Oracle Test Cases

Deepa Deshmukh

Atlanta, Georgia

Telephone: +1-704-***-****

E-mail: *********@*****.***

OBJECTIVE

To deliver solid Oracle ERP Application solutions using Functional/Business analysis expertise, coaching and mentoring as Oracle Functional Consultant/Oracle Business Analyst. This includes OM, Inventory, PO, Shipping, O2C, P2P, SCM, AP, AR, OPM, Quality, Testing, Mapping, Design, Documentation, Analysis, Enhancements, and RICEW components, as required, for Commercial / Federal applications.

SUMMARY:

Over 9+ years of experience in Oracle E Business Modules, Inventory, Purchasing, Shipping, Order Management, Oracle Process Manufacturing environment, Istore, Iprocurement, Advanced Pricing, Account Payables, Service Contracts, Fixed Assets, Accounts Receivables, General Ledger, Bill of Materials, Work in process, Retail.

Functional experience in Order to Cash, Purchasing Domain (P2P). Supply chain. Handled Process and Discrete manufacturing.

Extensive experience with Order to Cash and Procure to Pay, SCM, OPM Business flows.

Good working knowledge in Oracle AIM Methodology and documentation skills.

Handled Service Requests (SRs) with Oracle. Knowledge on Oracle Accelerator and Oracle R12.

Expertise in Implementation where was involved in Module selection, Requirement gathering, Gap Analysis, Mapping, Solution Design, Building, Testing, Documentation, User Training and Production support, user support ticketing tiers/level.

Proficient in Creating User Requirement Specification, Functional Requirement Specification, testing and Business Process Flows.

Good knowledge in developing and writing Test Plans, Test Cases and Test Scripts using manual testing tool HP Quality Center to perform User Acceptance Testing (UAT).

Involved on several Upgrade Projects.

Enhancement and Support, which involved giving Production support by interacting with user for, trouble tickets and establishing the process to be followed.

Extensive experience in conducting training sessions for users to give them knowledge about how the system works.

Highly motivated with excellent interpersonal and communication skills.

Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user accepting testing, production support, documentation and completion.

Significant experience in performing day-to-day maintenance and support of existing Oracle ERP applications in parallel with the analysis, design, development and co-ordination activities for new applications(Multitasking).

An enthusiastic and project-oriented team player with warm personality.

Excellent communication skills with leadership qualities & open to innovative ideas to develop a creative solution for challenging client needs.

Strong aptitude to learn and acquire new skill and Self Confident and ability to work independently as well as in a group.

Collaborate well with project management, business analysts and department management teams.

Ability to build and maintain strong working relationships with cross-functional business groups, as well as technical specialists.

TECHNICAL SKILLS:

Oracle Applications Modules: GL, AP, AR, FA, Inventory, Project, I-procurement, I-supplier, Purchasing and Order Management

Oracle Application Releases: 11.5.10.2 and R12

Languages: SQL, PL/SQL.

Databases: Oracle 11g/9i/8i/8/7.x, MS Access, MS SQL Server

Oracle Tools: SQL*PLUS, SQL*Loader, SQL Developer, Discoverer, Toad.

Version Control Tools: PVCS.

Instance Migration Tools: Kintana

Other Tools: SQL Navigator, Toad, Data Loader

Methodologies: Oracle Applications Implementation Methodology (AIM).

Productivity Applications: MS Office, MS Visio and MS Project.

EDUCATION:

Masters of Engineering in Electrical, Texas A&M University, Kingsville, 2006.

Bachelor of Engineering in Electronics & Communication, Mumbai University, Mumbai, India, 2003.

PROFESSIONAL EXPERIENCE:

Compunnel June 2016-Present

Business Analyst

Cox Automotive, Atlanta-GA

Cox Automotive leader in Vehicle remarketing services and digital marketing and software solutions for automotive dealers and consumer.

Responsibilities

Perform Application Support for ERP enabled Businesses within agreed SLAs. This involves investigating PI and P2 tickets for floor planning and settlement areas.

