Data Test

Meenakshi Sinha

E-Mail: *************@*****.*** Mobile: 678-***-****

Professional Summary A Software Quality Assurance leader with more than 10 years of manual and automated testing experience with mission to deliver quality software. Wealth of domain knowledge in Healthcare, Risk Insurance, Staffing and e-Commerce solutions include Cloud based applications. Extensive hands on experience in driving systems quality throughout the SDLC in Agile/Sprint based delivery model. Experienced in creating comprehensive Test Plans, Test Cases Test Data, SQL queries, Data Analysis and XML/JSON requests to ensure success with quality by validating Front-End/UI, Web Services and Back- end including database. Extensive experience in leading Business/User acceptance testing (UAT), QAT, Offshore coordination and successfully testing applications in Non-Production and Production environments which includes Sanity, Regression and new feature enablement testing. Extensive knowledge in using tools like, ALM, QC, Fitnesse, Selenium, SOAP UI, Postman, ETL testing with SSRS

(Database Reporting), Shell Scripts/Power Shell and TFS. Some recent achievements to highlight:

- Datawarehouse ETL Testing - successfully created and verified more than 100 database reports using Power Shell ISE tool.

- Performed comprehensive data analysis by running complex SQL queries across multiple database tables to ensure quality of data in database reports.

- Successfully rolled out cloud-based Claim Processing Tool without any defects. Created and verified more than 50 test cases.

- Created Test plan framework from scratch for data warehouse testing project

- Used Postman for API testing and Selenium for Web UI testing.

Work Experience Zelis Healthcare, Atlanta Position: Senior QA Analyst 09/2016 – Present Zelis, a market leading healthcare information technology company and provider of end-to-end healthcare claims cost management and payments solutions including network management, claims integrity and electronic payments serving healthcare payer clients, healthcare providers and healthcare consumers in the medical, dental and workers' compensation markets nationwide. Role and Responsibilities:

Actively involved in all Sprint ceremonies including grooming, planning and retrospective.

Develop test plan and cases to align the testing efforts needed to complete user stories for each Sprint cycle.

Prepare and review test scripts using Microsoft Test Manager (MTM)

API Testing - Used Postman and Swagger tool to test APIs. Wrote adaptors to test / invoke web services.

Web UI Testing – Used Selenium to automate Web testing

Reviewed database test cases according to assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL server database. Meenakshi Sinha

E-Mail: *************@*****.*** Mobile: 678-***-****

Responsible for updating and maintaining the TFS for reporting and logging the defects found during the functional and regression testing and follow up the bug life cycle.

Functional and Cross Browser testing of Defined Browser Stack of the site experience.

Defect Triaging and Release sign off for Continuous Delivery cycles.

Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

Environment: Swagger, TFS (Team Foundation Server), Microsoft Test Manager (MTM). JIRA, Internet Explorer, Firefox, Microsoft Office Suite (MS Word, Excel etc.), SCRUM, Agile, SQL server Report Builder, Microsoft Visual Studio, XML, JSON, Power Shell

PeopleNet Inc. Atlanta, GA Position: Senior QA Analyst June 2014 – Sept. 2016 PeopleNet provides a workforce technology solution customized to fit any business needs. It offers automated, fully hosted solutions designed to help agencies provide their clients with excellent time tracking and payroll processing services. The web-based solution stream lines all staffing processes which leads to improved operational efficiency of the customers. Role and Responsibilities:

Actively involved with SCRUM and sprint meetings, managing product backlogs, removing obstacles to progress, re-allocating resources where necessary, prioritizing and review milestones and accomplishments.

Develop test plan to align the testing efforts with each sprint.

Prepare and review test scripts using Rally.

Used SOAP UI tool to test SOA based architecture application to test SOAP services and RESTful APIs.

Performed SOA / web services testing using Soap UI, wrote adaptors to test / invoke web services.

Reviewed database test cases per assigned Requirements to validate reports by retrieving data with complex SQL queries from SQL server database.

Responsible for updating and maintaining the Rally for reporting and logging the defects found during the functional and regression testing and follow up the bug life cycle.

Functional and Cross Browser testing of Defined Browser Stack of the site experience.

Defect Triaging and Release sign off for Continuous Delivery cycles.

Writing complex SQL queries and update transaction and properties for accounts on stages for UI testing, Integration testing with different data points etc.

Participated in daily, weekly meetings and technical reviews. Prepared reports showing the testing efforts.

Environment: Soap UI, Rally, Jenkins, JIRA, Postman, Internet Explorer, Firefox, Microsoft Office Suite

(MS Word, Excel etc.), SCRUM, Agile, SQL server Report Builder, Microsoft Visual Studio, Eclipse, XML, XPath

Meenakshi Sinha

E-Mail: *************@*****.*** Mobile: 678-***-**** Aon-eSolutions, Marietta, GA Position: Sr. QA Analyst October 2008 – July 2014 Position: Senior Test QA Engineer

