SUMMARY

• 6 plus years of experience in Quality Analysis, Data Analysis, Risk Management, Manual and Automated Testing on Client/Server and Web Applications.
• Experience implementing various QA methodologies involving preparing Test Plans, writing Test Cases and executing them.
• ETL/BI testing experience with extensive backend testing with good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
• Proficient in various SDLC processes including RUP, Agile, Iterative and Waterfall methodologies.
• 7 plus years of experience in RDBMS technologies like Oracle 9.x/10g/11g, DB2 8.0/7.0, MS SQL Server 2005/2008, and Teradata.
• Efficient in handling defect tracking and reporting process using Quality Center, Rational Clear Quest, Team Foundation Server - TFS, JIRA, Rally, Bugzilla.
• Involved in developing and maintaining Test Matrix and Traceability Matrix.
• Experience in data warehouse concepts and technologies like OLTP, Normalization / Denormalization, ETL, OLAP, Data Models (Star / Snow Flake Schemas), Data Marts (Dimensions and Facts) and Reporting.
• Experienced with ETL tools like Informatica, SSIS, Datastage, and Ab Initio.
• Experienced in testing Crystal, Cognos and Business Objects, OBIEE Reports.
• Experience in Data Analysis, Data Validation, Data Verification, data profiling, identifying data mismatch and Good experience with data sources.
• Experienced in querying the databases by developing and running SQL and PL/SQL queries using utilities like Toad, Rapid SQL and SQL Server Management Studio
• Experience in tracking, verifying and validating of Business and Functional Requirements.
• Experience in Testing ETL, PL/SQL, UNIX batch jobs using scheduling tools such as Autosys, Cron tab.
• Expert in writing Complex SQL Queries for backend testing and created several queries on the fly for user specific requirements for trouble shooting day to day production issues to identify root cause.
• Experienced in coordinating testing effort between on shore and off shore teams.
• Superior analytical, troubleshooting, communication and presentation skill.

TECHNICAL SKILLS

Database: SQL Server 2000/2005/2008 , Oracle 9i / 10g / 11g, DB2, Teradata

ETL Tools: Informatica 8.X, SSIS, AB Initio, DataStage

Reporting Tools: OBIEE, SSRS, SSAS, Cognos, Hyperion, MicroStrategy, Business Objects

Languages: SQL, PL/SQL, Java

Platforms: Windows NT/2000/XP, MSDOS, UNIX, VMware

Defect Tracking: Quality Center, Clear Quest, Rally, TFS - Team Foundation Server

Scheduling Tools: Autosys, Cron Tab

DB Query Tools: Toad, SQL Assistant, Rapid SQL

Requirement Tools: Rational Requisite Pro, Doors

Other Tools: Clear Case, Access/Word/Excel, MS Project, Visual Source Safe, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, MA

QA Analyst / Data Analyst/ ETL

Environment: Oracle 11g, Informatica 9.5, HP ALM Quality Center 11, SQL, PL/SQL, Toad, SQL Server 2008, Rally, ASP.NET, Java, Autosys, UNIX, Putty, ERWIN, QTP

Responsibilities:

• Analyzed business and system requirements, and manage development of specifications to create and execute detailed test plans, and verify bug fixes.
• Configured test environment and create strategy for product development and certification. Assure test data, and schedule automated/manual tests.
• Involved in rigorous meetings with testing team and DWH Lead to plan and implement the testing efforts.
• Performed front-end testing on Web focus reports.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, defect tracking and reporting.
• Extensively used Informatica Workflow Manager to run the workflows/mappings and monitored the session logs in Informatica Workflow Monitor.
• Verified session logs to identify the errors occurred during the ETL execution and used Informatica Workflow Designer to perform unit testing and identify the root cause.
• Created Test Cases, traceability matrix based on Data mapping document and requirements.
• Performed complex data validation using SQL queries.
• Written several complex SQL queries for data verification and data quality checks.
• Reviewed the test cases written based on the Change Request document and Testing has been done based on Change Requests and Defect Requests.
• Preparation of System Test Results after Test case execution.
• Prepared Test Scenarios by creating Mock data based on the different test cases.
• Perform defect Tracking and reporting with strong emphasis on root-cause analysis to determine where and why defects are being introduced in the development process.
• Debugging and Scheduling ETL Mappings and monitoring error logs Using Informatica and Autosys.
• Have tested reconcile and incremental ETL loads for the project.
• Used Rally and Quality Center as defect tracking tool.
• Worked in the role of data analyst in mapping and scrubbing sensitive data within the application.
• Involved in testing the Informatica mappings, by validating whether the mapping adhere to the development standards and naming conventions, whether the mapping do what the technical design says it should do.
• Coordinated onsite offshore testing efforts.
• Test Metrics and Defect Metrics measurement by preparing metrics sheet.

Confidential

Web QA Analyst / Data Analyst/ETL Testing

Environment: /Tools: Ab Initio, Oracle 10G, SQL, PL/SQL, DataStage 8, DB2, Rapid SQL, Doors, SharePoint, Rally, ClearCase, ClearQuest, QTP, Quality Center 9.2, Teradata, Teradata SQL Assistant, Cognos, MS Visio, UNIX, Putty, TOAD, Autosys, XML, XSD, XSLT, Business Objects BOXI

