Gerardo Antonio Ruiz De La Garza Email & Phone Number

Mexico City, Mexico

Guadalajara, Jalisco, Mexico

Mexico City, Mexico

* Oversaw a team of developers responsible for establishing and maintaining seamless connections between an Azure data lake and various data sources. Notably, we achieved zero internal disconnection incidents and zero escalated incidents from third parties.* Guided a team in designing robust pipelines and efficient ETL (Extract, Transform, Load) processes tailored to meet our business partners’ requirements using Azure Databricks and PySpark. Our execution remained remarkably close to the planned timeline, with only a -5% deviation.* Played a key role in optimizing data models, resulting in loading time reductions of over 90%. This efficiency significantly improved data consumption across the organization.* Played a key role in optimizing data models, resulting in loading time reductions of over 90%. This efficiency significantly improved data consumption across the organization.* Collaborated on developing robust processes and mechanisms to ensure data availability, maintain high quality, and uphold data integrity.* Worked closely on defining and implementing standardized nomenclature rules for the data lake. As a result, we significantly reduced instances of misnamed files and eliminated problematic file types by 80%.* Thoroughly validated model results with our business partners, ensuring alignment with expectations. Remarkably, we encountered zero instances of deviation attributable to the ETL process.

Mexico City, Mexico

* Championed the creation and upkeep of critical documentation, including Playbooks, Runbooks, Monitoring guides, Health Checks, and Knowledge Articles. Our meticulous approach led to compliance levels consistently exceeding 90%.* Revolutionized change management processes, ensuring rigorous post-change validations. We achieved a remarkable shift—from a mere 10% review rate before my tenure to a flawless 100% review of production environment changes.* Led a team in Python and PySpark code reviews prior to deployment to mitigate risks and detect opportunities for improvement.* Proactively conducted capacity analyses, providing advance notice of upgrade requirements with a foresight window of over 6 months. Our readiness efforts significantly improved compliance by 80%.* Led successful root cause analyses for incidents, pinpointing 100% of the underlying causes. Our proposed fixes drove continuous improvement.* Guided three critical Service continuity test exercises, identifying valuable opportunities to enhance both continuity and compliance with industry best practices.* Steered risk assessments and process maturity initiatives, resulting in compliance growth exceeding 90%. Our proactive approach fortified our operations.* Facilitated service level reviews with development teams, ensuring adherence to agreed-upon standards. Our commitment extended to a warranty period of either 3 months or 3 process executions, whichever was longer.* Drove the establishment of a robust known error database, transitioning from zero documented issues to identifying and documenting over 20 critical errors. This proactive approach streamlined troubleshooting.* Collaborated on identifying mission-critical applications related to the Banamex sale, compiling a comprehensive list for replication planning.

Mexico City, Mexico

* Pioneered the establishment of our Support team, meticulously designing and implementing its core directives and an efficient ticket sorting system.* Skillfully resolved customer tickets, frequently necessitating substantial modifications to the systems they relied upon. Our commitment to swift resolution significantly improved user satisfaction.* Strategically redefined systems based on insights gleaned from our support system, reducing the number of tickets from 300 per week to 30 per week. * Adeptly translated customer requirements into actionable insights for our Project teams.* Actively supported and coached our Project team members, with a particular focus on Python backend development and database design. My goal was to elevate our collective expertise.

Mexico City, Mexico

* Took charge of creating a document management solution in Python specifically tailored for the postdegree department, organizing, storing, and retrieving PDF files efficiently, improving document tracking.* Spearheaded the development of the CGCI informative website, leveraging Azure Databricks and PySpark for analytics.

Mexico City, Mexico

* Lead a team to develop the hardware, firmware in arduino language and software in Python of a biotechnology device, achieving a precision of ~0.5°C with low cost parts against the goal of ~1°C.

Master'S Degree, Analytics And Business Intelligence, In Progress

Administración De Tecnologías De Información, Computer/Information Technology Administration And Management, Bachelor

Bachelor Of Computer Sciences, Computer Science, Bachelor