SUMMARY:

• Above 6+ Years of diversified experience in, Development, Analysis & Software Quality Assurance testing in data warehousing methodologies, ETL Tools, OLAP Tools Business objects, OBIEE, Siebel Analytics, Informatica and Client/Server Applications.
• Expertise in OLTP/OLAP System Study, Analysis and ER modeling, and Dimensional Modeling (Star schema and Snow flake schema).
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.
• Excellent programming skills using stored procedures and Oracle (PL/SQL) and Unix Shell Scripting
• Extensive experience in Project documentation of designing and Test Procedures Very strong knowledge in relational databases (RDBMS), data modeling and in building Data Warehouse, Data Marts using Star Schema and Snow Flake Schema.
• Expertise in full life cycle of ETL (Extraction, Transformation and Loading) using Informatica Power Center (Repository Manager, Mapping Designer, Workflow Manager, Workflow monitor)
• Extensive experience in implementation of Data Cleanup procedures, transformations Scripts, Triggers, Stored Procedures and execution of test plans for loading the data successfully into the targets
• Implemented performance tuning techniques at application, database and system levels
• Strong experience in Oracle database Performance & Tuning by explain plan and creating bitmap indexes and hints
• Experience with QA Principal CMM levels and Software Development life Cycle process improvement.
• Experienced in evaluating test results using test tools to manage Test scripts, Test execution and Defect Resolution process.
• Experience in automation of test cases using Mercury Tools (Test Director, Win Runner, QTP, Load runner)
• Experience in QA methodologies like CMM and RUP.
• Created various Testing Metrics in the various status reports like Weekly Status Reports, Monthly Dashboard and Test Summary Reports.
• Extensive experience in Black Box & White-Box Testing.
• Strong in Analyzing Business specs Requirements & Develop Comprehensive Test Spec & executes them.
• Experience in entire SDLC and QA life Cycle.
• Experience in writing Test Plans, Defining Test Cases, Developing and Maintaining test scripts according to the business specifications.
• Ability to interact with developers and product analysts regarding testing status.
• Expertise in Problem solving and Tracking Bug Reports using various Bug tracking Tools.
• Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.

TECHNICAL SKILLS:

Operating Systems:

Windows NT/95/98/2000, HP-Unix, Linux.

Databases:

SQL Server, Oracle 8i/9i/10g/11g, Teradata v2r5/v2r6

Languages:

Shell Scripting, JavaScript, ASP, HTML, SQL, PL/SQL, T-SQL

ETL Tools:

Informatica 7.x, 8.x, SSIS

OLAP Tools:

Business Objects XI, OBIEE 10.1.x.x, Siebel Analytics 7.x

Configuration Mgt Tools:

Rational Clear Case, VSS and star team

Defect Reporting Tools:

Test Director, Rational Clear Quest, Star team, Project Traq, Bugzilla, JIRA

Performance Testing Tools:

Load Runner, Astra Load Test

Functional Testing Tools:

Mercury Win Runner, QTP, Rational Robot,
Astra Quick Test.

Version Control:

Microsoft TFS, Guidewire Policy Center

FTP /Database/Design Tools:

TOAD 8.x/9.x, SQL Developer, Microsoft Visio.

PROFESSIONAL EXPERIENCE:

Confidential,WI Nov 2010- Till Date
Web Application Tester/Analyst
Confidential,needs Quality team to ensure the implementation of Guidewire Policy Center and customized as per the business rules.

Confidential,came up with an idea of an Advance Team Program which consists of three major phases: Foundational, Homeowners Policy and Auto Policy, supporting
the strategic direction of Personal Lines, replacing multiple Customer Management and Policy Administration systems into one common platform, the Guidewire application.
Guidewire Policy Center is a flexible underwriting and policy administration system that enables general insurers to grow business profitably by improving efficiency, while responding with agility to market opportunities and enhancing relationships with brokers and customers. Designed to support both commercial and personal lines, Policy Center helps insurers streamline front and back office processes, from new business submission and quoting through policy renewals.
American Family insurance products include: term, universal, and whole life insurance; personal and business auto insurance, personal umbrella insurance, home insurance; motorcycle, boat, motor home, snowmobile and car insurance; business liability key policy, and business policy package insurance; farm and ranch liability insurance; travel, trip cancellation, and global medical insurance.

• Involved in the Preparation of Test Strategy and Test Plan documents.
• Involved in the Requirement analysis in Rational Requisite Pro and Test Case design in Quality Center.
• Worked closely with the Business Analysts and the Business to understand the requirements and Business flow of the application.
• Lead the Interface, Policy and the Rating Modules and played the role as a Team Lead and Onsite Offshore Coordinator.
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage’s, Risk Analysis Customizations.
• Created the Requirement Traceability Matrix (RTM) and evaluated Test Coverage in Quality center.
• Prepared Weekly and Monthly Status dashboards for Project Test Status updates. Dashboards included various defect and Project related Metrics details.
• Used JIRA as the Defect Tracking tool and updated the defect logs.
• 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.
• Involved in the Preparation of Business Process Test Cases in Quality center Designed the Test Design and Test Execution
• Scorecard for reporting the Status of Test Case Design and Test Case Execution.
• Scorecard is a dynamic tool with different Design and Execution Metrics displaying the Progress of the Project.
• Involved in the System, Regression and UAT Testing Phases of the application.
• Involved in the implementation of Modified Condition/Decision Coverage for testing the Business Rules and Edits of the application.
• Implementation of Guidewire Policy Center -Application Quality Index worksheet after the end of every release to determine the quality of the application during each round of testing for providing QA Signoff.
• Involved in the review of test cases and test scenarios of the Policy module.
• Involved in the Integration Testing, System testing, Regression testing of the End to End testing.
• Prepared the Test Summary Report at the end of each round of Testing.
• 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.
• Used 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.

Environments: Microsoft Windows XP, Guidewire Policy Center 6.0, JIRA 3.7, Rally

Confidential,IN Jan 2010 – Oct 2010
Sr.DW Analyst/Tester
Confidential,is the biggest student loan provider and is a publicly-traded U.S. corporation, whose operations are originating, servicing and collecting on student loans, managing more than $180.4 billion in debt for more than 10 million borrowers.

Project Summary: The GRC/APG Cohort Management System is a system designed to collect information about client schools and its students in effort to control and improve the default rates. The data is received from various sources including the client schools themselves and is loaded into the SQL server database, processed for data exceptions, moves it through various stages trying to integrate the data from diverse sources together, generate output files to the operational system and also end-user reports, both internal to better service the clients and external to give the insight to the client schools being serviced.

• Performed End to End testing for the ETL Load process which included testing incoming file format, Loading Staging tables, Business rules implementation, Matching Criteria, Data Cleansing, Load to final tables and Reports generation.
• Prepared and implemented detailed test plan for the complex financial reports which included Quantitative (Data Testing) and Qualitative (Business Rules Implementation) testing.
• Worked as Senior QA Lead and performed the overall responsibility of modules and worked with other developers and ensured smooth delivery.
• Analysis of requirements and use case documents. Work with business analysts and address the gaps in requirements.
• Work closely with client architects and formulate design for the individual modules. Prepare Technical design documents (TSD’s).
• Quantitative and Qualitative testing of the ETL packages using SSIS 2005/2008.
• Provided insight to the developers to enhance the system efficiency by redesigning few modules to make them reusable.
• Lead the Migration project from one Domain to another domain after acquisition of new business unit (From Arrow Financial network to Sallie Mae network)
• Production support. Troubleshoot and fix production issues.
• Collaborated with other ETL experts in evaluating the efficacy of load processes and transactional data.
• Extensive work on SQL which included writing complex SQL/PL SQL queries, Stored Procedure, Functions, Triggers, optimizing queries using various tools, creating tables etc.
• Ensured accuracy of data by defining and building necessary audits and controls.
• Extensively used Microsoft TFS to maintain the documents and versioning.
• Performed the appropriate documentation for all the projects for future reference.

