Mayank Khandelwal

About Mayank Khandelwal

DATA ARCHITECTURE & LAKEHOUSE MODERNIZATION EXPERTI am a Lead Data Engineer and BI Architect with 10+ years of experience specializing in transforming complex data infrastructure into high-performance, cost-efficient cloud platforms. My focus is on Data Warehouse Modernization moving organizations from legacy architectures to scalable solutions like the Databricks Lakehouse and Snowflake.My expertise is centered on three core areas that drive enterprise value:1. Platform Engineering: Architecting and optimizing ETL/ELT pipelines using PySpark/Delta Lake (Medallion Architecture) and Azure Data Factory, resulting in measurable cost reductions (up to 35\\%) and decreased reporting latency (up to 50\\%).2. Security & Governance: Designing and implementing robust security frameworks, including Dynamic Row-Level Security (RLS) in Power BI/Snowflake/Unity Catalog, ensuring data compliance and secure, multi-tenant access for internal teams and external partners.3. Business Intelligence: Bridging engineering complexity with executive needs by delivering high-impact, governed Power BI solutions that drive strategic planning and operational excellence.I thrive on solving complex data challenges that have a direct impact on the bottom line. Let\'s connect if you are building the next generation of data platforms.

Experience

1. Lead Data Engineer & Bi Architect Client Caterpillar (Usa)

   Softude

   Feb 2022 — Present · Indore, IN

   Leading a 10-person engineering team to modernize the data architecture for a critical operations program. My key focus areas include:Driving the architectural evaluation and Proof of Concept (POC) for shifting high-volume workloads to the Databricks Lakehouse using PySpark and Delta Live Tables (DLT).Architecting and enforcing a multi-layer Dynamic Row-Level Security (RLS) framework in Power BI and Snowflake to manage access for 400+ internal and external users.Spearheading performance tuning initiatives that reduced Snowflake storage costs by 35% and accelerated metric delivery by 50%.

Education

• Sanghvi Institute of Management and Science (Engg)

  Bachelor of Engineering (B.E.)

  2006 — 2010

Skills

• Statistical Data Analysis
• Requirements Analysis
• Regression Testing
• C++
• Machine Learning
• Sql
• Apache Spark
• Quality Assurance
• Testing
• Microsoft Power Bi
• Data Visualization
• Javascript
• Mysql
• Integration
• Python
• Tableau
• Testlink
• C
• System Testing
• Sdlc
• Statistics
• Html
• Selenium
• Test Cases
• Hadoop