Data Test

RADHIKA KANDRAKONDA *******.***********@*****.***

Senior Quality Analyst/Engineer 901-***-****

PROFESSIONAL SUMMARY

Proficient as Sr.QA with 9+ years of experience in Manual, Automation, Database, Web Services Salesforce.

Thorough working of STLC.

Expert in understanding requirements, planning, coordinating, executing, reporting of testing projects in diverse industries.

Result driven Quality Assurance professional with extensive experience in software testing methodologies including both Agile (Scrum) and Waterfall models.

Performed System, Functional, Regression, Integration, Black box, Gray box, Resting, Smoke Testing, GUI, Usability, End to End, Positive, Negative, Data Driven testing, Adhoc testing and UAT.

Proficient in devising all artifacts of testing such as Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Strategies, End to End scenarios, Defect Reports, Test Summary Reports, Test scripts, documenting and reviewing results based on requirements and functional specifications.

Hands on experience in testing various domains like Healthcare, Logistics, Automotive and Insurance.

Experience in Independent Verification and Validation (IV&V), as well as Salesforce working environment.

Experienced with Web Services, SOAP UI, Validation of XML files, Test Harness tool, WSDL technologies and Unix Commands.

Knowledge with design and execution of Automation scripts using QTP, selenium Webdriver hybrid framework.

Experience automating full regression on Fitnesse Automation Tool (dbfit) by creating test pages and executing Test suites.

Strong working knowledge of tracking tools like TFS, HP ALM JIRA.

Strong bug tracking, error analysis/solving and resolution skills.

Expertise in testing the data through backend using SQL queries.

Excellent skills in ETL Testing using Informatica Power Center.

Compiled operation reports testing using microstrategy (BI testing).

Understanding of Relational and Dimensional data models.

Knowledge of Metadata and Star schema/Snowflake schema.

Experience as a Business Analyst designed requirements documents by working with marketing managers, stakeholders, development and testing teams respectively.

Extensive experience in managing, working with Lines of Business and leading onsite, offsite and overseas teams and with preparing and running calls, and meetings.

Experience with coordinating with production support/issues, resolving data and environmental issues in a timely manner.

Cooperated closely with IT experts, subject matter experts, project engineers in planning and developing analytical methods for data collection, data variables, analysis, storage, statistics and presentations.

Conscientious hard-working individual, reliable, self-motivated, team player and a quick learner of new Systems and Technologies.

TECHINICAL SKILLS

Testing Tools

TFS, QTP, Quality Center, JIRA, ALM, BUGZILLA, CALIBER

Languages

JAVA, JAVA SCRIPT, JSON, .NET, VB, HTML, SQL, PL/SQL, XML, Salesforce, Performance

Databases

Oracle 9i, SQL Server2000/2005/2008

Operating Systems

Linux/Unix, Windows XP, Windows 7

PROFESSIONAL EXPERIENCE

Client: Maryland State Department of Health – FEI Systems Role: Senior QA Columbia, MD

Project: LTSS DDA Nov2019 – Till date

The Maryland State Department of Health and Mental Hygiene (DHMH) is the state agency that oversees all operations within Long Term Services and Support (LTSS). LTSS is defined as the services and supports used by individuals of all ages with functional limitations and chronic illnesses who need assistance to perform routine daily activities.

Participate in SAFe ceremonies such as: PI Planning, iteration planning, daily scrum, system demonstrations, iteration review and retrospectives.

Review technical requirement documentation and create data/scenarios, write, implement, and report status for system test cases.

Provide peer review of project test cases.

Analyze, interpret and report test results to team.

Executing all modules in Adhoc BI reporting.

Identify, document and manage defects from defect discovery to resolution.

Communicate and collaborate directly with product owners, business analysts and developers when initial defects are identified for timely analysis and resolution.

Exhibit excellent attention to detail.

Make back end modifications in Raven and SQL databases

Involved in UAT support by creating test data.

Client: Health Care Authority -CNSI Rockville, MD

Role: Senior QA May2019 – Nov2019

Project: State of Washington Provider One

Washington Medicaid Management Information System: WAMMIS is a web-based, automated medical claims processing and management information system for processing and payment of Medicaid claims, providing necessary information for use in the management of the State’s Medicaid program developed in java.

