Nancy P

: acxxw2@r.postjobfree.com

: +1-804-***-****

Career Objective:

Seeking a progressive and challenging position which promises ample learning & growth opportunity and which utilizes my skills and enthusiasm to make a valuable contribution to the organization.

Professional Summary:

7+ years of IT experience in Ab Initio

Proficiency in using various Ab-Initio components like Partition by Key, Partition by round robin, Reformat, Rollup, Join, Scan, Normalize, Filter by expression, Gather, Merge and Lookup etc

Well versed with various Ab Initio Parallelism techniques and implemented Ab Initio Graphs using Data Parallelism and Multi File System (MFS) techniques

Good understanding of Data Warehouse Architecture

Knowledge about Enterprise Meta environment (EME).

Creation of wrapper scripts and conduct>It plans.

Performance and defect analysis.

Effective Team Player with excellent written and verbal communication skills

Training and mentoring new hires on project domain knowledge, data model and key Ab Initio concepts

Professional Experience:

Cognizant Technologies Solutions (Feb 2012 to Present)

Wipro Technologies Ltd (Sept 2009 to Feb 2012)

Projects Undertaken:

Project Name

BASEL Retail

Client

Capital One Bank US

Duration

Jan 2016 till present

Project Description

The Basel II Retail Credit Teradata Repository project will be responsible for implementing the Teradata Repository which will store all data elements required for the development and execution of Basel II Retail Credit PD, LGD, and EAD models, as well as for ongoing Retail Credit analysis. In order to implement this solution, the P60k project team will need to complete the following core objectives:

Modeling Retail Credit Data Structures within the Basel II Retail Credit Teradata Repository

The data elements for each Retail Credit Line of Business (LOB) will be modeled within the Teradata container based on the Core Data deliverables produced by the Historical Data Collection Projects, combined with the RWA required data elements. The Core Data deliverables are inputs to the P60 Data Sourcing & Gap Remediation projects, which in turn, will create the resulting Data Requirements and Metadata documents to be leveraged by the P60k Teradata Repository project. The P60 Data Sourcing & Gap Remediation projects will be responsible for combining the Core Data deliverables with the RWA required data elements within these documents. Along with specifying the data elements required by the Core Data Request and the RWA Calculator, the Data Requirements and Metadata documents will also specify any data transformations which will need to be applied to the data. The following P60 Data Sourcing & Gap Remediation projects will be providing Data Requirement and Metadata document inputs to the P60k project team:

P60a: Mortgage & HEL/HELOC

P60c: COAF

P60i: ING

This project will deliver on the following objectives:

Ensure that all data required for ongoing Basel II Retail Credit analysis is available within the Basel II Retail Credit Teradata Repository online or via archival retrieval

Implement the Basel II Retail Credit Teradata Repository in accordance with the Data Governance and Retail Credit Business Data Quality standards and requirements

Role

ETL Onshore Lead

Responsibility

Have worked as an Abinitio onshore tech lead, in this project, and have been involved in lead activities from offshore, which involve interaction with BSA and clients for clear understanding of requirements, proper work allocation to the offshore team members, along with review and follow ups, providing technical guidance to the team, and preparation of project metrics/trackers etc.

Have performed enhancements and tested applications using Ab-Initio in accordance with the Functional and Technical specifications. Worked with the project team to ensure that the program meets all requirements.

Have Created Technical Design Documents for ETL graphs and Unit Test case documents for graphs and scripts.

Involved in Metadata mapping from legacy source system to target database fields and involved in creating Graphs, dml's and xfr’s using Ab Initio.

Involved in submitting requests for code migrations between Dev, QA and Production, along with preparation of all relevant rollout documents like Job Scheduling details, EME Project details, and QA/SIT Signoff emails etc.

Developed scripts in Unix Korn Shell, for various purposes like copying files across servers, executing the graphs/deployed scripts, archival and purging of files for housekeeping etc.

Have worked on Teradata SQL during the project.

Have also lent support to the Project during QA/UAT testing and contributed to defect resolution for both Prod and Pre-Prod defects.

Project Name

Digital-Enterprise

Client

Capital One Bank US

Duration

Feb 2012 – Jan 2016

Project Description

Digital Platform Team processes all Data captured during customers' interactions with the bank via Web/Mobile by applying required business rules and loads it to EDW. EDW data is then analyzed for better servicing of existing customers, cross selling of products to existing customers and identify prospective customers.

Digital Project mainly has 4 sub tracks

1.Enterprise

2.Retail

3.Card HSBC

4.Mobile

The 4 streams of the Digital Application receive source feeds from the legacy source systems, which is then picked up by the ETL tool Abinitio, and then processed for data quality, followed by application of business rules and loading of transformed data into the target EDW Data warehouse which has been built on Teradata. The data, would then be acted upon by Reporting Tools like Business Objects and Cognos, to prepare reports based on which the Capital One Business Users can take their decision on fine tuning and improving their online banking and mobile banking portfolios.

