Electrical Engineer Business Analytics

ATHARVA .S. DIWAN

312-***-**** *******.*****@*******.************.*** LinkedIn

EDUCATION

KELLOGG SCHOOL OF MANAGEMENT, NORTHWESTERN UNIVERSITY Chicago, IL Master’s in Management degree, Jun 2025

Coursework: Corporate Strategy, Business Analytics, Operations, Marketing, Financial Modelling, Retail Analytics & Pricing Case Study:

Led price optimization analysis of $850M revenue across 300M units and three retail chains, identifying that standard medium products at client drove 69% of sales, developed targeted pricing strategies projected to improve margins by 2-4%.

Analyzed Kraft's cheese pricing strategies using R and Excel to address margin pressures, leveraging elasticity models and scenario testing to recommend balanced price hikes increasing total retailer profit by 3.1%. PUNE UNIVERSITY, Bachelors in Engineering (Electrical Dept.) (GPA-3.57/4) Pune, India

Won State-Level Engineering Project Competition ‘22 among 43 participants for developing a Battery Management.

Winner of Group Discussion at Annual Technical Extravaganza 2019 on "Implementation of Government Policies" WORK EXPERIENCE

ECOMETRIC CONSULTING, LLP (HYBRID) Exton, PA

Energy Engineer I, Aug 2023- Aug 2024

Led strategic assessments of energy efficiency programs for 8 U.S. energy companies, optimizing cost structures and reducing operational inefficiencies, resulting in a 30% increase in profitability.

Conducted Technical Reference Manuals (TRM) based performance evaluations of downstream and midstream energy projects, ensuring compliance and maximizing incentive utilization also Reviewed and validated state-specific TRMs, enhancing accuracy for energy consumption evaluations for smooth client experience.

Developed quantitative forecasting models in Excel to analyse energy consumption trends, guiding investment decisions for utility clients.

Performed benchmarking surveys by analysing annual energy reports, uncovering cost-saving opportunities and shaping data-driven strategic recommendations for client.

Researched HVAC market adoption and supplier dynamics, leading to a refined pricing strategy for 8 major U.S. energy companies.

ENPRO CONSULTANT PVT. LTD Pune, India

Electrical Engineer, July 2022- Aug 2023

Collaborated with over 10 conglomerates on projects encompassing energy audits, with potential clients, including Bharat Forge, India Glycols, and SKF India.

Developed a quantitative energy-saving model using Python and Excel for a chemical plant, forecasting 13-15% potential savings during a pre-audit board presentation.

Analysed data by Air leak quantification test, eliminated 63% energy loss caused by air leakages from the low- pressure line, which saved almost INR 18 lakh ($20K) per year for the client.

Identified energy losses of about 8.71%; consulted the client to replace inefficient motors from selective utilities with new technology motors for less power usage; saved 1.10 Crore INR per annum ($100K/year) at a breakeven period of 3.5 years.

AVER ENGINEERING PVT. LTD Pune, India

Electrical Engineer (Intern), May 2021- Aug 2021

Led a capstone project of installing lightning arrestor in the heavy lightning-prone area covering 400 meters circumference of the client company, Following IEEE norms. LEADERSHIP AND ACTIVITIES

Led a team of 20 volunteers as Community Service Director, organized blood donation camp twice, collected more than 170 units of blood per camp.

Coordinator, Training and Placement Cell in college, mentoring students with their professional development like, resume drafting, interview prep, coordinating with recruiters and maintaining records (2 years). ADDITIONAL INFORMATION

CERTIFICATIONS – Management Consulting, Six Sigma (Yellow belt), Agile Project Management.

HARD SKILLS – Excel (VLOOKUP, Pivot table), PowerPoint, Power BI, Tableau, Python, SQL, Stata, R.

AI SKILLS Alteryx, Co-pilot, Claude, Perplexity, Air table, Zapier, Lang Chain, Llama Index RESEARCH (Co-Authored with PhD Candidate)

Research assistant: Conducted multiple GWO model trials to minimize water leakage and prevent formulation contamination. Paper 157 Research published “Computational analysis of GWO used for controlling water level in pharmaceutical Industries".

Contact this candidate