Pradeep K Gupta

Atlanta, GA (USA) ad18ih@r.postjobfree.com

http://www.linkedin.com/in/guptapradeepk

Executive Summary

An experienced Data Management and Data-Warehousing Solution Delivery Architect with 24+ years of experience including ETL, reporting, data modeling, data quality, data governance, data conversion and MDM. Experience across industries like Banking/Finance, Healthcare, Pharma, Retail and Telco. Client list include Truist (SunTrust), Charter Communications (Spectrum), Boehringer Ingelheim, CIGNA, State of Rhode Island, Merrill Lynch/Bank of America, Blue Cross Blue Shield, Ahold, Abbott Labs, Berlex (Bayer), Wyeth

(Pfizer), JPMorgan Chase, Morgan Stanley, GE-Aircraft Engines and GE-NBC. Have managed end-to-end project/program deliveries. Done Quality and Risk assessments. Contributed to capacity/budget/schedule planning, sales pursuits, responding to RFPs, providing thought leadership and mentoring.

Effective communicator with the ability to disseminate complex technical information across all levels of organization in a manner appropriate to the receiving audience. Years of hands-on experience working with Data, an expert in SQL, data analysis and performance tuning. Unique expertise in building Audit, Control and Balancing framework for Data Integration solutions. Key Skills:

Technical, Data Integration & ETL Architect, BI/DWH, Informatica PowerCenter/Cloud IICS, MDM, Data Quality, Oracle/Exadata/ MS SQL server, SQL, PL/SQL, T-SQL, Shell scripting, Dimensional Modeling, Data Governance, Performance Management, JIRA/Confluence. ABC (Audit, Balance and Control) framework for ETL applications. Cloud/On-Prim/Hybrid solution design patterns

Functional, Program/Project Management (PMP Certification), Client Engagement Management, Offshore- Onshore Coordination, Cost & Schedule Planning, Process Improvement, Strategic/Tactical Planning, Business Analysis and Development. Project Proposals/RFPs

Excellent Communication, and interpersonal skills Education Training, Certifications & Affiliations

• Bachelor of Engineering (Electrical) from IIT-Roorkee, India.

• PMP Certification (pmi.org)

• Connected Manager Program: Joint certificate from Capgemini and Harvard Manage Mentor.

• Cloud Lakehouse & Data Management (Foundation) Certification: Informatica

• Data Governance & Privacy (Foundation) Certification: Informatica Experience Summary (For details go to “Project Details”) 01 Type of Industry: Banking and Finance - TRUIST

Project

Description:

Managing Data integration solutions for Mortgage Servicing area Role: Data and Application Architect (Vice President) Project Duration: Jan-2023 to Current

Responsibilities: Maintain end to end Data and application landscape. Keep track of data dependencies. Advise the team about best practices around developing Informatica based ETL solutions. Improved ETL performance by 60-80%. Maintain Data Models in Erwin.

02 Type of Industry: IT Services & Consulting – Capgemini Project

Description:

Various Consulting projects (Pharmaceuticals / Telecommunications etc.) Role: Project Manager, ETL Solution Architect, Data Architect Project Duration: Apr-2017 to Jan-2023

Responsibilities: Project Management, Project delivery, System Architecture, Data Modelling and ETL Architecture, System Performance improvement/Optimization, Onshore-Offshore co-ordination, Team mentoring, Process Improvements/optimization.

Reduced data storage by 95% by eliminating redundancy and appropriate data modelling techniques.

RFP response and SOW for various projects.

03 Type of Industry: IT Services & Consulting - Hewlett Packard Enterprise/DxC Project

Description:

Various Projects with clients like Merrill Lynch (Bank of America), Federal Reserve Bank of New York, CIGNA, Fannie Mae, Rhode Island T-MSIS / UHIP, Ahold Delhaize.

Role: ETL Solution Architect, Data Architect, Data Quality Designer, Team Lead, Contractor Manager, Project Manager, Lead Integration Architect Project Duration: Aug 2007 to Apr 2017

Responsibilities: Design and Build Near Real time data acquisition, MDM: De- duping/Merging of master data, Code Release management, Production monitoring and notification, maintenance and administration, Onshore- Offshore co-ordination, Team mentoring, Project Management, Setting up New ETL Environment, Conduct technical interviews, Designed Data Governance and Master Data strategies, Architecture & Design documents, Conceptual diagrams, ETL Performance improvements, Data Quality (IDQ), Job Scheduling/Automation.

04 Type of Industry: IT Consulting - Knightsbridge Solutions (Acquired by HP) Project

Description:

Various projects for clients like Abbott Labs, Berlex (Bayer), Wyeth

(Pfizer), Blue Cross Blue Shield (Michigan).

Role:

BSA, ETL Designer/Developer, Data Conversion, Data Quality Duration: Nov 2005 to Aug 2007

