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
- Develop and implement advanced power price forecasting models using BID3, Python, and R, resulting in accurate and reliable projections for grid conditions, power plant economics, and market dynamics.
- Conduct comprehensive analysis of market developments, including regulatory and environmental policies, emerging technologies, and economic factors, to assess their impact on the power grid and provide strategic recommendations to clients.
- Collaborate with cross-functional teams to enhance AFRY’s proprietary models and databases to drive innovation and improve the company’s market offerings.
UNITED FEDERAL CREDIT UNION South Bend, IN
Data Science Intern January 2023 - May 2023
- Conducted comprehensive analysis of customer reviews and feedback on 5 years of data, employing topic modeling and sentiment analysis techniques to extract valuable insights by gaining a deeper understanding of customer perceptions on various initiatives.
- Developed interactive data visualizations to effectively communicate the findings from the analysis, providing stakeholders with actionable insights.
- Ensured the scripts and methodologies used were highly reusable for future data analysis, facilitating streamlined processes and enabling ongoing data-driven decision-making.
CORPORACION ANDINA DE FOMENTO (CAF) Mexico City, Mexico
Jr Consultant
Data Analyst and Data Engineer
September 2021 - August 2022
- Collaborated in mapping business processes for the consulting teams’ projects to ensure accountability within the team and standardized 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.
- Organized and led meetings with the client to advocate why the project could and should be executed on a wider scale, as the new approach of the open-source program was a cost-saving alternative.
EDUCATION
UNIVERSITY OF NOTRE DAME Notre Dame, IN
Master of Science in Business Analytics May 2023
- Maiello-Bruchhaus Award for Analytics Excellence; MBA Consulting Club; Mendoza LatinAmerican Club
INSTITUTO TECNOLOGICO AUTONOMO DE MEXICO Mexico City, Mexico
Bachelor of Science in Business Engineering May 2021
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.
TECHNICAL SKILLS
Programming: Python (Scikit-learn; SciPy; NumPy; Simulation & Optimization; Web scraping); R; SQL; Java.
Statistics: Descriptive and frequentist inferential stats; Time Series Analysis; Survival Analysis.
Machine Learning: Regression; Regularization; Naive Bayes; SVM; CART; XGBoost; K-NN; Apriori; KMeans; Hierarchical Clustering; PCA; CNN; RNN; BERT; Transformers.
Tools: Linux Shell; Version control through Git; AWS.
Languages: Spanish (Native), French (Basic A2).
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.
INTERESTS
- Hispanic and Latin-American literature; Popular Science; Chess; Mechanical Watches.