Resume of HETAL PATEL

SUMMARY OF QUALIFICATIONS

· Over SEVEN Years Professional Experience as QA Analyst. Strong knowledge in Consumer Index, Banking, Retail, Healthcare etc. Strong experience in Quality Assurance and Software Testing. Experienced in developing Test Plans, Test Cases based upon the business requirements.

· Extensive knowledge of SDLC methodologies. Experienced in testing Client/Server and Web-Based Applications. Expertise in developing QA Test Plan, Test Conditions, and Test Cases; ensuring adequate testing of software both before and after completion; conducting and documenting UAT.

· Experience in Black Box, Positive, Negative, Data-driven, Unit, Integration, System, Front-End and Back-End Testing. Extensive experience in Manual and Automated testing using Mercury Interactive Tools like QTP, Load Runner, etc.

· Performed Sanity Testing, Smoke Testing, Usability Testing and Security Testing of various applications. Experienced in Regression and Functional Testing. Experience testing of FDA compliance applications.

· Proficiency in interacting with Oracle, SQL Server and DB2 databases using SQL. Experience in writing queries/scripts for Data analysis and QA report testing. Used Quality Center for Bugs reporting and communicating to developers, product support and test team members.

· Expertise in Oracle table data manipulation using SQL queries and UNIX commands/UNIX scripts. Participated in design Walkthroughs and Inspection meetings to review Test scripts and results. Extensive working experience in Oracle on UNIX Environment.

TECHNICAL SKILLS

Modeling/Methodologies: Software Development Life Cycle (SDLC), Agile, RUP (Rational Unified Process).

Testing Tools: Win Runner, QTP, Rational, Load Runner.

Bug Reporting Tools: HP Quality Center, Rational Clear Quest.

RDBMS: MS SQL, SQL Server, Oracle.

Operating Systems: INUX, UNIX, Windows 98/2000/XP/2003.

Other Tools: MS (Word, Excel, Power point, Visio).

Web Browser: Internet Explorer, Netscape Navigator.

PROFESSIONAL EXPERIENCE

Apr ‘12 - Present Bureau of Labor Statistics/ BAE Systems

Requirements Analyst/Tester Washington, DC

The Bureau of Labor Statistics (BLS) is the principal fact-finding agency for the Federal Government in the broad field of labor economics and statistics. The project Consumer Price Indexes (CPI) produces monthly data on changes in the prices paid by urban consumers for a representative basket of goods and services.

Responsibilities:

· Analyzed user requirements, use case documents and business rules using extensive walkthrough meetings. Reviewed Design Documents, Data Flow Diagrams, ER Diagrams for Backend testing in SQL/TOAD.

· Designed and Execute Test Cases for system testing and Acceptance testing. Develop and execute Test scenarios for User Acceptance Testing (UAT). Develops Test conditions and Test Data to execute the test scripts using SQL.

· Manually execute test scripts and performed functional testing, integration testing. Involve in writing SQL queries for Backend Testing. Delivered written test results. Experienced leading other testers in medium test efforts.

· Act as the primary channel for the communication of routine and emergency questions, issues and requests. an multiple JCS jobs and reported results to other testers and developers to perform system testing, integration testing and acceptance testing.

· Executed store Procedure using TOAD. Prepared IT system documentation. Tested different imputation methods (Item, area, C-imputation) using SQL. Validated multiple formula results by spot checking using Microsoft Excel.

· Experience in accessing data with SAS 9.2, 9.3 from a relational database such as Oracle or SQL Server. Performs verifications on fix and document status of defects appropriately. Develop requirement traceability matrix (RTM) to ensure proper test coverage.

· Participates in Peer Reviews of functional specification, application previews and Test plan/Test cases. Conduct review meetings for test plan, test design, test readiness and test completion. Work with development and QA team for defects uncovered during testing.

· Track outstanding defect reports and documented resolution after successful testing. Work closely with Software Developers to isolate, track and troubleshoot defect

Environment: SQL Developer 11g, SAS 9.3, JCS (Joint Control System), UNIX, TOAD, Oracle 10.5, Citrix, .Net framework, RUP methodology, Window 7.

Mar ‘10 - Mar ‘12 Bank of America

QA Analyst Los Angeles, CA

Bank of America is one of the largest organizations in the banking industry providing financial products, services, ideas and solutions to customers. Worked with a team of testers and analysts right from requirement analysis to testing process. Bank of America has two modules front office and back office activities.

Was involved in testing a Web based application, which has front office activities. Front office activities include accounts, cash management, transfers/transactions, check book issues and maintenance while the back end activities include day end, month end, quarterly and yearly process.

Responsibilities:

· Analyzed system requirements and developed detailed Test Plan. Help review and contribute to product documentation. Work closely with development team to resolve various issues. Worked on a UNIX platform and experience in backend testing by executing SQL queries.

· Manually tested the Web application to ensure the flow of the application functionality. Performed Manual Testing. Performed validation of the values that are entered on the front side is passing to the back end. Black Box, Negative, Regression, and Integration & Security Tests.

· Performed security testing, system testing, positive and negative testing. Backend Testing using SQL. Participated in weekly meeting with the management team and walkthroughs. Tested applications and documented results and bugs including documentation of information useful in the debugging process.

