Oracle Applications Financial Functional Resume Profile
Executive Summary-
- A highly professional Oracle Financials Consultant with 6 years' experience using the Oracle Applications suite, and 8 years' experience in Financial Operations and Management.
- Direct hands-on implementation experience with multiple Release 12 clients.
- Functional proficiency, sound technical knowledge and excellent understanding of best practice business processes and system design.
- Vast experience of working effectively across all staff levels. Articulate, confident and pro-active approach.
- Strong expertise in Oracle Financials General Ledger, Fixed Assets, Account Payables, Cash Management with strong knowledge of PO and Inventory.
- Full life-cycle conversion, implementation and post production support experience.
- Functional support for Lease Management implementation and upgrade.
- Full implementation/upgrade lifecycle for EBS ERP projects.
- In-depth knowledge of requirements' localization for Nigeria.
- Core competencies include Business Requirements Gathering and Definition, Gap Analysis, Mapping, Systems and Environment Set-up, Testing, End-user Training, Post Production Support.
- Excellent interpersonal and communication capabilities and extensive experience in dealing with people from various organizational levels and diverse cultural backgrounds.
- Fluent in English.
- Strong Technical Consultant in implementing, customizing, supporting and maintaining Oracle Applications/Oracle e-business Suite R12 the main concentration being in the Financial modules including Application Object Library AOL and System Administration.
- Strong Functional Consultant in implementing, supporting and maintaining Procure to pay P2P process.
- Experience configuring the Sub Ledger Accounting SLA set ups
- Configuring setups for Global Consolidation, Multi Reporting Currency and FSGS
- Configuring the setup for batch invoices and batch payments, multi currency invoices
- Period close and Quarter close experience.
- Experience in Design, Development and Testing of Oracle Reports/Oracle Forms
- Ability to effectively gather and refine report requirement from Users and Management and give appropriate attention to details. Proficient troubleshooting skills.
- Ability to manage time spent on multiple projects to meet deadlines. Ability to work independently and as part of a team.
- Coach and mentor train and motivate team to efficiently and effectively perform responsibilities.
- Ability to develop tactical business solution in challenging deadline driven environment.
Technical Skills Summary
- Oracle Applications 11i, 12
- Oracle System Administrator
- ERP: Oracle Financial Modules like GL SLA /AP/PO/AR/FA/CM/IExpense/IProcurement/ADI/e-BTax, Oracle Applied Technologies like Workflow
- Oracle Distribution: PO and Approval Workflow, INV, IPayment
- Oracle Global Financials GL, FA
- Oracle Lease Financial Management and Reconciliation
Professional Experience:
Confidential
Oracle Applications Financial Functional
Responsibilities Participated in multiple business meetings for Fit-Gap Analysis and Solution. Assisted functional lead analyst to conduct CRP1 and CRP2. Prepared BR.100 Application setup and MD.50 Application Extensions Functional Design documents according to AIM. Involved in configuration of CRP1, UAT and test instance. Trained Super Users and troubleshooting during UAT User Acceptance Test . Used the System Administrator responsibility to define users and assign responsibilities and set profile options Define Organization Structure MOAC , Users and Responsibilities, Security Profiles and Flex Fields Set-ups and maintenance, converted the headers, lines and line locations from the legacy system to Oracle Payables Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes Design Develop FSG reports in GL Set up AP bank accounts, bank documents, bank codes and expense report templates Defined profile options to specify certain implementation parameters Set up Recurring journals template, recurring journals and Auto-reversal in GL. Set up suppliers, locations, and purchasing quick codes. Setup payment terms, invoice distribution, matching of invoices against PO. Configure Financial Options and Payables Options in AP. Created custom Customer invoice print templates Configure System Options in CE. Worked on Cash forecasting, reconciliation, Cash pool and Cash positioning Reconcile AP with bank statement in Cash Management. Activation of various flex-fields in the forms to gather the additional information Participated in testing, user accepting testing in test instance and worked with certain key super users.
Environment
Oracle Financials R12 GL, AP, FA, P2P, CE Working with Ansell: a manufacturer of wide range of hand and arm protection solutions, clothing, on fresh Implementation with responsibility of GL, AP, CE modules from just before CRP1 through to UAT phases.
Confidential
Responsibilities Understanding the functional requirements of the client, Analysis and Review of High Level documents mainly MD50 Functional Specification and resolve the issues through functional walkthroughs. Developing custom interfaces between various Applications for integration. Developing reports through Oracle Reports and XML Publisher. Reviewing data load from legacy system SQL loader and PL/SQL programs was used to dump the data from the staging tables to the Interface Tables . Collecting Business requirement and Leveraging with Oracle Applications Uploading created Procedures, Functions and other database objects. Defining Concurrent Programs, Executables. Customization and development Reports as per client requirements. Writing Unit Test cases and testing after completion of the Object.
Provide leasing functionality and integration with lease price modeling software GL, AR, AP, FA Supported all go-live activities and post-production troubleshooting. Reviewing accuracy and completeness of MD070 Technical specification documents based on Functional Specifications.
Environment
Oracle E-Business Suite R12 - Oracle Financials Modules: GL, AP, AR,FA, CM. UNIX and SQL developer.
Project includes the customization in finance module along with new services to be included by the client, Office Depot Oracle Lease Financial Management- functional design, configuration, testing and supporting the full implementation
Confidential
Responsibilities: Present requirement questionnaire to the business and mapped business requirements. Prepare RD.20 and BP.80 according to AIM implementation methodology. Prepare Visio Process diagrams for AS IS / TO BE scenarios. Work with the business to come up with the future business process Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups and MOAC security. Set up Multi-Currency environment Create Customized responsibilities, customized menus, customized request groups Design a Prototype Demo configuration of French Localization as per client's request. Create BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AP, AR, SLA Sub ledger Accounting Contributed towards Conference Room Pilots CRP1 and CRP2 Coordinate with offshore technical team for data conversion. Helping users upload journals using Web ADI in GL Involved in Scheduling the Reports Configured GCS Global Consolidation System to consolidate balances from French Ledger with Parent company Ledger Configured AGIS for Leapfrog Head Office to handle their inter-company transactions along with defining intra-company rules Setup International Tax Calculation including UK VAT and Germany VAT Defining System Option Parameters in AR Completed setup and demonstration of handling Refunds Prepared System Test Scripts TE.040 for UAT sessions and Training Documents with screenshots for end users Prepare and Configure Setups in Production Instance and Production Support Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module Provided various custom solutions for client's specific needs Trained end users using Oracle UPK User productivity Kit Provided with post-production support after go live on GL, AP and AR modules
Environment
Oracle 11i financial modules - GL, AP,AR
Worked for Leapfrog: a manufacturer and global distributor of educational toys and learning games, on full life cycle Implementation with responsibility of GL, AP, AR modules right from the beginning through to Go-Live.
Confidential
Responsibilities Involved with Super User Training and resolving post UAT issues. Re-defined system parameters and Bank Statement Mapping in CE Perform additional Setup for Customer and Address Relations in TCA Architecture Corrected the system configuration to take care multi currency invoice entry and payments Worked on Trading Community Architecture TCA and customizing customer import program for site/contact information Defined the 1099 suppliers and testing the tax payment extractions for reporting purpose Developing AP, AR,FA and CE Training Guides Setup the Auto Cash rule set according to client requirements Prepared Static and dynamic data template for collecting all the information about the Banks, Vendors, Customers, Tax Codes etc. Develop/Update Discoverer Reports for Month End Reports Support Business Users in Month End Close Process Resolve the Reconciliation issues with Sub ledgers to GL Prepared documentation at various phases. Solution to complex issue through Metalink
Environment
Oracle E-Business Suite R12 - Oracle Financial Modules CE, FA, AP, AR and eBTax
AEM is a manufacturer of Hi-Reliability fuses and electronic components for aerospace and defense customers. Project was from UAT to Go-Live. Worked with AEM Was responsible for CE, AP, AR and eBTax modules from UAT through to Go-Live in the Upgrade project.
Confidential
Responsibilities Member of the core team responsible for implementing and setup of GL and AP Involved in current system analysis and GAP analysis system configuration and testing in GL and AP module implementation. Involved in organizing work shop with the end users for requirement gathering, limitations of existing system and proposed the solutions. Setup suppliers, supplier sites, banks and bank transaction codes Set up the approval hierarchy for expense reports Created employee expense templates for different departments Involved in developing test scripts, creating user manuals and end user training Configured the Sub ledger Accounting SLA setups Configured setups for Global consolidation, Multi reporting currency and FSGS Configured the setup for batch invoices and batch payments, multi currency invoices and multi currency payments to meet the requirements in AP. Developed AIM documentation RD-20, BR-100, CV-40, MD-50, and TE-40 for business requirements, system setups, conversions, customizations and functional testing respectively. Extensive unit and integrated testing done before CRP's UAT
Environment
Oracle Financials R12 - GL and AP Xsigo system is an information technology and hardware company. Worked with Xsigo as an Oracle Financials Functional Analyst from requirement gathering phase through to UAT phase in implementation project responsible with GL and AP
San Diego Convention Center, San Diego, CA
Oracle Financials Functional Analyst
Confidential
Responsibilities:
Set-up of financials options, payables and payables System options in AP Set-up of system setup options in AR Involved with migration of historical data for Accounts Payables and Accounts Receivables. Set-up of invoices, debit and credit memos, guarantees, transaction types Set-up receipt class, receipt methods, receivable activities Created the supplier, supplier sites, banks and bank account Configured the Sub ledger Accounting SLA setups Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes. Participated in CRP and UAT Prepared the MD 50 and worked with technical team regarding RICE components Prepared and executed test scripts TE 40 Created user-manuals and trained the end users
Environment
R12 Upgrade from 11.5.10.2 to R12.0.5, AP AR San Diego Convention Center is the primary convention center in San Diego. Project included the Upgrade of AP and AR from CRP phase through to UAT phase.
Confidential
Oracle Financials Functional Consultant
Responsibilities
Cut over and Go live as per the schedule and provided post-production support. Writing User Manuals and Training End Users. Conduct business meeting whenever required based on issues Issue tracking and solution, maintained documentation for the same Functional enhancement for invoice approval workflow Reset security rules to restrict access of users for only few fixed responsibilities Follow a strict change management process involving end users, followed by problem analysis, development or bug fixes, unit testing and user acceptance testing with thorough documentation maintained at all stages. Open and follow through on Technical Assistant Request TAR with Oracle.
Environment
Oracle R11.5.10.2 - Support GL Provided post-production Support in GL module for Vertex Pharmaceuticals, a pharmaceuticals and biotechnology company
Confidential
Oracle Financials Techno-Functional Consultant
Responsibilities
Define Business requirements for Oracle GL, AP and AR, involved in identifying GAPS Prepare Documentation of BR 100, BR 30 and Functional Extension and design Document MD 50 Involve in all the business meetings and communicated with the business for system updates and the meeting of implementation deadlines Find effective solutions that consisted of both work around and customizations to the forms and reports Identify RICE components according to the client needs Create Chart of Accounts, accounting Calendar, Currency, defined Legal entities and completed Ledger accounting options as per client requirement Create multiple responsibilities, developed security rules and customized menu to restrict user access to GL functionality as per client's requirement Define formulas for Mass Allocation and Recurring Journals and completed setup of options required to perform Mass Allocations Define Budgets, Budget Organizations, Budget Formulas, and Defined Budgetary control options, Create Master/Detail budgets, Defined Mass Budgets and Mass Budget formulas Involved in the setup of inter-company balancing and global inter-company system Design and create reports for client using the FSG Define setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states Define Customers, customer profile classes, payment terms, and distribution sets, and Auto Cash Rule Sets Define Invoicing information including Payment Terms, Invoicing and accounting rules, Territories and Invoice Sources Define accounting options, methods of accounting, realized gain/loss account, unallocated revenue account, auto cash rule set, and auto invoice tuning Define receivable activities for miscellaneous receipts, finance charges, bank charges, defined collectors, and defined aging buckets Created customer profile classes, attached payment terms, collectors, matched receipts, statement cycle to profile classes Setup transaction types, invoices, guarantees, deposit, and credit memos, debit memos Assign receivable account, revenue account, unbilled account, freight account, cleared account, and unearned account to transaction types Conduct CRP 1, CRP2, CRP3 and tested all the setup
Environment
Oracle Financials R12 - GL, CE, FA, AR and AP TCON is an Oil and Gas Service firm in the energy sector in Nigeria. Project includes data migration for the Expense Cycle PO, Inv, AP,GL and Revenue Cycle OM,INV,AR ,and the Implementation and Post Production support of GL, AP and AR from requirement gathering phase through to support phase.
Confidential
Oracle Financials Functional Consultant
Responsibilities:
Designed and created new CHART OF ACCOUNTS and set of books Created users and modified the privileges for users, rollup group and summary accounts Created suspense accounts for automatic balancing journal entries from particular sources and categories Created budget, budget organization, master detail relationship, budgetary control and budgetary control groups Define the Global Inter-company System GIS , Designed and Setup the Global Consolidation System Developed several FSG reports, including balance sheet and income statements Set-up supplier and supplier sites for suppliers in payables Developed several custom reports and customized oracle reports for payables Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close Created updating adjustment of invoices, debit memos, credit memos Defined banks, customers, receipt classes, collectors Analyzed and mapped historical data of existing customers Setup customer profile class, profile attributes, customer relationships, statement cycles and accounting rules Defined system options, transaction types, auto cash rule sets, remittance banks, bank accounts, receipt classes, distribution sets and payment methods Trained and guided users through the testing period
Environment
Oracle Applications R12.GL, AP and AR Modules. Up-gradation Production Support Garlock Sealing Technologies has been helping customers efficiently seal the toughest process fluids in the most demanding applications.
Confidential
Oracle Financials Functional Consultant
Responsibilities:
- Responsible for the implementation and conversion of the Oracle Consolidation Process in GL R11.5.10
- Responsible for the work plan management, evaluating it on an ongoing basis and determining the current state of the project.
- Business Requirements Mapping for General Ledger.
- Study of current business processes, future business flows and identification of gaps and workaround.
- Responsible for the environment setup for the implementation of Oracle GL.
- Carrying out User Acceptance Tests UAT .
- Conduct training sessions to end user for the implemented modules of Oracle Financials.
- Provide post implementation support.
Environment
Oracle General Ledger R11i
AOC is a leading global supplier of resins, gel coats, colorants and additives for composites and cast polymers. Backed by the industry's best technical support, AOC products are manufactured in facilities strategically located in United States, Canada, Mexico, Europe and Asia. AOC-owned facilities are certified as meeting ISO 9001:2000 standards for quality control.
Confidential
Responsibilities: Managed Financial Operations Facilities with a budget of over 160M. Reduced expense by 1.5M. Managed project managers and ensured compliance to contract terms and company policy. Monitored projects to ensured timely completion and on budget. Used such tools as timberland. Managed payroll, housekeeping financial operations and energy - lamps. Responsible for financial planning and budgeting. Performed financial analysis and forecasting, payroll planning and management, union contract review and application in planning and budgeting. Prepare and review accounts reconciliation, non-payroll commitment planning and control Use Tax Management and accrual for 50 States and District of Columbia. Month-end closing and variance explanation. Reduced processing cost by 15 by working with vendors to develop and implement consolidated invoicing system. Redesigned improve workflow procedures and increased department efficiency by reorganizing financial analysts' and financial clericals' tasks/duties and cross training.