Resume

Sign in

Oracle Manager

Location:
Katy, TX
Posted:
March 12, 2018

Contact this candidate

Resume:

Contact Info: 1-901-***-**** Cell

Status: U.S. Citizen

Email: ac4r33@r.postjobfree.com

SUMMARY

Over 25 Years IT experience including 17 years in enterprise-wide Oracle Financials implementation.

Solid expertise in functional ERP solutions implementation using Oracle Financials. From 10.5.7 to Release 12.2 4

Oracle Cloud Fusion Financials 8 to 12.

Did 7 upgardes end-to-end out which 3 upgardes on version 12 of EBS

Followed all SLDC and SOX compliance and GAP analysis, Agile

TECHNICAL SKILLS

Databases: Oracle 10g, 11g

Languages: SQL,PL/SQL

ERP: Oracle Applications (Oracle Financials V 10.6 SC & V 10.7) & 11i, 11.5.10.2 to R12.2.4

Oracle Cloud Fusion Financials Release 8 to 12

SUMMARY

Over 22 Years IT experience including 15 years in enterprise-wide Oracle Applications design, development, systems analysis, defining system standards, implementation, and database administration. Used AIM, Agile and project management for handling most of projects.

Solid expertise in functional aspects of ERP solutions implementation using Oracle Financials From release 10.5.7 to 12.2.13

over 10 years Installation and configuration of Oracle tools and databases, export, import, stored procedures, packages, functions, triggers, auditing and tuning database for performance.

Oracle Cloud Fusion Financials Release 8 to 12 from 2012 onward to current

On all projects part of month end close on financial modules

Leads in most of Financial projects

PROFESSIONAL EXPERIENCE

Currently working remote on Oracle Financials Cloud and OTC and P2P implementation

CSX in Financials from June 2017 to Dec 2017 as Financial and OTC consultant

Rolling out on key modules of financials with localizations to different Operating units using 12.2.4 and Oracle Cloud Fusion Financials 12

Rimini Street EBS Financial Consultant & Manager Sept 2016 onwards to June 2017.

Three full lifecycle of EBS core Financials AND team lead for OTC AND P2P:

Modules :

General Ledger, Sub ledger Accounting, Accounts Receivables and Accounts Payables.

Setting up Channel revenue management .

On the above modules did end to end setups, requirements gathering, RICE, GAPS and post production support. Also on some clients providing production support.

Team player in implementation of Oracle Fixed Assets and Cash Management

Working with users and meeting deadlines and also managing team for production support. This was cross clients.

Oracle Cloud Fusion Financials Release 11 & 12. Modules and areas of worked

Financials Setup Screens

Financials Data Extract - Outbound Integration

Partner Transaction Tax Integrations with Oracle ERP Cloud

Advanced Collections

Collections Work Area

Case Folder

Expenses

Global Per Diem Policies

Payments

Payment Approval

Receivables

Recurring Billing

Tactics Client Incomm : April 2016 to Sept 2016 EBS Financial Consultant/Manager

Three full lifecycle Oracle Financials and roll outs, including: scope design, GAP analysis, requirements gathering,testing and work with users,planning

Worked as consultant for a company in business of gift card and processing AP/AR transactions through Trade management on multi currency multi sets of books. Implementation of R12.2 Financials modules like AR,AP,GL, Trade Management Channel Revenue.Management.. Responsible for RICE objects and MD50 post production support and new projects

Was part of team for implementation of :

Oracle Financials Fusion Cloud Release 11 :

Users,Enterprise Structures,Bank, Branches, and Bank Accounts,Tax,Ledgers and Implementing Bill Presentment (BP)

Uploading data on chart of accounts, ledger, legal entities and Business units in spreadsheets

Create Hierarchies, cross validation rules in spreadsheets

Conversions from various legacy systems

Production support in Cloud and EBS Financials

Stemco : Remote Project Sept 2015 to March 2016 EBS Financial Consultant and Manager

2 full lifecycle Oracle EBS implementations and roll outs, including: scope design, GAP analysis, requirements gathering,testing and work with users,planning

