SUMMARY AND BRIEF PROFILE:

• 8 years of IT experience in the Testing, Analysis, design, and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, UNIX & OLAP.
• Experience in Web, and Client - Server Systems and Applications for Insurance, Banking and Retail Industries.
• Good experience in Client/Server, Reporting, Database, Data Warehouse and Web based applications with manual testing and using automated testing tools.
• Extensive experience in Backend Testing. Ability to implement Best QA Practices and process. Prepared detailed Test Summary report.
• Involved in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
• Highly experienced with different RDBMS and No SQL DB such as Oracle, MS SQL Server, Hadoop, MongoDB, Cassandra, Talend, Teradata and Mysql
• Extensive Experience in creating Test Cases, Test scripts, Test Strategies and Test Plans based on FSD’s, BRD’s & Use Cases.
• Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate-wide-ETL Solution using Informatica (IDQ, DVO), Ab Initio, Data Stage and SSIS
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Strong Business and Functional exposure on various business applications including Financial and Healthcare.
• Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
• Strong Data Querying/SQL and UNIX Shell Scripting skills. Possess excellent skills in Manual Testing and automated testing.
• Writing and Executing Test cases & defect tracking using Quality Center. Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, database testing and regression testing.
• Experience working with different automation tools like QTP, Selenium, Java and Load Runner.
• Experience in processing and validating data in flat files as well as in DB tables.
• Compatible to work in Agile environment. Excellent concept of ETL, Data warehousing and BI applications integration.
• Good experience in working with onsite-offshore team model projects. Ability to Prioritize Work, Good Analytical, Trouble shooting and Problem solving Skills.
• Having Strong Leadership, handling multiple tasks and Time management skills. Work Independently, Creative, highly motivated, and hard working with good interpersonal skills.
• Ability to interact with end users, also quick learner and team player with good communication skills.

EXPERIENCE PROFILE:

Confidential, Burlington, VT

Sr.QA Tester/ETL/Manual/Automation/Web

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Involved in extensive DATA validation using SQL queries and back-end testing
• Developed test cases for ETL process and reporting. Used SQL for Querying the database in UNIX environment
• Involved with Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Involved in Extensive Manual Testing using Quality Center.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Tested and developed the mapping for extracting, cleansing, transforming, integrating, and loading data using ETL Informatica. Tested SOA security with limited access to communicate between the services
• Used TOAD, DB Artisan tools to connect to Oracle Database to validate data that was populated by ETL applications
• Involved in testing Unix Korn Shell wrappers to run various ETL Scripts to load the data into Target Database (Oracle). Created test cases and executed test scripts using Quality Center.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Prepared test strategy to validate Teradata reports against Oracle reports. Defined the Scope for System and Integration Testing. Documented and published test results, troubleshooting and escalate issues
• Preparation of various test documents for ETL process in Quality Center. Involved in Test Scheduling and milestones with the dependencies.
• Used Toad to write SQL and query Oracle database. Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Created and executed test cases for ETL jobs to upload master data to repository. Responsible to understand and train others on the enhancements or new features developed
• Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
• Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
• Used Informatica Power Center Workflow Manager to run the workflows. heterogeneous
• Conducted white Box Testing - Functional, Regression and Data Driven. Verification of test results, comparing and analyzing.
• Used SDK to validate reports for Cognos Report Net and Cognos8 SDK. Wrote test cases based on ETL mapping document for testing the entire ETL workflow.
• Extracted data from different systems into source. Mainly involved in ETL development. Participated in the review meetings to resolve the issues.
• Worked with non-transactional data entities of multiple data feeds for reference data and Master Data Management (MDM)

Environment: Data warehouse ETL Informatica Power Center 8.6.1, QTP 9.2, Quality Center 9.2, Oracle 10g, Toad, XML, Windows XP, J2EE, HTML, SQL, SOAPUI, AutoSys and Cognos.

Confidential, Burlington, VT July

Sr.QA Tester/ETL/Manual/Automation/Web

Responsibilities:

• Participated in all meetings with project team members on Overview and Architecture.
• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Worked on testing data migration, data integration and data transformation.
• Written test cases to validate the ETL Informatica mappings and mapplets. Executed SQL queries using TOAD to query Oracle database.
• Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts. Used SQL Assistant to write SQL and query the Teradata database tables.
• Created complex SQL queries to validate the initial and incremental ETL loads. Used PL/SQL function to validate some test scenarios.
• Tested both multi-protocol and multi-party processes. Worked with UNIX commands like GREP, LESS and Diff.
• Tested several Informatica Mappings to validate the business conditions. Written positive and negative test cases for Cognos reports based on report specifications.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Validated several Drilldown and Pivot reports published in Cognos Scoreboard. Worked on testing report filter and view filter in Cognos reports.
• Worked with non-transactional data entities for multiple feeds of reference data using MDM
• Validated Prompts, filters, calendars and Cosmetics in reports. Participated in Project Status meetings and updated QA status and defect status.
• Used Quality Center to document and open defects and track them from time to time. Interacted with developers to resolve the ETL and reports defects.

Environment: Data warehouse ETL Informatica 8.1, BI Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, Oracle 10g, SQL, TOAD 10, SQL Developer, SQL Assistant, SQL Plus, Unix, Quality Center 9.0.

Confidential, Burlington, VT

QA Tester

Responsibilities:

• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Written SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity. Responsible for monitoring data for porting to current versions.
• Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed with developers to resolve the bugs.
• Perform full manual regression testing of MDM. Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Validating the reporting objects in the reporter against the design specification document.
• Involved in testing the Cognos reports by writing complex SQL queries. Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided that satisfies the transformation rules. Developed XML test files based on XML schema.
• Used TOAD & SQL Navigator GUI tools for Querying Database. Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested Canned/Ad-hoc reports using Cognos Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Responsible for reporting and escalating data issues arising from project or daily support.
• Performed Black box Testing, Regression and end-to-end testing. Developed/revised training documentation and procedure manuals.

Environment: Data warehouse ETL Informatica, SQL, PL/SQL, Mercury Quality Center, TOAD, Rational Clear Quest, MS Excel, XML, Cognos and Teradata.

Confidential, South Burlington, VT

ETL QA Tester

Responsibilities:

• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Involved in conducting the Functional, Regression and Integration testing.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensive experience in testing SQL Server and Oracle databases, involved in testing back end jobs using SQL queries.
• Wrote test cases for testing the project, ensures that the components of the system successfully integrate and function together
• Executed test scripts using QTP, analyzed the results & reported bugs using Quality center. Tested all the Informatica jobs and ETL flow for data validation.
• Wrote test cases based on ETL mapping document for testing the entire ETL work flow.
• Extracted data from different systems into source. Mainly involved in ETL development.
• Tested Complex Data warehouse ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested all the backend programs, Data warehouse ETL Informatica Mappings and update processes. Helped the System test lead in developing the Test Plan and Testing Strategy for DWH ETL/BI
• Tested the Data warehouse ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Validated BO Reports and Universes against Data warehouse/Data mart Database by writing SQL Queries
• Actively interacted with developers to resolve technical issues. Performed regression testing following the framework migration from JSF to struts
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database.
• Identified bugs and interacted with team lead and developers to resolve the bugs

Environment: ETL Informatica, BI Business Objects, Oracle 9i, RAD, Java, Struts1.1, JSF, QTP 9.0, Quality center, Solaris, Windows XP.