Olena

CONTACT
[відкрити контакти](див. вище в блоці «контактна інформація») Calls, WhatsApp

Telegram

[відкрити контакти](див. вище в блоці «контактна інформація»)
OLENA PETROVA
LinkedIn GitHub
BI DEVELOPER / DATA ANALYST
Lublin, Poland

Business and product data analyst strongly focused on business needs and data
HARD SKILLS modeling. Proficient in business data structuring and process definition. Used data
SQL , Python, Excel analysis methods to improve operations processes and project results.
Profound understanding of data-driven business and product development, as well
Data Modeling (ERD, Data Flow)
as of data analytics project processes.
Data Cleaning and Preprocessing Have experience in dataset import/export, data cleaning, exploratory data analysis,
Data Visualization and visualization. Worked with data related (but not limited) to resource
management, retail sales, SaaS product, and advertisement campaign analysis.
Descriptive Statistics
Seeking for opportunities to contribute to data-driven strategies and drive business
Requirements Analysis growth.
System Structure and Behavior Modeling
Business Process Modeling PROJECT EXPERIENCE
KPI, SLA, Product Metrics
Product Revenue Analytics (PowerBI)
Marketing Analytics IT school “GoIT” February, 2024
As a Business and Data Analyst, I delivered a 2-page analytical dashboard to
TOOLS evaluate factors affecting the product’s revenue, generated during 10 months.
To define metrics to show and to design the reports I studied the business context,
DBeaver, pgAdmin
clarified the data model, and specified the use cases of the Product team. That
Google BigQuery, allowed me to define parameters to calculate with SQL in the initial dataset,
Tableau, Power BI, Looker (Data) Studio applying CTE, Joins, and operations with dates.
The first page of the dashboard in PowerBI allows insights about user groups and
Jupyter Notebook, Google Colab
product’s versions performance. Revenue and ARPPU metrics ignore any filters,
Modeling Tools Users are grouped by age, LT, and LTV, it is possible to see the share of the
product’s versions. The second page shows the structure of MRR, it is possible to
SOFT SKILLS compare the Revenue and Churn Rate change with the dynamics of changes in User
count and Retention Rate.
Business needs focused Up to 20 custom measures using DAX.
This and other PowerBI projects on GitHub
Strong analytical thinking
System oriented Data Exploration and Visualization with Python
Goal and task commited IT school “GoIT” January, 2024

Able to work independently and in a team As a Data Analyst, I created visual reports of data relationships and dependencies.
The project was on Facebook advertisement results analysis.
My work included data preparation (SQL, Excel) exploratory analysis, and combining
EDUCATION multiple outputs into one plot (Python).
IT school “GoIT” It helps with the analysis of the effectiveness and efficiency of ads campaigns. The
challenge here was to visualize metrics with different scales at one graph, as well as
2023-2024
their annotation. It required customization of functions and subplots.
Data Analytics
The second task was to find correlations among ads metrics. The challenge was in
adding descriptive parameters to the correlation table and selecting parameters
Laba Academy
with the strongest and weakest correlation. That required not just technical skills,
2020
but also an understanding of analytical models.
Business Process Analyst
Another not-trivial task was to place subplots with different sizes, as well as to
American Society for Quality (ASQ) output tables in some of them.
2010 Project in GitHub
Certified Quality Improvement Associate
Product onboarding analysis (Tableau)
V. N. Karazin Kharkiv National University IT school “GoIT” December, 2023
1997-2002 As a Data Analyst, I created an interactive dashboard for user onboarding analysis.
Specialist’s degree in History The project allows evaluation effectiveness of conversion from registration to
payment.
LANGUAGES My task was: having the extract from the CRM system to calculate and to show
changes of registration numbers and conversion rates by month, as well as to see
Ukrainian - Native the average days to pass the funnel.
The challenge was in re-building the days-to-event graph based on a selected event -
English - Upper-Intermediate
LOD-expressions, parameters and actions were used.
Polish - Intermediate
This and other Tableau project can be found in my Tableau Public profile.
 CONTACT
[відкрити контакти](див. вище в блоці «контактна інформація») Calls, WhatsApp

Telegram

[відкрити контакти](див. вище в блоці «контактна інформація»)
OLENA PETROVA
LinkedIn GitHub
BI DEVELOPER / DATA ANALYST
Lublin, Poland

ACHIEVEMENTS WORK EXPERIENCE
Data Analyst / BI Developer 2023 - 2024
Analyzed business operations and reporting needs, and designed metrics
Completed 5 projects. Prepared Case structure.
Studies with description of all the steps. Prepared data models and data dictionary.
Prepared reference materials on Data Performed data import/export to/from a relational database and BI tools, data
Analytics and Data Cleansing/ Pre- cleansing and transformation using SQL, Python, DAX.
processing processes Calculated metrics and visualized with Power BI, Tableau, Looker Studio.
Obtained experience in analytics of Looked for dependencies and anomalies.
Product, Retail, Web marketing data Performed tasks on A/B testing preparation and results analysis

Business Development/ Product Manager
AdvanceIT (IT educational services, Ukraine) 2016 - 2023
Ensured 7 years of delivering educational Business analytics: defined and analyzed business development, sales
services on business development and effectiveness and efficiency metrics to control and improve business
software requirements analysis. profitability and capacity.
Engaged up to 15 brilliant instructors to Marketing analytics: based on data analysis, improved content marketing and
help more than 500 alumni Facebook advertising strategy and efforts.
Participants of the business development Product analytics: created a model for audience analysis by various parameters,
courses either solved their operational utilized elements of unit economics and product onboarding analysis.
issues during the course or identified root Customer(s) operations analysis: set up relations among processes, business
causes of problems and developed plans functions and resources, established measurement-based management system:
for improvement. KPI, SLA, process metrics, utilized elements of descriptive statistics.
Clients software systems analysis: supervised business needs identification,
setting up the process, system data, structure and behavior modeling, API
documentation.

Business Process Analyst
Improved effectiveness of Simcord, LLC (brokerage services, Ukraine) 2012 - 2015
communication between departments.
Accelerated efforts on work efficiency Analyzed and modeled the structure of the company, products, and services, as
improvement. well as of business communication processes.
Prevented investment in not necessary Modeled the business domain structure (logical data model), and established
tools. the terms/data dictionary to eliminate risks of redundancy and non-consistency
Helped to identify and overcome pitfalls of domain, organizational, and product data.
of growing business Designed an approach to personnel data storage to enable data collection.
Designed the documents and tasks workflows to enable visibility of statuses
and processing data collection.
Organized the product and project documentation storage and references.

Stimulated Top Management to goals and Business Process Analyst, Project Manager 2006 - 2012
KPI definition .
Increased ability of the company to Team International (IT oursourcing services)
satisfy the customer’s requests for Created operational dashboard prototype (Excel and SharePoint service), and
proposals and pass the operations due established the data collection process.
diligence process. Helped the project and functional management with the project and quality
Involved up to 50 people to active metrics collection and analysis.
participation in process improvement and Ensured successful preparation for the company appraisal for CMMI level 3
audit activities. (2008), the status maintenance and confirmation (2012).
Practitioners involved in process Utilized methods of descriptive statistics to analyze the stability and capability
improvement became extremely valuable of processes, as well as root cause analysis techniques for the process
and desired employees on the local improvement measures.
market and rapidly climbed the career Participated in the establishment of software requirement analysis and project
ladder. management functions.