In addition, she has:

• Extensive experience in Ab Initio 1.15 and Co-operating System 2.15 with EME as a Metadata Environment, Control-M Scheduler, Teradata Database.
• Expert in writing and testing queries at database level using Teradata, SQL Server.
• Working knowledge of creating new or maintaining Crystal Reports.
• Efficient in all phases of the development lifecycle, coherent with data cleansing, data conversion, performance tuning and system testing.
• Expertise in developing and maintaining overall Test Methodology and Strategy, Documenting Test Plans, Test Cases and editing, executing Test Cases and Test Scripts.
• Strong knowledge of both Star and Snow Flake Schema.
• Involved in coordinating calls with source systems, clients and with other business partners.
• Good experience is maintaining the versioning and deployment instruction documents while moving the code to various environments.
• Extensively worked with production support (L3) team to resolve issues and worked in extracting data from Database tables and flat files.
• Performance tuning by using phasing, appropriate filters and reformats, joins and lookups etc in Ab Initio.
• Hands on Experience in Teradata, UNIX, Shell Scripting, Data Relationships, Data extraction & Validation.
• Good exposure to development, testing, debugging, implementation, documentation, user training & production support.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes
• Experience on Creating detailed project outlines and application design specifications.
• Involved extensively in GUI, System and Regression Testing.
• Proven track record in troubleshooting of Ab Initio jobs and addressing production issues like performance tuning and enhancement.
• Excellent knowledge of studying the data dependencies using Metadata stored in the EME (Enterprise Meta> Environment) Repository.
• Strong understanding of business processes with excellent writing and documentation skills for the management and development.
• Excellent track record as a leader and team player with effective communication skills.

WORK EXPERIENCE:

Confidential, Plano-TX April 2010 - Present

Role: Technology Lead, Onsite coordinator (US)

Project Description: Data warehouse and Marts - This ETL development and maintenance project is to document and maintain Data Warehouse and associated applications such as cleansing, extraction for applications and data marts. Used Plan>it feature of abinitio to manage data processing.
This project also involved decommissioning of the existing PMORE database. As a part of Capital one Auto Finance (COAF) project I have worked on BI reporting side as well. This project involved creation of new reports and supporting existing reports.

Responsibilities:

• Planning, implementing, and maintaining software build and release management across Development, UAT and Production.
• Developing and implementing Standard Operating Procedure for Software build and release Management.
• Monitors and tunes ETL repository and system for performance improvements.
• Interacted with Business Analyst to understand requirements and translated them into the appropriate technical solution.
• Designing and developing complex Ab-initio code for new data model
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited)
• Warranty support for new code and provide production support for the existing process.
• Create a decommission plan for the existing process and support decommissioning activities.
• Interacted with User Groups/Corporate Testing Groups/Business people.
• Develop, Design and test a graph and its corresponding job and PSETs for date control file generation and maintenance.
• Used plan>it to run large scale data processing.
• Created Project Design document with appropriate diagrams (designed in MS Visio) to explain the project flow/architecture.
• Participated in the requirement gathering, UAT meeting with users to provide technical details

Environment: Ab Initio V1.15, Co>Operating System V2.15, EME, Control-M Job Scheduler, SQL Server 2000, Unix, Teradata, Crystal Reporting, Rochade.

Confidential, Richmond-VA Oct 2009 - April 2010

Role: Abinitio Technical Lead, Onsite coordinator (US)

Project Description: Objective of this project was to build operational data store for various source data. As a part of this project SEAM data and Year End Statement (YES) Data was loaded into the ODS Database. In SEAM project, we have extracted and transformed the data from flat files. And this transformed data was further FTPed to mainframe system. In YES project we have built the functionality to create the year end statements for customers first time in Capital one. This project was challenging in terms of data volume.
Responsibilities:

• Participated in requirements walkthrough sessions and completed requirement analysis.
• Created High Level Design document and detailed level design document.
• Planning, implementing, and maintaining software build and release management across Development, UAT and Production.
• Created Unit test document and coordinated system/integration testing
• Co-ordinated with various teams (BSA, QA team, Mainframe Team, DBAs, Release management team, production support team, etc) during the life cycle of the project
• Warranty support for new code and provide production support for the existing process.

Confidential, Dec 2008 - Sep 2009

Role: Abinitio Technology Lead, Project (End-To-End) Co-ordinator

Project Description: Confidential, aims at capturing the database changes to PPMIS Operational system and replicates them into the new PPMIS data warehouse. This will ensure that the PPMIS data warehouse will be at par with OLTP system in terms of PPMIS reporting functionality. This project was purely based on the ETL fundaments, which means that the source data extracted from the sources were transformed into the required reports or form and then load it into the database like DB2 (SQL Server).
Responsibilities:

• Requirements gathering and analysis.
• Planning, implementing, and maintaining software build and release management across Development, UAT and Production.
• Developing and implementing Standard Operating Procedure for Software build and release Management.
• Co-ordinating with various team for successful implementation
• Unit and Integration Testing in Ab initio along with validating COGNOS reports.
• Performed unit testing and prepare test cases for UAT.
• Co-ordinating with Mapping team, System testing team, UAT team during this project.

