Data Manager

Prasanna Singiresu

ETL QA/Informatica/DataWarehousing Consultant

US Citizen Email: ********.*********@*****.*** Ph:571-***-****

SUMMARY

16+ years of strong experience in testing applications built using technologies like, Data Warehousing (Data Migration, Data Transfer and ETL), ERP, Internet / Web, Client-Server.

Involved in testing application built on SAP 4.6 and Data Warehousing tools like Informatica 5.1 / 6.2/7.1,8.5,9.1/9.5.1, Informatica DVO 9.5.2.1, Abinitio (GDE 1.11, Co-Op 2.11) with reporting tools like Cognos 6.0 / 7.0, Business Objects 5.1.3/5.1.8

Extensively performed Unit Testing, System Testing, Integration testing, Functional testing and User Acceptance Testing.

Experienced in testing data loads in Enterprise Data Warehouse

Experience on Automation Tools like Test Complete, Selenium (RC/Web Driver 2.0), WinRunner, Load Runner and Rational Robot

Experience in testing Back end Services using SOAP UI Pro.

Excellent understanding of Data Models (Star schema and Snowflake Schema)

Experienced in testing reports using Business Intelligence (BI) Tools like MicroStrategy, Cognos, Business Objects and Essbase.

Involved in Requirements Analysis, Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.

Expert in verifying the accuracy and completeness of data after a data migration, replication, integration or other similar movement or transformation exercise using Informatica Data Validation Option (DVO).

Knowledgeable in all areas of the Software Development Life Cycle (SDLC).

Strong in Trouble shooting data discrepancies and interpreting technical specifications.

Experienced in using SQL queries for testing Data Warehouse applications.

A team player, with good interpersonal relations and effective communication and presentation skills.

TECHNICAL SKILLS

Operating Systems

UNIX (Solaris/Linux/AIX), Windows (95/NT/2000/XP)

Languages

Java, C, Pascal, COBOL, SQL, PL/SQL, VB, Java Script, VB Script, Shell Scripting (CSH, BASH, KSH)

Data Bases

Oracle 7.x/8i/9I, DB2, MS-SQL Server, TeraData7.1/6.1,14.10.0.04,

MS Access

Web Technologies

J2EE (Servlets, EJB, JSP), .Net (ASP. Net, VB.Net), Web Services, XML, HTML, Swing, AWT

Reporting Tools

Cognos 6.0/7.1, Business Objects 5.1.3/5.1.8, MicroStrategy 7i

App Server

WebLogic 6.x/7.x/8.1, WebSphere 4.x/5.x, Tomcat, Sun One

Modeling Tools

Visio 2000, Rational Rose (UML), Erwin

ETL (Data Warehouse)

Informatica 9.5.1/9.6.0, Informatica DVO 9.5.2.1,9.6.0, IBM DataStage and QualityStage 9.1/11.5, Abinitio (GDE 1.11, Co-Op 2.11)

Version Control

CVS, Harvest, Clear Case, VSCC

Bug Reporting Tool

Test Director, DVO, Clear Quest, Excel

Query Reporting Tools

WebSphere QMF, SQL Navigator 4.x/5.x, TOAD,

TeraData SQL Assistant 6.2, Queryman 6.0

Testing Tools

[Mercury Tools](WinRunner7.x, Test director6.x, 7.x, 8.0,LoadRunner 6.x, 7.x, QTP), [Rational Suite] (Rational Robot, Requisite Pro, Test Manager, Clear Case, Clear Quest)

Job Scheduler

Autosys, Windows Task Scheduler

ERP

SAP

Mainframe

TSO, NDM

PROFESSIONAL EXPERIENCE

Client: OPM (Federal) Washington DC

Role: ETL Testing Lead Nov 2017 – Present

Responsibilities:

As an ETL Test Lead for HCDW (Health Claims Data Warehouse) put out the test plan after discussions with the test team and have it reviewed and approved by the management/development team.

