Gaurav Wagle
Pune
Summary
Results-driven IT Professional skilled in BI Engineering and Data Platforms. Delivered scalable data solutions, optimised Azure Synapse Analytics, and implemented CI/CD pipelines. Led cross-functional teams, fostering collaboration through Agile methodologies. Drove platform modernisation and integrated AI-driven BI automation to enhance operational capabilities.
Overview
3
3
Languages
1
1
Certification
21
21
years of professional experience
Work History
Team Lead - Azure Data Engineer
Tata Consultancy Services Ltd
Pune, Maharashtra
03.2018 - Current
- Designed and orchestrated batch and streaming pipelines with Microsoft Fabric and Synapse processing 10m+ records/day.
- Optimised Synapse SQL pools using partitioning, materialised views, and caching.
- Deployed CI/CD pipelines with Azure DevOps and parameterised ADF using Key Vault secrets.
- Migrated critical SQL datasets to Azure Analysis Services semantic modelling.
- Built bronze, silver, and gold zones in Azure Data Lake with Delta Lake.
- Implemented governance with RBAC ACLs and data quality checks for dashboards.
- Partnered with analytics teams to deliver Power BI datasets reducing load times by 60%.
- Managed application lifecycle management over 17+ years.
- Administered Improve SaaS platform performance and reliability through timely issue handling.m and Azure infrastructure for 7+ years.
- Designed scalable, resilient, and secure orchestration and data validation frameworks.
- Applied Python, Databricks Spark, and SQL modelling using PySpark, Scala and Spark SQL.
- Built Delta Lake notebooks and job orchestration for lakehouse workloads.
- Optimised data pipelines across ADLS Gen2, Delta, and Parquet formats with ADF.
Technical Project Manager
Fino PayTech Ltd
Navi Mumbai, Maharashtra
05.2011 - 03.2018
- Managed project plans, resources, and progress using Azure DevOps/VSTS.
- Defined scope, timelines, and deliverables for banking and insurance solutions, ensuring alignment with client expectations.
- Delivered weekly status reports, managed change requests, and conducted client demos to ensure stakeholder engagement and project transparency.
- Oversaw CI/CD pipelines for IIS deployments and ensured smooth releases.
- Reviewed and optimised architecture for WinForms and ASP.Net applications, enforcing SOLID principles to enhance maintainability.
Senior Software Engineer
Senior Software Engineer – Andromeda
Mumbai
12.2010 - 04.2011
- Developed and maintained web-based CRM systems using ASP.NET (Web Forms), enhancing user experience and system reliability.
- Developed server-side components using ASP.NET (C# / VB.NET), CRM customisation.
- Customized on-premise CRM platforms, optimising Forms, Entities, and Workflows for improved functionality.
- Worked extensively with SQL Server; developed stored procedures, triggers, views; handled data normalization and basic reporting queries.
- Optimised SQL queries and stored procedures.
- Developed reports with SQL Server Reporting Services (SSRS) and Crystal Reports, providing actionable insights for stakeholders.
- Developed utilities for bulk data uploads (CSV, Excel).
- Performed ETL-like operations through batch jobs and scheduled scripts.
- Designed user interfaces using HTML 4 / HTML 5 (early adoption), CSS 2 / basic CSS 3, JavaScript.
- Key modules built: Customer Master, Contact Management, Lead tracking, Support ticketing.
- Performed manual testing (limited automation).
Engineer
Engineer – Spanco Ltd
Mumbai
03.2009 - 11.2010
- Designed and developed CRM solutions tailored to specific business requirements, enhancing user engagement.
- Extended CRM functionalities with plugins, scripts, and APIs to improve system capabilities and user experience.
- Tailored CRM modules for Sales, Service, and Marketing to meet specific organisational needs.
- Configured CRM dashboards and reports to provide insightful data visualisations for decision-making.
- Integrate CRM with external systems (ERP, billing, websites, APIs).
- Developed and consumed web services to facilitate data exchange between systems.
- Ensured seamless data flow between CRM and external platforms to maintain data accuracy.
- Designed comprehensive data models and established relationships within the CRM for optimal data organisation.
- Executed data migration, cleansing, and transformation processes to ensure data quality and integrity.
- Maintained data integrity and consistency while implementing security measures within the CRM.
- Optimised queries and storage for large datasets, ensuring efficient data retrieval and management.
Software Engineer
Software Engineer – Spanco Respondez BPO
Mumbai
02.2008 - 11.2008
- Designed, developed, and customised CRM solutions to meet specific business requirements.
- Integrated CRM with external systems including ERP, billing, websites, and APIs to enhance data connectivity.
- Developed and consumed web services to facilitate data exchange between applications.
- Ensured seamless data flow between platforms to facilitate real-time information exchange.
- Executed data migration, cleansing, and transformation tasks to ensure accurate data in CRM.
- Ensure data integrity, consistency, and security.
- Optimized database queries and storage solutions to enhance performance for large datasets.
- Configured CRM entities, forms, workflows, dashboards, and reports to streamline user experience.
- Extend CRM functionalities using plugins, scripts, and APIs.
- Customize modules like Sales, Service, Marketing, etc.
- Design data models and relationships within the CRM.
Software Engineer
Software Engineer – Greytrix India Pvt Ltd
Mumbai
12.2006 - 02.2008
- Design and develop ETL pipelines for migration.
- Extract data from legacy ERP.
- Transform data using scripts/tools (SQL).
- Load data into target ERP system.
- Led migration planning and analysis efforts to ensure successful data transfer between systems.
- Analyse source ERP and target ERP systems (data structures, modules, workflows).
- Understand business processes and map them across systems.
- Defined migration strategy (Big Bang / Phased / Parallel run) to optimise data transfer process.
- Identify data scope (master data, transactional, historical).
- Created detailed source-to-target data mapping documents to facilitate accurate data migration.
- Define transformation rules (format changes, validations, aggregations).
- Work with data models, field types, and business logic.
- Ensured compatibility with target ERP schema to maintain data integrity during migration.
- Identify and remove duplicate, invalid, or obsolete data.
- Standardize and enrich datasets before migration.
- Perform pre-migration data quality checks.
- Execute trial migrations (mock runs).
- Perform final production migration (cutover activity).
- Monitor migration jobs and resolve failures.
- Ensure minimal downtime during migration.
Graduate Engineer
Graduate Engineer – Standard Alkali
Navi Mumbai
03.2005 - 01.2006
- Develop, configure, and maintain PLC, DCS, and SCADA programs.
- Monitored and optimised control loops to enhance process efficiency.
- Troubleshot faulty instruments and control systems to restore functionality.
- Plan and execute preventive and corrective maintenance schedules.
- Perform routine calibration of instruments such as pressure, temperature, flow, and level.
- Optimize instrument accuracy and response time.
- Monitor real-time process parameters and control system performance.
- Implement alarms, interlocks, and safety logic as per design standards.
- Perform firmware and software upgrades of control systems.
- Analysed deviations and implemented corrective actions to improve system reliability.
- Ensure compliance with industrial standards such as ISA, ISO, and IEC.
- Maintain and manage Safety Instrumented Systems (SIS).
- Updated calibration records regularly to ensure accuracy and compliance, reports, and certificates.
- Assisted in hazard analysis activities to identify potential risks activities including HAZOP studies.
- Ensure explosion-proof installations and hazardous area compliance.
Education
Bachelor of Engineering - Instrumentation
North Maharashtra University
01-2004
Skills
- Microsoft Fabric
- Azure Synapse Analytics
- Data Factory
- Databricks
- ADLS Gen2
- Delta Lake
- Spark SQL
- PySpark
- Python
- Scala
- SQL optimization
- Data warehousing
- Data modeling
- Cloud architecture design
- Automated data workflows
- Data integration strategies
- DataOps best practices
- CI/CD with Azure DevOps
- BI tool optimisation
- Data issue resolution
- Stakeholder engagement
- Data project methodologies
- Cloud service management
Languages
English
Upper Intermediate
B2
Hindi
Upper Intermediate
B2
Marathi
Advanced
C1
Certification
- Microsoft Certified: Azure Data Fundamentals
- Microsoft Certified: Azure Database Administrative Associate
Accomplishments
- Reduced query latency by 30% through Synapse optimization.
- Improved Power BI performance by 60% via migration to Azure Analysis Services.
- Successfully migrated legacy BI systems to Azure cloud-native architecture.
- Delivered automation opportunities across data platforms, enhancing operational efficiency.
Custom
- Manage stakeholder relationships across multi-role, multi-location technical teams, ensuring alignment of priorities and smooth communication.
- Oversee daily operations, capacity planning, performance monitoring, and production support for BI and Azure-based applications.
- Lead teams providing L2 and L3 support for BI, Azure, Power BI and related applications.
- Design, implement, and improve frameworks for Medallion Data Engineering in Microsoft Fabric.
- Guide process improvement initiatives, introducing automation and efficiency enhancements across data platforms.
- Plan and execute support schedules, including application patching, installation, configuration, and upgrades.
- Drive team performance through coaching, training, and recognition of achievements.
- Identify opportunities for modernization and migration to cloud-native architectures, ensuring scalability and resilience.
Interests
- Reading books
- Swimming
- Travelling
Timeline
Team Lead - Azure Data Engineer
Tata Consultancy Services Ltd
03.2018 - Current
Technical Project Manager
Fino PayTech Ltd
05.2011 - 03.2018
Senior Software Engineer
Senior Software Engineer – Andromeda
12.2010 - 04.2011
Engineer
Engineer – Spanco Ltd
03.2009 - 11.2010
Software Engineer
Software Engineer – Spanco Respondez BPO
02.2008 - 11.2008
Software Engineer
Software Engineer – Greytrix India Pvt Ltd
12.2006 - 02.2008
Graduate Engineer
Graduate Engineer – Standard Alkali
03.2005 - 01.2006
Bachelor of Engineering - Instrumentation
North Maharashtra University