PROFESSIONAL SUMMARY:

• 8 Plus Years of experience in IT. Expertise in Quality Assurance, design, modeling, analysis, development and implementation of Data Warehouse/Data Mart Applications on UNIX platforms.
• Around 6 years of experience in SQA with manual and automated testing tools in financial, Investment banking, retail, health insurance, pharmaceutical and Supply Chain Management (DM and DP).
• Over 2 years of experience in development in using DataStage ETL tool.
• QA/Test background augmented and complemented by diverse experience in software development
• Worked as QA engineer, writing and executing test plans and test cases performing all types of testing (functional, acceptance, load, stress, performance, volume etc.)
• Worked on white box testing using framework testing app.
• Worked on black box and functional testing. Worked on application testing and data warehouse testing.
• Strong in Design, Development and Execution of Test plans, Test cases, Test Scenarios and Automated Scripts.
• Strong Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Expertise in Automated Tools – Quick Test Professional 8.0/9.1(QTP), Load Runner, Quality Center, Clear Quest and Rational Suite
• Formulating Test Strategies and Preparation of Test Plan and Test Scenarios
• Enjoy working collaboratively with testers, developers and other team members in testing complex projects and in the overall enhancement of software product quality.
• 2 years of extensive experience in DataStage Development. Used DataStage (Manager, Designer, Director and Administrator); extensive experience with DataStage Parallel Extender (EE).
• Worked on Parallel Jobs using various stages like Join, Lookup, Change Capture, Filter, Funnel, Copy, Column Generator, Peek, Dataset, Sequential File, Oracle Enterprise, Merge, Transformer, Aggregator, Remove Duplicates Stages, etc.
• Worked on Job Sequences to control the execution of the job flow using various activities and triggers like Job Activity, Email Notification, Sequencer, Routine activity and Execute command.
• Excellent knowledge in extraction, cleansing and modification of data from/to various data sources like flat files and databases.
• Experience in UNIX Shell Programming for scheduling, file manipulation etc.
• Excellent verbal and communication skills, has clear understanding of business procedures, adapt new environment quickly, Team building, Leadership and Project Management Skills
• Quick learner, efficient, self-motivated and success oriented. Excellent written and communication skills and ability to work independently in a time sensitive environment.

TECHNICAL SKILLS EXPERTISE:

• Testing Tools: Quick Test Pro (QTP) 8.0/9.1/10.0, WinRunner 7.0/7.5/7.6, LoadRunner7.8/8.0/9.0/9.1, Rational Clear Quest
• Defect Tracking Tools: Quality Center (QC) 8.0/9.0/10.0, Test Director 7.2/7.5/8.0, Rational Clear Quest, ReQTest.
• ETL Tools: Ascential DataStage (7.5), DataStage EE (Parallel Extender Version), Ascential DataStage Version Control.
• Reporting Tool: Cognos
• Programming Languages: SQL, PL-SQL, UNIX Shell Scripting, C, C++ and Java
• Databases: Oracle 10g/9i/8i, SQL Server, Teradata, DB2, Informix.
• Operating Systems: UNIX (AIX and Sun Solaris 2.x) Windows NT.
• Others: JSP, HTML, XML, Autosys, Frontpage-2000, Microsoft Visio2003, Tomcat, Visual studio.

EDUCATIONAL QUALIFICATION:

• Master of Technology: (Computer Science).

PROFESSIONAL EXPERIENCE:

Confidential,MA January 2009 to May 2011
Project 1: Basel
Role: Senior ETL Tester

State Street, a world leader in financial services, provides a full range of products and services for large pools of investment assets. State Street Corporation is also the world\'s leading specialist in providing institutional investors withinvestment servicing, investment management and investment research and trading

Implemented data sourcing project to meet data requirements of various data consumers like Credit Risk, Economic Capital, Operational Risk, Regulatory Capital and Market Risk business operations. The project was to consolidate data from various sources and load it into staging area. Perform cleansing and data normalization in the staging database. Load data from staging database to a star schema data warehouse.

Responsibilities:

• Worked with users & analysts to understand requirements
• Participated in client meetings to review Integrated Data approaches and to interpret results
• Closely involved in gathering requirement, design, development and implementation of the project
• Defined the testing requirement documents
• Worked with Development Team to draft the Development Checklist and Plan for Iteration Releases
• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing
• Performed database validation according to the business logic by comparing the source to the target in Spreadsheet
• Work with source system personnel on source data delivery issues .Interacted with DBA for setting up test environment
• Created the test environment for Staging area, loading the Staging area with data from multiple sources
• Extraction of test data from tables and loading of data into SQL tables
• Mapped Requirements to test cases (Traceability) for SIT and UAT in Requirements module of Quality Center
• Updated Traceability Matrix for Testing Specs changes, after change requests (CR) executed
• Involved in testing data integration, system integration and business workflow
• Reported defects in timely manner and logged the same into defect tracking tool
• Review test specifications, cases and performed manual testing
• Developed and tested UNIX shell scripts as part of the ETL process
• Automated the process of loading, pulling the data for test data setup
• Involved in Backend Database testing in Oracle using SQL
• Followed State Street defined ETL Standards and Best Practices

Environment: QC, QTP, Clear Quest, Clear Case, Ascential DataStage 7.5, Oracle 10g, UNIX, SQL*plus, Windows NT and Autosys

Confidential,MA
Project 2: AML November 2007 to January 2009

The Anti Money Laundering Solution Project provides an automated solution to the regulatory requirements imposed by the Bank Secrecy Act. This project provides automated suspicious activity detection and reporting functions through individual customer transaction monitoring, customer peer group profiling, rules-based analytics using industry best practices & case management.

Responsibilities:

• Preparation and execution of test cases.
• Executed test cases manually to perform Integration testing, compared and analyzed actual with expected results and reported all deviations to the appropriate individual(s) for resolution using Quality Center, along with logging defects with details and following up.
• Performed verification of UNIX logs using Putty while performing the testing.
• Developed and executed SQL queries for backend testing using SQL Navigator.
• Performed back-end testing manually by generating SQL queries.
• Involved in Performance testing, System Integration testing and User Acceptance Testing.
• Conducted the defect review meetings daily with Development team.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Extraction of test data from tables and loading of data into oracle tables using SQL.
• Performed Integration Testing, System Testing, Functionality Testing and Regression Testing.
• Performed extensive manual testing before doing the automation.
• Identified and thoroughly analyzed defects, issues, risks, and action items along with identifying the business requirements & the system requirements as part of the project team.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with Data Extraction, Transformation and Loading (ETL)
• Preparation of Test Report and Defect Log.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Submission of weekly status reports.

Environment: QC, QTP, Clear Quest, Clear Case, Ascential DataStage 7.5, Oracle 10g, UNIX, SQL*plus, Windows NT and Autosys

Confidential,MA
Project: Masterful Redesign of Extract Delivery August 2006 to October 2007

The intent behind the project is to improve the efficiency with which we deliver extracts while reducing costs. An extract is, a detailed claim’s (Medical, Behavioral, Pharmacy, Member, and Provider) information extracted out of Harvard Pilgrim source systems which is customized and designed specifically as per the requirements and specifications agreed upon by HPHC and its vendors.

Responsibilities:

• Performed verification of UNIX logs using Putty while performing the testing.
• Developed and executed SQL queries for backend testing using SQL Navigator.
• Able to work in tight schedule and on different applications at the same time.
• Prepare Test cases in QC by analyzing the requirements thoroughly.
• Created Test Data and Traceability Matrix.
• Used Autosys to run, schedule and monitor jobs and failed jobs are reported as defects.
• Completely tested and verified that the source data is extracted correctly, transformed and loaded into the report, SQL server data warehouse.
• Attended triage and cross functional meetings to facilitate direction, discuss the priorities of defects logged and delivery time.
• Performed extensive Backend Testing by developing, modifying, and executing SQL queries for data

validation and data verification on database.

• Provided a weekly project report that includes Test Metrics and status reports.
• Co-ordinate with the whole testing team to ensure total quality control on all deliverables.
• Tested different Reports that will be generated for the vender needs.

Environment: QC, Ascential DataStage 7.1.2/7.5.2, Oracle 9i/10g, PL/SQL, Teradata, UNIX, Autosys, Cognos.

Confidential,NC
Project: Sales Forecast DataMarts May 2005 to July 2006

