Kumar Jain (777) 7777-7777

SUMMARY:

  • More than nine years of experience as Software Quality Test Engineer in Insurance, Banking, Mortgage and Retail industries. Extensive experience in managing Software QA and Technical support organizations and programs
  • Expertise in Software System Analysis, Development, customization, implementation and support of software applications in database and software environments and testing, conversant with client-server and Mainframe applications
  • Domain expertise in Warehouse Management systems like Manhattan Associates WMS and Red Prairie WMS
  • Excellent understanding of the Software Development Life Cycle (SDLC), FIT/GAP analysis and various testing methodologies.
  • Proficient in both Manual and Automated testing of applications
    Expertise in designing Testing documents like Test Plans, Test Design Specifications, Test Case Specifications and Test Procedures
  • Involved with GUI Automation, User Acceptance Testing, Functional Testing, Integration testing, System Testing like Regression Testing, Performance Testing on Client/Server and Web Based applications
  • Experienced in the use of automated testing tools like QTP, Win Runner, Load Runner, Test Director, Quality Center in Investments, Banking and Insurance companies.
  • Experienced in testing of ERP delivered and custom applications
  • Working knowledge in variety of technical skills, including different programming languages, ERP systems, testing techniques, database management systems and Operating Systems
  • Proven ability to manage team QA testers and set test strategies
  • Excellent communication, presentation and interpersonal skills

TECHNICAL SKILLS:

QA Testing tools - Mercury Interactive Suite (QTP, LOAD RUNNER, TEST DIRECTOR – QUALITY CENTER), Clearquest, Rational Requisite Pro, Rational Test Tools Suite, Compuware

Methodologies – SDLC, ISO – CMM, SOA

Operating Systems - Windows NT/2000, Windows XP, Windows 95/98, UNIX, DOS, HP-UX, AIX, Solaris

Languages - SQL, PL/SQL, Java, Visual Basic, C, C++, COBOL, JCL, T-SQL

Databases - DB2, MS Access, Oracle, SQL Server

Web Technologies - HTML, XML, J2EE, MVS, VB.NET, Visual Studio.Net, .NET, ASP.NET, C#, XML, VB Script

Groupware: Lotus Notes, Lotus Domino

Microsoft tools: MS-WORD, MS-VISIO, MS-PROJECT, MS-EXCEL

ERP: Peoplesoft Financials, Oracle Financials, SAP, Manhattan Associates Transport Management System

Technologies - Application Servers, Web Servers, Relational Database Management Systems, Data Warehousing, Informatics, Cognos, Datastage and Business Objects, Telecommunications

Protocols: HTTP/FTP, DNS, TCP/IP, Routing, CDN

SQL Tools: Toad, SQL ACE

PROFESSIONAL EXPERIENCE

Publix Supermarkets Inc, Lakeland, FL Sept 07 – Present

Senior QA Analyst

This project involved customizing Manhattan Associates Warehouse Management System (WMS) to Publix needs. Publix WMS maximizes efficiency and optimize labor productivity in warehouses of all sizes. Each version provides the basic functions for warehouse operations, including physical inventory, shipping, receiving, and picking, as well as management features such as queries, reporting and barcode labeling. Publix WMS includes advanced features like space management, user defined sequenced put-away and picks, zone picking, batched order management, replenishment and cross-docking warning. WMS's barcode data collection system runs on portable data collection terminals (PDTs) and PDAs. Integration testing involved testing of Publix data sources from the mainframe systems like PIMS and Marwood, SAP HR and SAP FICO systems. Extensive integration with Publix - Manhattan Associates Transportation Management System (TMS) was also done. Integration testing involved backend testing of database tables, XML files and front end UI screens validation of fields and data. Menu level, screen level and field level security testing was also done. SAP transaction codes were also validated as part of integration testing. Database testing and data flow testing between different modules was extensively done.

