Summary:
ISTQB and HP QC 9.2 Certified Tester, having 5 years of experience in Software testing, proficient in Comprehensive testing of Data ware House testing (ETL), Oracle Applications, System and Web based applications.

Professional Profile

• IT professional with over 5 years of experience in testing projects related to different modules of Oracle Applications like Oracle Projects, Customer Relationship Management (CRM),Order Management and Database Testing, BI Testing Healthcare domain using various testing methodologies.
• Proficient in implementation of STLC and have good understanding of SDLC.
• Expertise in Test planning, Test estimation, Test case design, Test tool usage, Test case execution and Defect management.
• Experience in executing projects from requirements phase to production phase and Good understanding of process involved.
• Strong and good exposure on ‘Data ware house concepts’.
• Good in analyzing testing areas in Data warehousing application and SQL query writing.
• Proficient in Functionality, Regression Testing, Database Testing using Black Box Testing Methods
• Expertise in preparing test reports, signoff documents in different phases of testing
• Experience in following CMMi process for all test related activities.
• Expertise in preparing reports for higher level management to report the status of the project at granular level and gave estimations for the proposed requirement.
• Knowledge of facilitation, mentoring and technical writing skills including documentation and editing of user manuals.
• Excellent analytical skills for understanding the business requirements, business rules/ process and detailed design of the application.
• Good knowledge on SQL.
• Had exposure on Oracle Applications modules like Order Management and Inventory.
• Well Versed with Agile Testing Methodology.
• Experience in BI Testing (Cognos Reports).

Technology Skills and Tools

Operating System : All versions of Windows
Languages : C, Java
Database Language : SQL
Scripting Languages : Java Script, HTML, Servlets
ERP : Oracle Applications 11i ( Oracle Projects, CRM (11.5.9),
Order Management)
Testing Tools : Test Director, Quality Center 9.2, Toad for Oracle, Toad for DB2, QMF,
Ultra Edit.

Professional Experience :

Confidential, : 04/2010 – 10/2011
IT Quality Analyst,
Business Segment: Optum Health

United HealthCare is an operating division of UnitedHealth Group, the largest single health carrier in the United States.
UnitedHealth Group is a leading health care company, serving more than 75 million people worldwide.
As a leader in the health benefits and services industry, delivers benefits and services through six businesses — United HealthCare Employer & Individual, United HealthCare Medicare & Retirement, United HealthCare Community & State, OptumHealth, OptumInsight, and OptumRx — offer exceptional service, broad capabilities and enduring value in creating a modern health care system. Its products and services empower individuals, expand consumer choice and strengthen patient-provider relationships across the health care spectrum.

OptumInsight - a leading health services business, specializes in improving the performance of the health system by providing analytics, technology and consulting services that enable better decisions and results. It also provides health intelligence through consulting expertise, proven information and analytics capabilities; workflow solutions for health systems; and connectivity for health communities through health information exchanges.

Assignment Overview:

This engagement mainly focuses on the database enhancements of different databases owned by United Health Care. Being a part of testing team for this engagement, tested data and corresponding transformations related to the fields which were implemented by using ETL process.

Responsibilities:

• Review of project related documents (HLD, Functional Specifications, Mapping Document and Technical Specifications)
• Involved in Mater Test plan preparation and Efforts Estimation.
• Walkthrough of Master Test Plan to all Project team and Business users
• Designed and developed ETL Test Cases.
• Executing the ETL Test Cases manually with the help of SQL scripts and UNIX Scripts.
• Analyzed test results, recommended corrective actions, and provided quality feedback to product teams while identifying bugs and issues.
• Involved in creation of Complex sql quries and execution of queries.
• Involved in daily stand up calls, project related call and team related calls.
• Involved in Client Interaction through conference calls and net meeting.
• Responsible for uploading the Requirements, Test Cases and Defects in Mercury Quality Center and track bugs/product defects to resolution for continuous product improvement, including retesting and verifying fixes.
• Worked closely with software developers, business analysts, product managers, and release management to resolve product issues and to ensure high quality and timely product releases.
• Knowledge of facilitation, mentoring and Technical writing skills including documentation and editing of user manuals using Adobe products and Acrobat.
• Prepared project documents and application information documents, this reduced time and cost to train new members.
• Assisting the business team during production check out.
• Prepared sign off documents for every stage of testing.
  

Assignment # 2:

Confidential, Role : Module Lead
Project : Cisco International 3.0
Duration : Oct’2009 – Apr’2010

The Cisco International 3.0 mainly focuses on functional improvements of UK Selling Company.
The primary goal of the Cisco Int\'l initiative is to enable Cisco to capture business opportunities which are currently out of reach due to legal, tax and system limitations that prevent Cisco from conducting local "in-country" business in most geography.

For this release we mainly tested the enhancements happened to Oracle Projects (AS Projects) which includes Functional and Security testing.

Responsibilities:

• Involved in preparation of Test Plan document, Efforts Estimation
• Involved in preparation of weekly & monthly status reports for presenting to the client.
• Involved in daily stand meetings, project related call and team related calls.
• Participated FD review meetings with IT Analysts.
• Participated in daily status meetings with Subject Matter Experts (SME) and Onsite leads.
• Interacted with boundary and development teams for Issue Resolution.
• Responsible for overseeing the Quality procedures related to the project.
• Imparted training to new team mates.
• Creation of Traceability Matrix.
• Assisted the Business Team for BAT/UAT testing.
• Prepared training manual for the BAT and UAT users on QC 9.2 and gave training.
• Involved in Smoke Testing for every test cycle
• Detailed test scripts authoring and execution
• Validation of back end data by using SQL
• Involved in Functional and Regression testing for the Oracle module like Oracle Projects.
• Used Quality Center for Test Execution, Software Bug identification, tracking and reporting.

