SUMMARY

• Results oriented professional with over 8 years’ of experience in implementing and analyzing requirements to meet complex business needs successfully delivering high quality, effective and innovative business solutions through Quality Testing. Experience in various domains: Financial (banking, credit cards, mortgages, loans), Pharmaceutical (front end manual MySap application) & Insurance (Online quotes, login, auto, property).
• Extensive experience in Manual Testing - both web based frontend and backend / database Testing.
• Strong experience in writing Test Plans, Test Conditions, Defining Test Cases, Developing and maintaining Test Scripts, analyzing the results of scripts, interaction with team members in fixing the defects for both manual and backend testing.
• Strong Extensive working experience on Integration Testing, Functional Testing, GUI /frontend Testing, Regression Testing, Integration Testing, System Testing, Database Testing, Smoke testing, Usability Testing, Sanity Testing, Exploratory Testing.
• Strong experience in using test management tools like HP ALM, Quality Center(QC) and Test Director for Requirement Management, Test Planning, Test Case development, Test Case execution and Defect Tracking. Used QTP for running automation regression test scripts.
• Good knowledge of full life cycle implementation of the BI DW projects through SDLC life cycle:Well versed with all project management methodologies including Agile, Waterfall with a prime focus on DB and GUI testing.
• Strong understanding of STLC (Software Testing Life Cycle) and SDLC (Software Development Life Cycle).
• Involved in all stages of Test Analysis and User Acceptance Testing (UAT).
• Strong understanding of data warehousing concepts- OLTP, OLAP, Normalization, Types of Dimensions and Facts, Star and Snow Flake data models.
• Hands on experience with Informatica Power Center client tools like Informatica Workflow Manager and Informatica Workflow Monitor.
• Very good experience withDevelopment and Delivery teams, offshore teams,Customer and Vendor relations, Onsite teams.
• Good experience in writing Oracle SQL queries in SQL Developer for backend/ETL testing RDBMS databases like Oracle, to test the data loaded into the Target table as per the transformation rules.
• Proficient with UNIX commands.
• Extensive experience in analyzing business requirements and system functional specifications including use cases. Good understanding in types of dimensions and facts, Data Analysis, Normalization and strong understanding of Relational DBMS.
• Have excellent written and oral communication skills with the ability to communicate appropriately in business and technical situation at all levels.
• Very efficient team player from business requirements to scope development and understanding deliverables, self-motivated and a quick learner with zeal to explore new technologies.

TECHNICAL SKILLS

Test Management Tools: HP Quality Center(QC) 10.0, HP ALM 11.0, Test Director

Defect Tracking / Automation Tools: IBM Rational Clear Quest 9.0, QTP 10.0 (Quick Test Pro) and Jira

ETL Tools: Informatica 9.0, Datastage

BI/Reporting: Business Objects, Cognos

Operating System: Windows, UNIX, Linux

Methodologies: Agile/Scrum, Waterfall

Programming Languages: SQL, VB Script

RDBMS/ Database: SQL Server, Oracle

GUI Tools: Oracle SQL Developer, TOAD, SQL Plus, SQL server

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Database Tester/Frontend Manual Tester

Responsibilities:

• Analyzed System and functional Requirements (user stories) and designed test cases according to the STT (Source to Target) mapping.
• Worked on Agile methodology. Attended daily Scrum meetings.
• Developed Test Plans, Test Cases and Test Scripts for SIT and support for UAT tests.
• Manually tested the Credit Data Warehouse application as per the Functional req documents and Use cases
• Developed Tractability Matrix and Test Coverage reports.
• Responsible for manually testing of the CDW web component, the assigned section and to log defects and worked in sync with the other testers, interact with Business team and the developers to meet the deadlines.
• Wrote detailed test cases for black box testing of the application
• Performed re-testing, regression testing, usability testing and assisted UAT testing for the in-house application
• Managed and conducted System testing, Integration testing and Functional testing.
• Utilized ALM to design the test cases, execute them and to log the defects.
• Tracked the defects using HP ALM tool and generated defect summary reports. Prepared status summary reports with the Test Matrix - details of executed, passed and failed test cases
• Used SQL Loader Tool to load the data from the flat files into the Database.
• Worked on Oracle SQL scripts to test the loaded data in the target tables.
• Worked with Informatica Power Center tools - WF Manager and WF Monitor for testing .
• Tested all the ETL processes developed for fetching data from OLTP systems to the Risk Management environment.
• Used INSTR, SUBSTR functions, wrote DECODE and MINUS queries extensively in SQL Developer to manipulate the data into the target table.
• Hands on with Informatica Monitor, validating and debugging its components, and monitoring the resulting executable versions.
• Tested the extraction of data from the flat files and other RDBMS database into staging area and populated onto data warehouse.
• Understood the ETL architecture and Source to Target mapping to load data into Data warehouse and came up with the test scenarios accordingly.
• Actively interacted with developers, Business & Management Teams and End Users. Involved in Defects meetings, QA team meetings to discuss the defects with Development, QA, and Business and concerns and road blocks in the testing environments.
• Resolved the issues/defects after clear understanding of the root cause and mitigation plan. Provided implementation and post-implementation support.

