Oracle Analyst

BACKGROUND

Five plus years of experience in Information Technology as Financial Functional Consultant in Oracle applications. Role included the expertise in client interaction, functional setups of Oracle Financials Applications.

• Sr.Oracle Consultant for implementing financial modules Accounts Receivable, Accounts Payable, iReceivables,iExpenses, General Ledger and Cash Management

• Expertise in Requirement gathering, GAP analysis, design and development and Implementation of various business applications and support of the Oracle Financials AP, AR, GL, PO, CE, OM, iReceivables and iExpense.

• Expert in AS-IS Fit Gap analysis, CRP, UAT and Post-Implementation maintenance.

• Facilitated project meetings, identified issues, potential problems, and tracked action items.

• Strong Understanding of the Business processes, Procure to Pay (PP) and Order to Cash

• Prepared and delivered Technical / Design documents, User guides & Presentations.

• Leadership qualities, Time management and Team player with strong Interpersonal skills, excellent communication and presentation skills.

• Experience in AIM documents such as MD50, RD20, BR100 and TE40.

• Managed Projects for upgradation, support. Development and customization of Release 12 and Oracle Financials 11i in 11.5.10.2, 11.5.9.

EXPERIENCE

Client – 1800Flowers.com- Oracle Corporation

Long Island, NY (Sep’08 –Till Date)

Role: Sr.Oracle Analyst (Implementation of Release 12 - AR, AP, GL)

1-800-FLOWERS.COM Inc. – “Your Florist of Choice®” – has been providing customers around the world with the freshest flowers and finest selection of plants, gift baskets, gourmet foods, confections and plush stuffed animals perfect for every occasion.

• Defined conversion CV.040 and interface MD.050 specification for Trading Community Architecture (TCA) to define interface and conversion of Florists as suppliers in AP and customers in AR.

• Implemented Auto Lock box Functionality in AR for JP Morgan Chase.

• Implemented Outbound interfaces for AP for creating payment outbound file on (Positive Pay, Direct Deposit & Wire) for uploading into bank JP Morgan.

• Implemented Oracle tax software integration.

• Experience with the following features in Release 12

- Sub ledger Accounting

- Advance Global Intercompany

- Global Consolidation system

- E-Tax Engine

- Legal Entity Configrator

• Other AR setups included System Options, Receipts, and Bank.

• Gathering requirements for lockbox interface, designing the lockbox bank file format, setting up the functional setup for lockbox, designing the JP Morgan Chase interface validations for the lockbox load.

• Identified and setup GL legal entities using Legal Entity Configurator, Jurisdictions, Legal Authorities, Sequencing, Operating units, Ledger Books, Cross Validation Rules, and Accounting Setups.

• Document business specification for customization of Florist Statements in Detail and Summary format, create FSG specific business custom reports.

• Setup late fees and interest charges new functionality in Release 12 AR and Advance Collections.

• Documented RD20, BP080, BR100, TE20, TE40 and TE50 documents for all CEMLI”s.

Client – New York State Banking Department (NYSBD)

New York City, NY (Oct’07 to Aug’08)

(CGI Implementation)

Role: Finance Functional Consultant-(Public Sector Receivables and General ledger)

Department is the primary regulator for state-licensed and state-chartered financial Institutions, including domestic banks, foreign agencies, representative offices, savings institutions, trust companies, credit unions operating in NY State including mortgage bankers and brokers. Total assets regulated are nearly $1.3 trillion

Responsibilities: (AR and GL)

• Sr.Consultant for 11.5.10.2 implementation of AR and GL modules within the scope of RFP (Request for proposal).

• Conducted business meetings to study the “AS-IS” and “TO-BE” process flows through Microsoft Visio.

• Analyzed Inventory of requirements and prioritize Gap/Fit matrix with oracle applications. Mapping requirements with Oracle standard features.

• Prepared RD20, MD50, TE40 and BR100 setup documents for AR and GL.

• Design Chart of the Accounts, Calendar, Currency and Set of Books.

• Design MD 50 for Inbound and Outbound Interface document for AR Invoice Billing and Customers from BOSS and MBD systems.

• Prepare Change Request (CR) for revision of project proposal.

• Defined setup steps of the AR module. These included System Options, Receipts classes, Banks, Setup Customer Profile class, Remit to Address.

• Defined mappings for Auto lockbox for JP Morgan Chase ACH payment gateway.

• Defined Payment terms, Autoaccounting, Collectors and Auto Cash Rule Sets.

• Defined transaction types and Sources to interface Quarterly Invoices.

• Conduct CRP sessions. Successfully conduct UAT sessions.

• Set up Public Sector appropriations and Budgets and resolved issues/problems.

• Setup and configured web ADI to process opening GL balances after cut off period.

Client – Garmin International Inc

Olathe, KS USA (Jul’06 to Aug’07)

Role: Finance Functional Consultant-(AR, GL, iReceivables, CE, iExpenses)

Environment: 11.5.9 to 11.5.10.2 (Upgrade and production support)

Garmin International Inc. is a member of the Garmin Ltd. group of companies that

designs, manufactures, and markets navigation and communication equipment.

Responsibilities:

Accounts Receivable and Order Management

