GRUNENTHAL – Field Force Excellence Specialist Andean Cluster (March 2022 – Actual)• Development of analytical models (SQL Server / Python / Azure Datalake) to identify business opportunities.• Design and create KPI's (Qlik Sense / Power BI) to monitor sales force execution.• Development of statistical models (SQL Server / Python / R Studio / Azure Datalake ) for optimization of sales force teams “resource allocation”. • Development of models for customer segmentation and targeting (ETL, SSIS / Azure Datalake / SQL Server )• Business support for assertive decision-makingACCOMPLISHMENTS:  KPIs to follow up on the execution of the strategy by sales force.. Customer segmentation & targeting model by brand, channel and portfolio. Concentration curve model to optimize sales force teams and meet market demand. Integrated models of process/outcome variables to validate the functioning of strategic marketing initiatives.

GRUNENTHAL – Data Management Analyst (December 2019 – March 2022)• Creation and management of Databases (SQL Server / My Sql / SQL Developer)• Dashboard development (Power Bi- Qlik Sense)• Sales force training.• Creation and management of ETL (SQL Server Integration Services SSIS) • Creation of Stored Procedures, Views, Cursors, Functions (SQL Server)ACCOMPLISHMENTS:  Standardization and centralization of all market audit reports and KPIs for the Andean cluster (EC, CO and PE) Implementation of PBI PM – DDD (Project for the integration and visualization of market audit information for the Andean cluster (EC, CO and PE) Creation and automation of all market configuration processes for the Andean cluster (EC, CO and PE) Training in the use and interpretation of market audits to sales force teams to identify opportunities

SANOFI – Development of Tools and BI (February 2017 – December 2019)• Data analyst and management. ( Visual Studio Tools / Visual Fox Pro )• Database management (SQL Developer / SQL Server). • Development of cubes in ( Qlik View / Tableu )• Design and creation of ETL (Integration Services)ACCOMPLISHMENTS:  Automation in the generation of 95% of the reports and tools delivered to the different internal customers. Monthly increase in the % of communication between Internal Bases VS Customer Bases (Homologation). 90% automation of the execution of processes in the different Databases.

QUINTERO HERMANOSAnalista de información (October 2015 - February 2017)• Creation and management of databases (MySql / PostgreSQL)• Massive uploads of information.• Data processing (character cleaning)• Deployment and replication of databases on UNIX.• Design and construction of reports.ACCOMPLISHMENTS: Automation of 100% of information loads using Transact-SQL and SSIS. Design and creation of DB structures and models. 100% automation of character cleanup processes using Excel VBA and Visual Fox Pro.

Lincoln Electric Colombia – Aprendiz SENA IT (April 2014 - October 2014)Analysis, design and development of custom software, server maintenance, administration of databases (different DBMS), face-to-face / remote support to users on the use of internal applications, some activities of camera installation / DVR configuration, configuration of Active Directory, knowledge and experience in .NET (C# and ASP) and T-SQL.ACCOMPLISHMENTS: Design, development and implementation of RMAINTENANCE, a tailor-made software for the Industrial Maintenance area, in order to systematize and save historical information in BD SQL Server, of all day-to-day maintenance requirements.