Role

ETL Lead Offshore

Responsibility

I was involved in a 6 week knowledge transition process from the current vendor on the existing applications.

Have worked as an Abinitio offshore tech lead, in this project, and have been involved in lead activities from offshore, which involve interaction with onsite counterparts for clear understanding of requirements, proper work allocation to the offshore team members, along with review and follow ups, providing technical guidance to the team, and preparation of project metrics/trackers etc.

Have performed enhancements and tested applications using Ab-Initio in accordance with the Functional and Technical specifications. Worked with the project team to ensure that the program meets all requirements.

Have Created Technical Design Documents for ETL graphs and Unit Test case documents for graphs and scripts.

Involved in Metadata mapping from legacy source system to target database fields and involved in creating Graphs, dml's and xfr’s using Ab Initio.

Involved in submitting requests for code migrations between Dev, QA and Production, along with preparation of all relevant rollout documents like Job Scheduling details, EME Project details, and QA/SIT Signoff emails etc.

Developed scripts in Unix Korn Shell, for various purposes like copying files across servers, executing the graphs/deployed scripts, archival and purging of files for housekeeping etc.

Have worked on Teradata SQL during the project.

Have also lent support to the Project during QA/UAT testing and contributed to defect resolution for both Prod and Pre-Prod defects.

Project Name

COAF Data Enhancement Program Phase III (Teradata Migration)

Client

Capital One Auto Finance,U.S.A

Duration

Feb 2011 – Jan 2012

Project Description

Capital One Auto Finance is remodeling the entire analytical data warehouse environment by reaching out to the different business groups about their analytical needs and then restructuring the entire auto data warehouse. The new data warehouse is going to be built on a third normal form and the data is going to be loaded across the bank, mortgage and auto data warehouses based on the subject area of the data that is being loaded. This will enable cross business line analytics at an enterprise level in the future thereby proving a world class analytics platform. The initial delivery of the DEP3 project is aligned by subject areas.

Role

Offshore Ab Initio Developer

Responsibility

Developing the graphs, psets, and xfrs for the ETL part of the project using the ETL tool Ab Initio

Use Conduct It to develop plans which in turn call the graphs

Preparing Unit test cases and performing the Unit testing

Execution of Code checker and Data Lineage

Preparing the project related documents like Deployment plan, Code review check list etc

Adhere to the development guidelines, DDE standards and best practices during development

Gained experienced in working with EME(Check-in, Check-out, Version Control)

Used several air utility commands in the development phase

Peer review and self review

Project Name

COAF Data Enhancement Program Phase II (Teradata Migration)

Client

Capital One Auto Finance,U.S.A

Duration

Dec 2009 – Dec 2010

Project Description

The Teradata migration project comprised of fork lifting all data supporting current business intelligence needs, from SQL Server analytical environment to enterprise Teradata environment and converti-ng all legacy SQL Sever DTS packages into DDE for simplified and efficient data acquisition and integration environment. The project involved conversion of DTS packages to equivalent Abinitio code which is in the form of Abinitio graphs based on DDE( Data Development Environment ).DDE is specific to the client and the coding was done based on pre-defined DDE standards and patterns.

Role

Offshore Ab Initio Developer

Responsibility

Developing the graphs, psets, and xfrs for the ETL part of the project using the ETL tool Ab Initio

Use Conduct It to develop plans which in turn call the graphs

Preparing Unit test cases and performing the Unit testing

Execution of Code checker and Data Lineage

Preparing the project related documents like Deployment plan, Code review check list etc

Adhere to the development guidelines, DDE standards and best practices during development

Gained experienced in working with EME(Check-in, Check-out, Version Control)

Used several air utility commands in the development phase

Peer review and self review

Technical Expertise:

Database

Teradata

ETL Tools

Ab Initio 1.15, 3.1, Co>system 2.15.8.16, 3.1.1.7

Scripting Language

UNIX

Software/Tools

AbInitio(GDE1.15,3.1,Co>Operating System 2.14,3.1.1.7), EME,Teradata SQL assistant, SQL Developer, Hadoop Basics, AWS Basics

Academic Qualifications:

•Bachelor of Engineering (ECE) from Avinashilingam University, Coimbatore with 81% in 2008.

•XII from Avila Convent Matriculation Higher Secondary School with 91%in 2004

•X from Avila Convent Matriculation Higher Secondary School with 89% in 2002.

PERSONAL DETAILS:

Date of Birth: 26th Jan 1987

Spouse Name: Paul Richard

Marital Status: Married

Languages Known: English and Tamil

Nationality: Indian

PASSPORT NO M7791141 Expiry Date : 07/24/2018

Visa Status H1B Visa Expiry Date : 07/01/2018

Declaration

I hereby declare that above furnished details are true and precise up to my knowledge.

Nancy P

Contact this candidate