SUMMARY

• Over 6+ years of Professional experience as an Oracle Financial Functional Consultant using Oracle Applications (11i and R12) with Strong analytical skills in Finance Modules.
• Over 6+ years of extensive experience as Oracle Financial Functional Consultant in full life cycle implementation of Oracle 11i/R12 applications and business process analysis, evaluation and integration of internal systems, postproduction support and training to the users.
• Proficient full - fledged End-to-End Implementation, Upgrade, Enhancement and Support projects in Oracle EBS 11i/ R12 Implementation, Configuration and supporting Oracle Applications 11i/R12
• End-end working knowledge of the Procure-to-Pay (P2P) and Order to Cash (O2C) Cycles.
• Competent in understanding the functionality of the core Oracle Financial modules (GL, AP, AR, FA, CE, AGIS, PO) and their interplay in the overall accounting structure of an organization.
• Worked and managed successfully many Full Life Cycle of Software & Business Projects involving Requirement Analysis, Data mapping, High level Design, Low level Design, Presentation Layer, Prototyping, Designing, Developing, Code Reviews, Testing, Implementing, Deploying, Documenting, Maintaining and client/user interaction.
• Functional responsibilities: Interfacing with users, requirements gathering, functional gap analysis, application design, configuration, module setup, test script generation, writing training guides, training end users, and production support.
• Experience in Data mapping from the external source files with oracle EBS columns across the financial modules during interface development and conversions.
• Gap Analysis - using AIM template BR-010 High Level Gap Analysis document
• Preparation of process documentations, training materials & user trainings like BR100, MD50, etc. using Application Implementation Methodology (AIM).
• Business process analysis, requirement analysis, gap analysis, system mapping, CRP testing, system configuration, data conversions, master data loading and production go-live support.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Excellent troubleshooting and problem-solving skills and Quality assurance
• Knowledge on Sub Ledger Accounting (SLA), for managing accounting across Subledger transactions to generate accounting entries and customization of derivation rules as per the requirements.
• A team player who also can work well independently.
• Extensive experience creating SRs with Oracle Support, coordinating and following on multiple issues based on priority including identifying bugs and follow-up, as well as conducting OWC sessions with Oracle Support Team.

TECHNICAL SKILLS

ERP Solutions: Oracle Application Release 11.5.9/11.5.10.2/ R 12.0.6/12.1.3

Programming Languages: C, SQL, PL/SQL

Modules: GL, AP, FA, CM, PO, AR, HCM, HR, Payroll iExpense, EB-Tax, iProcurement, iSupplier, AGIS, PA, OM, Inventory, Shipping, Advanced Pricing, SLA, AOL

Database: Oracle 9i/10g/11g, SQL server

Operating Systems: HP Unix, Windows 2003, XP, 2007, 2008

Other Tools: Toad, SQL Loader

Documentation tools: MS Office, MS Visio, Power Point

PROFESSIONAL EXPERIENCE

Confidential - San Jose, CA

Oracle Financial Functional Consultant

Responsibilities:

• Implemented Oracle Project Suite (Project Management, Project Costing, Project Billing)
• Analyzed the business processes, requirements, mapped with Oracle features, conducted Gap Analysis.
• General Ledger (GL):
• Did GL Setups: Defined Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledger, Profile Options, Journal Sources, Consolidation Setups, Calendar. Configured Multi-Organization Structure
• Account Receivables (AR): Setups for TCA Architecture, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets.
• Advanced Collections: Setup Collectors, Tasks, Transaction Delinquencies, Dunning Plans, Collection Strategies, Dunning Letter, Universal Work Queue, Promise to Pay details, profile options, Aging, Scoring etc.
• Accounts Payable (AP): Functional analysis and setup and configuration of AP. Defined Financial and Payable options, defined descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching. Defined Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and schedule recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, Invoice distributions, Invoice validations and holds, Recurring Invoices, and Invoice-aging report formats. Set the profile options for AP.
• Setup 170 systems to scan FAXed, Emailed AP Invoices and placed the data into staging tables and later into interface tables to create the AP Invoices.
• Automated payments from Oracle to all banks for all payment types: ACH, checks, Wires and Positive Pay Files. iExpense: Defined Accounting Flex field, updated Internet Expense Messages, defined Contact Information and Global Policy Information, defined Employees, Security Profiles, System Profiles, Payable Lookups, Expense Clearing Account, Expense Report Options, Enabled auto Tax Calculation, Tax Code Default Hierarchy, defined Expense Report Templates, Establishing Corporate Credit Cards and Oracle Internet Expense Setup.
• Integrated Confidential credit card expenses into iExpenses.
• Purchasing (PO): Setup like Document Types, Line Types, Approval Groups and Assigned Approval Assignments to the Jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc. and successfully created PO’s, Receipts, etc.
• Implemented Blanket Purchase Agreements, Contract Purchase Agreements.
• Cash Management (CM): Cash forecasting & Cash positioning with individual bank details, define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping.
• FAH: Integrated ADP payroll third party application to load journals into GL using FAH. Did setups Subledger Application, Event Model, Process Categories, Even Class options, Journal Line Types, Account Derivation Rules, Journal Line Definitions, Application Accounting Definition, subledger Accounting methods etc.
• Maintained the regular interaction with the client, end-users, technical team, and participated in meetings on regular basis and followed up the progress of work.
• Tested the interfaces, reports, and processes to ensure that all the functionalities are working correctly.
• Worked with the users and businesspersons in designing and defining the new reports and customizing the existing ones.
• Coordinated set up activities in UAT and production environment of all the modules.
• Supported the Subject Matter Expert (SME) in Financial modules and business process.
• Post production support (L2/L3), creating tickets with oracle support, issue monitoring, log monitoring, etc.
• Expert in SQL, workflow processes.
• Fixed Assets (FA): Configuration of FA module with custom setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal entries and posted in GL, defined Asset Categories, Location & Key Flexfields, Depreciation Methods, Corporate books, Tax Books, etc.

