PROFESSIONAL SUMMARY:

Over 7 years of experience in Information Technology with emphasis on Software Testing/Quality Assurance. Experience in using Quality Assurance for ETL, Backend, Web based, Client/Server Applications using Manual and Automated testing tools.

PROFILE:

• Good understanding of QA methodology and Software Development Life Cycle (SDLC).
• Involved in analysis, design and quality assurance of Client/server and Web applications for Healthcare, Health Insurance, Banking, Retail and gaming industries.
• Extensive experience with testing Multi-Tier application architecture.
• Developed Test Plans, Test Scenarios, and Test cases, Test Scripts, Test reports and Test Metrics for Manual as well as Automated testing for various applications to ensure proper business compliance.
• Diverse experience in Information Technology with emphasis on Quality Assurance, Manual Testing, Automated Testing.
• Excellent knowledge in ETL validation, Data Model Validations.
• Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
• Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
• Have good knowledge with Applications like Calyx point, PEGA, CALLIDUS etc.
• Extensive experience in client/server and web application testing using System Testing, Functionality Testing (White & Black Box), Integration Testing, Regression Testing, Smoke Testing, GUI Testing, Data base Testing and User acceptance testing.
• Experience in using Visual Source Safe and CVS
• Extensive experience with Data warehouse applications.
• Strong experience in automating the test using QTP and modifying the script code using VB Script.
• Strong knowledge in Automation tool QTP and Quality Center.
• Experience in End-to-End testing with CMM and ISO standards.
• Experience in BPT (Business Process Testing) by using QTP
• Expertise in Problem solving and Bug Reports using Bug Tracking Tools.
• Strong skills in backend (in both Relational & Hierarchical database) testing. Writing SQL queries, generating reports to ensure data integrity and validating business rules
• Experience in working with Databases and using SQL, SQL Server, Oracle
• Good Knowledge in design/testing and implementation of stored procedures, triggers and functions at database level using PL/SQL
• Experience in testing Business Intelligence reports generated by various BI Tools like OBIEE, COGNOS and Business Objects.
• Ability to handle multiple tasks and work independently as well as in a team.
• Good team player with excellent written and verbal communication, interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS

Testing Tools : Quality Center10.0/9.0, Quick Test Pro 9.2/ 10.0
Languages : HTML, TSL, SQL, PL/SQL
Operating Systems: Windows 9x/2000/ NT/XP, DOS, UNIX
Methodologies : SDLC, Agile
Databases : Oracle (SQLPLUS), SQL Server, MS Access
Data warehousing Tools: Informatica, Business Objects, COGNOS, OBIEE
Office Software’s : MS Office (Word, Excel, PowerPoint). MS Project
GUI : C, C++, .NET, Java, JUNIT, J2EE, Java script, Visual Basics

EDUCATION

• Bachelor of Technology

EXPERIENCE:

Confidential,Redwood City, CA Oct 2011 – Present

Confidential,has been using Oracle Demantra Demand Management solution in North America since 2005. Recently, there was an engine tuning exercise to allow EA forecasting team to effectively use a statistical forecast in North America and developed JANUS for global forecasting and trade promotions management solution.

Responsibilities:

• Developed Test Plans, Test Scenarios, Test Cases, Traceability Matrix, Test Summary Reports and Test Execution Metrics.
• Developed and Executed the Test cases & Scripts for Functional, System, Regression, Integration, Performance and UAT.
• Involved in writing Complex queries using SQL for Data Integrity checks.
• Participation in Requirement / Use Case analysis, Risk analysis and configuration management.
• Validating the data in various stages of data movement from Source to Staging and from Staging to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test Manager.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.
• Developed presentation and testing implementation learning to other testing resources for cross functional training.
• Extensively tested the OBIEE report by running the SQL queries on the database by reviewing the report requirement documentation.
• 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 the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Validate the SELL_In, SELL_Thru data models and validated the OBIEE reports with oracle source systems Demantra and Fusion
• Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis
• Actively participating in project specification reviews, writing and maintaining QA technical documentation.
• Identify/debug, troubleshoot, modify, document, test the production issues and create production support schedule.

Environment: Informatica, Oracle 11i/10g, Oracle SQL developer, Toad 9.0, OBIEE and Windows XP.

Confidential,Dallas, TX March 2010 – Sept 2011

