We provide IT Staff Augmentation Services!

Oracle Functional Consultant Resume

2.00/5 (Submit Your Rating)

Confidential,: Over 12 years experience in Oracle Applications (E-Business Suite) with a strong Functional, Accounting and Financial background. Participated or led implementations, Analysis, roll-out, Testing, and Customization for Oracle Financials. Extensive experience in Oracle Financials 10.6, 10.7, 11.3, 11ix (including 11.5.10) and R12, as well as working knowledge of Development and customizations.

ESSENTIAL COMPETENCIES:

Conference Room Pilot |Business Process Modeling
Requirements Analysis | System Integration Testing
Project Planning and Management | User Acceptance Testing
GAP Analysis | Super User and End User Training
Solution Design | Production Deployment and Cutover
Application Setup / Configuration | Post Production Support

HIGHLIGHTS:

  • Extensive experience in Oracle Applications versions R12, 11ix (including 11.5.10) and 11.0.3, 10.7 Financials, manufacturing, Planning, Distribution, in Multi-Org, TCA Architecture.
  • Extensive familiarity with Application implementation methodology (AIM) for different phases i.e. gathering Requirements, Operation Analysis, Solution Design, Build, Test, Transition, Training & Production.
  • Rich experience in Oracle Applications R12 and 11i modules
  • Oracle property management setups including flexfields, lookups, location hierarchy and System options.
  • Implemented Lease Administration, Space Management and Property Portfolio Management.
  • Defined various templates including Billing term template, Payment term template and Milestone template.
  • Integration and end to end flow with oracle applications like Oracle payables, Oracle Receivables, Oracle Projects, Oracle GL and Oracle HR.
  • Excellent knowledge in Oracle Business Flows (Procure to Pay, Record to Receipt, Order To Cash and Asset to Depreciate etc,),
  • Full understanding of the NEW Oracle 12 ledger/subledger data model
  • Full understanding of the Oracle Financials Accounting Hub (FAH) and Oracle Financial Services Accounting Hub (FSAH).
  • Oracle Grant Accounting (OGA) with funding types, Awards, projects and expenditure functionality.
  • Implemented Property Management module with integration modules AP and AR
  • Extensive Upgrade Experience in Finance Modules, Procure to Pay and Order to Cash.
  • New Feature assessment and Proof of Concepts for new versions (R12)
  • Centralized Process in R12 (Includes Legal Entity, Payment System, E-Business Tax Engine, AGIS, FAH, FSAH and Sub Ledger Accounting Engine).
  • Using R12 new functionality defined foreign currency recurring journals.
  • Implementations with larges user groups
  • Experienced in the implementation of Finance modules, Procure to Pay (P2P) and Order to Cash (O2C) business processes.
  • GL Module configuration and FSG reports
  • Punch out configuration, iProcurement/PO approval routing through AME Rules and workflow
  • Worked in a team environment with other Consultants as well as customer team leads
  • Environment included multiple Organizations and lines of business for worldwide operations
  • Actively involved in resolving pre or post-implementation problems and work around
  • Strong hands-on functional experience, sound conceptual knowledge of business processes and Oracle products, good problem solving skills and an excellent team player
  • Experience in implementing large projects right from the Initial Analysis phase to Design and Configuration, User Training and finally System Testing and Post Production Support.
  • Working knowledge DISCOVERER reporting tool
  • Expertise in using tools like TOAD, Erwin and SQL*Loader
  • Integration Tools/Products - 170 systems, Markview, OCR, Imagenow, Vertex, Paybase, STR, Data loader and Recon SMS.

Oracle Apps Versions

Oracle Applications Versions R12, 11i (11.5.10 CU2 & RU-3, 11.5.9, 11.5.8), 11.5.5 /11.0.3/10.7/10.6SC

Imp. Methods

Oracle AIM

Skills Matrix

Oracle Apps. Modules & Knowledge