Creation of Test Cases, Test Scenarios, Test scripts and Test Execution based on the user requirement.

Writing Positive and Negative Test cases.

Test Defect Reporting and management within JIRA.

Good SQL skills and ability to write SQL statements independently.

Experience in Iteration, Integration, system, functional, regression, sanity and smoke testing.

Involved in test case reviews.

Experience in UAT support.

Experience in working independently to verify and validate the complex test scenarios.

Knowledge of claims, edits, pricing, adjudication, codes, provider

enrollment, pharmacy, managed care modules.

Interaction with Development team.

Presenting testing status and competency in the meetings

Flexibility to move across projects as needed.

Cooperative with team members and can-do attitude.

Involved in go-live activities.

Self-Evaluation to monitor own work to improve quality.

Client: Center for Medicare and Medicaid Services (CMS) Columbia, MD

Role: Senior QA July2017 – May2019 Project: CPC+ (Comprehensive Primary Care Plus)/MDPCP/AMS

The Centers for Medicare and Medicaid Services (CMS), through the Center for Medicare & Medicaid Innovation (CMMI), initiated Comprehensive Primary Care Plus (CPC+). CPC Web provides participating practices with tools to assist CPC Practice reporting and electronic clinical quality measures (eCQMs).

Create data/scenarios, write, implement, and report status for system test cases; Provide peer review of project test cases.

Involvement in the Smoke shakeouts, functional testing, GUI testing, Integration testing, System level testing, Regression testing, UAT, adhoc testing and end-to-end testing for all modules.

Creation of RTM and participation in Defect Review Meetings.

Design of regression test suite for designated areas of testing and execution of structured and regression tests against new releases.

Communication with developers and SQA team members to resolve various issues; analysis requirements for new features.

Composition of testcases to cover both functional and integration aspects for CDMS applications on Salesforce platform.

Development of several functionalities, system, end-to-end, acceptance tests based on existing use cases, Business and Product Requirements written by Business Analysts, as well as Change Requests.

Setup Test Environment and created Test Data for various testing scenarios.

Design and development of the Test plan, System Readiness and test strategies for applications and execution.

Experience in grouping the Regression Test Cases into Automatable Test Scenarios based on the business flow of the application.

Involvement in design and execution of Automation scripts using selenium hybrid framework.

Preparation of daily status reports with progress and targets, sent to management.

Ensuring test artifacts are up to date after release in SharePoint.

Participating in Kick off meetings, reviewing and analyzing project requirements, and managing testing effort for applications.

Extensively tested application on LMDC VAL environments after BDC migration from oracle to SQL Server.

Performing 508 compliant verification testing and reviewing technical requirements and developing testcases and plan.

Extensive participation in Error Review Meetings and ensuring testing process is properly implemented, and bugs are retested after the new build is received into integration.

Generated detailed metrics - Test Case Productivity, Test Execution Summary, Defect Metrics, test Execution Productivity for tracking purposes.

Client: Center for Medicare and Medicaid Services (CMS) Baltimore, MD

Role: Senior QA Mar 2017 –June 2017

Project: Integrated Project Management System (IPMS)

The project was to deliver a Web application - Integrated Project Management Suite (IPMS) to the Centers for Medicare and Medicaid Services (CMS). IPMS is a module in mother project Physician Quality Reporting System (PQRS). The purpose of IPMS is to support daily management throughout the project team, create a centralized repository of all program related information, reducing Level of Effort (LOE) by standardizing core project management processes, increase seamless team collaboration, and aid in resource management and team composition. Responsible for:

Analyzing User stories and developing Test Plan, Test Scripts, Test Cases and execution of them.

Performing Sanity Testing and Smoke Testing before the start of Testing in Test environments.

Functional testing, GUI testing, Integration testing, System level testing, Regression testing, and end-to-end testing for all modules.

Creating and executing manual test cases.

Testing the application across multiple browsers - Chrome, IE, Mozilla Firefox.

Detecting bugs and classifying them based on severity in the TFS Test Management with TestRail tool.

Extensively performing Manual Testing in all modules of the Application.

Verify that all the performance test accounts are working in BDC VAL

Client: FedEx Memphis, TN

Role: Senior QA Jan 2015 – Feb 2017 Project: FedEx Ship Manager – I Net

