Oracle Financial Functional Consultant Resume
Columbus, OH
SUMMARY
- Around 10 years of experience as a consultant in Oracle ERP Implementations, upgrades and support mainly inGeneral Ledger, Human Resource Management System (HRMS) Procure to Pay (P2P), Order to cash (O2C), Account Payables, Account Receivables, Fixed Assets, Cash Management, Purchasing (PO), Inventory (INV) and Order Management (OM) and Advanced supply Chain Management (ASCP)modules. Well experienced in identifying Gaps & developing Custom components as per business requirements.
- Extensive experience in design, development, implementation, customization and production support of ERP system for advanced GL, ASCP, P2P, O2C, OM, CM, FA etc.
- Two full lifecycle Implementations R12 with GL, AP, AR, FA, CE, iProcurement, iReceivables, iExpenses, E - business tax and Sub ledger Accounting(SLA) .
- Solid understanding of integration of Oracle Applications modules,Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.
- Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
- Designed process flows for each functional area during the implementation, carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
- Expertise in AIM Methodology to enrich project management and documentation processes.
- Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay (P2P), Assets to GL, Inventory, Credit Card Transactions, GL Accounting processes.
- Proficient in designing and requirements for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.
- Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization, Reports.
- Collaboration with the Business users during the various stages of project lifecycle.
- Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system).
- Expertise in post implementation support, prepared training manuals and also trained end users.
- Well experienced with Application Tools TOAD, SQL Developer, Data loader, ADI & Web ADI.
- Good Technical Knowledge on SQL, PL/SQL, Forms and Reports using for Inbound, Outbound, Extensions and Reports.
- Strong project management skills which include balancing multiple priorities with aggressive time lines and budget initiatives.
- Ability to work in a team, worked effectively in a multi-cultural environment and good at learning and teaching others.
- Excellent process orientation with analytical thinking and problem solving skills.
- Ability to prioritize and execute tasks in a high-pressure environment.
- Interpersonal skills, self-motivation, and quick adaption to new applications and technologies.
TECHNICAL SKILLS
ERP: Oracle EBS R12, Oracle EBS 11i SLA, E- Business Tax, Alerts and Report Manage
Operating Systems: Windows 7, Vista, XP, Linux
Office Applications: MS Outlook, Visio, MS Office, MS Project
Database Tools: TOAD, SQL Loader, Data Loader
Languages: SQL, PL/SQL, C, XML.
PROFESSIONAL EXPERIENCE
Confidential, Columbus, OH
Oracle Financial Functional Consultant
Responsibilities:
- Implemented a Highly Automated Financial processing system using Oracle EBS.
- Configured Accounting Flexfield, Account Maintenance, CVR's, Calendars, Currencies, Journal Controls, Journal Approvals, Ledger and Legal Entity Setups, Secondary Ledgers, Data Access Sets, Document Sequences, GL Profile options and Transactions Processing.
- Configured Mass Allocations, AGIS Setups in GL to Process the Intercompany Transactions using Invocies.
- Multi Org set-up - Responsible for implementing the multi-org set up with multiple operating and inventory orgs.
- Implemented Revenue Recognition program to generate the revenue distribution records for invoices and credit memos using Invoicing and Accounting Rules.
- Configured Invoicing Rule: Bill In Advance for Software Services.
- Configured Invoice Lines Accounting Rule: Duration, Rule Start and End Date.
- Implemented Fixed Assets Management: physical upkeep, asset tracking and financial administration.
- Configured AP Financials, Payable System and Payables options, Vendors and Sites, Bank and Bank Account for Fund Disbursements.
- Automated the AP Payment Process by using the Electronic Fund Transfer (ACH) to reduce the load on Check Payment Process.
- Configured Approvals Management (AME) for AP Invoice Approval and Hold Notifications.
- Configured the Regime to Rate flow in EB-Tax to calculate the Tax for AP Invoices.
- Customized SLA (Sub-ledger Accounting) functionality in R12 to provide Multi-period Accounting for Deferred Expenses.
Oracle Financials Consultant
Responsibilities:
- Act as the IT subject matter expert for Spares Inventory accounting set up for Cisco acquisitions.
- Support Service Supply Chain Finance team to reconcile global spares inventory and reserves accounting balances.
- Partner with Services Operations and Transfer Pricing Tax teams to define new spares inventory accounting for new entities and design IT solutions.
- Calculate, analyze and provide recommendations relating to reserves, FX, and asset recovery analytics. Assisted Finance team to stabilize huge swings in reserve variances plaguing the Services organization for over four years.
- Perform fixed asset accounting ensuring accurate asset codes, depreciation method, etc.
- Monitored Standard Cost Update program in inventory organizations.
- Analyze spares inventory, reserves, revenue, COGS, and intercompany variances and provide recommendations.
- Creation of Functional Design Document, Technical Design Document
- Provide End User Training, Support to Finance, IT and Operations teams.
Confidential, Sunnyvale, CA
Oracle Functional Consultant
Responsibilities:
- Involved in implementation and testing ofOracle Applications FinancialR12 GL, AP,AR and CMmodules
- Involved in requirement gathering and analysis and design of the application.
- Worked with the client team to understand the current Business Process.
- Developed test plans and scripts and conducted testing for quality assurance.
- ConfiguredGL, AP modules in R12Environment.
- Principal lead for General Ledger Multi-org on an R12 implementation through initial
- Worked on requirements gathering, gap mappings, and various functionalities in General Ledger.
- Working on Payables and Cash Management setups and issues.
- Determined business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting.
- Worked on Setting Instances for new acquisitions.
- Working on post upgrade support and interacting with Business users on Issue resolutions.
- Working with the developers on developing conversions, interfaces, reports
- Prepared Module design (MD050) Documents for Customizations.
- Worked on Setting up and customizing dunning letter, statement cycle in Accounts Receivable module.
- DevelopedFSG Reports in GLlike (Income statement, Dept. Expenses, Inter Company Summary).
- Created custom responsibilities to which were attached specific menus, forms and reports for restricted user access.
- Created and maintained User Menu objects.
- Created responsibilities assigned to users and set profile option
Environment: Oracle Application R12, Oracle General Ledger, Oracle Payables, Oracle Receivables, Cash Management and Fixed Assets.
Confidential, San Antonio, TX
ERP Functional Consultant
Responsibilities:
- Interacted with the Business users for understanding the Requirements and subsequently developed the functional design to meet the client requirement.
- Responsible for gathering Business Requirements (RD 020), Identifying Gaps & Fit Gap analysis (BR 010).
- Designed & implemented a Customization on “Refund process” (with the halp of Technical team) to refund the amount to the Customer by cutting a check in AP.
- Implemented a major Enhancement “Journal entry creation for Cash management Entries” to perform reconciliation of Treasury entries which saves significant cost & Benefits the Customer to avoid manual intervention.
- Evaluating the Reports and testing them for the desired outputs after development as Per the Business requirements.
- Responsible for Baseline configurations for Accounts Payables, Accounts Receivables & Cash Management
- Providing solution for Revenue Recognition for Pacific Bio Sciences orders in AR.
- Helping technical team develop a customized Revenue Recognition program in AR
- Developed and executed test scripts and drove resolution of fixes to the system prior To User Acceptance Test.
- Responsible for end to end testing on Accounts Payables.
- Testing the entire process of Payables transfer to GL, AP Assets creation and mass Additions create through Payables.
- Set up of Desktop ADI and test the creation of Journals along with WEB ADI.
- Evaluating and adding account combinations so Account Generator runs smoothly for Depreciation run.
- Played significant role in system Integration testing.
Confidential, Chicago, IL
Oracle Functional Consultant
Responsibilities:
- 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 providingProcure-to-Pay (P2P)life cycle support.
- Setup and ConfiguredGL, HRMS, AR, AP, FA, PO, CM, ADI, version R11i.
- 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 forGL and AP, including budgets, multi-org & multi reporting currency.
- Participated in setting up ofMulti-Orgfor 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.
Environment: R12- General Ledger, AP, AR, FA, CE, Alerts, Order Managerment, Report Manager, iProcurement & iExpenses.
Confidential, Austin, TX
Oracle Financials Functional Analyst lead
Responsibilities:
- Worked as Functional Analyst for Oracle Purchasing, Payables, Receivables, General Ledger, Cash management and Fixed Assets.
- Studied and evaluated functionalities of various modules.
- Defined Set of books, accounting flex field structure.
- Prepared Setup documents (BR100) for Accounts payables & Accounts Receivable.
- Created Responsibilities with menu exclusions as part of SOD & tested all the menus & functions.
- Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
- Prepared functional Design Documents for application extensions and conversions (MD.050).
- Prepared Test Scripts for Integration Testing (TE040).
- Handled post go-live user support.
- Developed the training material for the users.
Environment: Ledger, R12- General AP, AR, FA, INV, OM, iProcurement.
Confidential, Woburn, MA
ERP Functional Consultant
Responsibilities:
- Gather Business requirements and worked with End-users on Issues resolution
- Study of the current Business Process, Suggestion of future Processes andGAP Analysisusing AIM documents
- Preparation ofBR100, Common Set-ups doc, Sys Admin Set-ups documents
- System configurations and Set-ups configuration in the new environment
- Resolved Client/User issues during Testing Phase
- Prepared and Executed Financials Test scripts
- Interacted with End-users on day to day business operations.
- Worked on Reports Development.
- Validation of Data Migration and data loading
- Preparation of training materials
- Trained End user on Oracle Financials.
Environment: GL, AP, AR, FA, CE, PO & iExpenses