- Engineered a scalable ETL data pipeline for Origin’s new community battery product, handling thousands of customer records daily within AWS redshift. Implemented with,SQL, Python to structure and optimize data ingestion, prioritizing scalability andaccuracy as the product grows 20% each month.
‍
- Set up pipeline monitoring with automated checks using soda pipeline testing to ensure data reliability and consistency, catching and reducing errors effectively

- Developed end-to-end data pipelines to support referral programs, billing rebate calculations based on energy import/export usage, and lead eligibility processing fromFormstack. Utilized Python scripts to ensure reliable and automated data integration across systems.

- Built and maintained more than 24 data reports for business stakeholders across Finance/ Operations/Regulatory department, using SQL within a complex RDBS ecosystem and Tableau/Excel dashboards to visualize the data, enabling faster and more accurate decision making
‍

- Developed an internal web app as a full stack developer, providing internal teams amore efficient way of viewing and capturing and manipulating sustainability data, using Python,Flask, SQL, Javascript, HTML & CSS, API integration, saving stakeholder hours of manual work per day, increasing operational efficiency by 55%.

- Engineered an ETL pipeline to train a model to accurately pick up if a customer is onlife support using call transcript data, increasing our compliance with regulations inthe energy industry, using AWS Sagemaker, Python.
‍
- Implemented CI/CD & unit testing, reducing deployment errors by 30% and improving release cycles