SUMMARY

Over 15 years of advancing experience in Information Technology as Quality Analyst and Tester with solid understanding of Business Requirement Gathering, Translation of Business Requirements into Functional Requirements, Business Process flow, Business Process Re-Engineering Business Process Modeling. Have diverse experience in Automation Testing, Manual Testing and Software Development Lifecycle SDLC . Also have extensive experience in Automation Testing Tools like Win Runner, Quick Test Pro, Silk Test, Test Partner, Load Runner and Quality Center.

Expertise:

• Over 15 years of experience as a QA Analyst with solid understanding of all the phases of SDLC.
• In-depth knowledge of Software Development Life Cycle SDLC , having thorough understanding of various phases such as Requirements gathering, Analysis/Design, Development and Testing.
• Experience with QA Methodology including defect tracking and management
• Highly proficient in interacting with business users and gathering user requirements to develop necessary test cases/ test scripts.
• Performed Testing of database applications developed with Oracle, Sybase and SQL Server.
• Worked closely with Business Analyst for Requirements Study and develop SQL Scripts for end - end process validation.
• Extensive experience in Functional, Integration, Regression, System, Backend and Performance Testing.
• Expertise in writing Test Cases, Test Scripts for both manual and automation testing of various applications.
• Written and executed SQL queries and stored procedures manually for back-end testing.
• Expertise in Bug tracking using Mercury Interactive tools like Win Runner, Load Runner and Quality Center, Test Director and Clear Case.
• Hands on experience on Test Documentation: Test Plans, Test Tree and Test Cases.
• Expert in understanding of Software Development Life Cycle and Development Methodologies like RUP, Waterfall, Spiral, Evolutionary.
• Executed Test Scripts using win Runner, Load Runner, and QTP.
• Interacted regularly with the development team and the higher management to meet the deadlines of Project milestones.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform environment.

CONFIDENTIAL

Technical Skills:

• Testing /Bug Tracking Tools: QTP, Win runner, Rational Requisite-pro, Quality Center, Load runner
• Operating Systems: Mainframe, Win NT/95/98/2000/XP, UNIX, MS-DOS
• Languages: JAVA, COBOL, C, C , RPG/400, HTML, XML, SQL, PL/SQL
• Defect Tracking and Reporting Tools: PVCS, Clear Case, SOAP, HL7, AIX, Test Director, Business Objects, Rational Tools
• Hardware: IBM AS/400, IBM Compatible PC, HP 9000
• Database: Oracle, MS Access, SQL Plus, Lotus Notes, DB2, Mainframe
• GUI: VB 5.0, Access front end
• Network: FTP, TCP/IP, CICS

Experience:

CONFIDENTIAL

Software Test Engineer

CONFIDENTIAL is a full-line Credit Card Services and banking firm. It provides international corporate financial services for more than two million businesses conducting transactions in 190 countries. Worked on its Home Loan Management System This application is an online workflow system developed in JAVA and Oracle, to book and monitor the loan portfolios. The business of this division is to process loan application from potential clients/customers, evaluate their eligibility, approve them, and maintain the loans till their closed. This includes client, debtor, invoice, pricing, and account information. Invoices are funded and payments are processed with accounts being managed accordingly. Reports are generated for internal and external use. The loan is repaid and removed from the system. The five primary stages in the life cycle of a loan are the request, processing, booking, maintenance, and closure stages. The project was joined when it was in the design development

Responsibilities:

• Involved in requirement gathering, analysis of the requirements from the business owners and users.
• Interacted with users for verifying user requirements, managing change control process, updating existing documentation
• Responsible in the Coding, Integration Testing and Functional Testing of the systems
• Planned and defined Use Cases created Use Case diagrams, Scenarios and Use Case Narratives.
• Used different aspects of the Software Development Life Cycle SDLC .
• Developed test automation scripts using QTP for Regression, Functionality, and GUI testing.
• Created RTM Requirements traceability matrix mapping Requirements to Design Artifacts to SIT Cases to UAT Cases.
• Created vender agreement document to document the 3rd party deliverables.
• Extensive experience in TSYS/FDR 3rd party in 3rd party card booking system.
• Analyzed Business Requirements, performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams/State Diagrams and Class Diagram Documented and maintained requirements traceability matrix to ensure that all requirements are traceable from top to bottom and to provide a basis for test plan
• Assisted in design review meetings making sure all the requirements are covered in the development project scope.
• Designed, developed, maintained and tested universes in Business Objects for supporting ad hoc queries and canned reports according to the business requirements.
• Performed System and Integration Testing using Quick Test Pro.
• Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing efforts on their applications
• Created Activity Diagrams, Sequence Diagrams and ER Diagrams in MS VISIO.
• Responsible for the Designing and analyzing classes and objects by using the Business Object Designer.
• Involved in Configuration Management, Requirement management and analysis
• Created and executed Test Plan and Test Cases based on Design document and User Requirement document for testing purposes reports in Business Objects. Involved in User Acceptance Testing and training of end users.
• Resolved issues related to requirements during system testing and UAT.
• Participated in the planning and execution of the User Acceptance testing effort.

Environment: Quality Center, QTP, LoadRunner, Lotus Notes, Unix, Oracle, MS SQL Server, Business Query Analyzer, Java, J2EE, MS Visual Studio, Business Objects, MS Visual SourceSafe, ASP.Net, Web Plus, IBM DOORS, XML, FIXML

CONFIDENTIAL

QA Analyst/ tester

• This was a web-based application developed for various clients modules offered by CONFIDENTIAL The application was an enhancement of the one already existing and provided New York life customers to apply for various kind of Annuities, policies and Long Term Care products. The customers can also logon to their accounts via Internet to check their Account Summary and eligibility and Premium Payments. One application, which is only for different annuities and policies, is called Online Annuity System OAS and the other application is called Long Term Care LTC .
• LTC product was for the customers who wanted long term care for themselves or for their elderly or disable person. In both Application Customers were able to sign in with a user id and password. They were able to change their address, Pin number, user name and password and get the information for the agent who signed them up for the policies.

Responsibilities:

• Prepared the Test Cases based on the functional specifications.
• Application were tested both in integration and Model modules
• Involved in Functional and Regression testing during various phases of development of the application
• Performed Positive Testing and Negative testing both manually and automatically.
• Used SQL queries were to retrieve data from tables and to perform back-end testing.
• Testing experience of operation process support for the upstream and downstream systems related to CDW/ODS in UNIX environment.
• Identified potential impacts to services, perform resolution and work-around to meet Service Level Agreement SLA .
• Developer test solutions for viability.
• Created updated SOP document for services that are impacted.
• Worked closely with Business analysts to understand the requirement, and with Developers to understand the functionality of the application.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Involved in System Documentation, which gives extensive information about the dataflow and the methodology.
• Demonstrated strong problem solving skills in developing ETL mappings to extract data from the source system, validating, perform data transformations and then loading it into the target database.
• Prepared Data Administration department's charter document, which included definition of roles and responsibilities for IT technical positions, data management standards, data architecture principles and practices.
• Designed the logical and physical databases, and defined the ETL rules, for a multi-terabyte customer relationship management data warehouse.
• Contributed to the RFC for a metadata management tool, evaluated vendor responses, and after acquiring metadata repository, helped in the initial stages of designing an enterprise metadata model.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various data sources.
• Responsible for making sure that all of the extracted source data was correctly transformed into dimension tables and fact tables.
• Performed SQL Back-end testing to verification, validation and to check the consistency of data.

Environment: Informatica, XML, QTP, LoadRunner, Quality Center, J2EE, JavaScript, UNIX, C, VB Script, Oracle, SQL, Windows XP and MS Office

CONFIDENTIAL

QA Analyst/ tester

