Test Plan, Test cases, SQL, QTP, Agile, Waterfall

Neeru Ganju

**********@*****.***

Cell: 617-***-****

Home: 614-***-****

OBJECTIVE:

Seeking a position as a Software QA Analyst in a progressive and challenging environment.

SUMMARY:

Seventeen years of experience in Software QA: Testing of web sites, web applications, Touch screen, graphical user interfaces, and client/server applications. Performed extensive black box testing, smoke testing, regression testing, integration testing, and performance testing - both manual and automated testing using tools such as Silk and QTP. Well-versed with the complete QA process, writing test cases and developing test plans. Experience working with Agile development team. Excellent communication skills and ability to work in a team environment Experience in administering Quality Center, Rally.

TECHNICAL SKILLS:

Languages: Visual Basic 6.0, Power Builder, PL/SQL and SQL

Technologies: HTML 4.0, ASP, VB SCRIPT and XML

Databases: Oracle 8, SQL server 11.0 and MS Access

Applications: Crystal Reports, MS Office 2000, Jenkins, TradeSphere

Testing tools: Silk Test, Silk Radar, Test Track, Starts, Remedy, Mercury Quality Center, Toad, QTP, UFT, Quality Center, Rally, SnagIt, Snipping Tool

Operating System: Microsoft Windows 2000, XP, 7, Internet Explorer, Safari, Chrome

WORK EXPERIENCE:

Cardinal Health, Dublin, OH QA Analyst May 2018 – Aug 2018

Project:

Tier 1 project-Patient Recovery Business (PRB) – Global Supply Chain North America and Latin America. Cardinal Health acquired Patient Product Portfolio from Medtronics. Suppliers, Customers and employees migrate to Cardinal Health Systems and process.

Environment:

TradeSphere, a Global Trade Management (GTM) Software,

Global Trade Web Tool, SQL Developer, Oracle, Java, Global Logistics, SAP S4, Quality Center, ServiceNow

Responsibilities:

End to end testing. Creating shipments, ASN (Advance shipment Notice) and generating FDA release documents.

Coordinating with multiple teams for business process and data flow.

Source to target mapping verification using SQL queries and Global Trade web Tool to make sure data required to generate shipments is coming into the Vastera Database correctly.

Database verification for data transformation to make sure data going out to other systems is transferring correctly.

Trouble shooting the invoices/Orders/Shipments, correcting errors using TradesPhere Tool.

Ran test cases in Quality Center.

Updated existing test cases as per latest requirements and mapping documents.

Logged/tested defects using Quality center.

Sedgwick CMS, Dublin, OH Senior QA Analyst Mar 2008 – Jan 2018

Project:

TAMS2 Absence Management Applications, IVR, Reporting, Auto communication, Absence Pattern, Auto Approval, Incidental Absences, Auto Adjudication (AUA), VOE

Environment:

Microsoft SQL Server, .NET, C#, Quality Center 9.2, QTP 9.2, Rally, Agile Zen, Jenkins, XML, Progress, 4GL, Java Script, PUTTY

Description:

TAMS2 is used to record and manage employee absences. Absences can be added through various sources like IVR (phone call), Via-one which is an application where employee can log into the system and log their own absences. The supervisor can approve or deny absences entered by employees. The absence details also reflect in TAMS2 application which is the master absence management system. Absences can also come from Juris which is another application which tracks disability cases.

Project:ViaOne express is a Claims Management application for clients. It is a web application www.clientlookup.com where clients can log in and file a Disability claim.

Project: Walmart-SalaryandDriverImplementation-Hourly Benefit calculation

Responsibilities:

●Extensively tested TAMS application.

●Performed integrated testing of the TAMS and the JURIS applications.

●Created, executed and maintained test plans and detailed test cases.

●Performed smoke tests, functionality tests.

●Executed regression tests after fixing the bugs to make sure the bug fixing did not cause problems.

●Moved from waterfall SDLC to Agile methodology.

●Used Rally to track the story cards and requirements.

● Responsible for creating and executing test cases and tracking defects in Quality Center and in Rally.

●Regression tested the TAMS application by executing and debugging QTP scripts.

●Performed manual regression testing of auto correspondences.

●Participated in domain walks and retrospective meetings.

