Project Data

Saira Ittiachen

Cell – 267-***-****

Email – *****.*********@*****.***

EXPERIENCE SUMMARY

Experienced ETL and functional test lead with diverse industry experience in Healthcare, Marketing and Banking Industry. Overall 12 years of experience including project estimation, requirement Analysis, test strategy preparation, test design, and business scenario preparation for data analysis, test execution, defect management and support in all phases of data warehouse and functional testing lifecycle.

CAREER KNOWLEDGE

Strong knowledge of Software Development Life Cycle (SDLC - Requirements Analysis,

Design, Testing, Implementation, Support).

Experienced in Waterfall and Agile Scrum methodologies

Knowledgeable in creating Features using Cucumber for test scenarios identified for automation

Knowledgeable in creating step definition file in Cucumber

Run automated test scenarios using Selenium framework

Experienced in IVR automation testing using Cyara

Extensive knowledge in test Genesys Call Routing Solution, call handling, KVP vaidation

Extensive experience in ETL/ Data warehouse backend testing and functional testing.

Expert knowledge in creating Test Plans, Test Cases, Test Scenarios and Test Strategies,

Defect Management to ensure Quality Assurance and to test all the business requirements

Experience in preparing test reports from Quality Center and prepare daily test status

reports to communicate the test status with the team.

Extensive testing ETL experience using Informatica (Power Center)

(Designer, Workflow Manager, Workflow Monitor).

Excellent Knowledge of Database Systems – Oracle 12c, Oracle 11g, SQL server and Data

Warehouse concepts.

Extensive experience in developing SQL scripts to validate the databases tables and

reports data for backend database testing.

Experience in Business Intelligence testing in various reports using Business Objects

A very good team player with excellent Communication (Verbal and Technical)

TECHNICAL QUALIFICATION

ETL Tools- Informatica

Automation tools – Selenium, Cyara

Applications – Siebel CRM IP 15, OSB, Genesys IVR

Database- Oracle, SQL Server, DB2

Test Management Tool- HP Quality Center

Database Interface Tools- SQL Developer, Toad, AQT

Database Languages/ Programming Languages- SQL, PL/SQL, COBOL, C, C++

PROJECT EXPERIENCE

Project Title - Catalyst 360/ Optum

Duration- Feb 2015 - Till date

Location- Horsham, PA, USA

Role - DWH/ETL, Functional Test Lead(Siebel CRM, IVR, Genesys Call routing, SOA)

Technology and Tools - Informatica, Oracle, SQL Server,SOA OSB, IVR

Company – Cognizant Technology Solutions

PROJECT DESCRIPTION

As a strategic client partner, Cognizant is responsible for test planning & execution of functional and data warehousing testing of Optum’s enterprise applications including Siebel CRM, NICE, SOA, IVR and Warehouse data.

CLIENT DESCRIPTION:

Optum manages Membership enrollment, renewal and maintenance of the AARP plans for United Health Group . Its information services include database management (including electronic health records, or EHRs), analytics, and a variety of consulting services to health care providers, insurance firms, government agencies, and life science researchers.

ROLES AND RESPONSIBILITIES:

Manage end to end testing work for the DataWarehouse functionality and lead the project team of 6 offshore resources to assign module/activity/tasks/deliverables

• Administrate project review, escalations, quality assurance, task completion, project

deliverables, customer interface & project status reporting for the project

• Provide technical know-how, support, coach team members on business & other project specific aspects

• Analyze and understand testing requirements from business requirement document, technical

requirement specs

• Analyze and review Informatica (ETL) mappings to understand the technical implementation of

business rules

• Design and document Data warehouse testing strategy covering the test cases for

validating the data completeness and correctness, system performances of the ETL processes etc.

• Prepare test plan and work breakdown estimate

• Prepare the test cases for Summary/Detail testing, functional testing, regression testing,

performance testing and End to End testing

• Construct test queries with multiple joins, analytical functions, and sub queries linking by unions, intersection, and minus operators etc.

• Schedule and monitor the test cases execution

• Scheduling triage meetings to keep track and level of severity defects and communicating it

to Project Managers with Execution Score Card with defect status

• Involved in testing the IVR Inbound and Outbound call flows

• Log and publish the test results and raise the defects to HP Quality Center

PROJECT EXPERIENCE

Project Title – AllLink Transact Applications

Duration- March 2011 – Feb 2015

Location- Lanhorne, PA, USA

Role - DB Test Lead

Technology and Tools – Oracle, PL/SQL

Company – Harte Hanks Data Technologies

PROJECT DESCRIPTION:

As a Quality Analyst at Harte-Hanks, was responsible for test planning & execution of the multichannel marketing requirements for their clients in the Healthcare, pharmaceutical industry.

