Doświadczenie w pracy:
Data Analyst combining strong 2-year commercial experience at large corporations and a deep 5+ years background in scientific analytical research. Expert in building automated Power BI dashboards and optimizing ETL pipelines using Python, SQL, and DAX, successfully reducing manual reporting times by up to 60%. Experienced in building sales funnel visualizations, deploying RFM segmentation and developing predictive forecasting models to drive data-driven executive decisions and optimize business metrics (Revenue, Margin, EBITDA).
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).
Umiejętności językowe:
Английский
Dodatkowo:
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.
GitHub: https://darina6688.github.io/#
Telegram: @darina_geo