Financials: General Ledger, Accounts Receivables, Accounts Payables, Cash Management, Fixed Assets and Project Accounting.
Procure to Pay: Purchasing, Supplier Scheduling, iprocurement, Account generator, AK Developer, Econtent / Catalog administration, Web Supplier, isupplier portal, iExpense, Self Service Purchasing, Sourcing, eCommerce Gateway, Accounts Payables
Order to Cash: Order Management (Order Entry, Advanced Pricing, Shipping), Inventory, Service and Core Contracts Receivables Advanced Collections and iPayments
SOPO Process - Intercompany Transactions: Order Management (Order Entry, Advanced Pricing, Shipping), Inventory, Receivables and iPayments.
Quote to Procure: iStore, iProcurement, Order Management.
Order Capture: iStore, Order Management
B2B2C: Oracle Exchange Applications, Market Models, eHubs, Sourcing, Group Purchasing, Aggregation, Auctions, Bid Awarding, Revenue Models.
Others: Alerts, Workflow, Oracle Financial and Sales Analyzer (OFSA), Vertex Quantum, System administration, Application Object Library (AOL).

Software

Oracle 7.3/8.x/8i/9i/10g, Forms 4.5/6i/9i/10g, Reports 2.5/6i/9i/10g, PL/SQL, SQL*Loader, Oracle Developer Suit 9iDS/10g, Discoverer 4i/9i, Designer 9i, VSS, Load Runner, TOAD

Programming
Languages

SQL, PL/SQL, Basic UNIX Shell Scripts

Hardware

HP-9000, Sun Sparc Workstation, Pentium PC

Operating System

Linux Itanium 2.4.9, AIX 4.2, Sun Solaris ver5.9, SCO UNIX 5.0, HP-UX, WIN2K, Windows Vista, Win 2003, Win XP, Win 98/95, MS/DOS

Project
Mgmt. Tools

MS Project, MS Office 2007 and Visio.

PROFESSIONAL EXPERIENCE:

11/08 to till date Confidential, Mountain View, CA Functional Lead
Finance and Procure to Pay (iProcurement/PO/AP/GL/GIS/FA/INV/iExp)-US & Europe

Responsibilities:

  • Working as functional lead in GL, AP, iExpenses, iProcurement, PO and FA.
  • Actively participated in Acquired company implementations in very tight schedule
  • Prepared Requirement Documents and GAPs for newly acquired companies
  • Functional flow : Procurement flow including Punchout, Capitalized Assets, Mass Additions, Catalog Bulk load and approval hierarchy
  • Functional flow : Global Intercompany Transactions, Expenses Reports using iExp, Payment batch, Electronic Payments.
  • Configured intercompany (GIS) setups
  • Configured MRC setups and created Journals with foreign currency.
  • Conducted kick off/CRP
  • Configured Finance and Procurement Modules in DEV and UAT instances
  • Integration testing with internal and external modules/applications
  • Prepared UAT plan and Test Cases
  • Acted liaison between IT implementation team and Business Super Users
  • Tracked UAT issues with solutions
  • Prepared rollout production readiness and cutover plan
  • Supported Post Go Live issues
  • Involved as functional consultant in MDM (CDH and PDH) implementation.

