SUMMARY

• Over eleven years of experience in the field of Information Technology, with extensive experience in Quality Assurance and Software testing of Client/Server and Web - based applications
• Excellent knowledge and implementing skills in complete Software Development Life Cycle (SDLC), Agile Scrum and other methodologies.
• Good experience in working closely with Business Stakeholders and SME’s for day to day activities
• Expertise in analyzing the Business requirements, User Specifications and other Design specification documents
• Proficient in plotting the Test Strategy, Plans, Test cases and other Test related deliverables
• Proficient in Black Box, Functional, System/Integration, Data validation, Regression, GUI and UAT Testing types
• Having work experience in automation testing by using Selenium Web Driver 3.0, Quick Test Pro, HP ALM, JIRA tools. And good knowledge about bug reporting, testing status reporting etc.
• Strong experience in Data Validation/Data base/Backend testing using SQL Queries and Stored Procedures
• Strong knowledge in web services testing via ToolSOAP UI/ Postman/Restful web services
• Knowledge and ability to evaluate medical records and any other healthcare data and EDI transactions

TECHNICAL SKILLS

Operating Systems: MVS, UNIX, Linux, Windows Family

Cloud Technologies: 0365, SharePoint Online, MS Azure, AWS, Salesforce CRM

Tools: /Packages: SharePoint 2010/2013/2016 , ARCHIBUS Web Central

Testing Tools: Selenium Web Driver 3.0, QTP, Test Director, HP ALM, Win Runner, SOAP UI

Web Technologies: HTML, CSS, REST, JSP, Servlets, Ajax, and jQuery, Angular JS, Node JS and XML

ETL and BI Tools: Business Objects 6.5/XIR2, Data Integrator 6.x, Power Center 8.0

Languages: Power Builder, VB script, JAVA, J2EE, ASP.Net, VB.Net, ASP and JCL.

Database: Oracle 9i, 10g, My SQL, MS Access, DB2, SQL Server, Sybase 12.5, 15.5

Database IDE’s: SQL Navigator, TOAD, IBM DB2 Command center, SQL analyzer, Shell Scripts

Application servers: Web sphere, Apache, Tomcat, BEA Web Logic, IIS server, Autosys 4.0

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr.QA Analyst

Responsibilities:

• Worked closely with different business teams to get the required file and data for the testing team.
• Used to raise required RITM tickets to get the system access, data base access and QNXT UI access based on requirements
• Use to prepare database refresh details document required for the DB refresh RITM’s for the requirement
• Worked closely with respective DBA teams to get RWE access permissions for the team members to the required PLANDATA and other DB servers
• Used to verify the received files and delimit the 837 files
• Worked on CLAIM BOT application to load 837 files into the QNXT system and very Load status in the data base and also in the QNXT UI
• Verifying the data in different databases by running sql quires
• Attending onsite and offshore meetings every day and updating the status

Environment: SQL Server Management Studio, SQL, QNXT UI, iserve application, SharePoint

Confidential, CA

Sr.QA Analyst

Responsibilities:

• Attending everyday Agile scrum meeting and bi weekly Spring Planning, Retrospectives meetings and other Technical Review meetings.
• Analyzing and Reviewing the User stories, Business User requirements, Functional and Design specifications
• Designing, developing and documenting Test Plans, Test Cases based on Gap In Care Business requirements, User Stories.
• Frequent interaction and communication with Agile team like Stake holders, SME’s and other team members for clarifications and user story understanding.
• Creation new XML test cases for the HEDIS Measures and updates
• Updating the Azure repositories with XML test cases using CI/CD process
• Verifying and validation of HEDIS Measuresrelate to many significant public health issues, such as cancer, heart disease, smoking, asthma, and diabetes.
• Successfully completed Smoke/Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression testing of the Confidential Application modules for the releases.
• Verification, validation of the user stories using the Confidential 100 k data set.
• After completing verification, validation of the user stories and compare and complete PDBA analysis for the sample Patients using Carehib 250 k data set.
• Verification, validation of new value sets in MySql for Denominator and Numerator
• Verification, validation of output Log files for the required Counts, Hedis measures
• Identified and tracked the bugs until done using JIRA and Azure DevOps
• Data is validated using sql and data validation testing
• Generating weekly Status Reports and Bug reports and updating to the team using JIRA
• Experience withMedical and pharmacy data, provider claims data, and related coding schemas (i.e., ICD-9, ICD-10,CPT, HCPCS, DRG, NDC,REVCODE,UBREV)

