Test Cases Project

Ravinder Madadi *******@*****.*** Mobile: 614-***-****

PROFESSIONAL SUMMARY:

More than 13 years of experience in Software Quality Assurance Testing as a Test Lead and Beta Configuration Manager. Good understanding of Data warehouse, ETL, ERP, Client/Server. Good Knowledge in Financial, Health, Banking and Web Applications. Experience in Waterfall and Agile methodologies.

Strong understanding in SDLC, Project Life cycle and Test Methodologies.

Extensively worked as a Beta Change manager including Change Management, Configuration Management, Release Management and Problem Management.

Executed the tasks in Beta as per the project Implementation Plan. Promote and Install code from lower environment to Beta through Harvest tool, DB changes, UNIX code and Informatica mappings etc.

Extensive experience in Test Director and Quality Center for Managing/Executing Test cases, Defect tracking and reporting.

Experience in Integration Testing, System Testing (Functionality, Regression), Performance Testing and User Acceptance Testing.

Created the System Test, User Acceptance Test scenarios and test cases based Business and Function requirement documents,

Proficient in Data Warehouse testing like testing batch loads, Error/ rejected records processing, testing of Data Quality Checks and process dependencies.

Coordinated and managed with offshore testing team.

Reviewed the Requirement documents or story cards and Developed Test Scenarios, Test Cases and Test Scripts.

Solid and hands-on experience in designing and maintaining test plans.

Good skills in SQL, root cause analysis and data Analysis.

Expert in developing test data, test checklist, Test coverage metrics.

Extensive experience in Manual Testing of ETL and BI.

Good understanding in Data Warehousing and ETL Testing concepts (Dimension

Data Modeling, Star Schema and Snowflake Schema)

Excellent understanding of relational database concepts including normalization, referential integrity, joining tables, SQL, DDL and DML.

Good sense of teamwork, leadership quality, integrity, aptitude to learn and ability to put in sustained quality effort consistently.

Conducted project test case review and testing status meetings.

Work closely with Developers in resolving the issues.

Managed daily assigned tasks were completed in accordance with time.

Working and communicating with Developers, project managers and application rollout groups in order to set and meet quality standards.

Ability to communicate effectively at all levels of the Testing and Development process.

Attended the GO-NO-GO meetings and sign-off the project.

Reviewed the implementation plan with project tech leads.

TECHNICAL SKILLS:

Operating Systems

Windows NT/95, 98/2000/XP, Macintosh UNIX, DOS, Sun Solaris.

Languages

C, XML, SQL, PL/SQL

Testing Tools

Winrunner,Silk5.0, Silk Performer, Ruby-Cucumber, Quality Center, JIRA

Databases

Oracle, MS SQL Server, DB2, MS Access, Teradata and Netteza

Tools & Utilities

TOAD, WinSQL, SQL Navigator, Putty, Harvest, Maestro, Hamming bird

Reporting Tools

Micro Strategy, Business Objects.

ETL Tools

Data stage 7x, AbInitio and Informatica 9.0.

PROFESSIONAL EXPERIENCES:

Wipro LTD Jul-14-Jun-17

CVS Health, Minneapolis Jan-16 – May-17

Role: Test Lead,

Novolozix is a health care services company specializes in Prior Authorization of specialty drugs and Claims processing.

Responsibilities:

Participated in review meetings (System Requirement Document).

Prepared test cases and Test Scripts based on Design & Requirement documents.

Experience in analyzing EDI requirements and mapping documents.

Experience in EDI transactions (837,997,999,270, 271,278).

Good Knowledge in various EDI X12, EDIFACT standards and Flat Files (Prop Format).

Verified Translated EDI Output file with Paper Map as per the requirements.

Involved in testing HIPAA EDI Transactions and mainly focused on PA and Eligibility.

Worked Extensively with EDI Inbound and outbound claims processing systems.