●Fast paced environment, performed monthly off-hour production releases and other hot releases.

●Provided feedback to end users regarding status and estimated fix times for resolutions.

●Wrote Test Result documents for end users.

●Verified clients can log in to VOE application from their mobile phones and file a Disability claim or Worker’s Com claim or check the status of already existing claim.

●Performed parameter load testing to ensure client entities data migrated from flat files to database correctly.

●Experience in XML and web services.

Fresenius Medical Care, Lexington,MA QA Engineer May 05 – Dec 2007

Projects

Facility Database Application, Treatment Sheet system, Chairside System, Physician Database, Doctors Corner, Security Portal, Password Reset, Provider Relational Managemet (PRM)

Environment:

Java, Oracle, Oracle 10G, Domino, Websphere, Remedy, Mecury Quality Center, Quick Test Professional

Description:

The Facility Database Application is the authoritative source of information on the organizational structure and the individual business entities of Fresenius Medical Care N.A. With the Facility Database application the users view, add or update business entity data and create reports, mailing labels and extracts. Users access the application from FMCNA intranet. All users can view business entity data and generate reports. A restricted group can also add business entities, update business entity information and generate dialysis location extracts for their designated locations.

Physician Database is the primary source of information about the physicians who are affiliated with FMS. This application provides the ability to track and query physician information, produce reports, create a list of physicians based on specific criteria and produce mailing labels.

Treatment Sheet System (TSS) - The clinical staff performs the treatment transactions of a patient in the Treatment Sheet System. They can open and close the shifts in TSS. They assign a patient to a treatment station and document the Hemodialysis setup.

Chairside System is same as TSS except the treatment data is entered through touchscreen.

Doctors Corner web site has Clinical Reports available to doctors.

Responsibilities:

●Member of QA team for new, Medical Treatment Process (Kidney Dialysis)

Also Individual Contributor for other QA testing. For these projects I worked alone rather than on a team

●Participated in Design Discussions with Business Analysts and other IT project personnel to understand workflow process

●Wrote Test Scripts, Executed Test Scripts, Reported on Execution Process

●Used Mercury Quality Center to enter and execute test scripts

●Used Excel spreadsheets to compose test scripts, subsequently exporting the tests to Quality Center for testing.

●Administered Quality Center. This included facilitating new project setup, user maintenance, release/cycle setup, requirements setup, test case organization and defect management.

●Received salary increase(s) during this contract placement.

●Collaborated with counterparts on other teams including: developers, implementers, project managers, business line managers, user representatives, legacy system developers, and hardware and help desk teams

●Trained other QA personnel in software usage

●Worked remotely on a regular basis

●During one period of testing, tested 3 builds per week during a month when there was a production release each week

●Participated in QA testing for centralized applications, critical to company’s security and workflow process

●Performed smoke test, Functionality test and Regression tests for various applications.

●Performed security portal testing

●Performed security test for Facility Database Application

●Logged bugs in Remedy and Mercury Quality Center.

●Prepared status reports

●Prepared TSS data validation plan.

●Create users and assigned security roles.

●Helped to update User Guide for UAT.

●Helped update the Functional Specifications.

●Automated security test using Quick Test Professional tool

●Performed ETL testing

Dun & Bradstreet – Waltham MA QA Analyst Mar 04 – Nov 04

Projects:

Zapdata, MarketPlace, PasswordSmother

Environment:

Java, JSP, JavaScript, HTML, SQL Server, VBScript, ASP, VBA, Windows 2000/NT, StarTeam, Lotus Notes.

Description:

Zapdata.com is an internet site of D&B, one of the leading web sources for business sales leads, mailing lists and market analysis, providing a single point of access to up-to-date information on more than 14 million U.S businesses. This site hosts critical data such as contact names, fax numbers, and firmographic information from many of the world’s leading data sources.

MarketPlace incorporates Open Data architecture into a desktop application that integrates information from industry leading data suppliers, allowing users to further refine their select for their target markets.

PasswordSmother is a company wide password security enhancement project.

Responsibilities:

●Lead tester for zapdata.com web site; performed site wide testing, ensured accurate data updates, and supervised live site releases

●Tested quarterly DVD data refreshes and CD-ROM desktop software containing information on over 14 million U.S businesses.