Environment: Oracle Financial Applications 11i/R12 (12.2.4) AP, AR, GL, FA, CM, OM, PO, iExpense and iProcurement, iPayment: Creating iPayment Administrator, Security Management, Payment System, Payee, Risk Factors, Routing Rules and setting up of Profile options.

Confidential

Oracle Financial Functional Consultant

Responsibilities:

• Gathering of user requirements, business rules and processes, mapping and performance of Gap Analysis and suggest customizations, obtaining signoffs and developing prototype are my present responsibilities besides Configuration and Implementation of Financial Modules.
• General Ledger (GL): Configured Set of Books and Chart of Accounts, set up cross-validation rules and flex field segments. Defined journal sources, journal categories, translation of balances from subsidiary units for reporting purposes and consolidation. Defined system controls and set the profile options for GL and created Sub Ledgers. Configured multi-organization structure chart of accounts and embedded to GL.
• Purchasing (PO): Setups like document types, line types, approval groups and assigned approval assignments to the jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc and successfully created POs, Receipts, etc.
• Account Receivables (AR): Setups for TCA Architecture, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets.
• Cash Management (CE): Cash forecasting & Cash positioning with bank wise details., Define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping.
• Accounts Payable (AP): Functional analysis and setup of AP. Defined Financial and Payable options, defined descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching. Configured Vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and scheduled recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined Pre-payments, Expense detail report formats, Invoice structure with taxes, Invoice distributions, Invoice validations and holds, Recurring Invoices, Invoice-aging report formats. Set the profile options for AP. iExpense: Define Accounting Flexfield, updated iExpense Messages, defined Contact Information and Global Policy Information, defined Employees, Security Profiles, System Profiles, Payable Lookups, Expense Clearing Account, Expense Report Options, Costing parameters, Enabled Auto Tax Calculation, Auto Tax Calculation, Tax Code Default Hierarch, defined Expense Report Templates.
• Fixed Assets (FA): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL., Define Asset Categories, Location & Key Flexfields, Depreciation Methods, Corporate books, Tax Books, Security by Book feature etc.
• OM (Oracle Order Management/Pricing, Shipping): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules, and Successfully created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Validated data after uploading using Mass Additions Interface and ran necessary reports.
• Involved in creating Users, Responsibilities and the document sequence and categories for all the modules.
• Business Process Re-engineering of Requisition to Purchasing flow approvals in accordance with Controllership business criteria
• Experienced with iExpenses and iProcurement.
• Involved in Troubleshooting with the issues in Financial Modules while supporting Finance them, troubleshooting various issues relating to performing the month and quarter close.

Environment: Oracle Financial Applications R12 (AP, OM, AR, GL, FA, PO, iPayment, iProcurement, Inventory).

Confidential

Oracle Financial Functional Consultant

Responsibilities:

• Gathering of User Requirements, Business Rules and Processes, Mapping and Performance of Gap Analysis and suggest Customizations, obtaining signoffs and developing prototype are my present responsibilities.
• Prepared various AIM documents like BR100 and MD50.
• Experienced with iExpenses and iProcurement.
• General Ledger (GL): Designed Set of Books, built chart of accounts, set up cross-validation rules and flex field segments. Defined journal sources, journal categories, Translation of balances from subsidiary units for reporting purposes and consolidation. Defined system controls and Set the profile options for GL, and created of Sub ledgers.
• Account Receivables (AR): Setups for TCA Architecture, DQM, Customer Profiles, System Options, TAX Codes, Sales Tax rates, Transaction Types, Sources, Accounting Rules, Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges, Lock Boxes, Transmission Formats, Collectors, Aging Buckets.
• Accounts Payable (AP) Functional analysis and setup of AP. Defined Financial and Payable options, descriptive flex fields for additional information for vendors details and invoice transactions and provided solutions for invoice matching, defined vendors Banks, sites, quick codes and Interest invoices. Defined payment terms, distribution sets and scheduled payment lines. Set up and scheduled recurring payables for invoices paid on a regular basis and automatically remind staff to process recurring payables. Defined prepayments, Expense detail report formats, Invoice structure with taxes, invoice distributions, invoice validations and holds, Recurring Invoices, Invoice aging report formats. Set the profile options for AP iExpense: Define Accounting Flexfield, updated Internet Expense Messages, defined Contact Information and Global Policy Information, defined Employees, Security Profiles, System Profiles, Payable Lookups, Expense Clearing Account, Expense Report Options, enable Auto Tax Calculation, Tax Code Default Hierarch, defined Expense Report Templates, and Costing parameters.
• Fixed Assets (FA): Setups for Asset Category, Location Flex fields and Values, Asset Keys, Additional Fiscal Years, Profile Options, Creating Mass Additions, Posting Mass Additions, Full Asset Retirement Setup, Partial Asset Retirement Setup, Depreciation Setup, etc. and successfully created the Journal Entries, and posted Journal Entries in GL., Define Asset Categories, Location & Key Flexfield, Depreciation Methods, Corporate Books, Tax Books, Security by Book feature etc.
• Oracle Order Management/Pricing, Shipping (OM): Setups for Document Categories, Document Sequences, Parameters, Transaction Types, Quick Codes, Credit Check Rules, Credit Profiles, Payment Terms, Price Lists, Pricing Agreements, Modifiers, Shipping Parameters, Freight Carriers, Shipment Transit Times, Pick Slip Grouping Rules, Release sequence rules and created Orders, Attached pricelists, Pick released, Ship confirmed and transferred Order Information into Account Receivables (AR).
• Purchasing (PO): Setup like Document Types, Line Types, Approval Groups and Assigned Approval Assignments to the Jobs, Purchasing Options, Receiving Options, Financial Options, Lookup Codes, Payment Terms, etc and successfully created POs, receipts, etc.
• Involved in creating Users Responsibilities and the document sequence and categories for all the modules.
• Involved in troubleshooting with the issues in Financial modules while supporting Finance team, troubleshooting various issues relating to performing the Month and quarter close.
• Coordinated with End-User for closing procedures

Environment: Oracle Financial Applications R12, AP, AR, GL, FA, CM, OM, PO, iExpense and iProcurement.

Confidential

Oracle Apps Support Consultant

Responsibilities:

• Worked as an Asst. Functional Analyst for Oracle management, Receivables, Inventory.
• Assisted in configuration and implementation of Financial Modules.
• Studied and evaluated functionalities of various modules.
• Prepared Setup documents (BR100) for OM & Accounts Receivable.
• Configured Financial Statement Generator (FSG) Reports for financial reporting by defining Row Set, Column Sets and Content Set.
• Prepared functional Design Documents for application extensions and conversions (MD.050).
• Handled post go-live user support.
• Involved in setting up meetings with Business users to gather requirements information.
• Production support - month-end reconciliation, interface issues, support enhancements, ad-hoc reports, bug fixes.Issue resolution usingOracleSupport, creation and follow up of Service Request withOracle.
• Review and Resolve Reconciliation between sub-ledger and general ledger.
• Assist in new users in understanding the modules and other day to day activities
• Periodic User Training for all employees.
• Level1 Support to All financial users.
• Responsible for diagnosing the root cause analysis of the support issues observed to avoid reoccurrence of such issues in the future
• Functionality of Revenue recognition has been configured by setting up the organization wide policies in revenue management and in specific cases configured the rules for specific customers/customer classes.
• Provided hands on training to business user community for Post- Production support issues & daily and month-end closing of accounting periods for GL.
• Setting up system for foreign currency translation and re-evaluation performing financial consolidation of multiple currency set of books.

Environment: Oracle Applications 11i - (GL, AP, AR, CM, INV, Purchasing), Oracle 10g, SQL, TOAD.