Roberto Andrade
Market Modeling Analyst at AFRY Management Consulting
ROBERTO ANDRADE
Houston, TX • LinkedIn • GitHub • Website
PROFESSIONAL EXPERIENCE
AFRY Management Consulting Houston, TX
Market Modeling Analyst July 2023 - Present
- Lead AFRY’s North American gas markets modeling with GPCM, collaborating with AFRY’s global energy model team for AFRY’s Annual Gas outlook and other external client projects.
- Perform fundamentals analysis for energy markets with AFRY’s production-cost modeling software, assessing the performance of power assets and delivering insights on market trends for the team’s CAISO outlook.
- Model Mexico power markets in AFRY’s quarterly outlook and bespoke projects, including valuation of thermal, renewable, and co-located assets.
- Run Monte Carlo simulations and time series forecasts with Python for demand and other key variables. Present findings to stakeholders in slide decks and leveraging Power BI.
- Developed solar generation/load-factor profiles from open APIs using Python and integrated them into asset valuation workflows; documented a replicable methodology now used across regions.
- Performed technical and financial due diligence on renewable and thermal asset transactions, identifying contractual and operational risks that informed valuation adjustments and negotiation strategy.
- Point of contact for the US office to the Digital Transformation team; continuously improving processes through automation using Python and SQL.
- Led North American team transition from Tableau to Power BI, adapting existing workbooks and conducting team workshops to train over 14 fellow team members.
- Train new hires and interns on SQL, database management and AFRY’s data organization.
- Analyzed market developments and provided strategic recommendations to clients, incorporating insights from new technologies and regulatory trends.
UNITED FEDERAL CREDIT UNION South Bend, IN
Data Science Intern January 2023 - May 2023
- Analyzed five years of customer feedback data using sentiment analysis and topic modeling to derive actionable insights.
- Developed interactive data visualizations with plotly to effectively communicate the findings from the analysis, providing stakeholders with actionable insights.
- Packaged reusable ETL and analysis scripts to accelerate repeat studies and enforce consistent data governance.
CORPORACION ANDINA DE FOMENTO (CAF) Mexico City, Mexico
Jr Consultant
Data Analyst and Data Engineer
September 2021 - August 2022
- Mapped business processes to improve accountability and standardize project outcomes.
- Improved delivery schedule to the multilateral bank’s non-profit customer to once per week from once every three weeks.
- Executed and optimized search algorithms to build the centralized database of matching entries. Enhanced runtime by 75% while losing only 3% of matches.
- Secured client buy-in for scalable, open-source analytics pilots by presenting data-backed cost and performance tradeoffs.
EDUCATION
UNIVERSITY OF NOTRE DAME Notre Dame, IN
Master of Science in Business Analytics May 2023
- Maiello-Bruchhaus Award for Analytics Excellence
INSTITUTO TECNOLOGICO AUTONOMO DE MEXICO Mexico City, Mexico
Bachelor of Science in Business Engineering May 2021
- Dissertation: Solar Energy Farms on Idle Land — Identified a $100M sales opportunity for solar projects using Python and open-source data.
Additional Information
Energy Markets Modeling: BID3 (Power markets), GPCM (North American gas markets).
Programming: Python (Pandas, NumPy, Scikit learn, matplotlib, seaborn, requests), R, Java, SQL, Advanced Excel.
Statistics: Exploratory Data Analysis, Descriptive and Inferential Statistics, probability, Hypothesis testing, ANOVA, A/B Testing, Linear Regression, Survival Analysis, Time Series Analysis.
Machine Learning: Supervised & Unsupervised Learning, Regression, Classification, Linear Programming.
Tools: SQL Server, Jupyter notebook, Power BI, Tableau, Git (version control).
Languages: Spanish (Native)
OPEN PROJECTS
Solar Energy Farms on idle Land Summary
- Leveraged Python and open-source data to identify a 100 million dollar sales-per-year opportunity for medium to large entrepreneurs who invest in certain solar farm projects
Predicting the next item in Instacart Summary
- Applied the apriori algorithm to gain insights into consumer behavior based on over three million Instacart transactions of data, to increase transactions and customer retention by improving app suggestions.
Will a Client Repay a Loan? Summary
- Used feature engineering, developed and tuned classification models to assess whether a customer would pay the bank back. Explained the financial benefits of implementing and continually tuning such models.
Text Summarization with Transformers Summary
- Scrapes the scripts of the first two seasons of The Mandalorian, and of The Book of Boba Fett to generate concise summaries of each episode using the Transformers T5 model.
LEADERSHIP & SERVICE
ALCANCE USL Mexico City, Mexico
Volunteer December 2020 - December 2021
- Taught Spanish weekly for two semesters to children from underserved neighborhoods around Mexico City; partnered in developing the curriculum and a system to help other volunteers stay on track.
- Arranged activities for elderly people during the Covid-19 lockdown; guided the volunteers to ensure the nursing home could fulfill the activities in a way that optimized the budget and everyone’s restrained schedules.
- Mentored the next cohort of volunteers through team-building activities and assigned tasks to help them acclimate to the organization’s management and properly meet volunteer expectations.