This was a web-based application developed for various mortgage modules offered by CONFIDENTIAL. The application was an enhancement of the one already existing and provided Citibank customers to apply for the loan and check the status, while the employees could accept the mortgage applications, process the loans etc. The customers can also logon to their accounts via Internet to check the balance, make the payment or refinance the loan. The fundamental goal of the project was to enhance the entire insight product line to be more robust in the current global market segments. This online banking system was created using Java, Java Script, HTML and Oracle on UNIX platform.

Responsibilities:

• Worked as Services ESS and was responsible for coordinating and executing.
• System test activities. This included crafting and translating test strategies into test plans and schedules creating test scripts/cases/data executing test scripts providing timely reporting which also included the creation of standard docs such as RTMs/FRMs, test summary reports, etc. and conducting status calls adhered to company policies, procedures and guidelines for general testing.
• Established and maintained close working relationships with business and technology team members. Detail-oriented, self-starter with strong organizational and analytical skills and to be able to handle multiple responsibilities in a fast paced, deadline-driven environment.
• Evaluated business requirement and technical specification documents in order to craft test strategies and LOE assessments which accounted for, durations, constraints, assumptions, etc. that are needed in order to fulfill test objectives.
• Reviewed and validate design specifications so as to ensure requirements traceability and to determine application/component functional readiness requirements.
• Created and maintained test plans that defined test objectives, methods and tools to be employed for the assigned project.
• Identified potential impacts to services, perform resolution and work-around to meet Service Level Agreement SLA .
• Developer test solutions for viability.
• Created updated SOP document for services that are impacted.
• Strong, hands-on knowledge/experience with office automation tools such as MS Project, MS Office
• Worked with Business Analysts, Architects, Developers and Users to analyze the business requirements, functional specifications, and technical specifications and formulated detailed Test plans based on those requirements.
• Created Test cases in Quality Center for manual testing of the application.
• Created, updated and maintained the Test Matrix for Online Ordering Processing and Billing modules.
• Created automated test scripts using QTP for functional and regression testing.
• Enhanced the scripts using various checkpoints standard, page, text, database, and bitmap , synchronization point, and used regular expressions to parameterize the dynamically changing values.
• Implemented Recovery Scenario Manager to handle the known exceptions in the applications.
• Modified the properties of various VB objects using Object Repositories in QTP for performing the regression testing on the subsequent version of the applications.
• Created several Re-usable Actions in QTP for generic and secured portions of the application.
• Created performance-testing scripts in LoadRunner VuGen using Web HTTP/HTML protocol.
• Enhanced the script using correlation, parameterization, checkpoints, and rendezvous point.
• Executed Multi-user Scenarios to measure server performance for Payment module, as users extensively used this module.
• Used Controller to increase the required number of Vusers.
• Utilized LoadRunner Monitor to measure the system resources and LoadRunner Analyzer to analyze the response times of the business transactions under various loads and stress.
• Extensively Analyzed Various Performance Monitors to find System Bottlenecks like Memory Leaks, CPU Utilization and Network Bottlenecks.
• Created in-depth reports and graphs in LoadRunner to check where performance delay occurred: network, client, server delays, CPU performance, I/O delays, database locking.
• Used Quality Center to create the test requirements, test plans, manual test cases and defects management.
• Managed the testing process, schedule batch tests, log and track defects using Quality Center.
• Used SQL queries for performing the Back End Testing.

Environment: Informatica, XML, QTP, LoadRunner, Quality Center, J2EE, JavaScript, C, VB Script, Oracle, SQL, Windows XP and MS Office

CONFIDENTIAL

Sr. Quality Analyst

CONFIDENTIAL are a specialty pharmaceutical company engaged in the research, development, sale and marketing of prescription pharmaceuticals used primarily to treat and manage pain. The project I was assigned as a Sr. Quality Assurance Analyst to verify medical application and imaging. I was also analyst to verify medical billing information in the back office. The project I was working on was for primary support contact for the Model N Application Suite currently consisting of Medicaid and Government Pricing modules . This included assisting business users to resolve application errors, application functionality, logging defects and enhancement requests with Model N support and tracking those cases and managing UAT testing. The project also provided first level system administration consisting of user maintenance, loading data files, interfaces into and out of Model N, front end configuration changes, data analysis, managing testing for patches and upgrades, report development, writing functional requirements and other application support tasks.

