Amy CHEPTOO
San Diego
Summary
Detail-oriented Economics and Statistics graduate seeking an Entry-Level Utility Rate Analyst role. Equipped with strong quantitative skills, experience in data analysis, and a passion for regulatory compliance, rate design, and financial modeling. Eager to contribute to SDG&E’s mission through analytical rigor and collaborative problem-solving.
In dynamic and fast-paced environment, developed skills in data analysis, problem-solving, and strategic thinking. Excel in interpreting complex data sets and delivering actionable insights to support business objectives. Seeking to transition into new field where these transferrable skills can drive meaningful impact and innovation.
Overview
2
2
years of professional experience
1
1
Certification
Work History
Data Analysis Intern
Kenya Power and Energy
06.2023 - 12.2023
- Compiled and cleaned 5,000+ rows of utility usage data in Excel, identifying trends for a citywide efficiency initiative.
- Collaborated with senior analysts to draft a white paper on rate structures for EV charging stations.
- Automated monthly reports using Python, reducing team workload by 6 hours/week.
Research Assistant
Moi University
01.2022 - 05.2023
- Supported PhD candidates in analyzing utility subsidy programs, utilizing STATA for statistical testing.
- Summarized 50+ regulatory documents for a study on regional rate disparities.
- Participated actively in regular meetings with fellow researchers to discuss project updates, challenges faced, and lessons learned during ongoing activities.
- Maintained open lines of communication with project leads and team members for effective collaboration on common goals.
Education
Bachelor of Science - Economics and Statistics
Moi University
Eldoret,KE12-2022
Skills
- Data Analysis: Advanced Excel , SQL, R, Python , Tableau
- Financial Modeling: Forecasting, cost recovery analysis, scenario modeling
- Research & Reporting: Technical writing, regulatory filings, data visualization
- Tools: SAS, SPSS, Power BI, Microsoft Office Suite
Certification
- Microsoft Excel Expert Certification (2023)
- Coursera: Financial Markets (Yale University, 2022)
Timeline
Data Analysis Intern
Kenya Power and Energy
06.2023 - 12.2023
Research Assistant
Moi University
01.2022 - 05.2023
Bachelor of Science - Economics and Statistics
Moi University
Similar Profiles
MARY WANJIRU KAMAUMARY WANJIRU KAMAU
ASSISTANT PROCUREMENT OFFICER at KENYA POWERASSISTANT PROCUREMENT OFFICER at KENYA POWER
Eng. Kate MukangulaEng. Kate Mukangula
Power System Design & Development Engineer at Kenya Power and Lighting Co. LTDPower System Design & Development Engineer at Kenya Power and Lighting Co. LTD
Ali DegowAli Degow
Electrical Engineering Intern at Kenya power lighting supplyElectrical Engineering Intern at Kenya power lighting supply
Ian PiferIan Pifer
Student Volunteer at TRIO Upward BoundStudent Volunteer at TRIO Upward Bound
Britney Munoz ArriazaBritney Munoz Arriaza
Youth Development Teacher at La Jolla ElementaryYouth Development Teacher at La Jolla Elementary