Oracle Accounts Payable

Raja Shekar Reddy

Ph No: 727-***-****

Senior Oracle Applications Financials

Functional Consultant

Summary of Qualifications:

. Possesses a Master degree in Business Administration (MBA), holds a

Bachelor's degree in Finance, Certified as a Six Sigma Green Belt

candidate, Certified in Oracle 9i, seven plus years of experience in End-

to-End Implementation, Customization and Production Support of Oracle E-

business Suite Financial Modules which include General Ledger (GL),

Accounts Payable (AP), Accounts Receivable (AR), Cash Management (CE),

Fixed Assets (FA), Purchase Order (PO), Internet Procurement (I-Proc),

Internet Expenses (I-Exp), and System Administration.

. Extensive work experience on the Full Life Cycle Implementation of

Procure to Pay cycle (P2P)

. Hands on experience with Oracle R12 and Oracle 11i Implementation.

. Experience in using Oracle AIM (V.3.0) of project implementation

methodologies particularly Gather Business Requirements (BR.100),

Functional Documents (MD.50) deliverables and Test Cases (TE.40) for GL,

AP and AR modules.

. Experience in System Administration activities like creation and

maintenance of users, creating responsibilities, etc.

. Provided consulting services delivering comprehensive set of value-added

services for developing and implementing Oracle E-Business Applications.

. Proficient in functional aspects of Oracle Modules General Ledger (GL),

Accounts Payables (AP), Accounts Receivables (AR), Cash Management (CE),

Purchase Order (PO), Sys Admin, iExpense and iProcurement.

. Experience in all phases of Full Life-Cycle Oracle E-Business Suite

Financials implementation i.e. Requirements Definition, GAP Analysis,

Process Modeling and implementation.

. Exposure in Oracle R12 Financial Modules and SLA, MOAC, EB TAX.

. Experienced in implementing Multiple Sob's / Ledgers, Multiple Reporting

Currencies and Multi Org setups.

. Proficient in implementing Multi Organizational Setups in Accounts

Payable (AP).

. Participated with Business / Functional users in set-ups.

. Understand the Oracle Applications base Tables, Views and Workflows for

the Troubleshooting and resolution of Production issues.

. Strong Analytical, Diagnostic and Troubleshooting skills and ability to

work in a fast-paced and team-oriented environment

. Proven Team Leadership and Project Management Experience

. Experience on importing data from Sub-Ledger Modules( AR, AP)

. Worked on Customization and Development Reports under Oracle Apps.

. Collaborated closely with customer teams to accelerate the speed of

knowledge transfer and drive the highest value from the successful

deployment of the Oracle E-Business Suite.

. Implemented Six Sigma Project involved in Defining and gathering

requirements (DMAIC - Define, Measure, Analyst, Improve, Control), Root-

Cause Analysis, Delphi Techniques, Lean Management and Calculating Sigma

level.

. Solid understanding of R12 Oracle Functionalities and Integration.

. Personal Strengths include excellent Communication and Presentation

skills.

Technical Skills:

ERP and Applications Oracle Applications 11i and R12 (GL, AP, AR, FA,

PO, Cash Management, iExpense, iProcurement)

Operating Systems UNIX, Windows NT / Windows 2000 / Windows XP /

VISTA

Development Tools / UNIX, Windows, SQL and Knowledge on HTML.

Languages

Other Software MS-Office, MS Excel, MS-PowerPoint, MS-Project,

Visio

Packages Oracle E-Business Suite Applications 11i (11.5.9

and 11.5.10) and R12 (12.1.1 and 12.1.2)

Reporting Tool Application Desktop Integrator (ADI), Financial

Statement Generator (FSG).

Methodology Oracle E-Business Suite Application Implementation

Methodology (AIM) V.3.0

Educations:

Master of Business Administration (MBA)

Bachelors of Commerce (Finance)

Certifications

Certified in Six Sigma Green Belt (DMAIC - Define, Measure, Analyst,

Improve, Control)

Certified in Oracle 9i.

Career Experience:

Bare Escentuals, San Francisco, California January 2010 - September 2010

Oracle Functional (Consultant)

Bare Escentuals Inc. (NYSE: BARE) is a San Francisco based natural health

and beauty company that develop and sells its own line of cosmetics (i.d.

Bare Minerals, Rare Minerals, and Bare Escentuals brands). The Oracle

Modules worked on are General Ledger (GL), Accounts Payable (AP), Accounts

Receivable (AR), iExpenses, Cash Management and EB Tax.

. Participated in global implementation for countries United States, Japan,

Canada, United Kingdom, France and China.

. Prepared AIM documentations that include BR100, TE 040 (Test case

Document) and process flow documents for financial modules.

. Participated in planning and delivering GL module which includes defining

Ledgers, BSV's, calendar, defining security rules, account aliases and

used ADI (General Ledger Desktop Integrator) to integrate the GL module

to the excel sheet) in Oracle E-Business Suite.