Environment: Oracle Applications R12 and 11.5.10 (AP, iExpenses, PO, INV, FA, GL and AIM, MS Visio, MS Project Management, Share Point, Remedy System, PVCS, Stream server, Concur, CyberSource

11/07 to 10/08 Confidential, Boston, MA Functional Lead
Procure to Pay and Finance Modules Implementation

Responsibilities:

  • Worked as functional consultant in iExpenses, Accounts Payables and Fixed Assets.
  • Prepared Project Plan for iExpenses and AP(p2p Project)
  • Track of issues log and weekly meetings
  • Prepared UAT plan and involved in UATs with large user groups
  • Conducted and prepared training sessions and training material
  • AS IS Process Documentation for Accounts Payables and Corporate Travel Group.
  • Process Definition, AISIS and GAP analysis Document for Fixed Assets
  • Month End Process for FA
  • Fixed Assets Opening Balances with ADI
  • New features assessed in R12 for GL,AP,PO and iProcurement
  • Implemented R12 finance modules and Procurement modules
  • Prepared Requirement document for FA custom reports
  • Prepared GAP analysis and Functional Design documents for iExpenses and Accounts Payables.
  • Country specific implementations for iExpenses and Accounts payables
  • Conducted Several sessions/demos with different business users like Corporate travel, Services and Finance Group for iExpenses Custom Discoverer Reports Requirements
  • Configured various payment types including Draft, ACH, Wire and Check
  • Oracle Payment has been integrated with Paybase (Check Printing), Hogan and Pep+ systems (ACH Payments)
  • Prepared Electronic invoice process design document and custom solution
  • Conducted POC for Payment process
  • Preparation of Functional Test cases and Test plan
  • Prepared Functional design documents for iExpenses Reports
  • Co ordinate with development team, Performance team and QA team
  • Reviewed Technical Design documents and QA test cases scenarios
  • Prepared Deployment cutover list

Environment: Oracle Applications 11.5.10/R12 (AP, iExpenses,170 systems, AME and Bottom line Oracle e-Commerce Gateway Oracle 10g, Sun Solaris (SPARC 32 bit), TOAD, Work flow 2.6, Oracle Discoverer , FTP, AIM Methodology, MS Project Management and MS Visio 2000.

02/07 to 08/07 Confidential, Houston, TX Functional Lead
Procurement Rollout Europe (UK, France, Germany and Benelux) and Asia

Responsibilities:

  • Worked as functional consultant in iProcurement, Purchasing Modules
  • Requirement gathering from local business users
  • Prepared GAP analysis based on requirements
  • iprocurement/purchasing configuration for all rollout countries
  • Configured Expenses account rule mapping via data loader
  • Item Categories and Catalog Setups
  • Defined Functional specs for account generator and approval matrix
  • Conducted CRP and UAT
  • Resolution of conference room pilot/UAT issues
  • Prepared test scripts with test data groups
  • Various purchase document type (Including Standard and Blanket/Contract Purchase Agreements) setup end to end flow testing.
  • Desktop receiving procedures setup
  • Integration testing iProcurement with other sub modules (PO, INV, AP and GL)
  • Prepared training guides
  • coordinated with technical team for custom program like account generator and approval workflow
  • Created new categories based on UNSPSC code
  • Prepared production cut over plan document
  • Purchase news personalization

Environment: Oracle Applications 11.5.9 (PO, iProcurement, Oracle xml gateway and Oracle e-Commerce Gateway Oracle 9i, Sun Solaris (SPARC 32 bit), TOAD, Work flow 2.6, Reports Developer 6i, FTP, AIM Methodology, EDI, MS Access, Excel, MS Visio 2000.

09/05 to 01/07 Confidential, Purchase NY Functional Lead
Oracle Application Upgrade & Enhancement Project from 11.5.7 to 11.5.10 CU2

Responsibilities:

  • Worked as functional lead in iProcurement, iExpenses, Purchasing , Oracle Contracts and Project Contract Modules
  • Defined Expense Report Template
  • Assigned Signing limits
  • Prepared new features assessment in iExpenses module
  • Import spreadsheet expenses to iExpenses
  • Define Authorization preferences
  • Configured iExpenses module
  • Prepared Gap Analysis for new modules (Sourcing and iSupplier)
  • Re structured approval hierarchy based on company new policies
  • Prepared specification for the account generator (Charge account generation) while requisition creation in iprocurement/Purchasing.
  • Prepared Current Business Baseline
  • iExenses Setup and Customize business solutions
  • Conducted Multiple CRPs to various groups
  • Credit Card interface for iexenses credit card transactions
  • Punch out configuration setups for new suppliers
  • Information templates setup and assigned to item categories/specific items
  • Prepared New Features Assessment and Impact Analysis
  • Iprocurement/PO workflow regular issues and resolution
  • Implementation of new features like 'Centralized Procurement and Self Service Transactions', Non Catalog Request templates and Category Based Accounting
  • Oracle Frame works Customizations in iProcurement
  • Different types of Purchase Orders like Blanket and Contract integration with AP
  • Bulk Catalog uploads with Contract Purchase Agreement
  • Defined Customized Preferences through Frame Works using Funcational Administrator
  • Testing all Customization and extension programs
  • Prepared Test cases and Training Documents
  • Punchout enhancements and mapping
  • XML PO Output for Punchout Suppliers
  • Provided long-term user support during and after upgrade go-live
  • Preparation of Desktop Procedures and Check list documents
  • Certification scripts for all three modules
  • Post upgrade support and Module Enhancements
  • Master Items Purge Process
  • Configured New Modules (Sourcing and iSupplier) implementation
  • Prepared and Streamlined business solutions for Project Contracts

Environment: Oracle Applications 11.5.10 (AP, AR, GL, PO, iProcurement, Oracle Contracts, Oracle Projects, iExpenses, Oracle xml gateway, Oracle e-Commerce Gateway and Cash Management Oracle 9i, Sun Solaris (SPARC 32 bit), TOAD, Work flow 2.6, Reports Developer 6i, FTP, AIM Methodology, STR, 170 Systems, EDI, MS Access, Excel, Edit plus, MS Visio 2000, Lotus notes.

03/04 to 08/05 Confidential, Functional Consultant
Responsibilities:

  • Responsible for Preparing GAP analyses, Solution design document, Asis operation analysis and mapping for financial modules including AP, iProcurement and PO.
  • Prepared Configuration and Setup documents finance modules
  • Prepared To be process documents for finance modules
  • IProcurement/PO: Reviewing and finalizing the functional and technical documents. Performing unit and integration testing
  • Oracle Cash Management: Bank statement Loader Interface. Loading the BAI2 format into oracle. It is an inbound interface. Under standing BAI2 format functional documents. Functionality mapping and elaborating the business logic to the developers
  • Prepared Period end closure process
  • Performed a different role like Responding to multiple leads and managers to resolve their solutions interfaces concern. Scheduling and driving client meetings and achieving better business solutions.
  • Prepared and executed test cases
  • Prepared End User Training Materials
  • Performed a different role like Responding to multiple leads and managers to resolve their solutions interfaces concern. Scheduling and driving client meetings and achieving better business solutions.

Environment: Oracle Applications 11.5.9 (GL, AP, AR, CM, PO), Oracle 9i, Sun Solaris 5.8, TOAD, FTP, AIM Methodology, MS Access, Excel, Edit plus, MS Visio 2000, WinSCP3 and Bugzilla.

07/02 to 02/04 Confidential, Functional Lead

Confidential, is a leading one in the banking industry. It implemented an innovative solution for its customers like Distributors and suppliers. Various clients included CEA (Chains Eastern Airlines, Maxis telecom, True telecom and Motorola).

Responsibilities:

  • Involved in System study and Business process Requirements.
  • Involved in Maintenance of the General Ledger, Oracle Payable, Purchase Order, Accounts Receivable and Order Entry modules including the setting up of a new organization and the copying of items and their balances from on organization to another via the Oracle Open Item and Open Transaction interfaces.
  • Implemented Oracle Cash Management Systems
  • Bank reconciliation between JPM bank and Oracle Financials System
  • Bank Reconciliation using various methods like EDIFACT, SWIFT940 and BAI
  • Bank Statement Mappings templates with external program
  • Set up Vendors, Payment Terms, Distribution Sets, Matching Tolerance, Approval Codes, Quick Codes, Bank Accounts, and Interest Rates. Set up Invoice Types, Payment Methods, Debit and Credit Memos, and Tax Options.
  • Defined Payable and Financials options
  • Bank Setups with custom Payment Programs
  • Defined Suppliers & Banks, Payment Terms and Distribution sets

Environment: Oracle Applications 11.0.3 and 11i, Dev2000, Java, Toad, SQL*PLUS, Windows 2000, Sun and Windows Remote Connection

05/01 to 06/02 Confidential, Singapore Sr. Consultant

Confidential, is a leading Business Technology company, offering integrated solutions, products and services. Transmarco Data Systems has established strategic alliances and partnerships with major Information Technology companies in delivering seamless solutions tailored to varying customers\' needs.

Responsibilities:

  • Business Requirement Analysis, Gap Analysis, Set ups, defining functional specs for Oracle Financials Modules include GL, AP, PO, AR and INV.
  • Inventory items, Unit of Measure and Standard notes, Automatic number generation to purchase order
  • Purchasing/iprocurement: Define Regions and attributes through AK Developer. Position approval hierarchy setup based on organization structure. Defined custom descriptive flexfields and enabled those in iprocurement using AK Developer.
  • SOP: order creation, pick release, move order transact, shipping and auto invoice and related setups like Transaction Types, Price List, Modifiers for freight and discount, credit holds and other manual holds, ship set and fulfillment sets, foreign currency sales order, drop shipment, pick rules and delivery grouping and sequence rules.
  • Accounts Receivables Cycle: Autoinvoice, AR Transaction Types, manual invoice, receipt and quick receipts, AR lockbox, setting up receivable activities, banks and receipt class Credit memos and adjustments
  • Organization Structure: Inventory Orgs, Sub-Inventory, Stock Locator and Locations
  • Item Master: Categories, Category Sets, Item Attribute Controls, Item template and Catalog Groups
  • Accounts Payables: Set up all system options and set ups Steps including Profile options.
  • General Ledger: Performed Journal Import and monitor error tracking.
  • Purchase Document Approval Process - Approval Groups and Approval Assignment
  • Designing chart of accounts, calendar & currency, Defining and assigning set of books, Setting up of Multi _Org and MRC, Defining document sequences

Environment: Oracle Applications 11.5.3/115.5, Dev2000, Toad, SQL*PLUS, Windows 2000 and Windows Remote Connection

08/00 to 04/01 Confidential, Singapore Functional Consultant

Confidential, is a global business-to-business (B2B) Internet Market place for medical supplies and equipments. It Is a Division of UNIFIZE and powered by Oracle Corporation. It Started B2B and B2C which targets many hospitals and making contacts with global Distributors and Manufacturers in Germany Asia Pacific Middle East and Italy

Responsibilities:

  • Involved As a Functional lead Consultant I Designed and Implemented the Market Models and interface processes
  • Defining Trading Partners and Administering and Operating the Exchange as a Market Player Administrator
  • Integration with iprocurement through punchout
  • Using Self-Service catalogue management uploaded and edited large catalogs in bulk through XML and Spreadsheet Templates
  • Created specific pricing lists for individual buyers
  • Defined Fee Schedules, pricing methods and billing activities for price lists
  • Managed Company and user accounts with custom functions
  • Setting up Registration Management (Bulk registrations) for the Trading Partners
  • Monitoring auctions bidding for online, Proxy bidding and Power bidding
  • Defining Private/public Market Places for Closed communities. Loading catalogues into exchange, Uploading buyer specific Price lists
  • Accounts Receivables: Designing the Billing process from OEX to Receivables. Generating the process design documents and testing

Environment: Oracle Exchange applications ver6.0 & 6.1, Oracle Apps 11i (AR, iStore, iPayment, iProcurement, CRM), Oracle 8i, Developer 6i, Oracle Application Server9i, JSP, Windows 2000, Excel, XML and TOAD.

11/99 to 07/00 Confidential, Malaysia Functional Consultant

Responsibilities:

  • Involved Date Synchronization between Oracle Financials and Siebel CRM 2000
  • Oracle Modules include Oracle Receivable, Oracle Order Entry and Oracle Inventory.
  • Performed Interfaces
  • Business Process Analysis, Initial Design, Conference Room Piloting, gap analysis, final design and setup, user training and final end-to-end testing
  • Developed control files for SQL*Loader and PL/SQL programs for loading and validating the data into the interface tables from the Legacy system
  • Designing, testing and documenting the Conversion
  • Worked on Order Import interface in OM
  • Worked on customer interface in Receivables

Environment: Oracle Financials 11.0.3 (OE, INV, AR and GL) Siebel CRM2000 Oracle 8.0, Developer 2000 and MS Access, Excel. Web Store, Windows NT 4.0, TOAD and Editplus

05/99 to 10/99 Confidential, BatuPahat, Malaysia Functional Lead

Responsibilities:

  • Gathered functional requirements, designed, developed, Implemented and tested Oracle Financials/Manufacturing modules
  • Purchasing / Inventory Flexfields - Key flex fields like System Item, Item category and Descriptive flex fields like PO Header / Line / Shipment
  • Organization Setups - Legal Entity, Operating Units, Inventory Organizations and Locations
  • Purchase Document Approval Process - Approval Groups and Approval Assignment
  • Personnel Setups - Employee and employee assignment (since HR not installed), jobs and buyers
  • Purchasing, Receiving and Financial Options - Purchasing controls, defaults, numbering, accrual method, tax default hierarchy

Environment: Oracle Financials 11.0.3 (GL, AP, AR, PO, INV, OE and AOL) Oracle 8.0, Developer 2000 and MS Access, Excel. Web Server 3.0.2, Solaris ver.2.7, Windows NT 4.0, TOAD

04/98 to 04/99 Confidential, Malaysia Team Lead

Confidential, consists of three Business Groups (Americas, Europe, and Asia). DELL Asia Pacific Computer Corporation is giving Complete Software solution for its Regional centers China, Japan, Singapore, Australia, Hong Kong, Thailand and Taiwan centers. DELL Penang, Malaysia is the Main Production center for Note-Book Computers and Desktops. Also One of the Leading Partners in the World Market

Responsibilities:

  • As a Functional Consultant implemented Oracle Financials GL, AP, AR and PO modules Involved Development, Migration and Testing
  • AP: Set up Vendors, Payment Terms, Distribution Sets, Matching Tolerance, Quick Codes, Bank Accounts, and Interest Rates. Integrating Purchase Order information with the Accounts Payables.
  • AR: Set up Invoice Types, Payment Methods, Debit and Credit Memos, and Tax Options. Developed reports and set up aging analyses.
  • PO: Defined Buyer, Vendor, Location, and Authorization hierarchies to each Group and position. Defined Purchase Options, Unit Types, Documentary Control, Security Hierarchy, Receiving Options, Requisitions, RFQ, Quotation, Purchase order, and Purchase Agreements. Developed reports, some of the reports were Report of Purchase orders, Vendor list and report of internal requisition, report of total purchases and Comparison statement of Actual with Budget.
  • Involved in Data Synchronization, migration, Conversion, customization, perform unit and integration tests.
  • Customizing the custom reports. Registering the components to responsibilities and performing Unit Tests.
  • GL: Unit tests in all the schemas on Dell Daily rates Interface and Dell MRC reconciliation Report.
  • ALERTS: Creation of various Oracle Alerts to inform internal users of certain events (e.g., pending Orders Imported via EDI).
  • Apps 10.7 to 11.x Migration: Migrating Components using Chain link. Regenerating and modifying custom Reports and performing unit testing. Data Migration and unit testing in all the Schemas for PO Module. Using Ms Access and processing validated data, Making Excel spread sheets and Data loading.

Environment: Oracle Financials 11.0.3 (GL, AP, AR, PO and AOL) Oracle 8.0, Developer 2000 and MS Access, Excel. Web Server 3.0.2, Solaris ver.2.7, Windows NT 4.0, Chain link, TOAD, Load Runner 6.0

02/96 to 03/98 Confidential, Hyderabad India) Functional Lead

Highway Automation System is a sophisticated system that monitors the movement
the vehicles and people round the clock. HAS is a unique concept of networking all major national
of around 32,000 km and important state highways across the length and breadth of the country

Responsibilities:
Contributed towards the Financial Accounting and analysis of the Project carried on trough Oracle
Applications (Oracle Financials) by implementing and operating the modules GL, AP, AR, PO, FA, AOL and SYS AD with particular emphasis on the intricacies relating to Oracle Receivables and Oracle Order Entry

Environment: Compaq Windows NT, Oracle Applications, Developer 2000, PL-SQL.

07/95 to 01/96 Confidential, Hyderabad, India Developer

Responsibilities: Developed Inventory Control System. Involved in Designing, Development and Support Designed the modules to monitor Inventory system of the Organization Maintaining the status of the raw material Designed and Developed the ABC analysis also Safety stock maintenance. Functional testing and brought the system up to UAT.

Environment: WindowsNT, Oracle 7.x, Developer 2000 Forms 3.0, SQL Report writer.

Education:
Masters in Business Administration (MBA)
Masters of Commerce (M.Com)
Bachelor of Commerce (B.Com)
Post Graduate Diploma in Computer Applications (PGDCA)

References: References will be provided on request.

We'd love your feedback!