SUMMARY:

• Oracle EBS Functional Consultant and Solutions Architect with more than 20 years of aggregate Experience in IT. Worked for Clients from different countries and domain, expertise spans across Oracle Applications AP, AR, Advance iReceivables, iStore, iExpenses, GL (with Multi Org MOAC, Advanced global intercompany System (AGIS), Assets, Cash Management, Payments, Project Accounting(Costing, Billing and Manufacturing), Order Management, Purchasing, AOL and System Administration modules.
• Confidential has 20+ years experience as Lead functional and techno functional consultant in managing implementation, enhancement projects, and hands on experience in implementation. Has experience in Oracle Application Implementation, Review Business Process, Data Mapping, Gap Analysis, Design and Develop solution, Financial and Order management experience and has more than 10 full Life Cycle implementation, up gradation and production support exposure.
• Experience in Application functional Setups, Configuration, and AR and AP tax setups, e - Business Tax setups, Sub ledger Accounting and Localization setups etc and Customizations on Progress Billing & Revenue Recognition, Financial Accounting (FAH) and accounting of cost of goods sold processes in Multi Org and MRC environment. Has experience in Project Development and Deployment incorporating Business Requirements. Has experience in Gap Analysis, Develop AIM design documents and presentations for the CRPs.
• Has experience in Mapping, Data Conversion, Design Custom Processes, interface programs, develop test cases, integration and unit testing; Transition, Migration to Test and Production instances, Assessments, refinements, documentation and end user training. Has good knowledge in Oracle applications database, views, workflow, Forms Reports, API etc and experience in using tools like Data Loader, Pl/SQL and TOAD etc. Has experience in setting up controls for SOX and audit setups and preparing SOX test scripts.
• Confidential has proven ability to design and develop creative functional as well as technical solutions for Project accounting, Finance, Manufacturing, and Supply Chain management challenges and resolve critical issues. Certifying solutions through testing to include functional, usability, integration, performance, QA, operations, recovery and user acceptance; Implementing solutions including change management, installation, rollout and user training; monitoring and supporting all functions and interfaces during the transition to support period; documentation and turnover to support organization and operations.
• Design and setup for General ledger, sub ledger accounting setup including using FAH functionality, design and define Organization structure, legal entity, operating units, set of books / Ledger, Periods, Calendars, Key flex filed structure, AGIS setups for inter company transactions, defined code combination and security rules, journal sources, categories etc. Defined budgets, recurring journal entries, consolidation, FSG Reports etc.
• Worked on Asset module to defined Book Controls, Asset categories, Fiscal years, calendars, Assets integration with Oracle Projects, Mass transactions like transfers, charges, additions etc.
• Procure to Pay Process (AP / PO) for different Business requirement including overseas suppliers. Carried out setup activities for various purchasing options, receiving options and finance options, setup of buyers, purchase agreements, Approved Supplier Lists. Setup for Payable like financial / payable options, Supplier and Supplier site attributes Supplier Invoice matching process, ERS setup, payment terms, Banks and bank accounts, payment format programs, supplier payment bank interface programs etc. Assets setup activities Defined Assets book controls, system control set up etc.
• Sourcing rules, integration with advanced pricing, purchasing approvals, i-procurement and iSupplier Portal setup. Setups in receiving to support different receiving methods such as direct delivery, Standard receipt, etc and implemented automatic sourcing for various Purchasing documents. Defined Catalog, local content, employer and supplier p-cards etc and did setup for i-procurement module. Did supplier and buyer Setups for punch out.
• Defined and design to import Price Lists, different types of modifiers such as discount, surcharge, OID, freight & special charges Promotional schemes; qualifier groups & qualifiers, modifier incompatibility resolution using precedence/ best price techniques for advance Pricing .
• Defined pick release parameters, shipping transaction parameters, shipping tolerances, delivery grouping parameters, freight cost types, release sequence rules & shipping exceptions.
• Performed setup activities for Inventory like define Control, organizations and sub-inventories, Item Categories, Item Attachments, Inventory Planning, Item Cost, Inter Org Shipment networks, Inter Company Invoicing Process, Unit Of Measure Classes, Lot and serial number control etc. BOM setup like BOM structure, Routings, update cost and cost rollup process for standard as well as Average costing method.

TECHNICAL SKILLS:

• Worked on Version upgrades, new implementations, Custom Process, Enhancement, development of Interface and Data Conversion programs projects.
• Ability to articulate alternative solutions and reasoning behind the alternatives. Strong listening, interpersonal, analytical, trouble-shooting skills.
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines.
• Design document (AIM) for Interfaces, Conversions, custom programs and Customization of Work Flow, EDI, BI/ XML Publisher Reports, Alerts, Forms and Reports
• In depth knowledge and experience PL/SQL programming to Packages, Database triggers etc
• Ability to manage (Multiple) project tasks with changing priorities and tight deadlines and to articulate alternative solutions and reasoning behind the alternatives. Strong listening, interpersonal, analytical, trouble-shooting skills.