SUMMARY:

• Over 7+ years of IT experience in which around 5 years of experience in software Testing of ETL Testing and Web based Applications.
• Around 2 year of experience in Test Automation using QTP(9.2 to 10.00 versions)
• Expertise in analyzing Functional Requirements, Business Requirements and SCR (System Change Requests).
• Excellent in writing Test Scenarios and Test Cases for Smoke/Sanity, Integration, System, Regression, User Acceptance, Database, End-to-End and Backend Testing.
• Good experience in Functional Testing: Smoke, System, Integration, Regression, User Acceptance, Database, End-to-End and Backend Testing.
• Very good experience in Backend and Database Testing: Oracle, DB2, Teradata SQL Assistance, MS-SQL Server, MS Access databases.
• Good experience in Defect Reporting and Tracking with Quality Center, Test Director and Rational Clear Quest
• Testing Experience in Reports in Business Objects
• Performed ETL testing, Data warehouse Testing.
• Involved in writing Test Plans.
• Self motivated in Automated Testing. Written automated test scripts using Quick Test Pro and WinRunner.
• Implemented Data Driven automation approach using Quick Test Pro and WinRunner tools.
• Defined Reusable Actions and Library files (.VBS files) for QTP scripts.
• Maintained test data for QTP scripts in the Oracle database.
• Experienced in Functional, Regression, Integration, System and UAT testing
• Executed automated test scripts. Analyzed test scripts results and logged defects.
• Trained the testing team on Quick Test Pro testing tool concepts and implementation.
• Experience with Waterfall Method, V-Model, RUP (Rational Unified Process) method.
• Experience with Microsoft SharePoint (Web Application for Content/documents and Records Management).
• Effectively coordinated with development team and business analysts.
• Experience in business domains: Banking, Health Insurance, Telecom, Logistics & Transportation, E-Commerce and Retail Systems.
• Strong experience with Application and Web Servers.

TECHNICAL SKILLS:
Testing Tools Quality Center, Test Director, LoadRunner, Performance Center, Rational Clear Quest
Languages SQL, PL/SQL, VB Script, JavaScript.
Databases Oracle 8.0, 8i & 9i, MS-SQL Server, DB2, MS-Access
Database Tools TOAD, DB2, Teradata.
Application Servers WebLogic, WebSphere, Apache Tomcat, JBoss, Oracle 9i
Telecom Tools Amdocs ENSEMBLE
Content Management Microsoft SharePoint
Operating System Windows NT, 2000, XP, UNIX, Linux, Sun Solaris
Middle Tire TIBCO

EXPERIENCE:

Confidential,Data/Quality Analyst May/2011-Present

Confidential,Minnesota makes a healthy difference in people’s life.

Roles:

• Data warehouse testing, Migration of Claims from DB2 to Teradata SQL Assistant.
• Analyzed the Business, Functional Requirements and Streamlined the Testing Activities.
• Understand Functional Requirements from Data Mapping documents.
• Writing Test Scripts for the Functional Requirements in SQL.
• Performed Regression Test to ensure the product integrity after modification and enhancements.
• Running SQL queries against DB2 to verify the data matches with the migrated data, executed queries in Teradata databases.
• Experienced in producing Test Plans and Test Scripts from relevant documentation.
• Creation of test scripts in SQL based on published design documents.
• Data Profiling is done with DQ Analyzer tool.
• Involved in Automation Infrastructure Development in Quick Test.
• Flat file output is compared using Beyond Compare, which gives the result of unequal rows.
• Exported the results through SQL and documented the test results for test cases, suites executed.
• Test Scripts generated using Quick Test.
• Web based and Client /Server application testing with automation plus framework development
• Effectively coordinated with Business Analysts for clarification.
• Defects where Reported in Rational Clear Quest.
• Established and executed test cases.

