Test Cases Microsoft Office
Resume:
Shilpa Akula
***********@*****.***
PROFILE:
Senior IT Professional with over Eight plus years of experience in the IT Industry, having extensive expertise in testing applications in the areas of WEB & Client/Server, Mainframe. Specialized in Agile/Waterfall Methodologies and testing of software components for Build/Release testing. Good Interpersonal and Analytical skills and an overall Team player.
Strengths include:
High level of Analytical and Problem Solving skills with an eye for detail
Strong hands on experience with JIRA,ALM,QTP, Quality Center,IQ Tracker,CALT,MarkLogic,SoapUI 4.6.2,RQM,ClearQuest,Rational Clear Case
Specialized in writing scripts using SQA Team Test, Mercury Tools and Compuware Tools
Proficient in establishing Testng Methodology, Test Plan Design and Test Execution spanning various phases of Software Development Life Cycle
Performance of various types of Testing : GUI, Component, Functional, UAT, Integration,E2E, Regression, System testing and Automated Testing
Defect Tracking and Reporting using Test Director, Clear Quest,Bugzilla and MS Word/Excel.
Coordination with various groups from Initial Defect Finding to its Final Resolution
Result oriented professional with a proven track record.
TECHNICAL COMPETENCIES:
Testing Tools
Automated Tracking System,Test Director, Bugzilla,SQA Team Test,Rational Team Test,
JIRA, ALM 12.21,Quality Center,IQ Tracker,CALT,MarkLogic,SoapUI 4.6.2, PuTTY,WinSCP RQM,
Clear Quest, Rational Clear Case, Quick Test Pro
Testing Tools Versions
Test Director 8.0/7.6/7.2/7.0, Quick Test,Professional 5.6/6.5/9.0
Databases (RDBMS)
MarkLogic,Oracle SQL Developer 3.1.07,Toad, SQL Server, MS-Access, Golden, Informix.
GUI
Visual Basic, Developer 2000
Languages
C, C++, .Net,HTML,XML,TOAD,VB Script,COM+,SQL, JAVA1.4/1.5, J2EE, JavaScript, JIRA
Web Servers
Weblogic, Websphere and Apache
Web Tools
ASP, InterDev, COM, Frontpage 98
Operating System
Windows7/ Vista/XP and Microsoft Office 2010
PROFESSIONAL EXPERIENCE:
QSSI, Columbia, MD Dec 2013 – Present
Sr. QA Analyst
ACA - Federally Facilitated Marketplace (FFM)
A Federally-Facilitated Marketplace (FFM) are for states that does not have there own Exchange.The Centers for Medicare & Medicaid Services (CMS) is working to build the Health Insurance Marketplace for consumers .The Federally Facilitated Marketplace (FFM) allows consumer to determine there eligibility and enrollment. Consumers in FFM have the option to apply for Insurance Affordability Programs (Medicaid, Children’s Health Insurance Program [CHIP] and Premium Tax Credits) through state Medicaid and CHIP agencies or through the FFM. This requires close coordination between states and the FFM to ensure an effective and streamlined eligibility process.
Roles and Responsibilities:
Strong functional understanding of E&E and all the other modules related to it.
Part of Open Enrollment Testing for both the years.
Involved in Requirement gathering, creating test cases and executing in ALM.
Well Versed with Requirement, Test Plan, Test Lab tabs in ALM.
Well versed with TW and QMO Process.
Worked closely with CMS on test case review.
Worked together with the team members.
Involved in Functional and Regression testing in different environments.
Worked in Database to get the different queries to validate the application from backend.
Validated the XML, 834 and IPP from MarkLogic database
Well versed with Defect LifeCycle.
Ability to work on tight schedule and deliver the product on time.
Good Knowledge and Experience on functional SoapUI web services testing.
Worked on Medicaid Rules, MAGI, NonMAGI and quarterly updates.
Worked on BAR (Batch Auto Re-enrollment) and know how to validate X12 EDIFECS transactions
Worked on different modules for FFM : OE1,OE2, IRS Reporting, 1095 Form, ESD, Call Center, Issuers.
Worked on basic UNIX commands.
Environment: Java1.4/1.5,ALM 12.21,JIRA,Quality Center,CALT,MarkLogic,SoapUI 4.6.2,PuTTY,WinSCP,XML,Windows7/XP, Microsoft Office 2010.
Deloitte, Camp Hill, PA Oct 2012 – Aug 2013
Sr.QA Analyst
Washington Health Benefits Exchange
Washington Health benefits Exchange Health plan (Health Exchange) is a public-private partnership whose mission is to redefine people’s experience with health care. The Exchange is responsible for Washington Health plan finder-an easily accessible, online marketplace for individuals, families and small businesses to compare and enroll in qualified health insurance plans. This one-stop shop will enable Washington residents to, make apples-to-apples comparison between Exchange Qualified Health Plans (QHP). To implement this reform, Deloitte Consulting will be responsible for implementing a web portal making affordable health insurance available to Washington residents. Determine eligibility for tax credits or less expensive co-pays and deductibles. Receive personal assistance finding, selecting and enrolling in the right health plan to meet their needs.
Roles and Responsibilities:
Involved in Smoke Testing and AdHoc Testing for each build.
Involved in back end testing using SQL.
Wrote test scripts according to the System Design Documents.
Created defects in Jira tool when issues found.
Created applications and ran the batches to verified the correct status.
Performed System testing as per the System Design Documents in various sprints.
Did Functionality testing whether the System Design Documents met with the test scripts.
Played a lead role for the Enrollment module assigned to me.
Did Regression Testing after every build and reported the issues to the Functional leads.
Worked Closely with the Functional and Tech leads to understand the functionality well.
Attended the Client Meetings
Worked on R1/R2 release for Plan Management and on Pediatric Dental Plans
Working on R3/R4 release for Individual Enrollment module
Provide weekly documentation tracking progress
Worked with Development team related to the database related issues.
Validated the data in the database whether the data/status is correctly displayed from the application.
Worked in training team and created data to present before users.
Given training for testing to the newly graduated students.
Tested the Ready for retest defects and executed scripts in INT1, INT2, Training, Devlopment and UAT environments.
Environment: Java 1.4/1.5, JIRA, Oracle SQL Developer 3.1.07, Windows7/XP, Microsoft Office 2010.
Deloitte, Camp Hill, PA July 2011 – Sep 2012
Sr.QA Analyst
New Mexico UI System Modernization Project
UFACTS is a framework designed to support Department of Workforce (DWS) New Mexico to manage unemployment insurance benefits for Employers and Claimants registered in New Mexico. It enables employers to maintain their profile and submit their wages and other financial information. Claimants can submit their claim through the system and get Benefits. System also covers various administrative activities such as Fraud Detection etc..
Roles and Responsibilities:
Wrote test scripts according to the use cases.
Performed Screen testing as per the use case, Workflow documents.
Did Functionality testing whether the use case requirements met with the test scripts.
Played a lead role in the testing team.
Given training for testing to the newly graduated students.
Did Regression Testing after every build and reported the issues to the Business Analyst lead.
Created defects in Clear Quest when the issues found.
Whenever the defects are fixed. Did retested the defects and closed/re-open it.
Verified the use case, workflow, System Requirement documents in Clear Case.
Communicated Business Analysts whenever had questions on use case.
Communicated with developers whenever had issues with the code.
Ran batches myself in System Test.
Performed Testing in TFP (Training) Environment
Review application and learn Use Cases
Write Test Cases and Scripts for Phase 2 Tax
Screen Test and Script execution for Phase 2 and 3
Provide weekly documentation tracking progress
Environment: .Net, Toad, Rational Clear Quest, Rational Clear Case, Windows7,Microsoft Office 2010.
Deloitte, Camp Hill, PA April 2011 – July 2011
Sr. QA Analyst
Child Care Management Systems for the State of Virginia
Customer Portal is a web based platform developed for the State of Virginia. Customer Portal enables Virginia people to apply for Child Care. This web based application has five modules. Screening modules checks if the individuals applying for the above benefits are eligible or not. Apply for Benefits module enables the individuals to apply for the benefit by proving all the necessary information. Renew My Benefits section enables the individuals to renew their benefit if their benefits have expired. Check My Benefits enables the individuals to check their benefit and Report My Changes enables individuals to report the changes to their application.
The VaCMS (Virginia Child Care Management System) is an automated system for the Child Care Subsidy Program that will allow Virginia to meet federal mandates more efficiently, provide greater accuracy in payments to providers, and improve overall program management.VACMS benefits include: enhanced case management capabilities, automated
eligibility determination, integration with Electronic Child Care Point of Sale (ECC POS) swipe card devices, and automated encumbrance calculations.
Roles and Responsibilities:
Wrote Test Cases based on the Business Requirements.
Executed the test scripts as per the expected results. Updated the results on Rational Quality Manager (RQM).
Created defects using Rational Quality Manager (RQM) and attached the failed test cases to the defects.
Performed Regression Testing for each build in QATEnvironment (Testing), UAT Environment.
Worked with Development team related to the database related issues.
Validated the data in the database whether the data is correct using Toad.
Tested the Ready for retest defects in UAT and Testing environments.
Environment: Java 1.4/1.5, RQM (Rational Quality Manager), Toad, Microsoft Office 2010, Windows7/Vista /XP.
Deloitte, Camp Hill, PA Aug 2008 – June 2010
Sr.QA Analyst
iCIS (Integrated Client Information Systems)
iCIS project includes COMPASS, eCIS, LIHEAP and CIS
COMPASS
COMPASS (Commonwealth of Pennsylvania Access to Social Services) is to implement the DPW (Department of Public Welfare) programs in the state of Pennsylvania. Compass lets the people to apply online for social services offered by the Commonwealth of Pennsylvania. The self-screening questionnaire can tell the applicants which social services the members of the household may be eligible to receive. It provides the services like Medicaid, Food Stamps, Low-Income Home Energy Assistance Program, Cash Assistance, School Lunch Program and Long Term Care.
Roles and Responsibilities:
Created Test Plans, Test Cases based on the Business Requirements.
Wrote Scenarios using ATS (Automated Tracking System) tool.
Wrote Negative Scenarios based on the Business Requirements.
Used ATS (Automated Tracking System) tool to Track Bugs.
Actively tested each Migration build validations.
Played a major role by actively participating in scheduled conference calls with different regions to review the testing status and Defect Summit meetings to triage new defects and to follow up on new fixes, patches and builds.
The defects found in the application were sent to the developer through e-mail and after fix the same defects were reassigned to the tester for regression test. Defect Reports were generated weekly.
Tested Mainframe application CIS Client Information Systems.
Tested the Regression Testing in SAT Environment.
Tested Compatibility of Internet Explorer and FireFox web browsers for accessing web-based applications
Tested the applications in Development, Integration and SAT environments.
Performed Usability Testing on Web-based Application.
Worked on Children’s Health Insurance Program (CHIP) Reauthorization Act initiative
Worked on COMPASS Attach Scanned Documents (ASD) initiative
Worked on Client Notice Consolidation (CNC) initiative on Mainframe System
Worked on Imaging initiative
Worked on Automated Renewals Mail In (ARMI)
Worked on Master Client Index (MCI.NET)
Did Security testing in Development, Integration and SAT environments.
Tested the Batch related scenarios.
Performed Mainframe Testing.
Performed Testing in TFP (Training) Environment
Involved in back end testing.
Created Service Requests to ITSS to run the batches in several environments.
Involved in Smoke Testing and AdHoc Testing.
Developed QTP scripts.
Performed Security Testing using Image, Page and Text checkpoints and the environment.
Environment: COM+, .Net, SQL, ATS (Automated Tracking Systems), QTP 9.0, SoapUI Pro 3.0.1, Windows Vista/XP/NT.
Gentiva Health Care Services, Tampa, FL. July 2007 – June 2008
QA Analyst
Life Smart Technologies (LST)
Gentiva Health Services, Inc. is the nation's leading provider of comprehensive home healthcare and related services. Gentiva serves patients through more than 500 direct service delivery units within over 350 locations in 36 states, and through Care Centrix®, that manages home healthcare services for major managed care organizations throughout the United States and delivers them in all 50 states and the projects are involved Life Smart Technologies (LST) application, PDA and ADMINOPS. The Application is designed to replace the current Gentiva mainframe system to oracle UNITY system and provide the technology needed to support Gentiva growth. Life Smart which in compasses patient, worker, and administration services. Life Smart is used for scheduling patients and clinicians through a PDA System.
Roles and Responsibilities:
Involved in the setup of the QA lab environment.
Involved in Writing and execution of test plans, test cases based on business requirements of the application.
Created Reports and Graphs in Test Director to keep track of daily Testing Effort.
Conducted Backend Testing by using PL/SQL Statements.
Analyzed the results of manual and automated tests and wrote test cases in XML.
Executed test scripts in VB Script and reported any problems using Test Director.
Performed Security Testing using Image, Page and Text checkpoints and the environment.
Used Test Director to maintain the updated Requirements, Test Cases, and Test Script and to track report and manage defects.
Performed SDLC testing methodologies.
Involved in unit testing, system testing and Back end testing.
Involved in meetings to update the process flow charts.
Performed UAT Testing with business users.
Modified scripts and executed them using QTP as per requirements of testing for different modules .
Involved in monitoring test execution and system resource monitoring of different host machines.
Performed testing in Production Environment.
Executed SQL queries to check the data table updates after test execution.
Created the test data for interpreting positive /Negative results during functional testing.
All the bugs detected were reported using Quality Center. Interacted with the development team to report bugs. Maintained relationships with IT managers, Development, production support and business sponsors for clarifications.
Involved Smoke Testing and AdHoc Testing.
Involved in regression testing after each build release of the application.
Involved in analyzing the reports and documentation of test results.
Support test efforts by ensuring that effective communications are in place with IT Project Management, Application developers, Test Teams and Business teams when required.
Assisted Business users in conducting Usability Testing.
Environment: Quick Test Pro,Quality Center, Bugzilla,Windows Vista/XP/NT, DB2, Sql, Java, J2ee, JSP and Websphere.
EDUCATION:
Masters Of Arts
Osmania University, Hyderbad, India.
BCA (Bachelor Of Computer Applications)
Osmania University, Hyderbad, India.
HONORS AND AWARDS:
Received appreciation award from President Obama for Affordable Care Act-FFM Marketplace project – 2015, QSSI.
Received On the SPOT award for Gentiva Health Care Services project – 2008, Gentiva.
Received Exceptional Team award for Gentiva Health Care Services project – 2007, Gentiva.
Contact this candidate