Responsibilities:

• Involved in Analyzing Data mapping specifications to create Test Strategy and detailed system test plans.
• Worked closely with the Business Analysts and developers to understand the ETL requirements and Business flow of the application and prepared test cases and test scripts.
• Before the Load is accepted to test, have performed the smoke or shake-out test.
• Wrote complex SQL queries for extracting data from multiple tables and multiple databases.
• Extensively used Oracle database to test the Data Validity and Integrity for Data Updates, Deletes & Inserts.
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Performed cross browser testing for web applications.
• Performed integration testing between the web pages and backend functions called on them.
• Created the Requirement Traceability Matrix (RTM) and evaluated Test Coverage in Quality center.
• Used ClearQuest as the Defect Tracking tool and updated the defect logs.
• Used DataStage director for running the datastage jobs.
• Maintained Rally for Task allocation and tracking the tasks to closure.
• Experienced in evaluating test results using test tools to manage Test scripts, Test execution and Defect resolution process.
• Prepared different sets of data for Data-driven testing.
• Validated Business Objects reports for lay out and data quality according to functional specifications.
• Involved in the Preparation of Business Process Test Cases in Quality center.
• Documented the Status of Test Case Design and Test Case Execution.
• Involved in the System, Regression and UAT Testing Phases of the application.
• Involved in the Production checkout for performing a quick Business Process and Smoke Testing of the application before QA Signoff.
• Extensive use of Rally Software to Organize stories (requirements), tasks, defects and tests plan and track iterations (sprints) and releases.
• Involved in using Rally for making the development organization faster, leaner and more agile and to get on the track with the User stories and to improve iteration planning practices.

Confidential

DWH / Report Tester

Environment: Oracle 9i, SQL, PL/SQL, Informatica, SQL Server 2005, Java Script, DB2, Visual Source Safe, Quality Center 9.2, MicroStrategy, ClearCase, Toad, UNIX, Autosys, Putty, MS Office

Responsibilities:

• Prepare Test Cases and Test Plan based on Business Line Functional requirements, Business requirement documents.
• Perform Black Box Testing, System Testing, Data Driven Testing, and Regressing Testing.
• Written complex SQL and PL/SQL scripts for Backend Testing.
• Tested Complex ETL Informatica and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Used Quality Center to organize and manage all phases of the software testing process, including planning tests, executing tests, defect tracking and reporting bugs.
• Conducted Result Analysis and interacted with developers to resolve issues related to bugs.
• Informatica mapping and workflows are tested according to the data mapping specifications.
• Micro Strategy reports are tested according to functional specifications for cosmetics and data.
• Participate in the Project Meetings and Walkthroughs in pursuit of Information Sharing as well as resolving the intermittent issues of concern.
• Helped new team members understand the business requirements & system flow.

Confidential

ETL / BI / Web Interface Tester

Environment: Informatica, Oracle 9i, Toad, SQL Server 2005, MS Visual Studio, MS Management studio, Web Services, Autosys, UNIX, Cognos, SQL, PL/SQL, T-SQL, Quality Center

Responsibilities:

• Analyze Business / Functional Requirements, create Traceability Matrix and identify test scenarios for Manual and Automated testing.
• Participated in creating over all Test Plan for the project with Business Analyst, IT Development and QA team.
• Actively involved in setting up Test Environment, Testing Tools, Test Procedures and defect reporting requirements and deliverables.
• Involve in creating Test Data preparation with the Business Analyst and IT Development.
• Tested web application for browser compatibility and data and lay out.
• Validated check boxes, radio buttons, broken URLs, drop downs etc. on web pages.
• Create and executed SQL Queries to ensure data related requirements works as per business rules.
• Configure test environment and create strategy for product development and certification. Assure test data, and schedule automated/manual tests.
• Extensively tested several Cognos Reports for data quality, fonts, headers, footers, and cosmetics.
• Execute the test cases/scripts and report the results.
• Query databases using SQL queries in SQL Server Management Studio to validate the data in target tables.
• Use Microsoft Excel to test small amount of data imported from different database management systems.
• Write complex SQL queries and executed them to validate the incremental SSIS Loads.

Confidential

Back end/ Web QA Analyst

Environment: Oracle 8i, SQL, PL/SQL, XML, Test Director, Cognos, VB.NET, SQL Server 2000, Crystal Reports.

Responsibilities:

• Participate in requirement gathering meetings with the users.
• Analyze requirements and prepare Business and Functional Requirement Specifications.
• Interact with users to come up with meaningful test scripts to simulate real-time business scenarios.
• Prepare Test Plan, develop Test Scripts based on business and functional requirements and execute them.
• Extensive use of SQL queries for backend database testing.
• Test Several Cognos Reports using Cognos ReportNet.
• Conduct regular QA Status Meetings with development team and business partners to discuss and analyze defects.
• Prepare QA Status Reports to communicate to the Project Manager on a regular basis.