Identified the Scope of testing required for a particular release based on the requirements of the document.

Initiated the test planning activities for test case design and encourage the team to hold review meetings and ensure that the review comments are incorporated.

During the testing cycle, monitor the test progress by constantly assessing the work assigned to each of the resources and re-balance or re-allocate them as required.

Check if there might be any delays in achieving the schedule and hold discussions with testers to figure out the issues that they may be facing and strive hard to resolve them.

Present the timely status to the stakeholders & management and instil confidence about the work being done.

Attend the Daily stand up meeting along with the testing team.

Provide the Task and Estimation for the testing team at Sprint Review and Planning Meeting.

Conducted Defect review meetings.

Coordinated and worked closely with Operations team on the release activities.

Wrote SQL loader script to load the source files data (both Fixed and Delimited data) into Oracle tables for comparing data with the target tables.

Worked with QA managers, Development managers and the Software Development Director to develop and execute QA strategies to meet and exceed department and corporate quality goals

Trained and Mentored team members.

Responsible for Defining QA strategy, approach and execution of the projects.

Conducted internal team meetings to know the status of the Progress.

As a team lead escalation point for all matters related to testing and quality assurance and operate as a primary point of contact.

Helped testers in developing test scenarios, test cases and test data based on the requirement documents and make sure team covered all the business requirements.

Upload all the testing artifacts to the share point end of every sprint.

Coordinated with the Development team and the Product team in understanding the Source Target mapping document clarifications on requirements.

Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.

Used DataStage Director Tool to execute the Jobs, monitor and to test the scenarios like source to stage, stage to target, Reference code checks, Referential Integrity checks, Natural Key uniqueness, Audit balance control checks etc.

When the DataStage Job load fails, helped in performing root cause analysis through logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team.

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Created different scenarios Developed SQL queries to validate data in Data warehouse and Data mart.

Performed System Integration, User Acceptance and Regression Testing.

Worked with HP QC for logging defects.

Used WinSCP to copy files to server.

Environment: IBM DataStage and QualityStage 9.1/11.5, UNIX (IBM AIX), Windows 7, Oracle SQL Developer 3.2.20.09, Oracle 12c, Oracle SQL Loader, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, HP Quality Center 10, Cognos, WinSCP, Putty, Windows Task Scheduler.

Client: NFCU (Navy Federal Credit Union) Vienna, VA

Role: ETL Consultant Mar 2015 – Oct 2017

Responsibilities:

As a Senior Data warehouse tester for TSYS (Credit Card), MSP (Mortgage), used Informatica DVO tool to create both single and table pairs to test the scenarios like source to stage, stage to target, Reference code checks, Referential Integrity checks, Natural Key uniqueness, Audit balance control checks etc.

Created SQL views and join views for the table pairs in DVO.

Generated Reports out of DVO for the leadership team to give a sense of the test coverage via DVO scripts.

Updated parameter files in Serena Dimensions before executing the workflows in workflow manager and monitored the load in workflow monitor.

Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.

For the failure loads, performed root cause analysis through session logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Created different scenarios Developed SQL queries to validate data in Data warehouse and Data mart.

Performed System Integration, User Acceptance and Regression Testing.

Worked with HP QC for logging defects.

Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.

Coordinated and worked closely with Operations team on the release activities.

Used WinSCP to copy files to server.

Attended the regular meeting and update the testing status.

Imported the Sources from Data base using the designer and refreshed the DVO created folders to see the sources in DVO tool

Coordinated with the Development team and the Product team in understanding the STTM clarifications on requirements and defects

Based on the STTM logic created DVO scripts and SQL scripts to validate data from source to stage to Target tables

Currently working on MSP and created DVO scripts for validating between User File and view (Flattened table)

Attended Lending BIO test planning and review session planning meeting and discussed about the overall test status

Tested the CDC (change data capture) functionality of the data warehouse by creating DVO and SQL scripts

