We provide IT Staff Augmentation Services!

Oracle Financials Functional Consultant/ Business Analyst Resume

Deerfield, IL

SUMMARY

  • 7+ years experience as Sr. Business Analyst/ Oracle Functional Analyst working with Oracle databases, Oracle e - Business Suite (EBS) Financials, Projects and Manufacturing Modules. Part of full life cycle implementations with Three R12 implementations.
  • Experience and good understanding of R12 modules concepts like MOAC, configuration of security controls using Multi-org Access Control, Security profiles, Data Access Sets, Definition Access Sets. Well versed with the base table's data structure changes, Initializations, coding standard changes with R12.
  • Strong in Oracle EBS - GL, AP, eBTax, AR modules withfunctionalexperience in analysing business requirements, procedures & processes, module setup,functionaldesign specifications, user training and post-implementation support.
  • Working with an enterprise class ecommerce platform such as ATG, IBM WebSphere Commerce, Escalate Retail, Sterling Commerce, Microsoft Commerce, etc.
  • Requirement gathering activities with business along with numerous user awareness discussions, workshops.
  • Experience in developing cost effective solutions as Techno Functional Consultant using Oracle Applications and related technologies Including Implementations, Upgrades, Data Conversions, Interfaces, and Customizations.
  • Experience in all stages ofERPimplementation including Requirement Gathering, Solution Design, GAP Analysis, Customization, Configuration, Testing and Project Coordination.
  • Having process knowledge on Order Management, Purchasing, and Inventory; moreover, Procure to Pay (P2P), Order to Cash (O2C), Acquire to Retire (A2R) process cycles with cross function integration.
  • Proven ability to leverage advanced Oracle EBS knowledge, Logical and Analytical skills to identify and translate the business requirements into highly effective value added solutions. Designed and developed numerous solutions which are bug free and consistently met customer SLA goals.
  • Strong ability to liaise with end users and customers located around the world to cultivate strong business relationships. Direct customer interaction during all phases of product development lifecycle.
  • Ability to work with Cross-functional teams including Users, Financial Analysts, Business Analysts, Architects, DBA's, Functional Analysts and Technical Analysts.
  • Extensive experience in understanding and gathering client requirements, translating them in to various process alternatives, mapping into feasible solutions in Oracle Applications, managing functionalsetups related to Oracle applications.

TECHNICAL SKILLS

ERP: Oracle EBS (R12 - 12.1.3) /11i (11.5.8, 11.5.9, 11.510.2) /11.0.3

Modules: (GL, AP, AR,CE,FA), Supply Chain - (INV, PO, OM), Manufacturing - (BOM, WIP), CRM, ASCP, iProcurement, iExpenses, Service Contracts, TeleService, iSupport.

Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, Data Loader, BI/XML Publisher, Load Runner

GUI: Developer 6i, Developer 2000, Forms 6i/10g, Reports 6i/10g

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting

Databases: Oracle 11g/10g/9i/8i, MySQL, MS Access

Reporting Tools: Reports 10g/6i, XML/BI Publisher, Oracle Discoverer 10g/9i, Workflow builder

Operating Systems: Windows 98/2000/NT/XP/7/8, Unix (Solaris, HP-UX), Linux

PROFESSIONAL EXPERIENCE

Confidential - Deerfield, IL

Oracle Financials Functional Consultant/ Business Analyst

Responsibilities:

  • Worked on requirement gathering activities with business along with numerous user awareness discussions, workshops.
  • Involved in configuring and testing Account receivables and eBTax modules and supporting customizations.
  • Worked on Implementations, and Upgrade projects, including implementations in Oracle R12 (R12.0.3).
  • Well versed with the understanding of Oracle R12 including Sub-ledger Accounting (SLA), AGIS, FSG reporting.
  • Involved in Implementation, Upgrade, Production Support, Migration and Customization of various domains of oracle applications.
  • Involved in setup of GL and AP modules on production server, updating the test scripts.
  • AP and AR module setup and configuration, defining DFFs for additional data gathering from the third party applications.
  • Created numerous Lookups: Payment terms, Pay Groups, Tax distribution accounts, etc. Also, Prepared GL, Sys Admin configuration documents. Prepared configuration documents for HRMS, AP, AR and AGIS.
  • Provided Oracle R12 End User Support for Accounts Payable, iProc, eBTax, and GL by resolving/testing technical issues and new functionality. Identify, document and implement process improvements, while working with the DBA's, test team and user community through development and implementation.
  • Performed accounting activities such as preparing journal entries, checking supporting entries, account reconciliation, account reporting and/or cost accounting analysis.
  • Configure the Assets system to Route Capital Assets through Projects/Grants modules as appropriate to record depreciation monthly.
  • Worked on Fixed Assets module by managing assets which includes depreciation periods, summary of depreciation periods, FA Books etc.

Confidential - Omaha, NE

Sr. Oracle EBS / Business Analyst

