Pratik Wadkar

🗓️ Feb 2024 - Present 📍 Navi Mumbai 💼 America's #1 Digital Audio Company

Built 25+ scalable data pipelines, extracting and ingesting millions of records daily from multiple sources and APIs into the data warehouse.
Collaborated with stakeholders to gather business requirements and define KPIs, transforming raw data into analytics ready format for BI dashboards.
Leveraged streaming and asynchronous pipeline architecture, delivering ~8x higher throughput and drastically reducing runtimes.
Automated workflow orchestration via CI/CD, eliminating manual workload while enhancing operational efficiency.
Implemented data validation processes with real-time alerts, minimizing data quality errors by ~60%.

🏆 LTS Award ✨ Star of the Quarter

🗓️ Jan 2022 - Jan 2024 📍 Navi Mumbai 💼 American Legal Tech Company

Led end-to-end migration of 4TB+ data from Hive to Snowflake, implementing a Python-based workflow, ensuring seamless data transition.
Integrated data from various third-party applications and systems into Snowflake, populating 30+ tables for downstream analytics and reporting.
Developed modular SQL scripts to compute critical business metrics, improving query performance by ~50% and enabling reusability.
Deployed a time-series model, leveraging historical data to impute missing values and forecast trends with 92%+ accuracy, empowering data-driven decisions.
Communicated with cross-functional teams to resolve data discrepancies and drive project alignment.

✨ Star of the Quarter 🚀 Extra Mile Award

Education

🗓️ Jun 2021 📍 Navi Mumbai

🥇 First Class

🗓️ Feb 2017 📍 Thane

🥇 First Class

🗓️ Mar 2015 📍 Thane

🏅 Distinction

Skills & Credentials

🐍 Python 🗄️ SQL 💻 Shell 🌐 HTML 🎨 CSS 📜 JavaScript

☁️ Cloud Data Platforms 🏢 Data Warehousing 🔧 Data Pipelines 🧩 ELT 🤖 Automation ♻️ CI/CD 📈 Time-Series Forecasting 💡 Business Intelligence

🌩️ AWS (Redshift|S3) ❄️ Snowflake 🐝 Hive 🦆 DuckDB ⚙️ Github Actions 🐼 Pandas 🐻‍❄️ Polars 🧱 DBT 🔗 AWSwrangler 📡 Httpx 🎯 Darts 📊 Tableau

🗓️ Dec 2023

🗓️ Oct 2021

Experience