SUMMARY:

• Over Seven years of IT experience in QA testing,Design and Implementation wif extensive Web based, Client/server, Middleware for Financial /Banking domains
• Good experience in Client/Server, Reporting, Database, Data Warehouse and Web based applications wif manual testing and using automated testing tools.
• Ability to implement Best QA Practices and process.
• Extensive experience in Backend Testing and in preparing detailed Test Summary Reports
• Involved in full Software Development Life Cycle (SDLC) (designing, debugging, testing, documentation, maintenance and enhancement).
• Experienced in developing, reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
• Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
• Expert in documenting detailed test plans, test cases and expected results in Quality Center and tracing the test cases to the requirements
• Highly experienced wif different RDBMS such as Oracle 9i,10g,11g, MS SQL Server 2000, Teradata and MySql
• Solid experience in UAT testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
• Good Experience in Scheduling and managing QA/UAT execution activities and defining,writing and preparing QA/UAT Test Strategy, Test Plan and Test Scripts
• Extensive Experience in creating Test Cases, Test scripts, Test Strategies and Test Plans based on FSD’s, BRD’s & Use Cases.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading process, in a corporate - wide-ETL Solution using Informatica, Ab Initio, Data Stage and SSIS
• Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
• Strong Business and Functional exposure on various business applications including Financial and Healthcare.
• Experienced working wif Customer Information Data Mart for business reporting thru MDM and Data
• Strong Data Querying/SQL and UNIX Shell Scripting skills
• Writing and Executing Test cases & defect tracking using Quality Center.
• Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, database testing and regression testing.
• Experience in processing and validating data in flat files as well as in DB tables.
• Compatible to work in Agile environment.
• Excellent concept of ETL, Data warehousing and BI applications integration.
• Good experience in working wif onsite-offshore team model projects.
• Ability to Prioritize Work, Good Analytical, Trouble shooting and Problem solving Skills.
• Having Strong Leadership, handling multiple tasks and Time management skills.
• Work Independently, Creative, highly motivated, and hard working wif good interpersonal skills.
• Ability to interact wif end users, also quick learner and team player wif good communication skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Scripting Languages: XML, HTML, Visual basics

Languages: SQL, PL/SQL,C,C++,.NET Technologies.

ERP: People soft

Packages: MS-Office, Visual Studio. 2005

Modeling Tools: Erwin 4.0

Scheduler Tools: AutoSys,Control-M

ETL Tools: Informatica 8.1, 8.6.1, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS, Data Stage 6.x/7.x/8.x

Testing Tools: Quick Test Professional (QTP), Test Director, HP Quality Center, Rational Clear Quest, Bugzilla

Query Tools: PL/SQL, Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus

Databases: Oracle 9i/10g/11g, SQL Server 2000/2005/2008, DB2 (9.7), MS Access, Teradata

Reporting Tools: Cognos 8.0, Crystal Reports, Business objects

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

Sr ETL Tester

Responsibilities:

• Designed & Created Test Cases based on the Business requirements (Also referred Source to Target Detailed mapping document & Transformation rules document).
• Developed and executed various Manual testing scenarios and exceptionally documented the process to perform functional testing of the application
• •Used TOAD & SQL Navigator GUI tools for Querying Database
• Performed Black Box testing for testing all the business requirements and the System functionality
• Controlled and Managed all testing related aspects e.g. data management, release management, quality.
• Participated in specifications reviews, project scope assessment and software requirements of online home loan accounts
• Did unit testing, manual testing of the processes to check the integrity
• Developed project test documentation including test plans, test scripts and test result reports as well for the customer contact information and Loan prospect components
• Involved in extensive DATA validation using SQL queries and back-end testing
• Used SQL for Querying the database in UNIX environment
• Tested various application wif Quick Test Professional and wif script enhancements Promoted Unix/Informatica application releases from development to QA and to UAT environments
• Performed Regression, UAT and Database testing. Performed data validation-using SQL
• Involved wif Design and Development team to implement the requirements.
• Developed and Performed execution of Test Scripts manually to verify the expected results
• Involved in Manual Testing using Quality Center.
• Used Informatica Power Center Workflow Manager to run the workflows. heterogeneous
• Conducted white Box Testing - Functional, Regression and Data Driven.
• Verification of test results, comparing and analyzing.
• Developed User-Acceptance Test cases and assisted users in conducting UAT
• Conducted UAT to ensure dat application was user friendly and functioning according to desired requirements
• Used Informatica Power Center Workflow Monitor to review the session log files.
• Participated in the review meetings to resolve the issues.
• Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
• Prepared test strategy to validate Teradata reports against Oracle reports.
• Defined the Scope for System and Integration Testing
• Documented and published test results, troubleshooting and escalate issues
• Preparation of various test documents for ETL process in Quality Center.
• Involved in Test Scheduling and milestones wif the dependencies.
• Used Toad to write SQL and query Oracle database.
• Functionality testing of email notification in ETL job failures, abort or data issue problems.
• Responsible to understand and train others on the enhancements or new features developed
• Create and execute test scripts, cases, and scenarios dat will determine optimal system performance according to specifications.

