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
- Microsoft Power BI - 11 years
- Business Intelligence (BI) - 10 years
- ETL - 10 years
- Data Engineering - 10 years
- Azure - 10 years
- DAX - 8 years
- SSAS Tabular - 5 years
Preferred Environment
SQL, Python, Microsoft Power BI, DAX, C#, Azure, Azure Data Factory (ADF), Business Intelligence (BI), ETL, Fabric
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
PySpark, Pandas, React, Scikit-learn, Fabric
Tools
Microsoft Power BI, Apache Airflow, Looker, Stitch Data, BigQuery, Cloudera, Tableau, AWS Glue, Microsoft Access, Power BI Desktop, Power BI Report Server, Power Query, Microsoft Team Foundation Server, Git, GitHub, Retool, Terraform, DataViz
Languages
SQL, Python, Transact-SQL (T-SQL), Looker Modeling Language (LookML), Snowflake, Power Query M, C#
Frameworks
Apache Spark, Data Lakehouse, Hadoop, Spark, .NET
Paradigms
ETL, Business Intelligence (BI), Kimball Methodology, Role-based Access Control (RBAC), DevOps, HL7 FHIR Standard, Dimensional Modeling, Event-driven Architecture, Functional Programming, Scrum
Platforms
Azure, Databricks, Microsoft Fabric, Amazon Web Services (AWS), Google Cloud Platform (GCP), AWS Lambda, Windows Server, Kubernetes, Docker, Linux
Storage
SSAS Tabular, Databases, Data Pipelines, SQL Server Analysis Services (SSAS), SQL Stored Procedures, Microsoft SQL Server, Redshift, Apache Hive, Amazon S3 (AWS S3), MongoDB, Data Validation, Google Cloud, Data Lakes, Database Administration (DBA), Database Modeling, Database Caching, Cassandra, PostgreSQL, Data Integration, DB, SQL Server Integration Services (SSIS), Azure SQL, MySQL, Oracle 11g
Industry Expertise
Healthcare, Lean Six Sigma
Other
DAX, Data Engineering, Data Cleaning, 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, AI-assisted Development, CI/CD Pipelines, Data Build Tool (dbt), Delta Lake, RESTFul APIs, Amazon Redshift, Directed Acrylic Graphs (DAG), Architecture, Cloud Architecture, Streaming, Data Taxonomy, Metadata, Data Governance, Data Science, Data Visualization, Scripting, Medallion Architecture, iPaaS, Unity Catalog, Audits, Data Transformation, Database Schema Design, Financial Reporting Dashboards, Google BigQuery, Looker Studio, Query Optimization, Workflow Automation, EMR, Cloud, Customer Data Platform (CDP), Data Marts, Database Optimization, Database Partitioning, Document Parsing, Railway, Consulting, Data Extraction, APIs, Key Performance Indicators (KPIs), HIPAA, Big Data, NetSuite, Tipalti, Amazon RDS, Azure Data Factory (ADF), Programming, Data Vaults, Web Scraping, IT Project Management, Scrum Master, People Management, Metabase, Back-end, Fivetran, AWS Database Migration Service (DMS), Monitoring, Supabase, Business Modeling, Machine Learning, 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