Curriculum Vitae

18+ Years of International Experience in Data Engineering & Product Management

Professional Experience

Product Owner – CARDESS.ENGAGE

MCON Group

πŸ“ Germany

Jan 2020 - Present Β· 6 years 1 month

full-time

Leading the CARDESS portfolio implementation for large and medium dealer groups in Germany, managing data science teams across multiple countries.

  • Led implementation and rollout of ENGAGE in 25 major automotive dealers with 50 locations across Germany
  • Generate ~300 leads per month in average per location by mining customer's own customer base
  • Designed data pipeline: SQL Server β†’ Python processing β†’ AWS S3 β†’ AWS Glue ETL β†’ Parquet format β†’ QuickSight/Athena visualization
  • Implemented ML prediction capabilities: Vehicle Residual Value (Non-Linear Regression), Customer Life Cycle (Regression), Damage Classification (Deep Neural Network)
  • Designed Product Catalog search using AWS Elastic Search with ~90,000 vehicle models
  • Lead assigned data science team (internal and external) across Germany, Morocco, China, Mexico
PythonAWS S3AWS GlueAWS LambdaAWS QuickSightAWS AthenaAWS Elastic SearchMachine LearningSQL ServerParquet

Associate Director – Business Intelligence Team

MCON Group

πŸ“ Beijing & Shanghai, China

Jan 2015 - Dec 2019 Β· 4 years 11 months

full-time

Architect and Technical Leader for CONNECT project fulfilling IFRS9 regulations for Volkswagen Finance China and Mexico, managing teams across 5 international offices.

  • Architected and led implementation of DWH landscapes for Volkswagen Finance China and Volkswagen Finance Mexico for IFRS9 compliance
  • Led team of 20 people across 5 offices: Beijing, Shanghai (China), Munich (Germany), Casablanca (Morocco), Puebla (Mexico)
  • Designed DWH architecture involving 10+ business areas with 60+ business objects and ~200 million transaction records
  • Implemented communication and handover methodology leveraging different time zones across offices
  • Designed and implemented Contract Default prediction using AWS Machine Learning (binary classification model)
  • Delivered multiple Business Intelligence solutions for BMW, Porsche, Volkswagen, Daimler across multiple countries
  • Designed pilot data platform using Azure Databricks for telemetry data from test vehicles
  • Developed data pipelines using Databricks notebooks and Delta Lake with Azure Blob Storage
AWS Machine LearningAzure DatabricksDelta LakeAzure Blob StoragePower BISQLPythonSASETLData Warehousing

Senior BI Consultant

MCON Group

πŸ“ Beijing & Shanghai, China

Jan 2012 - Dec 2014 Β· 2 years 11 months

full-time

Senior consultant leading CRM and finance system implementations for premium automotive brands in China.

  • Designed CRM landscape architecture replacing Goldmine with CARMEN system for BMW, leading team of 6 people updating 20+ interfaces
  • Worked as senior data engineer in finance system setup for Porsche Holding China
  • Designed and implemented interface to centralize finance KPIs from multiple OEMs to Holding entity
  • Led data migration of complex accounting legacy system to Microsoft Navision Suite with 100% accuracy
  • Advised clients and team members on automotive strategy and CRM topics at all management levels
  • Mapped business processes to BI solutions and defined IT architectures
SQL ServerMicrosoft NavisionCRM SystemsETLData MigrationBusiness Intelligence

BI Developer

MCON Group

πŸ“ Beijing & Shanghai, China

Jun 2008 - Dec 2011 Β· 3 years 6 months

full-time

BI Developer implementing CRM and DWH solutions for BMW China, supporting exponential business growth.

  • Main ETL developer for Goldmine CRM system implementation in BMW China supporting 500+ users
  • Developed data migration scripts using SQL Server Integration Packages to centralize CRM data from legacy systems
  • Supported BMW's exponential growth from 200 to 400 dealer groups and 50,000 to 150,000 units sold over 3 years
  • Implemented and designed DWH landscape and interfaces with multiple 3rd party providers
  • Led CRM requirements and standards for all Auto Premium OEM lifestyle shops
  • Queried, extracted, processed and prepared sales, marketing and after-sales data for automotive clients
SQL ServerSSISGoldmine CRMETLData WarehousingQlikViewQlikSense

Software Developer

SCOSSI IngenierΓ­a

πŸ“ BogotΓ‘, Colombia

Oct 2006 - Mar 2008 Β· 1 year 5 months

full-time

DotNet developer building security systems and web applications for Colombian enterprises.

  • Designed and built event-driven security system for British Petroleum oil fields in Colombia
  • Implemented integration between field detection system and CCTV camera circuit with providers in Canada and USA
  • Developed WEB and Windows Applications with DotNet Technology for multiple Colombian clients
  • Changed paradigm of security systems from camera monitoring to event-driven action responses
DotNetC#ASP.NETSQL ServerMySQLSecurity SystemsCCTV Integration

Skills & Expertise

Data Engineering & Warehousing

  • SQL expert 18+ yrs
  • ETL/ELT expert 16+ yrs
  • Data Warehousing expert 16+ yrs
  • Data Modeling expert 16+ yrs
  • Python advanced 8+ yrs
  • R Programming intermediate 4+ yrs

Cloud & Big Data

  • AWS expert 6+ yrs
  • Azure advanced 4+ yrs
  • AWS Glue expert
  • AWS QuickSight advanced
  • AWS Athena advanced
  • AWS Elastic Search advanced
  • Azure Databricks advanced
  • Delta Lake intermediate

Business Intelligence & Visualization

  • Power BI expert 8+ yrs
  • QlikView expert 10+ yrs
  • QlikSense advanced 6+ yrs
  • SSRS advanced 12+ yrs
  • Tableau intermediate 3+ yrs

Databases

  • MS SQL Server expert 18+ yrs
  • MySQL advanced 10+ yrs
  • Oracle intermediate 5+ yrs

Machine Learning & AI

  • Machine Learning intermediate
  • AWS Machine Learning advanced
  • Deep Neural Networks intermediate
  • Regression Models advanced
  • Classification Models advanced

Product Management

  • Product Ownership expert
  • Agile/Scrum expert
  • Stakeholder Management expert
  • Team Leadership expert
  • Cross-cultural Management expert
  • Requirements Analysis expert

Domain Knowledge

  • Automotive Industry expert 16+ yrs
  • CRM Systems expert
  • Finance & Risk advanced
  • IFRS9 Compliance advanced

Education

Bachelor in Computer Science

National University

πŸ“ Colombia

Jan 1999 - Dec 2006

Bachelor in Computer Science with focus on software engineering and database systems

Professional Certificate in Applied Machine Learning

Columbia University – EMERITUS Institute of Management

πŸ“ New York, USA (Online)

Jan 2019 - Dec 2019

Advanced certification in machine learning applications and data science methodologies

Professional Certificate in Data Scientist with R

DataCamp Platform

πŸ“ Online

Jan 2018 - Dec 2019

Comprehensive data science training with R programming and statistical analysis

Certifications

Languages

Spanish native
English fluent
Italian intermediate
German basic