Ron L'Esteve
Ron L'Esteve is a seasoned Data Architect with over 16 years of experience with Microsoft Business Intelligence, Data engineering, and emerging cloud and big data technologies. Ron holds a Master of Business Administration (M.B.A.) and Master of Science in Corporate Finance (M.S.F.) from Loyola University Chicago. Ron is a Motorola Certified Six Sigma Green Belt and also holds the Microsoft Professional Program Certificate in Big Data and is a Microsoft Global Challenger.
Ron is a trusted architectural leader & digital innovation strategy advisor, responsible for scaling key data architectures, defining the roadmap and strategy for the future of data and business intelligence needs, and challenging customers to grow by thoroughly understanding the fluid business opportunities and enabling change by translating them into high quality and sustainable technical solutions that solve the most complex business challenges and promote digital innovation and transformation.
Ron has been the standard bearer for data excellence across industries and consulting practices, while empowering self-service Data, BI and AI through his contributions to the Microsoft technical community.
2021 Awards
2020 Awards
2019 Awards
Apache Spark
- Getting Started with Graph Analytics Using Apache Spark's GraphFrame API (last update: 3/15/2021)
- Real-time IoT Analytics Using Apache Sparks Structured Streaming into Databricks Delta Lake (last update: 3/25/2021)
Azure
- Azure Data Lake Analytics using U-SQL Queries (last update: 2/11/2019)
- Azure Vision Service and Face API Example with Python (last update: 5/1/2019)
- Create Azure Data Lake Database, Schema, Table, View, Function and Stored Procedure (last update: 2/20/2019)
- Design and Manage Azure SQL Data Warehouse (last update: 4/19/2019)
- Designing an Azure Data Lake Store Gen2 (last update: 4/21/2021)
- Example Using C# Code with U-SQL Scripts (last update: 3/7/2019)
- Getting Started with Azure Purview for Data Governance (last update: 6/8/2021)
- Reading and Writing to Snowflake Data Warehouse from Azure Databricks using Azure Data Factory (last update: 5/19/2021)
- Real-Time Anomaly Detection Using Azure Stream Analytics (last update: 1/14/2020)
- Using Azure Databricks to Query Azure SQL Database (last update: 8/29/2019)
- Using PowerShell and Azure Blueprints to provision a Modern Data and Analytics Platform (last update: 10/8/2020)
- Write Federated U-SQL Queries to Join Azure Data Lake Store Files to Azure SQL DB (last update: 1/24/2019)
Azure Data Factory
- Azure Data Factory Data Transformation with U-SQL (last update: 4/1/2019)
- Azure Data Factory Mapping Data Flow for Datawarehouse ETL (last update: 6/18/2019)
- Azure Data Factory Mapping Data Flows for Big Data Lake Aggregations and Transformations (last update: 9/16/2019)
- Azure Data Factory Pipeline Logging Error Details (last update: 1/20/2021)
- Azure Data Factory Pipeline to fully Load all SQL Server Objects to ADLS Gen2 (last update: 1/30/2020)
- Azure Data Factory vs SSIS vs Azure Databricks (last update: 6/8/2020)
- Create Azure Data Lake Linked Service Using Azure Data Factory (last update: 3/18/2019)
- Fast Way to Load Data into Azure Data Lake using Azure Data Factory (last update: 5/18/2020)
- Getting Started with Delta Lake Using Azure Data Factory (last update: 8/17/2020)
- Import Data from Excel to Azure SQL Database using Azure Data Factory (last update: 7/6/2021)
- Incrementally Upsert data using Azure Data Factory's Mapping Data Flows (last update: 2/17/2021)
- Load Data Lake files into Azure Synapse Analytics Using Azure Data Factory (last update: 3/9/2020)
- Loading Azure SQL Data Warehouse Dynamically using Azure Data Factory (last update: 4/16/2020)
- Logging Azure Data Factory Pipeline Audit Data (last update: 2/18/2020)
- Snowflake Data Warehouse Loading with Azure Data Factory and Databricks (last update: 6/15/2021)
Azure Databricks
- Advanced Schema Evolution using Databricks Auto Loader (last update: 8/30/2021)
- Azure Databricks Access Controls and Row Level Security (last update: 5/28/2021)
- Bloom Filter Indexes using Databricks Delta (last update: 9/14/2021)
- Create a Python Wheel File to Package and Distribute Custom Code (last update: 3/31/2021)
- Creating Deep and Shallow Delta Clones in Azure Databricks (last update: 5/7/2021)
- Databricks Delta Change Data Feed (last update: 9/10/2021)
- Getting Started with MLflow in Azure Databricks (last update: 4/14/2021)
- Managing Auto Loader Resources (last update: 9/1/2021)
- Mount an Azure Data Lake Storage Gen2 Account in Databricks (last update: 8/24/2021)
- Performance Tuning Apache Spark with Z-Ordering and Data Skipping in Azure Databricks (last update: 4/30/2021)
- Using Delta Schema Evolution in Azure Databricks (last update: 5/12/2021)
Azure Synapse Analytics
- Exploring the Capabilities of Azure Synapse Spark External Tables (last update: 3/3/2021)
- Getting Started with Azure Synapse Analytics Hyperspace for Spark Indexing (last update: 2/2/2021)
- Getting Started with Azure Synapse Analytics Workspace Samples (last update: 12/4/2020)
- Getting Started with Azure Synapse Link for Cosmos DB (last update: 2/25/2021)
- Using COPY INTO command to load Azure Synapse Analytics from Azure Data Lake Storage Gen2 (last update: 2/20/2020)
Big Data
- Realizing Business Value through an AI-driven Strategy and Culture (last update: 12/10/2019)
Data Warehousing
- Planning for a Cloud Data Warehouse Project (last update: 7/27/2021)
DevOps
- Azure Boards for Project Management (last update: 6/5/2019)
- Azure DevOps CI CD using GitHub Repo and Visual Studio Azure SQL Database Project (last update: 9/15/2020)
- Deploy Azure Data Factory CI/CD Changes with Azure DevOps (last update: 11/10/2020)
- Deploy SQL Database from Azure DevOps with an ARM Template and DACPAC File (last update: 5/9/2019)
- Getting Started with Azure Blueprints (last update: 7/14/2020)
- Managing Azure Blueprints with PowerShell (last update: 9/7/2020)
- Securing Secrets in Azure DevOps (last update: 10/22/2020)
- Using Azure Blueprints to deploy Azure SQL Server and Database with Key Vault Secrets (last update: 8/24/2020)
- Using Azure DevOps CI CD to Deploy Azure Data Factory Environments (last update: 8/4/2020)
Import and Export
- Flatten Semi-Structured Data with Snowflake (last update: 7/20/2021)
Integration Services Excel
- Using SQL Server Integration Services to Generate Excel Files Based on Criteria (last update: 1/4/2019)
Professional Development Certifications
- Prepare for Microsoft AI 100 Exam (last update: 12/18/2020)
Professional Development Interviewing
- How to Ace an Azure Data Engineer Interview (last update: 7/1/2020)
