Consultant

Responsible for identifying, automatizing and optimizing manual processes. Operate and enhance production processes for the “non-retail” and “government data” audits. Investigate data outliers before production. Data validation against the latin american hub.

Development of a classification system with fuzzy logic with 67% less human resources involved. Decrease of product classification time from one day to 2-5 minutes. Increase of assessed products in audits 13%.

-Pharmaceutial Market Mexico (PMM)
-Non Retail Channels
-GSDT Audit (IMSS & ISSSTE)
-SQL Server Integration Services (SSIS)
-SQL Server 2000 & 2005 & 2012 & 2014
-C#
IQVIA, formerly QuintilesIMS. International company specialized on providing information and business intelligence to the pharmaceutical industry. Responsible for providing support and training to customers based on the technology solutions portfolio. Identify requirements and new business opportunities. Pre and post-sale tracking. Customize technology solutions. Extend the solutions portfolio.

Development of a system and algorithm to detect and normalize outliers as a previous step to calculate incentives for sales forces, deployed in three weeks against four agreed. The system was developed with 50% less human resources and 25% less development time. Increase in yearly business prospects 300%, generating additional revenue against the sales objective in 13% for the “calculation of incentives” project.

- Business Intelligence dashboards with Board and Tableau
- Multidimensional cubes ( MS Analysis Services + SQL SERVER)
- Data modeling
- ETL MS SSIS - SSAS - SSRS
- Customer engagement
- Data analysis
- Datawarehouse (Data vault)