Sergio Gabriel Del Villar Alvarez Email & Phone Number

Mexico City, Mexico

Partner with regional and local FP&A colleagues to develop and implement reporting solutions that cost effectively minimizes manual processes to support and improve upon existing automated report delivery for month-end, quarterly forecast, and budget content along with preparation of quarterly Operations Review decks, and annual Budget Presentation decks, etc. in a scalable manner that provides capacity to FP&A.-Supported multiple VBA projects (new and legacy) across OpCos within MMC-VBA development along Oracle Hyperion Planning API to support reporting-Python and Excel coding to standardise global ETL transformation processes, developing solution to sustain the process involving but not limited packages like numpy, pandas, xlwings, requests, json, selenium (to reverse engineer solutions that did not provide a proper API) . Used HTML and JS to provide 3rd parties without python access to be able to run these processes as well.-Utilized AI technologies, including the ChatGPT API and LLM/LMM models to optimize processes, accelerate code development, streamline debugging, UI interface and enhance algorithm design.-Fixed Anaplan 3rd party Python API to make it work for our business case (https://github.com/sgdva/anaplan-api)

Mexico City Area, Mexico

Implementation and management related to information technology solutions using office applications as requested by CitiBanamex financial institution.- Defined control points in business processes to standardize work flow.- Coded VBA solutions to upgrade weekly/monthly reports to be delivered once a day instead, this helped to identify action plans faster than the previous methodology. - Used VBA to improve Access SQL Queries and enhance further analysis, with this hourly deliveries were changed to minute ones.- Managed SharePoint to enhance data quality and feedback on its management. Business decisions were built on with a better scope and accuracy.

Toluca Area, Mexico

Provided team coordination to drive adequate changes led by General Motors management.- Updated VBA internal coding to improve reliability and error proof on the execution.

Mexico City Area, Mexico

Drive changes for Learning and development in the Ford Credit Latin America region- International project management for VBA coding solution to improve the communication flow among associates from Argentina, Brazil and Venezuela; it was awarded with the July "Excellence Award" by Ford Credit.- Administrator for Latin America Sharepoint: including all technical support for all tasks assigned for the region.- Performed multimedia projects in Adobe suit to support presentations and resources in multiple conversation channels.

Toluca Area, Mexico

Provided team coordination to drive adequate changes led by General Motors management.- Coordination and testing approval for worldwide Excel Macro implementation within General Motors branches in order to improve audit process and error typing prevention, reducing an average working time from 1 month to 2 hours. - Obtained Release Analyst certification (freshman level) by courses led by General Motors.- Management and implementation in different Excel Macro solution projects among different areas such as warehouse, supervisor management and software departments aligned with black belt and DFSS methodology to improve process bottle necks and communication blockers.- Performed updates in global database with private software

Toluca Area, Mexico

Provided team coordination to drive adequate changes led by General Motors management.- Excel macro project management that was awarded with the "2015 Transformers GM Mexico Award" for improving decision analysis towards automotive parts in the design stage which was approved by the global council with associates from US, India, China and Europe divisions.- Designed and coded macro framework -including User Defined Formulas(UDF), XLL programming and related- to keep standardized work and metrics in multiple projects, improving speed times from hours to minutes for calculations (time saved estimated sometimes exceeds calculations, it may vary hours/days to minutes). Improvement tools built to audit past data released in system as well.- Organized multi disciplinary team work development in order to perform the best streamlined information flow among departments (and within them) for the design stage in the automotive parts.- Performed updates in private software as a result of the effectiveness in the streamlined information flow to keep the global data base organized.

Toluca Area, Mexico

Provided project lifecycle leadership to develop reliable products as specified with end consumer interaction. - Managed and gained approval for 5 projects (out of 5), adding 25 products to manufacturing lines.- Coordinated personnel and suppliers to achieve the lead time for projects by identifying and solving roadblocks including communication problems, requirement creep and user needs.- Performed calculations and system entries for SAP data for the new and existing products -including the next modules: Material Management (MM); Create Routing (CA); Create Bill of Materials (CS); Create Work Center (CR); Enter Storage Locations Collectively (MMSC); Customer-Material Info Records (VD); Stock Overview (MMBE)-.

Toluca Area, Mexico

Trainee on manufacturing, developing software solutions and implementations on the production line that helped the workers to keep track of the data. It was used for post analysis and studies to improve the lean manufacturing on the area.Summary:Time-motion studies for production lines.Documentation on Talk Time and OEE problems.18% Improvement efficiency on line process by taking "foreign elements" out.5'S Implementation as required by ISO 14001.Excel Macros coding to improve data analysis.SMED system design for tool selection in printing process.

Diploma Of Business Administration, Finance, 3.4 Gpa

Activities and Societies: - Dean's Honour Roll Fall 2017 - Semi finalist in The Great Canadian Sales CompetitionThe first year of NAIT's.

Engineer'S Degree, Industrial Engineering, 86/100

Activities and Societies: Play-actingAnalyze, design and manage productive systems, from the resource suppliance up to the deliver.

Education record