Project Data
Resume:
Nancy P
: **********@*****.***
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