Jorge Luna
Verified Expert in Engineering
Data Engineer and Developer
Mexico City, Mexico
Toptal member since November 9, 2022
Jorge is a seasoned business intelligence and data engineering consultant with over ten years of experience. His background includes working with big pharma companies, from requirements gathering to deployment, including extract, transform, load (ETL) and extract, transform (ELT) processes, data warehouses, tabular and multidimensional modeling, machine learning, data visualization, KPIs, and analytics. With all these skills and his record, Jorge is ready to take on new challenges.
Portfolio
Experience
- SQL - 15 years
- ETL - 10 years
- Data Engineering - 10 years
- Business Intelligence (BI) - 10 years
- Microsoft Power BI - 5 years
- SSAS Tabular - 5 years
- DAX - 5 years
- Azure - 3 years
Availability
Preferred Environment
SQL, Python, Microsoft Power BI, DAX, C#, Azure, Azure Data Factory (ADF), SSAS Tabular, Business Intelligence (BI), ETL
The most amazing...
...thing I've developed and designed is a multicountry data warehouse for a big pharma company.
Work Experience
Chief Technology Officer
Ideal Data
- Selected and established the cloud infrastructure for the company.
- Launched a new product category for advanced users based on machine learning.
- Led complex technical projects that required advanced skills, such as SQL, data analysis expressions (DAX), data visualization, and programming.
- Managed a team of three senior and two junior business intelligence (BI) consultants to accomplish the company's deadlines and distributed workload.
- Accompanied sales processes for high profile customers as information technology expert.
Business Intelligence Designer
Globant
- Optimized the data refreshing SQL process from five hours to 40 minutes.
- Led the internal business intelligence team in Mexico City with three junior consultants as the senior local member and shared good practices and optimization techniques with the team.
- Fixed the SQL Server Analysis Services (SSAS) Tabular data model issues that slowed down executive-level reports.
Information Management Consultant
IQVIA
- Developed a system and algorithm to detect and normalize outliers as a previous step to calculate incentives for sales forces, deployed in three weeks instead of four agreed.
- Created a classification system with fuzzy logic with 67% fewer human resources involved, resulting in a decrease in product classification time from one day to 2-5 minutes and an increase of assessed products in audits by 13%.
- Automated daily manual tasks with SQL, PHP, MS-DOS, and C#.
PHP Developer | ETL Developer
DGTIC UNAM
- Developed ETL processes in four months instead of six agreed with the customer, with 60% fewer human resources required.
- Decreased the development time by 33%, increasing the number of customers by 200%.
- Saved 100% of licensing costs for ETL tools with open source tools.
Experience
Power BI Story Telling
https://www.youtube.com/watch?v=s27misLB-1I&t=73sPower BI Course Teacher for Crehana
https://www.crehana.com/cursos-online-data/analisis-de-datos-con-power-bi/?title&__country_code=mxSales Outlier Detection
https://www.youtube.com/watch?v=ZuteIOA_NhA&t=20sTechnologies used: Microsoft Power BI, Azure SQL Server, Azure Anomaly Detector, and Python.
Time Series Forecasting Model Evaluation
https://www.youtube.com/watch?v=xSradrcAKzsThe Prophet model was tuned using grid search, so there were three models: base Prophet model, tuned Prophet model, and Microsoft Power BI built-in model.
Education
Master's Degree in Computer Science (with distinction)
Queen Mary University of London - London, UK
Bachelor's Degree in Information Technology
National Autonomous University of Mexico - Mexico City, Mexico
Certifications
Microsoft Certified | Azure Fundamentals
Microsoft
Lean Six Sigma Black Belt
VMEdu
Scrum Master Certified
VMEdu
MCSA | SQL Server Certification
Microsoft
Oracle Certified Associate
Oracle
Exchange Program Coursework in Computer Science
University of Erlangen-Nuremberg
Skills
Libraries/APIs
Pandas, Scikit-learn
Tools
Microsoft Power BI, Power Query, Microsoft Team Foundation Server, Git, GitHub, DataViz
Languages
SQL, T-SQL (Transact-SQL), Python, Power Query M, C#
Paradigms
ETL, Business Intelligence (BI), Kimball Methodology, Functional Programming, Scrum
Storage
SSAS Tabular, Databases, SQL Server Analysis Services (SSAS), SQL Stored Procedures, Microsoft SQL Server, SQL Server Integration Services (SSIS), Azure SQL, MySQL, Oracle 11g, Data Pipelines
Platforms
Windows Server, Azure, Linux
Frameworks
.NET
Industry Expertise
Lean Six Sigma
Other
DAX, Data Analysis, Analytics, Data Cleansing, Data Analytics, Dashboards, Reporting, Data Modeling, Data Architecture, Star Schema, BI Reports, BI Reporting, CSV, CSV File Processing, Data Warehousing, Data Warehouse Design, Excel 365, Dashboard Design, Dashboard Development, Analytical Dashboards, Interactive Dashboards, Reports, Azure Data Factory (ADF), Data Engineering, Programming, Data Vaults, Web Scraping, IT Project Management, Scrum Master, People Management, Business Modeling, Machine Learning, Data Cleaning, Tech Sales
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring