Summary:

• Over 8 years of Software Quality Assurance experience working with Web-based testing, Service Oriented and Client/Server applications.
• ICD 9 ICD 10 Conversion knowledge Worked in the analysis of the ICD 9 10 codes
• HIPAA 4010 5010 Conversion Analysis Involved in documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions
• Experience in testing APIs level testing.
• Deep understanding of QA Process, Test Methodology and Software Development Life Cycle SDLC , Waterfall, Agile and RUP.
• Solid experience with all levels of testing including Smoke Testing, Unit testing, Functional Testing, Integration Testing, System Testing, Regression Testing and UAT.
• Excellent knowledge and working experience in Test Planning, Test execution, Test Results Analysis, Requirement Traceability Matrix and analyzing business requirements.
• Good knowledge in web application testing and automation testing using Selenium.
• Experienced in both Manual and Automated testing tools using HP Quality Center, Test Director and QTP with VB Script.
• Quick Test Professional.
• Developed different Automation Frameworks like Linear, Structured, Keyword in HP
• Experienced in writing Test plans, Test Cases, Test Scenarios and defining the Testing methodologies and verifying and validating the web based applications.
• Effectively worked on Hp Load Runner for performance testing and developed test scripts
• Experienced in Functional, Load and Data Driven Testing in using SOAP UI.
• Extensively verified and validated XML request and response files Web Services from the third party service provider using SOAP UI.
• Extensively involved in Build Acceptance Testing, Functional Testing and Database Testing using SQL Server 2000/2005/2008
• Excellent working Knowledge of Databases like MS Access, SQL server, Oracle with PL/SQL and Stored Procedure.
• Good knowledge of ETL Testing/ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testings.
• Experienced in testing other web technologies like J2EE, Java Scripts and ASP.NET
• Extensive use of defect tracking tool like HP Quality Center, Rational Clear Quest, JIRA.
• Excellent hands on MS office applications.
• Good knowledge using the reporting tool Cognos.
• Organized, detail-oriented and have the ability to work well in a time sensitive environment.
• Excellent communication and presentation skills, self starter, quick learner and team player.

Technical Skills:

• Languages: Java, VB Script, VBA, C, C , SQL, PL/SQL, T-SQL, UML, XML, Shell Scripting
• Test Tools: QTP 8.2/9.0/9.5/10.0,Load Runner 8.0/9.5, SOAP UI, Selenium.
• Bug Tracking Tools: HP Quality Center, Clear Quest, JIRA, Tableau, Cognos
• Databases: MS Access, MY SQL, SQL Server 2000/2005/2008, Oracle 9i/10g, Toad for SQL server
• Operating system: Unix/Linux, Windows NT, Windows 2000/2003/2008 Server Windows XP/Vista
• Web Technologies: XML, HTML, CSS, J2EE, PHP, VB Script, web services, .NET

Professional Experience

Confidential

Title: QA Analyst

Roles Responsibilities:

• Worked as a tester backend and front end in the financial management, member enrollmennt and eligibility module for the UAT and production environment for the Washington Health Finder web application.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate.
• Used JIRA to raise defects and submit the tickets to the respective level.
• Responsible for communicating with the client for weekly status report and also with the offshore team.
• Participated in Daily and weekly status meeting with team members and coordinated with teams Development, Business, and QA for the progress of the work done in application.
• Responsible for running batch jobs daily and monthly to create the EDI files from the existing XML.
• Responsible for validating and analyzing the EDI 834 and 820 files.
• Created jobs to schedule multiple reports in Cognos connection.
• Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins used TOAD and SQL Developer.
• Planned, coordinate and execute microstragety metrics and attributes for End-users and documented the entire project.
• Create ad hoc reports and perform regression testing based on user requirements in the Microstrategy.
• Participated in business requirements reviews and software system application designs for testability.
• Track and report upon testing activities, including the test case execution stage, defect status if any defects opened during execution and the testing results status.
• Wrote Use Cases, prepared use case diagrams using Rational Rose UML and followed Agile at every stage of the processes.
• Developed SQL Queries for checking the Data Transaction and Database Integrity.
• Provided technical and procedural support for User Acceptance Testing UAT .
• Assisted in GAP analysis for any available requirements and communicated through the CR process.

Environment: Oracle SQl, SOA Framework, SQL server management studio, , MS Outlook, MS Excel, MS Access, MS Visio, JIRA, Cognos, Tableau.

Confidential

Title: QA Analyst/ QA Lead for Offshore Team

