QA Lead, Resume Profile, USA

Reference Id: 76991     Posted on Wednesday 26th August 2015      QA Analyst



Please note that this is a not a Job Board - We are an I.T Staffing Company and we provide candidates on a Contract and Full-time basis. If you need I.T.Professionals to fill a Contract or a Full-time Position, please call (800) 693-8939

QA Lead, Resume Profile, USA
Functional / Technical roles
  • Business Analyst, Data Analyst, Systems Analyst, QA Analyst
  QA Software
  • Mercury QTP, Mercury Quality Center (QC), Application Life Cycle Management (ALM), Test Director, Rational ClearQuest
Project Management Software
  • MS Project
  Databases
  • MS Access, Oracle, DB2 and Facets.
  Operating Systems
  • Windows NT / 2000 / XP / UNIX
  Project Tools: MS Project, Word, Excel, PowerPoint, Visio, Clarity.   REPORTING TOOLS SQL Server 2000, MS Access   web development Microsoft FrontPage, ASP, HTML   Programming   C++,  VBA, Visual Basic 6.0, SQL+, UNIX   Data Base skills SQL Server 2000, MS Access, Sabre, ORACLE, Lotus Notes       Summary
  • More than 8 years of progressively increasing responsibilities in the healthcare and financial industries with successes in:
  • Deploying enterprise solutions
  • Full Life Cycle system delivery implementations.
  • Worked with all stages of testing namely, Integration Testing and System Testing using automated test tools and User Acceptance Testing using manual tests.
  • Medical Claims experience in Process Documentation, Analysis and Implementation in 835/837/834/270/271/276/277/997(X12 Standards) processes of Medical Claims Industry from the Provider/Payer side, analysis & compliance experience from, payers, providers and exchanges perspective, with primary focus on Coordination of benefits
  • Worked on healthcare standards such as HIPAA 4010, 5010, ICD-9.
  • Complete Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis, Design, Development and Testing.
  • Hands on experience in testing tools like Quality Center, QTP and Application Life Cycle Management.
  • Experience in implementing the Rational Unified Process (RUP) in all four phases of a project: Inception, Elaboration, Construction and Transition.
  • Identify gaps, which require operational change in order to optimize system solutions by GAP analysis.
  • Acted as liaison between management and development team for requirements and Software Quality Assurance (SQA).
  • Strong expertise in using ETL tool Informatica with a solid work experience in Oracle PL/SQL, and all phases of SDLC.
  • Experienced ETL Analyst with skills of data analysis, profiling, design, optimization, and implementation of ETL process using Informatica Power Center.
  • Managed and worked with team for ETL efforts and implementation.
  • Preparing User Requirement Specifications (URS).
  • Proficient in manual and automated testing of Web based and Client Server applications.
  • Requirement Analysis and preparing Use Cases.
  • Identifying and documenting critical requirements through analysis of the department’s workflow and information flow.
  • Experience with co-ordination with off-shore QA team and overseeing all deployment and migration efforts.
  Quality Analyst
  • Documentation –Create Test plans, Test Suites and Test Cases.
  • Test – Conduct thorough unit and integration testing of all utilities.
  • Automated Test scenarios for GUI, Functionality, Regression testing, Ad-hoc testing.
  • Requirement Analysis and preparing Use Cases
  • Manual and automated testing of Web based and Client Server applications
  • End-to-End User Acceptance Testing (UAT).
  • Systems Development Life Cycle (SDLC)
      Technical Instructor
  • Training – Develop and deliver courses on system and business processes and procedures.
  • Support – Work with end-users to increase proficiency, guiding them in the use of software and change management techniques.
  Professional Experience                                                                                                                                                                                               Confidential Sr. QA Lead     Confidential is one of the largest professional service firms in the world and one of the Confidential” accounting firms. Confidential is a global organization of member firms in more than 140 countries. The project EY delivers. It provides the auditing tools for millions of people all around the world.   Responsibilities:
  • Leading the off shore and on shore QA team and guiding them in creating test scenarios, understanding the flow of the functionality, validating the test cases.
  • Assigning the task to off shore teams and attending the daily task status meeting.
  • Attending the daily sync meetings with Vendors of the application.
  • Providing the daily status to the Test Manager and maintaining the test results, Regression status , permutations for the testing strategy in share point.
  • Attending stand up meetings to provide the QA update to the team every day.
  • Working hand to hand with Product Manager by discussing the issues found in QA and prioritizing them.
  • Daily interaction with the development teams.
  • Attending defect review meetings with Product Manager and Development Teams.
  • Executing the Smoke Test for every build/sprint.
  • Attending meetings with BA to review the requirements and mentoring off shore and on shore QA teams.
  • Validating the functionality in the production deployments in different data centers.
  • Providing the QA sign off for CAB with test results and open defects.
  • Providing Test plan for the projects based on the scope list and requirements.
  • Ability to maintain more than 1 projects at a time.
  • Review the defects found in system testing, regression testing and prioritizing them.
  • Validating the defects found in testing.
  • Managing the QA results in shared locations and updating them day to day for ease of accessing to the team members.
  Technologies: EY Defect Tracking tool, Microsoft word 2007/2010, Microsoft Excel 2007, .NET, Share Point (TFS), Quality Center, Application Life Cycle management (ALM).   Confidential Test Coordinator                                                                                                                                                          Confidential is one of the leading Health Insurance providers in United States. It serves insurance to large group of people and at the same time provides to large companies.  The Project GMR is a Web portal build for the corporate user and their family members. It has got various modules like, Personal health record, Claims, Incentives, Online Health care etc. Responsibilities:
  • Developed Master Test Plan, Test Strategy, Work Flow, Test Requirements, Test Cases and detailed Test Conditions in Quality Center.
  • Managed Defect Triage daily defect review meeting with the Business Users and developers.
  • Attended QA Hand-Off meetings, actively participated with BA’s, Dev’s, QA’s explaining the written scenarios or test scripts.
  • Managed OnSite and Off-Shore Testing teams for developing and executing Test Cases and Test Scripts.
  • Managed all testing activities for Functional, User Interface, End-to-End, Multi Browser, Application, System, Integration, Regression, UAT and Migration Testing.
  • Actively involved in ETL testing of External files and Paper HA.
  • Trained Jr. Testers for writing detailed test cases and executed test cases in Mercury Quality Center.
  • Used HP Quality Center to track, report and resolve System Defects.
  • Participated in defect reviews with the developers, managers and business people and presented the Defect reports in the defect review Meetings.
  • Participated in Production rollouts and provided end-to-end support and post-implementation support to the customer community resolving production related issues.
  • Data validation and Database integrity testing done by executing SQL, PL/SQL statements.
  • Extensively worked on Reports which includes Patient Personal Health Record Reports, Claims Reports, Finance Reports, Member Reports and etc.
  • Prepared Test Cases based on business requirements and business rules for HIPPA EDI Transaction 834, 276/277, 270/271, 837/835.
  • Tested all HIPAA transactions for multi version support (4010 and 5010) and validating the database to file elements.
  • Analyzed HIPAA 4010 and 5010 standards for 837P EDI X12 transactions, related to providers, payers, subscribers and other related entities.
  • Utilized the 837 claim format for claim configuration. Followed HIPAA guidelines.
  • Configuration and evaluating the impact of proposed changes in rules and regulations.
  • Set claim processing data for different Facets Module.
  • Performed Positive and Negative Testing Manually
  • Process Medicaid Claims on FACETS 4.6 system
  • Involved in Claims processing – efficient management of claims processing for various types of claims like Professional, Dental, Pharmacy and Institutional.
  • Extensively used SQL queries commands for data verification and backend testing using Toad.
  • Validated different EDI formats and transactions under HIPPA 4100/5100 compliance
  • Developed Traceability matrix from Business and System Requirements documents.
  • Tested different modules like PI, EF, HA, SSO, LA/SA, Incentives, PHR Forms, Trackers, Delegations.