Responsibilities: Business interviews, Requirements gathering, Design ETL, Design ETL testing scheme, Test data generation, Design reviews with clients, Performance tuning, Data quality analysis, Data conversion, Master data maintenance, PL/SQL and Unix scripting.

05 Type of Industry: IT Services and Consulting - Wipro Technologies Project

Description:

Various projects for client JP Morgan Chase

Role:

Operate Manager, Onshore-Offshore Coordinator, Project Management Duration: Sep 2002 to Nov 2005

Responsibilities: Requirement Gathering, Business Interviews, ETL Architect/Design and Development, Coding and Testing, Production Release Management, Training, Project Documentation, Production Support. 06 Type of Industry: IT Services and Consulting - Kanbay (Acquired by Capgemini) Project

Description:

Various projects for client Morgan Stanley

Role:

ETL Developer, Reports Designer/Developer

Duration: May 2001 to Sep 2002

Responsibilities: Sybase T-SQL scripting, Crystal Report Development, Cognos Cubes, T-SQL, Development and Testing.

07 Type of Industry: IT Services and Consulting - Tata Consultant Services (TCS) Project

Description:

Various projects for clients ISBS (Integrated Standard Banking System), GE-NBC, GE Aircraft Engines

Role:

ETL Developer, Testing, Production Support

Duration: Jul 1999 to May 2001

Responsibilities: Erwin Data Modeling, Informatica ETL Design and Development, Testing and production deployments, PL/SQL, UNIX scripting. Project Details

Past Project Details

TRUIST Atlanta, GA, USA Jan-2023 to ‘ongoing’

Employer: TRUIST

PROJECT TYPE Managing Data integration solutions for Mortgage Servicing area ROLE Data and Application Architect

RESPONSIBILITIES • Maintain end to end Data and application landscape.

• ETL Performance improvements.

• Track data dependencies.

• Advise the team about best practices around developing Informatica based ETL solutions.

• Maintain Data Models in Erwin.

Charter Communications St. Louis, MO, USA Mar-2019 to Dec-2022 Employer: Capgemini

Project Type Cable Revenue/Mobile Revenue/Revenue Allocation/Channel List Manager/Subscriber Applications & Reporting / GL Postings Role Solution Architect/Data Architect/Account Manager/Sales Responsibilities • Solution Architecture, design and best practices around Oracle Exadata based data integration solutions.

• Data Modeling and Load Performance improvement. Setting up of processes and guidelines. CI/CD process improvements.

• Application consolidation / Data Migrations

• Application Support and Enhancements

Boehringer Ingelheim Danbury, CT, USA Apr-2017 to Mar-2019 Employer: Capgemini

Project Type Business Intelligence Data warehouse and Reporting (Human Pharma Rx Datawarehouse)

Role Project Manager, ETL solution Architect, Onshore – Offshore coordinator Responsibilities • Manage system enhancements work stream for the project.

• Conceptualize and design JIRA based process improvement for Code changes and ticket monitoring.

• On Prim and Cloud Applications.

• Project Management, Architecture & Design documents, Conceptual diagrams, ETL Performance improvements, Job Scheduling, Onshore- Offshore co-ordination, Team mentoring,

• RFP response and SOW for various mini projects

Ahold Delhaize Greenville, SC, USA Sep 2015 – Apr 2017 Employer: Hewlett Packard Enterprise

Project Type Datawarehouse Enhancement and Support

(Retail/Grocery Chain)

Role ETL Architect

Responsibilities • Provide guidance and roadmap to improve existing warehouse environments.

• Architect and design Audit, Balance and Control framework around ETL processes.

• Design ad-hoc Production fixes.

Rhode Island T-MSIS / UHIP Rhode Island, USA Sep 2013 – Sep 2015 Employer: Hewlett Packard

Project Type Rhode Island T-MSIS extracts for CMS

Rhode Island IES/UHIP

Role ETL Architect

Responsibilities • ETL Architecture and Designer on two projects.

• Created process for storing master list of code values and make it available for data loading processes.

• Provided Mentorship and training to the team of new hires.

• Provided support to Business Analysis and testing subject areas.

• Provided support to project Management and environment setup.

• Provided support in development phase.

Fannie Mae Herndon, VA, USA Jun 2013 – Sep 2013

Employer: Hewlett Packard

Project Type Mortgage Data Quality implementation

Role Data Quality Designer / Data Governance

Responsibilities • Worked with business analysts to develop specifications and requirements

• Developed data quality rules in Informatica IDQ tool

• Developed and tested data quality workflows in Informatica

• Developed and tested Autosys JIL scripts for scheduling. Cigna Healthcare Windsor, CT, USA Feb 2012 – Jun 2013 Employer: Hewlett Packard

Project Type Claims Reporting

Role Team Lead / ETL Architect

Responsibilities • ETL Performance improvements

• Project Management / Team management

• ETL SDLC process improvements

• Code promotion and Release process improvement

• Team Mentoring, Onshore-Offshore co-ordination

Federal Reserve

Bank of New York

New York, NY, USA Dec 2011 – Feb 2012

Employer: Hewlett Packard

Project Type BI Strategy Master Plan

Role ETL Architect & ABC specialist

Responsibilities • Analyze ETL and MDM requirements

• Conduct technical interviews

• Propose architecture and design for ETL and ABC

• Discovered Data quality gaps and proposed the need of Data Governance and Master Data strategies.

• Write Architecture & Design documents

• Create Conceptual diagrams

Merrill Lynch (BoA) New York, NY, USA Aug 2009 – Dec 2011 Employer: Hewlett Packard

Project Type Stock Loans: Locates

Role PM/Lead Integration Architect

Responsibilities • Project Management

• ETL Solution Architect, Design and Build

• Setting up New ETL Environment

• Designing new ABC framework

• Development/QA Process improvement

• Team Mentoring & Onshore-Offshore co-ordination

• Release management: QA, UAT, Production

Merrill Lynch (BoA) New York, NY, USA Dec 2007 – Aug 2009 Employer: Hewlett Packard

Project Type Client Reporting Data warehouse

Role ETL Architect/Designer

Responsibilities • ETL Architect, Design and Build

• Near Real time data acquisition.

• MDM: Maintaining Master copy of data and providing it to downstream systems

• Data Governance

• De-duping/Merging of Account-Party and Product data coming from multi- domain source systems

• Identifying dimensional data keys in multi-domain fact data and assigning it to a unique Account-Party and Product value.

• Code Release management

• Designed Production monitoring and notification logic

• Onshore-Offshore co-ordination

• Testing and Reviews

• UAT and Production monitoring

• Team mentoring

Blue Cross Blue

Shield of Michigan

Detroit, MI, USA Aug 2007 – Dec 2007

Employer: Knightsbridge Solutions

Project Type Claims Data warehouse

Role ETL Designer

Responsibilities • ETL Design for extracting data from source systems and maintaining Master copy of the data.

• Writing ETL Detail Design Documents

• Development, Testing and Reviews

• ETL Performance tuning

Wyeth Consumer

Healthcare

Madison, NJ, USA Apr 2007 – Aug 2007

Employer: Knightsbridge Solutions

Project Type Data Conversion

Role ETL Specialist, Data Conversion

Responsibilities • Designed, coded and tested the Data-Conversion and Data Standardization.

• Create master copies of data for lookup during conversion Process.

• PL/SQL, SQL scripting

• Testing Data conversion process

Abbott Labs Waukegan, IL, USA Nov 2006 – Apr 2007

Employer: Knightsbridge Solutions

Project Type Business Analysis

Role Business System Analyst

Responsibilities • Data Quality Analysis

• Client Interviews

• Documentation

Berlex Laboratories Montville, NJ, USA Jul 2006 – Nov 2006 Employer: Knightsbridge Solutions

Project Type ETL Development

Role BSA, ETL Architect, ETL Developer

Responsibilities • ETL Architect/Design

• Coding and Testing

• Business User Interaction

• Testing, Project Documentation

Abbott Labs Waukegan, IL, USA Nov 2005 – Jul 2006

Employer: Knightsbridge Solutions

Project Type Rx and Sales Data warehouse

Role BSA, ETL Designer, ETL Developer

Responsibilities • Data analysis

• ETL Architect/Design / ABC framework

• Coding and Testing

• Production Implementation and Support

JP Morgan Chase New York, NY, USA / India Sep 2002 – Nov 2005 Employer: Wipro Technologies

Project Type Operation Risk Data Warehouse/Self-Assessment System Role Operate Manager, Onshore-Offshore Coordination, Project Management Responsibilities • Project Management

• Requirement Gathering, Business Interviews

• ETL Architect/Design and Development

• Data Governance

• Coding and Testing

• Production Release Management

• Testing, Project Documentation

• Production Support

Morgan Stanley New York, NY, USA / India May 2001 – Sep 2002 Employer: Capgemini (Kanbay)

Project Type Data Warehouse and Reporting

Role Report Development

Responsibilities • Sybase T-SQL scripting

• Crystal Report Development

• Cognos Cubes

• T-SQL

• Development and Testing

GE (Aircraft Engines/NBC) Singapore / India Jan 2000 – May 2001 Employer: Tata Consultancy Services (TCS)

Project Type Data Warehouse and Reporting

Role ETL and Reporting – Advertising Data Mart & Aircraft Engine Parts Responsibilities • Erwin Data Modeling

• Informatica ETL Design and Development

• Testing and production deployments

• SQL, PL/SQL coding

ISBS Group - TCS India Jul 1999 – Dec 1999

Employer: Tata Consultancy Services (TCS)

Project Type Online Banking application

Role Unix Shell Script Coding and Testing

Responsibilities • Scripting file manipulation in Unix

• SQL data analysis / Defect analysis

• Testing / Documentation

Contact this candidate