Environment: SQL Server 2005/2008, SSIS, SSRS, Windows 2003/ UNIX, HP Quality Center 9.2

Confidential,CA Nov 2008 –Dec 2009
Sr. DW/QA Tester
Customer Order Tracking Analytical System was implemented for Consumer Goods section to take care of incidents or defects with the already shipped products and tracking the contracts for maintenance requests and any new procurement requests by clients. It also allowed users to give the capability to perform trend analysis and customer segmentation.

• Interacted with Developers and Business Analyst regarding requirements, test scenarios, and defects.
• Analyzed the ETL design documents to understand the logic.
• Performing Integration testing for all the Mappings in “Customer Order Tracking DM” and documenting the results.
• Performed troubleshooting the loading failure cases, including database problems.
• Worked on different Test Decks on different releases for East & West on Orders and Pre-orders.
• Developed Base line scripts for testing the future releases of the application using Quick Test Pro (QTP).
• Prepared Functional, scope and ETL mapping documents for COT Data mart.
• Executed the test cases for Staging Tables and Member tables and validate the data results.
• Updated the test cases on based on the requirement changes and executed the test cases.
• Wrote the SQL queries & PL/SQL code on COT tables and Data Mart Staging Tables to validate the data results and documented.
• Prepared Test Plans, Test Scripts, Test cases and validated the Test cases.
• Created and monitored daily incident Report.
• Utilized Win Runner extensively.
• Extensively used Microsoft TFS to maintain the documents and versioning.
• Involved in Regression, Release and System Integration testing.
• Involved in Reference tables updates as part of Testing.
• Used Quality Center for the bug tracking purposes.
• Participated in overall end-to-end testing.
• Working with different data sources, like Informix, Oracle, Teradata, Flat files, xml files, and handling huge data.
• Participated in validating OBIEE (frontend) dashboards/reports, and documented results.
• Included in meetings with the Development Team to discuss the open defects.
• Supporting and coordinating onsite/offshore teams.
• Created excellent documentation for client’s future use.

Environment: Oracle 10g/11g, Informatica 8.1, Linux, TeradataV6, OBIEE 10.1.3.4, IBM Lotus Notes, HP Quality center 9.0, Microsoft TFS

Confidential,Atlanta, GA Jan 2008 - Nov 2008
Sr. DW Tester/QA Tester
Confidential,is comprised of numerous business structured to meet targeted customer needs. GE Power systems Data Warehouse is built upon integrated legacy system data feeds received from many business data sources. This will allow GEPS management to continue to analyze the organized data and enables both tactical and strategic decision- making.

• Organized, prioritized, tracked and controlled requirements using Requirements manager module in Test Director.
• Reviewed and analyzed requirement document for writing the Test cases.
• Developed a Test plan based on testing requirements and created Test cases using Test Plan manager module in Test Director. This also includes Designing Tests, Automating tests when appropriate, and analyzing the Test plans.
• Used Database Checkpoints by using the SQL statements to extract data from Oracle tables and verify the output data on the browser page.
• Associated Test cases to requirements in order to ensure that all the functional requirements have been covered in the Test cases.
• Gathered Test Input data. Test Input data includes Pre-condition, Test Input, Test Result and Test Regression data.
• Automated Web Based testing using Quick Test Pro (QTP).
• Developed Base line scripts for testing the future releases of the application using Quick TestPro (QTP).
• Performed QTP with win32 applications.
• Automated the Test cases using Win Runner for Regression testing. Automation includes writing Test scripts in TSL.
• Performed GUI testing by Manually and automated with Win Runner
• Used QTP as Recovery Manager, for automatic recovery, useful in unattended testing.
• Created GUI, Bitmap Verification points in Test scripts.
• Performed Data driven testing using data tables in Win Runner.
• Extensively worked on XML for data transformation of data from flat files to the database.
• Involved in writing and implementing Detailed Test Plan and developed Test Cases and Automated Test Scripts in QTP through Test Director.
• Created Synchronization points to synchronize the Test script to the Application speed.
• Extensively worked on XML for data transformation of data from flat files to the database.
• Used GUI map configuration, Virtual Object wizards to map a custom GUI object class to a standard Win Runner GUI object class.
• Organized tests in to Test sets. Scheduled and ran the tests using Test Lab manager module in Test Director.
• Extensively worked on Oracle. Stored, analyzed and prioritized defects using Defects Manager module in Test Director. Analyzed various graphs and reports to make decisions about requirements coverage, test readiness and overall application quality. Reported defects to the developer upon detection of bugs.

