PROFESSIONAL SUMMARY:

• Over 8 years of IT experience in Quality Assurance and Data Analysis of various business applications in Client/Server environments, Web-based applications, Data Warehousing solutions, ETL and Business Intelligence solutions, QA and EDI specialist
• Excellent working knowledge of System Development Life Cycle SDLC and Software Testing Life Cycle STLC and Defect Life Cycle DLC .
• Strong experience in writing Test 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 Strategy including dashboards, summary reports, master detailed, drill down and score cards.
• Extensively worked on database query tools such as TOAD, SQL Navigator, Rapid SQL and SQL Plus.
• Extensive experience in writing complex SQL and 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 Center and maintained versioned objects using Rational Clear Case.
• Experience in 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,ALM, Rational Clear Quest, Bugzilla, Jira.
• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
• Knowledge on the phases of agile methodology.
• Involved in preparation of RTMs, Defect Reports and Weekly Status Reports.
• Extensively worked on Batch scheduling tools Autosys, Control-M to run and monitor ETL jobs.
• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.
• Excellent interpersonal, communication, documentation and presentation skills.

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Developed the complete Test documents like Test Plan, Test Cases and 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/ALM 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.
• Extensively tested Cognos reports for static/cosmetic errors like header, footers, logos, fonts etc which may appear in all pages of the reports.
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Verified ETL logs and reject/discard files for errors and reported them to development team.
• Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
• Involved in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
• Involved in validating SSIS and SSRS packages according to functional requirements.
• Tracked and executed the User Acceptance Test Cases UAT with respect to the requirements to determine the feature coverage.
• 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, ALM, TFS Team Foundation Server , MS Visual Studio, Cognos 10, Autosys, SQL Server 2008, SSIS, SSRS, SSAS, Windows XP, UNIX.

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. Involved in high and detail level design reviews to ensure requirement traceability and to determine application/component functional readiness requirements. Being part of the test team, responsibilities involved writing complex queries using SQL and PL/SQL to generate data based on the complex derivations for each attribute. Complex SQL queries were written to compare data generated by the application against the expected results generated based on mapping requirements for each interface. Involved in validating various Business objects reports for Lay out and data quality. Exclusively involved in execution of Autosys jobs, PL/SQL batch programs and responsible for reporting the defects to development team.
• 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.
• Worked in System testing / Functional, Regression testing and Integration testing
• 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.
• Tested Informatica mappings for various ETL functions.
• Responsible to test the functionality of Ab Initio graphs. Worked with the development team to create a suite of test data Input files, Expected results , that fully exercises Data Validation detecting, rejecting bad data to test ETL functionality properly processing .
• Worked on Informatica Workflow Manager to run the workflows and monitored the status and logs in Workflow Monitor.
• Tracked and executed the User Acceptance Test Cases UAT with respect to the requirements to determine the feature coverage. Performed functional, data and cosmetic testing for OBIEE reports. Validated procedures, functions, triggers in T-SQL. Responsible for testing Initial and daily loads of ETL jobs. Involved in testing the batch scheduling programs by using the Autosys tool. Responsible for preparing test cases and scenarios for System testing and UAT testing. Have worked in Technical Operations team for CDW ETLs execution support. Involved in creating various data scenarios Excel Sheets having expected data and validating them before and after running the respective Autosys batches. Developed UNIX scripts for file archiving, file transfers and file management. Involved in Database Validations, Writing Test scripts Including the related SQL Statements by joining various tables depending on Requirements for both Positive and Negative Scenarios. Linking Requirements from DOORS, to Test Scenarios in Quality Center/ALM. Validated SSRS packages for data quality according to the business requirements. Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: UNIX, Informatica 9.1, Oracle 10g, SQL, PL/SQL, Autosys, SQL Server 2008, SSIS Toad, Java, Autosys, IBM DB2, Business Objects XI, Web Services, Rational Clear Quest, TSQL, SQL Server 2008, OBIEE, Terdata V2R6, Clear Case, UAT, Quality Center/ALM, Putty, XML, XSD, XSLT, Leech FTP, Remedy, Windows XP/NT.

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 the ETL Data Stage and other ETL Processes 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: UNIX, Data Stage 8.0, SQL, Cognos 8.0, Clear Case, Informatica 9.1, Clear Quest, RequisitePro, Quality Center, SharePoint, Web Services, Soap UI, XML, Oracle 10g, SQL Server 2005/2008, DB2, PL/SQL, PuTTy, Flat Files, Session Logs, Rally.

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 for User Acceptance UAT , Functional and Regression test 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 the ETL graphs and other ETL Processes 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

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.

TECHNICAL SKILLS: