Alejandro Chavez Email & Phone Number

Machine Learning & GenAI• Deployed Daily Sales Dataset explanations + Q&A using Large Language Models in Databricks.• Voice synthesis & audio cloning using Coqui Text-to-Speech to convert dataset explanations into audio.• Sales forecast to the Daily Sales dataset using regression models to improve summaries.• Meeting Transcriptions & Summarization + Q&A using Speech-to-Text and Large Language Models.• Document / Text search and summarization using Embedding models and LLMs.• Slow & Fast Inventory Classification in Aggregates Sector deployed in Snowflake.• Customer Risk Classification in SCAC deployed in SAP Hana.Process Automation• Daily Cost & Expenses Dashboard using Tableau and Visual Basic Scripts + SQL procedures.• Daily Travel Expenses & Audit Dashboard using APIs and SQL procedures.• Online repository for all existing dashboards and reports in Cemex USA.• Automatic & dynamic e-mails for multiple Cemex USA activities.Weekly deliverables:• Month-end Accounts Payable reports and presentations for Planning and P2P• SQL Database and PowerBI / Tableau Dashboard maintenance• Weekly Bank Recon reports and Early Releases• AI Training & LaboratoriesService Delivery Award – 2021 Business Service Organization Annual Meeting

Monterrey Area, Mexico

Projects: Daily OPEX Dashboard, Asset Management Dashboard, Travel Expenses• Development of new processes and reports for the Financial Services area, as well as developing and monitoring Tableau dashboards.• Creating automatic data extractions from SAP, including data polishing, re-structuring and importing into SQL via daily / monthly automatic tasks and scripts.• Optimized existing Tableau dashboards + added functionality for end users.

Monterrey Area, Mexico

CEMEX Projects: Controllership Framework & Aggregates Global Network Reports• Consolidation, reports and presentations for the 2018 Budget in Aggregates, automated consolidation files for monthly reports with Global Network leaders.• Improved and updated 5 different Tableau dashboards for Sales and Inventory in the Global Network for Cemex Aggregates.• Created a platform using Tableau to consult the internal framework controls of Cemex.• Monthly presentations of main KPIs in the Global Network, and supported the Operational Excellence team with Tableau dashboards, documents and presentations for the Cemex 2017 Global Workshop.

Projects: Aislacon, ITESM, Metalsa, Intelexion• Process mapping in all of the involved areas in the commercial process, with the purpose of diagnosing their current operations, finding areas of opportunity and implementing a To-Be process with better practices, synergies and KPIs with Salesforce or Microsoft Dynamics.• Designed a quoting tool in Excel for Intelexion, in order to capture the necessary KPIs of their existing projects and create automatic reports to visualize the revenue and critical KPIs of each project.• Observation studies with key members of each department to map their As-Is process in high level of detail. Delivered documents with better practices and fixed areas of opportunity.

Monterrey Area, Mexico

Projects: Jomar Refaccionarias, Primero Seguros, Axtel, Aba Seguros• Diagnosed the current database at Primero Seguros and designed dashboards with Tableau to visualize the performance of their key products and find strategies to increase sales for the next period.• Held meetings with the sales team at Jomar, presenting the weekly progress of the team and helping them increase their sales and margins.• Presented weekly reports of their current inventory, stock-out units and sales team performance.• Used Tableau to create a self-updating customer satisfaction report for Axtel. This allowed us to create a 50 page report instantly once we received the results of the next trimester.• Insurance policy market research for ABA Seguros to find the newest products of their competition.• Projected the impact and rising competition of energy companies after the Energy Reform was implemented in Mexico

Monterrey Area, Mexico

• Diagnosed the current database structure of the company and polished the information available for statistical analysis. • Automated dashboards with Tableau for weekly sales performance reports

Monterrey Area, Mexico

• Repair and assembly of old computers and hardware for company use.• Diagnosis, maintenance and repair of computers and laptops on the site.• Technical assistance to other departments.

Boulder, Colorado

• Helped in the instruction of a programming summer course.• Taught the basics of animation and programming using Java and Flash.• Participated in review meetings to improve the teaching material.

Monterrey Area, Mexico

• Monitor and analyze the air quality in a decommissioned lamp plant, measuring the levels of mercury and lead and marking the locations that need to be cleaned.• Created reports of the contaminated areas and the levels of mercury and lead present.• Translated an agreement contract from Spanish to English