Responsibilities:

• Participated widely in Collecting Business and Technical Requirements.
• Prepared Test Plans based on analyzing the use cases, Business process specification documents and UI documents.
• Test Cases are written for scheduling and execution of tests, collection of test results and analyzing the data.
• Identifying required test data to execute test cases.
• Based on use cases and translate the information to a test suite, test case and test procedures
• By using Microsoft Excel spread sheet cause and effect spread sheet prepared based on functionality of the application.
• Tested GUI results and compared with database values using SQL Queries.
• Worked closely with Business analysts to understand the requirement, and with Developers to understand the functionality of the application.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.
• Involved in System Documentation, which gives extensive information about the dataflow and the methodology.
• Actively involved in Performance Testing, used Mercury Load Runner 8.
• Created test cases to determine the time its taking to retrieve the data from the server.
• Customized Load Runner Script to increase the performance and decrease the response time.
• Executed the Load Runner Script on Mercury Controller and documented the results.

Environment: WinRunner, MS- Excel, and Test Director, Informatica Power center 7.1, Oracle 9i, SQL, PL/SQL, PVCS

CONFIDENTIAL

Quality CONFIDENTIAL is one of the nation's leading providers of health, dental, group, life, disability and long-term care benefits. Company focus is on meeting customer needs. Company is introducing innovative products, delivering strong customer service and providing easy-to-understand information. The result: a wide range of health and benefits options that deliver a valuable difference. The company is a leader in the Health Care industry in all the states of CONFIDENTIAL uses DB2 database on Mainframe as well as Oracle database and front end Visual Basic and Oracle ERP applications for its business.

Responsibilities:

• Massive project changes for Medi-Cal - trained customers and team on coding standards and testing process.
• Worked closely with customer and Mainframe team to translate business needs into functional/technical requirements and defining technical solutions. Worked through approach, business requirement and JAD meetings to gather requirements, plan SDLC steps/project phasing, manage problems, risks, impacts, dependencies and assessments. Document, organize and distribute session outcomes, requirements, changes, issues, process and workflow within network environment.
• Served as the testing Point of Contact for the projects I was assigned, researched customer issues related to software functionality.
• Tested and investigate issues to determine the appropriate resolution.
• Worked with the Program Management Organization to create education documentation. Tracked issues to assist in trend analysis and the updating of the user guides and/or standard operating procedures.
• Served as a coach and mentor to the department staff regarding how to develop and execute a test plan.
• Serve as a process improvement leader for the QA department.
• Responsible for identifying areas for improvements, implementing process improvements and ensuring long term compliance.
• Led in managing QA participation in sunset reviews.
• Set policies, standards and procedures for cross-teams system development life cycle, workflow and the interfaces with Product Verification.
• Monitored the schedule of testing phases for all projects based on project specifications, scope, and coverage.
• Participated on Kaizen Team to complete Kaizen process for claims processing and operations for Medical.
• Converted the Business requirements and Business Rules in to mechanical test scripts.
• Performed manual testing of the application before starting the automation testing.
• Created test plans in Quality Center test plan module and the test cases in test lab module.
• Integration Testing- Testing of all the modules by creating a group or individual practice
• Regression Testing after the bug fix and replication of the code by the developers
• Bug tracking and setting Priorities -Used Quality Center as tracking tool.
• Performed Database Testing using SQL Queries for Data Validation, and also conducted User Acceptance Testing UAT
• Played a major role in Project Review Meetings and updated Bug Status Reports.
• Maintained Weekly Test Matrix Reports.
• Provided weekly status reports
• Developed professional relationships with all levels within the IT organization.
• Used SQL queries for database testing to verify the DB consistency.
• Updated test scripts based on the application enhancement.
• Responsible in Executing Test cases, Test Procedures and Records Defects in Defect Tracking Tools.

