Looking for a job

Evan Ngugi

@evanngugi

Message

Commercial analytics lead at PROTO Energy who cut reporting turnaround time by 70% with SQL and Power BI.

Kenya

Message

At PROTO Energy, I built and maintained centralized SQL and Power BI commercial data systems, integrating transactional data from ERP and distribution systems. I automated data pipelines and database indexing, reducing reporting turnaround time by 70%.

I also developed pricing benchmarks and commercial performance scorecards, and worked with sales and supply chain teams on stock health and replenishment. Before that, I managed retail operations across 32 outlets at Proto Energy and researched market expansion for SWVL.

Experience

Work history, roles, and key accomplishments

Current

Commercial Business Reporting Lead - Data & Analytics

Current

PROTO Energy

May 2021 - Present (5 years 5 months)

Built and maintained centralized SQL and Power BI commercial data systems, ensuring 100% data integrity. Identified database bottlenecks and implemented automated pipelines, reducing reporting turnaround time by 70%.

SQL Power BI Data Modeling DAX ETL Database Optimization Data Governance Excel Python Pricing Analytics Inventory Optimization Commercial Analytics

Field Coordinator - Retail Division

Proto Energy

Jul 2020 - May 2021 (10 months)

Managed retail trade operations and performance tracking across 32 outlets, conducting market research and competitor pricing analysis. Trained and managed 32 retail sales assistants, ensuring compliance and operational standards.

Retail Operations Market Research Competitive Analysis Team Management Compliance Inventory Control

Intern (ALx Project)

SWVL - Research & Strategy Consulting

Oct 2019 - Dec 2019 (2 months)

Conducted market research, competitor benchmarking, and pricing elasticity analysis for the Nairobi transit sector. Synthesized commuter data using statistical methods and Python to model route expansion and capacity utilization.

Market Research Competitor Benchmarking Pricing Analysis Python Statistical Analysis Data Synthesis

Education

Degrees, certifications, and relevant coursework

African Leadership University

ALx - Launchpad Program, Data and Decisions

2019 - 2020

Completed the ALx - Launchpad Program with core curriculum covering Data and Decisions, Python for Data Modeling, Communication for Impact, and Strategic Leadership.