PROFESSIONAL SUMMARY:

• Over 6 years of extensive experience in Quality Assurance testing of data warehousing and Business Intelligence processes, Web Based and Client/Server applications.
• Possess excellent knowledge & experience in providing data warehousing solutions and data warehouse concepts.
• Hands on experience on ETL tools in ETL process development, testing and in maintaining ETL codes.
• Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
• Performed test planning, test execution, test data, test coordination, configuration management and defect management areas for the web based, middleware and mainframe applications
• Excellent experience in Quality Assurance and testing, worked as ETL Tester, BI Tester, Data Tester and QA Analyst.
• Solid Back End Testing experience by writing and executing SQL Queries.
• Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, RUP
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• In depth technical knowledge and understanding of Data Warehousing, Data Validations, OLAP, SQL Server, Oracle and ETL.
• Extensive experience in RDBMS technologies like Oracle 8.x/9.x/10g, DB2 9.1/8.0, Teradata V2R6/V2R5, MS SQL Server, Excel and MYSQL, SQL Developer, TOAD, Quest Central for DB2.
• Experienced in testing Cognos and Business Objects reports.
• Four plus years of experience in Business intelligence reporting tools using Cognos Series 8.x/7.0, Power play, Transformer, Impromptu Web Reports (IWR), PowerPlay Enterprise Server, and Business Objects XI R3/R2.
• Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
• Worked with Functional /Testing tools as QTP, Quality Center, Test Director, Rational ClearQuest
• Experience in Mercury Quality Center - Design Test Steps, Requirement Mapping to Tests, Executing Tests Manually, Defect Logging, Defect Reporting
• Excellent Communication, Analytical and Interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/7.x (Repository Manager, Designer, Workflow Manager, Workflow Monitor)/6.2(Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager. Repository manager administration), Power Mart 6.2, Data Integrator, Data Mining, OLAP, OLTP, SSIS, Data Stage 8.1, Ab Initio (GDE 1.15, Co>Op 2.15)

BI & Reporting: Business Objects XIR3/R2, Cognos 8 series, Power play, Report studio, Query studio.

Testing Tools: Load Runner 8.1, QTP 8.2, RFT 6.1, Test Director, Quality Center 9.2.,Jira

Databases: Oracle 10g/9i/8i/7.3, MS SQL Server, IBM DB2, Teradata V2R6, MS Access 2007 and MYSQL

Job Scheduling: Appworx, Autosys, BMC Control M, Maestro

Operating System: UNIX (Sun Solaris 9.0/8.0/7.0, HP-UX 11i v1.5/1.6/2.0, IBM AIX),WINDOWS 95/98/2000/NT/XP, Linux,MS-DOS

Languages/Tools: CVS, VSS,SQL, PL/SQL, SQL Developer, TOAD, SQL Assistant, UNIX shell scripts, PERL, XML, SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

UAT Tester

Responsibilities:

• Participating in requirement walkthroughs and creation of test plan.
• Writing Test Cases from the Test Plan and manually tested the application.
• Participating with users in understanding the business requirements.
• Executing test cases in Quality Center.
• PL/SQL queries were written to perform operations like joins in the source database.
• Retrieving records from multiple tables from Oracle Database through SQL by using joins such as Inner Joins, Outer Joins using Oracle.
• Creating and executing SQL queries to perform testing using SQL to test Oracle Database to validate and test data using TOAD.
• Tracking, reviewing, analysing defects in the application using JIRA a defect tracking tool throughout the bug life cycle.
• Working on Informatica Power Center to check the log files.
• Manually conducting Positive Testing / Negative Testing.
• Performing Regression Testing after bug fixes or system enhancement.
• Performing Integration testing and Configuration testing.
• Performing User Acceptance Testing (UAT).
• Involving in job scheduling using Autosys.
• Extensively working in the Unix Environment using Shell Scripts.
• Documenting defects in Quality Centre.
• Using JIRA as well for story writing and defect tracking.
• Attending the Weekly meeting.

Environment: Informatica 10.2, UNIX, ALM/Quality Center, JIRA, Autosys, Toad 12.10, PuTTY, Oracle Client 12.1.0