Environment: Ab Initio V1.15, Co>Operating System V2.15, EME, Control-M Job Scheduler, SQL Server 2000, Unix, DB2, COGNOS reporting tool.

Confidential, Charlotte-NC Nov 2007 - Nov 2008
Role: Ab-initio Developer, Onsite Coordinator (US)
Project Description: The Basel II Accord is an extensive proposal intended to act as a catalyst for the development of advanced methods to manage risk and the capital adequacy of financial institutions worldwide.
The objective of the project is to extract, transform and load the data elements required for Basel II Credit Risk calculations. In this project, bank's data related to Equity, Securitization and Derivatives are sourced from various source systems and loaded into a central data warehouse. Then these data are provided in the form of views to the downstream users, who perform the required Basel II Credit Risk calculations.
Responsibility:

• Created ETL design documents to map source data to target tables.
• Involved in developing various ETL code that loads dimensional and fact tables.
• Created mappings using Filter, Router, Expression, Joiner, Update Strategy and Lookup Transformations.
• Extensively used ETL to load data from wide range of sources such as flat files (CSV, fixed-width or delimited).
• Performing unit testing and prepare test cases for UAT.
• Co-Ordinating with Mapping team, System testing team, UAT team during this project.

Environment: Ab-initio 14.3, UNIX, Teradata, SQL Server, UNIX Shell scripting, Autosys job scheduling tool.

Client: Confidential, India June 2006 - Oct 2007

Role: Software Engineer

Project Description: A USA bank project, in which different modules/applications deal with Credit Cards, Debit cards, AML (Anti Money Laundering), ATM, Data warehouse and data mart data. The project was divided into several critical modules where different activities of the bank were taken care of. This project was purely based on the ETL fundaments, which means that the source data extracted from the sources were transformed into the required reports or form and then load it into the database like Teradata or Informix.

Responsibilities:

• Responsible for development, design and testing of different applications like F7 (Profitability and aggregation module), CDW (Corporate Data Warehouse), ODS (Operational Data Warehouse), CDR (Card Data Repository), AML (Anti Money Laundering), HUB (Cleansing Module) and XM (Mainframe- one of the Data Source)
• Involved in requirement gathering, designing, development, testing, code promotion and production support for first run of the application.
• Responsible for Unit and System Integration Testing
• Develop and test Teradata and Informix queries.
• Develop shell scripts for automation of the processes.
• Develop graphs, their corresponding Autosys jils and promote the jils to production environment.
• Automate the process of creation of Autosys Development, Test and production Jils for their respective environment.
• Create and Maintain project documents (along with versions) onto the VSS and Documentum.
• Worked on Ab Initio components like Join, Rollup, reformat, scan, dedup, sort, partition and de-partition components, etc.
• Worked on Mainframe source files, flat files, input tables and lookup files.
• Promote the SQL queries from test to production environment by contacting Database DBA.
• Involved in performance tuning of the ETL process and performed the data warehouse testing.
• Involved in Defect logging and bug fixes
• Responsible for Code review, preparation of test plans and test cases.
• Involved in preparation of all the Software life cycle documents like Technical design document, Unit Testing and System Integration Testing documents along with Test Results and UAT document.
• Prepare Deployment document with information like Risk Mitigation plans, backout and implementation plans and schedule.
• Co-ordinate with client, business end users, onsite counterparts and team.
• Involved in conducting knowledge sharing sessions for fresher's/new joinees.
• Conduct technical design walk through for production support team.
• Conduct weekly onsite-offshore calls, defect prevention meetings, technical meetings for extra activities like creating tools, automation of project processes, etc.
• Provide Technical guidance to the project team
• Prepare Utilization Report for whole team.
• Conduct non project activities like organizing parties and games.

Environment: Ab Initio V1.14, Co-Operating System V2.14, UNIX, Teradata, Informix, Autosys, EME, Documentum, VSS, Windows XP, Mainframe, PICCT - Tool to raise Production Support Tickets.

Awards and Activities:

• "Circle Of Excellence Award" by Infosys USA Committee in 2011.
• Outstanding performer software engineer Spot Award by Infosys committee in 2010.
• Secured all performance based incentive and best grade while IT specific training and cumulative related rating appraisal cycle.
• Completed Ab-initio vendor training arranged by Infosys Ltd.

Educational Qualifications:

• B.E. in Instrumentation and Control Engineering

Technical Skills:

ETL Tools:

Ab Initio V1.14 & 1.15, EME

Reporting Tool:

Working knowledge of Crystal Reporting

Operating Systems:

Windows 95/98/NT/2000/XP, Unix.

Database:

Teradata, SQL server 2005, DB2.

Tools:

Control-M, SQL PLUS, Putty

Application Suite:

MS Office, MS Project, MS Share Point, Microsoft Visio Professional, Rochade

Certifications:

Teradata 12 Basics, Teradata Sql V2R5