SUMMARY:

• 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 wif ETL tools like Ab Initio & Informatica.
• Strong experience inPL/SQL, Shell Scriptingand other programming languages.
• ExcellentMaster Data Management, Data WarehousingandData Modelingnoledge.
• Lots of experience dealing wif 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, hardworking, self - motivated and self-learner wif admirable interpersonal and communication skills.
• Demonstrate ability in grasping both technical and non-technical concepts.
• Excellent communication and interpersonal skills, wif the ability to work independently and/or adapt to any team environment.

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000, UNIX (Sun Solaris2.6/2.8, Linux 2.4, HP-Unix).

Master Data Management: IBM Initiate 9.7

ETL Tools: Ab Initio (GDE1.15, Co>OperatingSystem2.15), Informatica, Power Mart 4.7, Power Center 7.1.x and 5.1.

Languages: SQL, PL/SQL, Unix Korn Shell, C, C++, JavaScript, VBScript, HTML, XML, ASP and .NET Framework

RDBMS: Teradata V2R5, Oracle 11g, SQL Server 7.0/2000, MS Access 97/2000

Scheduling Tools: Autosys, Control M

Database Utilities: Teradata SQL Assistance 6.1, Toad 7.5, SQL Loader, BTEQ Win

DSS Tools: Crystal Reports 8.0/8.5, Business Objects XI R3

CM Tools: Ab Initio EME Environment, PVCS, Visual SourceSafe 6.0, Harvest, Subversion

Testing Tools: Test Director 7.6, Clear Quest

PROFESSIONAL EXPERIENCE

Confidential

Mortgage Data Architect

Responsibilities:

• Created a formal description of a system and detailed plan of the system at component level to guide its implementation.
• Documented the structure of components, their inter-relationships, and the principles and guidelines governing their design and evolution over time.
• Created and reviewed the process maps of AS-IS state and future state
• Discussed wif Business to make sure all the functionality is covered in the future state
• Developed the standards and methodologies for benchmarking, performance, evaluation, testing, data security and data privacy.

Environment: Ab Initio, Mainframe, SQL Server, Pega, Empower and Lending Space, MeDB, MLCS and DIME

Confidential

ETL Designer/Architect

Responsibilities:

• Implementation and Management of CDI/MDM Platform, Management of Enterprise DWH
• 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 wif 99.999% availability
• Successfully used BXM(Bulk Cross Match) solution to identify the common customers between Confidential 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 implemented ACE framework creating reusable templates on existing enterprise pattern Ab Initio graphs
• Successfully used IXM (Incremental Cross Match) to integrate the 8.9M customer account records wifin 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 wif 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 3.1, Co-op 3.1, Ab Initio ACE, UNIX/Linux, Oracle, Teradata

Confidential, Washington DC

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 Confidential 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 wif 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, Washington, DC

SENIOR AB INITIO DVELOPER/ 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 wif 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

Confidential, Charlotte, NC

SENIOR AB INITIO DESIGNER/TEAM LEAD

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 dat were made in the business requirements.
• System extract processes - CDMG will develop the data requirements for each system of record extract, and will work wif 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 wifin 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, and 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 wif 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 configuration 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

Confidential, Richmond, VA

SENIOR AB INITIO DEVELOPER

Responsibilities:

• Responsible for gathering business and functional requirements.
• Worked wif business users to come up wif the format of scrub books used to massage the data to hide the customer sensitive data from the offshore developers.
• Responsible for developing Ab Initio graphs for the data scrubbing process dat enabled users to create customized test data based on parameters and environment variables.
• Initial setup for Ab Initio like writing Unix Scripts. Ex: setup scripts, deployed scripts etc.
• Build various Sandboxes in order to create Adhoc & Regular applications in Ab Initio.
• Build several Ab Initio graphs for the test data generator. These enabled the generator to scrub and unload data from production and load it into DMZ.
• Developed the process to parse the Scrub books to get parent-child relationship between the database tables to be unloaded.
• Developed the process to generate the DML for the tables to be unloaded.
• Developed the process to unload the data from the tables and scrubbed the data as per the rules specified in the scrub books
• Published the data into files in the following naming convention ...txt.
• Created the various parametric graphs to download and scrub the data from different databases like Teradata, Oracle and also from Flat files.
• Used Ab Initio Shop for data for running the Data Scrubbing of tables on demand by business users.
• Performed transformations of source data wif transform components like Write Multiple Files, Run Program, Join, Dedup Sorted, Reformat, Filter-by-Expression and Rollup, etc.
• Wide usage of Lookup Files to scrub the data.
• Writing Korn Shell Scripts in Aix UNIX to automate the ETL Process.