Responsibilities:

• Coordinated, Managed, Mentor and Lead the offshore team in all the activities regarding Testing and conversion of legacy system to the newest version of Facets 4.81.
• Highly Responsible in developing High Level Test Scenarios from the Business requirement/Functional requirement document.
• Get approval from the business/ Client for the Test Cases/Test Plan, Data Setup and Execution of Test Cases.
• Logged defect in Quality Center QC 10.0, and assigned to an appropriate developer.
• Document all the Test Results TR from the Scenarios and submit to respective POC.
• Involved in developing, documenting and implementation of Healthcare Application using FACETS 4.81
• Involved in Adjustment of the Pharmacy Claims Reversing the Claims, RR, RRCR, RRMR , and paying various types of claims. I.e. DMR Paper Claims , PTP, Government claims, E-claims, MSP Medicare secondary payer , COB, steps on running ERIC, EXTRACT, CET and NDM process.
• Performed smoke, Integration, Functional, and Regression Testing.
• Extensively involved in Facets enrollment module mainly in Back End system process for membership's enrollment info to downstream system and also involved in Front End system process for the information feed to Facets from Source system.
• Attend multiple meetings with the client Lead, Developer, and Project Manager to fully understand the functional and technical requirement, and to discuss the Test Scenarios Created.
• Highly involved with the Client to better understand the system and the business requirements.
• Wrote and Review test cases in QC, and Matrix the requirement documents along with it.
• Conducting the Test Results walkthrough with the Clients and getting Sign off to deploy project on time.
• Involved in integration testing between EAS and RxClaim.
• Prepare TR Test Results documents via Quality Center and provide to the Clients on each project.

Environment: HP Mercury Quality Center 10.0, Windows 2000/2007/XP, Facets 4.81, Rational Clear Quest, MS Excel, MS Visio, XML, Selenium, Cognos.

Confidential

Title: EDI Test Analyst

Responsibilities:

• Responsible for testing entire claims processing workflows as per business requirements
• Gathered requirements and reviewed Use Cases for the applications that used SSN and DOB as unique identifiers.
• Analyzed URS and Functional Requirements Specifications to understand business rules of application.
• Validated displays of Patient Screen to include masked SSN DOB Information.
• Claims Process validation Identified Claims Matching Scenarios upon which millions of Claim records were matched daily based on Patient's Information
• Involved in writing Test plans, creating Test scripts, and Team Co-ordination
• Performed Analysis of ICD 9 Procedure and Diagnosis Codes in accordance with ICD 10 CM and ICD 10 PCS Conversion Compliances
• Participated in meetings and JAD sessions to ensure legal and compliance deadlines of CMS Centers for Medicare and Medicaid Services are met
• HIPAA 4010 5010 Conversion Analysis Involved in the documentation of HIPAA 5010 changes to EDI 837, 834, 835, 276, 277 Transactions.
• Defined the approach for automating significant parts of the QA framework.
• Responsible for carrying out manual testing like Integration, Regression testing during various phases of test cycles.
• Interacted with dev. various members to discuss and resolve defects based on priorities.
• Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project and performed the testings.
• Developed and Maintained Test Schedule for Quality assurance deliverables.
• Responsible for working with application team in UAT and Production Release.
• Documented defects in IBM Clear Quest and provided test execution progress updates.

Environment: SOA Framework, MS Visio, Word, Excel, PowerPoint, CMMI, Rational Rose, Requisite Pro, Clear Quest, Facets, Claredi, SQL, Oracle, J2EE, Cognos, DataWarehouse.

Confidential

QAAnalyst Responsibilities:

• Configured the QA Environment for Manual Testing that includes data level testing and web application testing.
• Used QTP for web application testing as well.
• Created Test cases for all the features going in for that release.
• Performed Business objects testing and validating the results against Data warehouse.
• Tested the data and data integrity among various sources and targets.
• Made sure the link navigate to the correct page and verified the content as per the Business Requirement specifications.
• Review the different subject areas like Formulary, Customer, Sales, Employee, Aggregates etc and provide feedback and comments that help in fulfilling the goal of EDW project.
• Participated in Daily and weekly status meeting with team members and coordinated with teams Development, Business, and QA for the progress of the work done in application.
• Analyzed the Specifications and involved in identifying the source data needs to be moved to data warehouse.
• Good experience in communicating with offshore team.
• Communication with the client for weekly status report
• Helped the team in analyzing the data to be able to identify the data quality issues
• Supported and provided valuable suggestions to the ETL Tester / ETL Analysis, for designing of the flow and the logic for the Data warehouse project.
• Involved in testing to verify that all data were synchronized after the data is troubleshoot, and also used SQL to verify/validate my test cases. Involved in various testing phases like Functional Testing, Integration Testing, Data Validation Testing Positive and Negative Testing, Sanity Testing, User Acceptance Testing and Regression Testing.
• Used HP Quality center to write and run the test cases and to raise and track the defects.
• Participated in Daily and weekly status meeting with team members and coordinated with teams Development, Business, and QA for the progress of the work done in application.
• Developed Test Plan and Test Strategy for multiple data feed applications.

