SUMMARY:

• 7+years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, UNIX & OLAP.
• Extensive testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager) & SSIS 2008.
• 6+years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, UNIX & OLAP.
• Experience in Manual and automated testing tools like Quick Test Pro (QTP), Load Runner, Quality Center/ Test Director and Clear Quest.
• Experience in testing and writing SQL, T - SQL and PL/SQL statements.
• Have been involved in several upgrades of PeopleSoft People Tools and HCM, CRM, ELM and Financials applications.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
• Experienced in configuration management using Visual Studio Team System (VSTS), Team Foundation Server (TFS), VSS and Subversion.
• Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
• Strong experience with ETL systems, and having expertise with tools Informatica and Data stage.
• Did extensive Front-End Web Testing using QTP and Quality Center.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Created and Developed Reports and Graphs using ALM.
• Extensively used DB2 Load Utility for data retrieval/loading from and to DB2.
• Strong knowledge of Business Intelligence, Data Warehousing and Business Architecture.
• Performed Unit, Integration and System Testing.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
• Experience in Star and Snow Flake Schemas.
• Strong experience in testing tools like Test Director, Quality Center, Quick Test Pro and Test Track Pro.
• Strong understanding of Software Development Life Cycle (SDLC) and Strong Knowledge of relational database design.
• Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
• Excellent written and oral communication skills and a team-player with a results-oriented attitude

TECHNICAL SKILLS:

Operating Systems: Windows XP, Window 2000, MS-Dos, OS/400, UNIX

Languages & Software: Java2.0, SQL, J2EE

BI and ETL Tools: IBM Data Stage 8.0, Informatica 9, 8.1, SSIS 2008, Cognos

Others: MS Project, Visio, MS Office, MS Excel

Testing Tools: HP Quality Center 9.2 / 10 / ALM, TFS, JIRA, Clear Quest, Rational Clear Case

Databases: Oracle 9i/10g / 11g, DB2 8.0, MS SQL Server 2012/2005, Teradata 13

PROFESSIONAL EXPERIENCE:

Confidential, Apple Valley, MN

Sr. ETL Data Ware QA Analyst

Responsibilities:

• Participated in analysis of functional requirements
• Involved in designing and Preparing Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance.
• Used Jira as Bug management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.
• Preform validation of Nextera reports which Involves ISR, Roster, Student labels, as well the printed Reports and Reports which are included as part of hard drives.
• Involved in developing scripts to validate all the reports used in Assessment which involved multiple data bases (Reporting, Scoring and Test path)
• Worked with state department of education for AR, NE KS, NY and TN for providing the detail reports for almost 3 million student from each state for hassle free progress for parents and students.
• Worked with Datamart which pulls all the data from the Testpath, Reporting and Scoring databases to produce the final Reports.
• Worked on SSIS 2008 to validate all the tables of the Datamart for Nextera Reports. Included the database sources and the hash keys to identify the missing records from the source and the target Datamart tables
• Tested Nextera Reports to make sure the all the reports are according to the standard of state department of education which are specific to each state.
• Interacted with Developers and Business Analyst for Defect analysis and performed Regression Testing in all the environments.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations within an ETL process testing cycle.
• Performed different phases of testing like Smoke testing, Sanity testing, Functional testing, UI testing, Integration (End-to-End) testing, Regression testing.
• Rigorously performed Regression testing for every modification/enhancement of the project.
• Used SQL Server Management studio in creating & executing SQL queries for testing ETL process.
• Worked on issues with migration of Data from development to QA-Test Environment
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Involving in Performed Count Validation, Excel for Data Validation, Beyond compare for comparing the state data files.
• Maintained Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result to ensure complete test coverage.
• Contribute in the development of knowledge transfer documentation.

Environment: SSIS 2008, Microsoft SQL Server management Studio, Test Plan, Test Strategy, Jira, Agile, Test Cases, QTest, Confluence, Nextera (Reporting and Scoring) and Microsoft Office tools.

Confidential, Union, NJ

Sr. ETL QA Data Warehouse Test Analyst

Responsibilities:

• Worked alongside with Support team in training the operation manuals and helped with Root Cause Analyses and solutions recommendations.
• Worked as Environment Manager as well as interim Release Manager providing appropriate Release Schedules as required for project.
• Involved in extensive DATA validation, data verification and data conditioning using T-SQL queries and back-end testing
• Facilitate overall development and quality assurance (QA) efforts associated with upgrade and customization of PeopleSoft ERP applications.
• Designed FTP process to post files to PeopleSoft System
• Extensively developed SQL Queries using Rapid SQL to test the business process of financial accounting modules to PeopleSoft.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Attended business meetings to gather the requirements and fill in the gaps in present requirements.
• Delegated QA meetings with the team and Project Management and Attended team meetings, product walkthrough’s and review meetings.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata
• Involved in Test plan, Test case preparation and assigning defects through TFS(Team Foundation Server)
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Written several complex SQL queries for validating Cognos Reports.
• Developed test plan and Responsible for creating Test Strategy for the Data Warehouse and the reporting modules.
• Extensively used Informatica client tools. The objective is to extract data stored in Oracle database, flat files to load finally into a single data warehouse repository, which is in Oracle.
• Wrote Test cases in ALM and Defect report generation using ALM (Application Life cycle Management)
• Used SOAPUI for web services validation for SOA architecture.
• Written many test cases and test procedures using MS Excel and exported to Quality Center
• Initiated the QA process in the project along with team lead and acted as QA point of contact to the team.
• Performed different phases of testing like Smoke testing, Sanity testing, Functional testing, UI testing, Integration (End-to-End) testing, Regression testing.
• Rigorously performed Regression testing for every modification/enhancement of the project.
• Strong in writing complex SQL queries to profile and analyze the data in Oracle 10g.
• Defect tracking and Defect Report Generation are prepared using ALM and Quality Center
• Expert in working Star and Snow flake Schema dimension modeling.
• Used different Querying tools like Advanced Query Tool v8.2.5, Toad 9 to query different databases.
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Logged numerous defects, Work Items and Regression Test Suites for the project in to Version One Enterprise.
• Used T-SQL for Querying the DB2 database.
• Involved in testing the Cognos reports by writing complex SQL queries
• Created and Developed Reports and Graphs using ALM.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.

Environment: Informatica 9.1/8.6.1, SQL, Test Plan, Test Strategy, ALM / HP Quality Center 11.0, T-SQL, Cognos v8.4 Reports, Test Cases, TFS, Oracle 10g, Toad 9 for Oracle, Teradata 13, DB2, Advanced Query tool 8.2.5, PUTTY, and Microsoft Office tools

Confidential, Mount Laurel, NJ

ETL QA Data Warehouse Test Analyst

Responsibilities:

• Participated in analysis of functional requirements
• Extensively interacted with developers, business& management teams to understand the MedInsight Implementation Project business requirements and ETL design document specifications.
• Involved in designing and Preparing Test Plans, Test Cases, Test Scenarios and Test Strategies, Defect Management to ensure Quality Assurance . - MedInsight Implementation Project
• Used ALM (Application Life cycle Management) as test management tool to manage and organize Requirements Coverage, Test Cases, Test Scripts and Creation of defects.
• Manually performed Ad-Hoc testing.
• Involved in data conversion validation of PeopleSoft HCM application from Informix to Oracle
• Worked with users to analyze their needs to successfully develop PeopleSoft modules.
• Produced SQL periodic and ad-hoc reports off PeopleSoft and data warehouse.
• A test reporting environment was established to combine Distribution Work Management and PeopleSoft information into a consolidated place to allow combined reports to be generated.
• Tested Cognos reports to check whether they are generated as per the company standards
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Coordinated with Developers for Defect analysis and performed Regression Testing.
• Developed SQL queries /scripts to validate the data such as checking duplicates, null values, truncated values and ensuring correct data aggregations within an ETL process testing cycle.
• Performed different phases of testing like Smoke testing, Sanity testing, Functional testing, UI testing, Integration (End-to-End) testing, Regression testing.
• Rigorously performed Regression testing for every modification/enhancement of the project.
• Used TOAD for Oracle and Oracle SQL Developer in creating & executing SQL queries for testing ETL process.
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Worked on issues with migration of Data from development to QA-Test Environment
• Tested ETL’s to ensure that the source and the target are mapped as per the Requirements/specifications.
• Involving in Performed Count Validation, Excel for Data Validation in Data Migration pivot tables.
• Maintained Traceability Matrix for each entity and marking down Test requirement, Test Head line, Actual result & Expected result to ensure complete test coverage.
• Contribute in the development of knowledge transfer documentation.

Environment: Informatica 9.5, SQL, Cognos 10.1 Series, PeopleSoft HCM, Test Plan, Test Strategy, ALM / HP Quality Center 11.0, Agile, Test Cases, SQL Developer Oracle 11g, Toad 9 for Oracle, DB2, Advanced Query tool 8.2.5, PUTTY, and Microsoft Office tools.

Confidential, Denver, CO

ETL QA DWH Test Analyst

Responsibilities:

• Worked alongside with Business Analyst and Technical Architect in Analysis of Business and Functional requirements.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Attended Client meetings to gather the requirements and fill in the gaps in present requirements.
• Delegated QA meetings with the team and Project Management.
• Attended to team meetings, product walkthrough’s and review meetings.
• Worked with business team to test the reports developed in Cognos
• Involved in testing the Cognos reports by writing complex SQL queries
• Supported in QA activities in couple of enhancement projects apart from my designated responsibilities.
• Developed test plan and Responsible for creating Test Strategy for the Data Warehouse and the reporting modules.
• Reported the Bugs/Defects using TFS defect management tool.
• Used T-SQL for Querying the DB2 database in UNIX environment
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes.
• Used Quality Center to track and report system defects
• Written many test cases and test procedures using MS Excel.
• Initiated the QA process in the project along with team lead and acted as QA point of contact to the team.
• Worked on various data feeds like Text, Csv, XML, EDI, etc.
• Used SQL Server Integration Services 2008 to run various ETL jobs and read the logs for warnings/errors.
• Tested various Prompted reports, Summary & Detail reports, Drill down reports, Drill through reports, Ad-hoc reports.
• Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
• Tested different Cognos OLAP Cubes using Analysis Studio and validated them against the Cube ETL loaded data in the Datamart.
• Acted as single point of contact for the Reports Development team in creating test data for the Unit testing of the Reports, Query subjects and Cubes.
• Initiated Defects review meetings with Developers and communicated with them for whole defect life cycle until the logged defect is closed and verified.
• Mentored new QA resources to understand the business process and our test methodologies.

Environment: Informatica Power Center 8.6.1, SQL, Teradata 13, Test Plan, Test Strategy, Test Cases, Microsoft SQL Server Integration Services 2008, TFS,IBM Cognos v8 Reports, Quality Center, T-SQL, Cognos Query Studio, Cognos Analysis Studio, IBM UDB DB2 v9, SQL Server 2005/2008, Toad for DB2, Quest Central for DB2, PUTTY, Microsoft Office tools.