SUMMARY:

• Experienced DWH, ETL and BI Lead/Tester/Analyst with strong background in design, development, and support of databases and information products as well as data analysis / reporting / processing
• Over 11 years of experience in Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server, and Mainframe applications
• Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch
• Experienced in testing Web applications and client/server applications
• Analyzed requirements, use cases and technical specifications to develop Test Plans, Test Cases
• Experienced in coordinating resources within onsite - Offshore model
• Extensive experience in testing Business Intelligence (BI) reports using various reporting tools like Micro strategy, Cognos Report Net and Business Objects
• Solid Back End Testing experience by developing SQL queries for complex business logics and executing them
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica, DataStage and Ab Initio
• Experienced in working in Agile Scrum, Agile XP, Waterfall, and SDLC methodology environments
• Extensive working experience in RDBMS technologies like Oracle 8.x/9.x/10g/11g, DB 2 8.0/7.0/6.0 , MS SQL Server 2008/2005/2000/7.0/6.5 , Dbase, Excel and MYSQL. SQL Developer, TOAD, SQL Plus, Win SQL, Quest Central for DB2
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica, Data Stage and Ab Initio
• Expertise in testing complex Business rules by creating mapping and various transformations
• Experienced in working with HP ALM 11.x, Quality Center 10.0, Rational Clear Quest & Test Director
• Excellent understanding and expertise in writing complex SQL (DDL, DML and DCL) queries to perform back-end testing
• Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management
• Experienced in running SQL queries using Toad and SQL Server
• Experienced in Performance Tuning of SQL and Stored Procedures
• Extensive experience in manual testing the ETL and Business Intelligence Applications
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse
• Developing and Delivering System Documentation and Training; Testing and Auditing
• Excellent problem solving, interpersonal, and communication skills

TECHNICAL SKILLS:

ETL Tools: Informatica 9.1/8.6.1/8.1/7.1/6.2/6.1/5.1 , Data Stage 9/8.1, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS

Testing Tools: Quality Center, Win Runner, Test Director, Load Runner, QTP, Manual Testing, Rally, HP ALM 11.5.2

Database Management: Oracle 8i/9i/10g/11g, SQL Server 2000/2005/2008 , MySQL, ODBC, DB2, TOAD 8.5, MS Access, Teradata V2R5/V2R6

Reporting Tools: Cognos 8.0 Series, OBIEE, Business Objects 5.1 /6.1/XIR2

Operating Systems: Window 2003 Server, Windows 2000 Advanced Server, Windows 98, Windows XP, Linux and UNIX(AIX), MVS

Version control: Visual Source safe, WINCVS, PVC

Web Programming: HTML, XML, JSP, Java Script

Programming languages: C/C++, PL/SQL, VB 6.0, COBOL, CICS, JCL

PROFESSIONAL EXPERIENCE:

Confidential, Mount Laurel, NJ

ETL QA Lead /Data Warehouse QA Lead

Responsibilities:

• Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from other technical teams
• Developed test scripts based on business requirements and processes, in line with defined workflows and use cases
• Involved in extensive DATA validation on multiple data marts by using SQL queries for Data Migration Project
• Ensuring smooth onsite to offshore transition of requirements and conducting knowledge transition sessions
• Responsible for creating manual test scripts to include Functional Test, Regression Test, Compression test, UAT, Data Migration Test and Study Configuration Test
• Hands on experience in ETL Automation testing using DVO
• Attended Daily status meetings / Defect review meetings
• Performed System Testing, Regression Testing, Performance Testing, end-end testing and Production Smoke Test
• Coordinated component, system testing with the appropriate technical groups and Release Management and documented test procedures and findings
• Wrote SQL scripts to perform database testing and to verify data integrity
• Reconciled test results from different tests and different groups
• Responsible for testing workflows using Informatica (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Worked on profiling data for understanding the data and mapping document
• Used TOAD Software for Querying Oracle DB.
• Involved in loading Test cases to HP ALM through Excel and test case execution, defect Tracking and generating test reports
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance
• Involved in creating SQL script Framework to perform data lineage traceability testing on Schedule D Monthly submission files
• Involved in validating Financial regulatory report that are being submitted to Fed
• Wrote Complex SQL queries for all four portfolios like USBC, Target, VPLS and NCS to validate Schedule D submission files against Argus Data Warehouse raw data based on CCAR Business requirements
• Hands on experience in Axiom tool to validate Auto and Manual submission files for both monthly and quarterly for different source systems
• Worked with business team to understand the process involved in Financial Schedule submission files and performed traceability testing for different Schedules
• Coordinated within onsite and offshore and provided KT to offshore as and when needed
• Held daily status meeting with offshore to get status of the project work
• Prepared and ran regression scripts, and performed sanity tests and end-end testing
• Conducted Data Migration and Data Cleansing
• Tuned ETL scripts, SQL queries, PL/SQL procedures to improve the system performance
• Performed the tests in SIT, BAT, PAT and contingency/backup environments

Environment: Informatica 8.6/9.1, DataStage v9.0, MS SQL Server 2008, Oracle 10g/11g, PL/SQL, TOAD, SQL Developer, Linux, Waterfall, HP ALM, Axiom, DVO, MS Excel

Confidential, Roseland, NJ

ETL QA Lead/ Analyst

Responsibilities:

• Involved in Business analysis and requirements gathering
• Developed Validation plan and Quality summary report for the project
• Drafted test plans based on test strategy. Reviewed, created and executed test cases and test scripts based on test strategy and test plans based on Product Requirement Document
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Reviewed project test artifacts and coordinated with onsite Clients, onsite Project Leads and local reporting Managers
• Created Regression Test cases and automated them for the purpose of regression testing using QTP
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Responsible for testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing
• Worked in an Agile technology with Scrum. Conduct QA scrum call to gather status of the offshore team
• Communicated or transitioned the project details to offshore as and when needed
• Provided QA testing timelines understanding the project requirement and scope of testing
• Effectively communicated testing activities and findings in oral and written formats
• Extracted data from various sources like Oracle, flat files and SQL Server
• Involved in Performance testing to ensure the load and stress capability of the application
• Validated documented user requirements
• Written several complex SQL queries for validating Cognos Reports
• Prepared daily status reports and defect reports
• Wrote SQL scripts to perform database testing and to verify data integrity
• Focused on Data Quality issues, problems that include completeness, conformity, consistency, accuracy, duplicates, and integrity
• Extensively worked on designing various output and management reports Using SQL Server
• Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and populate the Data Warehouse
• Tested the outgoing links from all the web pages from specific domain
• Created Short-cut joins, aliases and contexts to make the universe loops free
• Hands on experience in Test management tool Rally by creating test cases for the user stories, test case execution and, logging defect for the failed test cases
• Tested and worked on creating open document reports for business
• Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues
• Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
• Involved in testing the Cognos reports by writing complex SQL queries
• Optimizing/Tuning several complex SQL queries for better performance and efficiency
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables
• Worked on issues with Migration from development to testing
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data
• Analyzed test cases for automation and created scripts for regression testing using QTP
• Automated Test cases for the purpose of regression testing
• Managed and executed the test process, using Agile Methodology. Reviewed the test cases and bug reports

Environment: Informatica 8.6.1/8.1, MS SQL Server 2005/2008, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Linux, Unix, Agile, Remedy, Rally, Cognos, WEBLOAD

Confidential, Montvale, NJ

ETL QA Lead/ Data Warehouse QA Lead

Responsibilities:

• Developed and Designed Test Cases based on the Business requirements
• Written several complex SQL queries for validating Cognos Reports
• Extensively tested the reports generated in Cognos by writing SQL queries to validate the data on the report and compare with the Data Warehouse data
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks
• Written several complex SQL queries & PL/SQL stored procedures for validating Cognos Reports
• Used SQL for Querying the database in Linux environment for testing the business rules imposed on data movement with Ab Initio ETL tool
• Used the ETL processes of Ab Initio tool to load data from MS SQL Server and Oracle, into the target Oracle database
• Attended walkthrough meetings with the Business Analysts and development to get a clear understanding of the business and the applications being used in house
• Prepared Traceability Matrices to track the requirements with the test cases and make sure none of them have been missed
• Developed automation test scripts to test the database by retrieving the data from the tables using HP QTP 10 and VB Scripting
• Validated that design meets requirements and function according to technical and functional specifications. Performed all aspects of verification and validation
• Used HP Quality Center 9.2 to state requirements, business components, test cases, and test runs for every iterations and, defects. Also link defects with requirements
• Involved in recording change requests on the Change Request Form (Remedy) Participated in meetings
• Worked with other members of the QA and Development teams and offshore team in improving the processes, methods, effectiveness and efficiency
• Generate data requirements and system specifications in an organized fashion for business solutions and for the developers to follow on
• Worked with business team to test the reports developed using Cognos
• Used TOAD & SQL Navigator GUI tools for Querying Database
• Participated in walkthrough and defect report meetings periodically
• Documented and reported various bugs during the Testing process
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables
• Tested the Front-End Web Applications developed in J2EE for data portal for matching
• Retested the resolved defects/issues after the developers fix the defects
• Involved in preparing test data for UAT and participated in UAT signoff
• Prepared strategies for analyzing the data for ETL Team
• Worked in a hybrid (Agile & Waterfall) methodology
• Involved in testing the Cognos reports by writing complex SQL queries
• Created and executed SQL queries in ORACLE and MS SQL server
• Updated the status of the testing to the QA manager, and accomplished tasked for the assigned work to the Project Management team regularly

Environment: Cognos 8.x, Ab Initio, MS SQL Server 2008, Oracle 10g, PL/SQL, TOAD 8.0, SQL, Agile, Remedy, Test Director/Quality Center, Power Connect, PowerAnalyzer4.1

Confidential, Richmond, VA

ETL QA Tester

Responsibilities:

• Developed detailed Test Plan, Test strategy, Test Data Management Plan, Test Summary Report based on Business requirements specifications
• Provided support to sales team management and sales operations support groups in the receipt, warehousing and reporting account level sales information
• Extremely involved in using Test Director for identifying the bugs with the help of SQL queries
• Involved in understanding the Requirements of the end Users/Business Analysts and Developed Strategies for ETL processes
• Responsible for Mini specifications document that describe the functionality of each subject area
• Used T-SQL for Querying the SQL Server database for data validation and data conditioning
• Reported software mismatches (from the test planning), to the development team using Quality Center
• Implemented Database Checkpoints for Back-end Testing
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Managed and executed the test process, using Waterfall Methodology
• Analyzed the Data Dictionary developed by the Systems Analyst for developing test scripts to test the Policy and Claims systems
• Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
• Extensively used Informatica Power Center 8.1.1 to load data sourcing from Source to Target databases
• Executing ETL - Informatica Workflows for updating test Databases from the Production servers
• Worked rigorously with developers to create test scripts in regards to the Informatica ETL
• Used Quality Center to track and report system defects
• Tested all the internal links and tested links jumping on the same Web page
• Tested several reports developed in MS Reporting Services which were migrated from Business Objects XI R2

Environment: Informatica 8.1.1, Business Objects Xi R2, Windows XP, Oracle10G, Sybase, IBM DB2, TOAD for Oracle, UNIX, MS SQL Server 2008, Reflections, Waterfall, Mercury Quality Center.

Confidential

QA Tester

Responsibilities:

• Created test plan, test strategy, test cases and successfully tested Registered Savings Plan (RSP) applications project
• Validated all batch and online programs and documented the test results
• Validated and tested all VSAM files which is flowing to DB2 to ensure the data integrity and formats
• Evaluated and tested various common modules and CICS programs for the RSP rewrite project
• Identified the predecessors, successors and other dependencies of the jobs and scheduled them
• Involved in monitoring the DB2 Data loading jobs and checked the accuracy of the data loaded into the tables
• Tested COBOL batch programs that generate Critical Reports for the usage of the Clients
• Involved in Unit, System Integrated Testing (SIT) and participated in User Acceptance Testing (UAT)
• Worked closely with product specialists in reviewing test results
• Involved in the preparation of test plans, test data, test cases and documenting test results
• Executed test cases and tracked the defects

Environment: IBM-MVS, OS/390, COBOL, JCL, CICS, DB2, VSAM, PANVALET, SPUFI, QMF, XPEDITOR, Intertest, File-Aid, SYNCSORT, In-house Utilities.