Data Project

BALRAJ ALLADI

Professional Summary

Over seven years extensive work experience in Software Quality Assurance

and Data Warehouse. Have excellent knowledge of Software Development Life

Cycle (SDLC) and a thorough understanding of various phases like

Requirements, Analysis/Design, Development and Testing. Involved in

Developing Test Plans and Test Cases. Experienced in Functional, Stress,

Load and Regression testing. Proficient in software testing, data warehouse

acceptance and automation tools such as Test Director, Silk Test and Quick

Test Professional. Extensively used Informatica tool and SSIS, to extract,

transform and load business data. Highly motivated individual with

excellent communication, presentation, and inter-personal skills. Extensive

knowledge of Business Intelligence environment, Hyperion Essbase and Data

Warehousing. Possess excellent problem solving, communication and

organizational skills.

Specific Expertise

Conducting requirement gathering sessions, feasibility studies and Impact

Analysis in organizing the software requirements in a structured way.

Used Test Director for tracking and prioritizing defects and for

enhancements after base lining the requirements.

Highly motivated team player with excellent communication, presentation and

interpersonal skills, always willing to work in challenging and cross-

platform environment.

Experience in backend/database testing for data validation by executing SQL

queries and stored procedures.

Verified and Validated Informatica ETL mappings that transfer data from the

source system to the warehouse.

Tested the extraction of the data from different OLTP source systems,

modification and loading into the target Staging/Target database.

Manual Backend Testing to verify integration and validity of data in both

RDBMS and OLAP systems.

Performed Data validation on the data originating from the source system to

identify and mark poor quality records for elimination into the data mart.

Validation included use of lookup tables (e.g., state or country) or data

type checking (valid numeric, date, and null) to qualify legacy records for

inclusion in further processing to the data mart. Records that do not

qualify are excluded from conversion or rerouted to an exception queue for

further processing.

Strong experience in the entire life cycle of Data warehouse design,

development and implementation.

Excellent Result oriented approach, great written and oral communication/

Presentation skills.

Strong Knowledge of Data warehousing concepts and Dimensional modeling

(Star schema and Snowflake schema).

Technical Skills

Automation tools Mercury Interactive Win Runner, Quick

Test Pro, Silk Test tool, Load Runner.

Change Management Tools Test Director, Rational Clear Quest.

Languages C, C++, PL/SQL, SQL, JAVA.

Operating Systems MS Windows NT,XP, Unix

Web Technology JDK,J2EE, HTML, DHTML, XML

RDBMS Oracle, SQL Server, Teradata, MS Access,

DB2

ETL Informatica Powercenter, SSIS

Software Packages MS Office, MS Project, TOAD, SQL

Assistant, SQL Developer.

Methodologies Star - Schema, Snow Flake Schema, Fact

Constellation

OLAP Hyperion Reports, Hyperion Analyzer,

Business Objects, Excel Add-In, SSRS and

Cubes.

Defect tracking Tools JIRA,Dev-track, VersionOne and Rational

ClearQuest.

Kronos Incorporated, Atlanta, GA

May 2008 - Current

Sr.SQA Engineer.

Kronos Workforce Analytics for Healthcare is an add-on product to the

Workforce Analytics product that adds the following functions to the core.

Workforce Analytics system:

Brings data from Kronos Workforce Timekeeper, as well as data from

payroll, agency and volume (billing) systems to the Workforce Analytics

datamart.

Adds four additional Healthcare Analytics cubes.

Makes daily and pay period productivity statistics available in the

dashboards, scorecards, and interactive reporting of Workforce Analytics.

Responsibilities

Analyzed and converted system requirements and designs into key test

objectives.

Designed test plans collaboratively with developers and business users

early in the iteration so as to guide development by Test Driven

Development process.

Agile development and testing in SCRUM framework.

Developed automation tests, database scripts, and batch files to validate

data in various phases.

Worked closely with development team members to troubleshoot problems and

identify the root cause.

Accurately reported defects: following the companies defined defect

management process (JIRA,Dev track and VersionOne tool).

Tracked and analyzed bugs using Jira tracking tool.

Reporting defects using JIRA & resolution of defects while retesting from

the resolved build.

Participated in improving the departments QA processes and procedures.

Actively participated in Status reporting and Defects discussion meetings.

Verified and tested the final output/data in the form of Reports and Cubes.

Responsible for manual testing of data integration/migration from various

source systems into the Data Warehouse environment.

