Jorge is available for hire

Jorge Luna

Verified Expert in Engineering

Data Engineer and Developer

Location

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.

Data Cleansing Data Analysis Analytics Data Analytics BI Reports Data Warehousing Data Warehouse Design SQL Databases ETL Business Intelligence (BI)SQL Stored Procedures T-SQL (Transact-SQL)Microsoft SQL Server Microsoft Power BI Kimball Methodology Data Cleaning DAX

Portfolio

Ideal Data

Azure, Microsoft Power BI, Python, SQL, Azure Data Factory...

Globant

Microsoft Power BI, SSAS Tabular, DAX, SQL, Databases, DataViz, Data Cleaning...

IQVIA

SQL, Microsoft Power BI, DAX, C#, SQL Server Integration Services (SSIS)...

Experience

SQL - 15 years ETL - 10 years Data Engineering - 10 years Business Intelligence (BI) - 10 years SSAS Tabular - 5 years DAX - 5 years Microsoft Power BI - 5 years Azure - 3 years

Availability

Part-time

Preferred Environment

SQL, Python, Microsoft Power BI, DAX, C#, Azure, Azure Data Factory, 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

2020 - PRESENT

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.

Technologies: Azure, Microsoft Power BI, Python, SQL, Azure Data Factory, SQL Server Integration Services (SSIS), SSAS Tabular, DAX, C#, Databases, DataViz, Data Cleaning, Data Pipelines, Data Cleansing, Data Analysis, Analytics, Data Analytics, Reporting, Dashboards, Data Modeling, Data Architecture, Data Vaults, Business Intelligence (BI), Data Engineering, Kimball Methodology, Star Schema, BI Reports, BI Reporting, Web Scraping, CSV, CSV File Processing, IT Project Management, Scrum, Scrum Master, Pandas, Scikit-learn, Machine Learning, People Management, Linux, Windows Server, SQL Server Analysis Services (SSAS), Tech Sales, ETL, Data Warehousing, Data Warehouse Design, Excel 365, Power Query, Power Query M, Microsoft Team Foundation Server, Git, GitHub, .NET, SQL Stored Procedures, T-SQL (Transact-SQL), Microsoft SQL Server

Business Intelligence Designer

2019 - 2020

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.

Technologies: Microsoft Power BI, SSAS Tabular, DAX, SQL, Databases, DataViz, Data Cleaning, Data Cleansing, Data Analysis, Data Analytics, Dashboards, Reporting, Analytics, Business Intelligence (BI), Data Engineering, Data Modeling, Data Architecture, Star Schema, Kimball Methodology, Data Vaults, BI Reports, BI Reporting, CSV, CSV File Processing, Web Scraping, People Management, IT Project Management, Scrum, Scrum Master, Pandas, Python, Scikit-learn, Machine Learning, Linux, Windows Server, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Azure, Azure Data Factory, ETL, Data Warehousing, Data Warehouse Design, Power Query, Power Query M, Git, GitHub, Microsoft Team Foundation Server, .NET, T-SQL (Transact-SQL), SQL Stored Procedures, Microsoft SQL Server

Information Management Consultant

2015 - 2019

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#.

Technologies: SQL, Microsoft Power BI, DAX, C#, SQL Server Integration Services (SSIS), SSAS Tabular, Databases, DataViz, Data Cleaning, Data Pipelines, Dashboards, Reporting, Data Cleansing, Analytics, Data Analysis, Data Analytics, Business Intelligence (BI), Data Engineering, Data Architecture, Data Vaults, Data Modeling, Kimball Methodology, Star Schema, BI Reports, BI Reporting, Web Scraping, CSV, CSV File Processing, Pandas, Scikit-learn, Machine Learning, Scrum, SQL Server Analysis Services (SSAS), Windows Server, Linux, ETL, Data Warehousing, Data Warehouse Design, Power Query, Power Query M, Microsoft Team Foundation Server, Git, GitHub, .NET, T-SQL (Transact-SQL), SQL Stored Procedures, Microsoft SQL Server

PHP Developer | ETL Developer

2010 - 2012

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.

Technologies: MySQL, Databases, DataViz, Data Cleaning, Data Pipelines, Data Analysis, Analytics, Data Analytics, Data Cleansing, Data Modeling, Data Engineering, Data Architecture, CSV, CSV File Processing, Web Scraping, Linux, Windows Server, SQL

Experience

Power BI Story Telling

https://www.youtube.com/watch?v=s27misLB-1I&t=73s

A Microsoft Power BI report for sales storytelling. I served as a Microsoft Power BI developer for a big pharma company that asked for an appealing report for their sales force. The project required data cleaning, modeling, and data visualization.

Power BI Course Teacher for Crehana

https://www.crehana.com/cursos-online-data/analisis-de-datos-con-power-bi/?title&__country_code=mx

I taught a Power BI course for Crehana, an IT education platform. I also designed the syllabus, exercises, slides, diagrams, and course material for this intermediate Power BI course which encompasses five modules and 30 classes.

Sales Outlier Detection

https://www.youtube.com/watch?v=ZuteIOA_NhA&t=20s

A retail company asked for an outlier detection tool for their time series sales. The project required data cleaning, outlier model selection and validation, and data visualization.

Technologies used: Microsoft Power BI, Azure SQL Server, Azure Anomaly Detector, and Python.

Time Series Forecasting Model Evaluation

https://www.youtube.com/watch?v=xSradrcAKzs

A big pharma company asked for a visual tool to evaluate the Facebook Prophet forecasting model against Microsoft Power BI built-in forecasting model.

The 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

2012 - 2013

Master's Degree in Computer Science (with distinction)

Queen Mary University of London - London, UK

2005 - 2009

Bachelor's Degree in Information Technology

National Autonomous University of Mexico - Mexico City, Mexico

Certifications

MAY 2021 - PRESENT

Microsoft Certified | Azure Fundamentals

Microsoft

JULY 2018 - PRESENT

Lean Six Sigma Black Belt

VMEdu

APRIL 2018 - PRESENT

Scrum Master Certified

VMEdu

JANUARY 2016 - PRESENT

MCSA | SQL Server Certification

Microsoft

APRIL 2012 - PRESENT

Oracle Certified Associate

Oracle

JANUARY 2009 - PRESENT

Exchange Program Coursework in Computer Science

University of Erlangen-Nuremberg

Skills

Languages

SQL, T-SQL (Transact-SQL), Python, Power Query M, C#

Tools

Microsoft Power BI, Power Query, Microsoft Team Foundation Server, Git, GitHub, DataViz

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

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, Data Engineering, Programming, Data Vaults, Web Scraping, IT Project Management, Scrum Master, People Management, Business Modeling, Lean Six Sigma, Machine Learning, Data Cleaning, Tech Sales

Libraries/APIs

Pandas, Scikit-learn

Platforms

Windows Server, Azure, Linux

Frameworks

.NET

Collaboration That Works

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

Discuss your requirements and refine your scope in a call with a Toptal domain expert.

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring