Data Analyst Portfolio - Shubham Patond

Hello, I'm Shubham Patond

Detail-oriented Data Analyst with nearly 3 years of experience in Healthcare and E-Commerce analytics. Proficient in Power BI, SQL, Excel, Python, and Google Analytics with a strong emphasis on dashboard creation, trend analysis, KPI tracking, and predictive modeling. Known for turning raw data into actionable insights and business strategy through clean visualizations and cross-functional collaboration.

Technical Skills

Power BI SQL (MySQL, Oracle) Python (pandas, numpy) Excel Tableau Google Analytics DAX AWS Snowflake Informatica Selenium (Web Automation) Postman ETL Data Cleaning Exploratory Data Analysis (EDA) Predictive Analytics Data Modeling

Key Projects

MAIDC – Mahaagromart E-commerce Analytics

Built executive dashboards for Mahaagromart.org tracking category-level sales, user engagement, and click-through funnel using Power BI, SQL, and advanced DAX. Influenced product strategy and marketing focus areas by identifying high-converting categories and visualizing seasonal performance.

MAIDC – Sales Growth Insights

Conducted YoY and MoM sales comparison, creating custom Power BI dashboards for leadership. Identified key growth drivers (state-specific campaigns, agent performance) behind 30% revenue increase in Q3 FY25.

Healthcare – Patient Data Analytics

Designed hospital data dashboard for patient admission trends, treatment outcomes, and demographics using Power BI and SQL. Collaborated with medical admin teams to deploy insights that shortened average patient processing time by 20%.

Professional Experience

Senior Assistant Manager (Data Analyst) – MAIDC Ltd. (Maharashtra Agro Industries Development Corporation, Govt. of Maharashtra)

Nov 2023 – Present | E-Commerce Division (Mahaagromart.com)

Designed Power BI dashboards to monitor marketplace performance: customer acquisition, traffic, orders, and category sales.
Built automated reporting pipelines integrating Excel, SQL queries, and retail data using Power BI, enhancing real-time sales forecasting.
Led Mahaagromart FY 2024–25 sales impact analysis; visualized quarter-over-quarter growth trends across top-performing SKUs and regions.
Identified a 24% YoY increase in revenue, helping strategize future promotions and product focus areas through geographic and cohort segmentation.
Managed Google Analytics, Facebook API campaigns, and logistics dashboards, improving campaign ROI and reducing delivery delays.
Collaborated with logistics, banking, and tech teams on API integrations and payment flow analysis.

Junior Data Analyst – Hudas Technologies, Pune

Jun 2022 – Oct 2023

Created interactive Power BI dashboards to monitor hospital KPIs: patient inflow, readmission rates, occupancy, and staff productivity.
Used SQL and Python (pandas) for cleaning hospital EMR datasets and automating data pulls.
Led predictive modeling to forecast patient readmission risk, reducing re-entry rates by 10% and improving staff allocation efficiency.
Presented metrics to non-technical stakeholders monthly, supporting data-driven decision-making in operational workflows.

Hello, I'm Shubham Patond

Technical Skills

Key Projects

MAIDC – Mahaagromart E-commerce Analytics

MAIDC – Sales Growth Insights

Healthcare – Patient Data Analytics

Professional Experience

Senior Assistant Manager (Data Analyst) – MAIDC Ltd. (Maharashtra Agro Industries Development Corporation, Govt. of Maharashtra)

Junior Data Analyst – Hudas Technologies, Pune

Awards

Skoch Honors Award

Education

B.E. in Computer Engineering

Certifications

Additional Information

Contact