Extensively Used BIZTALK and TPAM for validating EDI files.

Written the complex SQL queries and executed to validate the data from source to target.

Used Quality Center to design and execute the test cases, create, manage defects.

Created and assigned the defects. Worked closely with developers to resolve defects.

Used SharePoint to store document and version control.

Environment: SQL Server, BizTalk, TPam, Oracle and Quality Center

CVS Health, Irving, Minneapolis Aug-15 – Jan-16

Role: Test Lead,

CVS is an American drug retail pharmacy chain. RxClaim is one of the mainly used Adjudication Systems in CVS Health. We are involved in Query Testing of Client Benefits. It mainly deals with validating patient pay, accumulations, plan limitations, drug coverage etc. We are involved in Client Benefits Testing of various clients such as MVP, Welmark, Health NET and Medicaid.

Responsibilities:

Involved in CRD validation, Benefits Preview Checkpoint, Coding Checkpoint, Query Testing and Peer Review

Responsible for Performing Adhoc, Query and Smoke Testing

Responsible for providing timely updates to the customer

Responsible for attending the Triage calls and getting clarifications and reporting issues

Responsible for updating status and uploading test artifacts in the web based application SFDC

Environment: SQL Server, Oracle and Quality Center

True Value Inc., Chicago, Aprl-15 – Aug-15

Role: Test Lead, July’14 – Dec’14

The Customer Focused Vision Project is to create value for Retailers. The main objectives of this project is to allow True Value and our Retailers to leverage customer data and insights to drive incremental sales by delivering targeted, relevant marketing, supporting better decision making on new stores, relocations and conversions. The testing scope is to validate the data flows from the source systems to ESB to CDI to CDW.

Responsibilities:

Participated in daily stand-up and System Requirement Document review meetings.

Prepared test cases and TSQL Scripts based on Requirement documents.

Reviewed the Master Test Strategy, Test cases with Development and testing team.

Coordinated with source systems and scheduled the End-to-End beta flow dates.

Create and managed defects through JIRA.

Performed Traceability Matrix that maps test cases to requirements Coverage Analysis.

Executed test case and validated the data from source to target.

Involved and managed System, Regression and Integration Testing.

Reviewed the defects with project team and communicated the status.

Environment: SQL Server, Oracle, Teradata and JIRA

Zurich, Chicago, IL Jan’15 – Aprl’15

The Zurich Financial Data Warehouse is organized by “Subject Area”. The environment is built primarily to support US and CANADA data.

Responsibilities:

Participated in review meetings (System Requirement Document).

Prepared test cases and Test Scripts based on Design & Requirement documents.

Written the complex SQL queries and executed to validate the data from source to target.

Used Quality Center to design and execute the test cases, create, manage defects.

Created and assigned the defects. Worked closely with developers to resolve defects.

Environment: Netezza, Oracle, Unix, Informatica, Quality Center, Business Objects

Nationwide, Columbus, OH Jun’08 – Jun’14

Department: NF Data Warehouse /NFIDS / RADS/ iMedia

Role: Test Lead, Configuration Manager, Sr. Tester

The Nationwide Financial Data Warehouse (NFDW) is organized by “Subject Area” or Mart, with each development group focusing on a particular set of applications, product information. The NFDW contains the various Data Marts. The Marts are categorized based on the Line of business into Customer, Channel and Finance. The NF Data Warehouse provides direct and easy access to vast amounts of data that support reporting and analytical requests for numerous lines of businesses. The environment is built primarily to support ad hoc queries, meaning that by design the NFDW provides the most information (at the lowest level) possible and offers the flexibility for the user to sort, filter, aggregate business rules as needed for their request.

Project(s): Compus sunset, Data Quality, Siebel RIA, Advisory Services, Configuration Management, ESTAR, Back Log Projects, Dc Direct Product Conversion, Production Support (Break/Fix tickets), RUNAS to SUDO, QAT Process Improvement, Automated Password Change, May 1 Funds, Spot light, Server Currency, Database Upgrades, DTCC FAR, PPA Expansion, PALLM to ECIF, Spia, NBSG, Quarterly Password Changes, Alpha DB server Refresh

