DIVYA SANTHOSH

E-mail : adhj3d@r.postjobfree.com

Mobile : 91-996*******

OBJECTIVE

Seeking technically challenging position in Software Testing, that provides a highly motivated and progressive environment. These allow the pursuit of career advancement and expand my knowledge and skills.

EXECUTIVE SUMMARY

A success-oriented software professional, having 9.5 Years of experience in ETL and Data warehouse Testing

Experienced in Data warehouse/ Database testing.

Proficient in ETL and Data warehouse Testing.

Having Hands on experience in testing applications following complete Software Development Life Cycle (SDLC) & Software Test Life Cycle (STLC) process.

Good experience in deriving test cases from System Requirement Specifications (SRS).

Proficient in creating Test Scenarios, Test Cases and Test Documentation.

Experienced in performing Smoke Testing, Sanity Testing, Ad hoc Testing, Regression Testing, Functional Testing, Integration Testing (ETL), System Testing and User Acceptance Testing.

Proficient in generating and managing Defect Tracking reports.

Experienced in defect tracking tools like Quality Center.

Experienced in Scenario Identification, Test Cases Preparation, Test Case Review, Test data preparation, Executing the Test Cases and Test Result Generation.

Strong ability to handle multiple priorities and to prioritize workload.

Strong analytical, problem solving & organizational abilities. Possess a positive, flexible & detail oriented attitude, strive to be my best.

Proficient in preparing Weekly Status Report (WSR).

EDUCATIONAL QUALIFICATION

Bachelor of Engineering (Electrical and Electronics)

AVIT, Chennai

TECHNICAL PROFICIENCY

Database :Teradata SQL Assistant

Data warehouse Tools : Datastage 7.5.3, 8.1, Datastage 9.1

Test Management Tool : HP Quality Center, Application Lifecycle Management

PROFESSIONAL EXPERIENCE

Senior Associate at Cognizant Technology Solutions, Chennai – Jan 2007 to June 2015

Software Engineering Team Lead at Accenture Services Pvt. Ltd. Since June 2015

MAJOR ASSIGNMENTS:

1.Novartis Global Xpend

Project Title

Novartis Global Xpend – Transparency (Aug 2015 – present)

Client

Novartis Pharmaceuticals

Location

Chennai, India

Database

Oracle

ETL / Scheduling Tool

Informatica

PROJECT DESCRIPTION:

Transparency is the system built to handle the new federal and existing state reports for money Spent by a pharmacy company on doctors either via educational visits (Prescriber/Hospital Calls) or Speaker Programs or Display & Exhibits etc. This effort was initiated by the anticipation of a new Federal law that will require all Pharmaceutical companies to report all Spend amounts they spent to educate physicians through a year.

ROLES AND RESPONSIBILITIES:

Have taken the role of Development Lead

Handled a team of 6 members

Involved in Daily / Weekly reporting, Preparation of WSR

Handled Change requests through Novartis Solution Manager (Novasol)

Responsible for quality deliverables from Offshore

2. Mortgage Reporting

Project Title

Mortgage Reporting (Apr 2014 – Jun 2015)

Client

JP Morgan & Chase

Location

Chennai, India

Database

Teradata

ETL / Scheduling Tool

Informatica / Control M

PROJECT DESCRIPTION:

JPMC’s Mortgage product sales and its various reports were generated and sent for Internal and external reporting as part of this project. Raw sales information flows from different source systems, which was extracted and loaded to Database through Informatica. The scheduling of ETL jobs happened through Control M.

ROLES AND RESPONSIBILITIES:

Requirement analysis: Understanding the Test Requirement documents

Individual role in handling multiple reports

Involved in Test case Preparation, Execution and reporting

Prepared Daily status Report, Weekly status Report, EOTR

Handling Stakeholders and provided required progress updates through Daily meetings

3.Data Stage Upgrade 9.1

Project Title

Data Stage Upgrade 9.1 (Nov 2012 – Mar 2014)

Client

Lloyds Banking Group

Location

Chennai, India

Database

Teradata

PROJECT DESCRIPTION:

This project aims to upgrade the current Datastage versions to the latest version of Info sphere Datastage (9.1) and deliver the capability to add capacity to the platform (as part of a BAU process) as business demand grows

Info sphere Datastage is the strategic ETL tool used within the bank for extracting, transforming & loading the data.

The Migration of data and behaviour of DS components on the latest Datastage version was tested in this project.

ROLES AND RESPONSIBILITIES:

Requirement analysis: Understanding the Functional Requirement documents

Produced Effort and Cost Estimates required for Study and DBT of the project

Handled 8 member project testing team

Prepared Master Test Plan, Detailed Test Plan, Test Approach document, Traceability matrix, Daily status Report, Weekly status Report, EOTR

