Summary
Overview
Work History
Education
Skills
Accomplishments
Timeline
Generic

DIVESH AGARWAL

Louisville,KY

Summary

14 Years of deep understanding and proficiency working with database and data warehouse technologies and systems. Responsive expert experienced in monitoring database performance, troubleshooting issues and optimizing database environment. Possesses strong analytical skills and excellent problem-solving abilities.

Overview

14
14
years of professional experience

Work History

Sr Azure Database Engineer

TCS - Humana Inc
09.2023 - Current
  • Develop stored procedures in SQL Server to perform file processing operations in Data pipelines.
  • Working with TSQL queries and DAX queries to perform analytics and reporting.
  • Working with Hash tables and Global Hash tables to increase query performance.
  • Extensive experience working with JSONs and JSON Queries to handle REQUESTS and RESPONSES from Web UI.
  • Developed Data Model to serve near real time Operational Data Reporting.
  • Implemented best practices in Stored procedures and query writings to provide SLA which are in seconds.
  • Worked with Change Tracking features to perform Data Sync between Azure SQL Database and Data Mart in Databricks.
  • Develop ETL pipelines using Azure Data Factory and execute stored procedures.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
  • Implement CI/CD to perform automated DB Deployments with Azure ADO and Visual Studio DacPac solutions.
  • Perform Agile delivery and follow Scale Agile principles.

Solution Architect/ Data Architecture - Data and Analytics

TCS - Quest Diagnostics - Multi Project - Informatics Application/ESP Cloud Migration
07.2021 - 08.2023
  • Assess and evaluate existing on-premise environment of applications.
  • Worked with customers or prospective customers to develop integrated solutions and lead detailed architectural dialogues to facilitate delivery of comprehensive solution.
  • Develop target state architecture to meet customer security and data needs
  • Presented roadmap and technology infrastructure to customers, demonstrating deep familiarity with APIs, platform infrastructure, security and integration capabilities.
  • Prepare Business Case to explain need and benefits for required change
  • Workshop and collaboration with Technology specialists from vendor and customer to reduce risks
  • Prepare Risk register for forward planning and discussions
  • Strategize migration of data and its security both during transit and at rest
  • Work with Application Team and customer management to prepare SOW for the scope of work
  • Responsible for preparing data models for efficient use of Snowflake capabilities for migration of on-premises data
  • Lead end-to-end implementation and delivery of application migration to Azure cloud
  • Develop data pipelines for data migration from on premise to Azure Storage/Azure SQL Server
  • Helped in implementation of different deployment models of SQL server Azure SQL DB, Azure SQL MI, Azure SQL on VM's
  • Creating User profiles and roles in Azure SQL server.
  • Test Cases preparation and validations performed before Go Live
  • Develop factory model for CI/CD implementation for application migrations using Gitlab and Ansible
  • Daily and Weekly Status reporting and sharing project timelines with business and higher management
  • Present Project status in monthly steering committee involving CxO's.

Senior Database Developer/Senior ETL Developer

TCS - Quest Diagnostics - Informatics Application
06.2017 - 06.2020
  • Develop stories and prepare tasks in CA Rally for Agile delivery of projects
  • Responsible for end-to-end delivery of large-scale projects
  • Working with Compliance and Data Governance team to identify and resolve issues in data warehouse
  • Rapid building of data pipelines to ingest COVID data from heterogeneous systems
  • Automated shell scripts for continuous ingestion of COVID data and install alert mechanism for any failures
  • Develop Tableau dashboards for dynamic reporting on COVID numbers for higher management and Govt offices
  • Enhanced existing ETL jobs and workflows to make them GDPR/DAARD/EU compliant
  • Developed logic and implemented ETL jobs to preprocess partial accessions from Lab Systems
  • Build translation jobs in house to be able to remove dependency on legacy code built in COBOL/Mainframe and hence decommission
  • Prepared a dynamic dashboard for Business to monitor performance of Sales Team based on number of orders submitted electronically
  • Integrated Big Data platform with DataStage for exchange of data between two systems.
  • Extensively worked in PL/SQL to develop stored procedures for UI functionalities.
  • Developed stored procedures to serve API calls from different systems.
  • Worked on complex queries to perform Analytics using Analytical queries and pivot operations.
  • Performance tuning of DB queries and applying fixes to resolve issues.
  • Worked on HIVE queries and tables to perform heavy processing and make it available to downstream systems
  • Standardized Data Ingestion process of new labs and billing systems with help of checklist
  • Prepared Implementation plans for monthly statistics update on all tables required
  • Worked on team strategy to maintain codes in different branches in Gitlab and documented process
  • Mentor team and guide them for any technical and application related help
  • Knowledge on payor, provider and other terminologies included in LifeScience and Healthcare domain
  • Work with application DBAs to prepare data models for different BI reporting needs
  • Extensive knowledge of working with HL7 format and ICD10 code set
  • SME for application and domain knowledge which helps to provide technical solutions
  • Performed multiple POC on Snowflake to evaluate processing speed and functionality support
  • Built a Web Intefrace for Data Stewards to request for data change through the portal which will trigger automated backend process to fix the data in the warehouse
  • Implement process improvements to reduce manual efforts as well as processing speed of multiple ETL jobs/SQL queries.

