Phone : 949-***-****

Amritha Nair Email : acs3g0@r.postjobfree.com

Summary of Experience

Quality Assurance & Testing

More than 8 years of experience in IT industry. Around 6 years of experience in Software Quality Assurance, Analysis & Testing.

Very well versed in Software Testing Lifecycle and has experience across all phases of the STLC including Test Strategy, Test Planning and Estimation, Test Scenario and Test Case Design, Requirements Traceability matrix, Test Execution & Reporting

Experienced in Manual testing, Usability testing, White box/Backend testing, Black box testing, Verifying and Validation, Integration testing, System Testing, Regression Testing, User Acceptance Testing (UAT), Exploratory testing, Ad-hoc testing, Smoke Testing, Database Testing.

Expertise in Web service Testing, API testing and Database testing.

Strong knowledge of Software Testing life cycle (STLC), Software development life cycle (SDLC) and well-versed in Agile and Waterfall methodologies.

Experience in testing Web/Desktop applications, Mobile Application Testing, Migration testing.

Strong knowledge in SQL queries, PL/SQL, Oracle and RDBMS concepts.

Good Documentation and Process Management skills with an ability to effectively understand the business requirements to develop a quality product.

Application Development & Maintenance

2 years total IT experience in the area of analysis, design, development, testing and implementation of E-business application systems using Oracle Applications11i, Oracle ApplicationsR12, SQL and PL/SQL.

Behavioral Competencies

Excellent communication, analytical, problem-solving, management, inter-personal skills and a fast learner.

Technical Skills

Domain Knowledge

Health Insurance, Manufacturing(Procurement and Pay), Media and Entertainment, Insurance, Retail

Testing Tools

IBM Rational Tools, HP Quality Center, ReqPro,QTP,SOAP UI, SQL Developer, Availity, DB2 Data Studio, SQL Navigator,Soap UI.

Programming Languages

SQL, PL/SQL, C,UNIX Shell Scripting

Other Tools

MS Office tools, VISIO, XML.

Databases

Oracle 10g, SQL Server

Operating System

UNIX, Windows 9x/NT/2000/XP/Vista, Linux, DOS

Work Experience

1.

Duration : Jun’14 – Till Present

Client

Florida Blue

Role

Test Analyst

Organization

UST Global

Network Suit of Tools Implementation

Description: NST is contract creation and maintenance tool for PIMS (Provider Information Management System) which is industry known product of McKesson. This project is to create an automated platform to create contracts whenever there is addition/modification in the provider data.

Responsibilities:

Gathering the requirements. Responsible for analyzing business/project requirements, functional and technical specifications, and review that project requirements are clearly defined

Responsible for developing Test Strategies and Plans, creating test scenarios, test plans -designing test cases and executing the test cases.

Responsible for developing and maintaining test plan, creating reusable test cases, data analysis and creation of test data, conducting peer reviews and business reviews, perform manual execution of test scripts using Quality Center, analyze and thoroughly document defects detected during test execution. Test case designing, Data Mining, Test data preparation.

Document test cases in ALM and excel to ensure that all functionality is performing as intended Provide test case to requirements traceability

Mentoring other testing resources and assigning tasks to other team members

Coordinate with Business analysts and Project owners to define and execute End to end testing and User Acceptance testing.

Web service testing using SOAP UI (Soap and rest services).Testing of Mock Services.

Testing new data base designs using complex SQL queries and Procedures. Executing back-end data-driven test efforts.

Defects reporting, tracking and retesting through closure and release.

Troubleshoot unintended results and error logs to investigate cause of unintended results

End to end testing of newly created workflow.

Participating and supporting production deployment.

Environment:

HP QC, SOAP UI, Availity, SQL Navigator, DB2 Data Studio, Requisite Pro,XML.

2.

Duration : Sept’12 – Jan’14

Client

GE

Role

ERP Functional Testing Consultant

Organization

UST Global

R12 Reimplementation for SSS for Buy 2 Pay

Description:

SSS (Shared Sourcing Services) transforms all GE business into an E-Business covering all key components of the buy-to-pay business flow, processing and managing requisitions and receipts till payment. SSS mainly does indirect material procurement.

Buy 2 Pay is a single instance of Oracle ERP that supports Indirect Procurement for all GE businesses. It also supports multi-Org Oracle application instance where all major GE companies like GE Capital, GE Air Craft Engines, GE Medical Systems, GE Power Systems, GE NBC etc. carry out their purchasing activities using SSP (Self Service Purchasing) and core applications. It is 200+ operating units, multi-currency and multi-language environment. It also supports Direct Procurement and Accounts Payable for a few GE businesses. In addition to Buy 2 Pay core applications, many peripheral products are used by Buy 2 Pay Business Users. They include Right Fax, Sabrix, 170 Systems, Elance, EMIS, Datacert and others. Buy 2 Pay supports interfaces to businesses Accounts Payable systems as well as those that allow information transfer to support updates for system maintenance.

