RELEVANT EXPERIENCE:

• Extensive experience in Master Data Management, Data warehouse, Business Intelligence, application development for front end, back end and middle tier technologies.
• Extensive experience in Data Warehousing and hands on with ETL tools like Ab Initio Informatica.
• Strong experience in PL/SQL, Shell Scripting and other programming languages.
• Excellent Master Data Management, Data Warehousing and Data Modeling knowledge.
• Lots of experience dealing with the business end users. Excellent ability to understand and implement projects from the management perspective.
• Excellent team building skills. Led and managed teams responsible for delivering/maintaining critical projects.
• Experience in working as a Developer, Designer and Team Lead and Manager.
• Good team player, hard working, self-motivated and self-learner with admirable interpersonal and communication skills.
• Demonstrate ability in grasping both technical and non-technical concepts.
• Excellent communication and interpersonal skills, with the ability to work independently and/or adapt to any team environment.

SKILLS SUMMARY:

PROFESSIONAL EXPERIENCE:

Confidential

Role:ETL Designer/Architect

• Successfully managed a team of 15-20 resources On-Site and Off-Shore in CDI/MDM and ETL
• Successfully integrated 150 M customer account records across 32 sources.
• Successfully implemented High Availability with 99.999 availability
• Successfully used BXM Bulk Cross Match solution to identify the common customers between Capital One and partnership customer data
• Developed Ab Initio Solution to load the data from different sources into CDI Master files and create deltas to be loaded into HUB.
• Successfully used IXM Incremental Cross Match to integrate the 8.9M customer account records within 10 hours into CDI.
• Successfully designed and implemented Initiate Algorithms for Person, Business and Household
• Successfully implemented in-house built Match Quality Operational Manual Review process
• Responsible for the management and implementation of the EDW and CDI/MDM solution
• Worked with Initiate Support, DBA's, UNIX, Storage teams to tune and improve performance
• Successfully designed and deployed Inbound, Entity Management, Outbound broker processes
• Successfully lead several system conversions and delivered complex new business capabilities
• Strong Vendor Management skills: IBM/Initiate and On-Site/Off-Shore Resourcing partners

Environment: Initiate MDS CDI/MDM Versions 7.5/8.5/ 9.7, Ab Initio GDE 1.15.7 Co-op 2.15, UNIX/Linux, Oracle, Teradata

Confidential

Role: Senior Ab Initio Developer

Responsibilities:

• Involved in design and architecture of the whole application.
• Designed various IR2 modules for Loan Setup and Payment processing modules for various programs like 1MP, 2MP, HAFA, FHA and RDHAMP.
• Involved in various High level design and detail level design review meetings.
• Involved in designing the workflow for the whole project
• Involved in various handshake meeting between Fannie Mae and external partners.
• Supported testing efforts in both system test and acceptance environments
• Supported various releases in Production as well as acceptance environments.
• Designed the file transfer B2B protocols with different recipients using Flex File Exchange
• Involved and supported Adhoc Database Modification and File Modification processes.
• Developed process for Cleaning up the ETL UNIX file system and BOXI Wintel file system.
• Developed Data Quality mappings using Informatica Data Quality tool.
• Scheduled the calendar jobs using the Autosys Scheduler
• Involved in process design as per Risk and Compliance Standards

Environment: ETL, Ab Initio GDE 1.15, Co>Op 2.15 , Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX, Business Objects XI R3, Informatica

Confidential

Roles: Architect / Analyst / Senior ETL Specialist/ Team Leader

Responsibilities:

• Technical team lead and also responsible for leading the team, providing the technical solutions and also designing, developing, testing, and implementing the Mortgage backed Securities ETL processes and architecture.
• Responsible for understanding business and functional requirements and converting them into technical requirements and mapping documents.
• Involved as Designer and Developer for Guaranty Business System GBS .
• Developed Ab Initio graphs and high level design and detail design document for data movement.
• Developed parameterized Ab Initio Graphs to load the data in to Oracle Staging Tables.
• Create cfd, pset, data, and ctrl files.
• Performed transformations of source data with transform components like Write Multiple Files, Run Program, Join, Dedup Sorted, Reformat, Filter-by-Expression and Rollup, etc.
• Unit testing of new and existing Graphs.
• Used Automated Test Framework to test the Ab Initio graphs.
• Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
• Writing Korn Shell Scripts in Aix UNIX to automate the ETL process.
• Scheduling the Graphs using Autosys Scheduler.

Environment: ETL, Ab Initio GDE 1.13.3.2, Co>Op 2.13.1 , Ab Initio Enterprise Meta Environment, Mainframe, Oracle 10g, Clear Case, Clear Quest, Remedy, Autosys, UNIX

SENIOR AB INITIO DESIGNER/TEAM LEAD

Confidential

Responsibilities:

• Responsible for gathering business and functional requirements.
• Involved as Designer and Developer for Securities Collateral Tracking SCT .
• Development of source data profiling and analysis review of data content and metadata will facilitate data mapping, and validate assumptions that were made in the business requirements.
• System extract processes CDMG will develop the data requirements for each system of record extract, and will work with business and IT support staff to create and/or modify extract processes.
• Testing and data validation each extract process will be validated, and data elements within each file will be reviewed to ensure data quality prior to passing the file to Risk Management.
• Involved in various EME data store operations like creating sandbox, code check-in, code check-out according to the environment settings for the Securities Collateral Tracking SCT application.
• Developed Ab Initio graphs and high level design and detail design document for data movement.
• Developed Ab Initio Graphs to load the data in to Loan, Loan-Coll and Acct-Address MVS data files for RDW Group.
• Involved in Universal cleansing process for COBOL copybooks and mvs data files.
• Create cfd, pset, data, and ctrl files.
• Writing functions for Date/Time list formats.
• Running Development Scripts to convert the COBOL copybooks to create clean EBCDIC and ASCII dml's.
• Creating several Complex Graphs in Ab Initio for different system of records.
• Unit testing of new and existing Graphs.
• Responsible for creating Test Autosys jobs in development and test environments.
• Promotion of Code from development to test environments using Harvest Source Control System.
• Responsible for the code to be unit tested in the Dev Source tree before migrating it into the test environment.
• Responsible for checking the validity of the control files for business dates and record counts and also validated the ETL output files with the record counts in the input files.
• Responsible for training of team members on Autosys, Harvest and also guided them to understand the development and test cycles.
• Responsible for sending timely status updates to the team, enabling downstream users to load the tables into Informix.
• Write and modify several application specific Config scripts in UNIX in order to pass the environment variables.
• Writing Korn Shell Scripts in Aix UNIX to automate the ETL process.
• Scheduling the Graphs using Autosys Scheduler.

Environment: ETL, Ab Initio GDE 1.13.3.2, Co>Op 2.13.1 , Ab Initio Enterprise Meta Environment, Mainframe, COBOL Copybooks, MVS, Harvest, Autosys, UNIX

SENIOR AB INITIO DEVELOPER

Confidential

Summary:

The data scrubbing project was owned by Capital One's Test Data Management TDM team, which mainly involved in providing data for the offshore application developers test data. The team's role was to identify, populate, and provide mainframe and Capstone test data for offshore application support, development, and system testing.