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.
• Worked in different domains such as Energy Industry experience includes Oil/GAS and Chemicals, Power & Lighting, Electricity as well as retail industry
• 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 SQL Queries 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.
• Expertise in test management using HP ALMQuality 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.
• 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, Madison, WI

QA 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 SIT 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 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 migrating UNIX 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.
• 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

Confidential, Houston, TX

QA Analyst

Responsibilities:

• 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
• 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 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.
• 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, Seattle, WA

QA 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.
• 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, Austin, TX

QA Analyst

Responsibilities:

• Developed and conducted a wide range of tests and analysis to ensure that software, systems, and services meet minimum company standards and defined end-user and system requirements.
• Tested online e-portal for Health Risk Assessment, where Centennial Care Members may conduct their health risk assessment.
• Responsible for testing Initial and daily loads of ETL jobs.
• Extensively written complex SQL for ETL and report testing.
• Evaluated business requirements and technical specification documents to craft test strategies and LOE assessments which would account for durations, constraints, assumptions, etc. that are required to accomplish test objectives.
• Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements.
• Involved in obtaining Test requirements from the Business Users for new change requirements and enhancement request.
• Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface.
• Participated in Project discussions with analyst, developer & testing teams.
• Exclusively involved in execution of PL/SQL batch programs and responsible for reporting the defects to development team.
• Logged the defect/bugs on HP ALM
• Involved in maintaining the test environments; with activities like requesting data loads, data base backups, restarting the servers, requesting the deployments, troubleshooting issues.
• Involved in testing the batch programs.

Environment: Informatica 9.2, Oracle 11g, SQL Plus, SQL Server 2012, Oracle SQL Developer, HP ALM, MicroStrategy, Putty, Microsoft SQL Server, TOAD, Clear Quest, Clear Case, Web Services, Agile, UNIX, Soap UI, XML