Environment & Testing Tools: SQL , Teradata SQL Assistant, SAS,Toad, Ms Access, Windows XP, UNIX, Telnet, Quick 2, VB Script, Quality Center 8.0, Rational Clear Quest, Business Objects, Microsoft SharePoint,DQ Analyzer, Beyond Compare,Winscp,Unix.

Confidential,MN Dec/2010- May/2011
Data Analyst
Confidential,mission is to improve the quality of patient care and the productivity of health care delivery through the development and advocacy of less-invasive medical devices and procedures.

Roles:

• Analyzed the Business, Functional Requirements and Streamlined the Testing Activities.
• Understand Functional Requirements from Functional Design Document, Data Maps and Application Design Screen Prints.
• Writing Test Scripts for the Functional Requirements.
• Performed Regression Test to ensure the product integrity after modification and enhancements.
• Worked on Various SQL Server procedures for various Bugs, executed queries in test databases using SQL queries.
• Using Load Runner, execute multi-user performance tests, used online monitors, real-time output messages and other features of the Load Runner Controller.
• Develop and implement load and stress tests with Mercury Load Runner, and present performance statistics to application team
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Backend and Database Testing: Oracle, MS-SQL Server, MS Access databases.
• Developing simulation scripts using the HP Interactive Load Runner by identifying business critical transactions.
• Recorded and documented the test results for test cases, suites executed. Published test status reports.
• Coordinated with Development team and created new SCRs (System Change Request)
• Effectively coordinated with Business Analysts for clarification.
• Wrote Test Cases for Various S&OP Reports, CRM and Legacy Data Documents.
• Established and executed test cases.
• Handled automated and manual testing requirements.

Environment & Testing Tools: TIBCO, Web Sphere, SQL, Ms Access, Windows XP, UNIX, Test Pro 8. Telnet, Quick 2, VB Script, Quality Center 8.0, Rational Clear Quest, Business Objects, Microsoft SharePoint.

Confidential,CA Jul/2009– Nov/2010
Quality Application Analyst/Business Analyst
Confidential,mission is to provide banks and credit unions with mobile banking solutions of the highest quality. Innovative technology paired with more than a decade of mobile banking experience positions MShift as the number one provider of mobile banking solutions in the industry.

Roles:

• Understand Functional Requirements from Functional Design Document, Data Maps and Application Design Screen Prints.
• Written Test Scenarios. Prepared test cases in Quality Center for Sanity/Smoke, Integration, System, Regression, User Acceptance and End-to-End testing.
• Performed Integration Testing, System Testing, Regression Testing and End-to-End testing in different phases (environment) IT, banking and Dress Rehearsal (Production Mirror).
• Performed Iphone and Black Berry Apps, testing various Banks for the Client.
• Performed MART based applications to check the usage history of the MPM and QA33.
• Performed Regression based testing for public and private parts for various Bank Accounts.
• Performed User Entitlements and Accessibility testing for all functionalities in the application.
• Validated Database functionalities by executing database queries and Stored Procedures with TOAD tool.
• Logged and tracked defect in Rational Clear Quest.
• Performed various credit card transactions and bill payments.
• Tested customer reports which is developed in Business Objects
• Validated ETL DWload statistics andData MartLoads on an Ongoing Basis.
• Attended regular defect meetings and walkthrough held to review defects.
• Reported smoke test report to team lead after finishing smoke test.
• Performed interface testing to make sure that correct data are saving to other system, which connected with developing one.
• Wrote Quick Test Professional scripts.
• Implemented Data Driven Testing for QTP scripts.

Experience in performing various types of testing like system testing, regression testing, functional testing and performance testing

Environment & Testing Tools: J2EE, TIBCO, Web Sphere, Oracle 10g, Ms Access, Windows XP, UNIX, Test Pro 8. Telnet, Quick 2, VB Script, Quality Center 8.0, Rational Clear Quest, TOAD, Business Objects, Microsoft SharePoint.