ROLES AND RESPONSIBILITIES:

Design test scenarios and test cases for newly developed marketing strategies for the clients.

Log and track defects in HP Quality Center and report the findings to the development team.

Conduct functional testing to verify that the functionality matched with the Change Request specifications.

Participate in team meetings, discussions for new on-boarding clients.

Review requirements and suggest changes to improve quality of the process.

Create and document SQL scripts for use in testing of frequently tested processes. Testing of newly developed web applications and changes to the existing applications. Testing the data loaded from the front end screens are correctly loaded to the appropriate tables in the database.

Validating COGNOS reports to ensure that the data in the report is in line with the data in the database.

PROJECT EXPERIENCE

Project Title – JP Morgan Chase

Duration- Nov 2009 – Aug 2010

Location- Lowell, MA, USA

Role - DB Test Analyst

Technology and Tools – Mainframe, COBOL

Company – Tata Consultancy Services

PROJECT DESCRIPTION:

As a strategic client partner, Tata Consultancy Services, was responsible for test planning & execution of JP Morgan’s reporting tool that was used to generate reports to analyze current trends, forecasting etc.

CLIENT DESCRIPTION:

JPMorgan Chase & Co. is a leading global financial services firm and one of the largest banking institutions in the United States, with operations worldwide. Chase Bank provides credit cards, mortgages, commercial banking, auto loans, investing & retirement planning, checking and business banking.

ROLES AND RESPONSIBILITIES:

Primary work was done in Banking domain testing the client reports on intra-day, end-of-day, weekly and period transactions.

Developed testing scripts that address areas such as functional and regression testing, database impacts, bug retests and software scenarios

Ensured the data correctness and program functionality by executing test cases in HP Quality Center.

Logged and tracked software defects in HP Quality Center and reported the findings to the development team.

Reviewed software documentation to ensure technical accuracy, completeness, compliance and to mitigate risks.

Supported the onsite team in production verification test (PVT) during code deployment into the production environment.

Identified areas in the application that could be automated which reduced the project cost and testing effort.

PROJECT DESCRIPTION:

The project was aimed at migrating the data of two banks after a merger into the database of ABN Amro.The other banks had different processes and layouts compared to that being used in ABN AMRO. Programs were written/modified to accommodate the data/files from these banks.

ROLES AND RESPONSIBILITIES:

Participate in product design reviews to provide input on functional requirements, schedules or potential problems.

Plan test schedules or strategies in accordance with project scope and delivery dates. Design functional test cases from the requirement documents from the clients. Identify areas/applications that needed functional and regression testing.

Conduct smoke testing before the start of the testing cycles.

Execute test cases to ensure the correctness of the data mapping done and the functionality.

Log and tracked defects to closure by coordinating with the development team.

Also conduct sanity and regression tests during bug retests. Receive the best team award of the outstanding results and team effort

PROJECT EXPERIENCE

Project Title – SD Worx

Duration- Nov 2007 – Jan 2009

Location- Cochin, India

Role - DB Test Analyst

Technology and Tools – Mainframe, COBOL, Enterprise Architect, TSO, FIleAid, Expeditor, QMF(Query management Facility), FileAid for DB2,SPUFI, JCL

Company – Tata Consultancy Services

PROJECT DESCRIPTION:

The project was to develop a mainframe application that would enable SD Worx to do tax calculation for its clients.

CLIENT DESCRIPTION

SD Worx offers full service in Payroll, HR and Tax & Legal in Europe, the US and Canada. More than 60,000 large and small organizations rely on SD Worx and its 2,700 employees. During the company’s 70 year history they have acquired an extraordinary amount of expertise in Payroll, HR and Tax & Legal matters. They provide clients with a wide range of services including payroll and HR, legal support, training, automation, consulting and outsourcing.

ROLES AND RESPONSIBILITIES:

Designed and executed functionality, usability, database, connectivity and interface test cases for test web applications.

Tested complex applications like tax term calculation and tax deduction.

Performed initial debugging procedure by reviewing code pieces to determine breakdown source.

Provided feedback and recommendations to the development team on software usability and functionality.

EDUCATION AND PROFESSIONAL CERTIFICATIONS

Bachelor’s Degree in Computer Science and Engineering from the Rajagiri School of Engineering and Technology, Kakkanad, India – 2003-2007

ISTQB Foundation level Certification - International Software Testing Qualifications Board Certification - 2010

IBM Certified Database Associate - DB2 Universal Database (DB2 UDB) V8.1 Family Test 700 (Version: 1.0)-2009

IBM Certified Database Associate - DB2 Universal Database (DB2 UDB) V9.1 Family Test 730 - 2008

Contact this candidate