The Modification Portal (also referred to as PEGA) is a tool that automates the process for receiving, managing, tracking and responding to incoming loan modification requests. The tool simplifies the processing of modifications by automatically moving files along a consistent workflow across functions including Intake, Relationship Management, Underwriting, Quality Control, and Closing.

Responsibilities:

• Performed ETL test scenarios by writing SQL scripts with consideration of Business scenarios.
• Exclusively worked with ETL team to analyze the source and Target Database systems
• Exclusively worked with PEGA source system Business people to gather the requirements
• Exclusively worked on ETL test case scenarios with business functionality and generated the reports for business users.
• Translating business requirements and technical specifications into test cases, test script.
• Identifying the gaps between the requirements and use cases.
• Creating and managing system testing schedule and executing the test cases against the functional specifications.
• Created manual and automated tests by conducting functionality testing, regression testing.
• Worked closely with the project team in planning, coordination and implementing QA methodology in Agile Environment.
• Developed Test cases for different Loan scenarios (Conventional\\High balance\\Jumbo).
• Executed test cases manually to verify the expected results, as well as using automation tool Quality Center and QTP.
• Involved in preparation and enhancement of automated scripts for the identified automation scenarios using QTP.
• Analyzed and helped in modifying the Use Cases and created the Test cases based on them.
• Used Quality center to track, analyze and document defects.
• Reporting and tracking defects using test management.
• Involved in developing Entry & Exit criteria and defined the pass and fail standards.
• Performed Positive & Negative Testing.
• Participated in various meetings and discussed Enhancement and Modification Request issues (Change Requests).
• Performed Functional, Smoke, Integration, and System testing of Data warehouse application.
• Involved in Data testing by writing SQL queries in database tables to ensure UI result match the

Database results.

• Validated Source -Target mappings applying various transformation rules and Business Rules.
• Involved in testing various reports created using Cognos.
• Effective co-ordination between development team and testing team.

Environment: Quality Center10.0, QTP8.2, Informatica, Cognos, XML, Oracle TOAD, UNIX, PEGA, Excel

Confidential,Irving, TX May 2008 – Jan 2010
Role: DW Tester
--------------------------------------------------------------------------------------------------------------------------------------------

Handset My Verizon allows customers to access self-serve functionality directly from browser and handsets. Customers can use Handset My Verizon to check balance, check minutes, and message and kilobit (data) usage, make, manage and review payments. Also View current plan and features, manage features, change voicemail passwords, and locate a Verizon Wireless Communications Store near them. And find answers to frequently asked questions related to billing, using voice mail, roaming and traveling.

Responsibilities:

• Involved in leading and participating in the full software life cycle for testing (STLC) activities – from test planning, test execution to test monitoring, status reporting, documentation and Business Objects report validation.
• Reviewed requirements documented (mapping document/Report Specs) by Business Analyst for thorough understanding of the application.
• Validating the data thru various stages of data movement from staging to Data Store to Data Warehouse tables.
• Created Test Cases using the SDLC procedures and reviewed them with the Test lead.
• Executed all the Test Cases in the Test Environment and maintained them and documenting the test queries and result for future references.
• Validating the external data source by connecting thru Oracle heterogeneous services and joining them to existing tables and reporting the anomalies in the data.
• Testing included Unit, System, Regression testing, Business Objects reports testing.
• Provide flexible & high quality support to wider Testing strategies on key regular deliverables & ad hoc reporting issues.
• Extensively tested the Business Objects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Validating the reporting objects in the reporter against the design specification document.
• 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 the data mapping provided that satisfies the transformation rules.
• Validating the Archive process to purge the data that meet the defined business rules.
• ETL validation, Data Model Validation.
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
• Involved in validating the aggregate table based on the rollup process documented in the data mapping.
• Retested the modifications, once bugs are fixed after reinstalling the application.
• Developed automated scripts for functional and regression testing.
• Reported the bugs through email notifications to developers using Quality Center.
• Generated Problem Reports for the defects found during execution of the Test Cases and reviewed them with the Developers. Worked with Developers to identify and resolve problems.

Environment: Informatica, Business Objects, Mercury Quality Center 9.0, Java, HTML, XML,
Oracle 9i/10g, MS-Office2003.

Confidential,Milwaukee, WI April 2007 –March 2008

