SUMMARY:

• 16+ years of strong experience in testing applications built using technologies like, Data Warehousing (Data Migration, Data Transfer and ETL), ERP, Internet / Web, Client - Server.
• Involved in testing application built on SAP 4.6 and Data Warehousing tools like Informatica 5.1 / 6.2/7.1,8.5,9.1/9.5.1, Informatica DVO 9.5.2.1, Abinitio (GDE 1.11, Co-Op 2.11) with reporting tools like Cognos 6.0 / 7.0, Business Objects 5.1.3/5.1.8
• Extensively performed Unit Testing, System Testing, Integration testing, Functional testing and User Acceptance Testing.
• Experienced in testing data loads in Enterprise Data Warehouse
• Experience on Automation Tools like Test Complete, Selenium (RC/Web Driver 2.0), WinRunner, Load Runner and Rational Robot
• Experience in testing Back end Services using SOAP UI Pro
• Excellent understanding of Data Models (Star schema and Snowflake Schema)
• Experienced in testing reports using Business Intelligence (BI) Tools like MicroStrategy, Cognos, Business Objects and Essbase.
• Involved in Requirements Analysis, Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.
• Expert in verifying the accuracy and completeness of data after a data migration, replication, integration or other similar movement or transformation exercise using Informatica Data Validation Option (DVO).
• Knowledgeable in all areas of the Software Development Life Cycle (SDLC).
• Strong in Trouble shooting data discrepancies and interpreting technical specifications.
• Experienced in using SQL queries for testing Data Warehouse applications.
• A team player, with good interpersonal relations and effective communication and presentation skills.

TECHNICAL SKILLS:

Operating Systems: UNIX (Solaris/Linux/AIX), Windows (95/NT/2000/XP)

Languages: Java, C, Pascal, COBOL, SQL, PL/SQL, VB, Java Script, VB Script, Shell Scripting (CSH, BASH, KSH)

Data Bases: Oracle 7.x/8i/9I, DB2, MS-SQL Server, TeraData7.1/6.1, 14.10.0.04 MS Access

Web Technologies: J2EE (Servlets, EJB, JSP), .Net (ASP. Net, VB.Net), Web Services, XML, HTML, Swing, AWT

Reporting Tools: Cognos 6.0/7.1, Business Objects 5.1.3/5.1.8, MicroStrategy 7i

App Server: WebLogic 6.x/7.x/8.1, Websphere 4.x/5.x, Tomcat, Sun One

Modeling Tools: Visio 2000, Rational Rose (UML), Erwin

ETL (Data Warehouse): Informatica 5.1.1/6.2.2, Abinitio (GDE 1.11, Co-Op 2.11)

Version Control: CVS, Harvest, Clear Case, VSCC

Bug Reporting Tool: Test Director, DVO, Clear Quest, Excel

Query Reporting Tools: Websphere QMF, SQL Navigator 4.x/5.x, TOADTeraData SQL Assistant 6.2, Queryman 6.0

Testing Tools: Mercury Tools (WinRunner7.x, Test director6.x, 7.x, 8.0,LoadRunner 6.x, 7.x, QTP), Rational Suite (Rational Robot, Requisite Pro, Test Manager, Clear Case, Clear Quest)

PROFESSIONAL EXPERIENCE:

Senior Data warehouse tester

Confidential

Responsibilities:

• Created SQL views and join views for the table pairs in DVO.
• Generated Reports out of DVO for the leadership team to give a sense of the test coverage via DVO scripts.
• Updated parameter files in Serena Dimensions before executing the workflows in workflow manager and monitored the load in workflow monitor.
• Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.
• For the failure loads, Performed root cause analysis through session logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Created different scenarios Developed SQL queries to validate data in Data warehouse and Data mart.
• Performed System Integration, User Acceptance and Regression Testing.
• Worked with HP QC for logging defects.
• Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.
• Coordinated and worked closely with Operations team on the release activities.
• Used WinSCP to copy files to server.
• Attended the regular meeting and update the testing status.
• Imported the Sources from Data base using the designer and refreshed the DVO created folders to see the sources in DVO tool
• Coordinated with the Development team and the Product team in understanding the STTM clarifications on requirements and defects
• Based on the STTM logic created DVO scripts and SQL scripts to validate data from source to stage to Target tables
• Currently working on MSP and created DVO scripts for validating between User File and view (Flattened table)
• Attended Lending BIO test planning and review session planning meeting and discussed about the overall test status
• Tested the CDC (change data capture) functionality of the data warehouse by creating DVO and SQL scripts