Confidential, Providence, RI

ETL/QA BI Tester

Responsibilities:

• Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
• Created complex SQL queries for querying data against different data bases for data verification process.
• Conducting detailed and keen reviews on every deliverable like Test Cases, Defect reports and Test summary reports.
• Coordinating with QA Lead/Managers and resolve issues that occur during all phases of testing.
• Tested new Data migration tool used in the mapping of data to new system.
• Data migration of raw data to excel documents for clients
• Attend daily status calls with customers and provide status on testing progress and provide Test status & Defect status reports.
• Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards.
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Tested Complex 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.
• Extensively used ETL methodology in testing for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL solution using ETL tools like Informatica
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
• Developed and Performed execution of Test Scripts manually to verify the expected results.
• Validated that application meets requirements and functioning as per the technical and functional specifications.
• Performed monitoring of the ETL jobs (Extraction, Transformation and Loading) by using Informatica power center Work Flow monitor.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Tested the ETL mappings and other ETL Processes (Data Warehouse Testing)
• Written several complex SQL queries for validating Business Reports.
• Tested several stored procedures.
• Worked with business team to test the reports developed in Cognos
• Trained the users before UAT on how to test and document the test results. Also, assisted the users during UAT. Took part in Triage Meetings with the required parties after defect analysis to prioritize defect resolution.
• Used Informatica ETL tool for Extraction, Transformation and Loading the data into target database
• Involved in testing the Cognos reports by writing complex SQL queries.
• Involved in recording change requests on the Change Requests.
• Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
• Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Strong Informatica and data loading experience.
• Involved in various testing phases like Integration Testing, System Testing.
• Developed complex queries to test the reports developed.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging table
• Tested the data and data integrity among various sources and targets.

Environment: Informatica 9.1, DB2, Cognos, SQL, PL/SQL, Teradata 13, Mainframe JCL, Teradata SQL Assistant, XML, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, ALM/Quality Center 11

Confidential, Wilmington, DE

ETL/QA BI Tester

Responsibilities:

• Involved in development of test plans, analyzed the business requirements and data mapping documents and developed test cases.
• PL/SQL queries were written to perform operations like joins in the source database.
• Vigorously worked on Manual Testing. Written Test plans, Test Cases and Test Scripts.
• Analyzed and reviewed project documentation, business rets to prepare detailed test schedules and plans.
• Performed Integration, System, Regression, Performance and User Acceptance testing of an application.
• Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation with defect correction and retesting, followed by regression and performance testing.
• Written several complex SQL queries for validating Cognos Reports.
• 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.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Creating and executing SQL queries to perform Data Integrity testing on Oracle Database to validate and test data using TOAD.
• Coordinated with different users in UAT process.
• Involved in job scheduling using MS SQL server Agent.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Responsible for writing shell scripts (wrapper) to schedule the jobs in development environment.
• Developed graphs for the ETL processes using Join, Rollup and Reformat transform components as well as Partition and Departition components extensively.
• Personalized Cognos Connection for specified display options for testing regional options and personal information.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the DB2 database in UNIX environment
• Developed and tested all the backend programs, Informatica Mappings and update processes.
• Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
• Used T-SQL for Querying the SQL Server database for data validation.
• Executed workflows created in Informatica by the developers then compared before and after transformation of data generated to ensure that transformation was successful.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Validated format of the reports and feeds.
• Used TOAD Software for Querying ORACLE. And Used Teradata SQL Assistant for Querying Teradata
• Responsible for different Data mapping activities from Source systems to Teradata
• Performed periodic checks to run crosscheck against QA/SIT/PROD environments to ensure it is up and running.
• Created stored procedures, triggers using PL/SQL.
• Performed quality assurance reviews on all System Development Life Cycle.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Participated in defect review meetings with the team members. Used MS-Word for documentation.
• Involved in other test planning meetings and submitted test metrics daily to the management.

Environment: Teradata V2R6, Informatica 8.6, SQL Assistant 6.0.0, SQL, PL/SQL, Sybase, DB2, HTML, TOAD, UNIX, Mainframe JCL, VSAM, Clear Quest, Quick Test Pro, Quality Center, Load Runner

