MAYANK SHARMA

Data Analyst

Jaipur, Rajasthan, India 2+ yrs exp 85 · Excellent

About

Results-driven Data Analyst with a B.Tech in Electrical Engineering and 3+ years of field experience in power distribution and transmission. Completed 6-month professional Data Analytics training (Python, SQL, Power BI, Advanced Excel) at DUCAT Institute, Jaipur. Skilled at identifying patterns in operational data and translating insights into actionable business decisions.

Skills & Expertise (10)

SQL Advanced

8.0/10

Years Exp

Pandas Intermediate

7.5/10

Years Exp

NumPy Intermediate

7.5/10

Years Exp

Power BI Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

Advanced Excel Intermediate

7.0/10

Years Exp

Pivot Tables Intermediate

7.0/10

Years Exp

VLOOKUP Intermediate

6.5/10

Years Exp

Charts Intermediate

6.5/10

Years Exp

Work Experience

Management Trainee

CESC Ltd. (Calcutta Electric Supply Corporation)

Dec 2020 - Jun 2022

Analysed power loss data across distribution zones; identified high-loss feeders and theft-prone areas using field data. Reduced AT&C losses by 40% through targeted feeder-level interventions and consumer metering initiatives. Onboarded unmetered households onto the metered grid, directly expanding the billable consumer base. Prepared operational dashboards and progress reports tracking loss reduction KPIs for management review.

Graduate Engineer Trainee

Adani Power & Transmission Ltd.

Jun 2015 - Mar 2016

Monitored real-time power flow data to detect transmission bottlenecks and reduce line losses across HV corridors. Supported fault analysis and preventive maintenance scheduling, contributing to 100% uptime on assigned corridors.

Education

Professional Data Analytics Training - DUCAT Institute, Jaipur

2025 - 2026 · India

B.Tech — Electrical Engineering (Honours, 71%) - University College of Engineering (UCE), Kota

2011 - 2015 · India

Certifications

Intern

Jaipur Metro Rail Corporation · 2013

Completed an internship at Jaipur Metro Rail Corporation (JMRC), gaining practical exposure to metro rail electrical systems and maintenance operations. Assisted in understanding electrical infrastructure, safety procedures, and preventive maintenance practices. Developed strong analytical, problem-solving, and teamwork skills while working in a professional engineering environment.