Confidential,Minneapolis, MNFeb/2008 – Jun/2009
Quality Analyst
Rating and Underwriting
Rating and Underwriting is a Web Application, which process Rates and underwriting activities for Health Partners customers. The Health Partners employees are users for this application. To complete underwriting, addition information will be requested from Application, Claim History or Pharmacy Record. In Application, Customers contact information will be stored which will help underwriter to complete his task.

Roles:

• Analyzed Functional Requirements and SCRs (System Change Request).
• Designed Test Scenarios and Test Cases for functional and performance testing in Test Director.
• Performed Smoke, Integration, System, Regression and Backend testing.
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Carried out the Manual Testing of the application before switching over to the automation phase.
• Analyzed Regression Test Cases and Scenarios. Prepared Automation Procedure Document.
• Recorded and customized WinRunner scripts.
• Inserted Checkpoints and Output Values in WinRunner scripts to avoid functionality deviation and capture expected results.
• Defined reusable functions using Compile Module concepts.
• Created and integrated test-input data with WinRunner scripts by adopting Data Driven Testing.
• Executed WinRunner scripts. Analyzed results.
• Generated test data to ensure the smooth commencement of the testing cycle.
• Recorded and documented the test results for test cases, suites executed. Published test status reports.
• Effectively coordinated with Business Analysts for clarifications.
• Coordinated with Development team and created new SCRs (System Change Request).
• Executed database queries and Stored Procedures queries with TOAD tool.
• Tested Customers and underwriting details in the Unix Server with Telnet.

Environment & Testing Tools: J2EE, Web Logic, Oracle 9i, Windows XP, UNIX, Telnet, TOAD, WinRunner 8.0, Test Director 8.0, TSL

Confidential,Memphis, TN
Quality Analyst
Confidential, Aug/2006 – Jan/2008
Confidential, Get Transit Time is a Web Application for FedEx customers/users. The application allows finding the delivery time and FedEx delivery options for domestic and international shipments. Transit time for FedEx Ground, Express and Express Freight services displays in the transit time results page. Delivery dates and time are provided for single-piece and single-commodity shipments only. The transit time application only uses city name or zip/postal code to define transit time. The GTT only displays the city or zip/postal codes served by FedEx in the destination and origin countries selected.

Roles:

• Analyzed SRS defined new test cases and revamped regression test cases.
• Attended SRS (Software Requirements Specification) and DTPS (Detailed Test Plan Specification) walkthroughs.
• Prepared test scenarios and test cases.
• Performed System Testing, Integration Testing and Regression Testing.
• Defined Automation Frame Work and effectively implemented Data Driven Approach.
• Prepared design documents for test scripts.
• Defined automated test scripts using Quick Test Pro
• Executed QTP scripts for each test cycle (5 days) and analyzed results.
• Each test result is stored in the Test Director in a separate Run.
• Identified critical defects and followed defect tracking with Test Director.
• Provided weekly management status reports and coordinated meetings between testing team and development team to review defects.
• Effectively coordinated with Developers, Business Analysts and onsite coordinates.

Environment & Testing Tools: J2EE, Web Logic, Oracle 9i, Windows XP, Windows 2k, TOAD, Quick Test Pro 6.5, Test Director 8.0, VB Script

Confidential,Bangalore, India Jan/2005 – Jun/2006
Associative Quality Analyst
EBAP
Enterprise Business Application Process (eBAP) offers the complete cycle of processes involved in the sales operations of any organization. The eBAP is divided into eight basic modules: Customer information capturing, Product information Capturing, Pricing, Billing and Delivery, Transactions, Codes, Customization, Security, Reports.

Roles:

• Executed test cases for each test cycle and entered defects.
• Effectively identified defects, reported and followed defect life cycle.
• Validated defects as per build letter for each build release and reopened unresolved one
• Prepared knowledge documents for application with help of team members’ work around knowledge.
• Trained functional knowledge of the application to new team members

Environment: Java, Servet, JDBC, Java Script, WebLogic, Oracle, Windows 2k, 98