PROFESSIONAL SUMMARY:

• Senior Quality Assurance Analyst with almost 9 years of IT experience including Health Care, Retailer Systems and Public Services in Quality Assurance, Manual and Automation testing, Business Analysis and Software Development.
• Expertise in all phases of the SDLC and QA Life Cycle, with timely delivery against aggressive deadlines.
• Functional, Regression, Smoke, Performance, User Acceptance (UAT), Integration/System, White Box and Black Box Testing in both manual and automated modes.
• Experienced in using Industry standard Testing ToolsHP QTP/QC and Rational Suite. Have good exposure on testing Web Services and backend testing of Databases.
• Have an expertise in Use Case, state, sequence, activity and collaboration diagrams for a variety of application functionality designs. Have extensive experience preparing Business / Functional Requirements Documentation (BRD, FRD) / System Requirements Specification Documents (SRDS) / Use Cases, Test Plans, Test Cases, Test Scenarios, Test Data and Test scripts.
• Good understanding of Project Management Methodologies like Agile (SCRUM), RUP, Waterfall and CMM.
• Have extensive experience in Business Modeling, Requirements Gathering, Documentation, Quality Assurance, Testing within full Software Development Life Cycle (SDLC).
• Well - versed in RDBMS - Oracle, Teradata, DB2, SQL, SQL Server, PL/SQL.
• Have strong technical expertise in designing and implementing Data Extraction, Transformation and Loading (ETL) from different data sources into a common analytical data model using Informatica Suite and Business Objects Data Integrator / Data Services and hands on Confidential Data Stage.
• Have strong communication and interpersonal skills.

TECHNICAL SKILLS:

Quality Assurance: HP Quality Center (QC) and QTP 11.0/9.0, Rational Suite 2007/2006 (Rational Quality Manager, Rose, Test Manager, ClearQuest 7.1.2, Manual Tester 7.0.1, Functional Tester 7.0.1), Mercury Test Director

Databases: Oracle 11g/10g/9i/8i/8x/7x, Teradata V2R5, DB2, MS Access 7.0, MS SQL Server 2000/2005

Management Tools: MS Project, Office 2000, MS Visio, Crystal, Rational RequisitePro 7.1.2

ETL / BI Tools: Informatica PowerCenter 8.x/7.x/6.x (Designer, Repository Manager, Workflow Manager and Workflow monitor), Informatica PowerMart 5.x, Business Objects Data Integrator XIR2/ Data Services XIR3, Business Objects Reporting Package XiR2/6.x/5.x (Universe Designer, DeskI, WebI, InfoView, Import Wizard), Ascential DataStage 7.1

Version Control Tools: Share Point, Visual Source Safe (VSS), Spectrum, Confidential Rational Clear Case and PVCS

Operating Systems: Windows Vista/XP/2000/NT, Windows 2000/2003 Server and UNIX

Languages: Pascal, Fortran, C, C++, Java, VB 6.0, VB.NET, UNIX Shell Scripting, HTML, XML, SQL, PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Camp Hill, PA

Sr. Technical Test Analyst

Responsibilities:

• Reviewed Business Requirement documents, Vision documents, Use Cases, Supplemental Specification documents and Technical Specifications.
• Involved in importing the requirements documents in to Req.Pro and tagging the requirements.
• Involved in creating the attribute and Traceability Matrices in Req.Pro across various requirements.
• Involved in planning, coordinating and executing project testing tasks.
• Thoroughly understand the business requirements from JAD sessions and other meetings with Client side BAs and internal Confidential BAs to make sure the test scenarios/test cases, are covering all the requirements.
• Well documented test cases and test scripts corresponding to business rules and other operating conditions.
• Have to work with Source systems like CPR( Corporate Provider Repository), CMR/ECS ( Corporate Member Repository) and ICIS for group information to bring in the required data elements to Capitation databases and test data files and DB2 tables.
• Extensively used Rational Quality Manager to write Test Cases/Scripts and executing them.
• Created child test plans, Test Environments, test schedules and Test Execution Records in RQM.
• Done the data preparation to test the application as per the pre-conditions and validated the post-conditions and record the results of each test case/script.
• Extensively worked on testing DB2 databases for CPR, CMR and ICIS builds using Teradata SQL Assistant and Mainframe Confidential Rational Host-On Demand.
• Created complex SQL queries to validate the source and target data and to check business scenarios are met.
• Written automated test scripts in RQM, to test GUI screens of PGRS system.
• Conducted Unit, Component Integration, Functional System tests.
• Got the hands-on for Regression testing and in writing test scripts using Rational Functional Tester.
• Created/Reported defects from Clear Quest.
• Maintained the business documents and test scenarios/testcases/testscripts/results in company’s collaborative site, the Share Point.
• Have attended the daily SCRUM meetings for test data management, test status and to discuss other testing/data related issues.
• Well-coordinated with other business analysts and developers to nail down some testing issues.

