Guomin Peng
Katy
Summary
Results-driven Data Analyst with experience at CenterPoint Energy, specializing in ETL pipeline development and data governance. Proven track record in automating complex processes and delivering real-time insights through Tableau. Skilled in Python and SQL, with strong analytical abilities that enhance operational efficiency and customer satisfaction.
Overview
5
5
years of professional experience
Work History
Data Analyst (with Data Engineering Responsibilities)
CenterPoint Energy
04.2022 - Current
- Engineered and governed end-to-end data pipelines, managing the full lifecycle of critical data assets from development and testing to production migration for key reporting views (Customer Data, Gas/Electric Meter, Weather Data, Oil Spill).
- Spearheaded the architecture of an AI-powered Auditing Agent using the Agent Development Kit (ADK), automating a complex manual audit process. The solution integrates OCR, APIs, and web-based data gathering to consolidate audit reports, significantly reducing manual effort.
- Led the design and deployment of automated Tableau dashboards for executive stakeholders, replacing manual reporting to provide real-time insights into sales, business development, and customer engagement KPIs.
- Optimized data infrastructure by refining ETL jobs, developing processes for extracting embedded files, and establishing data governance standards, including naming conventions and descriptions for production tables.
- Analyzed large-scale call center data by building automated pipelines from Call Miner to GCP, identifying key customer intents and call drivers to inform strategies for enhancing operational efficiency and customer satisfaction.
Customer Service and Shipping System Specialist
Selleck Chemical
04.2021 - 12.2021
- Developed and maintained a robust shipping system using VBA and Python, and performed comprehensive data cleaning on shipping logs with Pandas to generate reports for leadership.
- Implemented data-driven optimization strategies based on KPI analysis that successfully streamlined shipping procedures and reduced operational costs.
Financial Data Analyst Intern
Weicepts LLC
06.2020 - 11.2020
- Built up a database by PostgreSQL for Fannie Mae mortgage dataset, explore numerical variables and categorical variables in dataset, understand their correlation between those variables.
- Analyzed roll rate analysis depending on the delinquency status of each loan.
- Preprocessed data, built up machine learning model and compared different machine learning model and conducted model validation in order to predict loan with delinquency status over 90 days.
Education
Data Science Track Certificate -
Springboard
05.2021
Master Engineering -
Purdue University
05.2020
Bachelors -
Shenzhen University
05.2011
Skills
- Python and R programming
- SQL databases
- BigQuery and PostgreSQL
- MySQL and MS SQL Server
- Oracle database management
- Deep learning techniques
- Large language models
- Generative AI applications
- Data manipulation with Pandas and NumPy
- ETL/ELT pipeline development
- Data modeling strategies
- Google Cloud Platform (GCP)
- Cloud functions deployment
- Version control with Git/GitHub
- Data visualization with Tableau, Power BI, and Looker
Affiliations
AI Auditing Agent | 2023 - Present
Objective: Automate the manual and time-intensive IN&OH Meter Data Audit.
Action: Architected and built an intelligent agent on the ADK platform that automatically parses subdivision plans using OCR, queries internal APIs for meter data, and uses targeted Google searches to gather external property data from public assessor websites. The agent calculates credits based on complex rate logic and consolidates all information into a master audit report.
Impact: Created a highly automated, scalable, and auditable system, significantly reducing manual workload and improving data integrity through robust exception handling and automated notifications for manual review.
Automated Business Development & Sales Dashboards | 2022 - Present
Objective: Replace manual data-pulls from SAP-CRM and Excel with a consolidated, real-time view of business performance.
Action: Designed, built, and automated a suite of Tableau dashboards to track year-to-date revenue against goals, project acquisition, new customer growth, and individual sales performance.
Impact: Empowered stakeholders with instant, visual access to critical business metrics, eliminating manual reporting errors and enabling agile strategic decision-making.
Objective: Automate the manual and time-intensive IN&OH Meter Data Audit.
Action: Architected and built an intelligent agent on the ADK platform that automatically parses subdivision plans using OCR, queries internal APIs for meter data, and uses targeted Google searches to gather external property data from public assessor websites. The agent calculates credits based on complex rate logic and consolidates all information into a master audit report.
Impact: Created a highly automated, scalable, and auditable system, significantly reducing manual workload and improving data integrity through robust exception handling and automated notifications for manual review.
Automated Business Development & Sales Dashboards | 2022 - Present
Objective: Replace manual data-pulls from SAP-CRM and Excel with a consolidated, real-time view of business performance.
Action: Designed, built, and automated a suite of Tableau dashboards to track year-to-date revenue against goals, project acquisition, new customer growth, and individual sales performance.
Impact: Empowered stakeholders with instant, visual access to critical business metrics, eliminating manual reporting errors and enabling agile strategic decision-making.
Timeline
Data Analyst (with Data Engineering Responsibilities)
CenterPoint Energy
04.2022 - Current
Customer Service and Shipping System Specialist
Selleck Chemical
04.2021 - 12.2021
Financial Data Analyst Intern
Weicepts LLC
06.2020 - 11.2020
Data Science Track Certificate -
Springboard
Master Engineering -
Purdue University
Bachelors -
Shenzhen University