Satvic Mittal

Senior Data Analyst @ESB

County Dublin, IE

Supported the data science team in understanding the business need for the customer churn model. Have been instrumental in data cleaning, data preparation, and model optimization by leveraging Python and SQL. The model increased customer retention by 30%, generating $5 million in revenue.• Performed comprehensive fraud analysis for the E-Cars business unit and developed a dashboard to visualise fraud patterns. Assisted the business in formulating remedial strategies, resulting in the recovery of over 2 millions in debts.• Created a dashboard to track key business KPIs like Customer Satisfaction & Understanding, Brand Awareness, Decarbonization of heat, and Customer Smart Metering, EBITDA, churn rate.• Created a custom dashboard on customer consumption patterns and product changes, which drives on historical data to help the business forecast demand and navigate decisions on new insight products and prices.• Worked on an end-to-end automation project to create a self-serving Ex Gratia (Sales) Report using a Power BI dashboard that reduced the workload from 5 days to real-time report generation. Displayed exceptional communication skills by facilitating collaboration between cross-functional teams.• Developed a solution to support the business during a crisis where customers struggled to top up their electric accounts. Created a dashboard to monitor affected customers and track progress in realtime. Created a multi-level data schema to collate data from multiple sources and utilized DAX and SQL for data transformation. • Built a dashboard to track Microgen customers. Added capability to track history in addition to Live data. Analyzed stakeholders’ need to develop a use case to track monthly gains and losses and track cumulative customer growth. • Set up reporting infrastructure for data quality and assurance to control data errors, improve data accuracy and maintain data security.

Imarticus Learning

Pro-Degree

UCD Michael Smurfit Graduate Business School

Master's degree

Ambedkar Institute of Advanced Communication Technologies and Research

Bachelor’s Degree