SUMMARY

• Over 7+ years of IT experience of Quality Assurance in Manual & Automation testing wif ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Excellent analytical skills for understanding the business requirements, business rules/processes, and detailed design of the application.
• Experience in creating functional/technical specifications, data design documents based on the requirements.
• Expert in writing Test Plans, defining Test Cases, developing and maintaining Test Scripts, Test Case Execution, Analyzing Bugs and interacting wif team members in fixing the errors as per specifications and requirements.
• Experienced wif Full Life Cycle and Methodology for implementing Data warehouse and Business Intelligence Reporting System.
• Extensive experience in quality assurance using Manual Testing, Automated testing tools like Quick Test Pro, Quality Center
• Experience in validating the ETL applications built using Informatica, Ab Initio, SSIS and DataStage.
• Extensively strong on databases including Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008R2 and IBM DB2, Teradata 13.0
• Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Knowledge in Business Intelligence tools like Microstrategy 9.0, Business Objects, Cognos and OBIEE.
• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.
• Implemented Optimization techniques for better performance on the ETL side and also on the database side.
• Extensive experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing.
• Experience in complete Software Testing life cycle: Unit Testing, Functional Testing, Regression, Integration, System Testing, Performance testing and Data driven testing.
• Expertise in Defect Reporting and Tracking using Test Director/ HP Quality Center.
• Extensive experience in testing applications on UNIX environment.
• Excellent in meeting deadlines, time management and presentation skills.
• Excellent team player wif problem - solving and trouble-shooting experience
• Worked on different platforms such as Windows XP,8 and UNIX, Sun Solaris, AIX, HP
• Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Quality Assurance Tools /Test Management: HP ALM 11/HP Quality Center 10, Test Director 7.5, IBM ClearQuest

Languages: SQL, PL/SQL

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

GUI/RDBMS Query Tools: SQL* Plus, Oracle SQL Developer, SQL Server Management studio, Teradata SQL Assistant 13.0, TOAD, WinSQL

ETL Tools: Informatica Power Center 8.x/9, Ab Initio, SSIS and Datastage

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

PROFESSIONAL EXPERIENCE

Confidential, NC

Sr. QA Tester

Responsibilities:

• Review Mapping Documents formula and rule engine.
• Analyzing change request for the existing mapping and creating an impact analysis for the change.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
• Prepared Test data preparation strategy and data masking strategy for the shared test environment.
• Written Test Cases for ETL to compare Source and Target database systems.
• Interacting wif senior peers or subject matter experts to learn more about the data.
• Involved in completing data testing before the UAT.
• Co-ordinate wif development and QA team for handling of defects wif respect to data.
• Interact wif clients/business users when issues arise on Data governance.
• Created spreadsheet wif all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
• As a ETL Tester responsible for the understanding the business requirements, ETL and subsequently design ETL testing strategy using SQL scripts.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations
• Perform Data Integration, Data comparison and Data Validation for Back End Testing by using SQL Queries (TOAD).
• Assisted in ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and tan to production environment.
• Created data rules to handle SCD Type II data using PL /SQL.
• Helped sequence the workflows for batch based on dependency to improve the time taken for end to end loading
• Tested and validated the BO reports by running similar SQL queries against the source system(s).
• Tested the Business Objects Reports using most of the Report studio features (Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through, Drill Down, Drill Up).
• Shared lessons learnt from the DQ analysis to the data governance team.

Environment: HP Quality Center 10.0, Informatica 8.6.1, SQL, PL/SQL, TOAD for Oracle 9.1, Oracle 10g, Agile, MS Office, Business Objects XIR4, Java, .NET, XML, HTML, Windows and Unix, Shell Scripting

Confidential, Manhattan, NY

Sr. QA Tester

Responsibilities:

• Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
• Perform both manual and automation testing and created various test results to track the testing results.
• Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
• Followed up wif standard software testing life cycle (STLC) to perform different types of testing for the projects.
• Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
• Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
• Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
• Updated RTM in daily, send status report and daily tracking report to test manager.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
• Performed Functional Testing using Quality Center.
• Participated to develop automation scripts in QTP to automate smoke and regression testing.
• Used Quality center to execute automation scripts in batch mode or unattended mode.
• Enhanced the scripts in QTP by applying checkpoints, parameterizations, synchronization point, data driven tests and creating modular tests.
• Defined the “Test Engagement Process” for new application launch and maintenance releases.
• Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
• Tested all the ETL process dat was developed to fetch the data from various feeds into the data warehouse.
• Written SQL scripts for validating the data loaded by the ETL processes.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Validated Data Stage logic by executing ETL Wrappers and Autosys jobs by using SQL and Unix Shell scripts
• Tested the reports developed using Business Objects.
• Worked closely wif the application development and design and testing team to resolve technical issues and interacted wif them to ensure overall quality of the software.

Environment: HPQuality Center 9.2, QTP 9.2, IBM DataStage 8.1v, Quality Stage, IBM DB2, Business Objects XIR3.1, Web Services/Web methods, XML, HTML Oracle 10g,, SQL, TOAD, Windows 2003/2007, UNIX

Confidential, Baltimore, MD

DWH Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• Managed multiple OLAP and ETL projects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Performed extensive Data Validation, Data Verification against Data Warehouse
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Tested several BO Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s, Grouped List, Cascade and Web Reports.
• Tested several Informatica Mappings to validate the business conditions.
• Testing the source and target databases for conformance to specifications
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center 10.
• Designed and prepared scripts to monitor uptime/downtime of different system components.

Environment: Informatica 8.1, Business Objects XIR3, WinSQL, QTP 9.2, Quality Center 9.2, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, IBM DB2.

Confidential, Edison, NJ

QA Analyst

Responsibilities:

• Analyzed Business Requirement Document, Software Design Document, Software Requirement Specification and Functional Requirement Document.
• Validated data from front end systems to the backend databases.
• Performed both Positive Testing and Negative Testing.
• Performed Code review of automation Scripts and made comments for changes made in the script.
• Involved in User Acceptance Testing, GUI Testing, and Regression testing, on different versions of the application.
• Validated all the web services by testing the WSDLs using SOAP UI.
• Validated all the ETL mappings developed to fetch data from OLTP system to the data warehouse.
• Automated and scheduled multiple Informatica mappings using UNIX Shell Scripting
• Validated all the session logs.
• Participated in SCRUM and SPRINT meetings.
• Created Scenarios as per business requirements wif various user loads using Performance Center.
• Enhanced the Ramp Up and Ramp Down time’s to simulate the real time scenarios.
• Extensively used SQL to query the Database to setup the test data for at least 500 virtual users for each applications.
• Assigned critical performance Defects to the developer using Quality Center.
• Weekly meeting wif the management team and share the Status Report on the weekly basis.

Environment: SOAP UI, Quick Test Pro (QTP) 9.0, Quality Center (QC) 9.0, VB script, SQL, TOAD, Microsoft Visio, MS Access, Windows XP/2003/2007, Oracle 10g, Informatica 7.1