Experience level:
More than 5 years
Education level:
Bachelor
Languages:
Russian: Native
English: B1
Serbian: A1
Marketing Analyst with 2 years experience.
I have moved company from Excel and PowerPoint reports to understandable and interactive dashboards in Power BI.
Proved that company doesn’t lost millions on rejected applications.
Opened insights at Clients Department’s work.
Reduced advertising budget expenses.
Proficient in Excel, CRM systems, Power BI, SQL (Postgre), client typology, Google Analytics, Yandex Metric.
I have moved the company to use Power BI except Excel in preparing analytical reports and dashboards;
Prepared functional dashboards which show insights of SEO, ADs, SMM, sales.
Found weakness in work of customer service department, helped to organize effective work with clients.
Have prepared 3 international market research.
Reduced time for preparing monthly reports by half due to automation of CRM reports;
Established a positive conversion of cooperation with the aggregator;
Advertising costs were reduced by disabling ineffective campaigns;
Automated most reports;
Make ABCXYZ client typology;
Work with CRM systems and end-to-end analytical systems
COMPLETED WORKS:
– After statistical analysis of A/B test results (taxi aggregator) recommend applying new payment mechanics only in 3 cities;
– Analysis online hours of drivers helped to find match/mismatch of demand and supply, find peak hours;
– unit economic calculation for online cinema (Retention, LT, LTR, Marginality).
– Profitability calculation of advertising campaign (unit economics, data visualization);
– Analysis A/B testing results of the advertising campaign (statistical analysis using Python.
ACHIEVEMENTS:
– Prepared 5 complex projects and graduating project using Excel, SQL, Python;
– All homework and graduation projects were performed according to the deadlines;
– Assistance in the development of educational material to other students.
PROFESSIONAL SKILLS:
– Knowledge of the theory and fundamentals of data analysis.
– Statistics for data analysis
– Knowledge of product metrics
– Data Collection, cleaning, aggregation by SQL (PostgreSQL);
– Python for Data analysis: Pandas, NumPy, Matplotlib, Seaborn, statistics;
– Cohort analysis;
– Create unit economy calculators in Excel;
– A/B testing;
– PowerBI;
– Participation in workshops, group works.
PROFESSIONAL TASKS:
– Managing the work of social service organizations;
– Preparing analytical and statistical reports;
– Working with the non-state sector of social services;
– Introduction of new forms and technologies of service;
– Supervision of department specialists.
ACHIEVEMENTS:
– Implemented a new system of service quality assessment, which provided competition and raised a quality of social services;
– Implemented 3 big projects;
– Organized support campaign for flood victim;
– Was a mentor for department colleagues;
– Reduced twice time of waiting social services.
Hard skills: Excel, Power BI, SQL (Postgre), CRM systems, Google Analytics, YandexMetric, end-to-end analytical systems
Soft skill: fast learning, able to work in stress situations, active, open minded, can work in a team and myself.