Responsibilities:

  • Ensure adequate and comprehensive testing is completed for all aspects of the application.
  • Involved in testing WMS modules like Inventory, Labor, Physical Space, Time and Order Aggregation
  • Involved in integration of WMS with TMS modules
  • Involved in preparing Test Plan and Test Cases based on the function specifications.
  • Involved in the review of requirements with business analysts and technical specialists.
  • Analyzed the application and performed Black Box and end-to-end manual testing.
  • Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time.
  • Experience leading and mentoring a group of four testers
  • Checked for the Database Integrity using the SQL Queries.
  • Used Mercury Quality Center as the test repository for executing the test cases and scripts and logging and generating various reports and graphs for further analysis and also to follow up the development team to verify bug fixes and update bug status.
  • Used HP Quick Test Professional(QTP) for automating manual test scripts
  • Involved in writing scripts in QTP using VB Scripting extensively
  • Involved in UI Specifications and framework design.
  • Involved in User Interface Testing to verify the functionality of various systems.
  • Involved in backend testing using PL/SQL scripts for Data Fixes
  • Involved in backend testing using PL/SQL scripts for Conversion testing
  • Involved in backend testing using SQL queries

Environment: Manhattan Associates Warehouse Management System, Manhattan Associates Transportation Management System,MS Excel, .Net, Oracle, SQL, TOAD, Quality Center, QTP

Sodexho – Buffalo, NY June 07 – Sept 07

Senior QA Analyst

Sodexho is a major food and facilities management organization that has offices in thirty-eight countries. The project involved time entry, shift differentials, employee transfers, employee contracts, wage computations and payroll systems integration. Sodexho managed its own employees as well as client employees. Different clients have different payroll systems. Integration of Sodexho payroll system with the client payroll systems was also a major part of the project. Claims processing was also done using this system.

Responsibilities:

  • Ensure adequate and comprehensive testing is completed for all aspects of the application.
  • Involved in preparing Test Plan and Test Cases based on the function specifications.
  • Involved in the review of requirements with business analysts and technical specialists.
  • Analyzed the application and performed Black Box and end-to-end manual testing.
  • Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time.
  • Checked for the Database Integrity using the SQL Queries.
  • Used Mercury Quality Centerbug tracking tool as the test repository for executing the test cases and scripts and logging and generating various reports and graphs for further analysis and also to follow up the development team to verify bug fixes and update bug status.
  • Involved in UI Specifications and framework design.
  • Involved in User Interface Testing to verify the functionality of various systems.
  • Testing of XMLfiles
  • Backend testing using SQL queries and PL/SQL procedures
  • Wrote QTP test scripts using VB Scripting
  • White box testing of the Peoplesoft Financials module.
  • Verifying Peoplecode Events and SQR’s.
  • Used Mercury Load Runner for stress and load testing.

Environment: PeopleSoft Financials, .Net, Oracle, UNIX, TEST DIRECTOR - QUALITY CENTER, Quick Test Professional (QTP), LoadRunner, PL/SQL, SQL, SQL Server, Peoplecode, SQR, Amdocs, Enable, MS VISIO, XML, Sharepoint

HSBC – Buffalo, NY April 06 – June 07

Senior QA Analyst

HSBC is a major banking and financial institution. I have done two projects in this organization. The first project was called ACCVS (Advanced Credit Card Verification System). The purpose of this project was to enable the customer support executives to verify the identity of the person giving the credit card information over the phone. The information regarding a person’s identity was obtained by querying various government and public databases. This system was a revamp of the old credit card verification system and included additional security features. The second project was OFDP (Online Financial Derivatives Pricing). The purpose of this project is to develop an online tool which supports a wide range of derivatives including Futures, European options, American options, Exotic options (including barriers, Asian and chooser options etc), Swaps (Interest Rate, Basis, Currency, Forward Start etc). The third project is called Hedge Fund Manager (HFM) is a secure web-based system that help to manage hedge funds and deliver reports, NAV, and performance data to clients. Documents and financial reports can be automatically uploaded for trading executives. It enables trading executives to easily send and track personalized campaigns, centralize investor and prospect information, track capital changes and account balances, and report on key statistics and performance.