Requirements gathering from legacy system and creating most of BR100, MD50 and MD70 documentation on Oracle EBS-R12 AR,AP,GL and Trade Management Channel Revenue Management. 2 full life cycle on Production support and new projects lead.

2 Implementing iReceivables Trading Community Architecture

Implemented the following in Oracle Cloud Fusion Financials 11 and 12:

GL, Payables and Receivables Security, Implementation of Oracle Financials Cloud all aspects from setup to creating intercompany rules

Key Energy Houston, TX July 2012 – Sept 2015

Sr. Business Consultant and EBS Manager

Three full lifecycle Oracle Financials and roll outs, including: scope design, GAP analysis, requirements gathering, testing and work with users, planning, Used OUM (Oracle Unified Method),configuration, RICE objects, testing, deployment and post production support from legacy system to Release 12, One upgrade from 12.1.2 to 12.1.3

2 full lifecycle and 1 upgrade of Oracle Financials 12.1.2 to 12.1.3

Projects implemented and test plans written are:

Solid understanding of Oracle EBS Database/Table structure to enable effective data analysis, troubleshooting and report design

Experience with Oracle System Administration, Workflow, Data Loader, Data conversion and 3rd party system integration with Oracle EBS

Payables changing banks and CTX/Nacha setting up separate remittance advice and CTX to banks.

Creating and Applying AR receipts using API

Payables Vertex and on use tax and sales tax support in AR. Customization between EBS and Vertex.

Lockbox automation.

Working on issues from business users on the above modules.

Working on MFAR and change of journal rules for Receivables. Also SLA on payables

General Ledger support for users and setting of cross validation rules and balancing segment rules.

Presently working with EBTAX and Vertex O series for integration of use tax and sales tax. Creating lookup tables in vertex and have custom integration with EBTAX.

Payables attachments on invoices

Get applied project using AR interfaces

Oracle AR

setup for foreign currencies

Tax lines setups

Setting up invoice rules

Credit Memo setups

Account Assignment

Exchange Rates

Receipt setups and cross currency receipts

Rule application sets

Setting up Notes for Receivables

Auto Lockbox validation

On Oracle Payables have done end to end implementation from suppliers to invoicing and payments.

Oracle General Ledger :

Sub Ledger customization

Implementation for international branches including setup of legal entities, sets of books and other aspects of integration with US books

Customized on GL description and security rules

Oracle Fixed Assets:

FA Asset setups

Detail and Mass Additions

Oracle Cloud Fusion Financials Release 9 and 10:

Configuring Financial Reporting

External Data Integration

Enabling offerings,

Implementation of Enterprise structures GL, Cash Management, Tax, Expenses and Receivables

AGI-Shorewood, TN – Paper Company

Jan 2011 to July 2012

Sr. Business Consultant

Two full lifecycle Oracle Financials implementations and roll outs, including: scope design,

Planning, configuration, RICE objects, testing, deployment and post production support from legacy system to Release 12, One upgrade from 12.1.2 to 12.1.3

2full lifecycle and 1 upgrade of Oracle Financials 12.1.2 to 12.1.3

Used Aglie system of project management in various projects

Extensive use of sql and pl/sql for conversions, interfaces and other customizations

Conduct Requirements Gathering Perform functional and gap analysis and Develop and document functional design

Guiding Business Analysts and users in the Financial System

Currently working on the following modules: General Ledger, AR, AP. Backup support for FA.

Customization and production support for forms and reports in the above modules.

Month end closing in multiple sets of books, currencies and languages.

Direct updates to tables for resolving production issues.

Working on custom projects in GL and AP.

Used OUM on various stages of project from Inception to move to production and from Project Management to Operations Support usingMSProject2003

Oracle R12

Setup of customers, vendors, invoice types, invoicing rules, interfaces, pcard

Experience in designing custom components, data conversions, extensions, interfaces to 3rd party systems, workflows, integrations, patch applications, reports, etc (RICE components)

Sub Ledger accounting setups and reconciliation

Auto invoice and customer interfaces

Iexpenses upload and customization