Environment: Agile, C++, Oracle, SQL Developer, My SQL, Confluence, GIT, Unix, Linux, XML, SharePoint Online, JIRA, Putty,WinScp, Azure Devops, CI/CD, Snag IT and Webex, HEDIS, NCQA

Confidential, CA

Sr QA Analyst

Responsibilities:

• Attending everyday Agile scrum meeting and bi weekly Spring Planning, Retrospectives meetings and other Technical Review meetings.
• Analyzing and Reviewing the User stories, Business User requirements, Functional and Design specifications
• Designing, developing and documenting Test Plans, Test Cases based on Business requirements, User Stories.
• Frequent interaction and communication with Agile team like Stake holders, SME’s and other team members for clarifications and user story understanding.
• Successfully completed Smoke/Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression Testing of the EMWS Application modules for the releases.
• Verification, validation and complete testing of the Folder Case, PID/EU rule, In-Basket mappings for the STN, RET and ARA Cases
• Verification, validation and complete testing of the Route By System, Route to Team, Route to User, QA task and Approval task functionalities for the STN, RET and ARA Cases
• Verification, validation and complete testing of the Open Case, Split Case, Folder Case and Purchase Case functionalities
• Identified and tracked the bugs until done using JIRA
• Data is validated using sql and data validation testing
• Generating weekly Sprint Burn down, Test Case burn down and Bug reports and updating to the team by status report using JIRA
• Translated EDI document to create a flat files

Environment: Agile, IBM FileNet P8, IBM Case Manager, SQL, IBM Content Navigator, IBM Content Manager, SharePoint Online, JIRA, Snag IT and Webex, EDI transactions.

Confidential - LA, CA

QA Test Analyst

Responsibilities:

• Analyzing and Reviewing the Business User requirements, Functional Specifications and other Design specifications, documents
• Designing, developing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on Business requirements, User Specifications and updating them accordingly whenever needed.
• Designed, developed and documented the Test data based on the business and functional specifications
• Running the Smoke and Sanity Testing in all the required Environments whenever latest codes is deployed, Database is refreshed and for every new Release or Build.
• Verifying and validating some SQL’s and some Stored Procedures other Data base objects in various Testing Environments whenever their is a data refresh and also for a new Release or Build.
• Successfully completed Smoke/Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression Testing and UAT testing of the Envoy Application modules for all the releases.
• Complete Testing of the assigned tasks or newly implemented business requirements or Mantis items to make sure they released to production without any defects.
• Designed, developed and documented Test Cases, Test Scenarios and the Test Data for the Data base Upgrade/Migration project and updated them accordingly for the Next Generation Project.
• Successfully completed major Interface Testing with upstream and downstream applications like CCS and MCS systems
• Worked extensively with SqlDbx and Sybase DB, SQL Server DB for the Interface Testing, back end testing, data base validations testing and for the business and functional validations.
• Extensively used Taskforce, servers and other UNIX servers for running the Taskforce related batch jobs, verifying the log files and other functional validations.
• Running the Shell scripts, taskforce jobs, and validating all the required conditions.
• Identified, Documented and tracked the defects and following through with resolution using HP ALM, Quality Center and generated defect summary report.
• Used Postman & SOAPUI for rest service testing.
• Manual Testing of happy path testing, functional testing, integration testing, regression testing and system testing mainly with Leads, Contacts, Accounts, Cases
• Creation of custom objects, fields and records
• Verifying and validation Assignment rules, Auto Response rules
• Verifying and validation Workflows to check the functionality of time based events
• Verifying and validating the formulas created for the objects validating the all page layouts
• Verifying and validation of validation rules, triggers and apex classes
• Creation of External and Internal Users to verify the system access permissions
• Representing QA/UAT team in Technical Workgroup, Defects review, QA Status and Reporting calls
• Involved in developing automation test case for some of the modules sing Selenium Web Driver