Responsibilities:

  • Involved in testing and Quality Assurance of Investment Banking Applications
  • Involved in preparing Test Plan and Test Cases based on the function specifications.
  • Involved in the review of requirements with business analysts and technical specialists.
  • Analyzed the application and performed Black Box and end-to-end manual testing.
  • Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time.
  • Used Test Directorbug tracking tool and as the test repository for executing the test cases and scripts and logging and generating various reports and graphs for further analysis and also to follow up the development team to verify bug fixes and update bug status.
  • Involved in UI Specifications and framework design.
  • Involved in User Interface Testing to verify the functionality of various systems.
  • Backend testing using SQL queries
  • Testing of XMLfiles

Environment: Oracle, .Net, UNIX, TEST DIRECTOR - QUALITY CENTER, Quick Test Professional (QTP), LoadRunner, PL/SQL, SQL, SAP HR, SAP FICO, MS VISIO, SharePoint
Mutual of Omaha, Pasadena, CA Nov05 – April06

Software Tester

IBM a pioneer in information technology provides technology services, consulting and e-business experience to meet the demands and new opportunities in ever-changing environment. Group sales automation project (GSAP), which includes quote generation for group sales. This system generates the premium for different types of insurance policies. While generating the quote this system will consider the insurance laws for that particular state & also the various discounts/surcharges that the company gives to the customer for that particular policy. Basically this system is at front end at company agent's office. This program focuses on making the application, underwriting and rating processes more efficient for agency and operations. The new electronic workflows mean faster application processing and policy issuance.

Responsibilities:

  • Ensure adequate and comprehensive testing is completed for all aspects of the application.
  • Involved in preparing Test Plan and Test Cases based on the function specifications.
  • Involved in the review of requirements with business analysts and technical specialists.
  • Analyzed the application and performed Black Box and end-to-end manual testing.
  • Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time.
  • Checked for the Database Integrity using the SQL Queries.
  • Used Test DirectorBug tracking tool as the test repository for executing the test cases and scripts and logging and generating various reports and graphs for further analysis and also to follow up the development team to verify bug fixes and update bug status.
  • Involved in UI Specifications and framework design.
  • Involved in User Interface Testing to verify the functionality of various systems.
  • Used ClearQuest Workflow management Tool
  • Wrote test scripts using VB Scripting

Environment: Quick Test Professional (QTP), LoadRunner, TEST DIRECTOR, SQL SERVER, J2EE, XML, MS-VISIO, MS-PROJECT, SQL, DB2, Crystal Reports, SUSE Linux, Apache Tomcat, MS Visio, Sharepoint, AS 400, MVS, CICS, JCL, QMF, TSO-ISPF

STEWART TITLE INSURANCE, Pasadena, CA Aug04 - Sep05
Tester

Stewart Loan Services (SLS) provides loan processing services to lenders and brokers. Services are available in a competitively priced bundle. Web based application designed as a managed solutions partner (MSP) to help title agents take advantage of the latest technology at decreased costs. Operating from a state-of-the-art data center, SSL eliminates the requirement for customers to host & maintain mission-critical applications.

Responsibilities:

  • Assess testing requirements and verify proper testing coverage and procedures
  • Develop Test Strategies, Test Plans and Test cases for all levels of testing
  • Ensure adequate and comprehensive testing is required for all aspects of testing
  • Work with Project Managers to obtain and assign appropriate testing resources
  • Monitor and track test progress and communicate status
  • Ensure reviews are being conducted for testing end products
  • Create and maintain all aspects of defect tracking.
  • Consistently provide high quality feedback on product readiness
  • Document final results and summarize identify success, problems
  • Document Best practices and recommendations for future testing
  • Mentoring test designers and test executioners
  • Working with the developers in fixing the defects
  • Involved in various projects as Scripter in developing the test plans and test scripts
  • Domain expertise in mortgage regulations

