Doświadczenie w pracy:
Data Analyst | TechnoGroup, Sales Analysis Department Jul 2025 – May 2026
The market-leading manufacturer of high-tech climate control equipment.
• Automated key reports by migrating from Excel to Power BI, reducing manual data preparation time by 60%.
• Engineered ETL pipelines using Python, SQL, and DAX to consolidate data from different sources, reducing report generation time from 1 day to 1 hour.
• Created a sales funnel dashboard in Power BI and Python with YoY/MoM comparisons that identified bottlenecks and increased deal conversion rates.
• Developed predictive revenue forecasting models for deals and shipments, enabling top management to evaluate risks and adjust sales plans.
• Designed a KPI-driven bonus calculation model for the project team, increasing data transparency of performance metrics.
• Audited construction project data to detect and resolve anomalies, improving the reliability of management reporting.
• Provided top management with up-to-date metrics (Revenue, Margin, EBITDA) to support data-driven decisions.
Data Analyst | PEK, Commercial Department Jul 2024 – Jun 2025
An international transport and logistics holding company.
• Prepared data for analysis using SQL and OLAP cubes; optimized ETL processes (Python, SQL, MDX), saving 40% of preparation time.
• Built management reports and dashboards in Power BI; created data presentations for top management in PowerPoint.
• Developed a comprehensive sales dashboard based on 3 years of historical data to visualize sales dynamics, funnels, and sales sources, identifying problem stages and increasing conversion rates.
• Analyzed key business metrics (KPIs, Revenue, LTV, ROI) and customer metrics (acquisition, retention, churn rate), as well as tracked user movement between sales channels.
• Designed customer surveys and processed responses using Power Query and Python to extract actionable insights.
• Implemented RFM analysis, grouping customers into 12 distinct behavioral segments to personalize promotional offers.
• Evaluated marketing campaigns across 20,000 traffic routes to optimize the budget and stop ineffective campaigns before scaling.
Analyst / Research Associate | GPNTB (National Scientific & Technical Library) Jan 2016 – Jun 2024
Scientific and analytical activities
• Prepared and cleaned data for analysis, generated reports in Excel and PowerPoint, worked with internal databases and scientific citation indexes (Web of Science, Scopus) to deliver insights to executive management.
• Maintained data quality for researcher performance metrics and automated data preparation, significantly reducing manual workloads.
• Developed technical and methodological documentation for information-analytical systems.
• Proposed and implemented additional new metrics to evaluate researcher performance more objectively, with results published in research papers, and presented at conferences.
Publication: Discipline-specific bibliometric analysis: Quality and performance indexes.
Technical Consultant / Junior Analyst | CentorIS (software development) Apr 2013 – Sep 2015
Supported software development and implementation.
• Created custom reports in iReports/Oracle BI Publisher and configured forms using IntelliJ IDEA/JetBrains MPS.
• Conducted system testing, documented bugs, and managed task tracking within Jira and Confluence.
• Developed project documentation, user guides, and training materials to assist clients with product adoption.
• Delivered user training sessions and product presentations to corporate clients.
Edukacja:
Saint Petersburg State University, Institute of Earth Sciences,
Master of Science in Geology, 2011
Umiejętności zawodowe i inne:
Hard Skills: SQL (PostgreSQL, MS SQL Server), Python, Power BI, DAX, Tableau, Redash, MS Excel (Power Query, Power Pivot, OLAP), PowerPoint, Git, Jira, Confluence.
Business & Analytical Skills: Financial Metrics (Revenue, Margin, EBITDA), KPIs Tracking, RFM Segmentation, Data Auditing, Customer Surveys.
Soft Skills: Analytical Thinking, Process Optimization, Cross-Functional Collaboration, Presentation Skills.
Languages: English (B2), Russian (Native).
Dodatkowo:
CERTIFICATES
• Data Analyst Course | Karpov.courses | 2024
• Advanced Python Programming | IQ Option | 2023
GitHub: https://darina6688.github.io/#