Mylan Laboratories is a leading pharmaceutical company manufacturing different types of generic and branded products. The project involved identifying user requirements and analyzing the existing data sources and future sales forecast of the company.
Ascential DataStage 7.5 was used to extract data from various sources and loading into a DataMart. The majority of the work was around cleansing and transforming the data. The design was done using Erwin adopting Star schema methodology.

DataMart provides information about the current and future sales/situation based on the information received from the Data Warehouse.

Responsibilities:

• Worked with the DW Architecture team in Testing complex Delta processing Loads
• Designed the high-Level design documents for Heterogeneous Interfaces.
• Involved in creating both positive and negative test data to cover all business scenarios
• Cleanse incoming data from various sources with conformance to the existing business standards.
• Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
• Analyzed and reviewed project documentation, business requirements to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Responsible for testing data load into dimensional data model using Ralph Kimball methodology.
• Performed quality assurance reviews on all System Development Life Cycle.
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.
• Performed extensive manual testing before doing the automation.
• Prepared and Documented the test scripts for functional and regression testing
• Created Test input requirements and prepared the test data for Data Driven testing.
• Used Test Director to track and report system defects and bug fixes. Written modification requests for the bugs in the application and helped developers to track and resolve the problems.

Environment: Ascential DataStage 7.5, Oracle 9i/8i, SQL*Loader, UNIX Shell Scripting, SQL*plus, Windows NT, ERWin 3.5.

Confidential,India
Project: Demand Management September 2004 to April 2005

i2 Demand Manager has been created using i2’s experience from helping hundreds of market-leading companies build a best-practice process and software solution for managing consumer demand. The product was to manage sales data, transfer and transform market data and load accurate financial information to oracle databases to analyze and forecast the demands.

Responsibilities:

• Analyzed user requirements
• Interact and coordinate with clients to gather information about the product
• Develop jobs using DataStage (parallel jobs) that will produce interface files.
• Design and develop complex transformations in DataStage to do multiple look-ups when loading the incoming source data.
• Use DataStage for moving the data to multiple databases and transforming the data.
• Test DataStage jobs and preparing the unit test cases.
• Create shell scripts to run Data Stage jobs.
• Extensively worked with DataStage – Manager, Designer, Director and Administrator to load data from flat files, SQL Server to target Oracle database.
• Compiled and ran the jobs in parallel using DataStage Parallel Extender to reduce time and improve performance.
• Used DataStage Manager to migrate jobs to the testing environment and import Meta data.
• Developed job sequencers to maintain dependency on data loads.
• Designed and developed complex transformations in DataStage to do multiple look-ups when loading the incoming source data.
• Create shell scripts to run Data Stage jobs.
• Writing Jil in Autosys to schedule jobs

Environment: Ascential DataStage 7.5, Oracle 10g, SQL*plus, UNIX and Windows NT

Confidential,India
Project: FinDNA January 2004 to August 2004

finDNA® monitors customers, account and transaction information to detect money-laundering activities with unerring accuracy and if any suspicious previously unknown behavior provides early reports - warning alerts of suspicious money laundering activities.
Core components of finDNA® are customer profiling, risk based transaction monitoring through advance techniques, alert/case management, watch list monitoring, know your customer (KYC) document management, a user friendly reporting interface where reports can be defined and printed by regulatory organizations. Other Additional supporting components are batch integration, secured transfer of files, a friendly user interface and many more. The project was to fetch data from various source files and do lookup against watch list files.

Responsibilities:

• Analyze functional specifications and write design documents
• Develop ETL batch to load comma separated watch list files to database
• Develop user friendly GUI framework for finDNA®
• Secure transfer of watch list files using Java API’s
• Test DS Batch jobs, GUI and preparing the unit test cases
• Created and maintained test library of generic User-defined functions.
• Created data table and parameterized the tests.

Environment: Java, C++, Ascential DataStage 7.5, Oracle 9i/8i, SQL*Loader, UNIX and Windows NT.

Confidential,India
Project: Samvahak April 2003 to December 2003

This product was developed for the defense to monitor operational preparedness. The project was to create and design the operations plan on the sand models which will be tested during the defense exercises.

Responsibilities:

• Develop web screens using EJB framework
• Fetch, validate, transform and load data using database level framework and transaction level framework
• Validate data using the validation rules and JSP scripts

Environment: Java J2EE, JSP scripts, Oracle 8i, SQL*Loader and Windows NT.