Prepared gap analysis and functional design documents for iExpense and Account Payable

Prepared functional analysis for iExpense report

Aware of O2C and P2P cycle. Fixed issue regarding this cycle.

Monitored B2B processes on weekly basis.

Responsible for fixing all the AR Auto invoice errors.

Work closely with internal/external customers to resolve billing issues/disputes with excellent customer service.

Oracle was integrated with Salesforce and AS400, so fair understanding of both the systems.

Troubleshooting and fixing the issues in Order management application -Tax code, Customer credit check, Backordering, Return Material Authorization Issues Provide guidance and support the users in their efforts to become proficient in the use of the applications.

Responsible for applying business and functional knowledge to meet the teams overall design and test objectives.

Created training material for users on the use of the business applications.

Training other Junior Consultants on various modules and functional setups in Oracle ERP.

Partner with various accounting divisions for analysis and any re-class entries for AR transactions to ensure accuracy of Cox Automotive/ Manheim financial records

Partner with NextGear for all Manheim inter-company adjustments via Oracle AR.

Responsible for unwinding Floorplan transactions, when vehicles settled via floorplan in error for all Manheim Auto Auctions

Analysis of outstanding Accounts Receivable, weekly/ monthly trend reporting to leadership.

Analysis of manual processes/ procedures to identify key technology/ process enhancements for Gavel2Gate project team.

Environment: Oracle Apps EBS Order Management, Accounts receivables, Purchasing modules version 12.1.3.

TCS July 2015-May 2016

Business Analyst

Zebra, Chicago, IL

A global leader respected for innovation and reliability, Zebra offers technologies that give a virtual voice to an organization's assets, people and transactions, enabling organizations to unlock greater business value.

The company's extensive portfolio of marking and printing technologies, including RFID and real-time location solutions, illuminates mission-critical information to help customers take smarter business actions.

Responsibilities:

Zebra technologies acquired Motorola in 2014 with an agreement stating we need to convert all the components from Motorola environment (Trilogy) to Zebra environment (Merlin).

Conducted meeting with stakeholders to understand the AS-IS process.

Recommended the TO-BE process along with the solution.

Analyze Functional requirements for Multi Org, Purchasing, iProcurement and AME.

Confirm functional level modular configurations and setups and documenting in BR100.

Created MD50s for Decommissioning project of Motorola.

Recommended APIs to cancel Purchase orders, Sales orders, requisitions.

Develop business process flows, data maps, and project plans related to Oracle EBS projects.

Designed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management.

Experience in full lifecycle implementations of Oracle EBS applications and SDLC in general.

Good documentation skills (gathering business requirements, writing functional and technical design documents).

Key Liaison between Business and IT for successful delivery of projects and accountable for operational support.

Provides input to business leader ship team on prioritization within the IT portfolio.

Cross functional view of functional initiatives.

Manage projects with varying degrees of complexity, provide production support to the business users and system processes, and ensure high level of IT service.

Recommended manual methods to delete the sourcing rules attached to the sourcing assignment and Internal Requisition.

Coordinating with offshore development team in API development-Unit test

Created test scenarios, test plan and test cases.

Environment: Oracle Apps EBS Order Management, Purchasing, iProcurement, Account Payables, Project and Cash Management modules version 12.1.3.

TCS March 2014 –June 2015

Business Analyst

Ingersoll-Rand Inc, Charlotte NC

Ingersoll-Rand Inc. is an Irish global diversified industrial company founded in 1871.

The company's list of brands and subsidiaries include:

Brand for air compressors, tools, material handling devices and more. Ingersoll Rand Security Technologies – architectural hardware brands including Briton, Legge, Kryptonite locks, Normbau and Randi

Club Car – golf cars and utility vehicles.

Trane – HVAC equipment.

Thermo King – transport refrigeration units.

Schlage - commercial and residential locksets, door handles, hardware.

GHH RAND – oil free and contact cooled screw compressors and compressed air solutions.