Environment: Mainframe, Crystal Reporting, BI, SOAP, HL7, AIX, Test Director, Win runner, Sun Solaris, Oracle, JAVA, HTML, Java Script, Web Sphere, Oracle, Windows NT.

CONFIDENTIAL

Sr. QA Tester

This project involved mainly for manual testing, was involved in testing different diseases categories.

I worked closely with the clients and upper management.

Responsibilities:

• Created test plans and test strategies for Cigna Corp for patient health monitoring system.
• Testing of front end GUI for CIGNA's customer service reps.
• Created test scenarios to test various diseases categories in order to confirm that the application was working according to the functional design application.
• Worked with Project Manager to come up with the testing deliverables, testing milestones and testing guidelines for several applications.
• Extensive manual testing in various client server environments.
• Created QA sign off criteria's for the applications that are under tests.
• Worked in collaboration with other Business Analysts, Quality Assurance Engineers and Project Managers to prioritizing projects.
• Worked closely with client area to ensure system requirements were fulfilled in final solution.
• Delivered QA Project status reports to the project teams.
• Developed functional test plans. Executing and/or reviewing results of test plans to ensure the system meets documented requirements.
• UAT and regression testing.
• Defining and preparing detailed test cases, test scripts and test designs related to application/system development projects providing support and guidance to IT technical resources with production problems.

Environment: Win Runner, Oracle, and Windows 98

CONFIDENTIAL

QA Tester

Mortgage and Loan Processing:

Used CONFIDENTIAL as an automated test tool to keep record of various loan applications, generate denial/approval letters and maintain a customer log. Tested for customer queries regarding mortgage information, changes in their payment plans, and variable interest rate calculations. Applications used were Visual Basic and Access.

Responsibilities:

• Developed system requirements document for mortgage application.
• Developed and executed test plans and test cases using Win Runner.
• Performed manual as well as automated GUI and functionality testing using Win Runner.
• Investigated software faults and interfaced with developers to resolve technical issues.
• Conducted integration, regression and performance testing using Win Runner.
• Performed volume testing to assess the limitations of the application.
• Used Test Director for defect tracking.

CD Maturity Tracking System:

• The application was designed to maintain record of all cash deposit accounts with regards to date of deposit and date of maturity. The application originated in house and was then implemented in all branches of the bank once error tracking was completed. Applications used were Visual Basic for front end and Access for back end.
• Performed front end GUI and back end testing for financial apps.
• Generated reports and maintained a defect log used Test director.
• Performed regression and integration testing using Win runner.
• Worked in close collaboration with developers.
• Designed manual testing after developing test plans and cases.
• Tested the end product with Win Runner.
• Used Test Director for defect tracking.

Environment: Win Runner, Load Runner, Test Director and Windows 98

CONFIDENTIAL

QA Tester

Claims Tracking System:

The project used Microsoft Access 2.0 on a Windows NT platform. The data source was a mainframe file that was downloaded into the application. The file was a list of exceptions records that the mainframe had detected a problem with . The application enabled the user to view the results of the mainframe generated exception, keep track of the exceptions that were corrected, and each week added new ones to the file.

Responsibilities:

• Manually tested both front end GUI and backend.
• Entered all the data into the tables and checked the output from the front end screen which was read only.
• Generated reports and maintained a defect log.
• Performed regression and integration testing.
• Communicated extensively with both users and developers.
• Purchase Order Processing System:
• An application was tested which computerized the material ordering system for all purchases. The application was designed to generate purchase orders and to keep track of all business functionality of a catalog/online business.
• Conducted unit, regression, and integration testing manually.
• Tested the effects on the database using select statements.
• Assessed the front end GUI for navigational ease between screens.
• Communicated with developers and users to develop a customer friendly product.
• Generated reports and maintained a defect log.

Environment: Windows NT