Environment: Informatica 9.5.1 hotfix 2.0,9.6.0, Informatica DVO 9.5.2.1,9.6.0,UNIX (IBM AIX), Windows 7, SQL Assistant 14.10,TeraData 14.10.0503, Java, Spring suite 3.1.0.Release, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, HP Quality Center 10,cognos,WinSCP,Putty

Test Lead

Confidential

Responsibilities:

• Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.
• For ETL performed Constraint testing, source to target counts, source to target validation, error processing.
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in Data warehouse and Data mart.
• Validated reports generated from Micro Strategy.
• Validated report data by writing and executing SQL queries against the Mart data base.
• Used Test Complete automation tool for Regression testing
• Perform integration, regression, and functional testing on changes/enhancements.
• Created the Common libraries/Functions
• Used Object SPY to recognize the Objects on the Browser
• Created test data in an Excel sheet for the Data Driven testing.
• User both xlDriver and Test complete variables for reading the test data prepared in Excel
• Performed System Integration, User Acceptance and Regression Testing.
• Worked with Rally for logging defects.
• Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.
• Involved in improving the QA Process.
• Used SOAP UI Pro for backend web service testing
• Created product specific Test plan.
• Coordinated and worked closely with Operations team on the release activities.
• Created the Regression plan and assigned the task to the team members and ensure that all of them have sufficient work for the release activities.
• Involved and worked in updating the Release deployment plan for different environments (QA/Stage/Prod).
• Performed root cause analysis through logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team.
• Involved in creating the Deployment Validation plan for all the four environment (i.e. QA, DEV, Stage and Prod)
• Trained and Mentored Junior team members

Environment: Informatica 8.5/9, UNIX (IBM AIX), Windows 7, Oracle 9,10g,11g, TOAD 10.6.0.42, SQL Server, Micro Strategy 8,9, Test Complete, Java, Spring suite 3.1.0.Release,, TortoiseSVN 1.7.11, Rally, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point,, Web services (REST), JSON, XML,SOAP UI Pro

Senior QA Engineer

Confidential

Responsibilities:

• Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.
• For ETL performed Constraint testing, source to target counts, source to target validation, error processing.
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in Data warehouse and Data mart.
• Created tests and ran those tests whenever Power Center loads a batch of data to the target using Data Validation Option (DVO).
• Using the GUI included in the DVO compared the data in the source and target by running table pair tests.
• Validated reports generated from Micro Strategy.
• Validated report data by writing and executing SQL queries against the Mart data base.
• Used Selenium RC/Web driver 2.0 for Regression testing
• Created the Common libraries/Functions
• Used Firebug to find/inspect HTML elements present in the page
• Used Xpath and CSS to locate an element based on associated class.
• Performed System Integration, User Acceptance and Regression Testing.
• Used to store the settings for each user in a unique user configuration directory using DVO.
• Worked with Rally for logging defects.
• Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.
• Created Table Pairs using the enterprise license of DVO to increase test performance and to store all error records from each table-pair test.
• While using DVO Table Pairs used a parameter in the WHERE clause of a table pair definition to filter the records that are tested.
• Involved in improving the QA Process.
• Created product specific Test plan.
• Coordinated and worked closely with Operations team on the release activities.
• Created the Regression plan and assigned the task to the team members and ensure that all of them have sufficient work for the release activities.
• Involved and worked in updating the Release deployment plan for different environments (QA/Stage/Prod).
• Performed root cause analysis through logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team.
• Involved in creating the Deployment Validation plan for all the four environment (i.e. QA, DEV, Stage and Prod)
• Trained and Mentored Junior team members

Environment: Informatica 8.5/9, UNIX (IBM AIX), Informatica DVO 9.5.2.1,Windows 7, Oracle 9,10g,11g, DVO, TOAD 10.6.0.42, SQL Server, CombineNet, Micro Strategy 8,9, Selenium (Web Driver 2.0), Java, Spring suite 3.1.0.Release, JIRA, JIVE, TortoiseSVN 1.7.11, Rally, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Web services (REST services)

Senior EIG Tester

Confidential

Responsibilities:

• Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.
• For ETL performed Constraint testing, source to target counts, source to target validation, error processing
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in Data warehouse and Data mart.
• Validated reports generated from Business Objects.
• Validated report data by writing and executing SQL queries against the Mart data base.
• Performed System Integration, User Acceptance and Regression Testing.
• Worked with HP Quality Center for logging defects.
• Tested Web services using SOAP UI

Environment: HP Quality Center 9.2, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Informatica 8.0.1,Business Objects, UNIX (IBM AIX), Windows XP, Oracle 11g, TOAD 9.0.1,SQL Server, Spring MVC, XML, Web services, SOAP UI, XML, selenium RC

S enior ETL QA Analyst

Confidential

Responsibilities:

• Verified Datastage Jobs against the source and tested the transformations for consistency and the target table validation.
• For ETL performed Constraint testing, source to target counts, source to target validation, error processing
• Extensively tested ETL (Datastage) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each stage, from source table to staging tables and then finally to destination tables.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in Data warehouse and Data mart.
• Validated reports generated from Hyperion Essbase.
• Validated report data by writing and executing SQL queries against the Mart data base.
• Performed System Integration, User Acceptance and Regression Testing.
• Tested the drill through functionality by writing SQL queries and match it against the fact tables
• Worked with HP Quality Center for logging defects.
• Used ishare for version control.

Environment: HP Quality Center 9.1, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Datastage 8.0.1,Hyperion Essbase, UNIX (IBM AIX), Windows XP, Oracle 9i/10g, TOAD 9.0.1,Subversion, ishare

QA Analyst

Confidential

Responsibilities:

• Created Test Plan, Test cases and Test Scripts using Rational Test Manager.
• Tested ETL (Informatica) mappings for each extract in the Informatica Designer and verified the session logs through Informatica Workflow Manager.
• Used Cognos to generate monthly and quarterly reports.
• Verified Informatica Mapping against the source (NSAT, ECDB, EODB), tested the transformations for consistency and the target table validation.
• For ETL performed constraint testing, source to target counts, source to target validation, error processing
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.
• Validated the data at each transformation. From source table to staging tables and then finally to destination tables.
• Trained and mentored team members with product knowledge and business processes.
• Worked in both Data Warehouse Models (Star and Snowflake Schema)
• Developed SQL queries to validate data in IODS, Data warehouse and Data mart.
• Validated report data by writing and executing SQL queries against the data base.
• Validated CDC (Change Data Capture) Power Exchange Functionality in IODS.
• Tested the functionality by writing SQL queries and match it against the fact tables
• Performed Integration, System and Regression Testing. Assisted the users with User Acceptance Testing (UAT) and logged defects using Rational ClearQuest.
• Used Rational ClearCase for version control.
• Used PGP Desktop for downloading the encrypted files

Environment: Rational Test Manager, ClearQuest, ClearCase MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Informatica 8.1.1/8.5.1, Informatica Power Exchange (PWX)8.5.1, Cognos, UNIX (IBM AIX), Windows XP, Oracle 9i/10g, TOAD 8.5.1/8.5.3, PGP Desktop 9.8.3

QA Analyst

Confidential

Responsibilities:

• Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.
• Scope includes the Following Line of Businesses (LOB’s) i.e. Wholesale (WDW, WSD, EBE), Correspondent, Retail.
• Developed Test Plans, Test Scenarios and Loan Scenarios.
• Validated Data across all the systems.
• Prepared Data validation Test Manual.
• Validated Informatica mappings using the mapping document.
• Wrote SQL queries to validate data in data warehouse and data mart.
• Validated report data by writing and executing SQL queries against the database.
• Performed IST, UAT and Regression Testing.
• Validated reports generated from Cognos.
• Retrieved files from Rule Admin, Hula Dashboard, DC compass, TSO and assigned them to testers along with E2E (End to End Documents) for data validation.
• Worked with Rational ClearQuest for logging defects.
• Prepared queries in Rational ClearQuest for all lines of Business

Environment: Rational Test Manager, Rational ClearQuest, Mainframe (TSO, CICS), DB2, MS Excel, Microsoft Visio 2000, NDM, MS Word, MS Power Point, DC Console, Informatica 7.1, Cognos 7.1, Hula Dashboard, Rule Admin, UNIX (IBM AIX), Windows XP, VB,.net, Oracle 10g, Java

Data Warehouse QA Analyst

Confidential

Responsibilities:

• Written SQL queries using QMF Websphere to prove the data mapping and Cognos Reports. Executed AWK Scripts.
• Actively involved in creating Test Plans based on the requirements submitted by the Business analysts. The Test Plan was approved and appreciated by the Test Lead and subsequently used as a template / baseline for future Test Plans
• Interacted with developers to explain when required, software bugs and re-tested the fixed issues. Identified and documented all issues and defects to ensure application software functionality.
• Run test cases and submit defect reports. Verify fixes and run regression tests
• Performed security and authentication test on Cognos Report Net.
• Raised STR (System Trouble Reporting) for all the issues found in the application, once the issue is resolved (after retesting) we needs manager’s approval to close the STR.
• Testing is done in both IST and UAT Environments.

Environment: Abinitio (GDE 1.11, Co-op 2.11), DB2, QMF Websphere, Unix (IBM AIX), Windows XP, COGNOS Report Net, Shell Script, Mainframe (TSO), MS Excel, MS word, NDM. Test Director 8.0, TeraData, TeraData Administrator 6.1, TeraData SQL Assistant 6.1

Daa Warehouse QA Analyst

Confidential

Responsibilities:

• Informatica used as an ETL Tool. Cognos and Business Objects are used as reporting tools. Written SQL queries using TeraData SQL Assistant 6.2 to prove the data mapping and Reports.
• Tested ETL (Informatica) mappings for each extract in the Informatica Designer and verified the session logs through Informatica Workflow Manager.
• Tested the cube functionality by writing complex SQL queries in TeraData and verifying the results against the cube.
• Involved in writing Test plan and Test cases.
• Tested the cube functionality by writing complex SQL queries in TeraData and verifying the results against the cube.
• Tested the Drill down functionality on each dimension and wrote numerous SQL queries to verify it
• Used VSCC as version control.
• Validated the fields within the Business Objects Universe to that of the corresponding fields within SAP.
• Once get the needed data, generated reports for further Analysis.

Environment: Informatica power center 6.2.2,Unix (Solaris 5.8), Windows XP, COGNOS impromptu 7.1,Business Objects, Oracle, SQL, PL/SQL, Shell Script, VSCC (Visual Source Code Control)), SAP, Microsoft Excel, Business Objects 5.1,Queryman 6.0,WinDDI 5.0.1,Visio 2000, AutoSys, MS Word

Data Warehouse Analyst

Confidential

Responsibilities:

• Involved in Writing Test plan and Test cases.
• Verified the Informatica Mappings (Source definitions, transformations, Target definitions, Connectors) which represent the data flow between source and target
• Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data
• Tested the data at both staging and data mart level
• Worked with Visual SourceSafe as version control.
• Identified and documented all issues and defects to ensure application software functionality.
• Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.
• Scheduled Team Meeting to discuss the status of the Defects and Assign the New Defects to Concern person.

Environment: Oracle 9i,SQL Navigator 4.3, Informatica 5.x, Unix (Solaris 5.8), ASP, VB, Java, JSP, IIS 4.0, Rational Rose, SQL Server, SQL Analyzer, Windows XP, COGNOS impromptu 7.1,SQL, PL/SQL, Shell Script, Visual source safe (VSS), Test director 7.1, Microsoft Excel, MS Word.

Confidential

Responsibilities:

• Extensively tested ETL portion, using SQL queries for consistency while extracting / transforming / loading the data
• Involved in both functional testing and GUI testing.
• Worked extensively with harvest as version control as well as bug (DCR) reporting tool.
• Developed SQL scripts using TOAD to extract data from the target tables to prove the data mapping.
• Scheduled Team Meeting to discuss the status of the Defects and assign the new defects to appropriate team members.

Environment: WinRunner, Test director, UNIX, ASP, ASP. Net, VB, VB.Net, IIS 4.0, XML, UML, Rational Rose, SQL Server, Oracle 8i, Java, Sybase, JavaScript, JSP, Win2000/XP, TOAD, CCCHarvest (CVS), WebLogic 8.1

Confidential

Responsibilities:

• Formulated Test Plans, system Test Cases using MS Excel.
• Wrote SQL queries to validate data in data warehouse and data mart.
• Performed extensive testing of the data at both staging and data mart level
• Performed White-Box Testing (Integration Testing and Unit testing) of the application
• Documented the defects and reported to the QA lead.

Environment: Windows NT, UNIX, Java, Servlets, SQL, JDBC, JWS and Oracle