OBJECTIVE:

Oracle Financials Consultant

SUMMARY:

• Over 20 years of experience combining strong financial background, effective execution of business process improvement, and expert level business system applications knowledge in dynamic changing environment. Strengths include ability to provide solid efficient solution to complex business requirements, strong effective written and verbal communication skills at all levels of an organization
• Oracle Financials R12.1/R12.2.4 - SLA, GL, Confidential, Payables, Receivables, Fixed Assets, Costing, Cash Management, iExpenses, Report Manager, Payments, eBTax (EMEA VAT, US Sales Tax using Vertex and Taxware Rate), Advanced Collections
• Knowledge in Oracle Fusion Financials Cloud - Rapid Implementation, Enterprise Structure, Business Unit, Reference Data Set, GL, AR, AP, FA, Cash, Collection, AMX
• Oracle Manufacturing R12.1/R12.2.4- INVENTORY, PO, BOM, FLOW, WIP, iProcurement, AME for Requisition Approval
• Oracle Order Management R 12.1/11.5.10.2 - Order Management, Advanced Pricing, Shipping, Intercompany, and basic Configurator
• Oracle DEMANTRA Predictive Trade Planning and Trae Deductions Management
• Blackline on line Reconciliation Application
• Interface- PO, Receipts and AP Invoice EDI Interface using E-Commerce Gateway, Interface design for Autoinvoicing external data, AR Receipts Interface using public API, Auto Lockbox Interface, Blackline Data Interface
• OAF/XML - XML Data Model and Templates design ( Confidential Excel, Laser Check/ Confidential /EDI/ Confidential /Swiss DTA/Wire Payment formats, Staged Dunning Letters), OAF Personalization, Form Personalization
• Reporting - BI Publisher, Business Intelligence Dashboard Creation using OBIEE/OBIA views, Discoverer Administrator 10g, Discoverer User 10g
• Tools - TOAD for Oracle, SQL*Plus, Oracle Workflow Builder 2.6,Oracle BI Publisher Template Builder, XML Writer, Alert Manager, Oracle Report Builder 6i/10g, DataLoader, MS Office, SnagIT, Monarch Data Extractor, GL Wand, More4Apps

EXPERIENCE:

Financials Consultant

Confidential

Responsibilities:

• Instituted enhancements in handling Demantra Promotion and Trade Deductions data validation to eliminate issues
• Improved Trade fund month end close process by building reconciliation reports between Oracle GL and Demantra TPM
• Gathered requirement from business and created new Demantra series for claim settlement analysis
• Implemented Oracle Collections Workbench to eliminate manual process and increased collection efficiency
• Assisted in R12 upgrade assessment for merging 2 systems into 1
• Trained Accounting on new Confidential Report Creation

Confidential

Responsibilities:

• Led R12 upgrade project for Cash Management and Fixed Assets
• Cash reconciliation process improvement for 100 bank accounts by implementing cash management with bank statement import
• Built Bank Statement Upload process for interface to Blackline
• Chart of account re-design project - re-built security rule/cross validation rule/translation rules for new chart of account
• Solution Design Cash Management Bank Statement Auto Reconciliation with custom process to populate Bank Transaction Number from subledgers to maximize match rate

Confidential

Responsibilities:

• SLA Rule Solution Design to direct subledger posting by Location segment for adding new business unit into existing Operating Unit
• Reduced Cost Accounting month end closing time by 1 day by converting text outputs into Excel outputs via XML publisher
• Translated stakeholder requirements into various documentation and deliverables such as functional specifications

Confidential

Responsibilities:

• Designed and built Oracle Financial Data Extract scripts (GL Balance, AR Subledger Balance, AP Subledger Balance, and Exchange Rates) for uploading to Blackline
• Trained users on using Blackline Transaction Matching function
• Prepared MD50 to automate data transfer from Oracle to Blackline using ftp method through concurrent program

Confidential

Responsibilities:

• Redesigned Oracle Project accounting views refresh process to reduce Discoverer system downtime
• Implemented PA data performance improvement short term project

Confidential

Responsibilities:

• Managed workload and resource requirement of Application Support to improve SLA with business
• Designed the functional flow of Oracle Trade Management to Demantra TPM Interface for Demantra project
• Monitored Gentran edi inbound/outbound communications and resolved rejected transmissions

Confidential

Responsibilities:

• Led upgrade for Financials and Supply Chain modules
• Migrated 11i Payables Payment Formats to R12 Payments XML Templates for Confidential, Confidential Structured/Unstructured, and 3rd Party Check Printing/transmission
• Developed custom Financial Training Materials for delta change between 11i and R12
• Conducted training for US and EMEA users

Confidential

Responsibilities:

• Implemented R12 Advance Collections and customized Scoring Engines to create Dunning Plans by Region/Collector with localized Dunning Letters
• Migrated 11i Payables Payment Formats to R12 Payments XML Templates for Confidential, Confidential Structured/Unstructured, and 3rd Party Check Printing/transmission
• Developed custom Financial Training Materials for delta change between 11i and R12
• Implemented Austrian EMEA Tax in R12 using Tax Rule engine to meet local requirements while handling intra-company sourcing tax correctly due to spin-off

Confidential

Responsibilities:

• Led Financials upgrade for US entity including GL, AR, AP, and FA
• Solution Design Item Tax Exceptions handling by using Product Category with Tax Zone in R12 for US customers per US Tax Law
• Trained Accounting to use R12 Confidential Publishing feature for consolidated reporting instead of using GL Wand tool
• Conducted CRP, UAT Testing Cycles and resolved all issues
• Developed custom Financial Training Materials for delta change between 11i and R12 and conducted training
• Automated AR Statement generation with email delivery

Confidential

Responsibilities:

• Led General Ledger and Payables Upgrade for all Entities
• Conducted CRP/UAT testing and resolved go-live critical issues
• Trained International Accounting to use R12 Confidential Publishing feature for generating consolidated global financial reports in Excel
• Developed custom Financial Training Materials for delta change between 11i and R12
• Responsible for go-live activities in EMEA and APAC regions

Confidential

Responsibilities:

• Documented Fabrication business requirements and process flows to identify gaps from standard operations for new entity implementation
• Built Confidential training materials using uPerform document builder

Confidential

Responsibilities:

• Customized Receivables SLA Rule in R12 to meet complex business requirements while maintaining financial accuracy and eliminated unnecessary manual Journal Entry
• Reduced data processing errors by analyzing root causes, modifying interface programs and correcting configuration in R12
• Analyzed average 600,000 Credit Card transactions per month to ensure proper recognition between Bank and Book

Confidential

Responsibilities:

• Implemented iProcurement for controlled expensed inventory items and office supplies/MRO purchases via Punchout to supplier catalog
• Automated Procure to Pay flow with EDI outbound/inbound transmissions and AP Invoice Interface for payment
• Built Discoverer View for analyzing Expenses by Department