QA Analyst Resume
Surbhi Jaitly
ph:
email:
Summary:
&#; A Software Quality Assurance and Automation expert with over Seven years of IT experience. Implementing and improving the quality validation process of software, hardware and web related projects.
&#; Good understanding of the Software Development Life Cycle, extensive knowledge of SEI/Capability/Maturity Model, CMMI and IEEE Methodologies and the Rational Unified Process (RUP) Methodology.
&#; Analysis of the Business Requirements, Software Requirements Specifications, Software Testing and Documentation.
&#; Experience in Test Coordination, Test Planning, Test strategies, Test case management, Test matrix & bug tracking.
&#; Specific testing expertise includes System, Functionality, Component, Performance, Stress, User Acceptance (UAT), and Integration and Regression using Automated/Manual QA Testing of several Telecommunications, Finance, Healthcare and consumer product related applications.
&#; Excellent working knowledge of designing & implementation of all QA test strategy plans manually and automated test solutions for client/server and Web applications with Mercury Interactive – Quick Test Pro, Win-Runner, Test-Director and Load-Runner, Test Manager to write and maintain automated test cases\Scripts.
&#; Expertise in manual testing including Black Box and White Box testing.
&#; Experience in Test-Director, PVCS Tracker for reporting the defects and generated the
reports and graphs.
&#; Knowledge of programming languages like asp.net, vb.net, Java and modeling languages like XML and HTML.
&#; Good knowledge of SQL RDBMS concepts and Understanding of Capacity Models
&#; Experienced in testing Data Migration, Data Cleansing, and ETL Processes by executing complex PL/SQL queries, executing UNIX shell scripts for monitoring batch jobs.
&#; Ability to work in a cross-platform environment that includes UNIX, DOS, Windows //NT, XP, XP Pro.
&#; Highly motivated self-starter and positive team player whose main focus is on delivering a high quality product that meets specified requirements for customer satisfaction.
&#; &#;Good analytical and communication skills and ability to work independently with minimal supervision and also perform as part of a team.
Education:
&#; B.S (Hons.) from India.
&#; M.S from India
&#; Advance Diploma in Web Centric Computing by the Academic Council of NIIT India.
Technical Skills:
Tools Load-Runner, Quick Test Pro, ,Win-Runner , Test Director, Web Load, Rational suite, CVS, Test Manager
Languages TCL, Shell script, VB-Script, Visual-Basic, Java ., Java-Script, XML, HTML, PL/SQL,
Databases ORACLE i/i//.x, MS SQL Server , MYSQL, MS-Access, Toad .
GUI Oracle Apps i,Developer/(Formsi/./., Reportsi/./.), Oracleias, VB./.,ASP
Hardware AS/, IBM RS
Operating Systems Windows XP//NT.//, UNIX, Solaris ., Sun Solaris , AIX .,Linux ./., MS-DOS, Mac OS X, MVS/CICS
Servers Apache Application Server, BEA Web Logic, Server (.), Web-Sphere Application server .
Professional Experience:
Project: KP.org Mar – Present
Client: Kaiser Parmanente, Pasadena, CA
This project “KP.org” is to provide the facility for members and current employers to look into their Kaiser Permanente account, refill their prescriptions on-line. This project also provides facilities for prospective members and prospective employers to see the required information for them to decide about their membership. It also provides information for insurance brokers and media representatives.
Responsibilities:
•&#; Worked with Change Management group on Change requests and implementing them in to system test
• Developed a detailed Test strategy document and Test Plan.
• Wrote the Detailed test cases in Microsoft Excel and exported to Quality Center.
• Performed testing with multiple sets of data - data driven test using Win-Runner
• Conducting functionality, Regression and GUI Testing using Win-Runner
• Building own test data in Oracle (manually & using SQL*Loader) on the servers, when real data is not available
• Creating and executing SQL queries on an ORACLE database to validate and test data using TOAD
• Extensive use of SQL queries to perform Data Integrity testing and Back-end Testing of the Application
• Used CVS to store all the test cases and test plans.
• Developed detailed Test Strategies and Test plans for testing of various Data Junction interfaces.
• Checked the format and data in the flat files for various interfaces and validated the data in the flat files with the database.
• Involved in the complete life-cycle of defect process from status open to closed using QC.
• Involved in QA phases of testing as well as UAT Testing.
• Analyzing Defect Reports and working closely with Application Developers for resolution
• Reported defects and Analyzed results using QC.
• Escalated issues, which are unresolved over a period of time.
Project: ChryslerFinancial.com, Fleet.com April – Feb
Client: Daimler Chrysler, Auburn Hills, MI
This was the maintenance and development project for the BC sites like “ChryslerFinancial.com”, “fleet.com” etc. The project involved the analyzing the existing code and data and after requirement gathering for new changes from the clients, that changes have to be implemented and tested in the testing environment .Created and updated work plan for the Functional Requirements phase of the project. Responsibilities involve the installing of existing code on Company's internal web and application servers so as to make the entire web sites up and running in our own environment. XML was used to transfer the data between application sites.
Responsibilities:
• Involved in writing Test plans, which detailed the testing scope, strategy, test requirements and testing environment based on the client’s requirements.
• Tested Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Parameterized scripts to handle user input data and correlated scripts to process server returned data via Load-Runner ..
• Responsible and involved in executing the scenarios, monitoring the server response timings, monitoring the throughput, Hits/Sec, Trans/Sec.
• Identified bottlenecks, data errors and integration problems and revised application to enhance performance before Application Launch
• Designed and developed Test Scripts in Test Director based on the Use Cases.
• Performed database testing by passing SQL queries to retrieve data.
• Co-coordinated with other testers to incorporate the business rules in their respective Test cases, which has been entered into Rule management Tool.
• Used Test Director for the defect reporting and tracking. .
• Logged into the UNIX Servers and checked the Log files for errors.
Project: Supply Chain Management System July – April
Client: American Suzuki Motors Inc, Brea, CA
“Supply Chain Management System” is an intranet based enterprise system for automation of all the processes of the American Suzuki Motor company. This application automates all the processes of the company including inventory control, production, purchase, shipments and all the other internal processes of the company. This application allows all the dealers of the company to submit their sales forecast reports on-line and to put their order for the new vehicles according to the models and colors. This application allows the user to define their models and see the quotation on-line for that particular model.
Responsibilities:
• Analyzing specifications and Developing Test Cases for the enhancements given as per the release using Test Director.
• Developing test scripts for Functional and data driven tests using Quick Test Pro on the web based module
• Using Quick test Pro parameterized the multiple sets of data using the data table feature.
• Comparing the expected and actual results using multiple checkpoints for text, GUI, bitmaps and databases in the web application
• Running queries on tables to verify data integrity and searching Stored Procedures code to explain flows/streams & verify functionality
• Executed Reliability Testing to verify data validity and systems stability
• Writing custom functions and programs to VuGen scripts to support the load testing efforts
• Parameterize scripts to handle user input data and correlate scripts to process server returned data via Load-Runner
• Monitoring resources to identify performance bottlenecks, analyze test results and report the findings to the clients, and provide recommendation for performance improvements as needed
• Developing Base line scripts for Performance testing of the application using Load-Runner
• Defining the standard templates and Process development to get the Quality Product to the Organization Implementing Waterfall SDLC in the Organization
• Analyzing the results & reporting bugs using Test Director and used CVS to manage the versions
Project: On-line Services Sep - June
Client: Met-Life, Inc., Boston, MA
Met-Life is one of the leading insurance companies. The project comprises of both client/server and web-based modules. In the web-based module, the system permits the registered members with Met-Life to get the details of the long term care insurance schemes and benefits. The field agents of the company enter the data of prospective customers using the client/server module. The application calculates the amount of insurance required premium, cash value and benefit amount for all the years.
Responsibilities:
• Based on the System Requirements and Design Specifications, developed the Testing Strategy, Test Conditions.
• &#;Wrote Test plans, which detailed the testing scope, strategy, test requirements
and testing environment based on the client’s requirements.
• Decomposed ETL specifications from High level documents.
• Tested Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Designed and developed Test Scripts in Test Director based on the Use Cases.
• Performed database testing by passing SQL queries to retrieve data.
• Co-coordinated with other testers to incorporate the business rules in their respective Test cases, which has been entered into Rule management Tool.
• Used Test Director for the defect reporting and tracking.
• &#;Logged into the UNIX Servers and checked the Log files for errors.
Project: IndiaPost.com Dec – Jun
Client: Department of Post, New Delhi, India
This customer access system is Web-based application, which allows customer to pay on-line, book the postal pick-up and delivery on-line, track the post and maintain the account on-line. Customers can open the postal account using this application through Internet, transfer the funds between different accounts and check their balance and use other premium postal services on-line.
Responsibilities:
• Designing and Writing Test Plans, Test Procedures, Use cases and Test cases with reference to Business Requirements, Design Specs and Functional Requirements
• Performing Functional testing, System testing and Regression testing
• Creating and executing SQL queries on an ORACLE database to validate and test data
• Testing various links and calculating the time taken to load a page and report the results Inserting Synchronization points and check points in TSL Win-runner scripts whenever necessary
• Reporting and tracking the bugs using Test Director
Project: Annual Budget April - Nov
Client: Satyam Computer Services Ltd,, New Delhi, India
This is web based project that provides the facility to the higher authorities in the company to view the complete details of the company financial status. Which in return helps financial team to and the Higher Authorities of the Organizations to study the Financial Data like Revenue, Capital Expenditure, Sales and Pre-sales, Profit and Loss and Based on these Data the Budget will be decided.
Responsibilities:
• Written System and Integration Test Cases based on the business and system requirements to test the functionality of the system.
• In various phases of SDLC performed different types of testing like Functional Testing, Volume
Testing, Stress Testing, Load Testing, Configuration Testing, Integration Testing, System
Testing, Acceptance Testing and Regression Testing
• Performed the activities necessary to execute tests in accordance with the test plan and test design (including setting up tests, preparing data base(s), obtaining technical support, and scheduling resources.)
• Was responsible for Tracking Defects and reporting them through Test Director.
• Reporting and tracking the bugs using Test Director
