ADOLFO PRIETO JR
Houston
Summary
Business Analyst with strong experience in retail and wholesale energy operations, advanced data analysis, and process optimization. Skilled in SQL, Power BI, and VBA with a proven ability to analyze large datasets, automate reporting, resolve billing discrepancies, and support cross‑functional teams in fast‑paced trading and operational environments. Recognized for improving data accuracy, enhancing workflows, and driving measurable financial impact. Adept at supporting system enhancements, conducting testing cycles, and collaborating with stakeholders across Operations, Sales, and Finance.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Retail Operations Analyst III
Constellation New Energy
Houston, Texas
09.2021 - Current
- Optimized Power BI reporting for 100,000+ retail power customers, resolving billing and transactional errors and improving data accuracy by 30%.
- Collaborated with Sales, Payment Operations, and Management to reduce aged receivables, clearing $150,000 of bad debt and unbilled within two months.
- Conducted thorough examination of extensive datasets for thousands of customers daily through multiple software tools to ensure accuracy in billing inputs.
- Documented issues and validated fixes to support ongoing system enhancements, partnering with IT during deployment cycles and regression testing.
- Executing 20+ Salesforce Cases daily to ensure accurate historical usage is validated for Pricing, Forecasting, and Sales team while reaching out to ERCOT account managers for each UDCs.
Data Analyst
alliantgroup
Houston, Texas
06.2020 - 12.2020
- Produced 40+ Quality Review Evaluations weekly, increasing client credit maximization by 35% through detailed wage and inventory analysis.
- Streamlined analysis of 10+ large datasets daily, improving tax credit application accuracy and boosting approval rates by 15%.
- Led a 5‑member Reviewer Team for enhancing quality control and increasing project accuracy by 30%.
- Developed repeatable data‑review processes that reduced turnaround time and improved consistency across engagements.
Distribution Management Intern
H-E-B
Houston, Texas
06.2019 - 08.2019
- Designed a 24/7 four‑shift warehouse schedule to optimize truck turnover and minimize downtime; presented to C‑suite leadership and received approval for implementation.
- Improved scheduling efficiency by analyzing 10,000+ weekly truck‑movement data points and identifying turnover patterns.
- Enhanced coordination across four warehouses, improving operational efficiency by 20% through conducting focus‑groups.
Education
BBA - Supply Chain Management and MIS
Baylor University
Waco, TX05-2020
Skills
SQL (complex queries, data validation)
Power BI (data modeling, automation, reporting)
Excel (advanced formulas, VBA, Power Query)
Data Transformation & Workflow Optimization
Billing & Transactional Reconciliation
Spanish (Conversational)
Certification
Data Analytics and Visualization - Rice University
Accomplishments
2024 Commercial Operations Trailblazer Award
Timeline
Retail Operations Analyst III
Constellation New Energy
09.2021 - Current
Data Analyst
alliantgroup
06.2020 - 12.2020
Distribution Management Intern
H-E-B
06.2019 - 08.2019
BBA - Supply Chain Management and MIS
Baylor University