Customization using Oracle forms release 10 on following :AR Invoice, receipts, customer, payables invoice entry and check payments.

Vertex Setups

"Default Tax Classification" checkbox checked on the transaction type

Tax rate codes as follows if these were not seeded by Vertex:

Tax exceptions are defined only in Vertex

Define "STATE", "COUNTY" and "CITY" tax rate codes manually before First Tax Rate Load

Loading the Vertex Rate File.

Define regime and taxes

Properly defined the service subscriptions

Tax calculation method of "Tax Regime Determination"

Party tax profile for your Legal Entity* that owns the operating units where you will use vertex for tax calculation as well as for each operating unit.

Fixed Assets:

FA Asset setups

Detail and Mass Additions

Linking Captial Projects to Assets

AR

setup for foreign currencies

Tax lines setups

Setting up invoice rules

Customer and invoice setups

Auto invoice and customer load by interface

Credit Memo setups

Account Assignment

Exchange Rates

Receipt setups and cross currency receipts

Rule application sets

Setting up Notes for Receivables

Auto Lockbox validation

Collections setup

General Ledger

Legal entity and set of books multiple with multiple currency

Sub Ledger Accounting reconciliation and setups

Periods accounting and budget

Setups for cross validation rules

Designed the COA and mapped Old COA to the New COA.

GL. Defined Row set, Column Sets and Reports Using FSG.

Defined the Set of Books, Currency and the Transaction Calendar in GL

Defined the Recurring journals, Journal sources and Journal Categories GL

Defined Budgets and Budget organizations.

Setup Matching tolerance and distribution sets AP.

Define Banks, bank Accounts, Banks transmissions details and Payment Terms.

Opened AP accounting period and Defined Withholding tax certificates and exceptions.

Cash Management:

Loaded bank statements for reconciliation

Developed custom reports

Helena Chemical Corporation Memphis, TN May 2003 – Dec 2010

Sr. Business Functional Consultant

2 full lifecycle Oracle Financials implementations and roll outs, including: scope design,

planning, configuration, RICE objects, testing, deployment and post production support from legacy system to Release 12 from 11i, One upgrade from 12.1.2 to 12.1.3

2full lifecycle from 11i to Release 12 and 1 upgrade of Oracle Financials 12.1.2 to 12.1.3:

Functional support for core financial modules and lead on new projects.

Worked in functional/ aspects of Oracle Internet Expenses and iReceivables

Worked on new projects in core financials and integration with other modules

Teradyne Inc.,Boston, MA February 2000 – May 2003

Sr. Oracle Consultant

Information Resources Inc., Waltham, MA November 1999-February 2000

Sr. Oracle Consultant

Managing a team of 10 developers

Trade Funds Management System

Oracle Applications Financials Version 10.7 and 11.0

Travelers Express, Minneapolis, MN March 1999-November 1999

Sr. Oracle Developer Consultant

Next Gen. Technologies Inc., Lakeland, FL February 1998-February 1999

ERP/Developer Consultant

Prison Call Record System:

Hotel Management System:

California Students Aid System:

Converted programs from Natural to PL/SQL.

Bennett Coleman & Co. LTD. India April 1997-February 1998

Assistant Manager IT

Financial-Accounting / Integrated Inventory Control:

Banking Operations and Management System:

Accounts Payable System:

Develop and design of custom Accounts payable system

Responsibility Accounting

Softscript Systems Ltd. India November 1996-April 1997

Software Consultant

Hospital Management System (Payroll)

The project includes all phases of software development life cycle. The system covers all aspects of Custom financials

Sadafco L.L.C UAE October 1994-October 1996

System Analyst

Royal Gulf, UAE April 1992-October 1994

System Analyst

Bhs/Mothercare Oman February 1990-April 1992

System Analyst

TrioChem Products Ltd., Bombay December 1988-January 1990

Accountant

EDUCATION

Bachelors Degree, Commerce University of Mumbai 1986

Diploma Computer Applications and Software Development University of Mumbai 1991

TRAINING

Oracle Financials V 10.7 SC

Modules: General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets & AOL



Contact this candidate