Environment: HP ALM 11.0, SQL LOADER, IBM CDC, Oracle DB, SQL Developer, Informatica 9.0, Agile

Confidential, Chicago, IL

ETL Tester/Database Tester

Responsibilities:

• Used HP Quality Center as a centralized repository for analyzing requirements, test cases, logging and tracking defects.
• Analyzed and wrote detailed test cases, test plan, prepared test scripts,
• 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, re-testing, regression testing, integration testing, System Testing, Data Integrity Testing and end to end testing.
• 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.
• Tested Type1 SCD and Type2 SCD tables.
• Used logical and physical data models that was done using Erwin for data warehouse to come up with the test cases and test scripts.
• Extensively used ETL to load data from Flat files to Oracle database.
• Used SET operators, aggregate, analytical functions and CASE expression in SQL to match the data in target to the source tables.
• Wrote various medium to complex SQL Queries to validate and perform the backend testing.
• Tested Informatica mappings for various ETL functions and transformations.
• Used corresponding SQL functions as per the transformation logic given in the source to target mapping document
• Interacted in regular meetings with Developers to understand the problems during various phases.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Wrote Unix commands to compare the data using CMP and DIFF, FTP for file transfers and connect to other servers, renaming the file, extracting date etc.
• Tested the scheduled Unix batch jobs according to the specifications and the functionality for scheduling and running the required jobs.
• Developed test scripts based upon functional requirements and processes. Processed transactions from system entry to exit.
• Used Informatica Workflow Manager to run Informatica mappings and Workflow Monitor to monitor ETL execution and logs.
• Extensively used Unix commands, Tested the ETL Informatica and other ETL Processes (Data Warehouse Testing) both before data validation and after data validation process.
• Tested messages published by ETL tool and data loaded into various databases and performed the tests in both the SIT, QA and contingency/backup environments.
• Performed system analysis and development of all level project technical requirements and testing strategies.
• Involved in extensive DATA validation using SQL queries while doing the back-end testing

Environment: Informatica 8.6, Oracle 10g, SQL Developer, SQL, Unix, HP QC 10.0

Confidential, Minneapolis, MN

Systems QA Analyst for Manual Testing

Responsibilities:

• Analyzed System Requirements and Use cases for designing the test cases.
• Conducted functional and regression testing during various phases of the development on multiple layers of the application.
• Used Quality Center to generate the Test cases and to execute them.
• Heavy integration testing done for various modules to ensure smooth SIT
• Used Clear Quest and Quality Center to log the defects.
• Transitioned from Waterfall to Agile methodology.
• Interacted with the Business Analysts regarding the High level Business Requirements and the Use cases.
• Performed Smoke Test against every build and send the build reports to the Project Manager, BAs and Developers.
• Involved in Defects meetings with the developers and Business team regarding the requirement clarifications, defect fixes, tracking of Business defects.
• Performed Cross Browser testing on different combinations of OS- XP,Win 7,MAC and Browsers like IE7,8,9,FireFox-3.6,9,10,Chrome,Safari.
• Updating the Requirement traceability matrix.
• Used SQL queries for data retrieval.
• Performed regression testing using QTP. Executed / ran regression test suite to ensure proper functionality.
• Responsible for weekly status updates showing the progress of open issues to be resolved.
• Actively participated in Team meetings to share the different testing methodologies.
• Worked in Agile methodology.
• Supported Production installs and testing in other environments like SIT, UAT, and Prod
• Performed End to end testing starting from the source to the report.
• Coordinated with on-site and offshore resources on the testing tools and application functionality.
• Got trained in test automation tool - HP QTP( Quick Test Professional) (VB Script).

Environment: Oracle 9i, Java, J2EE, Ajax, Solaris 9 and Windows environment, HP Quality Center 9.2, Rational Clear Quest, QTP 10.0

Confidential

Junior Tester/Manual Tester

Responsibilities:

• Understand and analyze Business Requirements and Functional requirements to designed test cases based on the Use cases and wireframes.
• Interacted with the Business Analysts and SMEs regarding application’s functionality and any clarifications needed on the documentation.
• Participated in the Use cases and Wireframes review sessions.
• Utilized Quality Center to design the test cases, execute them and to log the defects.
• Involved in Integration testing and System testing of the application.
• Responsible for performing functional and regression testing.
• Involved in status call meetings and daily stand up meetings to talk about the progress of the assignments on the project and to discuss on the issues, concerns and road blocks in the testing environments.
• Involved in Defects meetings to discuss the defects with Development, QA, Business.
• Interacted with the developers regarding the defects and scheduled live meetings to resolve the issues and get clear understanding of the defects.
• Involved in sprint review meetings to showcase the application to the product owners.

Environment: Quality Center 9.0, Windows Vista, Windows 7 Professional