Antonio Osorio Cruz
Mexico City
Summary
Dynamic Data Miner and Database Expert adept in SAS automation, diverse programming languages, and database systems, with a strong statistical foundation. Proven track record in process optimization, team leadership, and cross-cultural collaboration. Skilled in reducing processing times and driving efficiency through automation. Effective communicator with a passion for data-driven decision-making and continuous innovation.
Overview
20
20
years of professional experience
Work History
SeniorData Consultant
TCS
08.2020 - 09.2023
- Spearheaded SAS automation initiatives, optimizing insurance data treatment processes and migrating Teradata DB processes to Snowflake for improved efficiency, resulting in a 30% reduction in processing time.
- Enhanced project management by updating rollout tracking for 500+ processes and managing over 50 scheduled processes, achieving significant runtime reductions for key operations, with an average decrease from 2 hours to just 5 minutes for 15 processes.
- Innovated text mining techniques to classify client complaint calls and developed automated macros for efficient data detection, classification, and cleansing, improving data accuracy by 25% and workflow effectiveness by 40%.
SPSS Analyst
Walmart de México
City Of Mexico
02.2022 - 09.2023
- Conducted statistical analysis on sales data resulting in a 15% increase in revenue within targeted product categories.
- Documented daily 4GL-Shell processes, resulting in a 30% reduction in errors and streamlining of operational workflows.
- Collaborated with 8 cross-functional teams to translate analytical insights into actionable strategies, contributing to a 25% improvement in overall sales performance.
Senior Manager
Genpact
City Of Mexico
08.2019 - 07.2020
- Achieve a 30% increase in operational efficiency through the successful deployment of automation tools.
- Drive alignment between stakeholders, resulting in a 25% reduction in project delivery time and a 15% increase in client satisfaction.
- Provide strong leadership to cross-functional teams, fostering a collaborative environment and driving a 20% improvement in team productivity.
Director OfData Exploitation AndData Analysis
(Comisión Reguladora de Energía (Mexican Government
City Of Mexico
10.2017 - 12.2018
- Lead the daily operations related to volumes and oil prices data management, ensuring 99.9% accuracy, reliability, and timeliness of data processing.
- Manage and oversee the development, maintenance, and optimization of web services for the SIRETRAC System, ensuring 100% uptime and seamless functionality.
- Design, implement, and maintain stored procedures, triggers, and tables in SQL Server databases to support data storage, retrieval, and manipulation efficiently, achieving a 30% increase in database performance.
Data Miner
PROSA
City Of Mexico
08.2016 - 10.2017
- Authored comprehensive documentation covering management processes for MasterCard's ETL systems, consisting of 50+ detailed documents.
- Collaborated with 10+ cross-functional teams to identify key data sources and optimize data collection strategies, resulting in a 20% increase in data efficiency.
- Implemented data quality assurance measures, reducing data errors by 15% and enhancing data reliability.
Data Miner
TELCEL
City Of Mexico
08.2015 - 08.2016
- Developed and implemented forecasting models resulting in a 20% reduction in Telcel ATM downtime.
- Analyzed Telcel Customer Assistance Centers (CACs) indicators, leading to a 10% improvement in service efficiency.
- Designed and maintained Oracle data tables, enhancing operational efficiency by 25% in ATM fault management
Data Miner
PROSA
City Of Mexico
11.2013 - 08.2015
- Conducted association analysis leading to the identification of key client behavior patterns, contributing to a 10% improvement in card utilization.
Analyst
HSBC México
City Of Mexico
03.2011 - 02.2012
- Develop and implement translator tools (4GL to PL/SQL) in Java for data migration, achieving a 25% improvement in migration efficiency compared to previous methods.
- Conduct statistical analysis of financial products and derivatives using SPSS, resulting in a 20% reduction in analysis time while increasing data accuracy by 15%.
- Prepare regulatory reports utilizing SPSS for Banco de México, ensuring 100% compliance with regulatory requirements and standards, thereby mitigating risks associated with non-compliance.
Systems Engineer
BBVA
City Of Mexico
05.2007 - 12.2009
- Design and developed intuitive Java-based screens (Swing) for the BBVA brokerage house, resulting in a 50% increase in user satisfaction scores.
- Create and optimize complex queries, stored procedures, and user-defined functions in PL/SQL for Oracle and SQL Server environments, resulting in a 60% improvement in database query performance.
- Lead a team of developers to achieve a 60% reduction in Java codebase while maintaining or improving functionality, and enhancing system maintainability and scalability.
Informatics Manager
Médica Vial
City Of Mexico
04.2003 - 05.2007
- Managed SQL Server 2000 databases, overseeing a database size of approximately 500 GB.
- Produced over 500 statistical operational reports, tracking incidents, trends, and operational status on a monthly, weekly, and daily basis.
- Implemented automation processes, resulting in a 30% reduction in billing processing time and a 40% increase in efficiency in data capturing processes for insurance companies.
Education
Bachelor of Science - Mathematics
Instituto Politécnico Naciona
CDMX, Mexico City, México01-2002
Skills
- Data Mining and Database Exploitation
- Programming Languages: SAS, Python, R, C, PL/SQL, Shell Scripting
- Statistical Analysis
- Report Generation and Analysis
- Database Management
- Automation
- Excellent Communication
- Problem Resolution
- Team Development
- Tolerance to Stress and Frustration
- Quick Learner
- Analytical Thinking
- Action-Oriented
- Cross-Cultural Collaboration
TEACHING EXPERIENCE
- Instituto Tecnológico Superior (ITSOEH)/ JAN 2010 TO FEB 2011 Mixquiahuala, Hidalgo, México
● Programming, Operation research
- Instituto Tecnológico Latinoamericano (ITLA)/ Jan 2010 to Dec 2010 Tula, Hidalgo, México
● Programming, Discrete mathematics, Calculus
- TecMilenio/ Jan 2009 to Jun 2009 CDMX, City of Mexico
● Descriptive statistics, System development
- Escuela Superior de Física y Matemáticas – IPN/ Jan 2008 to Dec 2008 CDMX, City of Mexico
● Programming Instituto de Educación Media Superior delDF/ Feb 2008 to Nov 2009 CDMX, City of Mexico ● Mathematic
Timeline
SPSS Analyst
Walmart de México
02.2022 - 09.2023
SeniorData Consultant
TCS
08.2020 - 09.2023
Senior Manager
Genpact
08.2019 - 07.2020
Director OfData Exploitation AndData Analysis
(Comisión Reguladora de Energía (Mexican Government
10.2017 - 12.2018
Data Miner
PROSA
08.2016 - 10.2017
Data Miner
TELCEL
08.2015 - 08.2016
Data Miner
PROSA
11.2013 - 08.2015
Analyst
HSBC México
03.2011 - 02.2012
Systems Engineer
BBVA
05.2007 - 12.2009
Informatics Manager
Médica Vial
04.2003 - 05.2007
Bachelor of Science - Mathematics
Instituto Politécnico Naciona
Similar Profiles
MOHAMMAD SAJID ABBASMOHAMMAD SAJID ABBAS
System Engineer at TCSSystem Engineer at TCS
ALEEM ULLAH KHANALEEM ULLAH KHAN
MIM (MAJOR INCIDENT MANAGER) at TCSMIM (MAJOR INCIDENT MANAGER) at TCS
Rajashree RamakrishnanRajashree Ramakrishnan
Technical Lead at TCSTechnical Lead at TCS
PRAVEEN ADULAPURAMPRAVEEN ADULAPURAM
Salesforce Developer at TCSSalesforce Developer at TCS
MARIANA REYNA FABIANMARIANA REYNA FABIAN
Oceans and Fisheries Scientist at OCEANA MexicoOceans and Fisheries Scientist at OCEANA Mexico