Subham Joshi

Data Analyst with ~1.5 years of experience in SQL analytics, Python-based data pipelines, Power BI reporting, and statistical analysis across logistics and operations environments. MBA (Operations Management) - ICFAI Business School Mumbai, 2025; BCA 2022. Delivered KPI dashboards tracking 10+ metrics across 180K+ orders, built anomaly detection on 283K+ financial records, and engineered a 10-rule data validation engine achieving 100% accuracy.

Proven ability to translate complex datasets into actionable business insights for senior stakeholders. Proficient in Python (Pandas, NumPy, SciPy, Scikit-learn), SQL (CTEs, window functions, aggregations, 805K+ row datasets), Power BI (DAX, Power Query, data modelling), and MS Excel.

Google Advanced Data Analytics

Certified (7-of-7 Professional Certificate, May 2026) - 15 certifications total across analytics, Python, and SQL.

Data Analyst (Management Trainee Program) at Logistics Integrators Pvt. Ltd. (2025-03 – 2026-03)

• SQL analytics & reporting: Wrote advanced SQL (CTEs, window functions, aggregations) for threshold-based alerting, trend analysis, and anomaly detection on 180K+ order datasets - primary source for senior management operational reporting
• Python automation pipelines: Built ETL pipelines (Pandas, NumPy, openpyxl) reducing manual reporting effort; anomaly detection on 283,726 records using Z-score and IQR risk scoring, flagging 2,838 suspicious transactions with 0-100 risk scores
• Power BI dashboard ownership: Maintained dashboards tracking 10+ KPIs across freight operations with DAX measures and automated refresh - single source of truth for cross-team reporting
• Statistical analysis: Applied descriptive statistics, regression analysis, and trend modelling to freight operations data; surfaced actionable insights for process optimisation decisions
• Cross-functional coordination: Led RCA on performance anomalies partnering with 3-5 teams to validate conflicting data and deliver corrective-action reports to senior management

Operations Analyst (Intern) at Vrun Minerals Pvt. Ltd. (2024-02 – 2024-07)

• Built deviation-highlighting dashboards on inventory and sales trends; performed data accuracy checks and inventory reconciliation using Excel and Python (Pandas)
• Conducted business trend analysis and documented metric definitions for non-technical stakeholder self-service

MBA / PGPM in Operations Management – ICFAI Business School, Mumbai (2025)

Bachelor of Computer Applications in BCA – Shree Guru Ram Rai I.T.S., Dehradun (2022)