Qa Analyst Resume
Irving, TX
SUMMARY:
- 12+ Years of experience in Quality Assurance as Manual Testing, Functional Tester, Mobile Testing.
- Quality Assurance (QA) Experience in Web based, Client/Server and Data warehousing applications For Healthcare, Insurance and Media and Entertainment domains.
- Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
- Experienced in scheduling, resource management, risk management, work allocation to the team, estimations of testing and tracking status.
- Involved peer reviews, group reviews and acted as a moderator for inspections.
- Conducted Health Audits related to the process and SME Product reviews related to testing.
- Present RAG Report with metrics to customer/higher management.
- Participating in risk assessment and risk mitigation activities with the core team
- Well - versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
- Verifying and Validating Application Software and Documentation based on standards for Software development and effective QA implementation in all phases of Software Development Life Cycle (SDLC).
- Experienced in working with different types of SDLC processes like Agile, Iterative, V-Model and Waterfall.
- Professional experience in Integration, Functional, Database, Regression, System Testing, Load Testing, UAT Testing, Black Box, Automation testing, Interoperability Testing, and GUI testing
- Expert in Quality Center (QC 9.5 & ALM 11,12) with 7 years of User/Admin (Creating Projects, Adding/Deleting Users, provide access to Users, Assist users in HP ALM installation) experience of Test and Defect Management. Trained QC to the new hires.
- Good experience on SOAP UI tool
- Extension experience in iOS Testing, Mobile testing
- Attend Defect triage call to get the ETA’s for the defects, prepare the SLA’s for the defects and have an agreement with Dev team, Business and Management
- Involve mitigation plan if there are any risks after discussion with related parties.
- Worked as a Data Quality Analyst during integration of Confidential /Medco for many clients including Anthem, UPMC, and Emblem Health.
- Experience in Medco/ Confidential Integration and worked in many applications which involved data conversion testing. I have tested in Data History load testing.
- Experienced in working closely with Business Stakeholders including clients (Anthem, UPMC, and Emblem Health), Technical Leads to understand client data to develop Test Plan, Test Cases.
- Worked on creation of test schedule/test execution plan to ensure data quality tasks are completed as per timeframe in release
- Managed and followed logic given in Data Dictionary for project. Created/Maintained data quality documents such as checklist, templates, and guidelines
- Participated in cross-functional testing and helped in other teams for data creation for their testing.
- Experienced in testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, and generated reports.
- Extensive Knowledge in Health Insurance and Pharmacy Benefit Manager (PBM) Claims Processing Systems.
- Proficient in analyzing and translating business requirements to technical requirements and architecture
- Understanding of PBM regulations and related CMS guidance, responsible for proactive review of all CMS regulation and guidance
- Provided assessment of requirements when CMS revises guidelines and implements quality and compliance monitoring changes to ensure compliance to new guidelines.
- Executed and track quality and compliance review projects, develops quality review procedures, perform tests and document test results, prepare Test closure report for each release.
- Interfaced with internal operational areas and with external customers to improve the quality of customers' implementation of the PBM program, areas include Part D Benefit Setup, Part D Pharmacy Network Setup, CMS Plan Finder Submissions, Member Part D Explanation of Benefit Statements, CMS Reporting, Prescription Drug Event Reporting, Part D Policy and Procedures, and other PBM services provided by Confidential
- Participated in evaluations and audits of PBM services provided by Confidential and implements corrective action plans in response to negative findings
- Proficient in use of and manipulation of data extracts and reporting techniques.
- Extensive experience in BDD using Cucumber and Gherkin.
- Solid back end testing experience by writing and executing SQL Queries.
- Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
- Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
- Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) with Hadoop
- Experience in testing OBIEE( Oracle Business Intelligence Enterprise Edition) Reports.
- Solid experience in the Agile Methodology.
- Prepared various Testing project related documents and Reports like Status reports, Time Sheets, Defect reports and Requirement Traceability Matrix.
- Experience in generating metrics for the team using Rational Portfolio Manager.
- Interacting with Integration, Migration, Development and Business teams for discussing process improvements and dependencies.
- Have excellent project management skills, including developing project plans, testing effort estimates, and creating deliverables schedule
- Certified Lean Six Sigma from IBM Learning academy
- Experienced in the creation of User Manual documents.
- Comprehensive understanding of client’s needs for the proper management and delivery of projects.
- Flexible to learn advancements in the IT Industry and deliver good results.
- Flourish in both independent and collaborative work environments with quick learning abilities and good communication skills.
- Team player with excellent design skills, and problem solving abilities.
TECHNICAL SKILLS:
Test Management Tools: HP QC (Quality Center), HP ALM (Application Lifecycle Management) and IBM Rational Clear Quest 7.0, JIRA, GITLAB
Operating Systems: OS /390 MVS and Windows
Data warehouse Tools: Informatica, OBIEECI and Scheduler Tools: CA-7, CA-11
Databases: Oracle, SQL Server, VSAM, DB2, Teradata, MS Access, DB VisualizerLanguages: VB, Java, COBOL, JCL, HTML, PL/SQL, Java Script, Hadoop
Automation Tools: SOAP UI, Selenium, Fiddler
Mainframe Tools: File-Aid, Rumba, Personal Communicator
Management Tool: Rational Portfolio Manager
PROFESSIONAL EXPERIENCE:
Confidential, Irving, TX
QA Analyst
Responsibilities:
- Analyzed the Project plan and prepare the schedule for the Testing based on the availability of resources and scope testing scope, strategy and test requirements.
- Involved in System Testing, Integration testing, Interoperability Testing, Database Testing, Regression testing
- Involved in Mobile testing and IoT Testing
- Participated in API testing using SOAP UI
- Involve Test bench testing and vehicle testing
- Reviewing existing manual test cases and identifying the scenarios for automation
- Prepare dependencies based on the discussions with Integration, Migration, Development and Business.
- Raise risks on time if there are any deviations from the plan and prepare for mitigation plan.
- Follow up with BA’s and business to review and provide the approvals on Test Strategy, Test plan and scenarios and Test cases.
- Identify the risks, issues, dependencies and discuss with related to the counter parties and Management to resolve those ASAP for testing to go smoothly.
- Attend daily status and weekly status calls and update status to the Project Management and Client
- Upload requirements and Test cases in ALM, map the requirements to the Test cases as part of requirement traceability Matrix.
- Pull the reports from ALM and JIRA analyze the defect age and defect trends.
- Follow up with Development to fix the defects based on SLA’s provided.
- Discuss with Business Analyst for the defects if there are any clarifications required from Business Analysts.
- Coordinate with Integration, Migration, Development and Business, Environmental team and release Management to resolve the issues and deliver quality product on time.
- Prepare Integration scenarios and share to testing team to develop test cases after discussing with Integration and other Integration parties
Confidential, Hoboken, NJ
QA Analyst
Responsibilities:
- Involved in API testing using SOAP UI
- Reviewing existing manual test cases and identifying the scenarios for automation
- Prepare dependencies based on the discussions with Integration, Migration, Development and Business.
- Raise risks on time if there are any deviations from the plan and prepare for mitigation plan.
- Follow up with BA’s and business to review and provide the approvals on Test Strategy, Test plan and scenarios and Test cases.
- Identify the risks, issues, dependencies and discuss with related to the counter parties and Management to resolve those ASAP for testing to go smoothly.
- Attend daily status and weekly status calls and update status to the Project Management and Client
- Publish daily status reports with number of test cases, passed test cases, failed test cases, Blocked test cases, NA test cases and No run test cases along with percentage with RAG status
- Upload requirements and Test cases in ALM, map the requirements to the Test cases as part of requirement traceability Matrix.
- Verify the requirements in JIRA and assign test cases to the team based on the release.
- Pull the reports from ALM and JIRA analyze the defect age and defect trends.
- Follow up with Development to fix the defects based on SLA’s provided.
- Discuss with Business Analyst for the defects if there are any clarifications required from Business Analysts.
- Coordinate with Integration, Migration, Development and Business, Environmental team and release Management to resolve the issues and deliver quality product on time.
- Discuss with Integration lead to understand the interfaces and dependencies on other systems and follow up with dependent system counter parties for the availability of system and prepare Integration plan along with them.
- Prepare Integration scenarios and share to testing team to develop test cases after discussing with Integration and other Integration parties
- Prepare migration test plan and involve ETL Informatica mappings and other ETL Processes (Data Warehouse Testing) with Hadoop
- Prepare test plan for the OBIEE report test plan and involve functional testing of OBIEE reports.
- Conducted Defect Triage Meetings with the required parties after defect analysis to prioritize defect resolutions
- Defined and prepared of Test Data
- Analyze orphan analysis for each MDRM wherever break incurred between production and UAT comparison for each schedule under regulatory report
- Involved in querying using SQL and updating records and validate database records as expected.
- Create Test closure report once testing completed for each report and send to Client Test director for approval
- Daily meeting with offshore test manager for handover and take over activities.
Confidential, Franklin Lakes NJ
QA Analyst
Roles and Responsibilities:
- Attended Joint Applications Requirements Capturing (JAR) and Joint Applications Development (JAD) sessions. Provided input from QA perspective and part of Quality requirements.
- Worked as a Data Quality Analyst during integration of Confidential /Medco for many clients including Anthem, UPMC, and Emblem Health.
- Experience in Medco/ Confidential Integration and worked in many applications which involved data conversion testing. I have tested in Data History load testing.
- Experienced in working closely with Business Stakeholders including clients (Anthem, UPMC, and Emblem Health), Technical Leads to understand client data to develop Test Plan, Test Cases.
- Worked on creation of test schedule/test execution plan to ensure data quality tasks are completed as per timeframe in release.
- Wrote and executed SQL queries to validate test results.
- Managed and followed logic given in Data Dictionary for project. Created/Maintained data quality documents such as checklist, templates, and guidelines.
- Participated in cross-functional testing and helped in other teams for data creation for their testing.
- Co-ordinated with each application team to understand each environment details and made sure they have all setup done for end to end testing.
- Participated in status reporting meeting with Project Manager, Business stakeholder and each application test managers.
- Conducted defect triage meetings to ensure defects doesn’t recur and correct action taken.
- Participated in Release planning meeting and provided QA status based on test planning or execution phase.
- Verified build received from development team in Mainframe/Java/Pega technology and approved as a QA Approver.
- Validated all programs/modules/projected locked for the release and rejected package when any project missing as per release project lock sheet from release management share point.
- Created Requirement traceability matrix and Test Readiness Review documents.
- Executed test cases in Test Execution phase as per release execution using Mainframe, Java Tools,, SQL Server/Teradata and Soap UI/WSDL/XML in router application.
- Validated results in Data Warehouse using SQL/Teradata/Oracle SQL Developer.
- Captured test cases results in Confidential standard template approved by compliance team and presented to Business stakeholders in meetings.
- Uploaded test cases result and all approvals into Project share point.
- Worked in one release which includes agile framework like sprints, burndown chart for managing overall project status for Java based tool (Manual claim Submission tool for Paper claims).
- Prepare test scenarios, Test cases and upload into ALM
- Involved peer reviews and group reviews.
- Create various templates for calculation of complex projects involved in Medicare Part D program and presented to Medicare Sponsor.
- Worked with downstream application like Finance/EOB (Explanation of Benefits)/PDE (Prescription Drug Event) for proving data and explained them complex Medicare Part D claims calculation.
- Involved in testing QA and Maintenance environment for all the releases and supporting in testing production issues during Command Center calls.
- Ensured that deliverables are on time and meet the quality levels expected by Express Script’s internal and external customers and the Centers for Medicare and Medicaid Services (CMS).
- Responded to inquiries from internal and external customers regarding quality review and compliance policy and procedures, implements corrective action plans in response to negative findings.
- Kept management team abreast of significant issues or developments identified during quality control activities and actions being taken to improve the situation.
- Executed complex queries in Data Warehouse to find production data in Maintenance environment (Prod replica) and copy those data with encryption into QA for testing with live data.
- Worked closely with Business partners from various programs like Medicare Part D/Government Programs, Commercial, Medicaid, Health Care Reform/Obamacare, Anthem, Coventry (Medicaid/Commercial/Med D), Relay Health (Financial Information Transaction).
- Lead program with multiple major releases in coordination with various technical team and project managers while monitoring testing activities and key internal deliverable.
- Responsible to define, manage and supervise quality assurance phases, including end-to-end system testing, functional testing, integration testing, regression testing and user acceptance testing along with production validation.
- Liaising with project manager and technical leads to maintain project schedules, provide testing effort estimates and ensure on-time completion of deliverable.
- Leading in discussions and meetings on QA progress to project leadership, client stakeholders and QA management.
- Conducting defect analysis meeting with QA & development team along with SME to analyze actual root cause of defects and facilitating trainings to improve quality and reduce knowledge gap.
- Assisting team in creating and finding test data in various QA environments.
- Identifying potential risks & issues on a project and develop risk mitigation strategy and contingency plan in advance.
- Providing go-to-green plan to QA management to ensure project completion in the scheduled timelines.
- Apply consistent quality assurance approach, following standardized testing models and guidelines, and deliver consistent quality across all projects.
- Communicating the importance of knowledge of roles and responsibilities and standards to team members and demonstrating importance of quality by reviewing work of others and making necessary modifications.
- Imparting and applying knowledge, providing clear and concise instructions, sharing information and expertise with onshore and offshore team members to enhance process and results.
Confidential
QA Analyst
Responsibilities:
- Responsible for Test deliverables sign off
- Delivery management and task assignment of testing team
- Involvement in Scrum calls and providing the status of the team to offshore and onshore managers
- Prepare Test plan, get it review by business and follow up sign off.
- Prepare Test Plan, Test scenarios, Test cases and Test conditions and Test data.
- Involved functional testing, regression testing, Sanity testing and GUI testing.
- Participated in Walk Through and Defect report meetings periodically.
- Upload test cases and requirements into Quality Center and prepare requirement traceability matrix
- Test case execution and updating the status in Quality Center and maintaining the screenshot test proof documents
- Involved in Status reporting on test progress, Highlighting the issues & concerns if any to the Project Manager & Test Manager in terms of Daily & Weekly status reports
- Analyzing the test results and creating the bug report
- Involved in setting the parameter files in IBM Mainframes before requesting the jobs.
- Requesting for jobs to update the DB2 tables, and checking the tables are correctly updating or not through SQL queries.
- Provide support for audits in the project.
- Attend Defect calls, TSD and FRD calls
- Preparation of Test Plans, Quality Gates, Check Lists and Audit Folders
Confidential
QA Analyst
Responsibilities:
- Developed test cases for each functionality based on the functional specification.
- Participated in Peer review of test cases and test results.
- Actively involved to prepare Test data.
- Execution of Test Cases, Analyzing the test results and creating the bug report.
- Performed Functional, Regression, GUI and Adhoc testing on the application.
- Creation and maintenance of the automation scripts.
- Defects have been logged and tracked them to closure using Test Director.
- Conducted training sessions for new comers.
- Updating the status to client on daily basis.
- Attended Daily Status Conference calls with Onsite team and Offshore.
- Interacting with developers to resolve application defects on time.
- Map the test cases to the requirements to check the test case sufficiency.