SUMMARY:

• More than 7 Years of IT experience in 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.
• Involved in preparation of 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 SQL Queries and PL/SQL scripts.
• 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.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational ClearQuest, Bugzilla.
• 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.
• Experience in testing reconcile (initial) and delta (daily) ETL loads.
• Good experience in Data Migration testing and Web Interface testing.
• Good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors. 
• 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 11, Quality Center 10.x, 9.x, Test Director, TFS, Soap UI, Bugzilla, Rational ClearQuest

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

RDBMS Query Tools: SQL*PLUS, Query Analyzer, TOAD, Oracle SQL Developer, AQT

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

ETL Tools: Informatica Power Center 9.x/8.x/7.x, Data Stage,

Programming Languages: PL/SQL, JAVA

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 Outlook

Scheduling Tools: Autosys, Cron-Tab

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

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Data Migration/ Data 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.
• Used SQL server to develop and execute test scripts in SQL, to validate the test cases.
• Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.
• 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.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Extensively used ALM to track defects and managed them.
• Validated the data flow and control flow transformations are working according to functionality in SSIS packages
• Tested various KPI’s for Tableau and SF dashboard reports.
• Extensively tested several Business Objects reports for data quality, fonts, headers, footers, and cosmetics.
• Validated the cardinality of joins and data integrity on the business objects universe.
• Conducted user acceptance testing (UAT) to validate that the developed application meets the business requirements.
• Performed ETL using Microsoft SSIS, to extract, transform and load test data on the test environment and to tested against the database.
• Extensively involved in testing the ETL process from different data sources (SalesForce, UI, SQL Server, Oracle, flat files) into the target database as per the data models.
• Writing complex SQL queries for data validation for verifying the SSIS Packages and business Rules
• Written Test Cases for ETL to compare Source and Target database systems.
• Mocked test data to test all the scenarios and test cases planned.
• Used UNIX commands for file management; placing inbound files for ETL and retrieving outbound files and log files from UNIX environment.
• Written several complex SQL queries for data verification and data quality checks.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process, issues and lessons learned for future references.
• Reviewed the test activities through daily Agile Software development stand-up meetings.

Environment: SalesForce, SQL, Microsoft SSIS, HP Quality Center, Tableau, Agile, SharePoint, SoapUI, Oracle 10g, Data Flux, SQL Server 2008 R2, SalesForce, UNIX, Putty, Flat files, Session Logs, Windows.

Confidential, Eagan, MN

Quality Analyst / DWH / BI / Data Analyst

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 used   ETL   to 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.
• Extensively created UNIX shell scripts for scheduling and running the required jobs.
• Tested the   ETL   Data Stage jobs and other   ETL   Processes (Data Warehouse Testing) .
• Tested the   ETL   process for both before data validation and after data validation process. Tested the messages published by   ETL   tool 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, Richmond, VA

QA Analyst / DWH / BI / Data Analyst

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
• Assisted QA Manager in developing test estimation, scope and test plan for UAT
• 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 SharePoint.
• Managed manual test passes/runs with TFS.
• Prepared test plans using TFS for each release, written test cases and executed them as part of functional testing. Prepared test reports and deliverables and submitted for version releases.
• 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.5,SQL, PL/SQL, DB2,Oracle 11g, TOAD, Web services, TFS, API, Soap UI, XML, SharePoint, Quality Center ALM 11.0, Agile, OBIEE, Autosys, SQL Server 2012, UNIX

Confidential, Scottsdale, AZ

QA Analyst

Responsibilities:

• Designed & created Test Plan based on the BRD and SRS. Also referred Technical Design document, Source to Target Detailed mapping document & Transformation rules document, ER Diagrams to derive test cases for functional testing. 
• Prepared Test cases and Scripts in Quality center and executed them in test lab module.
• Performed pre-process validation for existence of specified database objects like tables, views, synonyms and grants for the same to corresponding schema in database. 
• Validated the target table column definition with source column definition (including type and length).
• Validated database structure with ERD (Entity Relationship Diagram).
• Written SQLs using joins, sub queries, correlated sub queries, group functions, and analytical functions to validate the data between source and target.
• Participated in migrating UNIX code from DEV to QA and QA to UAT environments. 
• Used JIRA tool for test/ defect/bug management. 
• Involved in executing/scheduling ETL jobs through Autosys.
• Validated the custom Cognos reports using Cognos report studio, ad hoc Cognos reports using query studio and cubes using analysis studio.
• Hands on experience on using Web Service such as SOAP and WSDL.
• Validated data stage mappings that load files into staging tables.
• Involved in extensive end-to-end DATA validation and back-end testing using SQL queries. 
• Created BRD x SRS and SRS x Test Cases Traceability matrix for all the projects.
• Validated the WSDL using schema compliance assertion in Soap UI.
• Heavily involved in performance testing and worked with analyzing tables, gathering statistics, tuning of SQL queries used to fetch source data. 
• Validated Data Stage jobs. Used Data Stage director to execute and verify Data Stage jobs.
• Used TOAD GUI tool for querying oracle database.
• Presented QA team work update/Status to Project/Program Manager in status meeting and also worked with business team to get approval on test plan/test cases. 
• Validated that design meets requirement and functions according to technical and functional specifications. 
• Involved with Design and Development team to implement the requirements. 
• Developed Test Scripts and executed them manually to verify the expected results and published the same to wider audience upon successful completion along with QA signoff. 
• Participated in KT meetings with Business Analysts and SMEs. 
• Frequently used Perforce to store documents and update them with the latest versions and additions. 
• Participated in walkthrough and defect report meetings periodically. 

Environment: TOAD, Rational ClearQuest, ClearCase, JIRA, Oracle SQL Developer, Soap UI, XML,MS TFS, Putty, VB Script, Quality Center 10, Agile, Cognos 8,Autosys, SQL Server 2008, XP, UNIX.