Test Cases Project
Resume:
SUMMARY:
Having **+ Years of Manual & Automation Testing Experience with Web based & ERP Applications.
More than 2 years of Onsite Experience with Onshore – Offshore coordination activities
Involved with different types of tests such as Regression Tests, Functional Tests, User Interface Tests, Integration Tests and End to End Tests were performed on the application.
Involved in Client-server Applications Testing, Web-Testing, ADF Application Testing, Oracle Applications 11i and R12 testing, Oracle Fusion, Browser Compatibility and Database Testing.
Understanding the Business requirements and Functional specifications to come up with appropriate Testing scope.
Understanding the technical and functional specifications, Creating Test Estimations, Test Plans, review and monitor test approach.
Work experience on Agile, V-model and Waterfall model.
Good Knowledge in Agile teams with a BDD approach.
Hands on experience in building Selenium Framework using TestNG.
Having experience with various testing tools like QTP, OATS, SOAP UI & Selenium...so on
Hands on experience in Tracking and Reporting of defects using Defect Tracking Tools such as QC/ALM, Oracle Test Manager, JIRA and Bugzilla.
Hands on experience in developing Automation frameworks, Test Scripts using QTP (Script), Selenium and OATS.
Developed a Keyword Driven Framework using OATS12.1
Having Good Knowledge in Groovy Scripting.
Involved in database Testing using Oracle,SQL Server and Toad tool for Data Validation.
Hands on experience in writing SQL Queries, extract data from MySQL, DB2 and Oracle.
Hands on experience in building Keyword Driven, Data Driven, Modular and Hybrid Frameworks.
Work experience in designing reusable and reliable functions in Core Java and VB Scripts.
Worked on Oracle Financials (Payments, Cash Management, Receivables and Advanced Collections, HRMS & Treasury) for the different versions of ERP Systems (R11 &R12) and JD Edwards.
Worked on Oracle Fusion HCM Module.
Got Trained in the R11: HCM Cloud Implementation Workshop
Good Functional & Domain Knowledge on Oracle Financials(AP,AR,GL,CM,FA,OM,PO),Supply Chain Management, Oil & Energy, Manufacturing and Banking domain
Had Testing experience with Tandem Applications
Proficient in Disaster Recovery Testing.
Performed MQ Series and Web Services and Rest-API Testing.
Ability to work in flexible mode for different type of requirements on diversity of applications.
Education
Bachelor of Engineering in ECE from Madras University
Certifications
AQM Certification from Oracle
Technical Profile
TECHNICAL
Skills
Operating Systems
Windows & Unix
Automation Tools
QTP10.x, OATS12.x, Selenium RC/Web Driver,Jmeter, Auto It, HP UFT 11.x
Database
Oracle 10g, SQL Server 2000, SQL Server 2005, MySql
Languages/ Web Technologies
VBScripts, MQ series, Java, C, UNIX, Magneto, ASP.NET, JavaScript, Cucumber, Gherkin
Development / Productivity Tools
HP QC 11.x, JIRA, TOAD, Soap UI, Eclipse, Web Services
ERP Systems
Oracle R11i, Oracle R12i & JD Edwards
Reporting Tool
OBIEE 12c
Work Experience:
PROJECT # 1:
Project Title
Oracle R12 Database& Application upgrade
Client
Subaru of America
Location
Cherry Hill NJ
Duration
Jan 2016 to till Date
Environment
Java, Oracle Apps R12.2.6 (AP, AR,GL,PO,IB,Contracts)
Testing Tools/Reporting Tools
OATS12.5, Jira, Selenium
OBIEE 12c
Role
QA Automation Tester
Project Description:
Subaru of America, Inc. (SOA) is the U.S. Sales and Marketing subsidiary of Fuji Heavy Industries (FHI) of Japan and is responsible for the distribution, marketing, sales and service of Subaru vehicles in the United States.
Roles & Responsibilities:
Understand the Business requirements
Manage Offshore team and assign tasks to be performed.
Prepare Test cases based on the MD50 document.
Prepare Detailed Test cases based on the high-level scenarios available.
Prepared detailed End to End Process of P2P document and Automated the same.
Worked on different Financial Modules like AP, AR, GL, PO, IB and Contracts.
Created library of functions, methods and Reusable Actions.
Automated O2C and Drop Ship End to End Process in OATS using Java.
Automated Payment Batch Process for different Pay Group Templates.
Identified the Post Clone Validation scenarios for EBS and Automated the same.
Automated the Snet web Application using the Selenium Web driver.
Performed Functional testing of Web Services using SOAP UI.
Execute Functional and integration testing scripts for Web Applications.
Performed defect logging and tracking using Jira Tool.
Identify the Regression Scenarios and Automated the Test scripts using OATS.
Execute Manual and Automated regression scenarios and report the defects in Jira.
PROJECT # 2:
Project Title
IFA
Client
NRUCFC(National Rural Utilities Cooperative Finance Corporation)
Location
Sterling,VA
Duration
April 2015 to Nov 2015
Environment
Java, Oracle Apps R12 (AP,AR,GL,PO),HCM
Testing Tools
UFT12.5,ALM,Jira,Selenium Web Driver
Role
QA Automation Tester
Project Description:
The CFC Cooperative System Integrity Fund serves as a resource to the rural electric program to support the efforts of cooperatives to resist threats to the integrity of their service territory, to protect the right of rural electric systems to provide non-electric energy services, and to assist cooperatives that are facing regulatory, judicial and legislative challenges that have the potential to materially affect the system integrity of other cooperatives in a state, region or the nation.
Roles & Responsibilities:
Understand the Business requirements
Prepare the Test Plan document
Prepare Test cases based on the functional requirement document.
Presented Test cases to Business for peer review and ensure completeness.
Provide Daily Test Status Report and Testing Activities to the Project & QA Manager.
Worked on different Financial Modules like AP, AR, GL, and PO.
Created library of functions, methods and Reusable Actions.
Did Integration Testing with Power Builder Application.
Performed defect logging and tracking using Jira Tool.
Assist the business users in Identifying and executing the UAT test cases.
Developed Automation Scripts for Fusion HCM Application using Selenium Web driver.
Involved in updating the Selenium Web Driver Scripts for web applications.
Execute Functional, integration, and regression testing scripts for all modules of Oracle Financials, AP, AR, GL
Developed Data driven Framework using UFT.
Identify the Regression Scenarios and Automated the Test scripts using UFT12.5.
PROJECT # 3:
Project Title
WFS – QA
Client
World Fuel Services(WFS)
Location
Miami, FL
Duration
Nov 2012 to Mar 2015
Environment
Java, Oracle Apps11i (AP, AR,TREASURY,AC), Web services
Role
QA Lead
Team Size
5
Automation Tools
QTP11.0 & QC11.0, OATS, Selenium Web Driver
Project Description:
WFS is a global leader in the downstream marketing and financing of aviation, marine, and ground transportation fuel products and related services. Provides fuelling and logistics services to air carriers, cargo and charter, private aircraft, and marine operators. They are into Oil Energy domain in Technology space of Oracle Apps, Java & SOA in support of 15+ applications to run their business.
Roles & Responsibilities:
Worked in Automation testing and lead a 6 members Team.
Develop test cases based on the Business Requirement and Functional Document (MD50) for oracle apps and web applications.
Extensively worked in developing the automated scripts using Selenium for web applications.
Developed data driven framework using Selenium web driver and TestNG for reporting.
Extensively worked in developing the automated scripts for Oracle Financial Modules using QTP10/UFT11.0 and OATS.
Worked on different Financial & SCM Modules like AP, AR, GL, Advanced Collections, Oracle Treasury, BOM and WIP.
Performed manual testing of Order to Cash, Procure to Pay, Accounts Payables, and Accounts Receivables
Worked on Preparing Test Metrics.
Execute Manual Test Cases and report the defects using the HP ALM tool.
Developing new scripts for newly added functionality.
Created scripts for functional and regression testing.
Executed SQL queries to validate the data.
Coordinate with developer & for un-interrupted build & test cycles.
Review weekly status with key project stake holders.
Participated in Phase Gate Meeting, Daily Defect Meeting and Sign-Off Meeting.
Provided Test estimations and Testing Metrics for testing project.
Identify new Regression Scenarios for each Release
Work allocation for the team, status update, team co-ordination
Worked with DB connection, FSO and Excel operations.
PROJECT # 4:
Project Title
Eseal
Duration
April 2011 to Oct2012
Organization
Sunera Technologies
Environment
Magento,OATS,QTP10
Role
QA Tester
Project Description:
E-seal ™ is to enable the Product with their corporate customers. TheEseal solution would enable Products
to protect and leverage the business value of the existing legacy systems and improve user subscriptions
by remodelling existing Content Management system design (Content Showcase and Cartridge Server)
into smaller, more maintainable modules and components (Modularization/Componentization) and
redeveloping these remodeled modules/applications.
Responsibilities:
Involved in preparation of Test plan.
Participated in writing Test cases, User Stories and execution.
Involved in defect reporting using jira.
Developed Keyword Driven Framework using OATS.
Developed a POC for Web and Oracle apps using QTP10.
Managing daily status reports, Test metrics.
Had Peer Review of test cases with dev. team
Project 5#:
Project Title
Bank ON
Client
Standard Chartered Bank
Duration
July 2010 to March 2011
Organization
Sierra Atlantic
Environment
Java, Oracle Apps12,MySQL & QTP 10.0,Agile Methodology
Role
QA Module Lead
Team Size
10
Project Description:
Bank ON™ is to enable the bank to interface with their corporate customers. It allows the bank to integrate their core banking application system with customer ERP systems. Bank ON™ will facilitate in bridging the automation gap that currently most of the banks have while processing their customer’s instructions in terms of Accounts Payables, Accounts Receivables, Cash Management and Trade.
Bank ON™ supports conversion of native formats that the customer ERP generates to the standard formats that is required by the banks to process the requests.
It takes various types of financial and non-financial requests and sends to the bank for further process. Similarly, it updates the customer about the status in terms of Account status updates, Bank statements, Account Reconciliation statements etc.
Responsibilities:
Test execution on different ERP systems (R11, R12, JDE)
Support on UAT Testing
Performed Testing on Oracle Financials Modules on various ERP systems.
Had Peer Review of the test cases with Domain Expertise.
Bugs reporting in Share Point Portal.
Participated in daily scrum meetings where all the testers will address any blockers blocking testing and discuss the status of assigned tasks.
Automated the Java Applications using Selenium.
Automated Oracle EBS [Payables and Cash Management] scenarios using QTP
Project Title
D3 Migration
Client
Chicago Pub Schools
Duration
Feb 2010 to July 2010
Organization
Dell
Environment
ASP, MS Access, C# & SQL Server 2005
Role
QA Engineer
Team Size
2
Tool
HP Quality center 9.2
Project Description:
The objective of D3 Migration project is to remove FMPro from being dependant on Dell Data Warehouse (DDW) for Order Data. FMPro will utilize FDR as its source for all order information previously gathered from Dell Data Warehouse (DDW).
CPS places the System Orders and Order Details are pulled from the upstream Application FDL and Placed in a share Point and From Share Point again pulls and generates CSV File. File is further moved to FMPro Database for Processing the Order and Ship to the customer. All these Operations will occur with the help of Jobs which run on Schedule Basis.
Role & Responsibilities:
Preparing and execution of test cases
Prepared Test Specifications [Test Plan, Test Methodology, Test Strategy…]
Performed Database testing using SQL Server
Performed Web Service Testing using SOAP UI
Had Peer Review of test cases with dev. team
Defects logging into Quality Center
Daily, Weekly & Ad hoc Status Reports
Project Title
GPT
Client
Dell Inc.
Duration
Oct 2009-To Jan 2010
Organization
Dell Inc.
Environment
ASP .NET
Role
Automation Tester
Team Size
1
Tool
HP Quality center9.2 & HP QTP 9.5
Description:
This Application deals in creating Order Number as per the customer Required Configuration. And the number of Modules Include in Creating Order for customer is Tech Spec, OEI, Project Eligibility, MI, Pilot Process and Pilot Queue. And once all the Modules are completed then order will be created for Customer. Automation done for all the Modules.
Role & Responsibilities:
Identifying Test Cases for Automation feasibility
Test data preparation for Automated Scenarios
Automation Script development using Descriptive Programming
Design and develop the most reusable automation test scripts using VB Script.
Test execution from Quality Center
Involved with ROI based preparations.
Worked with DB connection, FSO and Excel operations.
Worked with Dictionary objects.
Project Title
Best Buy B2B integration
Client
Best Buy
Duration
July 2009 to Sep 2009
Organization
Dell
Environment
ASP, MS Access, C# & SQL Server 2005
Role
QA Engineer
Team Size
1
Tool
HP Quality center 9.2
Project Description:
The objective of Best Buy B2B integration (Customer On boarding) project is to implement online electronic transactions between Best Buy and Dell (FMPro).
BestBuy Sends PO Inbound Details to Invois and Invois sends to FMPro. Based On PO Sent By Best Buy Dell makes Systems Ready and once the Sytems are Ready to Ship FMPro Genarates ASN Message and Sents to Invois and Invois Sends to BestBuy. All these Operations will Happen with the help of Jobs which run on Schedule Basis.
Role & Responsibilities:
Preparing and execution of test cases.
Prepared Test Specifications
Done Database testing using the Sql Server.
Performed XML Validation.
Had Peer Review of the test cases with dev team.
Logged the Defects into Quality Center.
Prepare Daily Status Report.
Project Title
P2M
Client
Dell
Duration
June’2008-To June 2009
Organization
Dell
Environment
ASP, VBScript, Oracle
Role
QA Engineer
Team Size
2
Tool
HP Quality center 9.2,Toad &QTP
Description:
P2M is a Dell on Dell Material Management, macro scheduling, line optimization, capacity planning and material picking solution for highly flexible kitting, boxing & Options / Over-pack processing.
P2M integrates with GE Cimplicity SCADA solution to provide a fully automated kitting and boxing system. P2M application is used in Kitting and Boxing areas in the manufacturing areas. These are the areas where the parts required by the units are picked. P2M also provides the powerful reports which will help in analyzing data.
It has been developed using .Net and data storage is Oracle 10G. Till now worked for ECFC, and EMFI dell facilities.
Role & Responsibilities:
Preparing and execution of test cases.
Prepared Test Specifications
Done Database testing using the TOAD 8.6 Tool.
Had Peer Review of the test cases with dev team.
Performed End to End Testing
Automated the functionality using QTP.
Performed web services testing using QTP.
Logged the Defects into Quality Center.
Uploading of Test cases into Quality Center & Execution
Defects review meetings with Dev.
Prepare Daily Status Report.
Project Title
DPM EMFP & DAO
Client
Dell
Duration
Jan’2007-May2008
Organization
Dell
Environment
ASP, VBScript, Oracle,Oracle Apps
Role
QA Engineer
Team Size
3
Tool
Quality center9.2,Toad
Description:
Mintelligence is a reporting application consisting of many dashboards in DAO and EMEA Region. Some of the dashboards are meta data driven.The reporting helps the business and the management to know about the Parts demand,Order status,Backlog orders, In production orders and Piece part demand data linked to orders on the factory floor for all the EMEA regions . The reports are represented in the form of grid view,graphs, Pie charts and drill downs which facilitates the management to take strategic decisions on the business.
The reports also contains the filtering capabilities upon which the user can check the speciifc order details.The data retrieved from the dashboards will be Near Real Time.Each user can save his report and can check the report with refreshed data at any point of time. The dashboards can be accessed by the admin privileged user.Users will be given the accounts to access Mintel reporting site.
Role & Responsibilities:
Preparing and execution of test cases.
Prepared Test Specifications
Played the active role in the Preparation of Test data for creation of orders for the team.
Done Database testing using the TOAD 8.6 Tool.
Had Peer Review of the test cases with dev team.
Performed End to End Testing
Logged the Defects into Quality Center.
Uploading of Test cases into Quality Center & Execution
Defects review meetings with Dev
Project Title
MWCP MIGRATION
Client
DELL U.S.A
Duration
Jun2006-Dec2006
Organization
DELL
Environment
ASP.Net, C#, SQL Server2000
Role
QA Engineer
Team Size
4
Description:
The main aim of the project is to migrate the MWCP data source to FDL data source for some of the downstream applications. As tsl/bios gets some of the order related data from MWCP data source by using some of the MWCP jobs so with this migration the tsl/bios gets order related data from FDR data source. All MWCP Jobs are now made to get data from FDR. All MWCP name references are changed to FDRP in the tables, Stored Procedures and job names.
Role & Responsibilities:
Preparing the test cases
Prepared Minutes of Meeting.
Prepared Traceability matrix and done Peer Review of test cases.
Understanding of Dell Manufacturing process.
Done database comparison.
Executed Test cases for Retesting & Regression testing
Logged the Defects into Quality Center.
Up loading of Test cases into Quality Center & Execution
Analysing the Requirements and identifying the test scope of the application in the process of Test Specification
Preparation of Test data
Prepare Daily Status Report.
Project Title
TSL/BIOS Data Loader Migration
Client
Dell
Duration
Nov 2005 – May2006
Organization
Dell
Environment
VB.Net, ASP.Net, SQLServer 2000.
Role
QA Engineer
Team Size
7
Description:
The Aim of the Project is to Move all the scheduled jobs running for TSL/BIOS from Sql Server Agent to Control M Job Scheduler running on dedicated app servers and Addition of instrumentation within all Jobs to aid job monitoring and displaying the Health of the Jobs on Dashboard. All the Jobs run from the Control-M Job Scheduler and get the data from source table and update in the base tables which will be used by the TSL-BIOS App for Reporting. The Health of these Jobs is displayed in the form of Process Status Dashboard which shows the details of the jobs like Current Status, Runs Today, Failure Today, Run Duration in the Dashboard and also color indication.
Role & Responsibilities:
Prepared test cases and done Peer Review of test cases.
Done Database Testing for Validating the Data after Migration.
Done Database and UI Testing for Dashboard using Cursors and Joins.
Played the role of Configuration Management for the team.
Involved in Post-Installation Testing.
Contact this candidate