In the sales compensation project for every product of GEHC sold by the sales representative, the payment and compensation details are calculated on a monthly basis. The details of the order that the sales representative make in a month is received in a file and then based on the plan/condition the compensation details are calculated and stored in the sales comp data mart for analysis and reporting generation.

Responsibilities:

• Involved in the review and analysis of Business design summary, Use case document and Screen definition documents.
• Analyzed the functional requirements of the callidus application and true comp repository sales data.
• Exclusively worked on EIM (Enterprise Incentive Management) Data structures analysis reports.
• Developed test strategy for the Callidus True Comp application and involved in preparing Test plan document and developed Test cases.
• Exclusively worked with ETL team to analyze the EIM True Comp Data sources and prepared ETL test cases with SQL queries.
• Exclusively worked on True Comp ETL test case scenarios with business functionality and generated the reports for business users.
• Worked with ODS (operational data storage) system to analyze the Historical data.
• Responsible for performing Functional testing on the Callidus True Comp application by creating automated test scripts using Test Script Language (TSL) scripts and Quick Test Pro.
• Extensively used customized functions in the compiled module.
• Extensively used Quality Center for requirements tracking and functionality tracking.
• Responsible for tracking defects using Quality Center and made sure those defects are efficiently passed from one layer to another.
• Tracked and Compared the data set results in different phase like SIT, UAT and PROD
• Documented the test results for each build of testing in all phases.
• Enhanced and modified the scripts according to the test case scenarios.
• Analyzed the testing progress by conducting walk through meetings with internal quality assurance groups and with development groups.
• Liaisons with the Management Team, Business Analysts, and developers for implementing new approaches and techniques.
• Responsible for documenting the process for future references.

Environment: Informatica, Quality Center 9.0, QTP 8.2, CALLIDUS True Comp Manager 4.3.2, Oracle9i, TOAD

Confidential,LA, CA Oct 2006 – Feb 2007
Role: QA Test Engineer
--------------------------------------------------------------------------------------------------------------------------------------------

Confidential,is one of the largest insurance companies which provide service in California. This company provides a full range of products and financial services from auto, fire, life and commercial insurance to administrative services. The company was developing insurance processing application online.

Responsibilities:

• Include testing and analyzing the system testing, functionality testing, Integration testing.
• Assisted in writing the test plans and testing the functionality for the web-based application.
• Writing test cases for the application with respect to the user requirement document.
• Attended several walkthrough meeting with the Business Analysts, Project Manager and developers and provided feed back accordingly.
• Got involved in preparing scenarios for the regression testing using automation tool.
• Performed regression testing for every modification in the application and new builds using QTP and Quality Center.
• QTP was used to generate automated test scripts for functionality and GUI testing and further enhancements were done in the script.
• Execution of the test scenarios and scripts and review of product functionality.
• Testing of various kinds of interfaces depending on the applications.
• Administered Quality center partly by creating the users user groups and assigning privileges to users.
• Manually written the SQL queries to test the back end database.
• Created Test Plans which describes the features and functions to be tested.
• Created manual and automated tests for several different modules.
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Wrote SQL Statements to retrieve data from backend.
• Performed Web Testing to check for broken Links in the Web Page.
• Helped the Lead create Traceability Matrix to ensure comprehensive test coverage of requirements, identify all test conditions and test data needs.
• Used Quality Center to plan tests, manage test assets, create and run manual test.
• Created, Updated and maintained Test Scripts for different builds and releases.

Environment: Mercury Quality Center, QTP, VB Script, Java, Oracle 9i, HTML, Internal Tracker, Windows, Ms-Office2000, Excel.

Confidential,India June 2004 – August 2006
Role: QA Tester
--------------------------------------------------------------------------------------------------------------------------------------------

Confidential,is India\'s one of the largest banks which offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management. Here I worked on E-Banking Project.

Responsibilities:

• Performed Manual Testing of this Web application.
• Testing compatibility of software under various Internet Browsers.
• Performed Integration testing, Regression testing and System Testing.
• Identified software defects and interacted with developers to resolve them and provided full support to the Test team using the Test Director.
• Participated in various meetings, discussed Enhancement and Modification Request issues.
• Performed GUI, Functionality and Backend Testing.
• Reported the bugs using an in house made bug-reporting system, which was developed using MS Excel sheets.

Environment: Test Director, Java, HTML, Oracle, Windows.