Data Test

Ashwini Mallipedi

Email: *********@*****.***

Mobile: 678-***-*****13

Experience Summary

8.10 years of experience in ETL Testing

Responsible for ETL Testing, OBIEE Reports and RPD Testing as part of BI Testing.

Automation Script Design, Test Development/Scripting, Review of Test Scripts, Test Script Execution, Test Script Maintenance, Defect reporting, Review of Test Artifacts as part of Automation Testing.

Expertise in DB testing and constructing complex SQL queries. Working on DWH ETL(Informatica) Testing and OBIEE Report Testing and RPD testing

Experience in Test Management Tools like ALM, JIRA

Good Experience in ERP Application like Oracle Apps.

Prepared SQL Scripts and validated data loaded into the data warehouse.

Strong experience in Defect linking, Requirements mapping and Preparation of Test bed in the Quality Center.

Experienced in Automation testing using QTP tool.

Testing Oracle BI Interactive Dashboards,Prompts,Oracle BI Answers, Reports and RPD as part of OBIEE Report testing.

Automation Script Design, Test Development/Scripting, Review of Test Scripts, Test Script Execution, Test Script Maintenance, Defect reporting, Review of Test Artifacts.

Risk Identification and Management, Effectively raising red flags, issues and concerns.

Track Suite execution results and send the results in Daily status Report

Sending weekly status reports and metrics

Coordinating with the development team/onsite leads to get the clarifications on the requirement.

Participated in defect triage meetings, proactively tracked the defects for early closure.

Understand the priorities correctly and make sure that the tasks are completed accordingly.

Performed the Integration Testing, as part of integration testing validated the table’s data at the various layers of DWH for both incremental load and full load.

As part of full load validated the complete table data for a particular time interval between Source and staging and staging and Target.

Ensure client confidence by thoroughly understanding the customer needs and find appropriate solutions to the problems.

Good interpersonal skills, commitment, result oriented, hard working with a quest and zeal to learn new technologies and undertake challenging tasks.

Experience Details

Worked with Oracle India Private Ltd as Senior Automation Engineer from Apr 2018 to Apr2019.

Worked with Liquid Hub as Senior Software Engineer from Dec 2016 to Apr 2018.

Worked with CSC (Computer Sciences Corporation) as Professional 1-Software Engineer from June 2010 to Dec 2016.

Academic Profile

B. Tech from Vardhaman College of Engineering and Technology (2005-2009), JNT University, Hyderabad, AP.

Technical Skills

Operating Systems Windows, R2, Linux

Web Technologies HTML 5, CSS 3, JavaScript, Rails

Database SQL Server, SQL Developer, Toad with Oracle, MYSQL

Management Tool QC 10.0, Version One

Functional Test Tools UFT

Project #1

Project : Oracle Utilities Analytics (OUA) Product

Type : ETL Testing

Environment : ODI, UNIX,SQL, OBIEE, Oracle Golden Gate

Client :Oracle Utilities Analytics(Oracle)

Duration : Apr 2018 – Apr2019

Project Description

Oracle Utilities Analytics (OUA) provides prebuilt dashboards, schemas and helps to extract,

Transform, Load and analyze data generated in Oracle Utilities applications like Customer Care and

Billing, Network Management System, Meter Data Management, Work and Asset Management and

Mobile Workforce Management. It is built on Oracle Business Intelligence Enterprise Edition (OBIEE)

platform with integrated spatial features and supports end to end analytical workflow including the ability

to drill down to the source applications. OUA extractors and schemas are built on Oracle Data Integrator

12c (ODI) and Oracle Golden Gate (OGG) tools.

Roles and Responsibilities:

Worked as a Quality Assurance for Analytics Products of Utility Industry.

Involved in setting up of processes, creating test plan, QA Strategy, test scope, test design and execution plan, estimating the time lines of QA for releases, focus on Automation for each release.

Technologies used – ODI as ETL tools, OBIEE for analytics, Open Script for QA Automation, Oracle 12c as database, Oracle Golden Gate.