Environment: HTML, SQL, SOAPUI, Informatica Power Center 8.6.1,UAT, QTP 9.2, Quality Center 9.2, Oracle 10g, Toad, XML, Windows XP AutoSys and Cognos.

Confidential, NJ

ETL Tester

Responsibilities:

• Participated in all meetings wif project team members on Overview and Architecture.
• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Worked on testing data migration, data integration and data transformation.
• Involved in Black box testing.
• Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing
• Written test cases to validate the ETL Informatica mappings and maplets.
• Executed SQL queries using TOAD to query Oracle database.
• Used Inner join, Outer Join, MINUS operations and Case statements in SQL scripts.
• Used SQL Assistant to write SQL and query the Teradata database tables.
• Created complex SQL queries to validate the initial and incremental ETL loads.
• Used PL/SQL function to validate some test scenarios.
• Tested both multi-protocol and multi-party processes.
• Worked wif UNIX commands like GREP, LESS and Diff.
• Tested several Informatica Mappings to validate the business conditions
• Written positive and negative test cases for Cognos reports based on report specifications.
• Worked wif XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Exported the Report data from Oracle and Teradata warehouse to Excel and validated using formulas.
• Validated several Drilldown and Pivot reports published in Cognos Scoreboard.
• Worked on testing report filter and view filter in Cognos reports.
• Worked wif non-transactional data entities for multiple feeds of data using MDM
• Validated Prompts, filters, calendars and Cosmetics in reports.
• Participated in Project Status meetings and updated QA status and defect status.
• Used Quality Center to document and open defects and track them from time to time.
• Interacted wif developers to resolve the ETL and reports defects.

Environment: Oracle 10g, SQL, TOAD 10, Informatica 8.1, Cognos, Teradata V2R6, MS Access, MS Excel, MS Word, XML, SQL Developer, SQL Assistant, SQL Plus, Unix, Quality Center 9.0.

Confidential, Providence, RI

DWH Tester

Responsibilities:

• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Written SQL queries on data staging tables and data warehouse tables to validate the data results.
• Check the naming standards, data integrity and referential integrity.
• Responsible for monitoring data for porting to current versions.
• Used Quality Center for defect tracking, test cases, test plan, updating the bug status and discussed wif developers to resolve the bugs.
• Perform full manual regression testing of MDM
• Automated and scheduled the Informatica jobs using UNIX Shell Scripting
• Validating the reporting objects in the reporter against the design specification document.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Validating the data files from source to make sure correct data has been captured to be loaded to target tables
• Validating the load process of ETL to make sure the target tables are populated according to the data mapping provided dat satisfies the transformation rules.
• Developed XML test files based on XML schema.
• Used TOAD & SQL Navigator GUI tools for Querying Database.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
• Tested Canned/Ad-hoc reports using Cognos Reporter functionalities like Cross Tab, Master Detail and Formulas, Slice and Dice, Drill Down, variables, filters, conditions, breaks, sorting, Functions, Alerts, Cascading Prompts and User Defined Objects.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Responsible for reporting and escalating data issues arising from project or daily support.
• Performed Black box Testing, Regression and end-to-end testing.
• Developed/revised documentation and procedure manuals.

Environment: Informatica, SQL, PL/SQL, Mercury Quality Center, TOAD, Rational Clear Quest, MS Excel, XML, Cognos, Teradata V2R5

Confidential

Jr. QA Tester

Responsibilities:

• Developed test plans, test scripts and build scenarios work flows according to the user requirements.
• Conducted black box testing of the application.
• Involved in conducting the Functional, Regression and Integration testing.
• Performed functional testing using QTP
• Wrote test cases for testing the project, ensures dat the components of the system successfully integrate and function together
• Executed test scripts using QTP, analyzed the results & reported bugs using Quality center.
• Performed Black Box testing for testing all the business requirements and the System functionality
• Performed extensive security testing to ensure dat the security and integrity of the system is maintained
• Used QC extensively to maintain test cases and also for tracking the defects
• Logged bugs, assessments of bug severity and Bug Tracking
• Actively interacted wif developers to resolve technical issues
• Performed regression testing following the framework migration from JSF to struts
• Used Back-end testing using SQL queries to validate the data in the back-end Oracle Database.
• Identified bugs and interacted wif team lead and developers to resolve the bugs

Environment: Oracle 9i, RAD, Java, Struts1.1, JSF, QTP 9.0, Quality center, Solaris, Windows XP.