PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
• Excellent knowledge in implementation of different QA methodologies/policies, strategies and plans in all stages of SDLC.
• Experience in testing Data warehousing Applications developed by Informatica, Ab Initio, Data Stage.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Responsible for coordinating testing throughout both systems ODS and EDW which were two different teams.
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Solid Back End Testing experience by writing and executing SQL Queries
• Extensive experience in Client/Server and Web Application testing using Functionality Testing (Black Box), Integration Testing, Regression Testing, UI Testing; Experience in End-to-End Testing, User Acceptance Testing (UAT), Performance Testing and SAP Application Testing.
• Excellent knowledge in test planning, coordinating, execution and leading the testing process.
• Tested various reports generated by Business Objects, Hyperion and Cognos.
• Experienced at testing ETL's and flat file data transfers without relying on a GUI layer.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage.
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Proficient in querying various RDMS like Oracle, Teradata, DB2 and SQL server.
• Tested the ETL Data Stage jobs and other ETL Processes (Data Warehouse Testing).
• Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
• Excellent knowledge of defect management and tracking using Quality Center.
• Personalized Cognos Connection for specified display options for testing regional options and rmation.
• Adept at backend testing and data validation testing using SQL queries
• Proficient in Functional, Negative, Regression, System, Integration, User Acceptance (UAT), Security, Usability and compatibility testing during the various phases of the development of the application.
• Experience in performing data validation and preparation of test data in UNIX environment using various UNIX commands and editors.
• Hands on experience in both Waterfall and Agile QA methodologies.
• Coordinated testing efforts and effectively managed Off-Shore teams.
• Self-conscientious starter, strong team skills and ability to lead a team toward achieving organizational objectives.

TECHNICAL SKILLS:

Operating Systems: UNIX, Linux and Windows 98/NT/2000/XP/7

Languages: SQL, PL/SQL, C, C++

RDBMS: Oracle 8i/9i/10g/11g, Teradata, IBM DB2, and SQL Server 2000/2005/2008

ETL Tools: Informatica 8.6.1, Ab Initio (GDE 1.15, Co>Op 2.15),Data stage.

BI Tools: Microstrategy, Business Objects XIR2/XIR3, Cognos and Hyperion

Testing Tools: Rational Clear Quest, HP ALM Quality Center 9/10

PROFESSIONAL EXPERIENCE:

Confidential, VA

Sr. ETL QA Tester

Responsibilities:

• Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
• Analyzed the Business Requirements Specification Documents and Source to Target Mapping Documents and identified the test requirements.
• Interacted with business users to analyze the business requirements and system functional specifications and prepared Requirements Traceability Matrix (RTM) documents to map the business requirements with the functional and technical requirements and test scenarios.
• SAP testing including best practices for test documentation, test tools, and test approach.
• Tested Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Involved in all phases of the QA Life Cycle and SDLC, with timely Delivery against aggressive deadlines, with QA methodologies such as Waterfall, Agile, Etc.
• Extensively used stages available to redesign Data Stage jobs for performing the required integration.
• Created Jobs to Schedule multiple reports in Cognos Connection.
• Attended daily Scrum Stand-ups for QA updates and defect status.
• Tested the source data for data completeness and data correctness.
• Evaluation of critical problems/issues during testing and reporting them in Quality Center.
• Tested the PL/SQL package that loaded data into staging from the source database.
• Writing complex SQL queries for checking the counts and for validating the data at field level.
• Prepared sample test data by inserting data into staging tables.
• Responsible for testing all new and existing ETL data warehouse components.
• Prepared all the test scenarios and shared across the team.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Well exposed to SDLC (Software Development Life Cycle) and Test methodologies.
• Tested the format of the reports according to the specifications provided and also compared the data in the reports with the backend data mart through SQL and also using excel for data comparison.
• Involved in Manual and Automated testing using QTP and Quality Center.
• Extensively used Cognos for report generation.
• Involved in end to end testing of the entire process flow starting from the source database to the target data mart to the reports by considering all possible scenarios.
• Tested and used PL/SQL to embed complex business logic in stored procedures.
• Prepared Test Plan and testing strategy for both ETL and BI testing needs.
• Co-ordinated with the offshore counter-part for testing needs and also gave KT sessions on the business requirements.
• Tested Operation Data Store process of ODS/DWL product.
• Was responsible for maintaining all the test cases and defects in HP Quality Center for all the team members to review.
• Involved in planning, designing, building, maintaining and executing tests and test environments at each point in SDLC
• Used Quality Center for defect tracking.
• Involved in unit, performance and integration testing of Data Stage jobs.
• Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
• Was the point of contact for the QA team for escalations and lead the bug triage meetings.
• Optimizing/Tuning several complex SQL queries for better performance and efficiency.
• Validated the production tickets assigned and once confirming the defect assigned it to the developer for fix.

Environment: Oracle 10g, Unix, Data Stage, Cognos, ALM/HP Quality Center 11, SDLC, Toad for Oracle, MS Office 2007, Windows XP

Confidential, Charlotte, NC

ETL/QA Tester

Responsibilities:

