SUMMARY

• 8+ years of extensive experience in Quality Assurance testing of data warehousing/ETL and Business Intelligence - Web Based and Client/Server applications.
• Experience in writing test plans, writing and executing test cases, mapping test cases to requirements, defect management and implementation of projects with TEMPeffective QA implementation in all phases of Software Development Life Cycle (SDLC).
• Very good understanding of Data Warehousing concepts, Data Models, Data Warehouse Architecture, ETL and teh Reporting applications.
• Strong expertise in Relational data base systems like Oracle, SQL Server, DB2 and Teradata.
• Well versed with Software testing concepts, SDLC, STLC, Agile and Waterfall methodologies.
• Experienced in Black Box, Smoke Testing, System Integration, Regression, Functional, Compatibility, Security and Front End and Back End Testing.
• Extensive experience in writing SQL and PL/SQL scripts to create Positive and Negative test data sets, data validation in database systems for Back-end and Front-end testing, data profiling and data analysis.
• Extensively worked with Test Management Tools like ALM HP Quality Center, Jira, Microsoft Test Manager (MTM) for TEMPeffectively tracking teh testing activities and defects management.
• Extensively worked with batch scheduling tools like Autosys, Control-m to run and monitor teh ETL workflow jobs.
• Experience in testing BI reports generated by different BI tools like Cognos, SSRS, Business objects.
• Experience in testing behavior and performance of a software using tools like LoadRunner and Loadview.
• Experience in UNIX for locating input files, data manipulation, validation, and running teh shell scripts.
• Experience in working closely with all levels of business and project teams to support teh UAT testing and production support.
• Possess excellent team management, leadership, communication and Coordinated testing efforts and TEMPeffectively managed offshore teams.
• Clear understanding of business procedures and ability to work in a team and individual with good communication skills, documentation and interpersonal skills.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center, SSIS, Data Stage

QA Tools: ALM HP Quality Center, JIRA, LoadRunner, SharePoint, Rally, MTM

Software Methodologies: SCRUM Agile, Waterfall Model

DBMS/Query Tools: TOAD, SQL Developer, Teradata SQL Assistant, SAS, SQL Server Management Studio

Languages: SQL, PL/SQL

Databases: Oracle, SQL Server, DB2, Teradata

BI / Reporting Tools: OBIEE, Cognos, SSRS, Business objects

Microsoft Office Suite: MS Word, MS Excel, PowerPoint, MS Office

Operating Systems: Microsoft Windows, UNIX

Scheduling Tools: Autosys, Control-M

P ROFESSIONAL WORK EXPERIENCE

Confidential, Fort Mill, SC

Sr.QA/ETL Tester

Responsibilities:

• Participated in full SDLC cycle from inception to deployment with regards to testing (Requirement Analysis, Test Planning, Test Cases, Script Development, Test Execution, Test Reporting, Test Result Analysis and Defect Retesting)
• Involved in understanding teh Business Requirements from teh Business Analyst in order to transform business requirements into functional test cases
• Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline documents.
• Attended JAD Sessions with Business Analyst, Development Team Manager and SME’s
• Worked with Agile Methodology (Scrum) for teh project.
• Implemented various Black Box testing like GUI, Regression, Functional, Integration, System, User Acceptance (UAT), Sanity, compatibility, Security and Database Testing
• Used TOAD to write and executed complex SQL queries including JOINS, Operators and conditions to validate Back-end data
• Extensively used Deloitte Mapping Tool to check teh source and target mapping
• Contributed to daily status meetings with project management on testing update
• Generated Testing and Defect Status report and communicated to teh Project Management Teams
• Responsible for documenting teh process for future references
• Reviewed teh Product backlog and Sprint backlog and involved in prioritizing teh backlog
• Performed functional and regression testing using QTP
• Developed Requirements Traceability Matrix to relate High Level requirements to Test cases
• Performed functional testing by deployment request, sanity testing, prioritized QA Test Cases within project plan
• Performed Defect Root Cause Analysis, interacted with related Team, and tracked defects in a Jira
• Has tested SSIS packages according to business requirements and data mapping requirement documents
• Extensively involved in testing teh ETL process of data sources, SAS, Teradata, SQL Server, Oracle, flat files into teh target Teradata, Oracle database as per teh data models