. Defined Ledgers for Global implementation.

. Defined various Receivables and Payables lookups to meet the detail level

of reporting.

. Defined Profile Class, Dunning letters, Collectors, Customers, Auto

Accounting, Transaction Types, Transaction Sources, Payment methods,

Receipt classes, Receipt sources, Payment Terms, Receivable Activities in

Receivables.

. Defined Payment Options, Payment terms, Distribution Set, Payment Format,

Prepayments, Expense Report Templates, Interest on Invoice report,

Matching options, Adjustment of Prepayments in Payables.

. Defined payment terms and set up the discount policy for early payments.

. Set up transaction types, invoices, guarantees, deposit, and credit

memos, debit memos.

. Defined banks, branches, bank account and payment documents for check,

and wire and EFT payment methods for supplier's payment disbursement.

. Monitored AP setups, especially supplier's setup, invoice matching,

payment setups and recurring invoicing setup.

. Participated in maintaining Bank account signing authorities, managing

Bank account statements in Cash Management.

. Set up Attachments to enable the user to add their attachment in

iProcurement requisition or order at the time of checking out their

shopping cart.

. Managed accounts payable department which included operations and

merchandise procurement payables.

. Participated in creating invoices.

. Participated in setting up of Banks, Bank Branches and Bank Account

details in Cash Management.

. Defined Journal line types, Mapping sets and Account Derivation Rules in

SLA.

. Setup Cash Management including bank account security.

. Setting up of Auto invoice Interfaces between AR, Billing System and

Taxgen and interfacing bank files with Cash Management for automatic Bank

Reconciliation, Interfacing Great Plains with Accounts Payable.

. Configured the setup for raising Batch invoices and Batch payments.

. Configured the setups for prepayments and adjustment to payment to

suppliers

. Configured the setups for prepayment to employees and defined employee

expense reports.

. Participated in Auto Reconciliation setups in Cash Management.

. Participated in setting SLA for account transformation from AP, AR to GL.

. Created custom responsibilities to which were attached specific menus,

forms and reports for restricted user access.

. Experience in creating Flex fields, Lookups, Profiles, Value sets,

Packages, Procedures, Functions, and List of Values.

Environment: Oracle Application R12.1.2 (GL, AP, AR) and I-Expenses.

Fidelity Investments, St. Petersburg, Florida March 2008 - November

2009

Functional Lead (Consultant)

Fidelity is a large company with more than 40 diverse business units. It

has grown to become a leading provider of a wide range of services,

including investment management, retirement planning, brokerage, and human

resources and benefits outsourcing services. The Oracle modules worked on

are Accounts Payable and Accounts Receivable (AR) and iExpense.

. Study of the current Business Process and GAP Analysis using AIM

documents,

. Preparation of BR100, Common Set-ups doc, Sys Admin Set-ups documents,

Involved in the production support of AP and AR modules and worked

closely with end users in resolving their issues.

. Set up suppliers, supplier sites and payable options in E-Business Suite.

. Set up internal banks, external banks in AP. Defined period types,

calendars, Distribution sets, Tolerances, bank accounts payables

documents, payment terms, approval groups and approval assignments.

. Participated in customization and personalization of iExpense pages.

. Participated in GL setups of Org Structure, Rollup groups and parent

child accounts, cross validation rules and Value sets.

. Setup Receipt Classes, Receipts Sources and Payment Methods.

. Defined Quick codes for Employees and Purchasing.

. Defined Financial Options and Payable Options.

. Participated in setting up of tax users and profile option values in EB

Tax.

. Prepared customer profile classes and customers, statement cycles,

dunning letter sets, receipt classes, receipt sources, payment methods.

. System Administrator skills - user creation, defining responsibilities,

profile options and securities.

. Defined roll up groups to provide the customize reports to the top

management with drill down features in ADI.

. Coordinated and monitored Month End Closing process.

. Generated various reports like GL report, Journal report.

. Changed the submission instructions on the iExpense page.

. Established control over data access with creation of Menus and

Responsibilities and by setting up flex field security rules.

. Participated in creating Expense Report Templates.

Environment: Oracle Application 11.5.10.2 and R12.1.1 (AP, GL and AR)

AECOM, Los Angeles, California April 2007 - January 2008

Oracle Financials (Consultant)

AECOM is a global leader in providing fully integrated professional

technical and management support services for a broad range of markets from

transportation, energy and water systems and constructions. The Oracle

modules worked on are General Ledger, Accounts Payable, Accounts

Receivable, iExpenses and Cash Management.

. Worked with a team to implement the Oracle financial modules for US and

international operations

. Worked with the functional department to design and implement new

business processes around requirements.

. Participated in providing Procure-to-Pay (P2P) life cycle support.

. Setup and Configured GL, AR, AP, FA, PO, CM, ADI, version R12.

. Enhancements to Internet Expenses functionality.

. Implemented Oracle Cash Management for bank reconciliation