Responsibilities:

Participated in review meetings (System Requirement Document or Story Cards).

Prepared Project Testing Estimates, Master Test Strategy and Test Plans documents.

Prepared test cases and Test Scripts based on Design & Requirement documents.

Reviewed the Master Test Strategy, Test cases with Development and testing team.

Coordinated with source systems and scheduled the End-to-End beta flow dates.

Used Quality Center to design and execute the test cases, create, manage defects.

Performed Traceability Matrix that maps test cases to requirements Coverage Analysis.

Verified the Implementation Plan and approved to move the code to Beta environment.

Executed, Completed test flows successfully and Communicated to the project teams.

Involved and managed Static, Regression, Integration, System and Acceptance Testing.

Written the complex SQL queries and executed to validate the data from source to target.

Strong experience in Business and Data Analysis, Data Profiling, Data Integration and Metadata Management (MDM).

Validated the Meta data, Data Quality Checks and verified the UNIX logs.

Coordinate, manage and support testing efforts with upstream and downstream systems.

Created and assigned the defects. Worked closely with developers to resolve defects.

Compared the actual result with the expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source.

Prepared Test data and validated Transformation rules.

Validated report fields present in the reports are as agreed in the specifications.

Checked the reports for any naming inconsistencies and to improve user readability.

Conducted, participated the defect, status review Meetings and provided the status reports.

Managed daily assigned tasks were completed in accordance with time.

Coordinating the Team on how to do the tests in different environments.

Created User Acceptance Test scenarios and test cases based Business and Function requirement documents,

Reviewed the implementation plan with project tech leads.

Attended the GO-NO-GO meetings and sign-off the project.

Verified the Implementation Check list and approved the RFC to implement the project.

Performed the Post Implementation Testing in Production.

Performed the root cause analysis for defects/break fix issues.

As a Beta Change manager involved in Change Management, Configuration Management, Release Management, Problem Management.

Executed the tasks in Beta as per the project Implementation Plan. Promote and Install code from lower environment to Beta through Harvest tool, Data Base changes, UNIX code and Informatica mappings etc.

Performed the Database, Harvest and Unix Quarterly Password changes.

Environment: Windows XP, Netezza, Teradata, Oracle, Unix, MicroStrategy, Informatica, Quality Center, Business Objects, Harvest, Webfocus, Maestro, Agile, Waterfall

Regal Computer Systems, KN. Jan’ 06 - May’ 08

Clients: Nationwide Financials, Columbus, OH

Ace Technologies, Inc. USA. Oct’ 03 - Dec’ 05

Clients: Nationwide Financials, Columbus, OH

Aventis Pharmaceuticals, NJ

Aventis is developing the MATtriX project to access and Generate Reports by using MicroStrategy Web, Desktop and Narrowcast.

Environment: MicroStategy, Seibel, Test Director, Documentum, Load Runner, Oracle 8i

Rsquare Technologies, Inc. USA. Jun’ 02 – Sep’ 03

Client: Visa.com, CA.

Visa.com is a leading Credit Card Company has developed a online Customer Account Management web site. Worked as a Sr. QA Engineer for the projects.

Generated scripts by Using Win runner automated tool.

Performed manual and automated functional testing of Web application in Windows NT, 2000 environment with Web browsers.

Environment: Load Runner 7.5, Win runner 7.5, Clear Quest and Windows2000.

Client: DirecTV Broad Band, CA.

DirecTV is a TV channel and DSL Internet provider. Worked as a Sr. QA Engineer for the projects like Comm. STD and Packages on the O.S.S4.0 (E.R.P) application. Prepared documentation and test cases for Customer, Order details and E-mail Communication Management System integration with KMA tool.

