Jorge L.

Consultant

375 dollar
Freelancer
12 ans
Mexico City, MEXIQUE

Mon expérience

Voir plus

IQVIAOctober 2013 - Présent

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)
Voir plus

National Autonomous University of MexicoApril 2010 - September 2012

University’s department of technology that aims to take advantage of IT to support teaching, research, administrative and diffusion activities. Responsible for requirement gathering and analysis. Development of technology solutions. Systems maintenance and testing.

Development of extract, transform and load (etl) processes in four months instead of six agreed with the customer and 60% less human resources required. Decrease of development time 33%, increase of the amount of customers 200%, savings on licencing costs 100%.

PHP developer on CakePHP framework at DGTIC.
-Introduced the IT team to Talend Opend Studio for ETL processes. Improved database response time. Kept my development time 90% in time.
-Key developer for the design and implementation of ETL processes for data integration and cleansing. Treated data from heterogeneous databases with different owners.
-Trained an IT team on the design and development of ETL processes with Talend Open Studio (10 hrs). Gave a speech about XML databases with Oracle. Trained a group of IT scholars on database foundations (20 hrs.)
Voir plus

SIS OrganizacionNovember 2009 - February 2010

-Enforcement and correction of business rules, process monitoring and data integration from distinct

sources. Ready to work on a production environment after two weeks of training.
Voir plus

DGIRE UNAMApril 2008 - March 2009

Power builder developer.





-    Automation of students' academic history reports with Power Builder for all high schools and

universities incorporated to the UNAM.

Mes compétences

Business Intelligence

Business Intelligence

Others

Data Science

Databases

MongoDB, MySQL

Big Data

Big Data

Mes études et formations

Informatics bachelor degree - Informatics - National Autonomous University of Mexico

Management Development Program in Data Science & Big Data - Bolsa Mexicana de Valores2018 - 2018

Big Data Engineering - Computer Science - Latam Challenge2017 - 2017

Master of Science (MSc) - Computer Science - Queen Mary University of London2012 - 2013

Exchange student - Informatics, IT. - University of Erlangen-Nuremberg2009 - 2009