Edgar García Franco Business Intelligence Specialist

T

Data Analytics Consultant

TSA Consultores

May 2025 - Current (1 year 1 month)

• Lead analytics projects in several industries: Banking, Oil & Gas, Transport, Telecommunications. • Exploratory Data Analysis and design transactional dashboards. • Process automatization using IA tools and n8n. Tools: MS Power BI, Python, SQL, Machine Learning, n8n.

G

Business Intelligence Analyst III

GTM COLOMBIA S.A.S

Sep 2022 - Dec 2023 (1 year 4 months)

• Market and competitive intelligence with exports/imports tolos. • Approval of 9 new product introductions out of a target of 10 in a period of 4 months. • Achieved mapping of the distribution of specialties and ingredients for the Lubricants and Home & Personal Care industries in LATAM. Tools: Veritrade, EMIS (global industries reports), Mintel, MS Power BI, MS Office.

Business Intelligence Coordinator

Ferrero LADM

Jan 2020 - Mar 2022 (2 years 3 months)

• Follow-up to Sell in, Sell Out and Inventories in S&OP process. • Preparation and presentation of the forecasting to the company's Headquarters. • Consolidate the company's reporting suite. Tools: MS Power BI, SQL, Power Query, data modelling, ETS, Forecast.

Business Intelligence Analyst

Ferrero LADM

Jun 2018 - Dec 2019 (1 year 7 months)

• Design and implement the company's sales commission model for Ecuador and Colombia. • Develop Dashboards with transactional data. • Management of the ETL data process. Tools: MS Power BI, Power Query, modelado de datos, ETS, Forecast.

Sales administration assistant

Ferrero LADM

May 2017 - May 2018 (1 year 1 month)

• Administrative support to the National Sales Manager with local reports and presentations. • Manage compliance with commercial agreements through invoices and credit notes. • Reduction of 60% overdue portfolio. Tools: MS Excel, MS Power Point

O

Logistics Coordinator GM Academy- General Motors Colmotores S.A.

OVERLAP COLOMBIA S.A.S

Apr 2013 - Oct 2013 (7 months)

• LMS training platform manager. • Logistic management for the corporate university. • Taxi Elite product training successfully achieved for the country's dealer network . Tools: MS Excel, MS Power Point, MS Project Management, LMS

Internship PNEIG/Consulting systems coordinator

Corporación Calidad

Jul 2012 - Feb 2013 (8 months)

• Development of proposals, documents and presentations to clients. • Financial control and monitoring of ongoing consulting projects. • Logistics organization for the Colombia Quality Management Award. Tools: MS Excel, MS Power Point

Edgar García Franco

About

Detail

Timeline

Résumé