American Standard – HVAC equipment.

Responsibilities:

Review business process and determine the requirement. Examine those requirements and determine the Oracle prerequisites.

Map requirement to Oracle Application and determine the gaps.

Prepare AS IS and TO BE process documents.

Train users on how to use Oracle Applications.

Perform all the Organization setups for OPM Inventory.

Designed interfaces for Bank Reconciliation and Positive Pay transactions through Oracle Cash Management.

Worked on creating the data load in all the instance including production for Item Category, On hand inventory and BPA for Tyler, Vidalia, Trenton and Forth Smith.

Live Production support for PO and Inventory.

Moved the code through PPM to higher instance.

Developed an inbound interface (loading data into staging table) and outbound interface (Truck load details are sent to third party system which stores the inventory for IR) using XML data along with Mapping of fields between Oracle and NASS (third party system).

Developed inbound interface for asset migration.

Acted liaison between IT implementation team and Business Super Users.

Involved in the punch out process functionality of iProcurement.

Creation of Queries to Data extraction.

Documentation – Preparation of MD50, testing and filling up the unit test plan for the above interfaces.

Worked on resolving the rejected and on hold invoices in Accounts payables.

Create a clear plan for multiple phases if system integration testing so that all the P2P and O2C flows are tested end to end.

Creation of test scripts, test cases and unit testing of the interface.

Postproduction support for the above interfaces and resolved issues related to them.

Conducted CRP and UAT sessions with business users.

Conducted kick off/CRP

Integration testing with internal and external modules/applications.

Environment: Oracle Apps EBS Inventory, Purchasing, Fixed Asset, iProcurement, Cash Mnagement and Account Payables modules version 12.1.3. Data Base 11G, Serena Dimensions Version Control (PVCS), Kintana Migration Tool (PPM).

TCS July 2013 - February 2014

Business Analyst

Air Liquide Industrial Services, Houston, TX

Air Liquide USA LLC is a subsidiary of Air Liquide Group, the world leader in gases for industry, health and the environment. Air Liquide is present in 80 countries with 42,300 employees. Oxygen, nitrogen, hydrogen and rare gases have been at the core of Air Liquide’s activities since its creation in 1902. Using these molecules, Air Liquide continuously reinvents its business, anticipating the needs of current and future markets. The Group innovates to enable progress, to achieve dynamic growth and a consistent performance.

Responsibilities:

Implement new COA structure [as decided by Air Liquide] for their operations in Singapore, Taiwan, China and Malaysia. SCM (Purchasing, Inventory), finance (Account Payables, General Ledger), I-Procurement, Cash Management will be used.

Providing estimation for the different phases of SDLC cycle.

Requirement gathering and system analysis of Air Liquide system.

Capturing functional/technical details of Oracle Applications R12.1.1 ERP (Enterprise Resource Planning) and documenting the same.

Conversion of Master and Transaction data using Open Interfaces/ API. (Master Item conversions, Item category, Item On hand and AP Invoices).

Oracle Cash Management: Bank statement Loader Interface. Loading the BAI2 format into oracle. It is an inbound interface.

Identifying existing Customized Oracle Reports Components of Inventory (Material balance, Report Stock in stock out, Summary of material balance, Inventory transfer, Goods issued) and Account Payables and accordingly did the changes based on COA Impact (Chart of Account) in those Reports.

Preparing Migration Cut over Plans, integration test plan/test cases for Oracle applications.

Made required changes to the Reports as per the change in COA.

Documentation – Preparation of MD75, testing and filling up the unit test plan for the above-recommended issues.

Provide end-to-end customer support which includes issue identification, implementing the fix in test instance, unit testing, following up with users for UAT approvals.

Environment: Oracle Apps EBS GL, AP, Purchasing, IProcurement and Cash management modules version 12.1.3. Data Base 10G.

TCS June 2012 –July 2013

Business Analyst

Equifax, Atlanta, Georgia

Equifax Inc. is a consumer credit reporting agency in the United States, considered one of the three largest American credit agencies along with Experian and TransUnion. Equifax is the oldest of the three agencies and gathers/maintains Information on over 400 million credit holders worldwide.

Responsibilities:

Upgraded from 11i to R12.

Documented functional testing (Rifle shot testing) and tested it for all the modules (AP and AR) in each instance (CORP, UK, CMS).

Documented the high-level architecture diagram, which shows the integration of all the modules in CMS.

Documented the setup and patch changes for CMS.

Recognized all the application forms and reports, which were impacted due to extended patches in CMS, UK and CORP instance.

Document requirements and actively participate in design, configuration and testing of Oracle implementation and its integration with other projects while providing support to the existing Release 11i implementation and in the near future - Upgrade to R12.

Tested all the application forms and reports after the extended patches were applied in all the instance.

Tested the following interface in AP module: Equifax AP Invoice Interface

Tested the following Reports in AP module : EFX AP Spend Extract

Tested the following interface in AR module: Customer Extract

Tested the following interface in PO module: Equifax PO interface

Testing evidences were captured and saved, example: Output and Log file for each program was saved in all the iterations.

The performance benchmark provided by the client was matched to the performance of the program run in the upgraded instance and it was almost the same.

Traceability matrix was maintained which acts as single source of truth for all the components.

Issue tracker was maintained to capture the issues encountered during the testing and resolution was recorded against it.

Consolidated status report is send to the client every day before the daily call.

Preparing Migration Cut over Plans, integration test plan/test cases for Oracle applications.

Environment: Oracle Apps EBS AR, AP, PO in 11i (11.5.10.2) version, Oracle 9i, Oracle 11g, Oracle Report Builder (6i), Version Control (PVCS).

Xenosoft Technologies January 2010 - May 2012

Business Analyst

Cisco System Inc, San Jose

Cisco Systems, Inc. is an American multinational corporation headquartered in San Jose, California, that designs, manufactures, and sells networking equipment.

Responsibilities

Order Management

Involved in pilot study of project, provided the detail input for performance tuning /Load testing and created Deep Dive Reports.

Involved with the following Cisco Ordering tools: Change Order Tool, UnDispatch Tool, Notifications tools, Status Tool.

Conducting internal meetings, customer meetings and quarterly steering committee meetings for business users in products and front office.

Interacted with the application team to understand the whole functionality and gather the required details such as scope of the project, data load user load, databases impacted, upstream and downstream dependencies.

Completely responsible in determining if the project was assigned for Performance Tuning or Load testing.

Created an ATO (Assemble to Order) sample Order that gets successfully created, booked, pick released, Ship Confirmed and invoiced.

Assisted the development team to generate load of 5000 order lines after creating a sample order for both QTC/BV instance to see the performance of Replicate Cycle update program (running in SJ) as well as Cycle update program (running in QTC/BV).

Suggested the criticality of executing the concurrent program under the estimated SLA for maintaining the order statuses in sync between QTC/BV and SJ Prod.

Tracking communications and issue log and ensuring timely issue resolution.

Involved in back end testing writing SQL queries in TOAD against Oracle database to extract information about specific tables to know the order status and recommended changes to the PL/SQL code.

Involved in adding new descriptive flex fields in Order Entry to capture additional data.

Involved in a lot of stress testing to find out the performance of the Order Management as to whether it could handle load of 5000 orders within the SLA.

Well versed with the complete Cisco Order to Cash Process.

Designed and developed the Business plan, execution plan and test cases.

Designed and developed Use Cases for creating, booking, dispatching, pack out, pick release and ship confirm.

Accounts Payables (AP)

Enhancements to the EDI 820 process, which transfers the formatted output, file to the bank.

Involved in upgrade project of account payables to R12 for some of the banks. Incorporated the PPP (payment process profile) functionality.

Worked on Performance Tuning of SQL queries using EXPLAIN PLAN utility.

Environment: Oracle Apps EBS OM, AP, O2C in 11i (11.5.10.2) version, Data Base 9i.