Environment: Load Runner 7.5, Oracle 8i, PVS Tracker, Test case Manager, Windows2000.

Ace Technologies, Inc. USA. Feb’99 - May’02

Client: Apexon Inc, CA.

Project(s): BRM Application with SAP

Apexon is creating a (Supply Chain Management) Business Relationship Management (BRM) Enterprise software solution for ERP Applications. This consists of different modules like Production: Consignment Inventory, BOM bills of material, Planning: Request for Commit (RFC), Capacity Management, and Procurement: Request for Quote (RFQ), Reports, Alert Management System (AMS).

Client: USWEB / CKS, CA.

Project(s): 3Com Media Ease - Education through Media

SEGA.Com - B2C Web Application

i2i. Com - B2B Web Application

Britannica.com - Professors Online Application

Responsibilities:

Prepared test cases and Test Scripts based on Design documents & Requirement documents.

Work closely with Developers in resolving the issues and understanding the functionality for future reference

Performed all phases of end-to-end testing which includes User Acceptance testing,

Functionality testing, Regression Testing, GUI testing, and system testing.

Managed daily assigned tasks were completed in accordance with time.

Attended the GO-NO-GO meetings and sign-off the project.

Reviewed the implementation plan with project tech leads.

Environment: Oracle 8.0, Windows NT, Silk 5.0, Team-Track and Silk Performer 3.5

Client: Neoforma.com, CA.

Project(s): Health Care B2B Application

Neoforma is the leader in healthcare business-to-business e-commerce, delivering comprehensive information and e-commerce services for medical products, equipment, supplies and services to healthcare buyers and suppliers worldwide. This system contains Auction, Shop, Plan, Resources and Registration modules.

Environment: Oracle, Oracle applications10.7sc, Netscape, Load Runner 5.0, Test Director.

Client: Pure soft Inc, CA.

Project(s): Human Resource Monitoring System

Involved in design and development and testing the Human Resource Monitoring System developed in Oracle which had GUI interfaces developed on Visual Basic 6.0. The system had features like customer lists, product lists and invoice generations.

Environment: Oracle 7.3, VB 6.0, Win NT, Win Runner 5.0, Test Director, Load Runner 5.0

FCS Pvt. Ltd, - Apr’ 97 - Dec’ 98

Integrated Accounting System

Involved in customization and implementation of Oracle Application Accounts payable, Receivable and General Ledger modules. The implementation follows the centralized control system using distributed database with remote control access connecting to different production centers with network over purchase and issue of materials to its production centers. The responsibilities include in designing, coding and testing phase of the system. Involved in Acceptance, Functional and Data Validation testing for the application. Performed Integration tests to ensure the interface between the modules.

Responsibilities:

Prepared test cases and Test Scripts based on Design & Requirement documents.

Participated in Master Test Strategy, Test cases review meeting.

Used Test Director to design and execute the test cases, create, manage defects.

Performed Traceability Matrix that maps test cases to requirements Coverage Analysis.

Written the complex SQL queries and executed to validate the data from source to target.

Preparation of Test documentation and sign – off testing.

Identified, Documented and Tracked software defects also in Quality Center.

Attended the GO-NO-GO meetings and sign-off the project.

Reviewed the defects with project tech leads and developers.

Environment: Oracle 7.1, Oracle Financials 10.6, Reports 1.1, and SCO UNIX

Gayathri Info Tech Pvt Ltd, India Aug’ 96 - Mar’ 97

Sales Order System

Involved in analysis, design, development and implementation of the Sales Order System, which is, integrated in two modules Inventory and Sales. Generated sales quotation for customer information and sales order using (forms and reports) Developer 2000.

Environment: Oracle 7.1, Developer 2000 (Forms 4.5, Reports 2.5) and Windows 95

Education: Post Graduation in Computer Applications

Contact this candidate