Environment: JAV JEE, JDK1.8, SQL Server Enterprise 2012, SSIS, SSRS, visual Studio, Sybase ASE 11, HP-UX, Linux,Shell scripts, Sun Solaris, Taskforce, Java, HP Quality Center/ALM 11.0, QTP11, Windows XP, Windows 7, Putty, Rapid SQL 7.6.4, SQL DBX, Querybuilder xml, XML, JCL, Share Point and IIS server, WebLogic, Apache 2.0,Spring Framework upgrade to version 4. Saleforce.com platform, Apex Language, Data Loader, Apex Triggers, Reports, SFDC Sandbox, Postman, Rest API, SOAP

Confidential, Irvine, CA

QA Analyst

Responsibilities:

• Attending everyday Agile scrum meetings and other Technical Review meetings.
• Analyzing and Reviewing the User stories, Business User requirements, Functional and Design specifications
• Designing, developing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on Business requirements, User Stories.
• Designed, developed and documented the Test data based on the business and functional specifications
• Running the Installation Script for updating the Testing Environments with the latest codes whenever Development team gives a new Release or Build.
• Installations of Stored Procedures other Data base objects in various Testing Environments whenever their is data refresh.
• Successfully completed Smoke/Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression Testing and UAT Testing for the BAU stories.
• Complete Testing of the assigned User stories in different environments to make sure they released to production with out any defects.
• Designed, developed and documented Test Cases, Test Scenarios and the Test Data for the HP-EOL Life Migration project.
• Completed Smoke/Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression Testing, Backend Testing and UAT Testing for the MARS HP-EOL Life Migration project.
• Complete Regression testing of the MARS Applications in the new Environment for the HP-EOL Life Migration project.
• Successfully completed major Interface Testing with upstream Portfolio Accounting (PA) System
• Worked extensively with Rapid SQL and Sybase DB for the Interface Testing, back end testing, data base validations testing and for the business and functional validations.
• Extensively used Galois-zx Autosys servers and issybnp-zx Unix servers for Running the Autosys jobs, verifying the log files and other functional validations.
• Running the Shell scripts, JIL jobs, and validating all the JIL conditions.
• Extensively worked with Windows 7 virtual machines and installing all the MARS application MSI packages and completed smoke/sanity testing on Windows 7 Virtual Machines.
• Identified, Documented and tracked the defects and following through with resolution using Quality Center and generated defect summary report.

Environment: Power Builder 9.0, 12.0, Sybase 12.5, 15.5, HP-UX, Shell scripts, Sun Solaris, Power Center 8.6,9.0,Autosys 4.0, .Net, Java, HP Quality Center 10.0, QTP11, Windows XP, Windows 7, Putty, Rapid SQL 7.6.4, XML, Share Point and IIS server, Salesforce.com

Confidential, Irvine, CA

QA Analyst

Responsibilities:

• Analyzing the Business requirements, Functional specification and other client on boarding specification documents
• Designing, developing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on Business requirements, Use cases and other specifications using Source forge
• Designed and developed the Test data based on the business requirements and specification documents
• Successfully completed Sanity Testing, Functional Testing, System Testing, Integration Testing and Regression Testing for RTML applications Stage 1, Stage 2 and Stage 3
• Successfully on boarded all the new clients to the RTML application after completion of Sanity Testing, Functional Testing, System Testing, Integration Testing, Regression Testing and UAT Testing phases.
• Complete testing of RTML applications stage1 functionalities like Address Hygiene, First Logic, Bad character check, Spoof check, Email Hygiene, Insource Phone Hygiene, AS1 Phone verification service, Minimum fields check and De dupe etc.
• Complete testing of stage1 advanced functionalities like Address capture, Reverse Phone append, Enhanced Reverse Phone append and Direct Email append.
• Complete verification, validation and testing of the stage2 Personal Level, Livu Level, Zip Level, Geo Level data attributes append for all the clients using the RTML application and the database.
• Verification, validation and complete end to end testing of the stage3 Models like House Hold level and Geo level models using the RTML application
• Verification, validation and complete testing of the stage3 Models implementations for the clients Capella university, NAMG, UOP using the Database
• Verification and validation of Monthly Insource database load/refresh for the Active, Archive data, Retail Data and new data attributes load.
• Complete UAT Testing for all the on boarded new clients
• Execution of Unix Shell scripts for the Webportal reports and for other tasks
• Complete Testing of security features for the new Web Portal application
• Complete Testing of the new Name Parser Logic, new the Cheetah mail Email validation and Honey Pot spam trap rules for the RTML application.
• Developing, modifying, and executing SOAP UI scripts/SOUP UI web services using SOAPUI
• Worked extensively with SQL Developer for back end testing, data base validations testing and stage 3 Models validations
• Completed Smoke Testing, Functional Testing, System Testing, Integration testing and Complete Regression Testing for all the newly on boarded clients based on clients specifications.
• Complete DR implementation (Disaster Recovery servers) and completed Failover and Recovery testing Regression Testing of the DR servers and ensured that Failover of all Prod clients switched successfully to DR servers
• Identified the defects and tracked them until closure using the Source Forge
• Conducted defects review meetings to determine the severity/priority of the bugs.
• Completed Monthly production deployments, observing the prod logs on the Unix servers and sending the Post prod deployment metrics

Environment: Unix, Shell scripts, Java, EJB, Oracle 10g, SQL Developer, Toad, Source forge, SOAP UI Web services, XML, WSDL, XSD, WinSCP, Extra Putty, Web Portal, Apache/ Tomcat 5.5.17, Postman, Manual Testing

Confidential, MN

Test Lead

Responsibilities:

• Analyzed User/Business requirements, Functional specification and Use Case and design documents.
• Designing and documenting Test Plans, Test Cases, Test Scenarios, and Test Strategies based on Business requirements, Use cases and other specifications using Test Director and Quality Center
• Completed the preparation of test data and complete testing of the Java based web services like Item availability, Item Inventory, Item details, Store Locator, and etc.
• Completed Block box testing, Positive & Negative testing, Data Validation, and GUI Testing.
• Participated in planning, implementing, and documenting the user acceptance testing for the UAT Lab.
• Extensive testing of the application on the wireless devices like PDA, MSA and on the POS systems
• Testing data flow from the UI to the database for the Java web services and PDA applications.
• Cross verification of the test cases to the Requirement documents, Design Document to verify that all requirements are being implemented and tested
• System testing, Integration testing with the POS team, QA testing, Failover and Recovery testing and Complete Regression Testing and ensured that systems are not impacted by fixes and upgrades.
• Completed Data validation testing for the entire applications running SQL quires, Store Procedures to the databases DB2, SQL Server, Oracle etc.
• Complete testing of the new PDA, Guest Connect application and Find it at Confidential stores applications.
• Prepared the Test data for the testing activities and for the UAT and Performance testing.
• Participated in User Acceptance Testing (UAT) and Business UAT testing
• Identified the defects and tracked them until closure using the Test director/ Quality center
• Prepared the Requirements Traceability Matrix (RTM), Test Log report
• Prepared Test Summary Reports, Defect Reports and other Summary Reports.
• Interacted with Business Analyst’s and the end users to make sure that the application allows the end users to perform all the intended functions in the UAT lab
• Participated in the Inspection and review meetings to evaluate Master Test Plan, Test cases and other test deliverables.
• Complete testing for the completion of the unknown search POC release.
• Developing and executing automated test scripts using Quick Test Pro for Regression Testing of the PDA and Guest Connect Applications
• Used Quick Test Pro (QTP) for running Data Driven Testing.

Environment: AIX 5.1, Java, J2EE, Java Web Services (SOAP), .VB.Net, .NET Web Services, HTML, XML, DB2, SQL Server, Oracle 9i, Web Sphere 6.0, ATG 7.1, Seibel Call center,, Data stage 7.2. Search Engines FAST & ENDECA, DB2 Connect, PVCS Dimensions, WBSD 4.1, Quick Test Pro 8.0, Test Director 7.3, Quality Center and SharePoint