Rahul Shah Email & Phone Number

Mumbai, Mh, In

Bengaluru, Karnataka, India

(Client : NIKE)✔ Set up SQL database on cloud servers to store client data for query analysis.✔ Applied statistical and algebraic techniques to interpret key points from gathered data.✔ Modeled predictions with feature selection algorithms.✔Implement One time Data Migration of multistate level data from SQL server to Snowflake by using Python and SnowSQL. Also developed data warehouse model in Snowflake.✔ Developed and analyzed complex SQL queries for extracting business insights, increasing decision-making efficiency by 30%✔ Responsible for creating Error Matrix Dashboard highlighting the issues (over 250+ test cases) on the platform, and monitoring various KPIs using Databricks, PySpark, SQL and creating a workflow for the same.✔ Identified and resolved cross-functional data quality issues, increasing data accuracy by 40%

✔ Automating Alert Emails for Data availability and Quality checks using PySpark and deploying on Airflow DAGs which helped the research team with client deliverables, reducing manual work by 80%.✔ Developed and maintained data pipelines using PySpark and Airflow to extract, transform, and load data from various sources into a centralized data warehouse (Amazon s3).✔ Built and maintained ETL workflows using Airflow to automate data processing, scheduling, and monitoring of data pipelines using Amazon EMR.✔ Developed and optimized complex SQL queries to extract data from databases and data lakes for analysis, visualization, and reporting purposes.✔ Responsible for creating Command Center Dashboard highlighting the issues(over 100+ test cases) on the platform, and monitoring various KPIs.

Goregaon, Maharashtra, India

Goregaon, Maharashtra, India

Mumbai, Maharashtra, India