Dec 2023 – Dec 2025 · 2 yrs · Seattle, Washington, United States · On-site

• Disney and Hulu Ads Platform: Processing petabytes of data data
• ▪Design and implement scalable data pipelines using Apache Spark in Scala, to efficiently process large data volumes & ensure rapid data delivery.
• ▪Write and optimize SQL queries for data transformation and aggregation, ensuring high performance and scalability in complex data environments.
• ▪Develop ETL pipelines orchestrated with Airflow, reducing data processing time by 50% and enabling faster access to data-driven analytical insights.
• ▪Built data infrastructure and data lakes on AWS, utilizing services such as S3, Glue, and Athena to support cloud-based data solutions.
• ▪Led the migration of legacy on-prem data systems to AWS, implementing observability mechanisms to enhance data monitoring and system resilience.
• Exposure: SQL, Spark, Scala, Python, Snowflake, ETL, Airflow, Git, Jenkins

May 2023 – Dec 2023 · 7 mos · Seattle, Washington, United States · Hybrid

• Max Data & Analytics: Developing Data Engineering, Analytics and Business Intelligence solutions of Max Streaming App
• Design and Implement Semantic Layer Data Pipelines for Subscription (SVOD) for Max, Legacy HBO-MAX and Discovery+.
• Write optimized SQL queries in Databricks to build KPIs and metrics for assessing business performance and generating insights.
• Develop LookML models, Explores in Looker, for intuitive data visualization.
• Implement DBT models with incremental logic, streamlined data transformations and workflow automation and DBX workflows to enhance efficiency and scalability.
• Build ELT pipelines, using Airflow orchestration to create analytics layer.
• Technologies: SQL, Python, Looker, Databricks, DBT, ETL/ELT, Airflow, Git

Jul 2021 – Mar 2023 · 1 yr 8 mos · Hybrid

• Perfect Order Experience: Leading the Customer Experience (CX) Business Intelligence and Analytics Team.
• Build datasets from large multi-dimensional data sources into leaner and structured data tables using Python.
• Design databases and implement Data Warehousing for data storage in Redshift and analysis.
• Write SQL queries to retrieve data and formulate business critical metrics from various data clusters.
• Build end-to-end ETL pipelines and automating the process using AWS resources such as S3, Lake Formation, Step Function and Lambda.
• Create Tableau and Quicksight dashboards to evaluate, derive insights and drive strategic recommendations.
• Code scalable and efficient automations for large scale data processing and analysis.
• Amazon Transportation Services: Optimize Supply Chain
• Complete end to end automation for various processes inside ROC to foster quick resolution and reduce man hours on manual tasks.
• Writing complex SQL queries, on-boarding it to the ETL pipeline and streamlining the process
• Creating reports and dashboards for IXDs, Totes, RELO etc. in Tableau, Excel to have complete view of the trend over historical events and taking decisions on it.
• Working on process optimization and improving the forecast accuracy in Totes network for better scheduling.
• Building time series forecasting model to predict week ahead volume.Amazon Transportation Services: Optimize Supply Chain • Complete end to end automation for various processes inside ROC to foster quick resolution and reduce man hours on manual tasks. • Writing complex SQL queries, on-boarding it to the ETL pipeline and streamlining the process • Creating reports and dashboards for IXDs, Totes, RELO etc. in Tableau, Excel to have complete view of the trend over historical events and taking decisions on it. • Working on process optimization and improving the forecast accuracy in Totes network for better scheduling. • Building time series forecasting model to predict week ahead volume.

Feb 2021 – Jul 2021 · 5 mos

• Uber’s Analytics and Reporting:
• Drive WBRs and MBRs and gather insights on contributing factors of anomalies using Statistical Analysis.
• Create metrics and KPIs using SQL and automating the mechanism using Python
• Create dashboards and reporting using BI tools like Tableau & Data Studio.
• Implementing Python - Dash code to build a web dashboard to save costs of Tableau licenses for agents and non-executives of Uber.

Jul 2019 – Feb 2021 · 1 yr 7 mos

• Analyze data, gather insights using Power BI dashboards from different data sources through SQL and Python.

Jul 2016 – Jun 2019 · 2 yrs 11 mos

• Developing SQL queries for extracting data from Enterprise Discount Database
• (EDD). Code development in Python and Java to derive package pricing