Gerardo Garcia Sandoval
Business Intelligence coordinator · Grupo Urrea
Zapopan, JALWork Experience
Business Intelligence coordinator
Grupo Urrea2019 – Present
-Development of Power Bi Dashboards with the main KPIs of the company. -Quantitative analysis of macroeconomic and internal variables to predict sales of Microsoft Excel the main SKUs -Machine Learning models in python to determine churn rate and customer Visual Basic classifications. Power Bi -Responsible of the sales force effectiveness and productivity department, providing the commercial area with technological tools to improve decision making. Python
New business coordinator
Grupo Urrea2017 – 2018
-Design and implementation of sales strategies with focus on profitability. Qlik View -RGM Strategies for the ceramics division. -Multidisciplinary team leader (Marketing, Production, Finance and Sales). Machine Learning -Responsible for the financial, technical and strategic evaluation of new potential line of business for the company.
Assistant professor
Universidad Panamericana2016 – 2017
-Subject: "Working Capital and Cashflow" English Toefl iBT 102 -Subject: "Investment Projects" Spanish Native
Financial Specialist
Inmobiliaria Tierra y Armonía2015 – 2017
-Optimization of financial models through technological tools for the best and effective decision making. -Report of the main KPIs towards general management.
Comercial Financial Analyst
Pepsico Mexico Foods2013 – 2015
-Analysis of market data to identify trends and develop effective sales strategies. -Revenue Management. -Setting customers and sales reps goals and targets