Environment: SQL Server, SQL Server Management Studio, Teradata, Oracle 12C, SQL Developer, Agile, Test Scripts, Test Plan, Traceability Matrix, SharePoint, UAT, SAS, Web Services, Toad.

Confidential,Skillman NJ

QA Analyst

Responsibilities:

• Involved in QA testing for getting Retail/ Nonretail facts, demographic data, product, Ruleset data, landing in landing zone, transforming teh data in transformation zone and finally to teh presentation layer for teh apps/reports to consume teh data.
• Conduct validations of existing and new reporting/applications which supported commercial operations for RETAIL/Nonretail Markets, Call activities for continuous accuracy and front-end ease of use.
• Mainly involved in teh creation of Test Plan, Test scripts, Test summary reports, Requirement Traceability Matrix to support teh project sign off.
• Involved in all phases of SDLC and referring to documents like Business Requirement document, Technical Design Document, Functional Requirement specification, mapping documents dat support testing needs.
• Performed extensive Data Analysis, Data Validation, Data Profiling, Data Verification, Data Loading, Data Warehousing/ETL testing and BI Reports Testing.
• Used Informatica as an ETL tool to load and test ETL process, data mappings and data transformations.
• Prepared test data, data mock up by modifying teh sample data in teh source systems, to cover all teh requirements and positive and negative test scenarios.
• Created and executed complex SQL queries to perform source to target testing database. Performed teh following tests: DATA COMPLETENESS, VALIDITY, UNIQUENESS, DATA INTEGRITY, DATA TRANSFORMATION, DATA QUALITY, INITIAL AND INCREMENTAL LOAD TESTS.
• Used Unix Shell scripts for running teh ETL jobs and various Unix command for teh input file validations.
• Extensively used HP ALM Quality Center for test managements.
• Worked with statisticians and Commercial data managers to provide teh extracts for analyzing teh data, generated reports, tables, listings and graphs.
• Involved in supporting teh UAT testing, coordinated with different users in UAT process and Production Support.
• Conducted and actively participated in Scrum meetings, different Reviews meetings, walkthrough meetings, provided input into projects for timelines and resources required for teh testing needs.

Environment: Informatica 10.2, SQL, UNIX, Agile, Test Scripts, Test Plan, Traceability Matrix, SharePoint, Control -m, HP ALM QC 11, UAT, SAS, Web Services, Toad, PL/SQL.

Confidential, Providence RI

ETL Test Analyst

Responsibilities:

• Analyzed Business Requirements, understood customer, and developed Test Plan using Testing Methodology.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics, Defect Report, Weekly Status Reports and SQA Report using Quality Center.
• Tested a number of complex ETL mappings, mapplets for daily data loads to compare Source and Target database systems.
• Validated teh target output in Informatica cloud and check if teh transformations used displays teh correct output as required in Target table.
• Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting teh defects to development team.
• Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Mapping.
• Gathered requirements for teh creation of data flow processes for teh SSIS packages
• Worked with SSIS to import, export and transform teh data between teh servers.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.
• Participated in unit testing and verified entrance criteria of QA and set up configuration data with developer and updated release notes.
• Performed testing on multiple Informatica mapping for data validation and data conditioning.
• Worked with peers in development and other organizations to troubleshoot and resolve project issues both technical and non-technical in nature.
• Involved in Back End Testing using UNIX Utilities and automated Regression Testing using shell scripting.
• Tested OBIEE reports for verifying and validating teh data. Tested several complex reports generated by OBIEE including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
• Assisted business & marketing team in execution of UAT by providing data.
• Shared technical information with team and involved in production testing with critical production problem.
• Interacted with upper management to provide daily QA status, discussed outstanding issue and upcoming project functionalities.