· Performed Sanity and Smoke Testing manually. Maintained the Test Matrix and Traceability Matrix. Documented and reported defects within established process and tracking systems using Mercury Quality Center. Performed Data Driven testing.

· Quality Center was used to create the test plan, store test cases and run the test sets. Interacted with developers to report and track bugs using Quality Center. Detected and reproduced the defects, and logged defects using HP Quality Center.

· Generated the test execution report in HP Quality Center to be reviewed by the QA Manager and development team. Used Quality Center for reporting and tracking bug and generating reports. Participated in release meetings.

Environment: Oracle/UNIX, Windows 2000, Agile, Quality Center, QTP.

Oct ‘09 - Feb ‘10 Wal-Mart

QA Analyst Bentonville, AR

At Wal-Mart, worked on a project involving upgrade of a retail business solution to provide functionalities including Price Management, Promotion, Purchase Order, Inventory, Shipping, and Receiving. The process developed and implemented a Performance Management Platform for the retailers to streamline the Forecasting and Budgeting process, thus reducing associated costs

Responsibilities:

· Analyzed Business Requirement document and Business Use Cases in development of Test Plans. Participated in the work-scope meetings and peer review meetings to evaluate Use Cases with Business and Design team.

· Developed and created Test plans, test cases and testing scenarios and conducted Integration testing in all areas of SAP. Developed data loading scripts and performed data loads from legacy to SAP.

· Performed Smoke, Functional, Regression, System and User Acceptance Testing (UAT) in Web application. Provide support and data as and when needed to the performance Team. Performed automated testing using QTP application.

· Performed Positive and Negative testing to test response of the application under test by creating Data Driven tests. Performed Unit testing in SD and MM SAP modules. Use BW SAP module database handling at file level.

· Reported Defects in Defect tracking tool of Quality Center by assigning Defects to development that are encountered during testing phase based on application teams.

· Coordinate with Operations team to make sure that new platform has robust testing processes. Make sure to trace test cases to operations use cases.

· Recommend and implement naming convention for Test Cases, Test Sets and Defects. Perform Gap Analysis. Coordinate with Test Coordination Center to set up and follow up on daily, weekly and monthly reports.

· Attended Weekly status meeting in reporting and provided a weekly report that includes test metrics consisting of status reports.

Environment: DB2, Quick Test Pro, MS Windows Server, MS Excel, Web Application, HP Quality Center and Windows XP, SAP.

Feb ‘08 - Sep ‘09 Magma Leasing Limited

QA Tester India

As a part of the Recoveries team, handled the commercial vehicle portfolio of the Orissa (a state in the eastern part of India) region. Magma Leasing Limited has been offering online car loans, commercial vehicle loans, construction equipment loans and personal loans. It also offers insurance services to the customers. The Company’s entire loan process, customer interaction, application process is converted into e-Business model. Worked as a part of the Recoveries team to analyze bad loans granted by the company and try to converts them into good assets. This is how we minimize the company risk.

Responsibilities:

· Worked with the Recoveries team to analyze portfolio of all the loans granted by the company to determine all the bad loans. Worked extensively with the Recoveries team to analyze the bad loans to determine root cause of the problem.

· As a part of the Recoveries group, developed new promotional strategies trying to help out the loan defaulters pay their loans. Involved for developing the strategies like no penalties, less interest rate etc to help recovery from the bad loans.

· Conducted meetings with loan officers and loan defaulters to help mediate the problem and come up with new solutions and recommendation. Assisted Recoveries team in analyzing the behavior of monthly payments of all loans to prevent them from becoming bad loans.

· Application tested manually. Designed Test cases from Requirements, Functional Specifications and Design Documents. Involved in GUI Testing and Functional Testing while testing the screens to view, enter, update, delete customer information who is defaulter.

· Performed database testing by writing SQL Queries for validating the data. Define & implement QA Processes & Standards. Used Test Director to write the test cases. Used Test Director to create reports and graphs. Successful in handling and executing of manual testing.

· Tested the software for peak load with maximum users using LoadRunner.

Environment: Visual Basic, Oracle9i, Windows NT, MS Word, MS Excel, MS Project.

Jul ‘06 - Feb ‘08 Molina Healthcare Inc

QA Tester India

Responsibilities:

· Record and document test result-using problem tracking request. Created Test Conditions based on BRD. Derived Test Cases from Business Use Cases, Conditions and Prototype of application. Involved in the development of test conditions to reflect business use cases.

· Assisted in developing test matrices to trace scenarios, requirements and product components to appropriate test scripts. Developed and documented test cases for functional and integration testing.

· Assisted in setting up the testing environment and conducted the testing as per business rules and specifications. Performed different types of testing, Functional, Integration, System, and Regression using Quick Test Professional.

· Conducted backend testing of the application by writing SQL queries. Performed test management and bug reporting using Quality Center. Performing Data Driven Testing using extensive data in the test scripts.

· Interacting with multi front end users and participating in the technical discussion with developers. Developed SQL queries in Oracle to test the application for data integrity.

Environment: UNIX, Visual Basic 6.0, Quick Test Professional, Quality Center.

Page 4 of 4