CAREER SUMMARY:

Consultant for Oracle Cloud (Fusion) ERP implementation of Financials and Procurement Application Services. 2y Support & Implementation of Oracle E - Business Suite Financials, Procurement, Manufacturing, SCM, and CRM. 18y Senior Functional Analyst in Manufacture, Insurance, Retail, Banking, Logistics, and Services Industries. 10y

SKILLS:

FAH, SLA, GL, Tax, AP, FA, AR, RMB, CM, TM, OIC, GAAP, IFRS, ASC, ASCP, PO, INV, WIP, OM, OPM, CST

FSM, RI, ADF, ADFdi, FBDI, UCM, BPM, OTBI, GL Wand, Hyperion, Essbase, XML, BI Publisher, SmartView, FRS

OUM, AIM, CRP, BPEL, SOA, Web Services, SOAP, REST, Java, CEMLI, RICEW, Developer, SQL, PL/SQL, ITIL

PMLC, SDLC, QA, ETL, Jira, SOX, audit, Diagnostics, iSetup, OAT, Word, Excel, Power Point, Project, Visio

WORK EXPERIENCE:

Oracle Cloud ERP Consultant

Confidential

Responsibilities:

• Integrating Oracle Procurement Cloud with Financials Cloud (Feb 18 to present). As Fusion ConsultantReview and update of setups in Purchasing, Receiving, and Inventory configurations in line with Financials.
• Migrated, refreshed, updated and upgraded deployment of Procure to Pay with Cost Accounting.
• Preparing for UAT. Tested accounting for cost centers, COGS, inventory transfers, accrual and variances.
• Implemented Oracle Cloud Financials (Jul 17 to Mar 18). As lead Project ConsultantAnalyzed requirements, conducted workshops, evolved gap - fit solutions under OUM Method guidance.
• Controlled environments for team of 7 through migration, refresh, patch, update and upgrade with QA tests.
• Designed Enterprise Accounting Structure on Ledgers based on business locations, processes, events, users.
• Configured Common, GL, Tax, AP, Assets, and AR with initial setups for CRP validation and subsequent updates.
• Achieved high accuracy in data conversion using FBDI, ADFdi, and UCM controlling extracts and mappings.
• Updated setups for tuned functions including for approvals, validations, pages, extensions, lookups, and flexfields.
• Managed Integrations using Cloud Connectors, bulk loads, OER for SOA change controls in Service Interfaces.
• Implemented Intercompany, EFT and Shared Service Center. Delivered BI Publisher Reports and OTBI Analytics.
• Articulated FAH and ORMB for Insurance service business (Apr 17 to Jun 17). As configuration consultantDefined Enterprise Structure, security, FAH accounting transformation SLA rules, GL with Intercompany.
• Setup Revenue Management rules to identify contracts, obligations for fee dimensions to recognize revenue.
• Integrated import of basis and billing data schedules for allocated revenue recognition accounting with reports.
• Implemented Fusion Cloud Financials for b2c business (Oct 16 to Mar 17). As Financials leadDefined chart of accounts, hierarchies in primary and secondary ledgers along with reporting currency features.
• Controlled configuration of Flexfields, General Ledger, Intercompany, Tax, Assets, Payables, and Receivables.
• Integrated Web Services for AP Invoice, Intercompany, Recurring invoices, Journals, Assets, and Expenses.
• Extended flexfield custom attributes for SOA validations, UI pages, BI Publisher and Infolets for OTBI reports.
• Uploaded data for customer accounts, suppliers, and open balances. Documented deliverables and training.
• Supported content migration of configuration package, RI spreadsheets, extensions, BI report and refreshes.

Oracle E-Business Suite Analyst

Confidential

Responsibilities:

• As Oracle E - Business Suite specialistControlled QA procedures for upgrade patching, migration, integration, environment testing and cutover.
• Evaluated CEMLI upgrade on impacts, modified customizations and setups, managed retrofit activities.
• Rolled out 3PL system for NZL and Taiwan through process mapping, proof of concept, CRPs, and integrations.
• Enhanced Order-to-Cash system using SOA composites, OSB pipeline, MFT flow, BPEL process, OEP analysis.
• Trimmed financial period close process with analysis, reports, reconciliation in sequential system schedules.
• Introduced ACH bank payment to suppliers, new products using Agile PLM, Order fulfillment proof of delivery.
• Developed processes for Roadshow event inventory transfer, prepaid ordering with delivery and accounting.
• Verified configured Incentive Compensation on collection, calculation, payment, allocation up to GL accounting.
• Completed final phase of implementation and post production support of E-Business suite for hardware manufacturing company, Prime-Line Products in Redlands, CA (Jun 12 to Aug 13). As Senior EBS Applications AnalystSupported SLA Level2 in Production, Controlled daily accounting of journals in GL, Generated daily BI Analytics.
• Prepared Reports, Analyses (Accrual, Variance, Margin), and Reconciliations for efficient period close.
• Customized SLA accounting methods with rules. Maintained EBTax with updates and fixes.
• Monitored COGS accounting flow, perfected average Cost calculation, contributing to profitability controls.

Confidential

Sr. EBS Systems Analyst

Responsibilities:

• Managed project team of 40 consultants with comprehensive planning, tracking progress, and meeting reviews.
• Reviewed requirements, analyzed gaps, customized functionalities, unit tested, conducted CRPs, and cutover.
• Managed Data Conversion ETL processes on 105 objects achieving >99% accuracy through iterations.
• Leading Planning - to-Procure-to-Pay team, implemented Demantra, ASCP, iSupplier, Procurement and OTM.
• Updated setups after CRPs in Purchasing, WMS, Order Management, Trade Management, and OIC.
• Established CDM, MDM practices with controlled processes under TCA, CDH and PDH architectures.
• Integrated Order-to-Cash modules Siebel, EDI, SOA, EBTax, order, ship, autoinvoice, claims and collections.
• Setup Trade Management for promotions and offers driving modifier pricing actions by types and for claims.
• Customized SLA rules for fine accounting. Rolled up Standard Cost runs for cost updates. OPM formula recipes.
• Controlled setups of Core Financials and Cost Management in OPM, WIP, Inventory, AP, Assets, AR, and GL.
• Supported L3 Post-Production. Managed functional performance tweaks.
• Executed scheduled rollouts on time.