We provide IT Staff Augmentation Services!

Sr. Technical Test Analyst Resume

Camp Hill, PA

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

Hire Now