Created and executed test plans and test cases using SilkTest.

Scripted and executed automated functional tests using SilkTest

Automated Test scenarios for GUI, Functionality, Security, Database and

Regression Testing using Quick Test Professional.

Developed parameterize test scripts to test same functionality with

multiple sets of data using Quick Test Professional.

Designed structured Automated Test Cases and Test Suites for reusability

using Quick Test Professional.

Environment: SQL Server 2005(SSIS, SSRS, cubes), Oracle, Test Director,

Silktest, Quick Test Professional, TOAD, SQL Server Management Studio.

Cingular Wireless (New at&t), Atlanta, GA

Jun 2006 - May 2008

Sr.QA Tester/Analyst.

Project

[pic] Project Mercury is a management reporting initiative underway to

streamline the reporting processes within Cingular. It will also serve to

provide accurate information down to the Customer Telephone Number (CTN)

level. Project Mercury consists of a number of major initiatives broken

out roughly into seven categories: Subscribers, Revenue, Cost, and

Foundation projects, PFT, Audits and Single Revenue Accounting System

Responsibilities

The End to End validation was intended to ensure that the data has been

correctly transformed from the various layers for each of the following

checkpoints.

1. Source to ODBC.

2. ODBC to Dimensions.

3. Dimensions to Fact.

4. Fact to Cubes.

Generated a master test plan, containing test requirements and test

strategies, to identify and describe testing that will be implemented and

executed using TestDirector.

Created traceability between the software requirements, test cases and

automated test scripts using TestDirector.

Performed Data Driven Tests to validate the same scenario with different

test data using Quick Test Professional.

Optimized Quick Test Professional scripts for web based regression testing

using different sets of data.

Quick Test Professional was used to generate automated test scripts for web

based functionality and GUI testing and further enhancements were done in

the script.

Provided individual or project support for complex projects or

applications, adhering to

Strict timelines.

Tested the extraction of the data from different OLTP source systems,

modification and also tested the data loaded into the target Staging/Target

database.

Worked closely with the ETL developer to develop the source to target

loads, monitoring the Timing of loads, validating data mappings.

Accurately sized and designed the test environment, which is, installing

and configuring Test Director, setting up client machines for testing and

connecting the test bed with back-end database and server.

Conducted Functionality and Regression testing during the various phases of

the development.

Verified and tested the final output in the form of Reports.

Tracing the test cases to the requirement specifications document using

TestDirector.

Developed Test Metrics on a monthly basis for higher management and

officials.

Performed QA Personnel Reporting and tracked defects using Test Director

and Rational ClearQuest.

Performed Database integrity testing by executing SQL statements.

Issued reports and generated monthly status and attended status meetings.

Environment: UNIX, Oracle, Teradata, Hyperion Essbase, Test Director, Quick

Test Professional, TOAD, Informatica PowerCenter.

Cingular Wireless, Atlanta, GA Sep

2004 - Jun 2006

QA Tester/Analyst.

Project

MaRS (Management Reporting System) is focused on sales by function (e.g.,

Retail Reporting, Finance Analysis, Sales Ops Analysis). MaRS pull reports

to show production numbers for sales (Gross Adds, Initial Adds, Store

Profile, Commissionable Revenue & more). MaRS is using tools to assess

metrics of Revenue, Margin, Expenses, Supporting Accounts, ROA, and more at

the store group reporting level (Return on Operations).

MaRS receives and processes data from multiple sources within the

organization. Daily detail subscriber feeds are loaded, processed,

transformed and aggregated by dimension within the Oracle database

environment. The summarized data is then loaded to Essbase cube. Mobile

level details therefore do not exist in the Essbase environment. Essbase is

used to facilitate a high level multi-dimensional presentation data layer

to the enterprise for analysis purposes.

Responsibilities

Responsible for establishing and supporting quality standards in the

development of system solutions.

Participated in the development and review of life cycle phase

deliverables, selection, architecture, installation and training of tools

and planning, creation and execution of testing activities.

Interacted with project teams that included developers, analysts, project

managers and client representatives. Responsible for coordinating the team

and resolved the issues that arise within the team and also represented the

team.

Used Mercury Test Director for bug tracking and reporting, also followed up

with development team to verify bug fixes, and update bug status.

Identified the critical test cases early in the project and facilitated the

transition of software from the development environment to the test

environment.

Extract processes and receive data from different source systems. Validate

the data, load the data to staging environments using UNIX and SQL Loader,

