SUMMARY

• 9 years of experience in software Analysis, Design and Software Quality Assurance Testing (Manual / Automation) of Client Server and Web Applications.
• Over Five years of experience in Testing Data Warehouse and ETL Applications.
• Experience with QA Methodology and QA Validations to ensure the Quality Assurance Control.
• Experience in using HP/Mercury Interactive (Win Runner, Test Director, Load Runner, and Quick Test Professional) and Rational Tools for Quality Assurance.
• Strong in Analyzing Business specifications and Use Cases and Developed Test Plans, Test Scripts and Test Cases and Executed them.
• Extensive experience in Unit, Functional, Integration, Regression, User Acceptance, System, GUI, Load, Stress, Performance Testing.
• Experience working in Production and Development support.
• Implemented the software development lifecycle (SDLC) for the testing life cycle to follow the Standards process in the application.
• Experience with industry standard methodologies like RUP, Agile and CMM.
• Experienced in Database Testing using SQL queries on RDBMS databases like Oracle and SQL Server.
• Extensive experience in White Box & Black Box Testing.
• Experience with Object Oriented Programming, UML concepts, design patterns, and web Technologies.
• Expertise in Problem solving and Bug Reports using Bug Tracking Tools.
• Excellent communication skills, Documentation Skills, Team problem solving ability, analytical and programming skills in high speed, quality conscious, Multitasked environment.

TECHNICAL SKILLS

Testing Tools: ALM11, Quality Center 8.0/9.0/10.0 , Test Director 6.0/7.0/8.0, Win Runner 5.0/6.0/7.0, Load Runner 10.0, Quick Test Professional 9.5, Requisite Pro and Clear Quest

Databases: Oracle 10g/9iAS/8i/8.0/7.3, Sybase ASE 12.5.1

Database Tools: TOAD, SQL*PLUS, SQL*LOADER, SQL Developer, JDeveloper, Aqua Data Studio

Scripting Languages: UNIX Shell, Java, JDeveloper, Java Script, EJBS, JDBC, PERL

Languages/Packages: SQL, PL/SQL, C, C++, JAVA, JSP, COBOL, HTML, DHTML

Data Warehousing: Informatica Power Center 8.1.1/7.1/6.0 , DataStage, Ab Initio.

Operating Systems: UNIX, Linux, Windows XP/2000/NT, MS - DOS

Other Tools: Harvest, Maestro, Lotus Notes, Autosys, Excel Macros

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

ETL Test Lead

Responsibilities:

• Managed requirements and their attributes using ALM11 / Quality Center.
• Developed Master Test Plan, Test Strategy, Work Flow diagram and Test Cases in ALM11/ Quality Center.
• Managed and Mentored Jr. Testers for developing and executing Test Scripts.
• Coordinated Data Maps Review sessions with Data Analyst’s and ETL Developers
• Wrote SQL Queries(Minus and Reverse Minus Queries) to verify the data being populated in Source and Target tables
• Performed Integration, System, Regression and smoke testing to test the application functionality.
• Conducted End to End testing manually.
• Involved in creating test data and populating the test environment.
• Performed User Acceptance testing and regression testing
• Tested the Source and Target databases (DB2, Oracle, Operational Data Store (ODS) and SQL Server Management Studio).
• Wrote SQL queries and statements to verify values in backed with respected to the specific operation performed by the fronted.
• Extensively used SQL and PL/SQL for data integrity testing at the backend.
• Wrote UNIX shell scripts to perform batch tests.
• Extensively worked on Defect Manager of ALM11 / Quality Center for bug reporting/tracking.
• Performed regression testing once the defects are fixed.
• Interacted with programmers to identify and resolve technical issues.
• Participated in Defect review meetings with both the stakeholders and developers.
• Participated in weekly review meetings and GO/NO-GO meetings.
• Developed Defect Summary Report and Test Summary Report once the testing is done

Environment: Oracle 9i/10g, SQL, PL/SQL, DB2, SQL Server Management Studio, UNIX, SQL*Loader, TOAD, JADE, HP Interactive tools (ALM11, Quality Center, Load Runner and Quick Test Professional) and Rational Tools for Quality Assurance.

Confidential, Minneapolis, MN

Sr. ETL Tester / Lead

Responsibilities:

• Managed requirements and their attributes using JADE / Quality Center.
• Developed Master Test Plans and Test Cases in JADE / Quality Center.
• Managed Integration, System, Regression and smoke testing to test the application functionality.
• Conducted End to End testing manually.
• Involved in creating test data and populating the test environment.
• Wrote SQL Queries to verify the data being populated in the various tables
• Performed User Acceptance testing and regression testing
• Automated the scripts using QTP.
• Tested the ETL processes and ETL mappings using Informatica.
• Executed ETL workflows in Informatica Workflow Manager to extract data from source database and load into target database.
• Verified Informatica session logs.
• Involved in testing Informatica reports and tested various classes, filters and conditions in the cubes.
• Tested the Source and Target databases (DB2, Oracle, Operational Data Store (ODS) and SQL Server 2008).
• Extensively used Ab Initio Error functions and String functions like is valid, is error, is defined, string substring, string concat for various Data Validations.
• Tested Ab Initio Components like Reformat, Joins, Rollup, Scan, Partition by round robin, Partition by key, Join, Gather, Replicate, Merge Developed graphs.
• Validated Graph Phases and checkpoints to avoid Deadlocks and also involved in Testing and debugging of the Graphs.
• Part of Interface testing Extracted and reformatted data from different heterogeneous data sources like DB2, Oracle, Operational Data Store (ODS), SQL Server using Ab Initio.
• Wrote SQL queries and statements to verify values in backed with respected to the specific operation performed by the fronted.
• Validated Conditions, Rules by using SQL and PL/SQL
• Wrote SQL statements to extract data from the Tables.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Used Ab Initio GDE to generate complex graphs for transformation and Loading of data into Staging and Target Data base area.
• Was involved in writing and executing various UNIX shell scripts for updating tables and creating usage files.
• Created Test Scripts and assisted in User Acceptance Testing.
• Generated XML files based on XML schema.
• Worked with SQL and PL/SQL to test database integrity.
• Maintain defects in JADE / Quality Center and participated in defect review meetings and GO/NO-GO meetings.
• Validated the files in UNIX environment and worked with UNIX scripts.
• Coordinated with Project managers, users and development teams.

Environment: Informatica Power Center, Ab Initio GDE, Oracle 9i/10g, SQL, PL/SQL, DB2, Teradata SQL Assistant, Autosys, UNIX, SQL*Loader, TOAD, JADE, HP Interactive tools (Quality Center, Load Runner and Quick Test Professional) and Rational Tools for Quality Assurance.

Confidential, Charlotte, NC

Sr. QA Analyst

Responsibilities:

• Managed requirements and their attributes using JADE / Quality Center.
• Developed Test Plans and Test Cases in JADE / Quality Center.
• Performed Integration, System, Regression and smoke testing to test the application functionality.
• Conducted End to End testing manually.
• Involved in creating test data and populating the test environment.
• Wrote SQL Queries to verify the data being populated in the various tables
• Performed User Acceptance testing and regression testing
• Automated the scripts using QTP.
• Was involved in writing and executing various UNIX shell scripts for updating tables and creating usage files.
• Created Test Scripts and assisted in User Acceptance Testing.
• Generated XML files based on XML schema.
• Worked with SQL and PL/SQL to test database integrity.
• Maintain defects in JADE / Quality Center and participated in defect review meetings and GO/NO-GO meetings.
• Validated the files in UNIX environment and worked with UNIX scripts.
• Coordinated with Project managers, users and development teams.

Environment: Oracle 9i/10g, PL/SQL, Sybase 12.5.1/15.0 , UNIX, SQL*Loader, ASP.NET, VB.NET, TOAD, SQL Developer, JADE, Mercury Interactive tools (Win Runner, Load Runner and Quick Test Professional) and Rational Tools for Quality Assurance.

Confidential, OH

Sr. DW Tester

Responsibilities:

• Participated in Requirement Analysis, Business Analysis, Use-Case Analysis and Gap Analysis.
• Developed Test Plans, Test Cases, Test Scripts, Test Scenarios, Test Beds, Test Data and Traceability Matrix.
• Agile/Scrum was followed through out the project and all artifacts are generated for each discipline.
• Conducted Integration, System, Functional, GUI, Regression, Smoke, Database Integrity, User-Acceptance (UAT) and Performance testing.
• Test Management was done using Rational Test Manager
• Managed the requirements using Rational Requisite Pro
• Involved in automating Applications using Load Runner, PAIT eXT and Funit tools.
• Developed Test Cases and Test Design using techniques (Equivalence Class Partitioning, All-Pairs and Boundary Value Analysis)
• Developed Test scripts, used various verification checks and developed reusable functions using Test Manager.
• Used the DataStage Designer to develop various jobs processes for extracting, cleansing, transforming, integrating, and loading data into data warehouse database
• Used the DataStage Director to schedule jobs, testing and debugging its components and monitoring of results
• Worked with DataStage Manager for importing metadata from repository, new job Categories and creating new data elements.
• Extracted and transferred source data from SQL Server, Teradata and Oracle databases.
• Worked extensively with Database Procedures, Functions, Cursors, Joins and Triggers using PL/SQL to apply business rules.
• Integrated the entire Performance Application through DataStage Sequencer and scheduled accordingly.
• Prepared specifications, Unit Test plans, and test cases for the Data warehouse related jobs.
• Involved in creating DataStage jobs for DW Dimensions and implemented Slowly Changing Dimension Validating the source and the target Tables.
• Schema validation, Inbound and Outbound Data Validation.
• Extensively worked on Ab Initio Error Functions, String Functions, Graphs and components.
• Created SQL scripts for verifying the ETL process as part of the Enterprise Data Warehouse.
• Worked with SQL, PL/SQL and functions to test the database integrity (Oracle).
• Worked with UNIX Shell Scripts.
• Tracked the defects using ClearQuest and generated defect summary reports.
• Maintained Test Logs, Test Summary reports and participated in defect review / Status / GO-NOGO Meetings.
• Configuration management / Version control was done using ClearCase.

Environment: Rational Suite 7.0 (Test Manager, RequisitePro, Robot, Rational Rose, Clear Quest), Mainframes, VSAM, QMF, TSO/ISPF, JCL, COBOL/DB2/SQL, ASP.NET, VB.NET, C#, IIS, DataStage Designer, DataStage Manager, DataStage Director, Business Objects, Ab Initio GDE, MS Office, HTML, Oracle 8i, TOAD, MS-Project, Windows 2000/NT, UNIX, Crystal Reports 8.0.

Confidential, Camp Hill, PA

Sr. QA Analyst

Responsibilities:

• Analyzed the business requirements and use cases to understand best about the application.
• Interacted extensively with stakeholders and developers.
• Developed detailed Test Plan for two iterations and Test Cases and executed them.
• Identified the test cases that are to be automated and those that are to be manually done.
• Managed requirements using Requirement Plan Manager of Quality Center.
• Documented Test Cases corresponding to the business requirements in Test Plan Manager of Quality Center.
• Involved in automating Applications using QTP.
• Developed requirements traceability matrix between requirements and test cases to ensure maximum coverage of the requirements.
• Followed Rational Unified Process across Software Development Life Cycle.
• Conducted GUI testing, Functional testing, and Smoke Testing, Integration Testing, Performance and User Acceptance testing on the application.
• Tested the ETL processes and ETL mappings using Informatica.
• Verified Informatica session logs.
• Wrote SQL statements to extract data from the Tables.
• Extensively used SQL and PL/SQL for data integrity testing at the backend.
• Wrote UNIX shell scripts to perform batch tests.
• Version control and configuration management was done using PVCS Tracker.
• Trained Beginners and intermediate QA Testers on Win Runner and on bug reporting tool
• Extensively worked on Defect Manager of Quality Center for bug reporting/tracking.
• Performed regression testing once the defects are fixed.
• Interacted with programmers to identify and resolve technical issues.
• Participated in Defect review meetings with both the stakeholders and developers.
• Participated in weekly review meetings and GO/NO-GO meetings.
• Developed Defect Summary Report and Test Summary Report once the testing is done.

Environment: Mercury Suite (Test Director 8.0/ Quality Center, QTP 8.0), Informatica, Business Objects, Mainframes, Java, J2EE, JavaScript, Oracle 8I/9i PL/SQL, MQ Series, SQL Plus, XML, WebLogic, UNIX Shell Scripts, Windows 2000.

Confidential

Software Engineer

Responsibilities:

• Involved in analyzing functional requirements, designing and coding process requirements
• Building client relationships and help identify prospects
• Developing and testing applications to meet the business process requirements
• Involved in designing the database
• Maintained project documentation to support SDLC
• Worked closely with testing groups for unit, module and integration testing
• Customized Reports to change layouts as per business requirements following SDRO methodology (Suppress, Display, Required, Optional)
• Design and implement Test Strategies, Test plans and Test cases.
• Manual Testing of application and identify test cases for automation.
• Involved in user group presentation, training and transfer of knowledge to technical support team
• Close interaction with Team members, Developers, Business Analyst and Project Management.

Environment: Oracle 9i, PL/SQL, C, C++, UNIX, Java, TOAD, SQL Developer, SQL*Loader, ClearCase, Test Director 7.0