PRACHI KSHIRSAGAR
Professional Summary:
I have around 8 years of experience in Manual and Automation Testing in Client/Server, Web based CRM and Health Care applications in windows and UNIX environment.
•Involved in developing Test plans, writing Test scripts, Test Scenario’s and Test cases based on the Business Requirements.
•Very good understanding of QA methodologies and processes.
•Having good knowledge of Software Development Life Cycle (SDLC) and Defect Life cycle.
•Experience in writing Test Cases to Business Requirements.
•Worked with Financial, Web, Health Care and Banking Applications.
•Experience in System Testing, Functional Testing, Regression Testing, Integration Testing, Browser Compatibility Testing and User Acceptance Testing (UAT).
•Extensively worked using SQL Queries to perform database testing.
•Hands-on Experience in Black Box and White Box Testing.
•Documentation & Defect tracking by using JIRA.
•Performed web based testing with REST and SOAP services and experience in testing of Mobile apps.
•Sound experience with Automated testing using HP Tools (QTP/UFT, QC/ALM) for Web based applications, and Client Server applications.
•Highly motivated, detailed oriented, ability to work independently as well as a Team Member with excellent Technical, Analytical and Communication Skills.
•Excellent track record of successful completion under tight deadlines.
•Experience with Android testing.
EDUCATION:
Master of Science in Computer Science May 2013
University of Texas at Arlington, TX. GPA: 3.75
Bachelor of Engineering in Electronics June 2002
Pune University, India. GPA: 3.5
TECHNICAL SKILLS:
Programming Languages : C, C++, Java, and Python.
Test Automation Tool : QTP/UFT, Selenium
Test Management Tool : Quality Center, ALM
Defect Tracking Tool : JIRA
Software Version Control : Tortoise SVN
Web Technologies : HTML, JSP, Java script.
Operating Systems : UNIX, Windows
Database : MySQL, Oracle 9i.
IDE and Tools : Eclipse, NetBeans, Android
Agile Methodology : Scrum
PROFESSIONAL EXPERIENCE:
Client: Premier, Raleigh, NC Nov’15- Aug’16
Role: QA Engineer
Project 3 –SCM(Incentives): Sourcing and Contract Management (SCM) contains tools for defining, calculating and working with incentives. The system computes earned and due incentive amounts from terms that you specify incentive definitions. Set up incentive definitions that contain supplier incentive terms and requirements for any supply or service contracts. Earning data is associated with the spend amounts. Summary earnings can be filtered by type of incentive, entity, contract and organization over selected period of time. Existing fees was converted to incentives. So modify existing fees data into a format for use in incentive setup summary and Workbench areas.
Responsibilities:
Participated in writing test plans, test cases and test scenarios.
Performed Backend testing with Microsoft SQL.
Performed data analysis.
Used Jira as an Agile tool.
Followed Agile Methodology.
Participated in testing Hot-fixes.
Followed agile methodology and attended daily scrum meetings.
Frequent Interaction with Developers and BAs.
Performed Functional testing and Regression testing.
Environment- .Net 4.0, In Built DTS, SQL, MS-excel
Project 2 - ERP Hospital Management: ERP is a SaaS (Software as a Service) application. It is divided into various components such as - Material management (MM), Accounts Payable (AP), General Ledger (GL). ERP is typically a suite of integrated applications that an organization can use to collect, store, manage and interpret data from many business activities, including product planning, purchase,manufacturing, marketing and sales, inventory management, shipping and payment and finance
Responsibilities:
Tested entire ERP Hospital Management system by writing detailed Test cases, Test Scenario’s and executed them.
Created EDI Vendor, Generated Purchase order with the EDI Vendor. Tested EDI 850, 855, 820 files.
Financial reporting fields (FRF) were added to MM, AP and GL as an enhancement. Tested if FRFs are added to the different modules properly.
Performed backend testing using MS- SQL.
Tested Item imports, Invoice Imports, JV Imports and Requisition imports.
Performed Smoke testing, Regression Testing.
Logged defect using Premier’s in built Defect tracking system (DTS).
Followed Agile methodology and attended daily scrum meetings.
Frequent Interaction with Developers and BAs.
Participated in Data Migration testing.
Environment- .Net 4.0, In Built DTS, SQL, MS-excel
Project 1 -RxERP :( RxVector and ERP Integration): RxVector application was a specialty pharmacy. Objective of this project was to integrate Pharmacy with the ERP Inventory. Pharmacy used only stock items. All drug details are saved on the ERP database along with the on hand quantity. Using Pharmacy GUI drug information is requested to ERP using NDC and GPI numbers. ERP returns entire item information along with on-hand quantity. When the drug gets dispensed from the pharmacy and gets delivered to the patients, an update is provided to ERP to reduce the available quantity.
Responsibilities:
Wrote Test scenarios, Test cases and executed for the integration of RxVector and ERP System.
Performed web based testing with REST and SOAP services.
Prepared an analysis report for the modules on the ERP side, where additional Pharmacy columns had to be added. (E.g. NDC, GPI, Storage conditions).
Followed agile methodology and attended daily scrum meetings.
Understood working of RxVector; Used JIRA for reporting defects.
Created a new organization, departments and asset locations for the new customer created for integration project.
Imported drug data using excel import feature.
Had frequent interaction with RxVector development team.
Environment- .Net 4.0, JIRA, SQL, MS-excel
Client: Delta Dental, Charlestown, MA Oct’14- June’15
Role: QA Engineer
Project: Core application to process EDI 834 files. Tested incremental releases. Tested and validated data from EDI 834 files successfully saved into the database. Validated Member enrollment details saved into database and member data is accessible from the core application. Tested and validated any changes updated via EDI 834 files are correctly updated in database.
Responsibilities:
Participating in validation of Professional Billing charges from Clinical Applications in Epic and external systems.
Created Bugs when the right charges and cost were missing in patient accounting due build issues on clinical and billing side.
Testing the interaction with Payers when billing is initiated and claim is generated.
Complied with HIPAA when receiving medical records and billing from other software in Epic.
Executed and documented System, System Integration, UAT and Regression Test cases in Quality Center.
Resolved Bugs created and assigned to me.
Converted Manual Test Cases into Automated Scripts using QTP.
Responsible for testing the application for functionality including Interface, System, Integration, End to End testing covering both positive and negative scenarios.
Test multiple Reports using SQL Queries on Toad.
Attended Bug and Test Objective meetings
Tested different aspects of the application like Person search, View benefits, different permission levels to be able to view benefits data, web services, back end testing etc.
Tested the user authentication and other security aspects of the application
Tested Transaction Files for EDI 834.
Wrote SQL for backend testing.
Followed Agile methodology.
Prepared pre-conditioned data for both negative and positive testing of the application
Involved in execution of test cases and reporting the defects using Quality Center
Different test reports are created like defects report, Testing Summary report, Build Cycle report etc.
Interacted with developers, users and various members of my team to discuss and to resolve defects and their priorities
Environment: ALM, QTP, Oracle10.2, Weblogic, Java, XML, JIRA
Client American Well Systems (Telecommute) June’14-Oct’14
Position: Usability Tester
Responsibilities-
Reviewed Functional specification documents for Native, Hybrid & Mobile Web Application Req Docs.
Developed and executed effective test plans, test cases, and test strategies based on the functional requirements of Mobile Testing Strategies
Attended Daily Stand Up Scrum Call to understand the User Stories from Business Analyst
Responsible for testing application on Laptop, iPad, Android phone.
Reported outcome of test cases.
Used Quality Center for Requirements Documentation, Test Plan, Execution and Bug Tracking.
Performed data validation, field verification and data display.
Produced bug reports based on priority and severity of the problem.
Attended bug tracking and problem escalation meetings.
Involved in writing Test Cases based on User Stories in each Sprint
Involved in Functional, End to End & UAT Test scenarios.
Involve in Mobile Platforms – Simulators & Emulators, Android, iOS, window7,Bada, Blackberry
Involve in Functional Testing, UI Testing, Installation Testing, Interrupt Testing, Regression Testing & compatibility testing with the devices.
Involved in Regression testing as we moved forward with new Sprint.
Attended all the Retrospective Meeting after each Sprint to Discuss Start, Stop,Continue and Shout out
Involved in UAT support (running UAT scenarios requested by End User /stakeholder)
Interacted with developers, users and various members of my team to discuss and to resolve defects and their priorities
Environment: iOS, Android, Windows, mobile app
Client: Sabre, Dallas, TX May’13- May’14
Role: QA Analyst
Project: Airlines Solutions – AirCentre Crew: Sabre® AirCentre™ Crew is a set of solutions that enable airlines to efficiently manage their crews. From planning and bidding to rostering and pairing, Sabre AirCentre Crew enables airlines to effectively manage crew training and keep track of crew qualifications to ensure that every flight is manned by a legal crew. AirCentre Crew offers an integrated and comprehensive solution that supports the end-to-end crew management needs of an airline. The suite addresses all phases of crew management operations from long-term crew resource planning through day-of-operations crew tracking and recovery, ensuring efficient deployment of crew at minimum cost while maintaining flight reliability and schedule integrity.
Responsibilities:
Provide the testing status on regular basis to the Senior Leadership Team (Director Level).
Discuss and decide the Test Strategy for quarterly releases.
Provided several improvements in Testing Processes.
Debug moderately complex software products through the use of systematic tests to develop, apply and maintain quality standards for company products.
Perform regression, functional, smoke, and positive and negative testing.
Test multiple Reports using SQL Queries on Toad and later added them to QTP scripts for automated testing.
Tested the performance of search query under such a heavy load.
Analyzed the load test results for various airlines.
Performed Component Integration testing (CIT) between various components like Roster editor and pairing editor.
Execute software test plans and take part in best practices for testing as well as tools and technology. Maintain documentation of test results to assist in debugging and modification of software as well as modify test scripts as needed.
Analyze test results to ensure existing functionality and recommend corrective actions.
As Senior Software Quality Assurance Engineering I have also acted as a mentor to junior team members.
Work closely with cross functional teams(dev team and delivery team)
Environment: ALM, QTP, Solaris, Jules, Oracle10.2, Perl, Weblogic, JBoss
Client: CVS, Woonsocket, RI July’10 –July’11
Role: QA Analyst/Tester
As the nation’s largest pharmacy health care provider, CVS deals with three business units – Minute Clinic, pharmacy benefit management (PBM) and retail pharmacy. The project deals with patient care, identifying opportunities and providing patient and pharmacy required services. It is a complex system used nationwide deals with drugs and patient care from multitude of insurance companies. This not only used for patient care but also to improve patient health by regular follow up via outreach service calls, recommends treatment for patients identifies therapeutic gaps and accepts manufacture coupons. As a QA tester on Rx Connect which is java based application, executed batch scripts using Control-M and worked on different types of stores.
Responsibilities:
Responsible for converting Manual Test Cases to Automated Scripts using QTP.
Created and implemented test cases, test scripts (using VB Script (QTP)) and prepared test data.
Responsible for performing GUI and functional, and integration testing.
Performed System Integration Testing (SIT) between different Applications.
Performed Regression, Systems, end-to-end testing to maintain the quality of the application.
Reviewed and created test scripts. Executed test cases.
Used Quality Center for Requirements Documentation, Test Plan, Execution and Bug Tracking.
Performed data validation, field verification and data display.
Produced bug reports based on priority and severity of the problem.
Attended bug tracking and problem escalation meetings.
Interact with developers and business analyst.
Environments: Quality Center, Java, UNIX, WinSCP, Windows XP, XML, Toad, Team Track
Client: Trimurti InfoTech, Pune (India) Sept’06 – June’09
Role: Sr. Software QA Engineer
Online Hospital Management: Online Hospital Management website was developed for providing various facilities to their patients such as online consultancy, online appointment, Patient history, Information about available services, online payment facility etc.
Responsibilities –
•Analyzed and documented the business and functional requirements into the Test Director.
•Mapped the test cases to the functional requirements in Test Director (Quality Center)
•Performed Regression, System and Feature function testing on the web application.
•Raised, Tracked and verified the defects in a Defect Tracking Tool - JIRA.
•Participated in Defect Review meetings with development team.
•Provided the Testing status to the manager and development team.
•Performed backend database testing by SQL queries.
Environment: Java, Servlets, JSP, XML, HTML, MySQL, Test Director, JIRA, Eclipse, Tortoise SVN
Pharmaceutical Products Management: This website was developed for the same hospital which has a separate division for their pharmaceutical products. Through this website, the hospital management was selling their in-house medical products to their patients as well as to other private hospitals, nearby medical colleges, and some local and regional pharmaceutical distributors.
Responsibilities –
•Analyzed business requirements, specifications and responsible for documenting the functional requirements in Test Director.
•Involved in developing detailed Test Plan, test cases and test scripts using Test Director for the Functional and Regression Testing.
•Design and write the test cases in Test Director (Quality Center).
•Executing the test cases and updating the results in Test Director (Quality Center).
•Performed Integration, Regression, System and User Acceptance Testing of an application.
•Detected, Raised, Tracked and verified the defects in JIRA.
•Mentor 1 junior tester.
•Reproducing the issues reported by customers.
•Providing the Testing status to the manager and development team on weekly basis.
Environment: Java, Servlets, JSP, XML, HTML, MySQL, Test Director, JIRA, Eclipse, Tortoise SVN
Orca Networks, Pune (India) Jan’06 – Aug’06
Position: QA Engineer
Online Banking Management: This was a web-based project developed for the local Bank. The online banking application, allows customers to check balances, make transfers and view recent transactions.
Responsibilities –
•Understood the Business requirements.
•Wrote the test cases in Excel sheet.
•Executed the test cases manually and documenting the results.
•Performed functional testing.
•Raised defects and validated them.
Environment: Java, Servlets, JSP, XML, HTML, MySQL, MS Excel
Android Application development-Health Services: (ACADEMIC PROJECTS (During Master’s Program)
Objectives:
•Enables physician to maintain up-to-date information about his patients from a remote location.
•Maintains every patient information in the database, Physician can pull out any of his patient information using the search functionality.
•Physician can look into his appointments on his phone.
•Patient can schedule an appointment. He can also look into his medical information.
Project Duration: 3 Months
Responsibilities:
•Writing Test cases as per the requirements.
•Performed unit testing, integration testing, system testing, and regression testing.
•Prepare the documentation, Release notes.
•Provide the iteration based project status by following the Agile Methodology.
Environment: Android, Core Java, PHP, MySQL.
Automation of Web-based application using Selenium Tool:
Objective: The objective of this project was to understand the Selenium automation tool in depth and create a test framework for 10 sample test cases on any web application.
Project Duration: 4 Months
Responsibilities –
•This was an individual project.
•Study the Selenium tool in depth.
•Create an automation framework using Selenium Webdriver.
•Automate those test cases using Selenium.
•Execute the automation scripts on different browsers (IE, Chrome, Firefox).