Data Analytics Portfolio

Firdavs Davronov | LinkedIn | davronof08@gmail.com

About Me

Recent Operations Management & Analytics graduate from Baruch College with hands-on experience in procurement, inventory management, and data-driven process optimization. Skilled in Python, SQL, Excel, and Power BI.

Core Competencies:

• Supply Chain Analytics
• Demand Forecasting & Statistical Modeling
• Procurement Operations & Cost Analysis
• Data Visualization & Dashboard Development
• Process Automation with Python

Featured Projects

📊 1. Demand Forecasting Method Comparison

Tools: Excel, Statistical Analysis | Date: Fall 2023

Evaluated 10 forecasting methods on 24 months of sales data to identify the optimal approach for inventory planning.

Key Results:

• Identified Holt-Winter's Additive method with 10.68% MAPE (50% improvement over simple methods)
• Potential $2.1M cost reduction through improved forecast accuracy
• Comprehensive comparison of MAD, MSE, and MAPE metrics across all methods

Skills: Time series analysis, statistical modeling, error metric evaluation, business recommendations

→ View Full Analysis

---

🔧 [2. Procurement Dashboard] (In Development)

Tools: Power BI / Excel | Status: Planning Phase

Interactive dashboard tracking vendor performance, spend analysis, and pricing compliance across multiple branches.

Planned Features:

• Real-time vendor performance metrics
• Spend analysis by category and branch
• Price variance tracking
• On-time delivery trends

---

🐍 [3. Python Automation Tools] (Planned)

Tools: Python (Pandas, NumPy) | Status: Upcoming

Data validation and automation scripts for procurement operations.

Planned Capabilities:

• Invoice data validation
• Duplicate detection
• Data quality reporting
• Automated reconciliation

---

Technical Skills

Analytics & Visualization: Power BI, Tableau, Advanced Excel (PivotTables, Power Query, VBA)

Programming: Python (Pandas, NumPy, Matplotlib), SQL

Statistical Methods: Regression Analysis, Time Series Forecasting, Holt-Winter's, Moving Averages

Tools: MS Access, Git/GitHub

Certifications

• IBM Data Analyst Specialization (Coursera, 2026)
• Python 3 Programming Specialization (Coursera, 2026)
• Data Analyst Toolbox: Advanced Excel, Power BI, Python (Udemy, 2025)

Contact

• 📧 Email: davronof08@gmail.com
• 💼 LinkedIn: linkedin.com/in/davronoff
• 📱 Phone: +1 (917) 891-3381
• 📍 Location: Brooklyn, NY

---

This portfolio showcases projects completed during coursework and professional development. All analyses and code are my original work.