Gaurav Gupta
Bengaluru
Summary
- Gaurav has 12+ years of experience with two plus years of experience in BI Data Architect and three plus years of experience in managing and leading DW/BI efforts and master data management solutions from requirement gathering to its implementation using Agile methodologies be it on premises, Cloud only or hybrid.
- Expertise in data modelling and data warehouse in Synapse, Azure SQL, SQL DB.
- Over 4+ year of hands-on experience of Azure services - Azure SQL (DB and DWH), Azure Storages, USQL, Data Lake, Data Factory, Azure Data Bricks and Event Hub, Azure Synapse, Azure function.
- Migrated on premise SSIS packages to Azure using Lift & Shift.
- Expertise in creating dynamic pipeline in Azure Data Factory v2 with Azure Data Lake Store Gen2 and BLOB Storage.
- Proficient in writing SQL queries and stored procedures with a view to maximize performance.
- Profound accomplishments in generating reports from a relational database by using SQL Server Reporting Services (SSRS), tableau, developing ETL packages using SSIS.
- Expertise in Developing and Extending MS SQL Server Analysis Services 2008 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
- MS SQL Server database administration, including configure Scheduled Tasks for regular Database Backup and created Maintenance Plan Activities like Rebuild indexes, reorganizing indexes, update statistics, shrink Database etc. using SSIS.
- Hands on experience on Image classification using Python, to find defect on wind turbine blades.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Sr. Principal Data Architect
KPI Partners, Applied Material
03.2020 - Current
- Design and Develop Cloud Data Solutions from SAP Hana, Dynamics 365, PL/SQL and Image Data to Azure services and Power BI.
- Lead analysis, architecture, design, and development of data warehouse and business intelligence solutions.
- Environment: Azure Data Factory v2, Azure Synapse Analytics, Azure SQL DB, IOT Central, Power BI, Logic Apps, DevOps (CI/CD), Azure Data Bricks, Dynamics 365, Azure Function, Azure Chat Bot.
Principal Data Architect
KPI Partners, FireEye
01.2019 - 02.2020
- Design and Development of Cloud Analytics Data warehouse from Oracle EBS, PL/SQL and Salesforce to Azure services and Power BI.
- Environment: Azure Data Factory v2, Azure SQL Data warehouse Gen2, Azure SQL DB, Azure Analysis Service, Oracle, Salesforce, Power BI, Logic Apps, DevOps (CI/CD), Azure Data Bricks.
Deputy Manager
Suzlon Energy Limited
10.2018 - 12.2018
- Design and Development of Data Collector which pulls onshore and offshore turbine data from around the world and push into Azure SQL DW.
- Environment: SQL 2012, SSIS, SSRS, SSAS, Azure Services.
SQL BI Consultant
Siemens Wind Power
06.2016 - 10.2018
- Design and Development of Data Collector which pulls onshore and offshore turbine data from around the world and push into DWH farm.
- Process involves different level of data mining and data cleansing.
- Environment: SQL 2016, MSBI, Power BI, APS (PDW), Azure Data Factory V2, Azure Data Lake Store, USQL, Azure Stream Analytics, Azure SQL DW, Python - Deep Learning, USQL.
Lead Consultant
ITC Infotech, IPSL
02.2015 - 05.2016
- Migration project where an existing framework called PIE has been replaced by AIR.
- The PIE System was deployed on SQL Server 2000 and AIR was on SQL Server 2012.
- In addition, process involved several developments assignments like (AIR Reconciliation Barclays MI Audit, Barclays POL MI DB, Etc.)
- Environment: Data Tools 2012, SQL Server, TFS, VS 2012.
Senior SQL Developer
Alacrity E Commerce Solution Pvt. Ltd, Gogotech Inc
05.2014 - 01.2015
- Gogotech is an E commerce business solution located in USA. This covers over 60 major consumer electronics brands are available on FactoryOutletStore, including products that range from Telecommunications and GPS to Fitness, Personal Care and Pet Supplies.
- Environment: BIDS 2008 R2, SQL Server 2005.
SDE
Aditi Technologies, Microsoft
04.2012 - 04.2014
- This Project is developed to handle 150 + data sources, which includes three types of data pull.DB Pull, File Pull, Web Pull.
- Environment: Rhino ETL, My SQL, SQL Server 2008 R2, BIDS 2008 R2, Snap logic.
Software Engineer
i-fact Technologies Pvt. Ltd.
01.2010 - 02.2012
- This project was developed to track Customer Relation in and Out insurance information across India.
- Environment: SQL Server 2008, SSRS, SSIS.
Education
Master's - computer application
Nagpur University
India01-2010
Bachelor's - Computer Science
PRSS University
India01-2007
Skills
- T-SQL
- SSIS
- SSRS
- PDW
- SSAS
- Azure Data Factory V2
- Logic Apps
- Power BI
- Tableau
Certification
- 70-776 Big Data Engineering on Microsoft Cloud Services
- 70-767: Implementing Data warehouse
- 70-761: Querying Data with Transact-SQL
- 70-762: Developing SQL Databases
- WIELY Certified R Programmer
Competency Applications
- T-SQL
- SSIS
- SSRS
- PDW
- SSAS
- Azure Data Factory V2
- Logic Apps
- Power BI
- Tableau
Technology Snapshot
SQL Server, MySQL, APS (PDW), Azure SQL DW, MSBI, Data Tools, Rhino ETL, Snap logic, Azure Services (ADF V2, ADLS, Azure Stream Analytics), Windows Server 2012
Timeline
Sr. Principal Data Architect
KPI Partners, Applied Material
03.2020 - Current
Principal Data Architect
KPI Partners, FireEye
01.2019 - 02.2020
Deputy Manager
Suzlon Energy Limited
10.2018 - 12.2018
SQL BI Consultant
Siemens Wind Power
06.2016 - 10.2018
Lead Consultant
ITC Infotech, IPSL
02.2015 - 05.2016
Senior SQL Developer
Alacrity E Commerce Solution Pvt. Ltd, Gogotech Inc
05.2014 - 01.2015
SDE
Aditi Technologies, Microsoft
04.2012 - 04.2014
Software Engineer
i-fact Technologies Pvt. Ltd.
01.2010 - 02.2012
Master's - computer application
Nagpur University
Bachelor's - Computer Science
PRSS University