●Lead Tester on Open Data feature of MarketPlace desktop software and web site.

●Tested the entire web site as part of Password Enhancement project to ensure company wide compliance with industry standard security regulations.

●Contributed to reduction of monthly data release time from 4 weeks to 2 weeks.

●Decreased costs and QA test cycle time by executing automated test scripts for data releases as well as regression tests.

●Specialized in performing data tests between servers and client side browsers using MS SQL 7.0/2000.

●Built, maintained and modified automated tests using VB and VBA for CD-ROM products.

●Entered, tracked and verified bugs in Problem Tracking database.

Market Measures/Cozint – Andover, MA QA Analyst Nov 2001 – Jun 2003

Projects:

Panel Management System, KP Portal, Admin Portal, Client Portal, Project Activity Log (PAL), Scripdriver.

Environment:

ASP.Net, ASP, VB Script, JavaScript, HTML, DHTML, SQL Server 2000, Photoshop, Visual InterDev, Windows 2000.

Description:

Panel management System is a custom application for NOP, facilitating centralized data storage, creation and management of medical professional sample populations to use in medical research.

KP Portal, Admin Portal, Client Portal – facilitate login, enrollment, creation, review/update of Health Provider profiles.

Project Activity Log (PAL) – a project-tracking tool facilitating management of complete project life cycle from proposal to timeline development to implementation.

Responsibilities:

●Converted MMI to Cozint respondent recruit approach.

●Integrated Product Lines for maximum potential and achieved high operational efficiency during Cozint/MMI company merge.

●Trained employees in QA practices and procedures.

●Tested existing functionality, reviewed requirements, created detailed test plans and test strategies for new features and enhancements of web/client server applications.

●Tested session cookies using various browsers: IE 6.0, Netscape Navigator 6.0, 7.0

●Logged, tracked, and prioritized bugs using STARTS (Cozint proprietary bug tracking tool)

●Installed new builds, created and maintained release notes, process documents and user manuals.

●Performed smoke tests and regression tests for various builds and releases of the product.

●Performed extensive database testing, using SQL and MS Access.

●Performed integration tests and oversaw site releases.

Emerge/mPower – Andover, MA QA Analyst Jan 2001 – Aug 2001

Project:

xPress Agricultural Data Management Product

Environment:

Oracle, Access, VisualBasic 6.0, HTML, ASP, VBScript

Description:

xPress is a comprehensive, full-featured web application, designed for agricultural data management, specifically to enable growers, dealers, service providers, and distributors to enter, update, store and review critical farm and field management information. PC Yield is another software that allows users to determine crop potential based on current field specific weather, historical weather patterns, seed variety, fertilization, and soil type.

Responsibilities:

●Tested the software on different operating Systems: Windows 95/98/2000, Windows ME.

●Created, executed and maintained test plans and detailed test cases.

●Performed smoke tests, functionality tests, and integration test.

●Executed regression tests after fixing the bugs to make sure the bug fixing did not cause problems.

●Tested browser functionality (IE 5.5) and online reporting features of the application.

●Performed database migration tests.

●Conducted product and documentation reviews.

●Entered and tracked bugs for various software in Test Track

PROFESSIONAL TRAINING:

Client Server Certificate Program

Worcester Polytechnic Institute, Waltham, MA

Intensive, hands-on, project-oriented curriculum, with special focus on relational, database technology (Oracle, MS Access, Sybase), GUI design frameworks (Visual Basic, PowerBuilder), and Client/Server development (middleware, ODBC, networking). Projects were based on Internet and Intranet applications using network technologies such as ActiveX, HTML, DHTML, and ASP. Database design and analysis using entity relationship diagrams (ERD). SQL realization of designed databases, complete with stored procedures, triggers, referential integrity checks, and constraints. Projects followed a full "waterfall" development life cycle:

Requirements, Design, Implementation, Test, and Delivery. Team design and development of a complete application. The application, a fictitious bookstore, "Acme Book Emporium" included design and development of a database and front-end GUI, with Internet access.

EDUCATION:

Computer Applications: Northeastern University, Boston.

Masters in English: Kashmir University, India.

Bachelor in Arts, Bachelor in Education: Kashmir University, India.

Visa Status: Citizen of the United States of America.

Contact this candidate