Олександр

Oleksandr Sitanskyi
BUSINESS ANALYST
[відкрити контакти](див. вище в блоці «контактна інформація») [відкрити контакти](див. вище в блоці «контактна інформація») Kyiv, Ukraine Telegram

LinkedIn GitHub

SUMMARY
Business analyst with 8+ years of experience in sales, team management and business processes. I can
collect document requirements from owners and users, describe and improve business processes,
write technical specifications for developers, test solutions before launch, write instructions and train
users. I have experience with CRM systems, creating tasks for the IT department through tickets,
building spreadsheets, reports and automation. I work with SQL, Python, Power BI, Tableau and Google
Sheets, and I am familiar with Atlassian tools. I am result-oriented, learn quickly, and I value working in a
socially responsible Ukrainian business.

SKILLS
Requirements Engineering — Functional & Non-Functional Requirements, User Stories & Acceptance
Criteria, Use Cases, Business Rules & Constraints
SDLC & Methodologies — Agile, Scrum, Kanban
Technical Skills — GitHub, REST/SOAP APIs, JSON vs XML, SQL & Relational Databases, Reading Code
Project Management Tools — Jira, Jira Service Management, Confluence, Backlog
Stakeholder & Product Strategy — Communication, Product Vision
Other Tools — AI Tools, Google Forms, Tableau, Power BI, BigQuery, Colaboratory, Spreadsheets
Languages — English (Intermediate) | Ukrainian (Native)

EXPERIENCE
Business Analyst / Data Analyst (freelance), e-commerce distribution 10/2024 – Present
•Analyzed the marketing funnel (leads – customers – repeat purchases,
average order value) and the work of sales managers; found low conversion
and no repeat sales.
Rebuilt the sales process: introduced communication scripts, upsell and
•

cross-sell. Result: customers started to come back, and the average order
value and the number of items per order grew.
Moved manual reporting to an automated system in Google Sheets;
•

designed table layouts, calculation logic and rules for stock replenishment
alerts.
At the owners' request, create widgets with key business metrics in real
•

time (Scriptable, JS, JSON, OS). This covered about 80% of ad hoc requests
without contacting an analyst.
Created KPI dashboards and tracking for sales, conversion, marketing,
•

employee performance and salary calculation; developed new logic for
calculating the sales team's incentives.
Made data entry easier for staff (drop-down lists, templates, formulas) to
•

reduce errors; wrote documentation for each table and process stage, so a
new person can start working without onboarding.
Described bugs of the company's own CRM for the IT department through
•

tickets: problem description, steps to reproduce, conditions, environment,
expected logic. Tested the CRM before it went live.
Prepared monthly and quarterly reports for owners; worked mostly with
•

owners and sales managers and clarified the goal of each request before
doing calculations.

PORTFOLIO
Insurance process mining (Process Mining, Tableau)
Analysis of the insurance claims handling process, finding bottlenecks and cycle time, comparing RPA
•

and manual handling, recommendations for process optimization

Humanitarian Analysis (Power BI, DAX, Power Query)
Data preparation and validation, interactive dashboard, recommendations for prioritization
•

Email Marketing & Customer Analytics (SQL, Looker Studio)
Analysis of email marketing performance

Sales & Marketing Performance Analysis (Python, Pandas)
Analysis of customers, revenue and marketing channels

Advanced A/B Testing Analysis (SQL, Python, Tableau)
Analysis of experiments, hypothesis testing.

PREVIOUS EXPERIENCE
Sales Manager - Team Lead 07/2016 – 02/2022
Worked with CRM, tracked KPIs and team performance, optimized sales
•

processes.
Introduced daily reporting: designed a report template for managers and
•

held discussions with team leads to adjust processes.
Delegated tasks to team leads and managers and controlled their
•

completion.
Initiative to change the sales funnel: instead of the "request – call" scheme, I
•

suggested a free webinar – a short three-day course – the main paid package

Senior Administrator 09/2015 – 07/2016
Introduced call handling with additional sales (upsell and cross-sell),
•

communication scripts and customer service standards. Result: the average
order value grew 4 times.
Introduced performance monitoring and a structured sales process.
•

Was responsible for purchasing, salaries, cash operations and compliance;
•

hired and trained the team.

EDUCATION
Specialist Degree in Management of Organizations, Polytechnic University 2010 – 2015

ADDITIONAL EDUCATION
Data Analyst course , Mate academy

Two-Day Sales Intensive , Bohdan Kurinnyi

IT Essentials: PC Hardware and Software , Cisco

ACHIEVEMENTS
Nike Run Club 5k
•

Prize winner at regional fire and rescue sport competitions (bronze, 100 m obstacle course; silver,
•

assault ladder)
District champion in track and field and team silver in the relay
•