Environment: SSIS, SSRS, SQL Server, SQL Server Management Studio, Oracle 12C, SQL Developer, OBIEE 12C, SQL Informatica, ETL/Informatica cloud, Autosys, UNIX, Shell scripting.

Confidential, Salt Lake City, Utah

Manual Tester

Responsibilities:

• Involved in reviewing Business/System requirements and other deliverables.
• Involved in preparing Test Plans and Test cases based on teh business requirements Document in teh Quality Center.
• Created TEMPEffective Test Data and Test cases to ensure teh successful execution of teh data loading processes, Created SQL scripts to verify test cases from source to target database.
• Used Data stage director for running teh Data stage jobs and validated them.
• Extensive experience in testing slowly changing dimensions of Type 2 to populate current and historical data to Dimensions and Fact tables in teh data warehouse.
• Extensively involved in System testing strategies preparation. Designed Test Cases and scripts.
• Expertise in resolving performance tuning issues. Expertise in UAT, IT test cases, UT Results.
• Extensively used SQL and PL/SQL coding in jobs for processing data. Debugging UNIX shell scripts and schedule teh mappings.
• Tested teh report scripts in administration console and query analyzer according to end user Requirements.
• Developed batches and sequencers in designer to run and control set of jobs.
• Involved in writing teh test cases based on Requirements, Executing teh test cases, Defect Reporting.
• Opened Defects in Quality Center and tracked teh status until defect is closed.
• Tested teh reports in Business Objects universe and validated teh data on teh reports are teh UI of teh reports as per teh Business Requirements.

Environment: Data stage, SQL, HP ALM, Agile, Toad, Teradata, Cognos, Oracle 11g, PL/SQL, Autosys, XML, QTP, Unix.

Confidential, SFO CA

DWH Tester

Responsibilities:

• Analyzed teh Requirements from teh client and Developed Test cases based on functional requirements, General requirements and system specifications.
• Involved in preparing RTM by link and sync process, mapping teh test cases with teh appropriate requirements in Quality Center.
• Lead and/or participated in teh creation, distribution and walkthrough of software test cases, scripts and other documents surrounding testing activities and ensure dat all testing activities and deliverables are conducted/produced in compliance with company standards.
• Prepared Test Scenarios by creating Mock data based on teh different test cases.
• Prepared Test Cases for system testing and uploaded them into Quality Center; linked teh test cases to teh business requirements, Defects to Test Cases.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Tested teh different sources such as Flat files, Main Frame Legacy Flat Files, SQL server and DB2 to load into teh DB2 data warehouse
• Has tested different Data Stage transformations.
• Validated aggregations, filters, expressions transformation logics in Data Stage.
• Created SQL compare statements to validate Actual result with teh Expected Results.
• Extensively used Data Stage Manager to run teh workflows and monitored teh session logs/log files in Data Stage Director.
• Documented teh Defects found in testing using Clear Quest.
• Used SQL Profiler to monitor teh performance of SQL queries.
• Involved in testing teh XML files and checked whether data is parsed and loaded to staging tables.
• Used Rational Clear Case to upload final test scripts and test results after final SIT (System Integration Testing).
• Excel reports are validated using SQL and embodying complex formulas in teh Excel.
• Worked extensively on Analysis Studio and Report Studio in testing various Cognos Reports.
• Lead teh team to review teh Test Results for teh Full System and Final System Test cycle.
• Reviewing teh test activities through daily Agile Software development stand-up meetings.

Environment: IBM DB2 V8, Data Stage 9.1, SQL, PL/SQL, Rational Clear Quest, Clear Case, T-SQL, Putty, Toad, Cognos 10, VBScript, WinSCP, FTP, UNIX, XML.