Internet Shipment is a web-based GUI application for FedEx customers. It is an initiative that provides accurate, consistent and timely shipment for FedEx customers across different regions.

Analyzing and reviewing project requirements.

Design and development of the Test plan, System Readiness and test strategies for applications, and execution.

Development of End to End scenarios, breakdown into Test scenarios and test cases.

Involvement in Environment shakeouts, functional testing, GUI testing, Integration testing, System level testing, Regression testing, UAT, End to End testing and Database testing for all modules.

Creation of Test Logs, Test Summary reports, RTM and participation in Defect Review/Status/GO-NOGO Meetings, as well as reporting to key stake holders.

Performing Tests in various environments, on various platforms, on various GPUs and their combinations.

Design of regression test cases for designated areas of testing, and execution of structured and ad hoc tests against new releases.

Communication with developers and SQA team members to resolve various issues; analysis requirements for new features to identify ambiguities, inconsistencies, and contradictory requirements.

Grouping Regression Test Cases into Automatable Test Scenarios based on the business flow of the application.

Completing data validation from front end application via back end of application using SQL queries.

Preparation of bi-weekly status reports with progress and targets, sent to management.

Ensuring test artifacts were up to date after release.

Participation in Kick off meetings, reviewing and analyzing project requirements, onsite-offshore coordination, and managing testing effort for applications.

Extensive participation in Error Review Meetings, ensuring testing process was correctly implemented and bugs retested after the new build was received into integration.

Generation of detailed metrics - Test Case Productivity, Test Execution Summary, Defect Metrics, test Execution Productivity for tracking purposes.

Setup of Test Environment and creation of Test Data for various testing scenarios.

Client: Center for Medicare and Medicaid Services (CMS) Owings Mills, MD

Role: QA Mar 2014 – Dec 2014 Project: Transformed Medicaid Statistical Information System - TMSIS

The Transformed Medicaid Statistical Information System (T-MSIS) is an expandable and multi-functional State Medicaid data transfer system that will support Medicaid and Children’s Health Insurance Program (CHIP) with Business Intelligence (BI), analysis and reporting. The T-MSIS system will support the State file submission process. States begin the T-MSIS business process by submitting T-MSIS data files to CMS.

Analyzing thoroughly client requirements and business scenarios to understand complete functionality.

Creating and reviewing system test plan and end to end test plan.

Organizing walkthrough’s and review meetings for test plans and Test scenarios, with development and testing teams.

Validation of the accuracy of data in the backend with that of the user input using SQL queries; validation of the application for each code drop.

Active involvement in data loading from file to database through Unix scripts which triggers the Informatica workflow.

Creating requirement traceability matrix to verify coverage of all client requirements.

Active involvement in post-production activities and providing updates on a timely basis.

Conduction of team meetings, review meetings, defect meetings, status updates meetings with team and management.

Involvement in T-MSIS Production environment with support of collection, storage and maintenance of State operational data in the T-MSIS system, monitoring the processes running daily.

Consolidation of all status reports and work plans for functional areas, and upload in to share point for client review.

Ensuring all artifacts are available in share point for client review and approval process.

Continual coordination and working with functional SME’s counter parts for identifying business process and its scenarios.

Preparation of detailed test scripts for business scenarios and ensuring coverage of requirements.

Validation of Business transformation logic applied on target system, Business data check, Record count check for active and passing transformation logic applied, Derived Field from source data is proper, Check Data flow from stage to intermediate table.

Validation of data after loading from stage file/table after applying transformation.

Understanding T-MSIS data model, structure, data elements and relationships.

Validating the business rules and creating test Data for business rules.

Involvement in performance testing for data loads in Informatica and report performance testing.

Performing both positive and negative testing.

Performing data communication through UNIX SSH client protocol, WinSCP and putty for script execution.

Involvement in adhoc testing, smoke testing and prod testing and in many emergencies build testing.

Performing operation reports testing using micro strategy - BI testing.

Performing Automation Testing of File Processing using Fitness tool for data.

Extracting results from Fitness and reporting results for more than 3000 test cases.

Using HP Quality Center for storing, maintaining test repository, bug tracking and reporting.

Client: FedEx Dallas, TX

Role: QA Lead Jan 2012 – Jan 2014

Project: LITE Shipping

