Nishant Agarwal

module lead

marsh•  May 2021 - July 2022

In this job role, I created an Azure data lake solution and used data cleaning procedures to improve data quality. I designed solution for recording EventHub events and sending them to Azure Synapse via Azure Stream Analytics. I fulfilled ETL solution needs by creating reusable Pyspark scripts in databricks and linked an Azure DF pipeline to orchestrate data into an Azure Synapse SQL pool. I provided weekly and monthly updates to stakeholders on project status and hazards, while identifying and resolving project hazards and roadblocks. Major Achievements: • Won award for operating show with 50% of desired team capacity. • Decreased 26% database load by modifying table design structures and refining queries. • Successfully completed onboarding of new team members in less than two weeks and provided Azure knowledge transfer to team members. • Directed seven-member team to complete project requirements on schedule.

consultant

Deloitte•  September 2018 - April 2021

During this tenure, I used Informatica BDM to establish reusable design framework for mass ingestion, as well as to collect requirements, conduct reviews, and create Azure Integration framework. I designed ingestion of structured data into Azure data lakes, Azure blob storage, and unstructured data into Azure EventHub and Informatica big data. I confirmed successful completion of KT transfer and project handover from external team. I also produced an audit logging framework using BDM and Unix scripts. Prominent Accomplishments: • Reduced 70% development time by establishing framework to automatically build parameter file. • Maximized 90% data accuracy / efficiency by automating manual data reconciliation process between different sources. • Added numerous reusable generic data factory data flows; saved development time by up to 50%. • Contributed efforts in FTL design and implementation across workflow reporting modules. • Earned recognition as technology stack SME for project and driving modules independently.

application developer analyst

accenture•  November 2016 - September 2018

Over this course of employment, I built source and target mapping data analysis and technical documentation. I established Workflows / Mapping to ingest data from many sources, including Hive, Flat-file, MSSQL Server, and Oracle databases, and processed it for reporting purposes. Basic Contributions: • Addressed source data problems and redesigned transformation rules. • Automated ETL operations for making data manipulation easier and lowering time by up to 40%.

Software Engineer

Cognizant Technology Solutions•  May 2016 - October 2016

In this period, I utilized ETL tools and programming / scripting languages to construct, test, integrate, and deploy ETL processes. I evaluated assigned tickets and provided estimated resolution time. I complied with agreed-upon SLA to acknowledge ticket Incident / service request. Key Attainments: • Delivered L1 and L2 support and reduced 20% ticket counts by redesigning ETL process. • Implemented data quality rules and removed data quality issues by 30% by enabling exception handling framework. • Acquired in-depth knowledge of Informatica PowerCenter and data quality for project requirements.

project engineer

Wipro Technologies•  February 2014 - May 2016

In this period, I utilized ETL tools and programming / scripting languages to construct, test, integrate, and deploy ETL processes. I evaluated assigned tickets and provided estimated resolution time. I complied with agreed-upon SLA to acknowledge ticket Incident / service request. Key Attainments: • Delivered L1 and L2 support and reduced 20% ticket counts by redesigning ETL process. • Implemented data quality rules and removed data quality issues by 30% by enabling exception handling framework. • Acquired in-depth knowledge of Informatica PowerCenter and data quality for project requirements.