Environment: Confidential Rational Quality Manager 2.0/3.0, Confidential Rational functional Tester 7.0.1, Confidential Rational Requisite Pro 7.1.2, Cleat Quest 7.1.2, Teradata SQL Assistant, Confidential Rational Host-On Demand, DB2, Oracle 11g, Teradata, FTP/SFTP, Java, XML, Confidential Mainframe, Share Point, MS Office.

Confidential, Harrisburg, PA

Sr. Quality Assurance Analyst

Responsibilities:

• Reviewed Business Requirement documents and Technical Specifications.
• Involved in planning, coordinating and executing project testing tasks.
• Documented test cases corresponding to business rules and other operating conditions.
• Manual Scripting is done for the test cases on the UCMS application and execution in Manual Tester.
• Wrote test cases and test scripts for Functionality testing.
• Worked on Automation of UCMS application using QTP.
• Used Object repository for handling the creating objects as and when required.
• Implemented code for handling different kinds of claim applications (complete/Incomplete applications) which cannot be handled by recording the scripts.
• Generated smaller scripts which help in reusing the scripts as needed.
• Used data pool for feeding the data to the scripts.
• Did the data preparation to test the application as per the pre-conditions and validated the post-conditions and record the results of each test.
• Generated code which can handle the testing at different ENVs and Validated the data.
• Closely worked with developers to nail down the technical problems, discussed issues concerned.
• Performed Regression Test manually for various Web Application jobs.
• Worked on Clear Quest by logging defects.
• Unit testing the measures and formulas in the universe and comparing with values of legacy reports.
• Listing all Characteristic in the excel spreadsheet and compare with legacy reporting characteristics.
• Ran Batch Process and Job schedulers in the back-end for applications to create tasks for the end users to work on the applications.
• Extensively worked on testing of backend objects like BPELs, MDBs, which calls various Web Services, individually through Jmeter scripts and sending SOAP Requests.
• Thoroughly tested the Workflow Tasks created by BPELs and MDBs.
• Also tested External Interfaces with which UCMS talks outside resources in the name of Inbound and Outbound testing.
• Check the System Logs for issue detection and work with Development team to make the issue fix in minimum time.
• Checking the user authorization for the corporate documents and did Accessibly Test to check the Roles and Permissions of various hierarchical management.
• Validated the test data by writing SQL Queries to complete the reconciliation and for accuracy.
• Did the data mining in the legacy data to apply that for testing the front end applications and did the data preparation as required.
• Conducted Unit, Component Integration, Regression, System and UAT Tests.
• Maintained defects in Clear Quest and participated in defect review meetings, Status meetings and GO/NO-GO meetings.
• Maintained test logs, test suites and reports.

Environment: HP QTP 11.0, Rational Suite 2007 (Test Manager, Requisite Pro, Clear Quest, Clear Case, Manual Tester & RFT), MQ Series, Java, HTML, XML, SOAP, Oracle 10g, DB2, Windows XP, WinSCP, MS-Office, Ascential DataStage, SQL Developer, WPS, WAS.

Confidential, Brentwood, TN

Senior Data Warehouse Developer & Tester

Responsibilities:

• Contributed in Requirements Analysis, Design, Implementation, Testing of Ecommerce and Data Warehouse.
• Involved in planning for End to End Testing of Sales Cycle, Master Cycle, Returns Cycle and Inventory Cycles for Ecommerce and Data Warehouse
• Prepared Test Cases and test scripts for Functionality testing of various Ecommerce Cycles in HP Quality Center.
• Extensive Unit, Regression, Pilot and Integration test of End to End Cycles and various ETL jobs using HP QC.
• Maintained defects in QC and participated in defect review meetings, Status meetings and AGILE (SCRUM) meetings.
• Performed end to end test manually . Performed Regression Test manually.
• Closely worked with External Systems and External Interfaces to prepare and finalize the Test Data.
• Closely worked with developers of External Systems and External Interfaces to nail down the Technical problems, discussed issues concerned.
• Involved in coding different types of dataflows like normal and R/3 to bring data from SAPERP tables, and ETL jobs for various requirements using tool Data Integrator (DI) Designer XIR2/ Data Services XIR3
• Converted many PL/SQL jobs into ETL and thus reduce the job running time in production, make it more readable/understandable way
• Extensively worked migrating, Test and Deploy of the ETL job from XiR2 to upgraded version XiR3
• Contributed in Requirements Analysis for various Reports and Design the Business Objects Universes
• Performed Extensive Unit Testing of BusinessObjects Reports for Data Accuracy.
• Performed Extensive pre UAT Testing of BusinessObjects Reports.
• Contributed in developing and generating complex, Adhoc, Flash Sales Reports, Business views, List of values.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks

Environment: HP Quality Center 9.0, Business Objects Data Integrator XI R2/ Data Services XIR3, Business Objects Enterprise XiR2 for Reporting, Oracle 10g, Toad, Tidal Scheduler, PL/SQL, SQL *PLUS 10.2, Spectrum, Putty, Windows NT, Linux.

Confidential, Waukesha, WI

Associate Systems Engineer

Responsibilities:

• Contributed to Requirements Analysis and Design
• Created Informatica Mappings with different transformations including Source Analyzer, Lookup, Filter, Expression, Aggregator, Stored Procedure, Lookup Transformations and more
• Involved in Code Review, Unit, Integration and Regression Testing of mappings and Workflows
• Developed test cases/scripts using Test Director.
• Prepared Test Data and helped external systems to prepare test XMLs.
• Executed Test scripts and done the defects Management in Mercury Test Director.
• Month end reconciliation of Order and Sales data from DWH to Sales compensation application.
• Worked on data sources such as Oracle and Teradata
• Involved in debugging of Mapping and other components like unix scripts.
• Fine tuned Transformations and mappings for better performance
• Job scheduling and monitoring in Redwood Cronacle
• Worked on different Clarify Cases and phase wise Change Requests (CR)
• Responsible for documentation in preparing SRDS, ETL specs, Installation guide, scheduling scripts as per GEHC standard guidelines

Environment: Informatica Power Center 7.1/6.2, Oracle 9i, Teradata 5.0, Mercury Test Director, Redwood Cronacle 5.6, PL/SQL Developer, Queryman, Windows NT, Solaris.

Confidential, Waukesha, WI

Associate Systems Engineer

Responsibilities:

• Involved in Requirement analysis and Design
• Implemented Star Schema modeling
• Analyze raw data and development of Informatica Mappings to load data into the Data Warehouse
• Created Mapping variables to perform the incremental loading of data.
• Testing and debugging of all relevant programs includes Mappings, workflows and reports
• Applied Change Data Capture (CDC) logic to mappings to get the current data
• Reconciliation of data after each phase development and testing
• Defect logging using Mercury Test Director.
• Scheduling of Informatica sessions for automation of loads in Cronacle
• Performance tuning of mappings and sessions
• Resolving issues in production as raised by users
• Responsible for documentation as per GEHC standard guidelines

Environment: Informatica Power Center 6.2, Teradata 5.0, Oracle 9i, Mercury Test Director, PL/SQL Developer, Cognos 6.0, Redwood Cronacle 4, Windows NT, Solaris

Confidential

Data Warehouse Developer

Responsibilities:

• Creating Mappings using Designer, Creating and running sessions using Server Manager for Order Management module
• Involved in loading data from various sources like MS Access, MS Excel, DB2 into Oracle stage
• Responsible for running monthly jobs for data warehouse by executing the mappings with the server manager.
• Enhancements in existing mappings.
• Involved in Code Review, Unit and Integration Testing of mappings and Workflows.
• Worked on Change controls (CC) and System Problem requests (SPR) in the phase-1 Data Warehouse.
• Involved in writing and executing various test scripts using Mercury Test Director.
• Responsible for maintaining Mappings design documents, Installation Guide and Test Cases.
• Developed list reports, cross-tab reports using Cognos Impromptu.
• Testing of the mappings in the development server
• Responsible for monthly audit checks

Environment: Informatica PowerMart 5.1, Mercury Test Director, Oracle8i, MS Access, MS Excel, DB2, Cognos 6, Windows NT, Solaris

Confidential

Data Warehouse Developer

Responsibilities:

• Creating Mappings using Designer, Creating and running sessions using Server Manager for PPC module
• Involved in loading data from various sources like MS Access, Flatfiles, Oracle, MS Excel into Oracle stage and then to Oracle Corporate Data Warehouse
• Responsible for running monthly jobs for data warehouse by scheduling the mappings with the server manager.
• Enhancements in existing mappings.
• Involved in Code Review, Unit and System Integration Testing of mappings and Workflows.
• Involved in writing and executing various test scripts using Mercury Test Director.
• Responsible for maintaining and writing ETL design specifications, Installation Guide and Test Cases.
• Testing of the mappings in the development server
• Developed reports using Business Objects.
• Responsible for monthly audit checks

Environment: Informatica PowerMart 5.1, Mercury Test Director, Business Objects 5, Oracle 8, SQL Plus, PL/SQL Developer, Developer 200, Unix, Windows 2000