Environment: Informatica 9.5.1 hotfix 2.0,9.6.0, Informatica DVO 9.5.2.1,9.6.0,UNIX (IBM AIX), Windows 7, SQL Assistant 14.10,TeraData 14.10.0503, Java, Spring suite 3.1.0.Release, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, HP Quality Center 10,cognos,WinSCP,Putty

Client: USPTO Alexandria, VA

Role: Test Lead Sept 2014 – Feb 2015

Responsibilities:

As a Test Lead for Private/Public Patents, tested ETL (Informatica) workflows for each extract in the Informatica Designer and verified the session logs.

Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.

For ETL performed Constraint testing, source to target counts, source to target validation, error processing.

Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Worked in both Data Warehouse Models (Star and Snowflake Schema)

Developed SQL queries to validate data in Data warehouse and Data mart.

Validated reports generated from Micro Strategy.

Validated report data by writing and executing SQL queries against the Mart data base.

Used Test Complete automation tool for Regression testing

Perform integration, regression, and functional testing on changes/enhancements.

Created the Common libraries/Functions

Used Object SPY to recognize the Objects on the Browser

Created test data in an Excel sheet for the Data Driven testing.

User both xlDriver and Test complete variables for reading the test data prepared in Excel

Performed System Integration, User Acceptance and Regression Testing.

Worked with Rally for logging defects.

Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.

Involved in improving the QA Process.

Used SOAP UI Pro for backend web service testing

Created product specific Test plan.

Coordinated and worked closely with Operations team on the release activities.

Created the Regression plan and assigned the task to the team members and ensure that all of them have sufficient work for the release activities.

Involved and worked in updating the Release deployment plan for different environments (QA/Stage/Prod).

Performed root cause analysis through logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team.

Involved in creating the Deployment Validation plan for all the four environment (i.e. QA, DEV, Stage and Prod)

Trained and Mentored Junior team members

Environment: Informatica 8.5/9, UNIX (IBM AIX), Windows 7, Oracle 9,10g,11g, TOAD 10.6.0.42, SQL Server, Micro Strategy 8,9, Test Complete, Java, Spring suite 3.1.0.Release,, TortoiseSVN 1.7.11, Rally, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point,, Web services (REST), JSON, XML,SOAP UI Pro

Client: Advisory Board Washington DC

Role: Senior QA Engineer Nov 2010 -Aug 2014

Responsibilities:

As a Senior QA Engineer for PIC Data Mart, tested ETL (Informatica) workflows for each extract in the Informatica Designer and verified the session logs.

Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.

For ETL performed Constraint testing, source to target counts, source to target validation, error processing.

Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Worked in both Data Warehouse Models (Star and Snowflake Schema)

Developed SQL queries to validate data in Data warehouse and Data mart.

Created tests and ran those tests whenever Power Center loads a batch of data to the target using Data Validation Option (DVO).

Using the GUI included in the DVO compared the data in the source and target by running table pair tests.

Validated reports generated from Micro Strategy.

Validated report data by writing and executing SQL queries against the Mart data base.

Used Selenium RC/Web driver 2.0 for Regression testing

Created the Common libraries/Functions

Used Firebug to find/inspect HTML elements present in the page

Used Xpath and CSS to locate an element based on associated class.

Performed System Integration, User Acceptance and Regression Testing.

Used to store the settings for each user in a unique user configuration directory using DVO.

Worked with Rally for logging defects.

Track and escalate the defects discovered during the releases and make sure all the prioritized defects got fixed and retested.

Created Table Pairs using the enterprise license of DVO to increase test performance and to store all error records from each table-pair test.

While using DVO Table Pairs used a parameter in the WHERE clause of a table pair definition to filter the records that are tested.

Involved in improving the QA Process.

Created product specific Test plan.

Coordinated and worked closely with Operations team on the release activities.

Created the Regression plan and assigned the task to the team members and ensure that all of them have sufficient work for the release activities.

Involved and worked in updating the Release deployment plan for different environments (QA/Stage/Prod).

