SUMMARY

• Over 6 years of IT experience in Quality Assurance and Data Analysisof various business applications in Client/Server environments, Web - based applications, Data Warehousing solutions, ETL and Business Intelligence solutions.
• Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle (DLC).
• Strong experience in writingTest Plans, Test Cases & Test Scripts based on business requirements, rules and system specifications.
• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification.
• Experience in Functional testing, System Testing, Regression Testing, Integration testing, GUI Testing,Security testing,Smoke testing, System Integration Testing (SIT), Software Validation testing, Configuration testing, Interface testing, Stress and Performance Testing.
• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects XI, Micro Strategyincluding dashboards, summary reports, master detailed, drill down nd score cards.
• Extensively worked on database query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
• Extensive experience in writing complex SQLand PL/SQL scripts.
• Experience on working with different models such as star and snowflake and strong working knowledge in dimensional modeling.
• Expertise in test management using HP Quality Centerand maintained versioned objects using Rational Clear Case.
• Experience with Automating test scripts using Selenium IDE
• Creating Scripts for Regression testing using Selenium web driver in Java environment.
• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking defects using HP Quality Center, Rational ClearQuest,Bugzilla,Jira.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• 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, Control-M to run and monitor ETL jobs.
• Involved in preparation of RTMs, Defect Reports and Weekly Status Reports.
• Knowledge on the phases of agile methodology.
• Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center9.x/8.x/7.x, SSIS, Data Stage, AbInitio

QA Tools: HP - Quality Center, Test Director, Quick Test Pro (QTP), Selenium IDE, Selenium WebDriver

DBMS/Query Tools: TOAD, Rapid SQL, SQL Developer, SQL Navigator

Languages: SQL, PL/SQL, C, Java,C#

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000 , DB2, Sybase Teradata V2R6/V2R5

Version Control Tools: Rational Clear Case, WIN CVS

Requirements Tools: Doors, Rational Requisite Pro

BI / Reporting Tools: IBM Cognos 8.0, Business Objects BOXI, SSRS

Operating Systems: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0, UNIX - Sun Solaris, HP-UX

Scheduling Tools: Autosys, Control M, Flux

Other Tools: TextPad, CompareIT, PuTTY, WinScp, SnagIT

PROFESSIONAL EXPERIENCE

Confidential, Tallahassee, FL

Sr. ETL/BI/DWH QA Analyst/Data Analyst

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Casesand Test Scripts by analyzing Business requirement documents and Use cases.
• Prepared Requirement Traceability Matrix (RTM), Test Status reports and Test Sign off documents.
• Involved with project backlogs and sprint backlogs.
• Extensively involved in System testing / Functional, Regression testing and Integration testing
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Performed Negative testing using Informatica to find how the workflow performs when it encounters invalid and unexpected values.
• Developed and maintained automated regression test cases in Selenium WebDriver using Java programming language
• Involved in test management and defect management using Quality Center and TFS.
• Performed Database (metadata) validation before loading the data into the target tables.
• Performed Data Validation by testing the delta/daily and reconcile/data loads.
• Created SQL compare statements to validate Actual results with the Expected Results and written complex SQL queries for validating Cognos Reports.
• Trackedand executedtheUser AcceptanceTest Cases (UAT) with respect to the requirements to determine the featurecoverage.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Worked onAutosysforBatch ProcessingETL, PL/SQL subprograms and performed backend testing.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Validated the data moving from multiple sources to target using Informatica data validation option.
• Estimated level of effort (LOE) for testing effort and reported to Test Leads.
• Performed Quality Assurance activities for data validation, data scrubbing, data profiling.
• Created shell scripts and used Unix commands to manipulate input files for test execution
• Created test data for all ETL mapping rules to test the functionality according to requirements.
• Ensured quality products delivered and installed as specified in the statement of work (SOW).
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Informatica 9.1, Informatica Data Validation Option (DVO),SQL, PL/SQL, Remedy, DB2,Selenium 2.4, Oracle 11g,TOAD, XML, PuTTy, Quality Center 10,TFS (Team Foundation Server), MS Visual Studio, Cognos 10,Autosys, SQL Server 2008, SSIS, SSRS, SSAS, Windows XP, UNIX.

Confidential, Danville, PA

Sr.ETL/BI/DWH /Web Tester/Data Analyst

Responsibilities:

• Analyzed the Business Requirements and Rules and worked with Business Analysts and Business Users in preparing Test Plans.
• Analyzed the Functional Specifications and implemented their technical aspect in System and Integration testing (SIT).
• Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
• Worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression, System (End to End)and Backend (Database).
• Developed and executed test cases and test scripts.
• Performed Integration, Regression, Performance and Functional Testing.
• Worked with the UNIX shell scripts.
• Used HP Quality Center as test management tool.
• Validated the responses of web services by passing various requests in SOAP UI.
• Tested Cognos Reports according to the business requirements.
• Exclusively used Analysis Studio and Query Studio to test the Cognos Reports.
• Tested several complex reports generated by Cognos including Dashboards, Summary Reports, Master Detailed,Drill down reports.
• Analyzed and tested Data Stage jobs with OLTP source data, staging and target data.
• Extensively written SQL to confirm the data transfer from sources to target.
• Tested the PL/SQL procedures, functions, packages according to the requirements.
• Performed Backend database testing, by executing the Group functions, complex Joins and sub queries.
• Verified test results (viewing the log files, querying the database) documenting the defects.
• Involved in testing the UI screens, reports which was used by the internal business team.
• Involved in defects tracking meetings for system integration testing and communicated the issues and escalations with the project manager.
• Involved in testing the functionality of Data Stage jobs.
• Executed ETL mappings through data stage director and monitored status.
• Tested theETLData Stage and otherETLProcesses (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Attended Bi-Weekly Defect Review and Defect Status meetings. Provided updates to Team Lead on testing activities.

Environment: Data Stage 8.0, SQL, Cognos 8.0, Clear Case, Clear Quest, RequisitePro, Quality Center, SharePoint, Web Services, Soap UI, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, UNIX, PuTTy, Flat Files, Session Logs, Rally.

Confidential, Winston Salem, NC

ETL QA Analyst/UAT Tester/Data Analyst

Responsibilities:

• Responsible for creating Test plan, development of Test scripts, execution and validate Test results and document test evidence.
• Executed test cases, and test scenarios forUser Acceptance (UAT), Functional and Regressiontest cases.
• Reviewed unit test cases and test results and certified the code for Integration testing
• Created user acceptance testing documents and reviewed them with the customer.
• Mapped test cases to requirements using Quality Center
• Involved in entering and tracking defects using Rational Clear Quest.
• Involved in communicating with support, business and development teams to resolve issues during test execution.
• Tested initial and daily loads for various Ab Initio graphs.
• Validated several SSIS and SSRS packages to verify that they are working according to BRS.
• Involved in testing the batch programs by using the Autosys tool.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Conducted reviews of test plans, test cases, and prepared test results.
• Tested the functionality of Ab Initio graphs.
• Tested theETLgraphs and otherETLProcesses (DW Testing).
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Effectively communicate testing activities and findings in oral and written formats.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to test business rules and security.
• Done data validations for Business Objects reports.
• Extensively used Ab Initio Co-op to execute the graphs and verify the logs.
• Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
• Created Test input requirements and prepared the test data for back end testing.
• Involved in testing the reports and UI screens containing those reports.
• Provided status reports on test execution, and defects identified during testing.

Environment: Oracle 9i, Toad, DB2, SQL, Ab Initio 2.12, PL/SQL, Business Objects XI, MS Visio, Rapid SQL, Mainframes, TOAD, .Net, XML, COTS, RUP, Windows, Autosys, TIBCO, Remedy, SQL Server 2003/2005 SSIS, SSRS,HP Quality Center, UNIX,PuTTy, SQL Navigator

Confidential, Madison, WI

DWH Tester/Data Migration QA/Web UI Tester

Responsibilities:

• Develop test plans based on BRDs and Technical Specifications.
• Created and executed test cases based on test strategy and test plans based on business requirement documents and ETL design documents.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
• Extensively used Informatica Workflow Manager to run the workflows.
• Preparation of technical specifications and Source to Target mappings.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Written Test Plans and Test Cases on Mercury Test Director Tool.
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Strong Perl Scripting experience in writing conditionals, subroutines, Perl packages, OOP and Debugging in Perl.
• Wrote SQL scripts and PL/SQL queries using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Used Data Stage Director to run the ETL mappings and monitor the status.
• Creating test cases for ETL mappings and design documents for production support.
• Extensively used Informatica for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively tested several Crystal Reports and Hyperion reports for data quality, fonts, headers & cosmetic.
• Participated in review meetings for defect status, priority and information exchange.

Environment: UNIX, Informatica, Perl Scripting, Mercury Test Director 6.5, SQL *Loader, Crystal Reports, Hyperion Reports, Oracle 9i, SQL Server 2003, Terdata, SQL Assistant, PuTTY, Remedy, WinSCP, Erwin 3.5, HTML, XML, Micro Strategy, Java, J2EE, SSIS, TOAD, UNIX log files, vi Editor, XP.