Projects: Risk Console, IVOS, Automation (Fitness) Aon Risk Console is a true browser-based risk management information system (RMIS) that combines claim, exposure, policy, and other risk-related data to provide risk managers with a comprehensive view of their organization's risk. Aon RiskConsole is the pioneer in browser-based risk information technology. Used by more than 100,000 users in more than 40 countries in eight languages, Risk Console is the premier global RMIS solution.

Role and Responsibilities:

Developed test automation, using TDD approach (Fitnesse, Groovy, etc.)

Worked in sprint team with business analysts and developers in Agile methodology.

Involved in Sprint planning, story prioritization and story points estimations.

Integrated automated testing with Jenkins Continuous Integration and Sauce Labs cloud-based test execution.

Modified automated test scripts as per functional requirements and created/maintained Groovy fixtures for new functionality.

Created REST API tests using Fitnesse REST services.

Analyzed Continuous Integration needs and developed and implemented test tagging strategy so that different tests were run at appropriate times.

Performed backend testing with SQL queries using Fitnesse Slim tables to perform CRUD operations.

I was responsible to report the sprint execution tasks and time entries in JIRA.

Reviewed manual testing methods, developed and executed automated scripts.

Involved in manual as well as automated testing of the applications.

Used SoapUI Pro NG/Ready API automation for REST based web services.

Involved in Defining user defined parameters to execute various functions in QuickTestPro

Used QuickTestPro checkpoints to automatically capture and verify properties such as the number of links, images, broken pages etc.

Managed offshore team in India and China.

Managed UAT co-ordination with various clients.

Environment: QuickTestPro, SoapUI, Fitnesse, Groovy, JIRA, QTP, QC, TOAD, Internet Explorer, Firefox, Oracle, Flex, Java, J2EE, Microsoft Office Suite (MS Word, Excel etc.), SCRUM, Agile, Citrix (Data Def, Load Def)

LBI, Atlanta GA Position: QA Analyst March 2008 – Sept. 2008 Project: Transitions Optical Managed Care Website, Home Depot and Bayer LBi develops digital solutions from customer strategies to immerse interactive experiences to post launch results tracking, analysis and optimization. Lbi offers interactive marketing services tailored to the clients' unique objectives.

Meenakshi Sinha

E-Mail: *************@*****.*** Mobile: 678-***-**** Role and Responsibilities:

• Review and perform detail analysis of FSD (Functional Specification document).

• Wrote test cases and scenarios in Mercury's Quality Central (QC).

• Conducted manual and regression tests based on Test Cases.

• Performed manual testing on various websites like Home Depot, Bayer etc.

• Performed detail functional testing of all interactive and non-interactive pages.

• Performed testing of web applications developed on Java and .Net environments running on different operating systems for compatibility purposes.

• Prepared test summary and defect report.

• Communicating and coordinating with off-shore QA team in India and development team in Atlanta for defect resolution.

Environment: Quality Central (QC) 9.0, QTP 9.2, HTML, Windows XP and Vista, .Net, ASP, VB Script, Java, JSP, Java Script, Microsoft Word, Excel, Adobe flash DAU (Defense Acquisition University) Sept 2005 – Feb 2008 Position: QA Analyst

1. Defense AT&L Green data Initiative

Defense AT&L workforce community is around 1.5 million and the data needed to be consolidated at one centralized place where the acquisition workforce members can login and verify the information present in the Civilian master database. There was a requirement to build an application to make the data green. The database was housed in the SQL 2003 server and a .Net application was built on top of that data, which the user community can log in via secure channel and correct the information. There is administration section for the various components to log in and search personnel database with various options for the search engine and approve the updated information. 2. STARS (Student Tracking and Registration System) The Defense Systems Management College's (DSMC) Office of the Registrar is responsible for capturing and disseminating student enrollment information to users at DSMC and DAU. The Project automates the essential tasks required for performing basic Registrar functions, sharing of information to DAU and DSMC staff and interfacing with external information systems. Role & Responsibilities:

• I was responsible for testing important components of both projects mentioned above. I primarily tested Student Enrollment and Course offering modules for STARS and Person Information screen, position and training information in Defense AT&L Green data initiative project.

• Prepared test cases in Test Director.

• Used Win Runner to automate functional test.

• Planned and implemented regression testing with emphasis on automation of scenarios

• Manually compared systems output to initial data to ensure reliability

• Wrote SQL queries in SQL Server for data verification and validation. Meenakshi Sinha

E-Mail: *************@*****.*** Mobile: 678-***-****

• Tested XML data transfer module through FTP

Environment: QTP, Win Runner, Test Director, VB Script, VB, ASP, .Net, SQL Server, Microsoft Office Suite (MS Word, Excel)

Contact this candidate