Environment: WinRunner, LOAD RUNNER, PVCS TRACKER, VB.NET, XML, MS-VISIO, MS-PROJECT, SQL, ORACLE, PL/SQL, Business Objects, Crystal Reports, SUSE Linux

Best Buy, Richfield, Minnesota Oct 03 – Jul 04

QA Tester

Minneapolis-based Best Buy Co., Inc. is North America's leading specialty retailer of consumer electronics, personal computers, entertainment software and appliances. The Company's subsidiaries operate retail stores and/or web sites under the names: Best Buy (BestBuy.com), Future Shop (FutureShop.ca), Geek Squad (GeekSquad.com), and Magnolia Audio Video (Magnoliaav.com).

Responsibilities:

  • Involved in preparing Test Plan and Test Cases based on the function specifications.
  • Involved in the review of Requirements with business analysts and technical specialists.
  • Analyzed the application and performed Black Box Testing.
  • Performed end-to-end manual testing.
  • Planned, coordinated and monitored project levels of performance and activities to ensure project completion on time.
  • Checked for the Database Integrity using the SQL Queries.
  • Used TestDirector as the test repository and used it for executing the test cases and scripts and logging and generating various reports and graphs for further analysis.
  • Used TestDirector for bug tracking and reporting, also followed up with the development team to verify bug fixes and update bug status.
  • Documented Software test Report
  • Worked for Point of Sale (POS), Order Entry, Production Management, Inventory Management, Warehouse Management System (WMS) and Customer Relationship Management (CRM) modules
  • Worked with Merchandise Management Module (MMS)

Environment: Test Director, IBM Mainframe, DB2, PLATINUM, FILE-AID, COBOL, JCL, Compuware

Sun Trust Bank, Atlanta, GA Nov 02 - Sep 03

QA Tester

The application consists of a Web Banking Module. The module provides client account information: account summaries, account details, monthly statements, balance transfers, accrued interest, check ordering, loan application, credit cards, financial services and Online Trading of securities stocks, bonds, mutual funds. Successfully tested the content, workflows and User Interface of this module. Involved in system and regression testing.

Responsibilities:

  • Developed QA Test plan for functional, integration, regression and end-to-end testing
  • Performed functional decomposition of requirements for developing test cases
    Worked with Users and Business Analysts to define and design test scenarios.
  • Generated test cases and traced them to the relevant use case
    Wrote and recorded scripts for Automating the testing procedure using WinRunner
  • Involved in running many batch jobs in order to retrieve data from the Mainframe
  • Wrote SQL queries to test data integration
  • Used TestDirector as the test repository and used it for executing the test cases and scripts and logging and generating various reports and graphs for further analysis
  • Used TestDirector for bug tracking and reporting, also followed up with the development team to verify bug fixes and update bug status
  • Maintained Test Matrix for the latest test results information Participated in the development of User Manuals for customers
  • Framed Business Rules according to Investment Banking, Fixed Income, Equities and credit derivatives principles

Environment: Mercury Suite (WinRunner7.0, TestDirector 7.2,), HTML, Mainframe, DB2, PLATINUM, FILE-AID, COBOL, SPUFI, ClearQuest

Mass Mutual Life Insurance Company Hartford, CT Jan02 - Oct02

QA Tester

Mass Mutual serves individual and institutional customers nationwide. Mass Mutual offers a variety of products and services, including life insurance, mutual funds, annuities, pension and retirement related services. Involved in system and regression testing.

Responsibilities:

  • Developed test cases by decomposing use cases for specific functional requirements
  • Wrote SQL and PL/SQL queries to check proper data population in application tables
  • Conducted automation for Functional testing using Win Runner
  • Performed System and Regression Testing for new releases of the application
  • Interacted with Business teams and Developers to understand business requirements and bug fixes
  • Communicated with developers through all phases of testing to prioritize bug resolution
  • Performed Interface testing to verify the data interface between various application modules
  • Used Test Director for bug tracking and reporting
  • Performed Navigation testing and cross-browser testing with IE and Netscape

to test the application behavior.