Environment: Quick Test Pro, Quality Center, Oracle SQl, Toad for Oracle, Data warehouse, SOAP UI, MS Outlook, MS Access, MS Visio.

Confidential

QA Analyst

Confidential is one of the leading insurance companies in the Confidential. The application helps the field agents of the company to enter prospective customer's data. The application also calculates the amount of premium required, cash value and benefit amount for the years in consideration. The Online application has different modules and I was involved in testing the Long Term Cares.

Responsibilities:

• Formulated detailed Test Plan, Test Cases and Testing Procedures, which included Test Cases/Scripts, capturing Test Results and capturing and resolving Test Anomalies
• Performed configuration/ compatibility and user interface testing manually
• Have experience designing and writing training manual templates, design formatting, project planning and writing technical documents
• Performed automated testing and data driven testing using QTP.
• Conducted GUI/Usability Testing and Black Box Testing according to specifications.
• Involved in writing complex SQL queries to check the data integrity
• Ensure that products and changes are fully documented.
• Analyzing and documenting detailed program information working and interacting with software developers and members of various other dependent departments
• Analyzing User and Functional requirements to point out gaps between used SQL queries to extract the data from the database
• Performed Smoke and Sanity testing.
• Performed Positive and Negative Testing
• Performed Security testing and Backend testing Manually
• Participated in conducting System testing and End to End testing Manually.
• Performed Usability and Integration testing Manually.
• Used Quality Center for bug tracking and reporting, also followed up with development team to verify bug fixes, and update bug status.
• Documented bugs found out during the process of testing.

Environment: SQL Server 2005, IIS, XML, Web Services, SOAP UI, VB-Script, HTML, Toad, MSOffice, Mozilla Firefox, Microsoft Visual Studio, Microsoft Visual Studio Source Control Explorer as TFS, HP Quick Test Pro 9.5,Load Runner 8.0

Confidential

Role: Software Test Engineer

Description:

Confidential is designed for Confidential It is a web based Medicaid system. This system manages the Medicaid and Medicare for the low-income people of Michigan State. The MI MMIS system has Several Systems like Provider, Claims, Benefits and Administration, HIPPA, Financials, Contract Management, Prior Authorization, etc subsystems.

Roles Responsibilities:

• Prepared test plan and test cases
• Used Clear Quest tool for defect tracking
• Mapped all the Requirements with the Documentation and the Test cases
• Coordinated with developers to fix the problem and enhancing the application.
• Implemented whole life cycle of QA Methodologies starting from planning, Capturing, Creating, Executing, Reporting and Tracking the defects.
• Created and executed SQL queries to fetch data from an SQL Server database to validate and compare the expected results with those actually obtained.
• Responsible for writing SQL Queries to find out that the data is correctly populated in each field.
• Used SQL Queries to verify the data from the Oracle database checked the PL/SQL Packages developed as a part of Backend testing Performed backend testing using SQL queries and analyzed the server performance
• Executed System, Integration, End-to-End and user Acceptance Test UAT test cases
• Conducted Back End Testing, Positive Testing, Negative Testing, and End-to-End testing for web based applications.
• Developed SQL Queries for checking the Data Transaction and Database Integrity.
• Data manipulation using SQL queries in Oracle database.
• Verified the loaded data in oracle and compared the extracted data from Legacy system
• Performed queries in the database using 'SQL' to check successful transaction using TOAD
• Checked the logs were written for each process that runs.
• Validated the internal processing of the MMIS, or other transaction processing system.
• Developed Test scripts to meet the requirement by using the Business Scenarios and Business Requirements for different kind of Claims.
• Provided management with metrics, reports, and schedules as necessary and participated in the design walkthroughs and meetings.
• Identified software errors and interacted with developers to resolve technical issues.

Environment: SQL SERVER 2000, Oracle 9i, Clear Quest, Quality Center, Java, UNIX, QTP 8.2