LITE shipping is a simple, efficient, familiar and fast shipping solution to lowest-barrier customers. It provides anonymous shipping options to customers for less than one package per day shipments, supporting logged in functionality for existing customers, while ensuring overall quality in Agile mode.

Working with Users of different departments associated with Lite Shipping.

Implementation of project in Agile/Scrum Methodology for stronger results.

Participation in the daily Scrum meetings to provide status of tasks assigned and to update burn up chart.

Conduction of review meetings of test Plan, test Cases with Project Manager, Developers and Business teams.

Provision of estimates for test initiatives and test planning.

Development and execution of test cases based on User Stories for every Sprint.

Conducting System functionality testing and regression testing based on user stories.

Completion of testing in provided timelines.

Reporting status to Project Manager and the Business.

Involvement in Retrospective and planning meetings for each Sprint.

Planning for Sprint validation and supporting development team to test quick fixes if any issues arose.

Performing web service testing to validate the request and response for all backend systems using SOAPUI and Test Harness.

Comparing the results with Beyond Compare tool.

Coordination of testing efforts within the Quality Assurance team.

Working with others through coaching and mentoring new employees to ensure tasks were completed on time.

Working simultaneously on several projects, each with specific requirements and timelines.

Client: Fedex Dallas, TX

Role: Business Analyst Aug 2011 – Jan 2012

Project: FedEx Web Integration Wizard

FedEx Web Integration Wizard (FWIW) is an online Wizard tool that allows users to integrate FedEx capabilities by automatically generating customized HTML code, which is used as a back-office application to help employees rate packages sent to customers, also customers can ship, rate and track shipments directly on user website.

Development of business architecture using requirements such as scope, processes, risk, alternatives.

Gathering Business Requirements from marketing team and stakeholders and eliciting them in the form of requirements, dataflow diagrams and documenting in Caliber.

Working with the development team through the Iterative development cycle to make sure that the laid-out requirements are incorporated into the design.

Performing quality assurance, system integration and user acceptance testing on-time.

Working with QA team through the testing Cycle to verify complete and rigorous testing of requirements.

Client: McKesson India

Role: Testing Analyst Mar 2010 – Jul 2011

Project: Encore

Encore was initiated by McKesson to supply information and care management products designed to reduce costs and improve quality across healthcare.

Participation in Requirement Analysis and use case discussions with the business for Application development and discussion of full scope and business rules with Developers, Team Lead and BA.

Performing manual testing and following formal test protocols for release.

Involved in creation of detailed Test Plan after analyzing business requirements and writing numerous Test Scenarios covering the functionalities of the application.

Creation of test cases for different types of testing and their execution.

Involvement in testing modules of Encore on different machines and browsers - Cross Browser testing.

Using Bugzilla for Bug Tracking and Reporting, generating customized graphs and reports.

Update of existing Test Plans based on changes in the functionality of the application.

Execution of Sanity Testing to determine whether software is performing well enough to accept it for testing effort & Smoke Testing to determine possibility of further testing.

Participation in weekly meetings with the management team and walkthroughs.

Involvement in writing SQL queries to extract the data from Oracle Database.

Working with developers to resolve defects, including providing detailed descriptions and verifying resolutions.

Performing shake out in UAT environment and end-to-end testing.

Maintenance of Test Logs, Test Summary reports and participation in Defect Review/Status/GO-NOGO Meetings.

Involvement in Post Quality activities.

Client: Daimler Chrysler India

Role: Mainframe Tester Aug 2009 – Feb 2010

Project: Cobol Le Conversation

Daimler Chrysler- This project involved converting all the COBOL II and COBOL VS programs to Cobol LE environment through Mhtran2 tool.

Analysis and Test data preparation.

Converting COBOL II and COBOL VS program using Mhtran 2 tool.

Involvement in Peer level review process.

Documentation of testing procedures, raising the defects and achieving successful delivery with timely manner escalations.

Updating lead, daily status with progress and targets.

EDUCATION

Master of Computer Application Jawaharlal Nehru Technological University

Bachelor of Computer Application MNR Degree college, Osmania University

ACHIEVEMENTS

Syntel Star Award - Best Performer recipient for FedEx Lite Project.

Syntel team award - Best Team Performance recipient for Daimler Chrysler project.

Contact this candidate