Technologies: HP Quality Center, Java, TOAD, XML, UNIX, HTML, Oracle, PL/SQL, Windows XP , Test Director.   Confidential Sr. QA Lead                                                                                                                                                                       Confidential Care has developed application to keep track of the active and inactive members using Social Security Number as a Unique ID. This application helps CCN to adjudicate the filed claims, avoid resubmission of the claims and identify false claims for the CCN participating members and non-members. CCN’s centralized database residing on a system controlled all the inbound and outbound data. The financial aspects were taken care by the financial accounts payable and accounts receivable modules.  All components extensively used sub files, data area, and SQL. The backend was DB2/400 database. Responsibilities:
  • Determined user requirements and goals by conducting meetings with client
  • Drafted test strategies, test cases and test plan based on functional specifications
  • Developed test cases for manual testing
  • Establish test data for testing the application
  • Worked on EDI and HL7 interface testing project involving HIPAA 4010/5010 Claims transactions set.
  • Wrote and verified stored procedures using PL/SQL to improve efficiency of the FACETS system.
  • Complete weekly UAT test plans for new implementations and updates configured on FACETS system.
  • Tested user interface and navigation controls of the application using QTP.
  • Experiences working in ANSI x12 837-835 EDI Transaction.
  • Validate the date from EDI transaction.
  • Tested the HIPPA EDI 834, 270/271, 276/277, 837/835 transactions according to test scenarios and verify the data on different modules.
  • Authored test case scenarios in Excel spread sheet and export them into Mercury Quality Center.
  • Designed, scheduled and executed test plans within the predefined timeframe
  • Manual Testing for checking the flow of the application functionality
  • Conduct the testing (system and regression) of all applications to ensure application integrity both AS/400 based systems and web-based applications. Entails: Managing/executing the testing effort, logging detailed accounts of errors/defects in the systems, and coordinating with the Application Development and Operations teams to diagnose and troubleshoot any errors/defects.
  • Functional Specification Document
  • Performed Test Execution & wrote & Executed Test Scenarios/Test Scripts.
  • Writing PL/SQL Procedures & Batch Processes
  • ETL functions in PL/SQL using stored procedures, packages for aggregation and summations.
  • Writing Test Plans/Test Scenarios/Test Cases/Test Matrix
  • Defect tracking using Quality Center (QC).
  • Executing System Test, Regression Test, User Acceptance Testing (UAT)
  • Validated Historical Data Load /Data Retention validation, ETL load dependencies – test defined load dependencies between jobs. Load Strategy, Naming convention and Audit columns in the history tables.
  • Ensured Informatica ETL extraction jobs include data quality metrics such as counts of rows extracted, sum of any numeric fields, and count of rejected records.
  • Validated the data from the source through the ETL process and into the target warehouse. This approach will validate the data at each transformation: first the source to Stage 1 schema, then the History tables, then the ODS staging tables, then the loading tables, then the ODS tables, and finally the destination tables in Synapse Data warehouse.
  • Validated Errors and Recovery scenarios including, duplicate record handling, Error Warning Messages., default values substitution. (e.g. Substituting NULL if a certain field does not contain a value), data reprocessing, Validating correct processing of ETL generated field like the surrogate keys ,load exception tables verification (Audit Log tracking), validating  Negative Scenarios for exceptions and verify that the exceptions procedures are implemented.
  • Used Test Director for setting up and maintaining projects on Test Director. Execute test cases using WinRunner scripts through Test Director
  • Performed manual back-end testing using SQL Plus to connect to an Oracle 9i database on a UNIX server.
  • Generated of all reports for the test cases through Test Director’s document generator. Assign and track all defects of test cases through Test Director. Analyze, track, and report test results
  • Developed design specification writing Test Reports & documenting test results.
  • Oracle forms, Oracle database (Release name: Claims Validation Process)
