Kumar Jain (777) 7777-7777 xxxxx@gmail.com
SUMMARY
-
9+ years of experience as Software Quality Test Engineer in Insurance, E-Commerce, Media, Banking, Mortgage and Retail industries. Extensive experience in managing Software QA and Technical support organizations and programs
-
Domain 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
-
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
TECHNICAL SKILLS
QA Testing tools: Mercury Interactive Suite (QTP, LoadRunner, 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
Macys.com, Tampa, FL May 2008 - Present
Senior QA Analyst
Macy’s is a major retail organization in United States. One project was adding enhancements to the existing macys.com functionality by storing browsing history of customers and giving product recommendations to them. Another project is focused on providing Master Data support to the systems implementing the Demand and Supply Balancing component of the Macy’s Supply Chain Vision. Demand and Supply balancing refers to all the processes associated with estimating and fulfilling demand throughout the supply chain including stores, warehouses and suppliers. Macys.com was a Service Oriented e-commerce application, which tracked all product orders, Inventory, stock, shopping cart, user requests, user profiles, user purchase history, tracks shipping and returns history. Users can manage their orders (purchase, update, delete, address change). System tracks the user purchase history to present to profile the user interests. I was involved in extensive regression testing on all modules of the application.
Responsibilities:
-
Preparing Test Plan and Test Cases based on the function specifications.
-
Involved in section 508 compliance
-
Involved in accessibility testing.
-
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 Director bug 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.
-
UI Specifications and framework design.
-
User Interface Testing to verify the functionality of various systems.
-
Backend testing using SQL queries
-
User Acceptance (UAT), Integration, System and Regression Testing
-
User acceptance testing (UAT) leading, mentoring, assisting business users from the client.
-
Repairing UAT test plan and Test cases.
-
Coordinating UAT-testing effort between project managers, development lead and the end client.
-
Wrote reusable functions using VBScript.
-
Testing of XML files
-
Testing Cognos Cubes.
-
Wrote SQL queries in T-SQL for SQL Server.
-
Writing SQL queries in Oracle with including joins and clauses
-
Reviewing PL/SQL scripts and Unix Shell Scripts for data fixes
-
Automating the Regression Testing after every version change of the application using QTP.
-
Coded business components using VBScript in QTP.
-
Automated test scripts for Functional, GUI validation, Data Driven testing using QTP.
-
Used QTP extensively to make sure; none of the requirement flow gets disturbed with code fix/ application enhancements.
-
Worked with various checkpoints by using QTP.
-
Converted QTP 9.5 version scripts to QTP 10.0.
-
Adding and Maintaining test Objects in Local/Global Object Repository in QTP.
-
Adding Synchronization Steps, Adding Check points/ verification points and Parameters into automated scripts.
-
Tested Output Messages, Database checkpoints.
-
Involved in content management using SharePoint
-
Involved in Browser Interoperability testing for various versions of Internet Explorer, Safari, Firefox and Chrome
-
Involved in web based testing issues like cache, session, cookies and login issues
-
Involved in testing XML files
Environment: Oracle, SQL Server 2008, .Net, Unix, Unix Shell, XML, HP Quality Center, HP Quick Test Professional (QTP), LoadRunner, COGNOS, PL/SQL, SQL,
MS Visio, SharePoint.
IBM- Mutual of Omaha, Pasadena, CA November 2005 – April 2008
QA Analyst
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.
-
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.
-
Wrote test scripts using VB Scripting.
-
Used Test Director bug 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
-
Environment: Quick Test Professional (QTP), LoadRunner, Test Director, SQL Server, J2EE, XML, MS Visio, MS-Project, SQL, DB2, Crystal Reports, Unix Shell, Apache Tomcat, MS Visio, Sharepoint, AS 400, MVS, CICS, JCL, QMF, TSO-ISPF
STEWART TITLE INSURANCE, Pasadena, CA August 2004 – September 2005
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.
-
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, LoadRunner, PVCS Tracker, VB.NET, XML, MS Visio, MS Project, SQL, Oracle, PL/SQL, Business Objects, Crystal Reports, SUSE Linux
Best Buy, Richfield, Minnesota October 2003 – July 2004
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).
-
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 November 2002 – September 2003
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. Developed QA Test plan for functional, integration, regression and end-to-end testing
-
Involved in system and regression testing.
-
Successfully tested the content, workflows and User Interface of this module.
-
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 January 2002 – October 2002
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.
-
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.
Environment: Mercury Suite (WinRunner, TestDirector), Oracle, JAVA, HTML, Linux
CitiGroup, New York City, NY October 2001 – January 2002
QA Tester
Citi Bank offers several types of bank accounts to its customer based on criteria such as profession, income, location, etc. The services offered are also dependant on the type of account the customer holds.
-
Involved in developing test cases and test scripts for manual testing
-
Involved in manual and automated testing of the application
Performed Black Box testing, System testing, Security testing, Integrity testing
-
Developed test cases and scripts for Front End testing (GUI and Functionality)
Tested entry and exit criteria for the application screens and checked their contents
-
Performed Data Validation for the data flow from Front end to back end
Developed test cases and test data for Data Driven testing to test the data flows and tested Database integrity by creating and executing SQL statements
-
Developed test scripts in Load Runner for performance testing and prepared metrics
-
Used Test Director for Defect detection, reporting and tracking
-
Interfaced with developers to resolve technical issues and investigated software faults
Environment: Win Runner, Load Runner, Test Director, HTML, Oracle, Java
EDUCATION
Master of Science – Computer Science, Bridgeport University, Connecticut
REFERENCES
Available Upon Request
