PROFESSIONAL SUMMARY:

• 7+ year’s Professional experience wif in depth understanding of all phases of SDLC, STLC, focusing on translating business requirements into viable technical solutions.
• Excellent technical writing skills wif hands on experience reviewing Business Requirements Documents, Software Requirement Documents, Functional, Mapping Documents, E - R Diagrams, Test Plans, Test Scripts and Execution and Status Reports.
• In depth knowledge of Different Domain like Insurance, Finance, Banking etc.
• Experience leading medium sized Teams spread across multiple time zones and countries.
• Expertise in Test Management using HP Quality Center 10, HP Application Lifecycle Management 11.00, 11.52 to document Test Cases and conduct triage and status meetings to resolve issues.
• Experience working wif huge volumes of data, analyzing record sets for Data Completeness, Data Correctness, Data Quality, Data Validation etc. using SQL and / or PL/SQL.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica and SSISand generating Business Reports using Business Intelligence tool like SAS, Micro strategy, BO etc.
• Proficient in using automated testing tools like Quality Center and QTP.
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server, MS Access, IBM DB2 and Sybase) and familiar wif concepts of SQL queries ranging from DML, DDL and TCL
• Experience in testing Business Intelligence reports generated by various BI Tools like SAS, Microstrategyand Business Objects.
• Experience working wif various software development methodologies including Waterfall and Agile Scrum.
• Excellent knowledge in Oracle Database, Teradata, MS SQL Server, IBM DB2, Sybase Systems and UNIX Platform.
• Ability to interact wif developers and product analysts regarding testing status and to maintain detailed QA documentation.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently wifin time frame.
• A quick learner who can swiftly adapt to new challenges.

TECHNICAL SKILLS:

Data Warehousing: Informatica8.6/8.1/7.1/6.1, SSIS (SQL Server Integration Service), AbInitio Co>Op 2.15, Data Stage 8.x

Reporting Tools: SAS, Micro Strategy, Business Objects XIR3/XIR2/6.5, Cognos 8 Suite

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling for Fact, Bridge and Dimension tables using Pivot Tables, Erwin etc.

Testing Tools: HP Quality Center 10, 11.00, 11.52, Quick Test Pro (QTP), Rational Clear Quest

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2008 R2, MS SQL Server 2005, Teradata V2R6, MS Access 7.0, IBM DB2, Sybase

Programming: UNIX Shell Scripting, SQL, SQL*Plus, PL/SQL, TOAD.

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

Environment: UNIX, MVS, HP-UX, IBM AIX 4.2/4.3, Win 3.x/95/98, NT 4.0, Sun-Ultra, Sun-Spark, Sun Classic, and SCO

PROFESSIONAL EXPERIENCE

Confidential, Virginia, VA

Credit Data Mart Tester

Responsibilities:

• Responsible for writing test cases, test steps using HP ALM 11.00 or 11.52, test scripts, executing test cases in Test Lab, mapping executed test cases to the requirements
• Responsible for testing Single Family Credit Data Mart using Shell script.
• The credit data mart exists in Oracle 11g database and the transactional database sits in either IBM DB2 or Sybase.
• ETL Informatica runs the job to extract data either from DB2 or Sybase, transform the data in accordance wif the business rules and load the data in Single Family credit data mart sits in Oracle 11g.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Tested several Informatica Mappings to validate the business conditions
• Validated the Micro Strategy financial report for Single Family Credit Data Mart using SQL.
• Did testing on ETL Informatica process for various data loading scenarios
• Responsible for validating financial report generated in SAS for Mortgage Loan Integrated System for both Multi Family and Single Family
• Responsible for validating expected and actual using Beyond Compare 3, Excel and SAS script
• Responsible for documenting the comparison using Excel or Word.
• Responsible for generating daily reports in HP ALM
• Responsible for validating reports generated in Micro Strategy for Multi Family Credit Enhancement Report

Environment: Informatica 9, HP ALM/Quality Center 11, QTP, SQL, PL/SQL, Microstrategy, SAS, DB2, UNIX, PERL, Korn Shell Scripting, Oracle 11G

Confidential, Worcester, MA

EDW (Enterprise Data Warehouse) Tester- Healthcare Enterprise Data Warehouse

Roles and Responsibilities:

• Responsible for testing data migration through conversion from legacy EDW existed in Oracle to new EDW in SQL Server 2008 R2.
• Responsible for coordinating testing based on the business requirements throughout data migration through conversion from Oracle to SQL Server.
• Responsible for validating data by count match and data match after running ETL future track on top of conversion in ODS.
• Responsible for writing SQL scripts to handle type2 scd columns as well as type1 scd columns for dimension tables in conversion using SQL Server Management Studio 2008 . after conversion is done ETL future track runsystems ODS and EDW which were accomplished by two different teams.
• Responsible for writing SQL scripts to handle type1 scd columns for dimension tables, bridge tables and fact tables in conversion using SQL Server Management Studio 2008 .
• Developed test plans wif test scripts to manually execute conversion, ETL and BI test cases following conversion/ETL procedure/mapping and AGILE Methodology.
• Tested Informatica Mappings and worked on Staging area to validate the data wif SQL Queries
• Designed and kept track of Requirement Traceability Matrix using QC.
• Used Quality Center for loading test cases and writing Test Plan, executing Test Cases, tracking defect and printing status report for the team meetings.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested data warehouse ETL process using SSIS (Integration Service)
• Tested all the backend programs, BO Mappings and update processes.
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Automated testing using Quick Test Pro (QTP) scripts and also performed manual testing.
• In the process of data migration, migrated data from an Oracle data source to SQL Server 2008.
• Coordinate and helped in testing the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down and Drill Up, Cross Tab, Master Detail and Formulae etc.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing and worked on test data and completed unit testing to check all business rules and requirements are met. Tested for negative data to check dat the job fails on any critical error.
• Responsible for writing complex SQL to clean data from source in Oracle and in SQL Server