Collecting test scenarios and use cases.

Designing, Reviewing and executing test cases.

Creating test data for various scenarios from source applications.

Logging/tracking/testing the defects/bugs.

Applying Builds on Test Environments and performing End-to-end sanity of every build.

Develop/Improve automations to increase test automation scope and speedup processes.

Support the Issues reported by product customers.

Suggest improvements required in the product to enhance performance.

Experienced in ETL testing, manual and Automated.

Well-versed in ETL process flows & standards and good knowledge of Data-ware house models like Star schema and Snow Flake schemas.

In-depth knowledge of writing medium and complex SQL queries using Joins and to use them to test data in Data Warehouse schemas.

Good understanding of Software testing life cycle activities from start to closure of a Product release.

Experienced in the test process including writing Test plans, Test Case preparation, Test Execution and Bug/Defect tracking.

Experience in understanding the Product requirements and deriving quality Test scenarios/Conditions based on the requirements.

Experience of performing Accessibility testing for products using various tools.

Experience of working in Agile methodology and actively participating in Sprint Planning/Review meetings, at times leading them.

Complete End-to-End knowledge of Product, from creating data at Source and the flow of the data to be displayed on the Reporting tool.

Project #2

Project : Alkermes Specialty Data Management Solution

Type : ETL Testing

Environment : Informatica 9.5, UNIX and SQL

Client : Alkermes, US

Duration : Dec 2016 – Apr 2018

Project Description

Alkermes launched a new product for MS patients. As part of the launch BIIB will utilize a closed distribution network for this product and would like to collect data from specialty pharmacies (SPP) in the network.

The goal of this integration is collect script level transaction information to measure performance of specialty pharmacy program for distribution and additional services and measure performance of reimbursement services hub to assist patients in accessing therapies.

Roles and Responsibilities

My responsibilities include in all stages of the project Testing.

Prepared data validation scripts and validated data loaded into Source Systems to the Target System.

Performed the Integration Testing, as part of integration testing validated the table’s data at various levels .

Preparing Test Evidence sheet.

Created defects for bugs identified in the Integration Testing.

Coordinating with the development team to get the clarifications on the requirement

from onsite and Conducting Weekly calls with client and Updating the Status of Testing and Data Validation to the client.

Participated in defect triage meetings, proactively tracked the defects for early Closure.

Project #3

Project : McDonald’s

Type : ETL Testing and Automation Testing

Environment : HPQC, Informatica, OBIEE, SQL Developer/TOAD,QTP

Client : McDonald’s Corporation, US

Duration : Feb 2013 – Dec 2016

Project Description

McDonald's Corporation (NYSE: MCD) is the world's largest chain of hamburger fast food restaurants, serving around 68 million customers daily in 119 countries. Headquartered in the United States, the company began in 1940 as a barbecue restaurant operated by Richard and Maurice McDonald; in 1948 they reorganized their business as a hamburger stand using production line principles. Businessman Ray Kroc joined the company as a franchise agent in 1955. He subsequently purchased the chain from the McDonald brothers and oversaw its worldwide growth.

Mc Donald’s Oracle E-Business Suite allowed a series of centralized operations for coordination of administrative operations achieved regional standardization of central applications and processes, such as for financial reports improved communication by using Oracle E-Business Suite, allowing shared information by all countries.

Roles and Responsibilities

Prepared data validation scripts and validated data loaded into the data warehouse.

Testing and Creating RPD and Report test cases for OBIEE Reports and RPD.

Identify and develop Automation Test Script for ERP Application

Performed Data Validation, OBIEE Report Testing and RPD for Break Fixes,Mini releases, Change Requests Fire fixes and Enhancements.

Automation Script Design, Test Development/Scripting, Review of Test Scripts, Test Script Execution, Test Script Maintenance, Defect reporting, Review of Test Artifacts.

Performed User Interface (UI) Testing, Functionality Testing, System Testing and Regression Testing as part of OBIEE Reports Testing.

