SUMMARY:

• Proficient in analyzing the Business Requirements, System Requirement Specifications, Functional Requirement specification, Design Documents to formulate Test Plans, Test Strategies, and Test Cases.

• Over 8+ years’ experience working as a QA, DWH, ETL Tester in various domains like Banking and Healthcare.
• Experience in Full life cycle of software projects including system analysis, design, development, testing, implementation and user training
• Expertise in creating Test Plans and executing Test Scripts.
• Prepared and documented Test Cases and Test Scenarios for both Manual and Automated testing. Tested dimensional data loads and fact data loads.
• Experience in developing stored procedures for data warehouse transformation process.
• Experience in conducting Integration, System, Functional, Regression, GUI, Stress, and Performance Testing.
• Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Mercury Quality Center
• Experience with Business Objects XIR2 and dynamic dashboards, scorecards and structured reports for operations and higher management.
• Expertise in creating and integrating BO reports and objects with the data warehouse.
• Extensive testing ETL experience using Informatica 8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
• Expertise in writing T -SQLs to retrieve one time load data from databases, based on the input mapping. Skilled in data manipulation using SQL queries.
• Experience in various web-based, client-server and distributed multi-tier applications deployed on multiple platforms.
• Developed Test Cases, Test Plans and produced Bug Reports Experienced in executing PL/SQL
• Strong working experience in Windows NT/2000/XP and UNIX environments
• Good communication and inter-personal skills, accustomed to work in a team environment with tight schedules and capable of working efficiently under pressure, manage multiple project and cross train sub-ordinates in other Functional areas

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 7.x/8.x, Power Mart, Ab Initio, SSIS

Operating Systems: Windows NT, SCO Unix, Sun Solaris, Red Hat Linux, HP-UX

Data Modeling: Erwin 4.0, Toad 8.0/7.0 (Tool of Oracle Application Development),SQL developer

Programming Languages: Visual Basic 6.0, C++, COBOL, C, C#, Java

Database: Oracle, Microsoft SQL Server, Microsoft Access,Teradata,DB2

ERP: Oracle Applications 11i E-Business Suite

Reporting Tools: Business Objects 6.5/XIr2,Cognos

Testing Tools: HP Quality Center 10.0, Rational Clear Quest, Test Director, Mantis, Jira

Other: Putty, nMap, WireShark, Packet-Tracer, Encryption, Penn testing, FTP, Winscp, The Forensic Toolkit, Regular Expression, Firewall, RoutingParallel programming, PHP, HTML,XML, Json, WSDL, SOAP, JavaScript, MS Visio, Office Suite

WORK EXPERIENCE:

Confidential, Milwaukee, WI

QA Test Analyst

Responsibilities:

• Designed and Created test plan, test scenarios and test cases.

• Responsible to translate business requirements into quality assurance test cases
• Review of test scenarios, test cases and Data warehouse Test Results.
• Developed test scripts using SQL queries to validate data.
• Prepared Regression Test Plans, Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use.
• Interacted with Users to understand the bugs in Business Reports generated from OBIEE.
• Tested the reports like Drill Down, Drill Up and Pivot reports generated from OBIEE.
• Performed front-end testing on OBIEE Executive Dashboard portal
• Interacted with design team to decide on the various dimensions and facts to test the application.
• Planned ahead of time to test the mapping parameters and variables by discussing with BA’s.
• Have tested SSIS packages according to business requirements and data mapping requirement documents.
• Extensively used Rational Clear Quest to track defects and managed them.
• Tested several reports detailing price/volume trends and expense variance over previous periods by using financial reporting and through the Interactive Reporting.
• Extensively tested several Business Objects Reports for data quality, fonts, headers, footers, and cosmetics.
• Executed automated test scripts using QTP for Regression testing.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Responsible for documenting the process for future references.
• Responsible for in-depth knowledge of data, processes or applications in their specific area of responsibilities
• Reviewing the test activities through daily Agile Software development stand-up meetings.

Environment: Informatica Power center 9, HP Quality Center, OBIEE 10g, Rational Clear Case, Rational Clear Quest, TOAD, JCL, Web Logic, Quick Test Professional (QTP), Java, Oracle 11g/10g/9i, SQL Server 2005, SSIS, SSRS, PL/SQL, Linux, Win XP, Asp.Net

Confidential, Indianapolis, IN

QA Test Analyst

Responsibilities:

• Interacting with Business Analysts for Business Requirements, testing scope reviews, inspections and test planning.

• Prepared Tractability matrix and prioritized test cases.
• Involved in creating Test Plans, Test Scenarios, Test Scripts based on business Requirements, Use cases and Functional Specifications in Test plan tab of Quality Center tool
• Create and maintain a Requirements Traceability Matrix
• Performed extensive Data Integrity testing by executing SQL Statements on Oracle & SQL database
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.
• Tracking and analyzing the defects and recording the variation between the expected and actual results
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• TOAD was used to perform manual test in regular basis. UNIX and Oracle were used in this project to write Shell Scripts and SQL queries.
• Used selenium Automation tool.
• Modified Test cases according to design doc’s changes, executed the test cases, Interpreted test results and determine pass/fail.
• Perform integration testing, functional testing, black box testing, system testing, user acceptance testing, and regression testing, as required.
• Perform backend testing using SQL queries to validate and verify data in database.
• Checking the integrity of UI data with the database using SQL queries, checking executing of stored procedures with the input values taken from the database.
• Executed the Test cases, Test Scenarios in Test lab tab of Quality Center.
• Communicated the issues/defects to the developer using Quality Center tool.
• Participated in bug review meetings with the software development team throughout the testing phase.
• Created Test metrics and participated in status meetings and reported the progress to the manager.

Environment: Informatica, Oracle 11g, Selenium,Toad,DB2, MS Office tools, SQL Query Analyzer, SQL Server 2008, Clear Quest, UNIX Scripting

Confidential

QA Test Analyst

Responsibilities:

• Involved in the meetings from the requirements phase prepared the TRDs based on BRDs.

• Responsible for preparing the mapping specification documents and developing the mappings based on the TRDs.
• Prepared master Detailed ETL and BI Test Plan for the entire Project.
• Performed End-to-End testing for the entire ETL and Business Intelligence. Involved in deployment the reports to production and debugging of reports
• Developed Test Plans based on Test Strategies and Developed scripts utilities simulators data sets and other programmatic test tools as required to execute Test Plans.
• Developed a testing strategy for all upcoming data feeds for both ETL and BI arena.
• Prepared traceability matrix for point's requirements from the completed test cases
• Extensively involved with ETL procedures/mappings/jobs and the testing of front-end reports
• Tested queries/reports/documents using Cognos
• Involved with extraction routines to verify all the required data loaded into target systems.
• Processed reject records for business rules for both dimensions and facts
• Conducted walkthroughs with the customer project management development team and Business Analyst
• Create detailed test plans based on analysis of requirements and design documents
• Analyzed raw points data to ensure the data met the business need
• Loading Flat file Data into Oracle tables using Unix Shell scripts
• Clearly communicated and documented test results and defect resolution during all phases of testing.
• Tested Complex Reports using Reporter module in Desktop/Web Intelligence functionalities like Slice and Dice Drill Down @Functions Cross Tabs Master/Detail and Formulae.
• Verified fields present in the reports are as agreed in the ETL specifications
• Extensively involved with backend testing by writing complex SQL queries
• Worked closely with business analyst and development group during the requirement phase and design phase to find out functional incompatibilities and software issues early in the QA process
• Worked closely with the development teams to replicate end user issues
• Supported Infrastructure Engineers Network Engineers Developers in creating testing checklists and coordinating testing for Projects Changes and Emergencies
• Communicated discrepancies determined in testing to impacted areas and monitored resolution

Environment: Oracle 9i/10g, SQL, PL/SQL, Stored Procedures, DB2, Toad, Erwin, Cognos, Test Plans Test Scripts, Test Cases, VSS, MS Office Suite, Informatica Power Center, Tivoli, MicroStrategy

Confidential, East Providence, RI

Data Analyst & ETL Tester

Responsibilities:

• Involved in Analysis Design and testing of various Enterprise Data Warehouse and Business Intelligence applications

• Attended the Requirements reviews Design reviews Code reviews to understand the overall process flow and Source to Target Mappings
• Used TOAD test various ETL process flow graphs to meet the Business rules and Technical Requirements
• Constructed SQL Queries to retrieve data from database
• Tested various Transformations for Data stage.
• Divided the graphs into various phases and used checkpoints to avoid Dead locks.
• Extensively worked on debugging ETL process graphs
• Developed and tested transformation functions and record formats for various input data files
• Prepared test data to verify the functionality of the Data stage.
• Generated the test data to perform the functional testing based on the DMLs and Record Formats
• Developed Test plans and Detailed Test cases based on business requirements
• Used Test Director to maintain Test Scenarios and Test execution.
• Involved in tracking the Defects using the Test Defect Tracking Tool and reported the bugs in the Test Director
• Analyzed the process to ensure that Business requirements are met and adhere to standards imposed by DW operations.
• Performed SQL validation to verify the data extracts and record counts in the database tables
• Tested Auto Sys jobs through command level to run the jobs to perform various tasks like Extract Transform and Load
• Involved in Unit testing of the Schema objects to test the Integrity of the Target Database (SQL server)

Environment: Business Objects Data Stage Designer, Manager, C#.Net, Web I 2.7, Oracle, Windows NT/2000, OWB