Kapil Negi

Lead Engineer

Tata Power Western Odisha Distribution Limited•  September 2021 - Present

Developed Interactive dashboard using Power BI for real time monitoring. Analyzed the billing and collection trends and helped in improving the collection activity by 30%. Performed data cleaning and extraction using SQL and Power BI for further analysis to find out the defaulters. Suggested business improvement strategies/solution on basis of analysis and insights. Reduced the the report preparation time using Advance Excel tools like Macros, Pivot, etc. and Power BI tool. Prepared reports and Dashboard and shared them with team members for better collaboration and outcome.

EXECUTIVE ENGINEER

Torrent Power Limited•  July 2018 - August 2021

Analyzed the complaint data of more then 3 lac consumers through visualization and shared the results with senior management for reduction in complaints. Been the part of the team that helped in reduction of the complaint resolution time (from 4 hours to 2 hours) and proper team utilization using SQL and Excel. Prepared team performance report on weekly basis to overcome the shortcomings. Prepared interactive Dashboards using slicers, time-liners and pivot table in Microsoft Excel.

ABES Engineering College

Electrical and Electronics Engineering, B.Tech•  August 2014 - June 2018

Passed B.Tech(Hons.) with 76.4%.

St. Joseph’s Academy

Science, Higher Senior Secondary School•  May 2013 - June 2014

Percentage :- 83%

Fatima Convent School

Science, Senior Secondary School•  May 2011 - June 2012

Percentage :- 79%