Performed the Integration Testing, as part of integration testing validated the table’s data at the various layers of DWH for both incremental load and full load.

Testing Oracle BI Interactive Dashboards, Prompts,Oracle BI Answers,Reports and RPD as part of OBIEE Report testing.

Preparing Test Evidence sheet.

Created defects for bugs identified in the developed reports.

Participated in defect triage meetings, proactively tracked the defects for early Closure.

Coordinating with the development team to get the clarifications on the requirement

from onsite and Conducting Weekly calls with client and Updating the Status of Reports and Data Validation to the client.

Create or maintain object repositories and following best naming conventions for the objects identified.

Review scripts by considering coding standards and performance parameters.

Identify/Understand ERP application Automation needs/Automation feasibility study, Resolve technical problems with the automation tool

Defining Test Deliverables, Task Planning and Scheduling

Generating of Automation Test Execution Reports.

Project #4

Project : BCI(BECKMAN & COULTER Inc)

Type : ETL Testing

Environment : Informatica, OBIEE, SQL Developer/TOAD,QC and QTP.

Client : BECKMAN COULTER

Duration : Feb 2012-Jan 2013

Project Description

The customer offers one of the most comprehensive portfolios of laboratory instruments and supplies to span the technological continuum, from bioresearch to clinical diagnostics and cellular analysis. The customer offers services for the Patient Care testing market, R&D Testing and Translational Solutions markets which include biotechnology firms, pharmaceutical companies, research institutions, universities, hospital laboratories, commercial laboratories, physicians' offices and group practices.

Roles and Responsibilities

Prepared the Utilities to minimize the team working hours.

Implemented the test management skills in the team and delivered Quality work.

Performing the ETL Testing, as part of ETL Testing validating the data at the various layers of DWH.

Performing Unit Testing, User Interface (UI) Testing, Functionality Testing, System Testing and Regression Testing as part of OBIEE Reports Testing.

Training to the new resources and helping team in preparing manual test cases and automation test cases applying test design techniques in an effective manner.

Analyzing the requirement documents.

Identify and develop automation framework suitable for Business Requirement Catalogue and Time Rule functionality.

Create or maintain object repositories and following best naming conventions for the objects identified.

Review scripts by considering coding standards and performance parameters.

Daily status reporting and Build closure report.

Performed Failure analysis on automation failures.

Perform ambiguity testing on Requirement specifications.

Reviewing effectively the manual and automation test cases authored by team to derive the quality of test cases.

Preparing DSR, WSR, Test Summary Report, Defect Summary Report, Defect Tracking Reports.

Project #5

Project : National Health Services

Type : ETL Testing

Environment : LDMS Tool, Informatica, MS SQL Server 2008, IBM Synergy & Change, HP Quality

Center,DTS,QTP

Client : NHS - UK

Duration : July 2010-Feb 2012

Project Description

NHS-Lorenzo is a healthcare application addressing fully the administrative and clinical information management requirements of healthcare providers. It is found on modern standards and designed by NHS- trained healthcare professionals. It delivers powerful clinical and management tools through a rich user experience. This application has two different interfaces which will be used by Product administrators and Hospital staff like Care Providers.

Roles and Responsibilities

Understanding of business and functional requirements.

Involved in Test case authoring based on functional requirements.

Performed Test case execution, Regression testing, Browser compatibility testing & Ad-hoc testing.

Defect reporting & verification.

Target IFF(Intermediate Flat File) Design and Development

Source Extraction through DTS(Data Transformation Source) and Informatica.

XML Generation (Meta Data, Validation Rules Creation) through XML Generator tool.

Writing validations using SQL Queries, Expressions

Writing Stored Procedures.

Loading the extracted data using LDMS(Lorenzo Data Management Studio) and validated data loaded into the data warehouse.

UI Testing on the migrated data.

Giving KT (Knowledge Transfer) on the application for the new joiners in the team.

Worked as DataMigartion-Developer on Lorenzo with the help of LDMS Tool, MS SQL, Informatica.

(Ashwini Mallipedi)

Contact this candidate