Handling Stakeholders and provided required progress updates through Daily meetings

4.Mass Affluent TS1

Project Title

Mass Affluent TS1 (June 2012 - Oct 2012)

Client

LBG

Location

Chennai, India

Database

Teradata

PROJECT DESCRIPTION:

The Mass Affluent initiative delivered a set of service and product enhancements that realized a step change in the experience that is provided to Mass Affluent customers, driving both higher sales and improved retention rates. Customers will be segmented within core brands based on their asset maintenance and Monthly Income. A customer may belong to different segments in different brands for example, Mass Market, Mass Affluent and Affluent categories.

ROLES AND RESPONSIBILITIES:

Was playing the role of Functional Lead

Handled a team of 6 members

Involved in ETL Testing

Participated in Requirement Analysis

Responsible for Writing / Reviewing Test cases and get it approved with Business Analyst

5.UKRB - Business Performance Management – Activity Reporting

Project Title

UKRB - Business Performance Management (Nov 2010 – Nov 2011)

Client

LBG

Location

Chennai, India

Programming Languages, Tools

UNIX, Toad, Oracle 10g

PROJECT DESCRIPTION:

The objective of Business Performance Management Integration work stream is to provide sales performance reporting and remuneration for the LBG Sales representatives based on the products and transactions held within specific regions in UK. National Sales System Integration (NSSI) is the front end system where the performance threshold and scores will be calculated based on which Bonus and Remuneration will be reported.

ROLES AND RESPONSIBILITIES:

Was playing the role of Team Lead

Involved in Manual Testing

Participated in Requirement Analysis

Responsible for Writing / Reviewing Test cases

6.BPM - NSSI Upgrade

Project Title

UKRB - Business Performance Management (Mar 2010 – Oct 2010)

Client

LBG

Location

Chennai, India

Programming Languages, Tools

Oracle 9i, Toad, Oracle 10g

PROJECT DESCRIPTION:

National Sales System Integration (NSSI) is the front end system where the performance threshold and scores will be calculated based on which Bonus and Remuneration will be reported. This application was under the Oracle 9i platform and was upgraded to Oracle 10g as part of the project.

ROLES AND RESPONSIBILITIES:

Was playing the role of Team Lead

Involved in Manual Testing

Participated in Requirement Analysis

Responsible for Writing / Reviewing Test cases

7.Credit Card Simplification – Starlight

Project Title

Starlight (April 2008 – Oct 2010)

Client

LBG

Location

Chennai, India

Programming Languages, Tools

Data stage 7.5.3, Teradata, Mainframe

PROJECT DESCRIPTION:

The Credit Card management system provided for Lloyds by First Data International (FD), Equasion, must be replaced with a new Credit Card platform provided by FD called VisionPLUS. This migration entails a substantial program of work to integrate the new system with the existing LTSB applications, whilst allowing the bank to continue with its business as usual Credit Card operations. In parallel, a new target Business Operating Model for the Credit Card Business need to be developed to leverage the benefits of VisionPLUS.

ROLES AND RESPONSIBILITIES:

Was playing the role of Test Analyst

Involved in ETL Testing, DW testing

Participated in Requirement Analysis

Responsible for Writing / Peer Reviewing Test cases

Involved in test execution

Involved in test report documentation

8.Research Information Factory (RIF)

Project Title

Research Information Factory (Mar 2007 – Mar 2008)

Client

Pfizer Pharmaceutical Inc.

Location

Chennai, India

Programming Languages, Tools

Informatica, Toad(Oracle)

PROJECT DESCRIPTION:

The RIF’s data warehouse provides integrated drug compound, experiment, screen protocol data to research scientist globally. The RIF also integrates with the Global Information Factory (GIF), which serves as a primary data integration and distribution hub for PGRD. The architecture consists of 3 subject areas (Compound, Screen Protocol and Experiment) and 3 marts. System Testing and SIT done for the enhancements to RIF work stream that includes changes to the existing subject area and DW/Marts and addition of new subject areas

ROLES AND RESPONSIBILITIES:

Was playing the role of Test Analyst

Involved in ETL Testing, DW testing

Participated in Requirement Analysis

Responsible for Writing / Peer Reviewing Test cases

Involved in test execution

Involved in test report documentation

ACHIEVEMENTS:

Have won STAR award in the few projects

INTERNAL CERTIFICATIONS

Oracle 9i certified Professional

Teradata Certified Professional

Cognizant Certified Professional in DataWarehousing

PERSONAL DETAILS

Date of Birth : Nov 08, 1985

Gender : Female

Marital Status : Married

Languages known : Tamil & English

Address : No.4, Vijaya Avenue, Selvaraj Nagar, Annai Anjugam Nagar Post, Urapakkam West, 603211

Notice Period : 3 months

Contact this candidate