Jorge Luna Email & Phone Number

Ciudad De México, México

Mexico City, Mexico

Video course Power BI Intermediate

Ciudad De México

Mexico City Area, Mexico

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… Show more 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) Show less

Mexico City Area, Mexico

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… Show more 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# Show less

Ciudad De México Y Alrededores, México

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… Show more 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.) Show less

Ciudad De México Y Alrededores, México

ETL - Data Stage developer at Pepsico.-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.

Ciudad De México Y Alrededores, México

Power builder developer.- Automation of students' academic history reports with Power Builder for all high schools and universities incorporated to the UNAM.

Master Of Science (Msc), Computer Science, Distinction

-CONACYT scholarship holder. -Queen Mary’s International Science and Engineering Excellence Award: to reward outstanding academic.

Programa De Desarrollo Directivo En Data Science & Big Data, Computer Science

Big Data Engineering, Computer Science

Big Data Engineering programme Modules (1 month per module) : - Python for data science - Data Analytics for business - Introduction.

Exchange Student, Informatics, It.

Informatics Bachelor Degree., Informatics, 9.1