Portfolio - Saurabh Dighe

1

Excel
Project

1

SQL
Project

1

PowerBI
Project

About

My journey into data began during my IoT internship, where I built a smart energy monitoring system that improved efficiency by 30% through structured workflows and time-series analysis. Since then, I’ve applied data analytics across healthcare, finance, and business. At Collective Liberty, I transformed 500K+ clinical records into actionable insights, enabling leadership to track KPIs, identify gaps, and prioritize high-impact interventions. At Excelerate, I analyzed 100K+ financial transactions, producing dashboards and reports that improved reporting efficiency by 20% and supported faster, informed decision-making. Through projects like Business Insights 360 and Enterprise SQL Analytics, I’ve designed dashboards and analytical pipelines that monitor KPIs across sales, finance, and operations, uncovering opportunities to improve performance and drive business impact. I am passionate about turning raw data into insights that inform strategic decisions and create measurable results.

Key

Skills

Python, R, SQL

ETL pipeline creation

data cleaning

Power BI

Tableau

Streamlit

Hypothesis testing

A/B testing

regression analysis

time series forecasting

Healthcare analytics

financial modeling

Advanced DAX functions

Excel

Data storytelling

executive presentation skills

Cross-functional collaboration

stakeholder management

My

Projects

Sales and Finance Analytics Project for AtliQ Hardware

Domain/Function: Sales and Finance

Conducted multi-year sales & finance analysis for AtliQ Hardware using Excel (Power Query, DAX). Identified $50M mid-tier growth potential, optimized division strategy, highlighted geographic margin gaps, and delivered actionable business insights.

End-to-End Business Analytics for Sales, Finance & Supply Chain

Domain/Function: Business Analytics (Sales, Finance & Supply Chain)

Built a business analytics solution for a simulated global manufacturer to analyze sales performance, profitability, and forecast accuracy, enabling better pricing, margin control, and data-driven decision-making using SQL.

Business Insights 360

Domain/Function: Brick, mortar and ecommerce

At AtliQ, data lived in silos across teams, slowing decisions. I unified sales, finance, and supply chain data into a 360° Power BI dashboard, giving leaders real-time visibility into profitability and demand, driving faster decisions and ~10% projected revenue growth.

My

Experience

Data Analyst Intern – Clinical Data Analysis
Collective Liberty, Washington, DC
Processed and validated over 500K patient and case records using Python and SQL, improving data accuracy and creating reliable datasets for healthcare and victim support analysis
Designed and implemented structured ETL workflows to organize multi-source healthcare and case management data, enabling consistent reporting and better service planning.
Evaluated and interpreted health indicators and service utilization trends to identify care gaps, helping teams make timely and informed decisions for victim assistance programs.
Developed and presented Tableau dashboards to track case progress, health outcomes, and key operational metrics, enabling leadership to prioritize high-risk cases and allocate resources efficiently.
Collaborated and communicated with program managers and healthcare coordinators to gather requirements, define metrics, and deliver insights that improved program effectiveness and community impact.
Data Analyst Associate Intern – Financial Analytics
Excelerate, Maharashtra, India
Reviewed and cross-checked over 100K financial transactions using Python, Excel, and SQL to ensure regulatory reporting accuracy and reinforce internal controls and compliance standards.
Constructed audit-ready financial datasets for balance sheet and income statement reporting through transformations in Python and Excel, improving reporting timeliness by 20% overall.
Executed detailed reconciliations and variance analysis across general ledger and transactional data, ensuring completeness, consistency, and accuracy for financial and regulatory submissions and audits.
Designed Power BI dashboards to track risk exposure, transaction trends, and reporting exceptions, supporting financial statement review and management decision-making for senior leadership.
IoT & Data Engineering Intern – Data Analysis
K.B.T.College of Engineering, Maharashtra, India
Collected, cleaned, and processed real-time sensor data for smart energy monitoring systems, ensuring high-quality datasets for analysis and enabling accurate trend detection.
Performed time-series analysis and visualized results using Python and Excel, providing actionable recommendations that improved simulated energy efficiency by 30% and supported replication of experiments across classrooms and households.