Project Quality

Metilda Julie

Cell - 202-***-****

*********@*****.***

Summary

. Around 7 years of experience in Data Warehousing Testing and

Development.

. Proficient as Quality Analyst Test Lead in analyzing Business

Specification Documents, developing Test Estimation/Budgeting, Test

Plans, defining Test Cases and maintaining Requirement Traceability

Matrix.

. Proficient as Developer in ETL Tools like DataStage and Ardentia

HealthWare Manager.

. Exposure to Finance, Healthcare and Insurance industries.

. Experienced in Testing with Databases like Teradata, Oracle, Microsoft

SQL Server 2005 which includes development and review of complex SQL

queries and Bteq scripts.

. Good experience in Reporting tools like Hyperion Tools - Interactive

Reporting Studio, Dashboard Studio, Web Analysis Studio and Ardentia

Cassius Reporting Tool.

. Good orientation to SDLC and STLC processes and methodologies.

. Proficiency at grasping new technical concepts quickly and utilizing

in a productive manner.

. Excellent Communication, Presentation Skills with strong problem

solving skills and a result oriented attitude and ability to learn

business and technology quickly.

. Good leadership skills always helped me in disciplined and time

managed work.

Technical Skills

ETL Tools DataStage 8.0.1, 8.1, Ardentia HealthWare Manager,

Informatica Power Center

Reporting Tools Hyperion - Interactive Reporting, Dashboard Studio, Web

Analysis and Ardentia Cassius Reporting

Databases Teradata, Microsoft SQL Server 2005, Oracle, Essbase

Test Management Test tools: Quality Centre, Platinum, Beyond Compare

Tools and Utilities: Teradata SQL Assistant, SQL Server Management

Utilities Studio, BTEQ Scripts, Excel Addins like Smart view,

Essbase, Query Builder

Languages SQL, C

Scripting Java Script

Languages

Operating Systems Windows XP/Vista/7, Unix

Version Control Compass, Visual Source Safe (VSS), Tortoise SVN

Systems

Defect Tracking QuickBase, Rendezvous, Quality Centre

Tool

Middleware TIBCO

Employment History

Cognizant Technology Solutions

American Express Jan

2014 to Present

Quality Analyst Onsite Lead

Project: Consumer Travel Technology - OFFLINE

The American Express Consumer Travel Network-USA provides travel, financial

and Card member services to consumers through American Express-owned travel

service offices, call centers, participating American Express

Representatives (independently-owned travel agency locations that operate

under the American Express brand) and the Consumer Travel Web site.

Agents provide ticketing, payments and booking services to customers

through offline/desktop applications like Saturn, SmartREZ and Foundation.

This project is about decommissioning the offline applications and

replacing it with Web applications.

Responsibilities

. Leads the team of 5 resources. Prioritizes work assignments for the team

and manages their deliverables. Reviews analysts' test cases to ensure

appropriate coverage, identifies and remedies gaps in test coverage.

. Design, develop, and execute test cases using test plans and functional

specifications.

. Participate in all phases of the test cycle, including Integration/System

Testing, Performance Testing, Regression Testing, User Acceptance

Testing, etc.

. Provides leadership to develop test plans from design and requirements

documents, consolidates scenarios, test cases and other input contributed

by other team members.

. Participate in software requirement, specification, and design reviews.

. Develops test scenarios using manual and/or automated testing tools such

as Quality Center and Quick Test Professional.

. Manage testing schedule and communicate testing progress.

. Perform deliverables tracking and reporting as assigned.

. Monitors progress of testing efforts within the team to ensure deadlines

are met.

. Provide technical guidance to QA team on how to test complicated

features.

Technologies: SQL Server Database, Platinum, Beyond Compare, Quality

Center, Quick Test Professional

Cognizant Technology Solutions

AAA Insurance Aug

2013 to Dec 2013

Quality Analyst Onsite Lead

Project: Membership Inbound

The NCNU Club will provide Member and other related details to IE in

accordance with the mutually agreed upon Membership data contact. IE, in

turn, will use this data to support key business processes including:

Master Data Management (CMNG), Marketing, Operations and Analytics /

Reporting.

The NCNU Club has a phased approach for the implementation of the new

Membership system. IE will align with NCNU's plan. The Membership data

exchange will be provided via two daily feeds from the NCNU Club to address

IE's four different streams: Operational Activity, Reporting, CMNG, Partner

Club.

Responsibilities

. Led the team with size of 3 resources. Served as the single point of

contact and liaison between offshore testing teams, project development

team, the Quality Assurance and Business Teams.

. Established work plans and resource allocation for the testing effort for

every testing stage of the project ensuring delivery of all projects

within established SLAs.

. Participated in reviews of functional and technical design

specifications, prepared by the Project team to understand the

requirements and validate the flow of the application.

. Prepare Test plan which includes details regarding objectives,

strategy/approach, scope, assumption, risks, entry and exit criteria and

defect management.

