Acerca de Octavio
Manager with over 10 years of experience leading Business Intelligence and Data Science projects. Expert in ETL/ELT tool migrations (Pentaho, IBM DataStage, Dataiku), database optimization (MySQL, MSSQL, GCP BigQuery), and developing advanced Data Analysis, Data Profiling, and ML processes using Python. Extensive experience in creating interactive dashboards with tools like Power BI, Tableau, and SAP Analytics Cloud (SAC), integrating real-time analysis, planning, and predictive analytics capabilities to drive strategic decision-making.
Proficient in designing, maintaining, and automating scalable data infrastructures, skilled in languages such as Visual Basic, JavaScript, and Linux Shell, and in implementing solutions within Big Data environments (Hadoop, Spark, MongoDB). Committed to technological innovation, continuous process improvement, and the professional development of the teams I collaborate with.
My core professional skills include Adaptability & Agile Responsiveness, Strategic Analysis & Critical Thinking, Problem-Solving & Decision-Making, Communication & Negotiation, Leadership & Management Under Pressure, and Empathy & Collaboration.
Inglés
Bilingüe o nativo
Japonés
Nociones
Español
Bilingüe o nativo
Acepta trabajo presencial
Mexico City (hasta 50 km)
Experiencia
- Wal-Mart de México, SAB de CV Coord.Gerente de AdministraciónGRAN DISTRIBUCIÓNdiciembre de 2020 - noviembre de 2023 (2 años y 11 meses)Mexico City, MéxicoAs Gerente de Administración, I led the strategy and execution of key data and optimization initiatives within the Omni Strategy Center of Excellence (CoE). I was responsible for transforming and consolidating our data infrastructure to support strategic decision-making and improve operational efficiency.My main responsibilities and achievements include:I led the successful ETL/ELT tool migration from Alteryx to Dataiku, establishing an optimized workflow and a unified data platform for the entire operation.I designed and configured a project space in Google BigQuery with Gold, Silver, and Bronze schemas, substantially improving data classification and quality for strategic analysis.I proactively trained teams in the advanced use of Python, SQL BigQuery, and Dataiku, significantly elevating their technical capacity to implement effective data solutions.I optimized data handling processes, achieving a 40% reduction in processing times and improving overall team efficiency.
- Inova México (NAP LAB SA DE CV)BI LeaderIMPORTACIÓN & EXPORTACIÓNjulio de 2015 - diciembre de 2020 (5 años y 5 meses)Avenida Milho Híbrido, Fazenda Ataliba Leonel, SP, BrazilAs BI Leader, I was responsible for leading the Business Intelligence strategy and the integral management of databases. I drove process optimization, ensured data security, and strengthened the company's analytical capability to efficiently support commercial operations.My main responsibilities and achievements include:Orchestrated the integral database migration from MySQL 5 to MySQL 7, guaranteeing a smooth and uninterrupted service transition.Led the ETL migration in Inova México, transitioning from macro-based data loading to the successful implementation of Pentaho, significantly improving the efficiency and robustness of data processes.Assumed full responsibility for ensuring the uninterrupted data availability, implementing effective monitoring and troubleshooting strategies in MySQL databases.Directed the complete database backup process, implementing regular backup procedures via CronTab of Linux to guarantee data security and recovery.Developed and maintained robust ETL processes in the Pentaho platform for efficient data manipulation, and optimized complex SQL queries for strategic report generation.Collaborated with the development team on implementing efficient data models, ensuring consistency and integrity of data flows for new system functionalities.
- Pentafon Contact Center & CXSPAnalista de Base de DatosTELECOMUNICACIONESdiciembre de 2014 - julio de 2015 (7 meses)Mexico City, MéxicoAs a Database Analyst, I was responsible for the management and optimization of databases to support contact center operations and customer experience (CX) initiatives. My role focused on ensuring the integrity, availability, and performance of business-critical data.My responsibilities included:Optimized SQL queries for the generation of operational and management reports, improving the speed of access to key information.Ensured data integrity and consistency through regular maintenance and validation of information within the databases.Provided technical support to operational and analytical teams, resolving database-related incidents and facilitating access to necessary data.
Recomendaciones
Sé el primero en recomendar a Octavio
Ayuda a este freelance a destacar compartiendo tu experiencia.
Estos perfiles de freelance también coinciden con tus criterios
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Formación
- CapacitaciónWal-Mart de MéxicoCapacitación
- - Aprendizaje Instantáneo SCRUM Product Owner SAFe- - Scaled Agile FrameworkAprin- Aprendizaje Instantáneo SCRUM Product Owner SAFe- - Scaled Agile Framework