Ricardo Mercado

Experience

• 

  Secretaría de Desarrollo Social

  Sept 2007 - Sept 2008

  Senior Budget Analyst

  I was in charge of the Budget Information applications, I worked on enhancing the automation processes, I was managing and working with heads of different lines of business in order to increase the reliability and data quality.• Programming and maintenance of SiHo, SiReg, Sipag Web (POO Java).• Server administration and user passwords for application usage.• Attention to end users.

• 

  Solera | Audatex

  Oct 2008 - Jun 2011

  Reporting Analyst

  I worked as business intelligence developer. I was in charge of the daily/weekly data processing and reporting. I ensured that the data was up-to-date and accurate for the different metrics we provided, by using powerful reporting tools, such as charts, gauge and some mapping indicators that facilitated upper-management decisions.• Developed of ETL (Extracting Transforming and Loading) Financial information in order to show useful information on dashboards through the automation process.• Implementing data quality controls in order to provide certainly and reliability.• Building several reports (mapping, gauging, pivot tables, etc) in order to facilitate decision making.• Developing and publishing DataMarts in Oracle/SQL server by using the tools provided by the company like MS Analysis Services, Microsoft Report Builder and Dundas Dashboard.• Client support and interaccion with other teams in USA. Show less

• 

  HSBC

  Jun 2011 - Sept 2013

  Senior BI Consultant

  I spearheaded Business Intelligence developments with a primary focus on decreasing processing time and eliminating manual intervention. Through the creation of various processes, I successfully reconciled figures by line of business, contrasting them with the official reports provided by the Finance department.• Through building Dashboards and Scorecards reports, several LOBS were able to ccame up with solid strategies to manage incentives and penalities based on employee performance.• Developed of ETL (Extracting Transforming and Loading) Financial information in order to reduce five days of work through automation processes.• Modelling end-user data for each line of business (DataModels, DataMart).Increasing the reliability of data provided by CID almost 5% through reconciliation from official sources such as Finance Data Store.• Implementing data quality controls in order to reduce 3% margin of error for manual intervention.• Proposals for new projects and enhancement of existing applications from other lines of business.• Management and responsibility for subordinates Show less

• 

  Urban Science

  Sept 2013 - now

  Contribute to tackling the most intricate challenges encountered by Hyundai & Genesis, prioritizing the optimization of dealership networks and enhancement of individual dealer performance. Employing a rigorous scientific approach to enhance vehicle sales, increase profitability, and cultivate stronger customer loyalty. Participate in data mining, cleaning, and aggregation tasks to preprocess data, then proceed to construct, and deploy predictive models while conducting innovative data analysis. • Improve and fine-tune machine learning and statistical models, encompassing classification, regression,clustering, analyzing bias-variance trade-off, over/under-fitting, and model tunning (such as Decision Trees, Random Forest, SVM, and Naïve Bayes models). These efforts contributed to the advancement of Hyundai/Genesis dealer sales and network representation, leading to a 1.2% increase in nationwide market share during the 1Q of 2024.• Utilizing both supervised/unsupervised learning techniques to segment EVs and assess the charging station infrastructure network across the US. As a result, the Genesis account achieved internal revenue growth of 8% in Dec 2023.• Perform iterative data exploration and visualization, along with statistical analysis, to uncover meaningfulcorrelations within sales data for both Gas/Hybrid and EVs. Following the completion of the project, Hyundai Local Account experienced an internal revenue growth of 32% in Dec 2023.• Analyzes and interprets comprehensive datasets covering customer shopping behaviors, demographic profiles, economic trends, mall statistics, and mobility patterns. Utilizes statistical techniques like clustering and time series analysis to discern customer preferences and identify opportunities with the OEM network.• Optimized SQL queries and data retrieval processes, resulting in a 30% improvement in report generation speed, enhancing operational efficiency and user satisfaction. Show less Conduct high-quality data-related projects and assignments with a strong emphasis on accuracy and timely delivery, utilizing a combination of client interaction and technical skills.• Created automated ETL (Extract, Transform, Load) processes on a monthly and year-end basis using Microsoft Integration Services and SQL Server, thereby cutting manual workload by 50% and lowering operational costs by $1,200 annually.• Executed data cleansing and validation protocols, leading to a 16% decrease in data errors and guaranteeing the availability of high-quality, dependable data for informed decision-making.• Modelling end-user data for each automotive account (Mapping reports, key performance indicators KPI’s, statistical scorecards). Show less In charge of International Network Studies, with a specific focus on improving the current dealer network methodology using geospatial algorithms, statistical analysis, and analytical processes. The objective is to streamline decision-making, ultimately fostering the growth of sales and profits for our customers.• By applying scientific methods to assess automotive network performance, I provide recommendations for optimal solutions that support decision-making aligned with network performance and client strategy.• Developed ETL (Extracting, Transforming, and Loading) processes for automotive information across various business markets (Argentina, Brazil, Ecuador, Mexico, etc.). The aim was to reduce errors in manufacturer's locations by 10% through the automation of the process.• Modelling end-user data for each automotive account (Mapping reports, key performance indicators KPI’s, statistical scorecards). • Defining strategic performance plans matching with Business Management Information (BMI).• Proposals for new projects that involve technology that never has been used in the office. Show less

  • BI & Data Analysis Manager

    Apr 2020 - now

  • Sr. Consultant - Toyota Motors North America

    Jul 2017 - Mar 2020

  • Sr. Consultant - General Motors Mexico

    Sept 2013 - Jun 2017
• 

  CIO & Co-Founder

  Jan 2015 - Jul 2017

  Confidential Startup

  Real time mobile-web applications development.Developing strategy solutions.Building certainty and reliability to the decision making.