Program Manager Sql Developer

DIVESH AGARWAL Mail: ******.*********@*****.***

Phone: +91 –700-***-**** (India)

+1 – 610-***-**** (US)

Experience Summary

12+ years of IT Professional as Technical Lead and Technical Program Manager in Data warehousing, Data Analytics & Business Intelligence portfolios for domains like Healthcare and Banking/Financial Services.

Achievements

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.

Secured State Highest Score in Computer Science in High Secondary in Meghalaya.

Technical Expertise

Elements

Particulars

Primary Skills

DataStage, Oracle Pl/SQL, Shell scripts, Oracle APEX

Operating Systems

HP-UX /AIX

Languages

Java programming, PL/SQL

Development Tools

DataStage Designer, SQL Developer/Toad, Eclipse, Bash, Oracle APEX

Scripts

Java, SAS, Unix Shell

Reporting/Visualization Tools

Cognos/ Tableau

Analytics Tools

Cognos/SAS, Spark

Databases

Oracle 11g/12c, Snowflake Cloud Database, HIVE

Domain Knowledge

Banking and Financial Services and Healthcare

Agile and Project Management

CA Rally and Clarity

Documentation

Microsoft Excel, Microsoft Word

Version Management

StarTeam. Gitlab

Experience Details

Sl. No.

Name Of the Organization

Designation

Joining Date

Relieving Date

1

TATA CONSULTANCY SERVICES

ASSISTANT CONSULTANT

DEC- 2009

TILL NOW

Project Details

Client / Location

Quest Diagnostics Ltd. / India

Project Description

The project involves migrating applications to Azure Environment and remove dependency on the On-Premise Data Center/Resources. The current scope is to perform a pilot project to build a factory model which will help to move other applications in a systematic pattern.

The scope of the project is to Lift and Shift Applications with minimum coding changes.

Role

Technical Program Manager

Duration

From (MON - YYYY)

MAY – 2021

To (MON - YYYY)

TILL DATE

Responsibility

Work with Cloud Architects to define standards, templates and guidelines.

Prepare Project Roadmap and Project Plan for each in scope applications.

Manage the responsibility of End-to-End Delivery

Delegate tasks to resources and follow up on progress

Prepare client status reports and setup governance calls

Review Final Architectures and Documentations.

Team Size

10

Client / Location

Quest Diagnostics Ltd. / Collegeville, PA, USA

Project Description

The project involves the management and enhancement of the Data Warehouse which holds the data from Lab and Billing Information Systems. ETL processes are built to load around 300K records and to extract data for more than 200 customers on a daily basis. Java API’s provide access to the restricted Data Warehouse to different internal teams and Patient Mobile Applications. SAS scripting and shell scripting are used to process the extracted data for custom requests from the customers. APEX applications and PL/SQL procedures and packages are built to manage the configurations and

Role

Technical Lead

Environment/Tools

Cloud, DataStage, Oracle 12c, Data Warehouse, AIX, Oracle APEX, Java, SAS, Cognos/Tableau, GitLab, Rally

Duration

From (MON - YYYY)

MAY – 2013

To (MON - YYYY)

MAY – 2021

Responsibility

Requirement gathering and solution proposal in Data Analytics domain

Sprint planning, allocating work to team members, progress report of each module as well as team members.

Designing, developing, implementing, testing, and maintaining complex ETL processes using DataStage and Oracle

Creating and maintaining PL/SQL stored procedures, complex queries, functions and other scripts.

Optimizing new and existing ETL and PL/SQL components while processing large volumes of data.

Developing front end applications for reporting and configuration using Oracle APEX and Java scripts.

Developing complex reports for Business Intelligence using Tableau/Cognos.

Directly interacting with clients & managing a team to deliver various reports on time.

Involved in Unit testing, resolving bugs & preparing high level documents (URS, Design Architecture document etc.) for the project.

Team Size

11

Client /Location

JP Morgan Chase & Co. / Bangalore, India

Project Description

This was an enhancement and maintenance project to sustain the Chase Home Lending applications by monitoring and building tools to foresee the regular processing of the loan documents throughout the Business Process Workflow. The Business Process Workflow was maintained by FileNet application while Captiva tool was used for processing loan forms. Java API were built for data retrieval and custom adhoc requests.

Role

Developer

Environment

Java, Filenet, Captiva, Unix

Duration

From (MON - YYYY)

Dec – 2009

To (MON - YYYY)

May - 2013

Responsibility

Develop and maintain workflows in Captiva and FileNet applications.

Develop Java application to login and display the logs on a front-end application.

Maintenance of version of the project code in Sub Version (SVN) by merging the module developed with latest version in SVN.

Administration and Monitoring of Captiva Tool.

Team Size

6

Training Attended / Certifications Done

Course Details

Transformational Program Manager – Level 2 Certification (TCS Internal Learning Program)

Data Architecture Program – Level 2 Certification (TCS Internal Learning Program)

Certificate in Life Sciences - Level 1 (BDA - TCS Business Domain Academy)

DWH concepts - Level 1 Certification (TCS Internal Learning Program)

Agile Practitioner – Level 1 certification (TCS Internal Learning Program)

Attended training on Hadoop, Spark, Scala with hands on experience

Completed a POC on Snowflake Cloud Data Warehouse for Migration from Oracle

Contact this candidate