Sahil Mittal
Faridabad
Summary
A dedicated and results-driven professional with extensive experience in SQL, data warehousing, PowerBI, and Tableau. Proven track record of leveraging advanced analytics tools and techniques to extract actionable insights, drive informed decision-making, and optimize business processes. Strong analytical mindset, coupled with exceptional problem-solving skills and a passion for data-driven innovation.
Overview
8
8
years of professional experience
Work History
Lead Data Analyst
Decision Tree Analytics
Gurgaon
10.2021 - Current
- Worked extensively on Postgres SQL and redshift to manage transformation process.
- Managed team to work on creating Tableau dashboards and creating more than 60+ dashboards.
- Built Data warehouse to integrate data from various data sources.
- Worked on Following domains for our clients to get overall insights.
- Inventory Analysis
- Sales Analysis
- Logistics and Transportation
- Operation Analysis
- Receivables and Payables
- Purchasing Analysis
BI Consultant
Fractal Analytics
Gurgaon
08.2020 - 09.2021
- Project - A CPG product study by conducting a customer survey
- Worked as a team leader to manage a team who worked on customer survey data to build end to end process from collecting data to building reports.
- Worked as BI consultant for one of our client in the CPG domain
- Worked on python scripts to import data and creating scripts for transforming raw files into structured data
- Worked on Python using Pandas and Numpy for a process automation and data cleanup.
- Worked on Python to create flat files which were then utilized for creating Power BI Report.
Assistant Manager Data Analytics
IFFCO Kisan Sanchar Ltd
Faridabad
01.2020 - 08.2020
- Project - Kisan Call Center (KCC), Zonal Consumer Helpline (ZCH), Agriculture transport helpline, Kisan Rural finance helpline
- Analyzing call abandon problems, quality analysis and deriving problem area in all the states
- Worked on Power BI to create interactive dashboard and visuals, creating data models, worked on power query and DAX for creating complex calculations.
- Managed to pull data through API for various CRM.
Senior Data Associate
Liquidhub Analytics
Gurgaon
10.2016 - 10.2018
- Analyzed financial data to extract insights, identify trends, and and build Power BI Dashboard.
- Strong command of SQL for querying, manipulating, and analyzing large datasets from financial databases, ensuring accuracy and efficiency in data retrieval and analysis.
- Worked on data warehousing concepts and technologies, including designing, building, and maintaining data warehouses to support financial analysis and reporting requirements.
Education
Post Graguation Diploma - Data Engineering
IIIT BANGLORE
BANGLORE03-2023
B. Tech -
University of Petroleum and Energy Studies
05.2016
12th CBSE -
D.A.V. Public School
01.2012
Skills
- PostgreSQL
- Power BI
- Data Warehousing
- Python
- MYSQL
- Exploratory Data Analysis
- Team Management
- Logical thinking
Timeline
Lead Data Analyst
Decision Tree Analytics
10.2021 - Current
BI Consultant
Fractal Analytics
08.2020 - 09.2021
Assistant Manager Data Analytics
IFFCO Kisan Sanchar Ltd
01.2020 - 08.2020
Senior Data Associate
Liquidhub Analytics
10.2016 - 10.2018
Post Graguation Diploma - Data Engineering
IIIT BANGLORE
B. Tech -
University of Petroleum and Energy Studies
12th CBSE -
D.A.V. Public School
Similar Profiles
Shubhanshu ManiShubhanshu Mani
Data Engineer at Decision Point AnalyticsData Engineer at Decision Point Analytics
Jithesh JanardhananJithesh Janardhanan
Analytics Consultant at Decision Point AnalyticsAnalytics Consultant at Decision Point Analytics
MARSHA CROSBYMARSHA CROSBY
Onsite Contract Support Program Manager at Chickasaw Nation Industries, Inc., and Chenega Decision SciencesOnsite Contract Support Program Manager at Chickasaw Nation Industries, Inc., and Chenega Decision Sciences