Oracle Developer Us
Profile
- Over 10 year’s of experience in software testing with good exposure to work in all phase of Software Development and Testing Life Cycle.
- Experience in the field of IT with focus on QA and testing of Web based and Client-Server applications, SOA and Web Portal applications.
- Strong skills in designing and developing test cases, test data, test plan and execute test run.
- Experience in various testing like GUI, Functional, and Regression, Database Testing and Bug tracking & reporting system. Results analysis and metrics.
- Excellent working experience on HP Performance Center, Quality Center, ALM.
- Experience in Non-functional testing, including designing, building and running automated performance tests.
- Experience with agile / iterative design and development methodologies.
- Worked closely with Business Analysts, System Analysts and also gave suggestions & ideas to improve the quality of the software systems.
- Well versed with test planning, effort estimation, defect and test management, resource allocation, communication to clients, reporting.
- Worked on insurance Domain, Medical, Client Relationship Management and Retails.
- Excellent Soft Skills, leadership qualities, team player, enthusiastic initiator, and ability to learn the fundamental concepts effectively and efficiently.
TECHNICAL SKILLS
Functional Testing Tool : HP Quality Center, HP ALM, Rational Functional Tester, Clear Quest Test Manager, Rational Manual Tester etc.
Performance Testing Tool : HP Performance Center, HP Performance Vugen, Rational
Performance Tester
Configuration Management: Rational Clear Case, Universal Verification and Test System,
Visual Source Safe.
Operating System : Windows 9X/2000/XP/NT/ME, UNIX, Mainframe.
Data Base : Oracle8i, SQL server, DB2, MS Access 2000.
Languages : C/C++, SQL, Java, Unix.
Education:
- Master of Technology (2002) in Industrial Pollution Abatement with 7.3 CGPA,
- Confidential,Roorkee, Uttaranchal, India
- Bachelor of Engineering in Mechanical Engineering with 67.4 %,
- Confidential,University – Jabalpur, M.P., India
Professional Experience
- Working as Senior Test Engineer (Test Lead) in IBM India Pvt. Limited, Gurgaon since Feb 2006 to till date.
- Worked as Software Test Engineer in Dinodia Consulting Pvt. Limited, Delhi since July 2003 to Feb 2006
- Worked as Software Engineer with role as Software Test Engineer in MCEC Pvt. Limited, Delhi, Aug 2002 to June 2003.
- Worked as QC Engineer in pipe fabrication shop of Reliance Petroleum Refineries in Jamnagar under SS Brothers, Jamnagar, August 1998 to May 2000.
Professional SUMMERY
Project # Personal Saving Center and FileNet IS Rewrite, Standard Insurance Confidential,Portland ORCONFIDENTIAL USA
Period Feb 2011 to Till Date.
technologies Portal, Data base: Oracle
Team Size 6
role Onshore Test Lead
Description
Personal Saving center - provide secure internet access to retirement account. User can able to view account balance, transfer fund between investment, change investment direction and contribution amount, request a loan and review the transaction history.
FileNet IS Rewrite - The business purpose of the FIleNet Image Services Re-Write project is to: Begin the process of retiring the old Filenet IS system by migrating 9 specific applications from Filenet IS and 3 applications from P8 4.0 to the new P8 5.1 platform. Build the Filenet P8 Version 5.1 environments including new Oracle 11G instances which the systems require. Migrate content from Filenet IS and P8 4.0 to P8 5.1 and successfully transition business operations to the migrated applications on the new platform
Responsibility
- Understanding and analyze the business requirement and Estimate the testing effort.
- Use cases and Requirement review with BA and transfer the knowledge to offshore team member and assign the task to design the test scenario and test cases.
- Keep track of the requirement change and communicate to the team.
- Preparation of system test plan and performance test plan.
- Tracking – Project Schedule, Resource utilization, Issues, Risk escalation.
- Reviewing the test objective, test scenario and test cases and test data prepared by the team.
- Setup test plan and test set in ALM, upload test cases, mapping requirement with test cases and made analysis and dashboard to report the testing progress.
- Execution of the test cases, log the defect and keep track the status.
- Organize test planning, defect triage meeting to discuss test item and defect review.
- Provide daily, weekly and defect matrix to the client.
- Ensure the quality and timeliness of delivery of testing assignments.
- Design Test script in load runner and create scenario based on NFR to perform load testing using the VuGen, Performance Center.
- Analysis the result and evaluate the performance and delivered the same.
Confidential,USA
Period June 2010 to Feb 2011.
technologies Mainframe (System OS 390), Data base: IMS DB/DC and DB2
Team Size 4
role Onshore Test Lead
Description
Workers Compensation and APL OMNI is a Mainframe based application which handles the Claims Administration for the ACE Insurance. The various ACE field offices use this application to process the worker’s compensation and automobile property and liability claims.
Responsibility
- Preparing the QA test plan including test scenario and design the test cases and test data preparation.
- Review the test cases document and test data prepared by team.
- Execution of the test cases, log the defect and keep track the status.
- Coordinate with the downstream system to perform the integration testing.
- Reporting test status on daily and weekly basis.
- Attend the weekly status meeting with client and provide the status of testing progress.
Confidential,Georgia Technology Authority, USA
Period Dec 2009 to June 2010.
technologies JAVA, AIX, Unisys 2200, Oracle, Windows XP.
Team Size 11
role Test Lead
Description
IBM has been contracted to convert eleven (11) Unisys mainframe Georgia Bureau of Investigation (“GBI”) COBOL applications, to an open systems environment utilizing Oracle database technology and Unisys COBOL programs to Micro Focus COBOL.
These applications are currently running on a Unisys OS/2200 Series mainframe platform. IBM will use automated conversion tools and support services of a third-party provider to accomplish this conversion.
Responsibility
- Analyzed business requirement and make knowledge transfer to team.
- Designed and developed test scenarios based on functional requirement and use case document.
- Design Test condition and Test Cases specification and setting up test environments.
- Manual test cases design in Rational Manual Tester and run the script by using Clear Quest Test Manager.
- Performing the test case execution, troubleshooting & validation in Regression testing phase.
- Performance, load and stress testing using rational performance tester.
- Defect logging and tracking in Clear quest.
- Attend formal & informal meetings and coordinating with team members.
Project # PuHO IBM, Helsinki, Finland
Confidential,Finland
Period August 2009 to Nov 2009.
technologies JAVA, J2EE, JSP, DB2, Windows XP.
Team Size 4
role Senior test engineer
Description
PuhO is an application, which is meant to be taken in use in sorting point work at Vantaa logistics centre. PuhO directs workers in sorting of shipments, in printing of container labels and in closing ready carrier items. In addition PuhO enables reporting and supervision of the work based on the congestion of sorting points. The process descriptions of this document are based on the Use Case model of the PuhO application
Responsibility
- Review use cases document and prepare the test case scenario on the basis of use case document and requirement document.
- Preparation of Test Cases to validate the application made as per requirement and setting up test environments to execute the test cases.
- Manual test cases design in Quality Center and execute the test cases.
- Performing the test case execution, troubleshooting & validation in Regression testing phase.
- Defect logging, reporting and tracking in Quality Center.
- Regression testing for all change requests and an overall regression for each release.
- Preparing Status reports of test execution, defect status for each release of application.
Confidential,Government
Period Jan 2007 to July 2008 and Jan 2009 to July2009
technologies JAVA, J2EE, JSP, DB2, Windows XP.
Team Size 7
role Senior test engineer
Description
VISTA is an application for managing Social Insurance in Switzerland. It consists of many applications split as Core and Business applications.
Core Applications, are the applications, which provide the basic functionality to the business applications. Like Partner Management (PV), Individual Account (IK) etc
Business Applications are various insurances offered by VISTA, like Pension (RE), Supplementary Benefits (EL) etc
VISTA is built on custom {Client / Server} frameworks to implement the mentioned applications.
It will be deployed across Switzerland in more than 15 Cantons (states).
Responsibility
- Review the FIT Identification and use cases document and prepare the test case scenario on the basis of use case document and requirement document.
- Preparation of Test Cases to validate the application made as per requirement and setting up test environments to execute the test cases.
- Preparing test basis data using various business rule and data correlation and design the SQL script to insert the data in database before the start of the Execution Phase.
- Automate the System test case using Rational Functional Tester
- Performing the test case execution, troubleshooting & validation in Regression testing phase.
- Developing Traceability Matrix to map test cases with use cases and Business Rule.
- Defect logging, reporting and tracking in Clear quest.
- Regression testing for all change requests and an overall regression for each release.
- Preparing Status reports of test execution, defect status for each release of application.
- Attend formal & informal meetings and coordinating with team members.
Confidential
Period Aug 2008 to Dec 2008
technologies JAVA, JSP, SOA, DB2.
Team Size 11
role Senior test engineer
Description
EKKO is part of a larger SKAT system modernization program that also embraces a new infrastructure platform (IP).
Agreement and Distribution (A&D) is a component in SKAT’S new platform to handle all distribution of messages to customers, thus centralizing all functionality and requirements regarding communication with customers. When ever a system needs to send a notification, distribution and other messages to the customer then A&D is responsible for formatting the message and delivering the message to the customer. As new SKAT systems will be developed it’s the intension that these systems will reuse the A&D services.
Responsibility
- Development of test environment
- Installed and configured CQTM and trained to team member.
- Implementation of RFT and provided the training to team members.
- Implementation of RMT and provided the demo to team members.
- Prepared Test Cases and Review the test cases prepared by other team member.
- Performance testing of application by using Rational Performance Tester (RPT).
- Developed traceability Matrix to map test cases with use cases and WPI for review of test cases.
- Coordinate and communicate test deliverable tasks with developers and test team.
Confidential, US
Period Feb 2006 to Jan 2007
technologies JAVA, J2EE, JSP, DB2.
Team Size 8
role test engineer
Description
e-Pricer is a Web based application that provides various pricing functions needed by IBM representatives and support centers to price a customer quote quickly, easily, and consistently.
e-Pricer supports the Value Price Solution step of the CRM Solution Design and Delivery (SDD) process.
e- Pricer application has three modules – GUI, Administration and Setting.
GUI module is used to create quote – National, International and GCO. For all quote e-Pricer will retrieve customer information, Display list price, Display cost and profitability measure, Display delegated prices based on user delegation etc.
Setting module is used to manage customer list, country list, Brand list, Parts file, etc.
Administration module is split in three parts-Profile management, Authorization Management and Personal management.
Responsibility
- Designed and developed test scenarios based on functional requirement and use case document.
- Conducted Peer Review of test cases and test data prepared by team members.
- Prepared Test Cases for functional testing of application and Test data before test execution phase.
- Created manual test script and run through Rational Manual Tester to validate the system.
- Performed Graphical user Interface, Functional, Integration, Regression and Smoke Testing.
- Prepared Bug reports, logged and tracked through the Clear Quest.
Confidential,UK
Period July 2005 to Feb 2006
technologies JSP, JAVA, ORACLE 8i
Team Size 5
role test engineer
Description
This is a B2C portal for online shopping which provides various types of products for the buyer; XL Shopping mall-solutions cater for both small businesses and large corporations, and, since its creation have helped many businesses within these fields. Users can place orders for various products. Application allows user to keep the selected goods in cart. It is easy to use this site because build tools allow people of all levels of experience to build fully e-commerce enabled and search engine friendly sites.
Responsibility
- Identified the test scenario and Design test cases as per functional requirement and design document.
- Performed sanity, Functional, regression and GUI testing for each build of application.
- Automate the regression test cases using Win Runner and maintained the test script build wise.
- Execution of Test Cases and Reporting defect to the concerned and validate defect.
- Defect and Test Management using Quality Center and responsible for reporting.
Confidential,
Period oct 2004 to June 2005
technologies JSP, Java Script, Oracle8i
Team Size 4
role Test Engineer
Description
Mainly there are two modules in this project Admin and Product. Admin module maintains all backend database operations by their administrators. Products module have 2 categories Software and Hardware. According to the products they needed customers can organize these online only. It has a search engine for any product that has been developed by Winston along with the various features available for those goods.
Responsibility
- Identified Test cases and recording test script in Win Runner as per test procedure.
- Customized the recorded test script and creating robust test suites.
- Performed Regression testing using test suites and analyzing the playback result.
- Responsible for created test environment and test data availability to application.
- Prepared defect description, reports and tracked the defects using Quality Center.
Confidential,
Period feb 2004 to sep 2004
technologies JAVA, oracle8i
Team Size 5
role test engineer
Description
This is an application for managing customer relations through online. The system allowed the registration of Customers, Customer orders, updating order, order status, Send suggestions about the product and search for specific product and Money Transactions. The system had an administrator provision for dealing money transactions with the customer.
Responsibility
- Peer review of test cases, prepared test data and execute them as per requirement.
- Recorded the test script using Win Runner and execute them for regression testing.
- Performed Black Box testing like Functionality testing, Integration testing, Regression testing etc to test the quality of the product.
- Prepared Bug reports and interacted with developers for fixing of bugs and verified.
Confidential,
Period july 2003 to jan 2004
technologies Visual Basic 6.0, windows and Oracle 8i
Team Size 4
role test engineer
Description
Comprehensive Infirmary Management Software designed to automate all aspects of Hospital Management. The package contains several modules to look after each and every department of Hospital Maintenance. The software is specifically designed to help manage the Hospital very efficiently and provide overall supervision of all operations. The different modules to cover entire operations of Hospital are Reception, Admission, Diagnostics, Billing, Pharmacy, Administration, and Reports.
Responsibility:
- Designed the functional test cases and test data as per requirement document.
- Created test environment and performed functional, regression and database testing.
- Executed the test cases and find the defect and logged in quality center.
- Documented the test result and defect and report daily defect tracking.
- Prepared Rout Cause Analysis document and defect matrix and traceability matrix.
Confidential,Period Aug 2002 to June 2003
technologies Visual basic 6.0,
Team Size 6
role Test engineer
Description
This project is to automate a consultant’s needs. It has four modules like Master details, Client details, and Applicant details and reporting of all the transactions. To make the transactions easy for the consultants like fetching the job orders from the clients, providing jobs to the applicants, keeping records off all the applicants with their skills, limitations, training provided to them, placements etc.
Responsibility:
- Understand the business requirement, development and system test plan document.
- Designed test scenario and test cases on the basis of functional requirement doc.
- Involved in sanity, Graphical User Interface and Regression testing of application.
- Test case executed to validate the application against requirement and log defect.
Certifications:
- Foundation Level Certificate in Software Testing of ISTQB.
- Brain Bench Certificate of software Testing.
- Brain Bench Certificate of software Quality Assurance.
- Brain Bench Certificate of RDBMS.
Training:
- Quick Test professional 8.2
- Rational Performance Tester
- Testing process and Best practices
- J2EE
- QMS and CMMI.
- Rational Manual Tester
- Rational Functional Tester
- Rational Test Manager