Technologies: PL/SQL, Windows 2003 Server, WinRunner, Test Director, Quality Center.     Confidential Test Lead                                                                                                                                                                            The California Public Employees Retirement System (CalPERS) provides pension fund, healthcare and other retirement services for California public employees. CalPERS Corporate Database Application (CDB or COMET) is a 3-tier client-server based online and batch application that provides system functionality and supports business rules for maintaining Employer, Participant, Health, and T-Log information. CDB produces as well as processes data transaction files that are transferred between the HP/Unix Server based CDB application and mainframe legacy applications. CDB also supports data Backbridge and Refresh processes that transfer information between CDB and several legacy mainframe databases. Responsibilities:
  • Analyzing the system specifications, business requirements, worked closely with the business user to gather requirements for new development.
  • Testing the load on the Server for usability of the ETL Tool
  • Tested the validity of the data cleaning done by the ETL by writing SQL and PL/SQL Scripts, also creation of temp tables/ drop table's views etc.
  • Involved in walk through and meetings with manager to review the project specifications and to understand and analyze the Business, functional and technical specifications
  • Wrote Test Plans, numerous Test Cases and Test Scripts for the application.
  • Best practices, Standards, Compliances, methodical and structured approaches in designing ETL solutions using Informatica
  • Inserted Requirements in Quality Center, Mapped Requirements with Test Cases.
  • Designed the test sequence to be performed.
  • Performed Functional, Regression, Integration and User Acceptance Testing for the various applications.
  • Participated in the creation of Data tables for Automation testing.
  • Developed and executed various Manual Testing Scenarios and neatly documented the process to perform Functional Testing.
  • Wrote Automated Test scripts using QTP.
  • Worked closely with QA and Developers to clarify/understand functionality, resolve issues
  • Attended weekly meetings with team leaders, managers and developers to discuss the issues found during the creation of the test case/scripts.
  • Wrote SQL queries to validate data in the database.
  • Prepared testing documents to communicate about the status and progress of the testing efforts with the management team members.
  • Developed test plans, automation of new feature test suites, across the product line and multiple operating systems
  • Identified and defined scope for Integration and System Testing
  • Interviewed Business Area Experts, asking detailed questions and carefully recording the requirements in a format that could be reviewed and understood by both business people and technical people.
  • Formed a bridge between the Project Manager and different teams with effective presentations.
  • Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams / State Chart Diagrams and Robustness Diagrams using Rational Rose according to RUP methodology, thus defining the Data Process Models.
  • Created Traceability Matrices to validate requirements against client statement of work commitments.
  • Providing training to the team on defect tracking management and walkthrough the application.
  • Written requirements following SDLC methodology, converted them to User Stories in order to follow agile development.
  • Checked the data flow through the front end to backend and used SQL queries to extract the data from the database.
  • Prioritized, evaluated, monitored defects and Analyzed Defect History.