The goal at Buy 2 Pay is to become a complete Buy to Pay system for all GE Businesses worldwide.

GE wanted to move to the new Oracle supported platform of R12. UST team, engaged in design, build, run operations of SSS since 2009, is doing the Technical Re-implementation of SSS platform.

The purpose of this version upgrade is to eliminate the risk of exposing the business critical application to unsupported versions of Oracle EBS. As part of this initiative, GE proposes to use the existing R12 instance.

As a Functional Testing Consultant, involved in the following activities

Responsibilities:

Involved in the requirement analysis.

Analyze and Review the Business and technical Requirements.

Preparation of test scenarios from the functional specifications and preparing the test plan for the object developed.

Develop and maintain test cases.

Plan and schedule all QA deliverables during project lifecycle

Conduct formal test case review sessions with project team and incorporate feedback

Validate the application and document actual results, and evaluate compared to expected results, replicate the defects so that any errors can be identified.

Perform test execution, defect detection and test result reporting.

Develop SQL queries to retrieve data for validation purposes

Report defects and escalate issues as needed

Regular reporting of overall project status, including test case execution statistics, defect status, milestone achievement, and satisfaction of quality metrics.

Performed Mobile application testing in Blackberry and Android devices.

Tools used:

Mercury ITG Package (Kintana), SQL Developer, Quality Centre

3.

Duration : Jan’12 – April‘12

Client

Allianz Cornhill Information Services (ACIS)

Role

Test Analyst

Organization

UST Global

R2 Fusion Project.

Description:

Allianz Insurance include motor, home, music, small animal policies.TIA is the software used to support this. Currently the different insurance like music, motor etc. are in different databases and the project aims in the integration of all these in to one system using TIA.

Responsibilities:

Attended the requirement meeting.

Participated in estimation analysis.

Responsible for designing and developing test strategy.

Responsible for test case preparation, execution and validation.

Environment:

Quest Toad, Quality Centre.

4.

Duration : Sep’11 – Dec‘11

Client

Warner Bros

Role

Test Data Analyst

Organization

UST Global

WBEI’s iCampaign project

Description:

Warner Bros. Entertainment – a fully integrated, broad-based entertainment company – is a global leader in the creation, production, distribution, licensing and marketing of all forms of creative content and their related businesses, across all current and emerging media and platforms

There are two systems to store the data for WBEI- EIS3& ICampaign.

The EIS3 stores the international release schedule. These systems store information about the title, synopsis, genres, talent as well as competitor information.

The ICampaign inbound interface receives title information, release schedule and territory information through EIS3 and will store it on fields present on Feature Title and Campaign in iCampaign.

The interface will automate transmission of Title information from EIS 3 to iCampaign by validating MPM# in iCampaign. The transaction from EIS 3 will be once a day job. This automated interface process will decrease the manual effort, allowing for shorter processing time, increasing reliability in the transaction data while providing a stronger audit trail.

The interface between EIS and the iCampaign system ultimately provides an XML file, to transfer data from EIS to iCampaign as specified and provided by WBEI.

Views were made to get the desired fields and procedures were written to invoke the views and to get the result as the desired XML format.

Responsibilities:

Analyze the Business Requirements Document (BRD) and prepare the Business technical Requirement.

Test case preparation and test data analysis.

Test data preparation for SIT. Test cycles execution, Result verification and Issue analysis.

Environment:

SQL*PLUS, Manual testing using SQL queries and spread sheet validation/reporting.

5.

Duration : May’08 – April‘11

Client

GE

Role

Techno Functional Consultant / QA Consultant

Organization

UST Global

Oracle ERP Systems – SSS PO Development Support

Description:

SSS (Shared Sourcing Services) Buy 2 Pay transforms all GE business into an E-Business covering all key components of the buy-to-pay business flow, processing and managing requisitions and receipts till payment. SSS mainly does indirect material procurement.

SSS Buy 2 Pay is an Oracle ERP platform that supports Indirect Procurement for all GE businesses. It includes iProcurement, Purchasing, Payables, iSupplierPortal, Cash Management, and other Oracle support modules. It also supports multi-Org Oracle application instance where all major GE companies like GE Capital, GE Air Craft Engines, GE Medical Systems, GE Power Systems, GE NBC etc carry out their purchasing activities using SSP (Self Service Purchasing) and core applications. It is 200+ operating units, multi-currency and multi-language environment. The goal at Buy 2 Pay is to become a complete Buy to Pay system for all GE Businesses worldwide.

