PROFESSIONAL PROFILE
*+ years of experience in Quality Assurance
Extensive knowledge of SDLC and STLC
Manual and Automated testing with Waterfall as well as Agile/Scrum Methodology experience
Review requirements, specifications and documentation to gain a thorough understanding of the programs and processes to be verified
Proficient knowledge in various types of Software Testing such as System Testing, Positive Testing, Negative testing, Data Driven Testing, Back End Testing and Regression Testing, End to End Testing etc. in client/server and Web-based application
Excellent knowledge of frontend and backend testing of Web Applications
Excellent skills in writing Test Plans, Test Scenarios and Test Cases
Excellent knowledge of writing and executing SQL queries for data validation, create test data etc.
Excellent knowledge of creating complex test data for various applications testing i.e. EDI, CSV data, flat files, xml etc.
Extensive experience in Back-End Testing using SQL on UNIX and Windows platform to validate the consistency of data
Expert in Bug/Defect management using tool such as ALM and JIRA, triage for the defect management, call and run meeting with stockholders for defects resolution, prepare the report of the defects
Good experience in writing SQL for data validation in migration as part of backend testing
Very good working knowledge of major Operating Systems such as DOS, Windows, Linux and UNIX
Maintained Test Matrix, Requirement Traceability Matrix and Test Reports
Strong Knowledge on MS Office suite (Word, Excel, PowerPoint, Outlook, Access etc.)
Knowledge of Medicaid and Medicare Services
Medicaid and Medicare modules as well as Interface Testing and Data Conversion
Extensive experience in gathering Medicaid and Medicare plan requirements from the client
Good understanding of insurance policies like HMO and PPO and proven experience with HIPAA EDI transaction codes such as 834 (Enrollment & Maintenance)
Good knowledge of EDI for 834 and 837 including creating mock files.
Very good knowledge of Section 508 compliance
Well verse with Web Content Management System for managing the content of the Websites
Good communication and writing skills with the ability to adapt to new and dynamic environments.
Ability to multi-task, prioritize and work with time constraints while paying attention to details.
Good problem-solving, judgment, and decision-making skill
Execute the End to End Testing and support UAT for test data and testing
API (Web Services Testing) with SoapUI with data driven testing methodology
Create the different types of assertions for the validation of the Web Services
Automating Web Application Testing using Selenium WebDriver with Java binding and TestNG Framework.
Experience in Data driven Testing and Cross browser testing in Selenium WebDriver with TestNG Framework
Executing Selenium WebDriver Test Cases and Reporting defects
TECHNICAL SKILLS
Testing Tools:
Quality Center, ALM, QTP, Selenium WebDriver, Eclipse, TestNG
Bug Reporting:
ALM, JIRA, Team Foundation Server
Operating Systems:
DOS, Windows, LINUX, UNIX
Database:
MS SQL with Visual Studio, MySQL, Oracle with TOAD, SQL Developer and SQL Plus, MS Access, Sybase with TOAD
Applications:
Microsoft Office/360, Outlook, Skype for Business, WebEx, Claredi, UltraEdit, Notepad++, IBM Content Navigator, Putty, FileZilla, Facets, HP Service Manager
Web Technologies
HTML, XML, CSS, XSLT, Firebug, Web Service, JAWS, VBscripts, Web Content Management, ISS
Education: Bachelor (Mathematics)
Work Authorization: Green Card
EXPERIENCE
Hewlett Packard Enterprise, Indianapolis, IN March 2016 – Present
QA Tester
Job Description: Testing in support of the development and/or implementation of a Medicaid Management Information System, including interfaces to MAPIR (Medical Assistance Provider Incentive Repository) and other strategic vendors and/or applications (pharmacy benefits management, data warehouses, etc.). The function specifically responsible for ensuring that transactional, channel, and integration testing are performed to validate transactions, verify file execution, validate information sharing connections and transmissions, and verify that successful integration can be achieved between the system and external entities.
This includes:
Conducting web-based transaction, batch transaction and file exchange testing
Conducting Interface testing
Create test files based on business design
Conducting Web Services Testing
Conduct the Web application (Websites) testing and automation
Responsibilities:
Conducting Requirements Inspections/Analysis
Working with project team to create Test documents.
Analyzing Business Process documentation, Context Diagrams, Design Documents and Business Requirements to design the specific testing assets that need to be created, including test cases, test data, roles, IDs, etc.
Used SQL Queries for backend testing for data validation and data retrieval.
Responsible for writing and updating test scripts, executing testing, recording and resolving defects in coordination as well as communicating the status and progress of testing.
Test case development, execution and defect management within HP ALM.
Manually creating flat files with complex data for interface testing.
Creating required test artifacts and coordinating/participating in the artifact approval process.
Used HP Quality Center as a test management and defect tracking tool. Microsoft SQL server manager for data validity and the data retrieval. Logged client production support bugs in Jira tool.
Designed and executed various Test scripts for Regression tests.
Arranging testing facilities, training, and reference materials as needed.
Performing execution of test phases - run status, defects, and validation issues.
Coordinating defect resolution with BA, Developer, Test Manager and PM
Reporting status and updating management on issues.
Testing the web services for the accurate functionality of the system using SoapUI
End to End testing – create test data, executing the test to validate the system process the transactions correctly, help in daily meeting of E2E testing by involving in the meeting and writing minutes etc.
Execute and support UAT testing and test data
Analysis of test requirement and automation feasibility
Automating Web Application using Selenium WebDriver with Java binding and TestNG Framework.
Very good hands on knowledge of Java Core for the creating scripts for the test cases
Create and execute data driven Testing and Cross browser testing in Selenium Web Driver using Eclipse
Performed Parallel and Cross Browser testing on different browsers like Chrome, Firefox and Internet Explorer where multiple tests
Use of Soft and Hard Assertion for validation of the test cases
Executed Selenium Test Cases and Reporting defects
Use of different Annotations for the management of the tests
Use of exception handling, implicit wait and explicit wait for enhancing the scripts
Developed the Automation framework using TestNG from the scratch and the scripts (test cases) written using the Selenium WebDriver API in Java
Git and GitHub experience for the version control
Environment: ALM 11, Oracle Database, Oracle SQL Developer, MS SQL, Visual Studio, Core MMIS, Indiana Medicaid Web Portal, Notepad++, Unix Model Office, Putty, FileZilla, Microsoft Outlook, Skype for Business (Lynch), IBM Content Navigator (On Demand), File Exchange (SFTP Server), SharePoint, rLink, Microsoft Office (Word, Excel, PowerPoint, Outlook), Web Services, SoapUI, Eclipse, Selenium WebDriver, TestNG, WinZip, Cisco VPN, Pulse Secure, Team Foundation Server etc.
Optum Technology (United Healthcare Group), Morristown, NJ Aug 2015 – Nov 2015
Quality Analyst/Tester
Description: The scope of the project was to work on an Enrollment & Maintenance (834), validate data in the back end and extensive Backend Testing. The enrollment of the New York state ACA applications can be enrolled through the Facets application of UHG with integration testing and system testing.
Responsibilities:
Performed Back End Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data
Actively participated in, group and individual based, problem solving and decision making throughout the different phases of Agile.
Requirements Analysis for the clear and concise requirements i.e. Business Requirements and System Requirements
Participated in Sprint Planning as part of the agile development for Different functionality for Testing.
Integration Testing and System Testing to ensure the quality of the application/system developed
Writing test cases from the High-Level Document (HLD) as well as Technical Specification Document for the testing to ensure the quality
Upload the test cases in the ALM using ALM add ins for Excel
Create test data (EDI 834 file) for the enrollment, update, cancellation and termination for the validation
Ensure documented the errors and reported them to the developers
Walkthrough of the test cases
Walkthrough of the test results
Meeting with System Analyst, Developer and Lead for the issues in the High-Level Documents to make the requirement clear for the testing
Documented the test results and reported the status of assigned test tasks and issues to project QA Lead.
Conducted Back-End Testing Using SQL Commands.
Extensively used SQL statements to query the Oracle Database and Sybase for Data Validation and Data Integrity.
Environment: Facets, HP ALM 11, MS SQL, Visual Studio, HP Service Manager (HPSM), WebEx, Claridi, Interactive SQL, PLSQL Developer, SQL, Ultra Edit
Anthem, Virginia Beach, VA Jan 2014 – May 2015
Quality Analyst/Tester
Description: The scope of the project was to work on Enrollment & Maintenance (834) as well as claims (837), validate data in the back end and extensive Backend Testing as well as to access the system through the web application. Involved testing manually and by Automating the test cases for the functional and regression testing.
Responsibilities:
Performed Back End Testing-using SQL queries, generating reports to ensure data integrity and validate the inserted and updated data
Performed extensive UAT and documented the errors and reported them to the developers.
Processing of member enrollment and benefits, (834) batch jobs corresponding to the claims (837)
Involved in System testing and Regression testing manually
Resolved issues with member attributes, enabling multiple rules associated with member lookup process in Facets.
Used Team Foundation Server as a test management and defect tracking tool. Used Oracle SQL for backend testing.
Review cases; compare data from consumer, with information received from the FFM (Federally Facilitated Marketplaces), and the Issuer/Health Plan Provider.
Did requirement gathering and testing of consumer web portal for the enrollment of Medicare members.
Tested the Medicare and Medicaid preferred Eligibility and EOB claims extract files.
Managed defect tracking process, which include prioritize bugs, assign bugs and verifying bugs using Team Foundation Server and experience with test manager.
Coordinated with concerned developer/developer teams for design reviews per the business requirements for both UAT and Production testing
Worked on Different Modules like Billings, Membership, Claim and Provider in MMIS application.
Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios
Automated the web applications using Selenium WebDriver with JAVA binding and TestNG by creating the test scripts and executing them.
Tested user interface and navigation controls of the application using Selenium
Create as well as maintain the test scripts created with Selenium WebDriver
Parallel as well as cross browser testing using Selenium WebDriver and TestNG
Use of annotations, implicit wait, explicit wait, parameter etc. to enhance and manage test cases
Environment: MS SQL, Oracle, Sybase, HIPAA 5010, XML, ALM, JIRA, Eclipse, Selenium Web Driver, TestNG, EDI 834/837
NY State of Health, Albany, NY Jun 2012 – Dec 2013
QA Analyst
Description: As part of Affordable Care Act, New York State decided to come up with its own Health Exchange and CSC (Computer Science Corporation) took the responsibility of Technical Architect, Design and implementation / coding of web application need of State. The project has been used for providing health care benefits to the individuals by determining the eligibility considering all the eligibility factors.
Responsibilities:
Maintaining knowledge of Medicare and Medicaid rules and regulations pertaining to the Facets configuration and evaluating the impact of proposed changes in rules and regulations.
Worked on EDI Transactions (834/837) for Verification and Validation as part of System Testing.
Involved in daily client standup meeting with client for business requirements analysis and defect prioritization for existing high and critical defect found in production as well as enhancement.
Used HP Quality center for test management and defect tracking and SQL server is used for back end testing of data validation and data retrieval. Automation tool Selenium was used to run the applications in Firefox.
Played primary role as QA in collecting and analyzing requirements by interacting with client and business analysts and discuss with Development team separately to identify the testing scope as well as development (Coding) scope for those requirement.
Wrote test cases and developed test scenarios based on BRD, SRS, FDD and Use Case Documents.
Wrote SQL queries in Toad for backend testing, Verification and Validation.
Worked on HIPAA EDI 834 use cases and collaboration templates according business requirements.
Responsible for designing Test Steps, Requirement Mapping to Tests, Executing Tests manually, Defect Logging and Defect Reporting using Team Foundation Server and Test Manager.
Performed cross platform and cross browser Testing.
Raised defects and assigned to Development teams with appropriate severity levels.
Worked closely with developers to resolve the technical issues to meet the dead lines.
Worked for UAT Entrance and Exit criteria
Conducted Back-End Testing Using SQL Commands
Environment: Oracle, HIPAA, EDI 5010, XML, QTP, Selenium, MS SQL
Priority Health, Grand Rapids, MI Jan 2011 – May 2012
QA Analyst
Medicare Enrollment Automation-Priority Health automated the enrollment process for Medicare. In order to meet the anticipated growth in Priority Health products, PH choose an improved way to enroll and reconcile Medicare members. The current processes and systems do not meet the requirements from an operational effectiveness or from CMS compliance perspective. PH ability to enroll and service Medicare members, PH installs IKA systems. This system includes IKA's online enrollment portal, Enrollment accretion file generation, Medicare reconciliation and CMS Medicare reconciliation.
Medicare PPO-Priority Health had offered new Medicare product PPO within the Medicare product portfolio. Priority Health automated the billing entity and commissions process as a part of this project. Priority Health expected 30,000 new Medicare members; the current staff cannot fulfill the workflow for creation of billing entity and commission process, which was a manual process before.
Medigap-Priority health added a new line of Medicare supplement (Medigap) products. Medigap products are designed to cover the members cost share ("GAP"- deductibles and co-insurance) that is part of original Medicare benefit design.
Responsibilities:
Identified the requirements for accommodating HIPAA 5010 standards for 834 transactions and captured these requirements to develop new GUI for the internet based application.
Participated in setting up testing environment.
Involved in preparing Test Cases based on business requirements.
Tested 834 and 837 transactions
Authored and executed Test cases for Claims and Customer Service Workflow by manually.
Performed database testing by using SQL queries Responsible for writing the Test Cases and Test Scenarios based on the Functional Specification and technical Specification and documented in Mercury Quality Center.
Worked on claims, Claims adjudication, Membership, Eligibility in different managed care products like HMO and PPO.
Recorded scripts in Quick Test Pro to perform Functionality testing.
Worked with providers and Medicare or Medicaid entities to validate EDI transaction sets on Internet portals
Did requirement gathering and testing of consumer web portal for the enrollment of Medicare members.
Intensively involved in project testing efforts by doing Regression Testing and by helping UAT team in User Acceptance Testing
Evaluated incoming project request for UAT support in order to determine the impacted systems, programs and/or downstream jobs or distributed applications which will need to be included in the project scope
Modified test scripts created by the system test team to meet UAT needs
Supported User acceptance testing (UAT) in preparing the test scripts and test execution
Logged the errors, reported defects, determined repair priorities and tracked the defects until resolution using Mercury Quality Center.
Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
Responsible for performing System and integration testing for release.
Identified, analyzed and documented defects, error and inconsistencies in the application using Quality Center.
Environment: Word, Excel, PowerPoint, Facets, SQL, Oracle, EDI, Quality center