Environment: Informatica 8.x, Oracle 9i/10g, OBIEE 10.1.3.x, Test Director, Quick Test Professional, XML, Toad, Windows 2003, MS CRM, Microsoft Visio.

Confidential,CT Oct 2006 – Dec 2007
DW Tester/QA Analyst
Confidential, is one of the leading insurance companies for healthcare, ACC (Aetna Customer Care) is an application used by the field agents of the company to maintain the data of present and prospective customers for statistical and business analysis purposes. This is an Intranet application. It offers data about the insurance policies of customers. It is designed for quote, new business and customer care models. Quote helps to see the premium and new business for purchasing the insurance. Customer care provides the company with statistical data for better customer management. Also implemented the HIPAA guides for each transaction.

• Involved in writing Test cases and developing Test Plans.
• Wrote the Unix Scripts for counting fields, converting the ASCII to Text files
• Ran the UNIX shell scripts to count the records for ALSS Source to Stage and Comparing with header Tables
• Have knowledge of 837,835 transactions. For each transaction there is specific document like modifying the definition, add any additional data elements.
• Found the Defects when running the test cases in Test Director in data stage jobs
• Assign to ETL Developers using PVCS Defect Tracking tool
• Involved in reviewing Business Requirements and Use Cases.
• Automated scripts using Win runner.
• Tested Application for HIPAA standards compliance
• Conducted data driven tests using win runner.
• QTP was integrated with Win runner.
• Responsible for GUI Testing, System Testing, Regression Testing and Acceptance Testing.
• Tested the application on different browsers and verified the links of the application.
• Use SQL & PL/SQL to test backend functionality.
• Used Test Director for defect tracking and participated in Bug reporting and reviews.

Environment: SSIS, Siebel Analytics 7.8, Oracle 8i/9i, SQL Server 2005, Microsoft Office, UNIX, Windows NT.

Confidential, Mar 2005 – Sep 2006
Programmer /QA Analyst
Client: Confidential,
Confidential,was developed for Punwire Telecom Services ltd. This application consists of four modules Stock maintenance, Sales, Payroll and Financial accounting. I was involved in Stock maintenance and Sales modules.

• Generated Reports using Crystal Reports Tool
• Involved in manual Testing
• Developed and executed test document and test cases
• Handled large amount of data & worked with the source code.

Environment: Windows NT, SQL Server 2000, DTS, Crystal Reports.

Confidential,Bangalore, India June 2004 – Mar 2005
Verification & Validation Engineer

The Main Objective of this Project is to test the Features of VCRCOMBI + RW, HDD-Combi which are Combination of VCR, DVD and Hard Disk, DVD Recorders. By Using this Device We can do Manual and Timer Recording from Any Input Source like TV, Cam, Satellite On to Disks like DVD, DVD+RW, DVD+R and on to VCR, HDD in Different Recording Modes Like M1, M2, M2x, M3, M4, M5 and M6, Play Back from the same. This Device Will be having One Key Feature called Dubbing by this we can Dub Data from VCR to DVD, HDD to DVD and visa versa. These Devices having the latest Feature called EPG (Electronic Programming Guide), which was tested thoroughly.

• Execution of Test Cases using Test Generator
• Performing GUI, Functional and Regression Testing
• Detecting the bugs, classifying them based on the severity and Problem Raising on Change Synergy’s Telelogic.
• Providing screen shots to identify & reproduce the bugs

Environment: DMN 8600, Test Quest, Test Generator.