Gurpreet Singh Katyal
Mumbai
Summary
Eager to leverage my 16+ years in Data Engineering, with specialization in Azure's Data ecosystem and Python. Excited about crafting data driven solutions to improve business processes significantly. Most notably, architecting a cloud-based data warehousing solution to increase the efficiency of data retrieval
Overview
18
18
years of professional experience
1
1
Certification
Work History
Senior Azure Cloud Architect
Capgemini
06.2020 - Current
- Extensively used Agile Scrum methodology for development
- Delivered data pipelines to extract and ingest data into data lake from various sources using serverless architecture
- Azure Data Factory, Azure Functions, Azure Service Bus in Azure. Ensured that data is preprocessed and building models to generate BI reports
- Extensively used Databricks for data engineering and analytics including Spark SQL
- Extensively used SQL Azure and Azure SQL DWH/Azure Synapse Analytics for database needs
- Extensively used Logic apps and Functions for designer workflow and compute needs
- Extensively used Azure DevOps, Git
- Mapped client requirements and providing best solutions
- Handled requirement analysis, designing, prototype development and testing activities for the products
- Conducted system study and collaborating/coordinating with team members for requirements mapping, system design, development, integration, implementation, etc
- Participated in solution discussion and implementation plan
- Maintained the technical documents, quality manual and standard operating procedures for the complete project
- Delivered and implementing the project as per scheduled deadlines
- Mentored and guiding a team of 10 team members
Azure Cloud Architect
Capgemini
07.2019 - 06.2020
- Extensively used Agile Scrum methodology for development
- Delivered data pipelines to extract and ingest data into data lake from various sources using serverless architecture
- Azure Data Factory, Azure Functions, Azure Service Bus in Azure. Ensured that data is preprocessed and building models to generate BI reports
- Extensively used Databricks for data engineering and analytics including Spark SQL
- Extensively used SQL Azure and Azure SQL DWH/Azure Synapse Analytics for database needs
- Extensively used Logic apps and Functions for designer workflow and compute needs
- Extensively used Azure DevOps, Git
- Mapped client requirements and providing best solutions
- Handled requirement analysis, designing, prototype development and testing activities for the products
- Conducted system study and collaborating/coordinating with team members for requirements mapping, system design, development, integration, implementation, etc
- Participated in solution discussion and implementation plan
- Maintained the technical documents, quality manual and standard operating procedures for the complete project
- Delivered and implementing the project as per scheduled deadlines
- Mentored and guiding a team of 6 team members
MSBI Technical Project Manager
Capgemini
10.2016 - 05.2019
- Extensively used Agile Scrum methodology for development
- Delivered ETL(s) to extract and ingest data into datawarehouse from various sources using MS SSIS
- Ensured that data is preprocessed and built models to generate BI reports
- Extensively used MS SQL Server for database needs
- Extensively used JIRA, VSTS
- Mapped client requirements and providing best solutions
- Handled requirement analysis, designing, prototype development and testing activities for the products
- Conducted system study and collaborating/coordinating with team members for requirements mapping, system design, development, integration, implementation, etc
- Participated in solution discussion and implementation plan
- Maintained the technical documents, quality manual and standard operating procedures for the complete project
- Delivered and implementing the project as per scheduled deadlines
- Mentored and guiding a team of 4 team members
MSBI Technical Lead
Capgemini
06.2014 - 09.2016
- Extensively used Agile Scrum methodology for development
- Delivered ETL(s) to extract and ingest data into datawarehouse from various sources using MS SSIS
- Ensured that data is preprocessed and built models to generate BI reports
- Extensively used MS SQL Server for database needs
- Extensively used JIRA, VSTS
- Mapped client requirements and providing best solutions
- Handled requirement analysis, designing, prototype development and testing activities for the products
- Conducted system study and collaborating/coordinating with team members for requirements mapping, system design, development, integration, implementation, etc
- Participated in solution discussion and implementation plan
- Maintained the technical documents, quality manual and standard operating procedures for the complete project
- Delivered and implementing the project as per scheduled deadlines
- Mentored and guiding a team of 4 team members
MSBI Technical Lead
Accenture
08.2012 - 06.2014
MSBI Senior Developer
Tata Consultancy Services
03.2010 - 07.2012
MS.Net Junior Developer
Idealake Information Technologies
02.2008 - 07.2009
MS.Net Junior Developer
K-Bridge
02.2007 - 01.2008
Education
Bachelor of Technology - Information Technology
Uttar Pradesh Technical University
India09.2006
Skills
- Azure Data Factory
- Azure Databricks
- Azure Data Lake
- Azure Synapse
- Azure SQL
- Azure Cosmos DB
- Application Insights
- Azure Monitoring
- Azure Blob Storage
- Azure Disk Storage
- Azure Queue Storage
- Azure File Storage
- Azure Table Storage
- ARM templates
- Key Vault
- Azure Stream Analytics
- Azure Event Hubs
- Azure Service Bus
- Azure Function
- Azure App
- Azure Logic Apps
- Python
- PySpark
- SparkSQL
- C#
- PowerShell
- Azure DevOps
- JIRA
- MS SQL Server
- MS Access
- My SQL
- Oracle 10G
- Agile Scrum
- Waterfall
- Snowflake
- MS Power BI
- MS SSIS
- MS SSRS
- MS SSAS
- MS Net
Certification
- Capgemini: Architect L2 Level, 2024
- Capgemini: Engagement Manager L0 Level, 2023
- Microsoft Certified: Azure Data Engineer Associate, 2022
Others
Trainings : MS Fabric, Safe Agile Scrum
Pre Sales: Experience working in RFP(s) (Pre Sales) in terms of solutioning, architecture, estimations, etc.
SME Support : Experience in providing SME support to the project(s) under escalations
Interviews : Experience in taking interviews
Conducting Sessions : Experience in conducting various technical sessions across organization
Timeline
Senior Azure Cloud Architect
Capgemini
06.2020 - Current
Azure Cloud Architect
Capgemini
07.2019 - 06.2020
MSBI Technical Project Manager
Capgemini
10.2016 - 05.2019
MSBI Technical Lead
Capgemini
06.2014 - 09.2016
MSBI Technical Lead
Accenture
08.2012 - 06.2014
MSBI Senior Developer
Tata Consultancy Services
03.2010 - 07.2012
MS.Net Junior Developer
Idealake Information Technologies
02.2008 - 07.2009
MS.Net Junior Developer
K-Bridge
02.2007 - 01.2008
Bachelor of Technology - Information Technology
Uttar Pradesh Technical University
Similar Profiles
Abdoul-rahim DombaAbdoul-rahim Domba
Ingénieur d'études et de recherche at CapgeminiIngénieur d'études et de recherche at Capgemini
Bélinda BONACINABélinda BONACINA
Document Management, quality and configuration at CAPGEMINIDocument Management, quality and configuration at CAPGEMINI
Namrata DwivediNamrata Dwivedi
Front End Developer at CapgeminiFront End Developer at Capgemini