Pranav Maheshwari Email & Phone Number

Texas, United States

• Applied the BADIR framework to drive actionable insights and effi cient decision-making for clients, resulting in a 10X faster generation of insights and a 20X impact by focusing on top drivers.• Engineered a scalable, robust ETL pipeline using AWS Glue, Redshift, and Appfl ow, reducing costs by 75% and completing the project in 2 months, well ahead of the 3.5-month deadline.• Automated and orchestrated ETL processes with Managed Workfl ows for Apache Airfl ow (MWAA), implementing… Show more • Applied the BADIR framework to drive actionable insights and effi cient decision-making for clients, resulting in a 10X faster generation of insights and a 20X impact by focusing on top drivers.• Engineered a scalable, robust ETL pipeline using AWS Glue, Redshift, and Appfl ow, reducing costs by 75% and completing the project in 2 months, well ahead of the 3.5-month deadline.• Automated and orchestrated ETL processes with Managed Workfl ows for Apache Airfl ow (MWAA), implementing Slowly Changing Dimensions (SCDs), and creating a data warehouse in S3 buckets, achieving a 6-fold reduction in daily processing time.• Extracted and Integrated diverse data sources, via APIs, improving data accessibility and reducing data integration time.• Conducted in-depth revenue and trend analyses, enhancing data visualization and performing exploratory data analysis (EDA), driving a 20% increase in actionable insights through collaboration with data analysts. Show less

Bangalore

• Utilized Google Cloud Storage (GCS) and Dataproc clusters to design and implement PySpark-based ETL and data analysis pipelines, ensuring efficient data processing and storage, resulting in a 30% cost reduction.• Orchestrated complex workflows and scheduled ETL jobs using GCP Composer to manage Apache Airflow DAGs, ensuring seamless data pipeline automation.• Executed complex SQL queries to extract, manipulate, and analyze data from ClickHouse and Postgres, providing valuable insights… Show more • Utilized Google Cloud Storage (GCS) and Dataproc clusters to design and implement PySpark-based ETL and data analysis pipelines, ensuring efficient data processing and storage, resulting in a 30% cost reduction.• Orchestrated complex workflows and scheduled ETL jobs using GCP Composer to manage Apache Airflow DAGs, ensuring seamless data pipeline automation.• Executed complex SQL queries to extract, manipulate, and analyze data from ClickHouse and Postgres, providing valuable insights for decision-making.• Applied data visualization and exploratory data analysis (EDA) techniques in Superset, uncovering trends and patterns in large datasets to support data-driven decision-making.• Processed large volumes of data using Kafka and Spark structured streaming, optimizing data pipelines for real-time analytics. Show less

Navi Mumbai, Maharashtra, India

• Increased data processing efficiency through techno-functional expertise in the BI Analytics Team, enabling faster data-driven decision-making.• Solved complex data engineering challenges by leveraging PySpark, SQL, and SAP HANA.• Streamlined data pipeline execution by scheduling jobs and workflows with Apache Airflow and Azkaban, ensuring timely data availability.• Possess expertise in various data warehouse technologies, facilitating comprehensive data analysis.• Created… Show more • Increased data processing efficiency through techno-functional expertise in the BI Analytics Team, enabling faster data-driven decision-making.• Solved complex data engineering challenges by leveraging PySpark, SQL, and SAP HANA.• Streamlined data pipeline execution by scheduling jobs and workflows with Apache Airflow and Azkaban, ensuring timely data availability.• Possess expertise in various data warehouse technologies, facilitating comprehensive data analysis.• Created clear and actionable insights for stakeholders through data visualization and advanced Excel dashboards. Show less