Professional Summary
•Having around ** years of experience in Functional and Performance Automation and Functional Testing with a wide variety of tools and projects
•Great hands on experience with OATS 12.5, Oracle Test Manager-OTM, OLT, Quick Test Professional-QTP/UFT, Mercury Quality Center-QC-ALM, Selenium, JIRA, SVN, GIT – BitBucket, Testrail, SQL, Database Testing and VMs
•Great hands on Experience in Framework design such as Modular, Keyword, Hybrid and Data driven with QTP/UFT, Selenium and OATS
•Hands on experience with Visual Basic VB-Script, Java and Java scripting languages
•Good working experience in scripting and developing with QTP/UFT, Selenium-Web Driver, OATS
•Great working experience in Creating Object Libraries, Java class files, Child scripts and Function libraries with OATS
•Good hands on experience in executing the performance cycles and script development with OATS
•Migrating lower version (OATS 12.3, OATS 12.4 )scripts to higher version of OATS 12.5 and resolving installation/migration issues
•Creating the Customized Object Library for OATS Hybrid framework with java class files and custom X paths identify objects with minimal failures
•Implemented error handling with Java and used POI jars for test data handling
•Expert in using Databanks, Data table, Database connection and dynamic test data handling
•Good working knowledge in SOAP and REST Services with UFT, Selenium and OATS
•Good working knowledge with Oracle forms 6i, 10g, 11i and ERP R12
•Install OATS, Configure Oracle Test Manager and create/maintain projects in OTM
•Strong experience in OATS Open script, OTM and OLT Performance testing
•Good experience in Automating Oracle EBS/ERP applications Forms(Order Management, O2C, Service Contracts flow, Invoicing), ADF, Flex, .Net, Java, Windows, Web and Desktop applications
•Great hands on experience with UFT Descriptive and Object oriented programming, Modular, Keyword Driven, Hybrid Framework development
•Well versed with the Agile-Scrum and Waterfall methodologies.
•Well versed in Integration, Regression, Functional, Front-End, Exploratory, Backend Testing.
•Certified in HP-QC,HP-QTP and QMS process
•Hands on Experience with ERP 11i, R12, Order Management, Pharma, Insurance, Energy and Banking domains
Educational Qualification
Master Degree in Computers Applications (MCA)
Bachelor Degree in Computer Science (BSC)
Professional Summary
Project #8
FCT Automation
Feb-2017 to Till Date
Client
First America Title Company, Santa Anna, CA
Technologies
OATS –Open Script 12.5.0.2,OLT, OTM, ADF, Hyperion, EBS R12, Share Point
Team size
5
Role : OATS Automation Architect & Onsite Coordinator
Description
First American Title Insurance Company facilitates and streamlines real estate transactions by providing comprehensive title insurance protection and professional settlement services. First American Title helps homebuyers and sellers, real estate agents and brokers, mortgage lenders, commercial property professionals, homebuilders and developers, title agencies and legal professionals close transactions. Find out more about our products and services, and how First American can help you streamline your transaction and protect your investment.
Part of this project, we have implemented OATS functional and performance automation of EBS R12 AP, AR, GL, CM, OM modules to stream line all the transactions across the EBS flow. Implanted the standards, automation framework enhancements and OTM configuration in multiple environments and servers.
Roles & Responsibilities
Discuss with Business and Functional leads on the key areas where automation needed
Identify automation scenarios and create functional backlog
Create the Automation scripts with OATS – Open script and execute them for monthly release
Configure Oracle Test Manager-OTM for Automation scripts and run the monthly runs from OTM
Improved the existing OATS automation framework to accommodate multiple OUs, Multiple environments without any changes to the scripts
Resolved the existing log awaiting issues like OATS object identification issue with ADF, EBS Forms not launching issue with OATS, Unable to execute scripts from OTM, Script failing for multiple OUs, Script modification required whenever environment refreshes
Prepared OATS set up, Automation play book, framework documents for future use
Coordinating with the team members from offshore and onsite and stay on top of the day 2 day work assignments
Guide the FA team towards the QA and Automation process improvement
Monitor the performance script development, Execution and Performance cycles
Review the Performance results and recommend the opportunities for tuning
Coordinate with the DBA, Infra, DEV teams and implement the tuning recommendations
Report the weekly status report to stakeholders
Conduct training sessions on QA process improvements and OATS Advanced framework concepts
Develop Functional OATS Automation scripts for the EBS Forms R12
Create and develop E2E automation scripts for AP, AR, Gl, FA and OM modules
Project #7
EOS O2C ERP Automation
Aug-2016 to Feb 2017
Client
Veritas Technologies, Mountain View, CA
Technologies
EBS Forms, ERP R12, OATS –Open Script 12.5.0.3, Order Management, O2C
Environment
Java, Web and EBS/ERP R12 applications
Tools
QMS, JIRA, OATS, SQL Developer, Share point, Application Test Manager-ATM
Team size
6
Role : OATS Automation Architect
Description
After Veritas separated from Symantec, Veritas would like to solve the existing problems in the Order management system like Billing issues, Auto invoice issues, Auto booking rules from the customers, Auto renewal of the service contracts like around 300 issues were found in the existing system. Veritas designed a project called Easy order system to fix and test all these issues.
Part of EOS, We did the complete E2E testing of the order workflow and fixed the issues in monthly releases. Business team assigned the priorities for the issues, QA and DEV collaboratively worked together to achieve the goal.
Roles & Responsibilities
Review and understand the existing issues in the ERP R12 O2C flow
Review the requirements related to the issue/enhancement and do requirement ambiguity testing
Discuss with the Biz team on the requirements and sharing the knowledge to the team
Prepare Test plan, Test Cases and Test execution from ATM - Application Test Management tool
Raise the defects and triage the defects with DEV team for quick resolution
Identify the candidates for Regressions suites from Order creation from multiple sources
Create Automation Framework to suite the E2E data driven scenarios
Created the E2E scripts to full fill the Order creation, Service contract generation, Auto booking rules, invoice creation and cash flows
Identify and Develop Reusable components and framework components
Groom the Functional team on OATS and Automation Script execution
User story creation and peer review
Project #6
OM ERP Automation
Mar 2016 to Aug 2016
Client
Beach Body LLC, Santa Monica, CA
Technologies
EBS Forms, R12, OATS –Open Script, OTM
Environment
Java, Web and EBS/ERP applications- Order Management
Tools
QMS, JIRA, GIT-Bit Bucket, OATS, OTM, SQL Server, VM, Confluence
Team size
8
Role : OATS Automation Architect
Description
Team Beachbody is where your healthy lifestyle begins. Created in 2007, this direct-selling division of Beachbody is powered by our independent distributors. We call them Coaches.
Our Coaches can help you achieve fitness or financial success with a combination of Beachbody's proven home workout programs, easy-to-follow meal plans, nutrition advice, financial incentives, and a support system like no other.
Real transformation takes work and a little help along the way. So whether you want to lose weight, get fit, or earn money by helping others, Team Beachbody offers a unique opportunity to turn your interest in fitness and weight loss into a part-time or even full-time career.
Roles & Responsibilities
Create Automation Framework for the ERP Suite applications
Identify and Develop Reusable components and framework components
Design and develop test strategy and plan
Design Automation scripts with OATS
Execute and Fix the scripts issues
Execute the existing scripts and improve the script performance by implementing the standards and best practices
Coordinating with the offshore resources on daily status and issues/blockers
Discuss with the onsite client team to resolve the issues quickly and effectively
Conducting daily stand ups and sprint retrospective meeting
Maintain proper documentation across the sprints
Project # 5
DART Automation
Feb-2015 to Mar-2016
Client
MISO Energy, IN, USA
Technologies
Automation Framework Development, VB Script, Java
Environment
.Net, WPF, Oracle Forms, Java, Web and Desktop applications
Tools
QMS, JIRA, GIT-Bit Bucket, HP-UFT, Inflectra- SpiraTeam, TOAD
Team size
10
Role: Automation Architect & Onsite Coordinator
Description
MISO exists to provide an independent platform for efficient regional energy markets. Since 2001, MISO have fostered wholesale electric competition in the region, created greater system reliability and established coordinated, value-based regional planning. As a user of Smart Grid technology, MISO furthers the U.S. Department of Energy’s goal of revitalizing the nation’s electric grid. Information gathered from our synchrophasors allows us to detect conditions of the electric grid 30 times every second. Synchrophasors provide immediate value - enhancing MISO’s ability to simulate and troubleshoot the bulk power system to bring a new level of situational awareness for grid operators.
(DA) The Day-Ahead Energy and Operating Reserve Market is a forward market that simultaneously clears energy and operating reserves on a co-optimized basis for each hour of the next Operating Day.(RT) MISO’s Real-Time and Operating Reserves Market continuously balances supply and demand at the least-possible cost while also recognizing current system conditions.
Roles & Responsibilities
Single point of contact for the engagement technical and tactical issues
•Develop Automation framework with UFT and design Reusable components
•Maintains the Automation code repository with GIT and controls the versions for script development and execution
•Review of the Test scripts and reusable components and provides feedback and review comments
•Identify the Regression scenarios for Automation and prepare the Sprint backlog
•Develop automation scripts for the regression case and schedule the script execution in different environments
•Design Object repository, Business and Generic library functions in the framework
•Extensively used the Descriptive programming and File handling methods to reduce the script execution time
•Used descriptive programming with COM and DOM objects for handling the dynamic objects in the applications
•Used extensive VB Scripting, File objects and Windows object automation for better testing
•Analyze the test results and Raise the defects for the functionality failures and script fixes for script failures
•Prepare the Test summary report and share to the stake holders across the org
Project# 4
MICROS OPEARA – 5
Jan-2014 to Feb-2015
Client
MICROS (Subsidiaire of Oracle, USA)
Organisation
Alliance Global Services(EPAM Systems)
Technologies
Java, Oracle forms 6i, Oracle 10g database, Oracle ADF forms
Environment
Windows 7, Oracle Applications Forms 11g, Web
Tools
QMS, OATS 12.3,JIRA, SVN, Open Script IDE
Team size
8
Role : Automation Lead
Description
Micros- Is a front desk hospitality management system that operates across the Hotels. Micros have major versions called Opera-5 and Opera-9 which works with Oracle EBS Forms. Micros have major modules Configuration, Property Management System (PMS), End of the Day (EOD), Utilities. Opera has automated the way of reservation in Hotels.
PMS has a centralized reservation system that accepts the reservations from the guest and confirms their reservations and same can be accessed by the front end executive to check in the guest and can be used to post the other bills like Food charges to the room, bar charge and other miscellanies charges.
Configuration modules allows the Hotel management team to configure their property such a way that they can create their own rooms, packages, services and other rates. Opera allows the front desk to create Rates for different types of rooms, packages for the guests and customized packages.
EOD report allows the night audit process and generates revenue report of the particular hotel. EOD is also called Night audit report where the Auditor knows the no.of rooms filled and vacant on the particular day and roll out the business day to next day.
Roles & Responsibilities
Individual Contributor from Automation team and closely working with the functional team to get the application knowledge.
Design QMS, test strategy and plan for the Opera5 and Opera9 applications
Created the Automation feasibility analysis on the application and designed the Automation framework for the application
Identified the Regressions suite and provided the Automation effort estimation
Designed the reusable components with Opens script and business and generic function libraries
Created customized classes to store object properties instead of using the tool given object repository
Used external JAR files to read/write test data and it minimized the script development time
Designed and developed customized methods and functions for Result reporting, Interfaces for Child Scripts and Exception handling mechanism
Closely working with the client on Framework architecture and got approval from the client
Project # 3
ERP Order Management Automation
Aug-2011 to Dec-2013
Client
Cisco Systems
Organization
Accenture Services Pvt Ltd
Technologies
OATS, ERP 11i, R12, Oracle 10g, Windows
Environment
Web Applications, ERP Suite, Citrix
Tools
OATS 9.3, JIRA, SVN and RDP
Team size
5
Role : Automation Lead
Description
Quoting and Ordering is one of the Most Revenue created Application of Cisco Systems, Inc. Q&O deals with the creation of Estimates, Quotes and Orders. Q&O application is used across the Globe by CISCO users to create quotes and orders.
Once the Estimate or Quote is create with some products and eligible service levels and sites, Quote net amount will generate depending up on the Sites and Service levels selected. Once the Quote net amount is generated user can proceed with ordering of the quote. After Quote conversion process is completed then Quote will convert to Contract
Roles & Responsibilities
Attend Technical meetings & discussions.
Maintaining valid documentation. Designed complete Frame work and Design documents.
Handled most of the critical functionalities with Function libraries in OATS 9.3
Covered End2End functionality of the application first time in CISCO-CCW Project through Automated scripts
Proposed Business Oriented-Data driven approach to implement the E2E scenarios in ERP R12 O2C flow
Developed OATS scripts, Business and generic function libraries with error and exception handling
Used most of the Pre-Defined functions and User defined functions based on the Business requirement
Reduced the lines of code by using Business and Generic Functions
Project #2
Oracle Insurance Policy Administration (OIPA)
Feb 2010 to Jul-2011
Client
ORACLE CORPORATION
Organization
Oracle India Pvt Ltd
Technologies
Java, Java Script, HTML Reporting
Environment
Web Applications and Desktop Applications
Tools
Selenium-WebDriver, Cucumber, JIRA, SVN
Team size
1
Role: Sr. Auto Engineer
Description
Oracle Insurance Policy Administration, simply OIPA deals with the customer insurance policy details. The application contains majorly two modules. 1. Guaranteed Level Premium Term Policy (GLPT) and 2. Variable Differed annuity (VDA). GLPT is a policy that provides a policy benefits if the insured dies during a specific period of time. VDA is a contract under which an insurer promises to make a series of periodic payments to a names individual in exchange of premium or a series of premiums.
The application has around 600 regression test scripts and 500 are already developed by some third party team. As we entered, we have taken the completed project in and started executions for every release. I contributed myself to the project and improved advanced concepts and reduced the execution time of the scripts by 30% than previous execution and got appreciation for this.
Roles & Responsibilities
•Maintained in the Weekly regression execution of 600 test scripts independently
•Had R&D on the existing Modular frame work and reduced the Execution time by 30% than earlier execution cycle by introducing Dynamic wait time and loading the script settings and libraries dynamically
•Implemented dynamic object handling functions with Java Script to reduce the static wait time in the frame work
•Developed major reusable functions to reduce the manual effort
•Created JUnit Tests and executed on a daily basic
•Execution and Review of the scripts for every release
•Defect reporting to the Development team and handled the Defect status meetings weekly
•Conducted the automation training session to the internal manual testing team
•Handling one application independently
Project #1
Quoting & Ordering(Q&O)
Jun 2007- Jan 2010
Client
Cisco Systems, Inc.
Organization
Satyam Computers Pvt Ltd(Tech Mahindra)
Technologies
Automation Testing, Functional Testing, Oracle Applications 11i and R12
Environment
Windows, Web Applications and ERP Suite
Tools
QTP 9.2, QC 9.2, SQL, Citrix, SVN, JIRA
Team size
4
Role : Test Engineer
Description
Quoting and Ordering is one of the Most Revenue created Application of Cisco Systems, Inc. Q&O deals with the creation of Estimates, Quotes and Orders. Q&O application is used across the Globe by CISCO users to create quotes and orders.
Once the Estimate or Quote is create with some products and eligible service levels and sites, Quote net amount will generate depending up on the Sites and Service levels selected. Once the Quote net amount is generated user can proceed with ordering of the quote. After Quote conversion process is completed then Quote will convert to Contract.
Roles & Responsibilities
Attend Technical meetings & discussions.
•Design and Execute Functional/Regression Test cases
•Defect reporting and Defect triage calls with the DEV teams to resolve the issues
•Identify the Regression cases for Automation and complete feasibility analysis
•Develop Test scripts using the existing framework with QTP
•Test script execution in QC, result analysis and defect reporting
•Test script maintenance and upgrading the old test scripts to the new version of the QTP up on upgrades over the years
•Developed scripts and created reusable generic functions that can be used across the org
•Test script debugging and fixing the script issues and code integration issues