Responsibilities:

  • Automated the Billing system using Oracle database for billing various customers. Implement solution to provide accurate billing and save lot of money for company.
  • Identified and ensured fixes for ASCP bugs in 11i where addressed, while implementing R12 ASCP
  • Participated in various project management activities such as estimation using Project Estimator tool. Project costing and billing, Effort and schedule measurement/slippage using XDPortal, Creating status reports.
  • Developed reports for getting payables and receivables from Sub ledger Accounting (SLA)
  • Have setup and tested various ASCP Plans in various test environments for R12 Upgrade project, have executed Plans / Collections, reviewed Planners workbench, resolved various Oracle EBS Planning issues, have worked with Oracle Support teams on various Service Requests.
  • Preparation of Test scripts, performing quality assurance testing, user testing on new implementation of Oracle treasury, cash management and payables.
  • Conducting UAT sessions with key users and Go Live with minimal issues in Post Production support.
  • Preparation of Standard operating procedures (SOP s), end-user training material for Project Costing, Billing, Project Contracts and other customized modules.
  • Have worked on Oracle Inventory modules for completing standard functional setups such as Organizations, locations, Sub-inventory, locators, Planners, Inventory Parameters.
  • Customized revenue Recognition rules by using API's in Project Accounting.
  • Rolling out Global Trade Management(GTM) to new Orgs in Oracle EBS system. Ensuring classification codes and setting up Shipping document sets for the new orgs.
  • Modified the Subledger Accounting to suit accounting requirements of client for Payables and Receivables .
  • Automated the Billing system using Oracle database for billing various customers. Implement solution to provide accurate billing and save lot of money for company.
  • Provides advice on accounting matters, support to financial staff with issues related to financial reporting and variances.

Confidential

Business Analyst

Responsibilities:

  • Implemented application customizations based on fit-gap analysis and enhancements for Projects, Grants, Commitment Control Billing, Projects, AR, AP, AM,Travel& Expense, Contracts and GL modules.
  • Used Oracle standard API's to put holds on Project billing events as per the requirement.
  • Developed multiple reports in Oracle Projects listing closed projects, expenditures, Tasks, agreements, Budgets, key members, billing events etc.
  • Integrated sub-ledgers with operational systems like CLASS, FDDB, Worldport, COMDATA, Logistics Vision, and PHAMS.
  • Designed AP and PO inbound interfaces to capture the cost and AR Inbound Interface to capture the revenue. Also developed several outbound interfaces to aid in reconciliation.
  • Owned monthly expense projections utilizing various methodologies that accurately communicate sensible expense management to maximize margin.
  • Worked on General Ledger Multi-org on an R12 implementation through initial Conference room pilot (CRP).
  • Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
  • Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage forfinancialand statutory reporting
  • Collaborated with corporate matrix partners to publish monthly regional operating metrics that aggregate product-line earnings and outlook.
  • Enhanced earnings and expense forecasting model to reduce process time to focus on expense drivers and internal management controls.
  • Implemented cost reduction initiatives to contain temp expense by creating a temp spend tracking database, and a regional approval process.
  • Fortified Senior Management understanding of key drivers and corrective action plans for monthly regional expense calls

Confidential

Business Analyst

Responsibilities:

  • Customized and Developed the Quote to sales agreement process and create the new price list based on quote process dynamically.
  • Developed the Payable interface process using Web ADI for purchasable and non-purchasable items.
  • Developed the Lot tagging form and calling standard order form using ZOOM functionality.
  • Collaborated with corporate matrix partners to publish monthly regional operating metrics that aggregate product-line earnings and outlook.
  • Responsible for requirements gathering and definition, conversion of business requirements into technical specifications, technical project plans, overseeing the development work etc.
  • Manage the data integrity and timely completion/closing of shop orders and material information in shop floor data systems and MRP.
  • Performed requirements gathering, gap mapping. Responsible for initial setups using Accounting Setup Manager.
  • Assisted/reviewed Payables and Cash Management, maintaining and updating BR100 documentations.
  • Determine business requirements for integration, including review of Chart of accounts to ensure adequate coverage for financial and statutory reporting
  • Development on Workflow Customizations for sending the sales order to VCHS before provisioning the Sales Order. Used Workflow builder 2.6 to customize existing processes by adding new notifications.
  • Resolved issues related to Order Management, Release Management, Shipping, Pricing, OSP setup, Purchasing, Blanket Purchase Agreements, Discrete Jobs, BOM & Routings, WIP Transactions while supporting Oracle 11i.
  • Involved in Implementation, Upgrade, Production Support, Migration and Customization of various domains of oracle applications.
  • Working Experience on 10 releases with Business Analyst and Integration Team during CRP Testing.
  • UAT and Production Support during each phase go-live.
  • Loaded the vendor's information from the legacy system to oracle Purchasing. Developed a PO interface to generate Purchase Orders through an interface conversion program as per the data received from Legacy System.

Hire Now