Environment: HP Quality Center 10.0, SSIS,Informatica 9, QTP, SQL, PL/SQL, Business Objects 3.1, EME*, SQL Server Management Studio 2008, 2005, MS Sharepoint, MS Outlook, Oracle 11g, 10G. Beyond compare 3. MS XL.

Confidential, Richmond, VA

Data Warehousing Tester - Credit Card Data Mart

Roles & Responsibilities:

• Responsible for coordinating testing based on the business requirements throughout both systems ODS and EDW which were accomplished by two different teams.
• Developed test plans and manually executed ETL and BI test cases following ETL procedure/mapping and AGILE Methodology.
• Designed and kept track of Requirement Traceability Matrix
• Validated the data of reports by writing T-SQL queries in PL/SQL Developer against ODS
• Used Quality Center for loading test cases and writing Test Plan, executing Test Cases, tracking defect and printing status report for the team meetings.
• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Tested all the backend programs, Informatica Mappings and update processes.
• Worked as Onsite Coordinator for getting the work done from offshore team.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• In the process of data migration, migrated data from an Oracle data source to Teradata.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing and worked on test data and completed unit testing to check all business rules and requirements are met. Tested for negative data to check dat the job fails on any critical error.
• Did automation using PERL and UNIX Shell scripting.
• Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
• Tested several Informatica Mappings to validate the business conditions
• Tested several data migration application for security, data protection and data corruption during transfer
• Responsible to help testing team on creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment:menformatica 8.6.1, HP Quality Center 10.0, QTP, SQL, PL/SQL, Business Objects XIR3, EME*, Mainframe Flat Files, Teradata 12.0 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant, COBOL II, UNIX, PERL, Korn Shell Scripting, Oracle 10G, DB2, TOAD9.7

Confidential, Warren, New Jersey

Data Warehouse Tester

Roles & Responsibilities:

• Organized and imparted training to newcomers in the team regarding different technologies like SQL, PL/SQL and different processes.
• Attended Client calls for gathering and understanding Business requirements, clarification and analysis.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Tested various jobs and performed data loads and transformations using different stages of Informatica and pre-built routines, functions and macros.
• Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance.
• Extract data from Mainframe data sets to compare against Target Values.
• Written complex SQL queries for validating the data against different kinds of reports generated by Business Objects XIR2
• Reported bugs and tracked defects using Quality Center 9.2
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
• Did data validation on Teradata using Teradata SQL Assistant and BTEQ.
• Performed Front-End, Functionality, Data driven and Web Based testing using Quick Test Pro (QTP)
• Executed and written UNIX shell scripts to check whether data import/export done correctly or not.
• Worked wif data reconciliation for the entire data migration project for both target system and rejected records.
• Written PERL scripts and UNIX Shell Scripts for various data comparison and data parsing needs.
• Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
• Tested the reports using Business Objects XIR2 functionalities like SQL Queries for validating data against different kinds of reports, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Performed all aspects of verification, validation including functional, structural, regression, load and system testing.
• Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check dat the job fails on any critical error.

Environment: SQL, PL/SQL, Informatica 8.6, Quality Center 9.2, QTP, Rational Clear Quest, MS Excel, Business Objects Enterprise XIR2, Oracle, UNIX shell scripts, PERL, Teradata 12.0 (Multi-LOAD, Fast-LOAD, FAST EXPORT, TPUMP, BTEQ), Teradata SQL Assistant, Korn Shell Scripting.

Confidential, Richmond, VA

Data Warehouse Tester -EDW

Responsibilities:

• Involved in creating source target mappings based on the Technical Design requirements.
• Involved in Business analysis and requirements gathering.
• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Preparation of technical specifications and Source to Target mappings.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Used Quality Center to track and report system defects
• Worked on issues wif migration from development to testing.
• Experience in loading from various data sources like Teradata, Oracle, Fixed Width and Delimited Flat Files.
• Recorded scripts using Quick Test Pro (QTP), added validations and coding to the scripts. Also used descriptive programming where recording did not work.
• Tested ad hoc and canned reports for Business objects.
• Solid testing experience in working wif SQL Stored Procedures, triggers, views and worked wif performance tuning of complex SQL queries.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Extracted certain column of data from a number to files using PERL.
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Worked wif ETL group for understating mappings for dimensions and facts.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Tested Business Objects reports and Web Intelligence reports
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif data quality issues.
• Conducted regression testing using Quick Test Pro (QTP) after deployment of every build in Test Environment.
• Validated cube and query data from the reporting system back to the source system.
• Tested analytical reports using Analysis Studio
• Used different sources for Input.
• Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
• Created different user defined functions for applying appropriate business rules
• Written test cases and completed unit test documentation.
• Involved in pager rotation program to support 24 x 7 production support.