• Created test cases and test plans for user acceptance testing and system testing based on functional specifications.
• Written test cases for Data Stage jobs which were migrated to Informatica mapping.
• Used Data Stage Director to run and monitor the jobs for performance statistics.
• Good understanding of SDLC, CMM, IEEE, CMMI methodology.
• Reported bugs and tracked defects using Quality Center 8.2 (Test Director)
• Tested PL/SQL procedures that were developed to load the data from temporary tables in staging to target tables in the data warehouse
• Provided support to offshore QA team by giving them knowledge transfer and helping them with closure of the defects.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Performed data validation on the flat files that were generated in UNIX environment using UNIX commands as necessary.
• Proficient in SQL and PL/SQL coding.
• Tested complex reports with multiple data providers/different universes and databases (Oracle, SQL server, DB2).
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• In the pre initial load phase validated the data table additions and code tables based on Code table values document and the Source to MDM data mapping document.
• Implemented SDLC, QA methodologies and concepts in the Project
• Performed independent MDM services testing by preparing xml transactions.
• Tested the XMLs feeds received from another source which is a third party for data consistency.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Created custom defined queries using PL/SQL to test the data
• Responsible for QC support and ensuring that the SAP applications management services were delivered to meet the customers' business needs and expectations.
• Tracked defects to closure by coordinating with the dev team.
• Tested source data for data completeness, data correctness and data integrity. Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Performed manual testing on various modules of the Application
• Performed End to end testing starting from the source to the report.
• Executed SQL Queries to check table updates and data retrieval
• Created public folders, private folders, personalized pages and custom views on the Cognos connection portal.
• Conducted and coordinated integration testing and regression testing.
• Worked with leadership team to analyze current SDLC process and recommended process improvements.
• Wrote stored procedures using PL/SQL to implement the business logic
• Participated in business requirements gathering and in modifications of the requirements based on the scope.
• Written test cases for Data Stage jobs which were migrated to Informatica mapping.
• Tested the data consolidation for Master Data Management (MDM)
• Worked with the DSO team to understand the source to target mapping document and accordingly helped them to clean the source data to decrease the defects and to ensure that final data matches with the data warehouse standards.
• Designed and developed Test Plans, Test Scripts and Test Cases in HP Quality Center and executed them.
• Prepared test data to cover all the test scenarios.
• Tested and distributed the reports to the users via Cognos Connection validated all the applications and successfully executed and unit tested the jobs with Data Stage director.
• Maintained all the test cases in HP Quality Center and logged all the defects into the defects module.

Environment: SQL, PL/SQL, Data Stage, SDLC, HP Quality Center 10.0, SAP, XML, Oracle 10g, Data Stage, TOAD for Oracle, Cognos.

Confidential, Bloomington, IL

ETL Tester

Responsibilities:

• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Reviewed requirements for testability and usability, and consulted development staff with regards to system functionality.
• Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Data Stage.
• Worked on Cognos Framework Manager to import data from SQL Server Data source to create Models for reports and published packages to Report Net server.
• Tested the flow of data from front end to backend databases.
• Tested the real time updates happening in the databases through web services using SOAP UI.
• Tested the ETL processes that ran to load the data into the central repository.
• Develop, maintain and execute manual test cases.
• Performed smoke testing, Functionality testing, Integration testing, and Regression testing.
• Worked with Data Stage jobs and log files to monitor the test runs.
• Participated in review meetings for creating Test plan and test results summary.
• Analyzing business and functional requirement to design SIT and UAT Test Cases
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Tested cognos reports for verifying and validating the data. Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Participated to create Test Analysis reports(TAR)and stored them into the Quality Center.
• UpdatedRTMon daily basis, send status report and daily tracking report to test manager.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions.
• Participated in the meetings with business users to present future functionality of the application, gather information from them to know about their need and send this information to test manager.

Environment: SOAP UI, Java, J2EE, SQL Server /Oracle 9i, SQL, PL/SQL, Cognos, Windows XP, Test Director 7.6

Confidential, Caledonia MI

QA / Data Analyst

Responsibilities:

• Involved in Data Analysis and Database Designing.
• Involved in identifying data from BRD to Develop LDM, PDM by studying Data Flow diagrams and State Transition Diagrams.
• Used MS Visio to develop the database design.
• Extensively involved in developing Data Dictionary.
• Created tables and various database objects.
• Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Involved in performing validation of datasets, tables and triggers by performing White Box Testing and code walk-through.
• Performed Data Profiling to improve search abilities by using tags and aliases.
• Dynamically adjusted price breaks in accordance with client pricing groups and allowed editing/addition of customer information to rapidly assemble on-screen, printed and database-recorded quotes.
• Developed test reports and participated in testing prioritization and archived test results and user signoff
• Involve with Design and Development team to implement the requirements.
• Performed execution of test cases manually to verify the expected results.
• Involved in creation of tables, writing stored procedures and Triggers.
• Developed user interface screens using VB, ADO to connect to backend and stored procedures to manipulate data.
• Handling user defined exceptions.
• Involved in testing, implementation & maintenance.

Environment: MS Visio, Crystal Reports 9.0, Metadata Repository, Visual Basic 6.0, SQL Server 2000, SQL, T-SQL, UNIX and Windows NT.