. Set up new account combinations and cost centers in the Oracle

application.

. Developed the new chart of accounts.

. Performed hands on configuration setups for GL and AP, including budgets,

multi-org & multi reporting currency.

. Participated in setting up of MOAC for managing multi-org setups.

. Participated in Setting up Asset Key Flex fields, Asset Categories, Asset

Locations, and Asset Calendar.

. Defined Sub Ledger Accounting Methods.

. Responsible for full cycle accounts payable; review of internal travel

and expense reports.

. Defined currency translation, conversion, revaluation and set the profile

options for GL.

. Defined GL budgets and budget organization.

. Defined the approval limit for new employees.

. Setting up of suppliers and supplier sites by defining payment terms,

distribution sets and tolerances.

. Setting up of Canadian Goods and Services Tax (GST) in EB TAX.

. Developed the customer invoice, statements and dunning letters.

. Maintained cash and bank records, bank deposits and reconciliation.

. Setup Multi Org Structure including new Ledger setups based on 2 Legal

Entities, and 2 Operating units.

. Setting up FSG reports and custom views.

. Participated in interacting with all concerned end users to achieve

proper guidance to design customized forms, reports and to perform

interfacing.

Environment: Oracle Application R12 Multi Org Set up (AP and AR), GL, FA

Lucent Technologies, Allentown, Pennsylvania May 2006 - April 2007

Oracle Financials Functional (Consultant)

Lucent Technologies designs and delivers networks for the world's largest

communications service providers. Backed by Bell Labs research and

development, Lucent relies on its strengths in mobility, optical, data and

voice networking technologies. The Oracle modules worked on are General

Ledger, Cash Management Accounts Payable, Receivables, iProcurement and PO.

. Implemented Oracle Applications 11.5.9.

. Handled Global Implementation of Oracle ERP (11i) for Optical Fiber

Optics Division of Lucent Technologies.

. Project with Lucent Technologies Incorporated, Implementing Partners were

IBM and Oracle Corporation.

. Directly responsible for the configuration of Purchasing, Accounts

Payables, i-Procurement, Inventory and worked with the other team members

on the integration of Project Accounting, General Ledger and Account

Receivables modules.

. Define Information Templates in iProcurement to pass necessary order

processing information to suppliers.

. Implemented set of books (Chart of Accounts, Calendars and Currencies)

in GL

. Defined Financials options, Payables Options and Payables System Setups

to set control options and defaults values.

. Defined Accounting periods and Journal postings.

. Defined payment terms, tax code, aging periods, reporting tax entity,

invoice hold and release names

. Defined various Purchasing and Payables lookups to meet the detail level

of reporting.

. Setting up of auto Bank Reconciliation process via CM (Cash Management)

Module which provides for Automatic Generation of Reconciliation

Accounting Entries, Automatic Recording of bank initiated activities,

Automatic Reversal of rejected receipts, and the ability to clear

payments and receipts.

. Created organization structure, Sobs, GRE/Legal Entity, Operating Unit &

Inventory Organization

. Participated in importing data to GL module through Journal Wizard.

. Experienced within Oracle Payables (AP), General Ledger (GL), and Oracle

Receivables (AR).

Environment: Oracle Apps 11.5.9 (AP, AR and GL)

NTPC Electric supply Company Ltd, India January 2006 - May 2006

Oracle Functional (Consultant)

. Worked with the client team in understanding the business process and

assisted the team lead in preparing the Business Requirement definition

document.

. Performed on-site Requirement Analysis and developed functional

specifications for the modules and customized processes.

. Participated in planning and set-up of accounting flex field structure

and chart of accounts.

. Defined Invoicing information including Payment Terms, Invoicing and

accounting rules, Territories and Invoice Sources

. Developed cross-validation rules to restrict and determine departmental

use of accounts.

. Defined suppliers, supplier banks, financial options, payment options,

payment terms, and bank accounts.

. Defined distribution sets, expense report templates, and locations.

Environment: Oracle Apps 11i (AP and GL)

System Tech, Bangalore, India June 2004 - December 2005

Oracle Functional (Consultant)

. Worked with the client team in understanding the Business Process to

prepare the Business Requirement definition document (AIM).

. Created the General Accounting functionality by setting up Chart of

Accounts and Fiscal Calendars

. Defined the Multiple Set of Books, Accounting Periods, and Journal

Sources.

. Defined payment terms, Distribution sets, Tolerances and Expense

Templates.

. Defined recurring invoice templates. Set up employee expense templates

and distribution sets.

. Defined value sets, key Flex field segments and roll-up groups with

security and cross validation rules and Used ADI (General Ledger Desktop

Integrator) to integrate the GL module to the Excel spreadsheet.

. Activated some descriptive flex fields to capture additional information

for the client not available in standard Oracle forms, set up Suppliers

and Banks for AP use

. Created Users and Responsibilities in System Administration.

Environment: Oracle Apps 11i AP, AR and GL.

Contact this candidate