Performed root cause analysis through logs, querying the tables and pin pointing the exact cause of the application failure and shared the findings across the development team.

Involved in creating the Deployment Validation plan for all the four environment (i.e. QA, DEV, Stage and Prod)

Trained and Mentored Junior team members

Environment: Informatica 8.5/9, UNIX (IBM AIX), Informatica DVO 9.5.2.1,Windows 7, Oracle 9,10g,11g, DVO, TOAD 10.6.0.42, SQL Server, CombineNet, Micro Strategy 8,9, Selenium (Web Driver 2.0), Java, Spring suite 3.1.0.Release, JIRA, JIVE, TortoiseSVN 1.7.11, Rally, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Web services (REST services)

Client: Amtrak McLean, VA

Role: Senior EDW Tester Sep 2009 – Oct 2010

Responsibilities:

As a Senior EIG Tester for BOD (Board of Directors) Data Mart, tested ETL (Informatica) workflows for each extract in the Informatica Designer and verified the session logs.

Verified Informatica mappings against the source and tested the transformations for consistency and the target table validation.

For ETL performed Constraint testing, source to target counts, source to target validation, error processing

Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Worked in both Data Warehouse Models (Star and Snowflake Schema)

Developed SQL queries to validate data in Data warehouse and Data mart.

Validated reports generated from Business Objects.

Validated report data by writing and executing SQL queries against the Mart data base.

Performed System Integration, User Acceptance and Regression Testing.

Worked with HP Quality Center for logging defects.

Tested Web services using SOAP UI

Environment: HP Quality Center 9.2, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Informatica 8.0.1,Business Objects, UNIX (IBM AIX), Windows XP, Oracle 11g, TOAD 9.0.1,SQL Server, Spring MVC, XML, Web services, SOAP UI, XML, selenium RC

Client: Booz Allen Hamilton McLean, VA

Role: Senior ETL QA Analyst Mar 2009 – Aug 2009

Responsibilities:

As a Senior ETL QA Analyst for Data Management Transformation (DMT), tested ETL (Datastage) jobs for each extract in the Datastage Designer and verified the session logs through Datastage Director Client.

Verified Datastage Jobs against the source and tested the transformations for consistency and the target table validation.

For ETL performed Constraint testing, source to target counts, source to target validation, error processing

Extensively tested ETL (Datastage) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.

Validated the data at each stage, from source table to staging tables and then finally to destination tables.

Worked in both Data Warehouse Models (Star and Snowflake Schema)

Developed SQL queries to validate data in Data warehouse and Data mart.

Validated reports generated from Hyperion Essbase.

Validated report data by writing and executing SQL queries against the Mart data base.

Performed System Integration, User Acceptance and Regression Testing.

Tested the drill through functionality by writing SQL queries and match it against the fact tables

Worked with HP Quality Center for logging defects.

Used ishare for version control.

Environment: HP Quality Center 9.1, MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Datastage 8.0.1,Hyperion Essbase, UNIX (IBM AIX), Windows XP, Oracle 9i/10g, TOAD 9.0.1,Subversion,ishare

Client: College Board Reston, VA

Role: Data Warehouse QA Analyst Dec 2007 – Feb 2009

Responsibilities:

As a QA Analyst for Centralized Data Warehouse (CDW), analyzed software requirements and business requirement documents to get a better understanding of the system on both technical and business perspectives.

Created Test Plan, Test cases and Test Scripts using Rational Test Manager.

Tested ETL (Informatica) mappings for each extract in the Informatica Designer and verified the session logs through Informatica Workflow Manager.

Used Cognos to generate monthly and quarterly reports.

Verified Informatica Mapping against the source (NSAT, ECDB, EODB), tested the transformations for consistency and the target table validation.

For ETL performed constraint testing, source to target counts, source to target validation, error processing

Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data.

Validated the data at each transformation. From source table to staging tables and then finally to destination tables.

Trained and mentored team members with product knowledge and business processes.

Worked in both Data Warehouse Models (Star and Snowflake Schema)