ETL Developer

TCS - Quest Diagnostics - Informatics Application
06.2013 - 01.2017
  • Perform data analysis and research for Business users using SQL and Reporting tools like Cognos
  • Develop efficient SQL queries to perform data extraction against large scale data warehouse for periodic customer deliverables
  • Maintain and tune performance of ETL jobs and SQL queries by applying best practices
  • Automated maintenance activities with shell scripts and scheduled for periodic execution
  • Developed Cognos dashboard to display KPI metrics required for monitoring team
  • Perform data analysis on missing members to prepare for HEDIS season
  • Write ETL jobs to prepare test files for external customers by masking PHI and PII data
  • Develop SAS and PERL scripts to perform post processing on final deliverable files to filter rows or columns as per business need
  • Write SQL queries and configure integration of new labs and billing systems into system for data readiness
  • Work with Data Governance team to validate data quality and help identify gaps in data loaded from heterogeneous systems
  • Build JAVA API's and stored procedure which would help to access data from the data warehouse by internal teams
  • Parse the streaming of XML messages published by IBM MQ and load them into the tables as CLOB
  • Develop complex and efficient processing logic to process parsed XML's and load them into system
  • Build Web Interface to help load customer data and filter criteria for automated data processing
  • Enhance new functionalities to existing web interface to reduce workload by operations team
  • Coordinated with different infrastructure and middleware teams to keep environment in stable state
  • Coordinated with Business to collect requirements and finalize requirement analysis
  • Prepare and maintain technical documentation for entire SDLC lifecycle.
  • Maintain code and project related information with Starteam
  • Prepare and implement change management operations.

Junior Developer

TCS - JPMC - CHASE Home lending
12.2009 - 05.2013
  • Automated log access by creating a front-end application using JavaScript and HTML/CSS
  • Prepared a batch script to automate daily report creation for status reporting
  • Provide support for existing java applications build to maintain the data flow and control flow to FileNet applications.

Education

Bachelor's of Engineering - Information Science and Engineering

Visvesvaraya Technological University (VTU), Belgaum
Dr. Ambedkar Institute Of Technology
09.2009

Skills

  • Azure Cloud Services and Infrastructure
  • SSMS
  • Azure SQL Server/Database
  • PL-SQL/TSQL
  • Oracle 11g/12c
  • Snowflake Cloud Database
  • HIVE
  • Bash
  • Oracle APEX
  • HP-UX /AIX
  • Java programming
  • Azure Data Factory
  • DataStage Designer
  • SQL Developer/Toad
  • Eclipse
  • Shell scripts
  • Business Intelligence
  • RDBMS
  • Microsoft Office Toosl - Excel/Word/Powerpoint

Accomplishments

  • Completed Azure Fundamentals - AZ900 certification in 2022.
  • Received Best Team Award from Client - Quest Diagnostics in 2019.
  • Promoted as Data and Analytics Evangelist for the client - Quest Diagnostics in 2019.
  • Received a tag of TCS Contextual Master for providing solution to customer using Domain and Technical expertise in 2019.
  • Awarded Star Performer Award from Client - Quest Diagnostics in 2016, 2017 and 2018.
  • Received Best Team Award from client - JP Morgan Chase in 2012.

Timeline

Sr Azure Database Engineer

TCS - Humana Inc
09.2023 - Current

Solution Architect/ Data Architecture - Data and Analytics

TCS - Quest Diagnostics - Multi Project - Informatics Application/ESP Cloud Migration
07.2021 - 08.2023

Senior Database Developer/Senior ETL Developer

TCS - Quest Diagnostics - Informatics Application
06.2017 - 06.2020

ETL Developer

TCS - Quest Diagnostics - Informatics Application
06.2013 - 01.2017

Junior Developer

TCS - JPMC - CHASE Home lending
12.2009 - 05.2013

Bachelor's of Engineering - Information Science and Engineering

Visvesvaraya Technological University (VTU), Belgaum

Similar Profiles

CREATE PROFILE
DIVESH AGARWAL