iProcurement is part of Oracle Applications ERP, an integrated suite of E-Business solutions designed to transform GE business into an E-Business. It is the starting point for the ordering process and provides powerful self-service requisitioning capability with an intuitive web shopping interface. It processes and manages requisitions and receipt of the requested goods/services in an efficient and automated manner.

Responsibilities:

Design. Development and testing.

Extensively worked on workflows and interfaces, mainly developing of the codes- the procedures and functions in PL/SQL and testing of these in working environment.

Created SR against Oracle and had a good exposure of working with Oracle and solving the

issue.

Creation of DFF as per business requirement to handle additional storage of data depends on

Business.

Retrofitting of RICE components as a part of RUP applying in our Custom instances.

Creation of Concurrent Programs and attaching value set to the defined concurrent programs as

A part of business requirement.

Testing for the End to End Functional Testing

Environment:

Oracle Sql*Plus, SQL Developer, Workflow Builder, Kintana, PVCS, Quality Centre,Oracle EBS Application

6.

Duration : Feb’07 – Apr‘08

Client

Wellpoint Inc

Role

Developer/Tester(End to End)

Organization

UST Global

Project

PHARMACY BENEFIT MANAGEMENT (PBMCOI) CONSOLIDATION AND INTEGRATION

Client

Wellpoint Inc

Period

Feb 2007 till April 2008

Description

WellPoint is the second largest Health Care Company in USA, with 15.5 million members across California, Georgia, Missouri, and Wisconsin.

The project was about applications required to handle the various healthcare applications like claims processing, mini adjudication, prior authorization etc.

Being a web based application used by call center representatives and was interwoven into different technology streams like Java, .Net and Oracle SQL. The front end was a java application, the middle layer was .Net applications and the back end was Oracle database.

Being in the Oracle SQL track of this project which is responsible for the transfer of data from database to a Service Business Interface (which was a .Net track). The Stored Procedures were developed for all the functionalities like Eligibility, Claims, Provider, Product Coverage etc., in Oracle and SQL Server databases. The Stored Procedures used to transfer required data and logging is implemented in all the functionalities to capture all the errors and exceptions during the execution.

Role

Database Developer

Solution Environment

PL/SQL, SQL

Work Location(s)

Trivandrum, India

Responsibilities

Develop Database Objects for the business requirements.

Database Object maintenance and movement across environments.

Perform data corrections to resolve data quality issues in production.

PHARMACY BENEFIT MANAGEMENT (PBMCOI) CONSOLIDATION AND INTEGRATION

Description:

PBMCOI is an integration project to integrate data’s in two different databases. The details of Eligibility, Claims and benefits are available in these databases. This is a web based application and used by call center representatives.

The project was about applications required to handle the various healthcare applications like claims processing, mini adjudication, prior authorization etc. The project was interwoven into different technology streams like Java, .Net and Oracle SQL and had to access different databases of 2 major healthcare clients. The project was a kind of integration of the operations of these customers. The front end was a java application, the middle layer was .Net applications and the back end was Oracle database.

Being in the Oracle SQL track of this project which is responsible for the transfer of data from database to a Service Business Interface (which was a .Net track). The Stored Procedures were developed for all the functionalities like Eligibility, Claims, Provider, Product Coverage etc., in Oracle and SQL Server databases. The Stored Procedures used to transfer required data and logging is implemented in all the functionalities to capture all the errors and exceptions during the execution.

Responsibilities:

Was involved in the development of the Oracle packages, functions and procedures using Oracle application which used to transfer data from the database to the middle .Net layer

Involved in requirement gathering

Co-ordination with the onsite team members for requirement clarifications.

Analysis and Designing of various functions, Procedures and packages.

Coding of various Components to retrieve data from the backend.

Unit, Integration, Regression and System testing of various components.

Issue Resolution, which includes managing the issues that come up during the course of the project and getting it resolved in time with the help of the client.

In the role of the Defect Prevention Controller of the project, helped in monitoring the defects to the permitted level of the project.

Quality assurance of the deliverables.

Mentoring new entrants in the project.

Education

Degree

University

Year of Passing

B.Tech

SCT College of Engineering, Trivandrum, Kerala University, India

2006

Certifications

1.DB2 UDB Family Fundamentals.

2.OCA certified.

Contact this candidate