Confidential, New York, NY

ETL Tester

Responsibilities:

• Enhancement and implementation of Guidewire Claim Center Integration and System Test Specifications.
• Extensively worked on Policy system implementation and integration of Commercial line and personal line of various Line of business.
• • Reviewed High Level and Low Level Design docs and clarified design solutions with Developers.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing.
• Performed end-to-end test from Guidewire and to various downstream application.
• Determined testing requirements developed and reviewed scripts for positive and negative test scenarios, conducted baseline testing, white box testing, black box testing and regression testing and generated reports. Tested server and Web Portal.
• Verified Historical data conversion and migration from Legacy (PMS) System into Policy System and Guidewire Claim Center using SQL Server 2012 and Informatica Power center 9.5.
• Reviewed and Tested data load from Policy System to Middleware and from MW to data warehouse using SQL Server 2012.
• Experience in Error and Event Handling using Precedence Constraints, Break Points, Check Points, and Logging using SSIS 2008.
• Validated custom ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Performed data validation testing of production defect using SQL and resolving and testing back end process.
• Participating actively in system, performance, regression and UAT testing for every new build released.
• Demonstrated an organized, systematic, disciplined and analytical approach to problem solving.
• Hands-on experienced with defect tracking tools like HP ALM.
• Extensively involved in UAT by supporting Testing and implement QA Process for data load and reporting using Cognos Series 8 V-10.2.2.
• Presented Daily Analysis Report to highlight bugs, issues and risks involved.
• Responsible for different Data mapping activities from Source systems to Reporting.
• Involved in all walk through for test designs, data designs and code reviews.
• Developed Test cases & Test Scenarios for new features and involved in Test estimation.
• Excellent knowledge on Agile and waterfall Methodology.
• Test plan, Test Strategy and Test scenario preparation.
• Test Estimation, Team reporting and resource managemen.

Environment : SQL Server 2008/2012, Informatica 9.5, Cognos Series 8 V-10.2.2, Report2Web, HP ALM, OnBase application, MyTMM, RMS, Guidewire, Autosys.

Confidential

ETL QA Tester

Responsibilities:

• Developed Test Cases for Functional as well as non-Functional, and Regression
• Testing based on the Design Document, User Requirements and Use Case Diagrams
• Planning Test cases and performed Functionality of GUI, Security, Configuration, Back-end and Acceptance Testing Manually
• Reviewed the Test Plans covering Unit Test, Integration Test, and Acceptance Test with other team members.
• Worked with other members of the QA and Development teams and offshore team (Pune, India) in improving the processes, methods, effectiveness and efficiency
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Participated in walkthrough and defect report meetings periodically.
• Documented and reported various bugs during Manual Testing.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Set up batches and work flow sessions to run these mappings.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Involved in running the ETL loads through APPWORX (by specifying the session parameters)
• Written SQL Queries to define, Identify and validate the code written for the data movement into the database tables.
• Developed PL/SQL procedures & triggers.
• Manually performed Smoke Testing of the new builds for Basic Functionality Checking
• Build a lean Regression Test Suite for Manual and Automated Testing
• Created UAT test cases and scenarios based on Use Cases, and made sure those UAT test cases meets the business requirements.
• Inserted Database Checkpoints to verify consistency of the database workflow using Win Runner
• Implemented Database Checkpoints for Back-end Testing
• Expertise in SQL queries for inserting data by join different database and cross verification of data
• Responsible for all pre-ETL tasks upon which the Data Warehouse depends, including managing and collection of various existing data sources
• Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements
• Performed Functional Testing and Back-end Testing using the database comparable results Manually
• Test Director was used for bug reporting and tracking

Environment: ETL (Informatica 6.2), Oracle 9i, SQL, PL/SQL, UNIX, Test Directror, AppWorx, TOAD, SQL Navigator, Windows XP Professional, Putty, SSH Pro, SmartFTP, MS Excel 2003, MS Word 2003, Remedy, PVCS Version Manager, TextPad 5.0