Technologies: Windows XP, QTP, HP Quality Centre, Rational ClearQuest, Rational RequisitePro, IIS, MS Office, UNIX, Rational Rose, Perl, SQL Server 2005, Oracle, FTP   Confidential Test Lead                                                                                                                                                                           Jan 06 - Aug 07 The Reporting & Analytics Foundation (RAF) project objectives for Phase 2 were to Decommission CORAL Data warehouse processes, interfaces, software tools and infrastructure environment, deliver Synapse warehouse interfaces, reporting and analytics tools equivalent to the existing CORALDW capabilities, extend Synapse warehouse data services to include financial and positional data currently stored in the CORALDW, delivery of base deal information and valuation Results from the following source systems into Synapse data warehouse (V9, Spreadsheets, eMartketplace – (Trading Limit) and NUCLEUS) and to decommission Hyperion reporting and replace it functions  with Spot Fire that will enable multidimensional reporting across information subject area. Responsibilities:
  • Responsible for the core activities of the test effort which includes identifying and defining the required tests, monitoring detailed testing progress and results in each test cycle, evaluating the overall quality experienced as a result of testing activities. And identifying the appropriate techniques, tools and guidelines to implement the required tests
  • Identified and established the testing environment (Physical and logical environments, test data, test tools) that needs to be in place.
  • Performed System Integration Testing (SIT), User Acceptance Testing, (UAT), Integration Testing, End to End Testing, Co-existence Testing and Performance Testing
  • Identified and deployed process improvements and standards for key practices in requirements management, metrics management, and testing and release management.
  • Translate the test strategy into a plan with concrete activities from "why and what" to "who, how, where and when"
  • Ensure that the team follows the testing standards, guidelines, and testing methodology as specified in the testing approach.
  • Maintained the test logs, test reports, test issues, defect tracking using Quality Center.
  • Created test cases to validate advanced business computational logic focused around prompt forward trade (i.e. P&L impact), for trades booked in ENDUR V9.This includes impact from Conversion from SYBASE (ENDUR 5.3) to ORACLE(ENDUR 9)
  • Tested Delivery of Deal Reference data and Pricing data (Natural gas and power) from Nucleus
  • Validated the one Time Historical Data Migration: Validate end-to-end business process flow from source system ->Synapse data warehouse -> downstream system/ reporting interfaces. Deal Entry in Trading Manager, Deal Validation and Confirmation testing.
  • Business transformation logic verification and validation. Tested to ensure that data is transformed correctly based on business rules defined in the Paper Mapping.
  • Validating data types, column/field length are as specified in the Paper Mapping and match the data model.
  • Creating and executing SQL queries on an ORACLE database to validate and test data using TOAD/RAPID SQL.
  • Created functional and Integration test cases for spotfire Information views: Results fields in Spot fire information views.
  • Validated Historical Data Load /Data Retention validation, ETL load dependencies – test defined load dependencies between jobs. Load Strategy, Naming convention and Audit columns in the history tables.
  • Ensured Informatica ETL extraction jobs include data quality metrics such as counts of rows extracted, sum of any numeric fields, and count of rejected records.
  • Validated the data from the source through the ETL process and into the target warehouse.
  • Validated Errors and Recovery scenarios including, duplicate record handling, Error Warning Messages, validating  Negative Scenarios for exceptions and verify that the exceptions procedures are implemented.
  Technologies : MS Windows, MS Visio, MS Project, MS Office (PowerPoint, MS Word, MS EXCEL), Web 2.0, SQL Server, SDLC, Rational ClearQuest, Rational Requisite Pro, Quality Center, Agile methodology   Confidential Test Analyst                                                                                                                                                                                  Worked as a Test Analyst at Keystone Mercy Health Plan (KMHP) on several different projects; KMHP was working with EDS for the State of Florida (AHCA) and Commonwealth of Kentucky besides several other state agencies. Involved in The project objective for NaviMedix a web based project involving integration of Different customers at different location I was Involved in  Mapping each and every provider to one or more business entities for NaviMedix so that NaviMedix could implement the online Provider Portal for KMHP at the various provider sites that work with KMHP. Responsibilities:
  • Created documents that incorporated both the technical and functional details.
  • Involved in creating documents and diagrams for Membership Enrollment according to the HIPAA 834 Compliance Standards for Membership Enrollment.
  • Created Test Documentation and Test Plans
  • Use Test Director to create to create Test Plan, Test cases and test scripts as well as steps for manual and automated implementation of test cases in Test Director
  • Documented requirements using Use Case (UC) analysis for the development team. Also, stored the documentation in a common SharePoint Repository for version control.
  • Developed and maintained complex SQL queries for MS SQL Server and MS Visual SourceSafe for extensive back end testing purposes
  • Documented requirements using Use Case (UC) analysis and User Experience (UX) GUI design.
  • Web testing utilizing HP QuickTest Professional (QTP), Client/Server application manual testing utilizing Windows XP, Oracle 9i, TOAD, and SQL Server. ClearQuest for defect tracking and test cases repository and maintaining RUP documentation.
  • Defined standards, approaches / processes including the naming conventions, coding patterns for team members followed by deployment policies and disciplines.
  • Translated business/data requirements into data integration detailed designs and technical specifications needed by the ETL developers.
  • Established ETL strategy, process, methods to complete overall project with the client standards.
  • Code walkthrough, map reviews, ETL tuning and suggestions for process improvements.
  • Monitoring the performance of the system on a day-to-day basis
  • Created Test Scripts in Win Runner. Performed GUI testing using Win Runner
  • Regression testing on weekly builds. Performed weakly Walkthroughs and Inspection meetings
  • Performed Black Box Testing. Performed Positive and Negative testing for the system.
  • Conducted Back End Testing to test the connection between Store’s system and the database in order to verify data integrity
  • Performed Functional and Regression testing using Win Runner
  • Monitor and analyzed activity report. Created reports for Server monitoring and Transaction time
  • Bug reporting using Test Director
  • Documented requirements using Use Case (UC) analysis, and created As-Is and To-Be process flows to conduct gap analysis to improve efficiency.
  • Involved in updating and/or reworking previous documentation on their Membership Enrollment System for Florida to get them in sync and up to date with their current new system in place.
  • Unit Tests, bug fixings and fine tuning of ETL processes were handled in doing the build.
  • Wrote PL/SQL packages, Stored Procedures to invoke several ETL functionalities for aggregation, summation and other complex calculations.
  • Involved in bi-weekly workgroup sessions to complete various sections in the functional specification document like Business Rules Definitions, Processing Rules, Pre-Edit Errors, etc. and weekly status meetings for updates.
  • Involved in manually testing the application from the backend to carry out data validation.
  • Used requirement elicitation techniques such as JAD Sessions and Document Analysis to gather information regarding the application from the KMHP SME and EDS along with the State of Florida people.
  • Maintained open and clear communication with the team on change requests.
  • Co-authored and reviewed Operational Guidance Documents along with Design Documents and Deployment Plan Documents.
  • Created UI Documents as supporting documents for the Business Requirements Documents.
Technologies: WinRunner, LoadRunner,QTP, Test Director, Clear Quest Windows NT, Oracle, IIS, UNIX, HTML                 

Search Resumes

Looking for I.T Professionals on a Contract basis?