• Was involved in 11.5.9 to 11.5.10 upgradation. Was involved in overall coordination, interaction with Gamin’s global group in US, UK and Taiwan team management and responsible for finance modules functionality changes.

• Functional support on Credit Card gateway, credit card encryption (VeriSign), voice authorization processing using iPayment.

• Resolved issues relating to Customer credit check rules and credit card holds. .

• Creation to booking, fulfillment, shipment, Auto invoice, Autoinvoice exceptions, revenue recognition and GL transfer.

• Conducted the corporate training for GL, AP, AR and CE for new and changed features in 11.5.10

• Integration of AR with vertex to calculate sales tax.

• Project preparation/specification on Price protection plan to dealers.

• Gathering/modification of functional spec for tracking and shipment # on Invoices/Credit Memos.

iRecievables and iExpense

• Gathered business requirement for Credit Memo Approval, iRecievables Workflow Setup.

• Indexed the customer database to make customers available in iReceivables.

• Set up AMEX Credit Card load functionality, Audit Functionality, expense templates with perdium in iExpense.

• Defined Internal and external users.

• Setup external self-user and anonymous registration.

• Setup Euro Bank and iExpense module (perdium) for Garmin GE operating unit.

• Setup Payment Format and Distribution sets.

• Prepared end user manuals & guidelines for Monthly, Year-End finance closing activities.

General Ledger

• Reduced the month end closing cycle by several working days by using Oracle ADI and setting up Mass Allocations for several manual journal entries

• Setup legal entity, operating Unit, Inventory Org, Organization location, defined security rules, account combinations for Digital Cyclone Inc operating unit.

• Involved in the Design and Structure of the Accounts and GL Code combinations for Digital Cyclone operating unit.

• Consolidation of subsidiary SOB with parent SOB with currency translation.

• Troubleshoot using Oracle Diagnositcs.

Client – Concur Technologies

Redmond, WA USA (Apr’06 to Jun’06)

Role: Finance Functional Consultant-(iReceviables and Receivables)

Environment: 11.5.9 (Implementation)

With Concur Travel & Expense, travel booking and expense reporting come together to deliver One Touch Business Travel powered by Smart Expenses.

Responsibilities:

iReceivables and Receivables

• Was involved in implementation of iReceivables with integration to Receivables.

• Configure application and Functional Specs BR30, BR100 and TE40 for iReceivables.

• Gathered business requirement for Credit Memo Approval, iRecievables Workflow Setup.

• Indexed the customer database to make customers available in iReceivables.

• Updated the Receivables lookup codes based on business needs.

• Personalized the iReceivables homepage and defined bank for new payment methods.

• Granted external customers with function security for respective bill-to sites.

• Setup collectors, approval limits, discounts and service charges.

• Setup the dispute and pay invoice options.

Client – BMC Software

Houston, TX (Jan’06 to Mar’06)

Role: Functional Consultant-(AP, GL, PO, iExpense)

Responsibilities:

Accounts Payable

• Worked with the client team in understanding the Business Process to prepare the Business Requirement definition document.

• Mapped the Future Process Requirement into Oracle AP module

• The purchase orders that get matched are updated in the system.

• Transferring the payables to GL.

• Set up Suppliers and Banks for AP use.

• Defined payment terms and recurring invoice templates. Set up employee expense templates and distribution sets.

• Defined distribution sets, expense reports templates, Locations. Defined financial options, Payables options and Payment programs

• Prepared some AIM documents for the Accounts Payable Module including: BR.020- Business Requirement Mapping Document, BR.100- Setup Document.

General Ledger

• Set up fiscal years, and calendars.

• Defined the Functional Setups for the Global Consolidation process including the Parent SOB, Revaluation, Translation and Consolidation Workbench.

• Enabled the Accounting Key Flexfield and designed the chart of Accounts.

• Set up accounting period types and accounting calendars. Designed Set of Books. Choose set of books.

• Used ADI (Application Desktop Integrator) to integrate the GL module to the Excel spreadsheet.

• Defined Recurring Journals and period end closing for AP sub ledger.

Accounts Payable and iExpense

• Month end Open/close balances.

• Creating suppliers, supplier’s sites and merging suppliers.

• Defined payment terms and recurring invoice templates.

• Conducted Business meeting and finalized setup steps required for the implementation of iExpenses such as Credit card loader programs, Ghost cards, Employee setup, Profile Options, Financial and payables Options, Currencies, signing limits.

• Conducted User training and prepared documentation of iExpenses setups and Implementation.

Client – ICICI Prudential Life Insurance

Bangalore, India (2005)

Role: Financial Service Consultant (AR)

Responsibilities:

• Designed and developed solution methodology (MD50 & MD70) for setting up parties by defining business/technical specifications in response to business objectives.

• Conducted User Training for OM and AR business Users.

• Conducted Business Owners meeting to finalize functional setups that are required for Accounts Receivables Module. Setups are such as Transaction Types (Invoice Types), Auto Accounting Setups, and Configured Invoice Types with Order types, AR Batch sources, Remit To addresses, Receipt Classes and Payment Methods. Prepared Test Scenario Document to conduct Unit Test and UAT (User Acceptance test) in AR Module.

EDUCATION

Master in Business Administration (MBA) Bangalore University (Financial Management and IT)

Contact this candidate