. Provide daily Test Summary reports and conduct meetings with the Business

Team to review testing defects.

. Improved testing processes to ensure greater efficiency and quality of

projects.

. Participation in review of Test execution and created Test schedule for

system testing. Responsible for defect tracking.

. Responding to immediate production issues, investigating fixes needed

with developers and business and create test cases to test the changes

made for immediate deployment in production.

. Supported Testing in varying software development life cycle (SDLC)

models ranging from Agile (component focused), Waterfall, V model,

process based, methods.

Technologies: Oracle, Platinum, Beyond Compare, Quality Center

Cognizant Technology Solutions

AAA Insurance Jul 2012 to

Dec 2013

Quality Analyst Onsite Lead

Project: Marketing Analytics Data Warehouse

AAA Insurance Exchange Direct Sales & Marketing has chosen to work with an

outside vendor, Merkle, to help build a marketing data warehouse, an

automated campaign management system, and an analytics & reporting tool. IE

Marketing Analytics has been working with Merkle to provide sample data

feeds for Merkle to work within their Discovery. As in Release 1, AAA

Marketing Analytics will provide the data feeds to Merkle again for Release

2 so that Merkle can test for consistency and begin their build process.

Meanwhile, AAA IT will be building the ETLs that essentially will be the

pipes that automatically send these data feeds to the Marketing Analytics

data warehouse that Merkle is building for us.

Responsibilities

. Led the team with size of 10 resources. As an Onsite Test Lead, my

responsibilities includes analyzing and reviewing business and system

requirements, to create Test Estimation, Test Strategy & Plan

incorporating all inputs from all the technical and business users.

. Maintain the QA environment to test and coordinate UAT with business

users.

. Scheduling weekly status, test scenario walkthroughs and meetings with

the Developers, Business Users & QA Team and developing testing metrics.

. Documenting and tracking defects in Quality Analyst.

. Scheduling Defect Triage call twice a week and follow up with Development

team to get the critical defects fixed and deployed for Testing.

. Includes Reviewing Test Cases, RTM and clarify the issues and concerns

raised by Offshore team.

. Participating in all phases of the project, from review of requirements

and design to final system testing, deployment and maintenance.

. Mentor Offshore testers and business unit personnel on general testing

and documentation practices.

. Working with development team, managers, and other QA members to better

the QA process.

Technologies: Oracle, SQL Server 2005, Platinum, Beyond Compare, Quality

Center

Cognizant Technology Solutions

The Prudential Insurance Company of America May 2011 to

Jun 2012

Quality Analyst Onsite Lead

Project: Pru-AIT-AIF Phase 2A, 3A, 4A

The Prudential Insurance Company of America is one of the largest life

insurance companies in the U.S. The company offers a variety of products

and services, including life insurance, mutual funds, annuities, pension

and retirement-related services and administration, asset management,

banking and trust services, real estate brokerage franchises, and

relocation services.

AMP or Actuarial Modernization Program consists of a series of initiatives

to improve Prudential Annuities Actuarial business and supporting technical

organizations' ability to meet current and future demands.

Information Management and Business Intelligence will address the need to

improve actuarial data quality, reduce manual intervention, operate and

report actuarial data from collected data environment(s).

Technologies: Oracle, Quality Center

Responsibilities

. Led the team with size of 4 resources. Coordinated with project team and

involved in Analysis of Requirements, High Level Design and Mapping

document.

. Used detailed knowledge of business and created Test Strategy and Plan,

Schedules, Test Cases and Test Scenarios.

. Provided Knowledge Transfer sessions to client and offshore team members

on technology.

. Involved in Test Plan, Test Cases/Scenarios and Test Results Reviews and

Walkthroughs.

. As an Onsite coordinator, my responsibility includes Reviewing Test

Cases, RTM and clarify the issues and concerns raised by offshore team.

. Performed peer review on modules and documents created by team members.

. Providing accurate Testing status by creating Status report and sharing

the same with Clients every day.

Cognizant Technology Solutions

Aetna Global Benefits (HealthCare)

Jun 2010 to Apr 2011

Quality Analyst Offshore Lead

Project: NHS Ardentia ART

NHS Ardentia ART is a tool used by Healthcare people like Doctors, Nurses,

Surgeons, etc to analyze the Primary and Secondary Care Patients details.

It is a Web Based tool. This project deals with data loading of different

formats of source file into Ardentia Data Warehouse. Ardentia HealthWare

Manager ETL tool is used for loading source files. The data loaded are

separated into different modules like AAE, APC and OPA. Then the data are

summarized and loaded into SSAS cube. Finally, the customers view the

primary and secondary care details in the form of OLAP and Relational

reports created in Ardentia Cassius reporting tool.

Responsibilities

. Involved in Analysis of Requirements, High Level Design and Mapping

document.

. Communicated with Client in knowing the functionality of the system when

there are changes in the requirements and reporting the project status.

. Performed as a QA lead role in managing testing activities.

