SUMMARY:

• Over 7 Years of IT experience in Data Analysis/ QA Testing/ Batch Testing/ ETL/ DWH/ BI - Reports Testing & Testing of Software systems in Data Warehouse/ Business Intelligence/ Client-Server/ Oracle and Web-based environments in Windows and UNIX platforms.
• Extensively worked in entire QA Life Cycle, which includes designing, developing and execution of the entire QA Process.
• Strong knowledge of Software Development Life Cycle (SDLC) and QA Methodologies like Agile, Scrum, Waterfall, and Iterative process.
• Involved in preparing the Test Plans, Test Strategy documents, Test Cases & Test Scripts based on business requirements, rules, data mapping requirements and system specifications.
• Experience on Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing,Security testing, Smoke testing, System Integration Testing (SIT), Software Validation testing, UAT, Batch Testing, Interface testing, and Performance Testing.
• Prepared Requirement Traceability Matrix (RTM), Defect Report, and Weekly Status Reports, Checklists, Job Aids, Test Readiness Review Documents, Test Summary Reports.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.
• Extensive experience in writing complex SQLQueries and PL/SQL scripts.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Analyzed modules and designed test scenarios and test scripts in UNIX environment.
• Developed UNIX Shell scripts to execute different SQLs to test the sanctity and integrity of the tables.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, MicroStrategy, Cognos including dashboards, summary reports, master detailed, drill down and score cards.
• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational ClearCase.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.
• Have experience in testing reconcile (initial) and delta (daily) ETL loads.
• Have good experience in Data Migration testing and Web Interface testing.
• Have good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Extensively worked on Batch Scheduling tools Autosys to run and monitor ETL jobs.
• Knowledge on the phases of agile methodology and scrum Methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

QA/Testing Tools: HP ALM, Quality Center 11.x, 10.x, 9.x, Test Director, TFS, Rally, Soap UI, Bugzilla, Rational ClearQuest

Version Control Tools: Rational ClearCase, CVS, Share Point

Requirements Tools: Rational RequisitePro

RDBMS (Databases): Oracle 11g/10g/9i/8i, MS SQL Server 2012/2008, DB2, Teradata

RDBMS Query Tools: Query Analyzer, TOAD, Oracle SQL Developer, SQL Navigator

BI/Reporting Tools: IBM Cognos, MicroStrategy, Business Objects BOXI, OBIEE

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Data Stage, Ab Initio 2.1x, SSIS

Scripting Languages: SQL Scripts, UNIX Shell Scripts

Operating Systems: Microsoft Windows Family, UNIX - Sun Solaris, HP-UX

MS Office: MS Word, MS Excel, MS PowerPoint, MS Outlooks

Internet Tools: VB Script, Visual Inter Dev, HTML, DHTML

Scheduling Tools: Autosys, Cron-Tab

Other Tools: Putty, Text Pad, CompareIT, WinSCP, Data Flux, GS Data Generator

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Lead QA Analyst/ETL Tester

Responsibilities:

• Analyzed solution architecture and design documents including Source to Target & detail design documents needed for each tracks and plan test design activities.
• Prepared SIT project planning like creating testing scenario, test plans, and test scripts and test summary reports.
• AssistedQA Manager in developing test estimation, scope and test plan for SIT.
• Lead the SIT team and provided the SIT status and LOE for code fixes and drops to Project Manager on Weekly Project Status Meeting.
• Extensively written complex SQL for ETL and report testing.
• Participated in migratingUNIX code from DEV to QA and QA to UAT environments.
• Used UNIX commands for file management; placing inbound files for ETL and retrieving outbound files and log files from UNIX environment.
• Extensively created UNIX shell scripts for scheduling and running the required jobs.
• Kicked-off test cases design session with business, setup working sessions with Business SMEs, to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases, facilitated test cases sessions, identified test coverage and gaps if any as part of the sessions.
• Validated the responses of web services by passing various requests using soap UI.
• Worked with UAT test team, OBIEE team, Development team and Performance test team in defining, reviewing and addressing issues around test strategy document.
• Maintained all documents, SQL scripts, approvals and test results and saved on share point.
• Prepared test plans, test cases and RTM involved in the process of analyzing the expected and actual results.
• Involved in project requirements analysis, writing test specifications, formulating test plan, executing test cases & keeping track of the defects logged (Using Rational Clear Quest).
• Identifying defects and performed root cause analysis by analyzing data quality issues.
• Responsible for documenting the process, issues and lessons learned for future references.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Review daily test status and issue/ defects with the project team and business. Prepare communication and create daily status and defect reports.

Environment: Oracle 11g, Toad for Oracle 9.5, SQL, PL/SQL, IBM Rational ClearQuest, ClearCase, Web services, Putty, WinSCP, Cisco Jabber 9.6.3, Webex, HP ALM, Waterfall, UNIX, Unix shell scripts, VB script, SLS, Oracle EBS

Sr. ETL Tester /BI QA Tester

Responsibilities:

• Analyzed solution architecture and design documents including Source to Target & detail design documents needed for each tracks and plan test design activities.
• Prepared UAT project planning like creating testing scenario, test plans, and test scripts and test summary reports.
• Responsible for testing the product using SQL Queries/ UNIX command for the DB check and server startup/new builds.
• Verified in UNIX environment to make sure user home directories are created with correct access.
• Handled the tasks of explaining UAT scope, criteria and entry/exit strategy to less trained professionals and Responsible for driving end-to-end Test scenarios efforts and in identifying test data for UAT
• Drafted complex SQL queries and perform allocation testing from front end / user interface
• Defined test approach, created presentation, reviewed with Business partners and incorporated feedback and distributed final EDW 1.1 test approach.
• Extensively written complex SQL for ETL and report testing.
• Kicked-off test cases design session with business, setup working sessions with Business SMEs, to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases, facilitated test cases sessions, identified test coverage and gaps if any as part of the sessions.
• Validated the responses of web services by passing various requests using soap UI.
• Worked with Infrastructure to define/ redefine what's required from environment as well as data needs perspective for both EDW SIT and UAT environments.
• Reviewed Shakeout test cases from the team and oversee all users has access to the entire databases and OBIEE environment.
• Worked with SIT test team, OBIEE team, Development team and Performance test team in defining, reviewing and addressing issues around test strategy document.
• Reviewed SIT test cases and test scripts, provide feedback and support in terms of testing techniques and test coverage.
• Summarized final Test Summary Results and review with Business and IS in order to obtain approvals
• Maintained all documents, SQL scripts, approvals and test results and saved on share point.
• Managed manual test passes/runs with TFS.
• Used Informatica Workflow Manager to execute Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Validated the data between source and target by using Informatica data validation option.
• Validated the data flow and control flow transformations are working according to functionality in SSIS packages.
• Identifying defects and performed root cause analysis by analyzing data quality issues
• Assigned the tasks of preparing test results as well as gather test results from other testers in standardized format.
• Validated List reports, Crosstab reports, Charts, Dash Boards of SSRS reports and SSAS cubes.
• Reviewed the test activities through daily Agile Software development stand-up meetings.
• Used TOAD to develop and execute test scripts in SQL, to validate the test cases.
• Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Responsible for testing Initial/Reconcile and Incremental/daily loads of ETL jobs.
• Interacted with design/development/DBA team to decide on the various dimensions and facts to test the application.
• Heavily involved in testing reports in OBIEE, validated both the custom and ad hoc reports.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.
• Participated in KT meetings with Business Analysts and SMEs.
• Responsible for documenting the process, issues and lessons learned for future references.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.
• Review daily test status and issue/ defects with the project team and business. Prepare communication and create daily status and defect reports

Environment: Informatica Power Center 9.1, DVO, SQL, PL/SQL, Remedy, DB2, Oracle 11g, TOAD, ClearQuest, ClearCase, Web services, TFS, API, Soap UI, XML, SharePoint, Quality Center ALM 11.0, Agile, OBIEE, Autosys, SQL Server 2012, SSIS, SSRS, SSAS, UNIX

Confidential . Petersburg, FL

QA Consultant / ETL Tester / Reports Tester

Responsibilities:

• Involved in writing the test plans, test cases and RTM involved in the process of analyzing the expected and actual results.
• Worked on Extracting Data from Mainframe and load the data into Oracle.
• Performed Integration, End-to-End and System testing.
• Responsible for source system analysis, data transformation, data loading and data validation from source systems to Transactional Data system and Warehouse System.
• Extensively usedETLto load data from Flat files to Oracle.
• Executed various SQL Queries to perform the backend testing.
• Tested data stage jobs for various ETL functions and transformations.
• Had regular meeting with Developers to report various problems.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
• Performed Black box testing, White-box testing, System Testing, Data Integrity Testing and end to end testing.
• Implemented SDLC, QA methodologies and concepts in the Project.
• Involved in Developing Test Plans and Developed Test Cases/Test Strategy with input from the assigned Business Analysts.
• Tested UNIX batch jobs according to the specifications and the functionality.
• Developed test scripts based upon business requirements and processes. Processed transactions from system entry to exit.
• Used ETL methodologies for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica Power Center.
• Involved in developing Unix Shell wrappers to run various SQL Scripts.
• Tested theETLData Stage jobs and otherETLProcesses (Data Warehouse Testing).
• Tested theETLprocess for both before data validation and after data validation process. Tested the messages published byETLtool and data loaded into various databases.
• Performed the tests in both the SIT, QA and contingency/backup environments.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Heavily involved in Cognos reports, extensively used SQL for testing reports.
• Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2.

Environment: Oracle 9i, Toad, DB2, SQL, Data Stage, PL/SQL, Cognos, MS Visio, Informatica, DB2, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, Remedy, SQL Server 2005 UNIX, Putty

Confidential, MN

Data Migration Tester / DWH Tester

Responsibilities:

• Analyzed Business Requirements Document and Functional Specification document and analyzed the project needs.
• Worked with Stakeholders updating project status and ensuring the delivery of QS.
• Involved in the development of Detailed Test Strategy for Functional and System Testing.
• Performed data validation testing after theETLprocess usingInformatica.
• Designed, Developed, Executed and Analyzed Test plan, test cases, test scripts for use in Integration, System, and Regression Testing.
• Reviewed business requirements and added requirements into the Quality Center, and Wrote test cases and Functionality testing based on Requirements.
• Extensively used HP Quality Center as defect-tracking system to log, close and generate reports and tracked through to resolution.
• Performed system testing, Integration testing, and Regression testing.
• Performed Inbound and Outbound Data Validation.
• Validated the MicroStrategy reports for the data and the lay out.
• Used Informatica Workflow Manager to schedule and run Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Involved in preparation of test data to test the functionality of the sources.
• Used SQL queries to extract data from the target tables to prove the data mapping.
• Tested variousETLScripts to load the data into Target Data Warehouse (Oracle / Teradata).
• Involved in understanding of the Specifications for Data WarehouseETLProcess and interacted with the designers and the end users for informational requirements.
• Responsible for weekly status meetings showing progress and future testing efforts to the QA Manager.

Environment: Oracle 9i, Informatica, SQL Server, SQL, PL/SQL, TOAD, IBM AIX, Teradata, MicroStrategy, Teradata SQL Assistant, Unix log files, Mercury Quality Center, Rational ClearCase, ClearQuest.