SUMMARY:

• Seasoned Oracle Fusion, EBS R12 professional with several full - lifecycle, multi-million dollar implementation experiences over 18 years, including 3 years at Strategic Accounts division in Oracle Consulting.
• Functional Consultant/Techno-Functional Consultant/Project Lead/Technical Consultant/Onsite-Offshore Coordinator for multiple Oracle EBS implementation at Confidential, Confidential, Confidential, Confidential & Confidential, Confidential, Confidential, Confidential, Confidential and may other clients.
• Proven success in influencing adaption to global standard processes; aligning process with technology, business goals with IT strategies; communicating effectively with people at different levels of hierarchy and expertise
• Solution-focused, business-value-driven, self-motivated and quick-learning team player excellent at skills of requirements engineering, presentation, documentation, organization, interpersonal and time management
• Experience in business flow accelerators, global blended delivery, project management, analysis, design, development, testing, and post go-live support.
• Experience in process flows: Fusion Financials, Procure to Pay, Order to Cash, Advanced Pricing, iProcurement, Supply Chain Management, Logistics, Asset Management, Warehouse Management, Manufacturing & HRMS
• Extensive on hand experience in Custom Interfaces, EDI and B2B solutions across modules.
• Extensive on hand experience in development using Oracle Technologies including SQL, PL/SQL, Forms, Reports, Workflow, BI Publisher, XML DB, XML Gateway, Oracle Express (APEX), ADF, UNIX Scripting, OBIEE
• Management of People, Processes and Performance to drive excellence; problem-solver and change-catalyst with exceptional skills in strategic action, implementation, scalability and sustainability

TECHNICAL SKILLS:

Applications: Oracle E-Business Suite 11 / 11i / R12 / Fusion

Modules: GL, AP, AR, FA, PA, Advanced Collections, HRMS, INV, BOM, OM, Advanced Pricing,Purchasing, Warehouse Management, Shipping, Enterprise Asset Management, Purchasing,Process Manufacturing, Cash Management, Bill Presentment, Oracle Fusion Financial

Databases: Oracle 7/ 8i / 9i / 10g / 11g /12c

GUI: Oracle Forms 3.0/Developer 2000 /6i / 9i / 10g, J Developer, OAF, ADF

Languages: SQL, PL / SQL, Pro*C, UNIX Scripting

Tools: SQL Plus, Oracle Workflow, SQL Loader, TOAD, BI Publisher, XML DB, Oracle XMLGateway, APEX(Oracle Express),Oracle Forms/Reports, Oracle e - CommerceGateway, OBIEE, Data Loader

Methodologies: Oracle Application Implementation Methodology, Confidential Ascendant Oracle ERP Method

PROFESSIONAL EXPERIENCE:

Oracle Financials (FAH) Functional Lead

Confidential

Responsibilities:

• Requirement Gathering
• Leading CRP Sessions on Financial Accounting Hub (FAH)
• Financial Accounting Hub (FAH) implementation & support
• Oracle Revenue Management & Billing implementation
• Analyse and Resolve post production issues as per the SLAs
• AIM Documentation - BR100, TE40 & MD50. MD70
• Designed interfaces to port data from Oracle RMB (Revenue Management Billing) to Oracle FAH
• Configuring Oracle RMB
• Customer
• Defining Sub ledger Accounting setups using Accounting Method Builder:
• Event Model, JLT’s, JED’s, Sources, Application Accounting Definition, Mapping Sets, Sub ledger Lookups based on Business Requirements
• Defining Complex Accounting rules via Account Derivation Rules
• Configured
• Legal Entities, Ledgers, Value Sets, Data Access Set, Sequence, Journal Source, Journal Category, Currency, Rates and Ledger Sets
• Configured Complete COA Structure, Primary and Secondary and Statutory Ledgers, Legal Entities
• Supporting Revaluation, and Translations activities
• Supporting Period End activities
• Resolving Staging & Accounting errors
• Defined Request Set and Interfaced the data to oracle via FAH from Oracle RMB by scheduling Interface Jobs
• Interfacing setup data like mapping sets and currency rates using Data Loader
• Configured Complete Setups in Accounts Payables
• Configured Banks Accounts, LookUps, Aging Periods, Payment Methods, XML Publisher Format Template, Formats, Payment Documents, Payment process profile, Payment Systems & System security Options

Oracle EBS Consultant

Confidential

Responsibilities:

• Custom Billing Application implementation & Integration with Oracle Receivables.
• Transforming business and stakeholder needs into practical requirements
• Successful Implementation of a Custom Application (Fund Connect Billing & Institutional Billing) in Oracle R12 to process data from Confidential online trading portals.
• Interface Data from global on line trading Portals to Oracle EBS
• Forms & BI Publisher reports to review interfaced data
• Processes to apply cash & calculate revenue
• Interface pricing data from external system to EBS
• Generate Invoices & Statements for customers
• Techno - Functional consultant
• Technical Consultant
• Oracle R12 Implementation
• Transforming business and stakeholder needs into practical requirements
• Configuration of GL & AR modules including Cart of Accounts
• Implemented a fully automated custom solution for generating, distributing & archiving statements for Confidential ’s 50000+ customers
• Provided solution to capture and maintain Confidential ’s customers with complex hierarchical structure which can have up to 5 levels of parent child relationship between those 50000 + customer accounts
• Led a team to successful upgrade from 11i to R12 for Confidential Electrical Works America
• Designed and implemented a fully automated B2B process to interact with Confidential ’s trading partner (Kintetsu World Express) to interface PO, Receipts & Warehouse management activities like Shipping Requests & Advices between them using XML Gateway
• Successful integration of Oracle R12 with a 3rd party toll - Confidential AR Collect a workflow driven collection tool as part of Confidential ’s global rollout
• Worked on setting up and interfacing Price Lists, Modifiers, Qualifiers, Formulas and Pricing Attributes
• Designed a custom solution to eliminate the financial overheads & risks involved in Confidential drivers collecting money on delivery at stores which helped Confidential to save millions of dollars
• Implemented automated scheduling process to run nightly batch
• Defining Process Manufacturing Organizations, Item & Formula conversion from legacy system
• Provided a solution to interface 1 Million lines of AR invoice lines worth 45 Million dollars with excellent performance on a daily basis which is highly critical for Confidential ’s cash flow.
• Designed and developed Inbound and Outbound EDI - 810, 812, 850,860 using Oracle Edi Gateway
• Designed and developed a custom solution to generate Late Fee’s for overdue AR transactions which allows Confidential to generate revenue worth couple of millions of dollars annually. Where the late fee can be calculated & posted at Top Account or Child Account level.

Confidential

Responsibilities:

• Techno - Functional consultant
• Oracle R12 Implementation
• Business Process Re-engineering
• RICEW documentation
• Post Production Support
• Successful Implementation of Oracle R11i
• Designed and implemented a custom THROTTLE process to streamline warehouse management process where deliveries of new Orders will be grouped together with back orders for the same customers. So that Arbonne will be saving millions of dollars every year.
• Implementation of interfaces for Item, Item On Hand, Customers, Sales Orders, Delivery, Picking & Shipping from other system to Oracle R12
• Design & development of a custom solution for reporting & handing of daily interface error’s

Confidential - Irvine, CA

Responsibilities:

• Led a team to successfully migrate legacy data from General Binding Corporation which was merged with Confidential to form the new company Confidential Brands
• Successfully implemented conversion/interfaces (Invoices, Purchase Orders, Receipts and Items) at Confidential handle the conversion of legacy data and also to interface data on a daily basis from the other systems to Oracle Application to handle the data in millions
• Worked as On-Site Off-Shore coordinator
• Designed and developed a single Match (2-way or 3-way) process at JCPenny for both Merchandise and Non-Merchandise items to be implemented in Oracle Application and it needs to be capable of meeting the goal of achieving close to 98% match in an automated manner.
• Successfully designed and developed conversion/interface of data across application modules for multiple clients
• Implemented Pricelist conversion and daily interface.
• As a Technical consultant I was involved directly with the client for designing, development, document and code reviews, testing, Installation, object release management and different acceptance stages
• Successful consolidation of data from two different 10.7 instances and upgrade to 11.5.6 at Telefonica Movie Star
• Resolved severe performance issues at Group Saltillo which was due to a memory leakage bug in Forms & fragmentation in Shared Pool. The whole application was tuned to give excellent performance
• Successfully implemented a custom ERP/MRP solution called IMAS - Integrated Manufacturing System (Owned by Mascon) for L&T and Bharath Electronics Limited
• Participated in the stream lining of AVALON (ERP product) at Confidential
• Writing scripts to port data from the two different instances, consolidate, modify and port to 11.5.6
• Developed scripts to generate new Account code combinations with validation of all segment values.
• Developed Purchase Requisition Interface