Assignment # 3:

Confidential, Role : Team Member
Project : SciCare
Duration : Aug’2009 – Oct’2009

Cisco had acquired the Scientific Atlanta, due to this some this employees records need to be migrated to Cisco database. After the migration happened testing was performed with these employee data to make sure that the application is working properly.
Testing includes functionalities like Costing, Billing, Resource Management, Oracle Time and Labor… of OP using the provided Scientific Atlanta resources. And it also focuses on the migrating the systems from SAP to Oracle, Integration of back office operations, Back end support operations to handle the 300+ projects from SciCare to OP. SciCare implementation will be using features of Oracle Projects that are enabled for Cisco AS implementation.

Responsibilities:

• Involved in preparation of daily status reports for presenting to the client.
• Participated in daily status meetings with Subject Matter Experts (SME) and Onsite leads.
• Interacted with boundary and development teams for Issue Resolution.
• Responsible for overseeing the Quality procedures related to the project.
• Involved in daily stand meetings, project related call and team related calls.
• Assisted the Business Team for BAT/UAT testing.
• Given training to BAT on QC 9.2
• Involved in Smoke Testing.
• Detailed test scripts authoring and execution
• Validation of back end data by using SQL
• Have been involved in educating the Team on various aspects of the project.
• Involved in Functional and Regression testing for the Oracle module like Oracle Projects.
• Used Quality Center for Test Execution, Software Bug identification, tracking and reporting.
• Prepared training document on Oracle Resource Management and submitted to Wipro

knowledge repository.

Assignment # 4:

Confidential, Project : Cisco International 2.0
Role : Team Member
Duration : Mar’2009 – Jul’2009

The primary goal of Cisco International 2.0 is to enable Cisco to capture business opportunities which are currently out of reach due to legal, tax and system limitations that prevent Cisco from conducting direct business in certain countries. Direct selling capabilities are a competitive necessity, particularly in emerging countries.This release is primarily focused on making operational one new Cisco Selling company – STC (UK).
For this release mainly tested the functionalities like Costing, Resource Management, Oracle Time and Labor related to Oracle Projects Module.

Responsibilities:

• Involved in preparation of daily status reports for presenting to the client.
• Participated in daily status meetings with Subject Matter Experts (SME) and Onsite leads.
• Interacted with development teams for Issue Resolution.
• Involved in daily stand meetings, project related call and team related calls.
• Detailed test scripts authoring and execution.
• Validation of back end data by using SQL.
• Imparted training to new team mates.
• Assisted the Business Team for BAT/UAT testing.
• Creation of Traceability Matrix.
• Involved in daily stand meetings, project related call and team related calls.
• Involved in Functional and Regression testing for the Oracle module like Oracle Projects.
• Used Quality Center for Test Execution, Software Bug identification, tracking and reporting.

Assignment # 5:

Confidential, Project : Single Trading Company
Role : Team Member
Duration : Sep’2008 – Feb’2009

STC is the second step toward transforming Cisco\'s legal entity structure. It will include: operating unit (OU) systems de-customization; entity creation playbook (defined as "minimal risk" functional setups in test environments only); GSCM-related MOVE rule optimizations; Virtual Trader inter-company billing improvements; multi-jurisdictional onsite AS transactional policy improvements and other foundational improvements.

Responsibilities:

• Maintaining of regression suites.
• Detailed test scripts authoring and execution
• Validation of back end data by using SQL
• Participated in daily status meetings with Subject Matter Experts (SME) and Onsite leads.
• Interacted with development teams for Issue Resolution.
• Imparted training to the new mates.
• Handled the team in the absence of lead for a period of 4 months.
• Creation of Traceability Matrix.
• Involved in Functional and Regression testing for the Oracle module like Oracle Projects.
• Used Quality Center for Test Execution, Software Bug identification, tracking and reporting.
• Making an analysis of the failure reported during the script execution.
• Involved in daily stand meetings, project related call and team related calls.

Assignment # 6:

Confidential, Project : Synergy
Role : Test Engineer
Duration : Jul’07 – Aug’08

Scope: Cisco Synergy Commerce Transformation enables the next level of Cisco\'s business growth, by transforming commerce capabilities ordering, configuration, pricing, etc.. It will accelerate Cisco’s ability to provide its customers and partners with a world-class configuration, pricing and user experience for all of Cisco\'s offerings.
Synergy Program includes Oracle Applications Upgrade to Release 11.5.9, Retirement of the CIBER Environment.

Responsibilities:

• Maintaining of regression suites.
• Involved in Functional and Regression testing for modules like Service Request Management.
• Used Quality Centre for Test Execution, Bug Identification, Tracking and Reporting.
• Updating the onsite team of the task status regarding the project.
• Creation of Traceability Matrix.
• Imparted training to new team mates
• Involved in daily stand meetings, project related call and team related calls.

Confidential, Role : Associate Engineer
Duration : Nov’06 – Jun’07

Responsibilities:

• Developing web pages for different applications using Java script and HTML
• Development of applications using Java servlets.
• Creation of Unit and Functional test cases.

Education

Bachelor of Technology in Computer Science