Pranav Mittal

About Pranav Mittal

I am a Data Analyst specializing in the modern data stack, focused on bridging the gap between raw data and strategic business decisions. With 5 years of technical experience, including 3 years driving data analytics at Zscaler. I build reliable data models and business intelligence solutions using advanced SQL, Snowflake, and TableauMy approach goes beyond standard reporting—I build automated tools that solve actual data bottlenecks. Whether it\'s developing a custom Python/Streamlit application to automate complex data validation or architecting business data marts in Snowflake, my goal is always to ensure absolute data integrity and drastically reduce manual overhead.Beyond tool building, I have a proven track record of handling high-stakes enterprise data, having successfully executed end-to-end data mapping and validation for massive system migrations (including Workday and Greenhouse).I am deeply passionate about clean data models and efficient pipelines, actively leveraging Python and dbt to transition deeper into Analytics Engineering. I thrive in environments where I can build scalable, automated solutions that empower cross-functional teams.

Experience

1. Data Analyst

   Zscaler

   Oct 2024 — Present · Chandigarh, IN

   Data Pipelines & API Integration: Engineered an automated data integration with the Brivo platform, streamlining data extraction and movement to enhance operational security reporting.Business-Critical Automation: Automated the end-to-end generation of complex Churn reports, eliminating manual data processing and ensuring leadership receives highly accurate, timely retention metrics.Python Validation Tool: Architected and deployed a custom data validation application using Python and Streamlit. This tool automates \"apple-to-apple\" table comparisons to instantly flag missing records and ensure data integrity.Snowflake Data Modeling: Partnered directly with business stakeholders to define requirements and establish a new business data mart within Snowflake, building functional data models and documenting core logic.

Education

• Jaipur National University

  Bachelor of Computer Science, Computer Programming, Specific Applications

  2017 — 2020

• Uttaranchal University

  Master of Computer Applications - MCA, Artificial Intelligence