Developed SQL queries to validate data in IODS, Data warehouse and Data mart.

Validated report data by writing and executing SQL queries against the data base.

Validated CDC (Change Data Capture) Power Exchange Functionality in IODS.

Tested the functionality by writing SQL queries and match it against the fact tables

Performed Integration, System and Regression Testing. Assisted the users with User Acceptance Testing (UAT) and logged defects using Rational ClearQuest.

Used Rational ClearCase for version control.

Used PGP Desktop for downloading the encrypted files

Environment: Rational Test Manager, ClearQuest, ClearCase MS Excel, Microsoft Visio 2000, MS Word, MS Power Point, Informatica 8.1.1/8.5.1,Informatica Power Exchange (PWX)8.5.1, Cognos, UNIX (IBM AIX), Windows XP, Oracle 9i/10g, TOAD 8.5.1/8.5.3,PGP Desktop 9.8.3

Client: Wells Fargo Frederick, MD

Role: Data Warehouse QA Analyst Aug 2006 – Nov 2007

Responsibilities:

QA Analyst for Automated Decisioning for Wells Fargo Home Mortgage

Analyzed Software Requirement Documents and Business Requirement Documents to get a better understanding of the system on both technical and business perspectives.

Scope includes the Following Line of Businesses (LOB’s) i.e. Wholesale (WDW, WSD, EBE), Correspondent, Retail.

Developed Test Plans, Test Scenarios and Loan Scenarios.

Validated Data across all the systems.

Prepared Data validation Test Manual.

Validated Informatica mappings using the mapping document.

Wrote SQL queries to validate data in data warehouse and data mart.

Validated report data by writing and executing SQL queries against the database.

Performed IST, UAT and Regression Testing.

Validated reports generated from Cognos.

Retrieved files from Rule Admin, Hula Dashboard, DC compass, TSO and assigned them to testers along with E2E (End to End Documents) for data validation.

Worked with Rational ClearQuest for logging defects.

Prepared queries in Rational ClearQuest for all lines of Business

Environment: Rational Test Manager, Rational ClearQuest, Mainframe (TSO, CICS), DB2, MS Excel, Microsoft Visio 2000, NDM, MS Word, MS Power Point, DC Console, Informatica 7.1, Cognos 7.1, Hula Dashboard, Rule Admin, UNIX (IBM AIX), Windows XP, VB,.net, Oracle 10g, Java

Client: Citigroup New York City, NY

Role: Data Warehouse QA Analyst Dec 2004 – July 2006

Responsibilities:

Data Warehouse QA Analyst for Retail Banking Data Warehouse Application. Abinitio used as an ETL Tool. Cognos used as a reporting tool.

Written SQL queries using QMF Websphere to prove the data mapping and Cognos Reports. Executed AWK Scripts.

Actively involved in creating Test Plans based on the requirements submitted by the Business analysts. The Test Plan was approved and appreciated by the Test Lead and subsequently used as a template / baseline for future Test Plans

Interacted with developers to explain when required, software bugs and re-tested the fixed issues. Identified and documented all issues and defects to ensure application software functionality.

Run test cases and submit defect reports. Verify fixes and run regression tests

Performed security and authentication test on Cognos Report Net.

Raised STR (System Trouble Reporting) for all the issues found in the application, once the issue is resolved (after retesting) we needs manager’s approval to close the STR.

Testing is done in both IST and UAT Environments.

Environment: Abinitio (GDE 1.11, Co-op 2.11), DB2, QMF Websphere, Unix (IBM AIX), Windows XP, COGNOS Report Net, Shell Script, Mainframe (TSO), MS Excel, MS word, NDM. Test Director 8.0, TeraData, TeraData Administrator 6.1, TeraData SQL Assistant 6.1

Client: Lucent Technologies Murray Hill, NJ

Role: Data Warehouse QA Analyst Feb 2004 – Nov 2004

Responsibilities:

Worked as a Data Warehouse QA Analyst for EDW Application.

Informatica used as an ETL Tool. Cognos and Business Objects are used as reporting tools. Written SQL queries using TeraData SQL Assistant 6.2 to prove the data mapping and Reports.

Tested ETL (Informatica) mappings for each extract in the Informatica Designer and verified the session logs through Informatica Workflow Manager.

Tested the cube functionality by writing complex SQL queries in TeraData and verifying the results against the cube.

Involved in writing Test plan and Test cases.

Tested the cube functionality by writing complex SQL queries in TeraData and verifying the results against the cube.

Tested the Drill down functionality on each dimension and wrote numerous SQL queries to verify it

Used VSCC as version control.

Validated the fields within the Business Objects Universe to that of the corresponding fields within SAP.

Once get the needed data, generated reports for further Analysis.

Environment: Informatica power center 6.2.2,Unix (Solaris 5.8), Windows XP, COGNOS impromptu 7.1,Business Objects, Oracle, SQL, PL/SQL, Shell Script, VSCC (Visual Source Code Control)), SAP, Microsoft Excel, Business Objects 5.1,Queryman 6.0,WinDDI 5.0.1,Visio 2000, AutoSys, MS Word

Client: Solucient Baltimore, MD

Role: Data Warehouse Tester Mar 2003 – Jan 2004

Responsibilities:

Worked as a Data Warehouse Analyst for DW Application

Involved in Writing Test plan and Test cases.

Verified the Informatica Mappings (Source definitions, transformations, Target definitions, Connectors) which represent the data flow between source and target

Extensively tested ETL (Informatica) part, using SQL queries for consistency and errors while extracting / transforming / loading the data

Tested the data at both staging and data mart level

Worked with Visual SourceSafe as version control.

Identified and documented all issues and defects to ensure application software functionality.

Developed SQL queries using SQL Navigator to extract data from the target tables to prove the data mapping.

Scheduled Team Meeting to discuss the status of the Defects and Assign the New Defects to Concern person.

Environment: Oracle 9i,SQL Navigator 4.3, Informatica 5.x, Unix (Solaris 5.8), ASP, VB, Java, JSP, IIS 4.0, Rational Rose, SQL Server, SQL Analyzer, Windows XP, COGNOS impromptu 7.1,SQL, PL/SQL, Shell Script, Visual source safe (VSS), Test director 7.1, Microsoft Excel, MS Word.

Client: Bell South Birmingham, AL

Role: Data Warehouse Tester Jul 2002 – Feb 2003

Responsibilities:

Actively involved in creating Test Plans, Test cases and Test scripts based on the requirements submitted by the Business analysts.

Extensively tested ETL portion, using SQL queries for consistency while extracting / transforming / loading the data

Involved in both functional testing and GUI testing.

Worked extensively with harvest as version control as well as bug (DCR) reporting tool.

Developed SQL scripts using TOAD to extract data from the target tables to prove the data mapping.

Scheduled Team Meeting to discuss the status of the Defects and assign the new defects to appropriate team members.

Environment: WinRunner, Test director, UNIX, ASP, ASP. Net, VB, VB.Net, IIS 4.0, XML, UML, Rational Rose, SQL Server, Oracle 8i, Java, Sybase, JavaScript, JSP, Win2000/XP, TOAD, CCCHarvest (CVS), WebLogic 8.1

Client: C2 Technologies Chennai, India

Role: Test Coordinator Nov 1999 – Jun 2002

Responsibilities:

Created the Test Case requirements based on design documents

Formulated Test Plans, system Test Cases using MS Excel.

Wrote SQL queries to validate data in data warehouse and data mart.

Performed extensive testing of the data at both staging and data mart level

Performed White-Box Testing (Integration Testing and Unit testing) of the application

Documented the defects and reported to the QA lead.

Environment: Windows NT, UNIX, Java, Servlets, SQL, JDBC, JWS and Oracle

Education: Master of Computer Applications

Contact this candidate