Xenosoft Technologies February 2008 - December 2009

Business Analyst

Prudential Financials, Arizona

Prudential Financial, Inc. provide insurance, investment management, and other financial products and services to both retail and institutional customers throughout the United States and in over 30 other countries Responsibilities

Responsibilities:

Involved in all phases of SDLC (Planning, Design, Development, Testing, Production, Release, Support and Upgrade) for a couple of interfaces between SE system and Oracle system.

Prepared System Required Documents (SRD) based on Business required Documents (BRD).

Interacted with Business users as well as Functional Lead to understand the AS-IS process and suggested on the TO-BE process (Gap Analysis).

Documented the high-level business flow for integration between SE, Oracle and Biztalk.

Maintained end-to-end ownership of the product and process improvement, as well as fostering strong customer/business unit relationships.

Sat with the business in deciding the sequence of interfaces like Auto invoice, Credit Memo, Receipt’s, 1099S, GL interface.

Accounts Receivables (AR)

Performed various Data mapping exercise between SE columns and Oracle columns worked as a system analyst to identity the columns in SE (source system), mapped them to the Oracle columns for the Auto invoice standard program, and documented in Microsoft Visio.

Created PL/SQL packages to load the Invoices created in Service Engine (a Legacy System) to Oracle Accounts Receivables using the Auto Invoice Import Program.

Worked on Interfacing all the Credit Memos entered in Service Engine and applying them to the proper invoices in Oracle Receivables by creating PL/SQL packages and registered them as concurrent program.

Used Biztalk, PL/SQL procedures to facilitate data import to staging tables, interface tables and then to base tables.

General Ledger (GL)

Created SQL Server procedures to get the existing receipts in SE.

Developed 1099-S interface from SE to ETRS for each transferee file with Home sale service in which the property has been acquired during the tax year 2008.

Developed Logical and Physical data modelling using Microsoft Visio 2003 for the Proceeds and GL Journal Entry process.

Involved in creating a scripts in SQL Server database in Order to extract data of all the Invoices, customer, supplier information.

Involved with Integration Team and worked in loading the Legacy data into Oracle Staging Tables using BizTalk.

Coordinated with the QA team in preparing test scripts, test scenarios and conducted User Acceptance Testing (UAT) to confirm adherence to the formulated Business Requirements.

Set up the email option to receive emails when the concurrent program is run.

Used Mercury Quality Center to move the scripts to QA, STAG and PROD environment.

Maintained the application versions using PVCS.

Purchasing (PO)

Conducted meeting with business and functional teams to setup 2 ways, 3 way and 4 way invoice matching process.

Assisted the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and presented project related presentations.

Environment: Oracle Apps EBS Accounts Receivables, Purchasing, General Ledger in 11i (11.5.10.2) version, Data Base 9i, SQL Server 2005, Biz Talk, Service Engine, PVCS, Mercury Quality Center 9.0.

Xenosoft Technologies May 2007 - January 2008

Business Analyst

AT&T Wireless Alpharetta, GA

AT&T Mobility branded and referred to as AT&T, formerly Cingular Wireless LLC, is a wholly owned subsidiary of AT&T Inc. that provides wireless services to 109.4 million subscribers in the United States.

Responsibilities

Developed Control scripts and loaded existing data using SQL*Loader.

Worked on importing Legacy Journals into General Ledger using SQL*Loader, GL Interface and Journal Import.

Worked on fixing issues in Discoverer 6i relates to FA module and AP module - Sales tax variance report.

Proficient in creating Business Requirements and Functional Specification Documents (FSD) as per the SDLC process.

Worked with Desktop Edition of Oracle Discoverer6i. In Administration edition created various business areas, custom folders and joins for reporting. Also worked with user edition developing various financial analysis reports.

Environment: Oracle Apps EBS FA, AP, General Ledger in 11i (11.5.10.2) version, Data Base 9i, Discoverer 6i.

Contact this candidate