Keshav Nirwan
ETL Developer
Ghaziabad
Summary
More than 9 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server Integration Services and Azure Data Factory in Development, Test and Production Environments in banking domain.
Overview
9
9
years of professional experience
2
2
Languages
Work History
Senior ETL Developer
Genpact
10.2023 - Current
- Translated technical concepts and information into terms parties could easily comprehend.
- Working on ADF (Azure Data Factory) and SSIS (SQL Server Integration Services) for data integration, transformation, and workflow orchestration
- Integrate ADF pipelines with other Azure services such as Azure Synapse Analytics, Azure SQL Database, Azure Blob Storage, etc.
- Configure ADF pipelines to replicate the data movement and transformation logic from existing SSIS packages.
- Validate the data integrity and accuracy after migration by comparing the output of ADF pipelines with the original SSIS packages.
- Migrated legacy applications to the Azure cloud platform, resulting in increased flexibility and reduced operational costs.
SQL and SSIS Developer (Technical Lead)
Accenture
1 2020 - 09.2023
- Operational Data Store is a type of database designed to integrate data from multiple data sources used for regulatory reporting.
- Enhanced data accuracy by optimizing SSIS packages and implementing data validation techniques.
- Streamlined ETL processes for faster data extraction, transformation, and loading.
- Maintained complex T-SQL queries, views and stored procedures in multi-database environment with little supervision.
- Analyzed existing SQL queries to identify opportunities for improvements.
SSIS Developer
Tata Consultancy Services
2 2016 - 12.2019
- TCS has started a new joint venture with Royal Bank Of Scotland to support and extend help on the Technical/Technological front
- Analyzing the existing structure and providing the solution and enhancement to the system and created the estimation plans.
- Interaction with the clients to gain the functional knowledge.
- Coding in SSIS and MS SQL (complex programming queries. SPs).
- Designing, creating and scheduling MS SQL jobs.
- Created functions, procedure and tables in MS-SQL
SharePoint and .net Developer
Tata Consultancy Services
12.2014 - 12.2015
- Developed timer job for the movement of data from World Bank Inranet Site (PPF) to World Bank Internet Site.
- Developed timer job for pushing PDF file generated from World Bank Inranet Site (PPF) to WB Docs (World Bank Database).
- Converted PDF files from World Bank Database into html files then extracting the data from html and feed to the new developed Intranet Site called Policy Procedure Framework(PPF)
- Developed PDF Convertor module to export user filled form data to PDF using iTextSharp.
Education
Bachelor of Engineering (Information Technology) -
Krishna Engineering College
Ghaziabad, Uttar Pradesh12th - undefined
Schiller Institute
Ghaziabad, Uttar Pradesh10th - undefined
Schiller Institute
Ghaziabad, Uttar PradeshSkills
SSDTControl-MJIRAMS SQL Server 2012/2016
Azure Data Factory
Azure Storage
Extracurricular Achievements
- Worked as an Information Security coordinator in the Project.
- Participated and volunteered in 4 days Global Spirituality Mahotsav organized by Ministry Of Culture , hosted at Kanha Shanti Vanam, World Headquarters of Heartfulness, Telagana
Timeline
Senior ETL Developer
Genpact
10.2023 - Current
SharePoint and .net Developer
Tata Consultancy Services
12.2014 - 12.2015
SQL and SSIS Developer (Technical Lead)
Accenture
1 2020 - 09.2023
SSIS Developer
Tata Consultancy Services
2 2016 - 12.2019
Bachelor of Engineering (Information Technology) -
Krishna Engineering College
12th - undefined
Schiller Institute
10th - undefined
Schiller Institute