. Provided Knowledge Transfer sessions to client and offshore team members

on technology.

. Participated in preparing High Level Test Plan and Test Strategy

Document.

. Participated in writing, reviewing the test cases by understanding BSD,

TSD and mapping document.

. Prepared Test Data as per business requirements.

. Performed all kinds of testing such as Integration Testing, Functionality

Testing, Post Production Testing, Smoke Testing, Regression Testing etc.

. Executed test cases using SQL queries in SQL Server 2005 to validate the

Loading strategy, Transformation, Count Validation and Data Validation.

. Done testing on ETL data Loading, Cube and Reporting areas.

. Provided many value added documents like Best Practices on Ardentia Data

Warehouse Testing and other documents related to project.

Technologies: Ardentia HealthWare Manager, Ardentia Cassius Reporting Tool,

Sql Server 2005, Quickbase

Larsen & Toubro Infotech Ltd

Freescale Semiconductors, USA

Mar 2009 to Apr 2010

Developer

Project: CCT (Change Control Track)

The goal of CCT is to enhance and maintain already existing projects. A

ticket is entered in CTS (Control Track System) by Business Analysts and

assigned to the respective developer. The developer starts analyzing the

issue and fixes it according to the type of CCT (Enhancement or

Maintenance).

Responsibilities

. Understanding the CCT and preparing Requirement Analysis document.

. Preparation and Review of Design Specification, Test cases and ETL Jobs.

. Developed ETL Jobs, Bteq Scripts, complex sql's, Interactive Reports, Web

Analysis Reports.

. Done Quality related tasks like reviews, approvals, maintaining versions

of ETL jobs as well as documents in compass and Tortoise Sub Version.

. Involved in Unit Testing, IT-AT and UAT Testing. Preparing Implementation

Plan and implementing the jobs in production.

Technologies: DataStage 8.0, Teradata, Hyperion Technologies like

Interactive Reporting, Essbase administrative services, Web Analysis,

Excel Addins like Smart View, Bteq scripts

Larsen & Toubro Infotech Ltd

Freescale Semiconductors, USA

June 2008 - Mar 2009

Developer

Project: Procurement Spend & Savings Phase I & II

The goal of the project is to bring the entire procurement data in one

place (EDW), to replace the existing TSC (Total Spend Cube) in SAP BW, to

tie up Procurement Spend and Savings with the Finance View and to provide

standard reports as well as a suitable environment for Adhoc querying, to

automate & standardize spend and savings across manufacturing, finance, and

procurement, enhance data availability and to allow for timely & flexible

analysis into relevant SAP Procurement data.

Responsibilities

. Understanding Functional and Business requirements. Provides analysis,

design and technical programming expertise to develop ETL processes using

the Informatica.

. Involved in designing the framework for extract loads.

. Responsible for ETL design, development and testing

. Preparation and Review of Design Specification, Unit Test cases and ETL

Jobs.

. Responsible for Creating test plans, test cases and exaction of unit

testing

. Responsible for analyzing the source data, develop source to target

mapping documents, and create extracts from the source systems or source

files.

. Involved in developing Hyperion Interactive Reports, Web Analysis Reports

and Adhoc Reports.

. Preparation and Review of Design Specification, Test cases and build

documents.

. Involved in Quality related tasks like Work Process Audit.

. Issue Fixing and Enhancements.

. Done Unit Testing and system integration testing and also involved in IT-

AT and User Acceptance Testing. Implementing ETL Jobs, Reports, Database

Tables in Production.

Technologies: DataStage 8.0, Teradata, Hyperion Technologies like

Interactive Reporting, Essbase administrative services, Analysis

Integration Services, Web Analysis, Excel Addins like Smart View, Essbase,

Query Builder & Visual Explorer

Larsen & Toubro Infotech Ltd

Freescale Semiconductors, USA

Oct 2007 - June 2008

Developer

Project: Lot Master Phase I

Freescale Semi Conductors Inc wants to track the manufacturing process of

converting Wafer to Die. They want to track the quantity, rejects, amount

of finished goods manufactured, customers shipped to using the Active Data

Warehousing. To fulfill these requirements a real time active data ware

housing is built using TIBCO middle ware as source to store the messages,

DATASTAGE 8.0 as the ETL and TERADATA as the database to load the data.

Each activity is tracked as a transaction, each transaction generates an

XML which is published to the Tibco Queue and then the ETL reads the

message from the Queue process it (applies the Business logic transforms

the data) and loads into the Teradata.

Responsibilities

. Understanding Functional and Business requirements.

. Preparation and Review of Design Specification, ETL Jobs and Unit Test

cases.

. Involved in ETL Jobs development and enhancement.

. Posting messages through TIBCO tool.

. Involved in load scheduling and performance optimization.

. Jobs Migration to Production Environment.

. Issue Fixing and Enhancements.

. Done Unit and System Integration Testing on ETL Jobs.

Technologies: DataStage 8.0, Teradata, TIBCO

Contact this candidate