Summary
Overview
Work History
Education
Skills
Certifications Training
Timeline
Generic

Shubham Gulwani

Pune

Summary

Results-driven Data Engineer with 5.5+ years of IT experience, specializing in Data Analytics, ETL Development, and Reporting. Expertise in Azure Synapse Analytics, Azure Data Factory (ADF), Alteryx, Power BI, SQL, and Azure Data Lake, with a strong focus on data extraction, transformation, and automation. Skilled in designing scalable ETL pipelines, optimizing data workflows, and reconciling large datasets (10M+ transactions). Exploring Databricks with PySpark for advanced data processing and analytics. Adept at creating insightful dashboards and ensuring data integrity to support data-driven decision-making. Strong experience in collaborating with clients and cross-functional teams to deliver high-quality data solutions.

Overview

6
6
years of professional experience

Work History

Senior Consultant

Ernst & Young Global Delivery Services
Pune
05.2022 - Current
  • Designed and developed scalable Azure Data Factory (ADF) pipelines to ingest, transform, and orchestrate data from APIs, SharePoint, SQL Server, and unstructured data sources into Azure Data Lake Storage (ADLS) in Parquet format with optimal partitioning
  • Implemented ETL/ELT frameworks in ADF and Synapse, ensuring efficient data transformation, error handling, and monitoring
  • Streamlined data reconciliation processes for high-volume datasets (10M+ transactions), achieving a 70% increase in efficiency while minimizing discrepancies and enhancing data integrity for analytics and reporting purposes
  • Developed Azure Synapse Analytics solutions for high-performance querying, data modeling, and real-time analytics
  • Optimized data workflows to reduce processing time and ensure cost efficiency by leveraging partitioning strategies, and indexing techniques
  • Used CI/CD pipelines using Azure DevOps, enabling automated deployments, version control for ADF and Synapse
  • Developed highly efficient SQL queries and stored procedures to enhance database performance and query optimization
  • Currently exploring on Azure Databricks with Py-Spark, developing scalable ETL pipelines for big data processing and advanced analytics
  • Collaborated with stakeholders to gather business requirements, design cloud data solutions, and implement best practices in data security and governance
  • Designed and optimized end-to-end Alteryx workflows for ETL, data blending, and advanced analytics, improving data processing efficiency by 40%
  • Created custom Alteryx macros and analytical apps, streamlining data transformation, parsing PDFs, and handling complex file formats
  • Implemented Data Quality and Validation Rules in Alteryx, ensuring data integrity and compliance with industry standards
  • Automated data extraction, transformation, and validation using Alteryx, Power BI, and Excel VBA, reducing manual effort by 50%
  • Developed Balance Sheet reconciliation workflows in Alteryx, integrating with Power BI for real-time financial analysis and reporting
  • Collaborated with cross-functional teams to enhance process automation, optimize ETL workflows, and improve data governance
  • Conducted Alteryx training sessions for new hires, enhancing team efficiency and adoption of best practices

Data Analyst

Infosys Ltd
Pune
03.2019 - 05.2022
  • Designed and optimized ETL workflows in Alteryx, automating data extraction, transformation, and loading (ETL) from SQL Server, XML, Excel, and CSV sources, improving data processing efficiency by 33%
  • Developed custom Alteryx macros and analytical apps, streamlining data reconciliation, validation, and transformation for large datasets
  • Implemented automated workflows with Alteryx Server, enabling scheduled execution, alert-based processing, and email notifications, reducing manual intervention by 50%
  • Created advanced Power BI reports and dashboards, integrating Alteryx workflows for real-time data refresh, leveraging DAX queries for deep business insights
  • Collaborated with cross-functional teams to optimize data pipelines, enhance process automation, and ensure compliance with industry standards

Education

Bachelor of Engineering - Electrical Engineering

Government College of Engineering,Karad
Satara, Maharashtra, India
05-2018

Skills

  • Alteryx
  • Azure Data Factory
  • Data Manipulation
  • Data analytics
  • SQL
  • Power BI
  • Data Blending and Transformation
  • Data visualization
  • Data Transformation
  • Problem solving
  • Team Collaboration
  • Data Parsing
  • Client collaboration
  • Attention to detail
  • Adaptability & Continuous Learning
  • Alteryx workflows
  • SQL query optimization
  • Data analysis
  • Workflow Optimization
  • Alteryx Designer
  • Azure Synapse
  • Azure Data Lake
  • Databricks
  • PySpark
  • T-SQL
  • Python
  • Alteryx Macros
  • Analytical Apps
  • ETL/ELT Pipelines
  • Performance tuning
  • Process Automation
  • Microsoft Fabric
  • Cross-functional teamwork
  • Process automation
  • Stakeholder collaboration
  • Multitasking and organization
  • Teamwork
  • Team collaboration
  • Power BI reporting
  • Data pipeline development
  • Proficient in Microsoft office
  • Cross-functional collaboration
  • Requirements gathering

Certifications Training

  • Alteryx Designer Advanced Certified
  • Alteryx Designer Core Certified
  • Microsoft Certified: Azure AI Fundamentals (AI-900)
  • Microsoft Certified: Azure Data Engineer Associate (DP-203)
  • Microsoft Certified: Azure Data Fundamentals (DP-900)
  • Microsoft Certified: Azure Fundamentals (AZ-900)
  • Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
  • Microsoft Certified: Power BI Data Analyst Associate

Timeline

Senior Consultant

Ernst & Young Global Delivery Services
05.2022 - Current

Data Analyst

Infosys Ltd
03.2019 - 05.2022

Bachelor of Engineering - Electrical Engineering

Government College of Engineering,Karad

Similar Profiles

CREATE PROFILE
Shubham Gulwani