transform the data and load to the data mart environments. This data is

identified and tracked from staging tables to Fact and Dimension tables

before loading into Essbase Cubes.

Once the initial validation was done and the data mart was loaded, the data

was being tested for appropriate business rules. Created test conditions

against each of the business rules and Scenarios.

Executed Test Scripts for newly developed functionality and Maintain

Regression Test Scripts

Responsible for manual testing of data integration/migration from various

source systems into the Data Warehouse environment.

Ran SQL queries against the Data Sources and Targets for Validation.

Verified and tested the final output in the form of Reports.

Environment: Windows NT 4.0 / 2000/98/95, UNIX, Oracle, Teradata, Test

Director, Toad, Hyperion Essbase, Excel-Add-in.

AmericaRX.com, NY Jan 2004

- Aug 2004

QA Test Engineer

Project

AmericaRX.com monitors its Pharmacy Activity and Online Pharmacy Revenue on

a daily and monthly basis respectively. The data from the Peoplesoft

database are transformed into SQL Server tables using DTS Packages which is

the data source for the Essbase Cubes. Cubes were built and loaded using

AIS (Analytical Integration Services) .Reports were developed in Hyperion

Reports and Hyperion Analyzer.

Responsibilities

Involved in creating test plans, validating Sources, Targets, and

Transformations using SQL Server DTS Packages.

Generated and executed manual and automated test scripts for the User

Acceptance Testing, Functional, System, and Integration testing.

Run and maintained QTP scripts during maintenance.

Parameterized the fixed values in checkpoint statements, created data

tables for the parameters and wrote functions for the parameters to read

new data from the table upon each iteration - Performed Data-driven

testing.

Performed System Testing and validated the data both in the data source

(SQL Server) and the target (Essbase).

Ran SQL queries against the Data Sources and Targets for Validation.

Analyzed system requirements and developed detailed Test Plans for System

Testing using Test Director

Verified and tested the final output in the form of Hyperion Reports and

Hyperion Analyzer.

Environment: Windows 2000, TestDirector, QTP 8.0, Hyperion Essbase,

Hyperion Reports/Analyzer and Oracle

BNSF Rail Road, Ft Worth, TX Jul 2003 -

Dec 2003

QA Tester/Analyst.

Project

This was an OLAP system called the TouchFree dashboard used for budgetary

analysis of all financial Departments using drilldown, charts, attached

narratives, predictive alerting, etc. It will be the main tool used by the

senior management team to explain the operating results, audit issues,

process breaks, headcount metrics, etc of their respective organizations.

Data mart built to analyze the Budgetary Analysis Structure. The data mart

is built on the Star Schema model maintaining the conformity of all the

dimensions. There are two fact tables in the model. The first one is a fact

less fact table that contains the relationship among the various dimensions

related to the account structure. The second fact table contains the daily

snapshot of the claim activities as of the end of the day.

The source system for this application - Budget Management (the OLTP system

for Account Structure Management) The data is pulled from these two systems

on a daily basis and staged in a persistent staging area. Once the data is

staged, the dimensions and the facts are loaded.

Responsibilities

Developed test cases and test scripts were stored in a Central Repository

and Version Control applied using Clear Case.

Developed Test Scripts for manual as well as for automated testing using

Win Runner.

Defined and performed the Test strategies and associated scripts for the

verification and validation of the application and helped ensuring that it

meets all defined business requirements and associated functionality.

Wrote Test Plan and Test cases for Acceptance, Functional and Integration

Testing using TestDirector.

Optimized QTP scripts for Regression testing of the application with

various data sources and data types.

Parameterized the fixed values in checkpoint statements, created data

tables for the parameters and wrote functions for the parameters to read

new data from the table upon each iteration - Performed Data-driven

testing.

Coordinated and Controlled Testing Projects at every step of the Quality

Cycle from Test Planning through Execution to Defect Management.

Monitored all phases of the Testing process, Test Schedules and their

Execution, and Communicated Project Information.

Performed extensive Database testing by testing the Front End, inserting

Database Checkpoints to query data, performing Load Test on the database

server.

Tested reports for doing the business rules validations and compare them

against the source data. These reports were scheduled and were being run

after every load.

Created and tested scenarios using positive and negative test data.

Environment: Windows 2000, TestDirector, Quick Test Pro 6.5, Hyperion

Essbase, Hyperion Reports/Analyzer and Oracle

Education

Bachelor's of Science.

Contact this candidate