![[Image of Aleksandr Dumchykov]](https://alexdumchikov.github.io/Portfolio/Other/my_photo_without_bg.png)
Aleksandr Dumchykov
Business Intelligence Lead | Data Analyst Lead
Transforming complex data into actionable insights to drive strategic decisions and business growth. Experienced in leading BI teams, optimizing reporting processes, and implementing advanced analytical solutions that enhance operational efficiency and profitability.
Top Skills
Featured Projects
![[Sales Dashboard]](https://alexdumchikov.github.io/Portfolio/Dashboards/screenshot%20of%20dashboard.png)
Sales Dashboard on JavaScript
Sales Dashboard on JavaScript
Developed reports visualizing performance metrics and sales trends, providing valuable insights
Key Achievements:
- Key advantage: Highly customizable report.
- Reduced report generation time by 20%
- Enabled data-driven decisions through clear and easy-to-understand analytics
![[Geo Analytics Image]](https://www.carto-sig.com/assets/img/portfolio/isochrone.webp)
Geo Analytics
Geo Analytics
Performed spatial analysis to identify geographic patterns, enabling targeted interventions...
Key Achievements:
- Identified geographic drivers of targeted customer
- Developed predictive model with high accuracy
- Created interactive geographic visualization for sales patterns
![[Power_BI Image]](https://alexdumchikov.github.io/Portfolio/Power_BI/Power_BI_screenshot.JPG)
Power BI | Tableau
Power BI | Tableau
Interactive reports using leading BI platforms like Power BI and Tableau
Key Achievements:
- Leveraged pre-configured report templates to accelerate report development.
- Implemented security models to protect sensitive data within reports.
- Empowered users to make data-driven decisions by embedding actionable insights into their daily workflows.
![[Data Warehouse Image]](https://alexdumchikov.github.io/Portfolio/Project_SQL/SQL_screenshot.JPG)
SQL Reporting
SQL Reporting
Leveraged SQL for powerful data manipulation and analysis...
Key Achievements:
- Enabled efficient analysis and processing of large-scale datasets.
- Automated complex data extraction and reporting processes, enhancing operational efficiency.
- Provided timely and accurate data fundamental for strategic business intelligence and decision-making.
![[Predictive Analytics Image]](https://alexdumchikov.github.io/Portfolio/Python_Data_Analysis/Python_Analysis_screenshot.JPG)
Python Data Analysis
Python Data Analysis
Streamlined data cleaning, advanced analytics, and impactful visualization via Python...
Key Achievements:
- Performed data cleaning, handling 25% missing values and 15% outliers.
- Identified customer segmentation patterns.
- Automated data validation pipeline.
![[Statistics Image]](https://alexdumchikov.github.io/Portfolio/Statistics/AB_screenshot.png)
Statistics, A/B Testing
Statistics, A/B Testing
Applied statistics & A/B testing to validate impacts and optimize business performance....
Key Achievements:
- Enabled evidence-based decision making for business initiatives
- Quantified the true impact of product features or marketing campaigns.
- Reduced the risk of deploying ineffective changes.
Technical Skills
Database
Dashboards & Visualization
Data Analysis & Modeling
People Management
Machine Learning & Statistics
Emerging Technologies
Other Skills
Languages
English
Full professional proficiency (C1)
Russian
Native
Ukrainian
Native
Work Experience
Efficiency Improvement Lead
- Optimized Device Sellers Performance: Created a comprehensive model that improved sales strategies for device sellers, resulting in a 15% increase in sales performance.
- Improved Multi-Category Product Availability and Visibility: Utilized Machine Learning and Scoring models to enhance product availability and visibility across multiple categories, leading to a 18% increase in product visibility.
- Enhanced Experiential Touchpoints: Developed models that improved experiential touchpoints, resulting in a 10% increase in customer engagement and satisfaction.
- Implemented Visualization Solutions: Developed solutions for visualizing results on maps, providing clear and actionable insights that improved decision-making processes by 30%.
- Optimized SKU Assortment Planning: Developed a model for SKU assortment planning across all channels, ensuring balanced and efficient product distribution, leading to a 20% improvement in inventory turnover.