Data Quality Assurance

Nalini P. Pasupulati **** Raspberry Ct.

Data warehousing Quality Analyst Edison, NJ-08817

Cell:908-***-****

E: ******.**********@*****.***

Work Status: Green Card Holder of United States of America

Summary

Over 7 years of experience in end to end development of software applications using Data

•

Warehouse methodology in various phases of IT projects such as System Analysis, Design, Coding

and Testing. Extensive experience in the implementation of Data Warehouse/ Data marts for business

applications in Financial, Banking Domain.

6+ years of strong QA (Testing) and Data Warehousing experience in building and managing

•

various Data Warehousing / Data marts using Informatica products such as Informatica

PowerCenter 7.1/7.0/6.1/6.2.1/5.1/4.7, PowerMart 6.2/5.1/4.7, PowerConnect, PowerAnalyzer,

and Power Exchange tools.

6+ years of experience in RDBMS technologies like Oracle 8x/9x, DB2 8.0/7.0/6.0, Teradata

•

V2R5/V2R4/V2R3, MS SQL Server 2000/7.0/6.5, Dbase, Excel and MYSQL. SQL Developer,

TOAD, Quest Central for DB2.

Four plus years of experience in Business intelligence reporting tools using Cognos Series

•

7.0/6.0, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise

Server, and Business Objects XI/6.5/6.0/5.0, BO Developer Suite 6.0/5.0 (Designer, Web

Intelligence, Broadcast agent, Supervisor, Module), Microstrategy.

6+ Years of experience in Relational modeling and Dimensional modeling (Star schema and

•

Snowflake schema with FACT & Dimensions tables using Kimball and Inmon methodologies) and

experience in logical and physical data modeling with Erwin 4.5/4.0/3.5.5/3.5.2, MS Visio.

Extensively used SQL, PL/SQL to create complex queries, SQL override, Stored Procedures,

•

Triggers, CA Autosys, and BMC Control M and Maestro.

Worked on various Operating Systems which include Windows 95/98/2000/NT/XP and Linux

•

(RedHat), UNIX (Sun Solaris 9.0/8.0/7.0, IBM AIX, HP UX 11i v1.5/1.6/2.0).

Education

M.S. Software Engineering, UAH, Alabama GPA - 3.31 Aug’04 - May’05

M.S. Computer Science UAH, Alabama GPA -3.3 Aug' 00 - May’04

B.Tech. Computer Science and Engineering, SK University, India GPA - 3.8 Aug' 95 - May'99

Page 1 of 6

Nalini Pasupulati

Technical Skills

ETL Tools Informatica PowerCenter 7.1/7.0 (Repository Manager, Designer, Workflow

Manager)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow

Manager. Repository manager administration) /5.1/4.7(Source Analyzer, Data

Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation

developer), PowerMart 6.2/5.1/4.7/1.7

BI & Business Objects XI/6.5/6.0/5.0, BO Developer Suite 6.0/5.0 (Designer, Web

Reporting Intelligence, Broadcast agent, Supervisor, Module), Cognos Impromptu 7.0/6.6,

Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise,

MicroStrategy

Testing Tools QTP 8.2, WinRunner 8x, Test Director, Quality Center, Load Runner 7x

Databases Oracle 9i/8i/7.3, MS SQL Server 2000/7.0/6.5, IBM DB2 UDB 8.0/7.0/6.0/5.0,

DB2/400, Sybase, Teradata V2R5/V2R4, Sunopsis, MS-Access and MYSQL.

CA Autosys, BMC Control M, Maestro.

Job

Scheduling

UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS

Operating

95/98/2000/NT/XP, Linux (RedHat),MS-DOS

System

SQL, PL/SQL, SQL Developer, TOAD, Quest Central for DB2,UNIX shell scripts

Languages/

(Cron, C), Java, Servlets, XML, HTML, DHTML, C/C++, Visual Basic

Utilities

Work Experience

Bank of America/Merrill Lynch, Pennington, NJ July 2009 – Present

ETL Test Lead - Data warehousing Quality Analyst

The client data is converted from BAI/NFS system to GWM HUB and PATH on the ML side. The

Investment Clients such as Brokerage Clients, CTA, Bank Extract CTA;

Non Investment but Premier Banking Executive and TRUST clients are converted

from BAC to ML system.

Basel II Bank Of America standards require that parties with whom the bank interacts, are identified with

a unique customer identifier across GWIM platforms for Basel II Risk Management Scoring. These

customers include both domestic and International.

Responsibilities:

As a Data warehousing Quality Analyst was involved in

• Managing project streams and acted as Business rules/Data validation MDM steward for CODG

(Client On Boarding and Data Governance), Bank of America and Merrill Lynch.

• Lead team of 3 onsite and 2 offshore.

• Managed multiple ETL projects same time.

• Performed data analysis, testing, debugging, audits, and problem resolution.

2

Nalini Pasupulati

• Lead client calls, offshore and onsite calls and worked on Status Report.

• Developed the Test Plan, Testing Strategy and RTM.

• Performing Project stream management,

* Data standardization review,

* Data model review,

* Software Requirement Spec (SRS/HLD) review,

* Software Architecture Spec (SAD/LLD) review,

* Design/Implement/Execute validation cases, test scripts, and data

validation strategy.

* Design and standardize validation method and implement criteria.

• Responsible for key Business/Technology functional areas including

* GWM Client Hub,

* GWM Master Profile,

* GWM Index

* Corresponding PATH systems

* Basel II GWIM Index and Master Profile

* NFS, PNE conversion.

• Interacted with Business and Technical partners to get a clear understanding of the requirements.

• Involved in developing SQL scripts for validating Data Survivorship, Branch Rollup, House

holding, ETL Process, Outbound Feeds, Id Resolution process, Correlation Process, BAU

Process, Delta Loads from PATH and KD.

• Involved in Data conditioning, Data Mining and Data cleansing for various projects.

• Involved in validating the Unique ID generated by GWIMHUB is unique only across GWIM

systems and verified if GWIM Hub is sending all Basel required customer data elements to GDPP

for provisioning to ECRIS for all customers maintained on the GWMHUB/Index.

• Extensively used SQL developer to develop the queries and executed them against the appropriate

databases.

• Queries were ran against the databases to compare the source data to the Target data for validating

the implementation of all the business rules.

Environment: Ascential Data stage 7.5.1A, Oracle 10g, Oracle SQL Developer v1.1.0.23, Rational Clear

Quest v 2003.06.15.734.000, HP QC v9.2, Windows XP Professional, MS Visio 2007, MS Excel 2007,

MS Word 2007

MTV Networks, NY Oct 2007- April 2009

Sr. QA Tester

MTV Networks uses Plan-it application for Adsales systems which integrates with Gabriel, WinsalesB,

WinsalesA, downstream applications Forecast and WinPrint, Reporting applications such as Evolve,

Winsales Datamart. The RateCard and the Deals information will be sent from Plan-it to Gabriel through

OWB process There are two modules associated with this integration namely GRCIM (Gabriel RateCard

Integration Module), GDIM (Gabriel Deal Integration Module). GRCIM will update the RateCard

information in Gabriel system when a RateCard version is released in Plan-it. GDIM will update the Deal

information in Gabriel System when a Proposal is sent to Hold/Contract. The Reference and Avails

related information will be sent to Gabriel from Plan-it through GRIM (Gabriel Reference Integration

Module) and GAIM (Gabriel Avails Integration Module).

Page 3 of 6

Nalini Pasupulati

Rapt is a project for Digital Adsales systems which is used to determine if the number of booked

impressions is equal to the number of delivered impressions, There are two Flat files namely Solbright,

Snaplog which are loaded in to respective tables by using sql loader and data is loaded in to the UDM and

Datamarts IM, PD, BA through Oracle Stored Procedures.

Responsibilities:

Extensively involved in writing Test Plan, Test Cases, based on Business Requirement

•

Documents, Functional Requirement Specifications, and Design Specification document

generated and executed Test Scripts.

Developed ETL Test Plan and Test Strategies for the entire Line of businesses.

•

Created a weekly project status format and issue log for weekly meeting

•

As a QA Analyst I was required to provide technical quality assurance for web based

•

applications, meeting both company standards and end-user requirements.

Written Test Plans and Test Cases on Mercury’s Quality Center Tool.

•

Involved in functional testing the Web application using WinRunner.

•

Worked with Oracle database to compare the results from front-end data values with

•

backend data values.

Extensively used SQL queries for Database testing and Validation.

•

Involved in extensive backend testing.

•

Developed Test Cases for testing the mapping designs before going to the production phase.

•

Written several UNIX Shell Scripts for cleanup, logging, file manipulation and transferring the

•

files.

Developed Korn Shell Scripts and Perl Scripts to create fixed width files from flat file sources,

•

and to wrap the SQL code, and to validate/test the load process.

Worked with Toad for data retrieval.

•

Extracted certain column of data from a number to files using PERL.

•

Used PERL for automating all the types of modules at a time.

•

Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts

•

for various scenarios.

Involved in all testing phases: Unit Testing, System Testing, Regression Testing, Integration

•

Testing, and Quality Assurance Testing.

Used Rational Clear Quest the defect tracking tool for retesting the CQ’s and creating the new

•

issues using the CITRIX as web Interface.

Modified the UNIX scripts for Testing purpose to check the Rollback mechanism, Restatement

•

window logic, wrapper scripts etc.

Involved in executing the UNIX shell scripts for loading the data from the Source to the

•

Datamarts.

Tested the data and data integrity among various sources and targets.

•

Environment: Oracle warehouse Builder 10g, Oracle 10g, Flat Files, PERL,SQL, PL/SQL, SQL *

Loader, UNIX(Cygwin), TOAD 9.5, Teradata SQL Assistant 6.0, Teradata V2R6 (MLOAD, FLOAD,

FEXPORT, TMPUMP, BTEQ), UNIX Shell Scripting, HP Quality Center 9.2, Rational Clear Quest,

Windows XP Professional, Citrix 8.0, WinRunner 8x, .NET.

4

Nalini Pasupulati

Bank of New York, NY July 2006 - Sept 2007

Sr. QA Tester

The Bank of New York has implemented the Credit Risk Data Warehouse (CRDW) and enabling

applications to satisfy the Federal Reserve’s mandate that BNY comply with the terms of the Basel II

accord for measuring credit risk, calculating regulatory capital, publicly disclosing the centrally

aggregated credit risk information, and reconciling the warehouse’s information with BNY’s general

ledger. The CRDW processes daily credit risk information from 43 Bank systems and resides in the IBM

hosted data center in Secaucus, New Jersey.

Responsibilities:

Interacted with the Business users to identify the process metrics and various keys

•

dimensions and measures.

Well exposed to Software Development Life Cycle and Test methodologies.

•

Extensively involved in writing Test Plan, Test Cases, based on Business Requirement

•

Documents, Functional Requirement Specifications, and Design Specification document

generated and executed Test Scripts.

Worked with SQL to compare results from front-end data values to backend data.

•

Generated test scripts for automation using Quick Test Pro.

•

Developed manual and automated test cases and Quick Test Pro scripts to test the

•

functionality of the applications and generated Test Scripts and automated it for future use in

Quick Test Pro.

Conducted the Functional, System, Regression, and Performance testing of the Web

•

application using Mercury tools Quick Test Pro and Load Runner.

Worked with PERL control structures & Regular Expressions for substitutions based on

•

matches.

Worked with PERL for file manipulations.

•

Developed complex queries using different data providers in the same report.

•

Heavily interacted with ETL team for testing data Quality and data Validation.

•

Written several backend SQL queries and was involved in enhancing the performance by

•

tuning the SQL queries.

Involved in creating Test Matrix for various work streams for traceability purposes.

•

Involved in writing Test cases for all the links and various data files based on ETL Mapping

•

document by Test Director.

Extensively used PL/SQL queries to perform operations like joins in the databases

•

Worked with several sources for understanding the business needs for performing both

•

positive and negative testing.

Executed UNIX Shell Scripts for Batch Job Execution.

•

Written several UNIX scripts for running test loads for regression testing purpose.

•

Responsible for weekly status Reports, Performed functional, Integration, Regression testing.

•

Environment: Ascential Data stage 7.1, DB2 9, MS SQL Server 2000, SQL, Win SQL Professional,

Windows XP Professional, Novell client 4.91, PERL, IBM AIX 5.1, MS Visio 2003,MS Excel 2003, Load

Runner 7x, Lotus notes 6, PeopleSoft 8, Oracle10g, Erwin 4.0, Toad, QTP 7.2.

Individual Projects

Research Associate, UAH May ’05 - Sep ‘06

•

-My duties include developing a prototype model for Heavy load Database Model.

Page 5 of 6

Nalini Pasupulati

Teaching Assistant, UAH Sep’03 - May’05

•

-My duties include teaching students in the areas of Computer science.

Graduate Research Assistant, Computer Science,UAH Sep’02 - May’03

•

-My duties include constructing a central research interest database and to provide credentials,

research interests and authentication by using PHP, MYSQL.

Research Assistant, Civil Engineering, UAH. Aug’01 - Mar’02

•

- My duties include maintaining database, developing a project to provide traffic simulations for

different networks.

Worked as Database Administrator, UAH Feb’01 - Aug’01

•

-Worked as Database Administrator for the Graduate College, UAH, where my duties include

maintain student and faculty database.

6

Contact this candidate