SUMMARY

• More than 8 years of experience as consultant in Oracle ERP Implementations, Upgrades and support mainly in General Ledger, Account Payables, Account Receivables, Fixed Assets, Cash Management, Purchasing (PO), Inventory (INV) and Order Management (OM)modules. Well experienced in identifying Gaps & developing Custom components as per business requirements.
• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle E - Business Suite.
• Four full lifecycle Implementations R12 with GL, AP, AR,FA,CE,iProcurement, iReceivables, iExpenses, E-business tax and Sub ledger Accounting (SLA).
• Implemented full life cycles of Oracle E Business Suite Applications in Financial area having globally operatedMulti Organization, Intercompany, Multiple Legal Entities and Multi interfaces with multi currency business environment.
• Experienced in ERP Applications & Client Server Technologies, along with Development, Testing, Support, Upgrade and Tuning of Oracle Financials, Oracle Manufacturing, Oracle Purchasing, Order Management and Sales.
• Solid understanding of integration of Oracle Applications modules,Multi Org, Reporting Currencies Setups, Chart of Accounts, FSG, Budgets and Flex fields.
• Good Exposure to Reconciliation of Sub-Ledger modules with GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Experience in all phases of the Software Development Life Cycle (SDLC) in an ERP environment.
• Good experience customizing and personalizing approvals using Oracle Approval Management (AME).
• Implemented and tested complete Order to cash (O2C), Procure to Pay (P2P) cycle.
• Designed solutions to enhance standard oracle flows for Order to Cash (O2C), Procure to Pay (P2P), Assets to GL, Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Experience in using Oracle AIM (V.3.0) of project implementation methodologies particularly Gather Business Requirements (BR.100), Functional Documents (MD.50), Data mapping conversions (CV 040) deliverables and Test Cases (TE.40) for GL, AP, AR, FA and CE modules.
• Hands on experience in implementing RICE (Oracle Reports 6i/Forms 6i, Interfaces, Conversions, Extensions) components, workflows, Oracle Alerts, Lookups, OA Framework (OAF), XML Publisher Reports.
• Designed the Functional solutions to the Key Gaps through Interface, Extension, Customization and Reports.
• Good Technical Knowledge on SQL, PL/SQL, Forms and Reports using for Inbound, Outbound, Extensions and Reports.
• Well experienced with Application Tools TOAD, SQL Developer, Data loader, ADI & Web ADI.
• Extensive knowledge on oracle application views, base tables, oracle discoverer reports, XML reports and workflow used for troubleshooting and resolution of production issues.
• Worked closely with users during requirements gathering, solution designing, solution build, testing and production support.
• Excellent interpersonal communication and knowledge management skills displayed during communication with client, planning and review meetings and during various trainings in all phases and levels of the computing industry.
• Strong analytical, diagnostic and troubleshooting skills and ability to work in a fast-paced and team-oriented environment. Strong analytical, innovative and leadership qualities.

TECHNICAL SKILLS

ERP Modules: Oracle E-Business Suite Versions 12i/ 11.5.10/11.0.3 Account Receivables(AR), Purchase Order(PO), Fixed Assets(FA), Account Payables(AP),General Ledger(GL),Cash Management (CM),Order Management (OM), Inventory(INV),Application Object Library(AOL), Work In Process (WIP), Material Resource Planning (MRP), Flex fields, TCA, CRM, Service Contracts, Service Fields, SYSADMIN, INSTALLBASE.

Self Service: iexpense, iprocurement, ireceivables, isupplier, iassets.

Applications Tools: Toad, SQL * Loader, PL/SQL Developer, Discoverer, BI/XML Publisher, Load Runner.

Programming Languages: SQL, PL/SQL, C, C++, Java, HTML5, PHP, UNIX Shell Scripting.

Database: Oracle 9i/10g/11g, Microsoft SQL Server 2010, MS Access.

Operating Systems: Windows 98/2000/NT/XP/7/8,UNIX (Solaris, HP-UX), Linux.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Oracle Finance Functional Consultant

Responsibilities:

• Conducted business analysis, requirement gathering, and identification of Gaps and providing solution in terms of workarounds and customizations.
• Conducted user training and coordinated in performing user acceptance testing.
• Preparation of test scripts and well documented user procedure manuals.
• Set up Chart of Accounts and Set of Books in multi-org environment.
• Setup cross validation, security rules, and recurring journal entries.
• Defined and maintained Key Flex Fields in General Ledger and AP.
• Defined new responsibilities, menus, hierarchies, security rules and approval groups for users. Also included, restricting users access to certain forms and form functions using function security.
• Performed end-to-end functional and technical aspects of the project including gathering requirements, gap analysis and feasibility study, process mapping, functional setups, data migration, system design, testing and deployment.
• SetupiExpenseto enable project expense reports, Setup auto accounting foriExpensesrelated expense types, and expense templates.
• Conducted CRP, UAT and training for end users and production support.
• Performing Business Requirement Study in Financials and modeling Future Process Model and preparingAS-IS (BP040)andTO-BE (BP080)documents.
• PreparedRD020, BR100, TE040(Test Scripts) and End User Training Manuals.
• Forms and Reports Customization to provide functional specifications to technical team.
• Redesign Cash Management and Payments Business Processes and IT operations for Retail and Commercial Banks.
• Automatic bank statement reconciliations, Cash pooling, Cash forecasting and Cash positioning.
• Performing period-end processing forOracle Cash Management.
• Custom P2P (Procure to pay) Process: The process of procuring material from the organization and getting paid for the process of handling material. This process picks the PO’s, which have AP invoice option defined in DFF and create Requisitions and creates against the Supplier.
• Gross Sales Report, Report displays the Order Information, AP and AR Invoices, Customer/Supplier Information, Invoice amount details, Trips and shipment information.
• Developed custom Intercompany and Back2Back invoicing solution and also setup Auto Accounting rules.
• Worked on journal import interface program to import journal data from legacy system into GL base tables.
• Worked on Auto Lockbox Open interface for automatic processing of receipts in AR module.
• Configured Payables Financial Options for defaulting Accounting Information on AP Invoices distributions.
• Defined Banks for processing Suppliers Invoice Payments and to default the GL Accounts for AP Invoice Payments.
• Defined the setups required for Auto Reversing, Auto Posting and for scheduling the Transactions.
• Involved in functional setups for AR revenue recognition process and month end reconciliation process of Revenue recognition unearned revenue between AR and GL.
• Vendor Import and set up banks, cash accounts and tax codes for AP.
• Developed several custom Oracle Reports for invoice printing, consolidated billing, reconcile between AR Adjustments and GL adjustment account (between sub-ledger and ledger), to print multiple currencies for a given PO transaction.

Confidential, Green Bay, WI

Oracle Functional Consultant

Responsibilities:

• Defined Business requirements for Oracle GL and AR, involved in identifying GAPS.
• Configured multi-org business structure in Oracle, Ledger Setup, Legal Entity, Establishment Setups and MOAC security.
• Set up Multi-Currency environment.
• Created Customized responsibilities, customized menus, customized request groups.
• Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.
• Prepared Functional Design documents for iExpenses and Accounts Receivables.
• Setting up of E Business Tax and SLA as per the business requirements.
• Identified RICE components according to the client needs.
• Involved in the setup of inter-company balancing and global inter-company system.
• Designed and created reports for client using the FSG.
• Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module.
• Defined setup steps of the AR module. These included System Options, Receipts, Lockbox, Quick Codes and Taxes. Exemptions were defined, as products were not subject to tax in all states.
• Performed general Payables setups like Financial Options, Payables Options, Banks & Bank Accounts, Supplier, Supplier Sites, Payment Terms and Profile Options and Payment setups like Payment Format, Payment Process Profile and Internal Bank Payable Documents.
• Customizing and personalizing approvals using Oracle Approval Management (AME).
• Developed Customer API in Oracle Receivables.
• Integrating iPayments, iCollections,iExpenses and iRecevables with Oracle Payables, Advanced Collections and Oracle Receivable.
• Configure System Options in CE.
• Configured Oracle Payments with various credit card payments.
• Develop customization for Re-authorization for various credit cards.
• Creating Credit Card receipt class and Credit card payment method to do authorization and settlement from Oracle Order Management and Oracle Receivables for AMEX, Visa, Master Card and Discover.
• Configured the Sub ledger Accounting (SLA) setups.
• Created BR.100 Application setup and CV.040 Conversion data mapping documentation for GL, AR, SLA (Sub ledger Accounting).
• Prepared the functional design documents to explain the functionality of the custom concurrent programs in Oracle Costing application by analyzing the PL/SQL programs.
• Configured GCS (Global Consolidation System) to consolidate balances from Foreign Ledger with Parent company Ledger.
• Configured AGIS to handle their inter-company transactions along with defining intra-company rules.
• Involved in configuration of CRP1, UAT and test instance.
• Conducted CRP 1, CRP2, CRP3 and tested all the setup.
• Involved with study of existing system, preparing theBRD100/Functional (MD50),Technical (MD70)design document and Conversion Data Mapping Document(CV40)to extract data from legacy system into Oracle Applications openinterface tablesand for implementation of GL and AR.
• Analyze, Design and Develop Accounts Receivables Auto Invoice Interface. This involved data mapping and developing Conversion programs for converting Invoices, Credit Memos, Debit memos usingPL/SQLscript.

Environment: Oracle Applications (OM, PO, FA, GL, GA, AP, AR), Workflow Builder, SQL * Loader, PL/SQL, Developer 2000/6i, JDeveloper, XML Publisher, TOAD.

Confidential, Durham, NC

Oracle Functional Consultant

Responsibilities:

• Acted as liaison between client and development team for product development as per requirements.
• Participated in multiple business meetings for Fit-Gap Analysis and Solution.
• Setting up of Cross Validation Rules, Setting up of Security Rules in GL and Assigning to different responsibilities.
• Assisted functional lead analyst to conduct CRP1 and CRP2.
• Prepared BR.100 Application setup and MD.50 Application Extensions Functional Design documents according to AIM.
• Involved in configuration of CRP1, UAT and test instance.
• Trained Super Users and troubleshooting during UAT (User Acceptance Test).
• Used the System Administrator responsibility to define users and assign responsibilities and set profile options.
• Performed general Payables setups like Financial Options, Payables Options, Banks & Bank Accounts, Supplier, Supplier Sites, Payment Terms and Profile Options and Payment setups like Payment Format, Payment Process Profile and Internal Bank Payable Documents.
• Define Organization Structure (MOAC), Users and Responsibilities, Security Profiles and Flex Fields.
• Involved in setup for Payables, Inventory, Purchasing, General Ledger based on deep understanding of the functional processes.
• Design & Develop FSG reports in GL.
• Set up AP bank accounts, bank documents, bank codes and expense report templates.
• Defined profile options to specify certain implementation parameters.
• Set up Recurring journals template, recurring journals and Auto-reversal in GL.
• Set up suppliers, locations, and purchasing quick codes.
• Setup payment terms, invoice distribution, matching of invoices against PO.
• Configure Financial Options and Payables Options in AP.
• Created custom Customer invoice print templates.
• Configure System Options in CE.
• Worked on Cash forecasting, reconciliation, Cash pool and Cash positioning.
• Reconcile AP with bank statement in Cash Management.
• Activation of various flex fields in the forms to gather the additional information.
• Participated in testing, user accepting testing in test instance and worked with certain key super users.

Confidential, Reno, NV

Oracle Functional Consultant

Responsibilities:

• Conducted Business Process Review (BPR) and GAP analysis to determine business requirements and prepared documentation accordingly.
• Implemented General Ledger (GL) by defining chart of accounts, calendars (Accounting & Transaction), currency types, conversion periods, conversion rates, flex fields and values sets to deal with multi-currencies.
• Involved in set up for consolidations and customizing FSGs and generating reports using RXi Reports tool along with month end close processes for GL and sub-ledgers.
• Implemented Purchasing (PO) module by setting up organizations, inventory organizations, locations and customers, buyers, payables options and purchasing options.
• Implemented Procure to pay cycle: created the employees, setting up of buyer and creation of requisitions, RFQ, quotations, and PO (purchase order).
• Customized the PO Requisition Approval workflow to add custom approvers, additional validation, derivation and verification depending upon the business needs.
• Worked on setups in Purchasing in assigning approval assignments, approval groups, and approval hierarchy.
• Created organizations, inventory items, catalog RFQ, got approval from supplier in procure to pay cycle and customized the Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.
• Customized the Print Purchase Order Report based upon user requirements and added bitmap image of company logo to the report.
• Provided online user training, created user manuals and best practice proposals for purchasing modules.
• Performed buyer set up to facilitate PO creation and approval process by defining various approval groups and approval limits with default approval routing hierarchies.
• Acted as a liaison between the client and technical team to enable product development with a close fit to client requirements.

Environment: 11i Purchasing,Project Costing, Project Billing, Internet Expenses, Project Oracle Time & Labor, Accounts Payables, General Ledger, Accounts Receivables.

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Provided post-implementation support and maintenance of two ERP implementations Month, Quarter and Year-End closures.
• As a Techno-Functional Lead was involved across all modules in the project and coordinated with business and technical team for implementation, production support, and training and maintenance activities.
• Performed end-to-end functional and technical aspects of the project including gathering requirements, gap analysis and feasibility study, process mapping, functional setups, data migration, system design, testing and deployment.
• Involved in Oracle 11i system configuration for functional setups of AR, AP, FA and GL.
• Developed custom Intercompany and Back2Back invoicing solution and also setup Auto Accounting rules.
• Involved in functional setups for AR revenue recognition process and month end reconciliation process of Revenue recognition unearned revenue between AR and GL.
• Vendor Import and set up banks, cash accounts and tax codes for AP.
• Developed several custom Oracle Reports for invoice printing, consolidated billing, reconcile between AR Adjustments and GL adjustment account (between sub-ledger and ledger), to print multiple currencies for a given PO transaction.
• Implemented Auto lockbox feature for cash applications.
• Design of Tax Interface (Vertex) process with 11i.
• Customized the consolidated invoicing feature and developed a custom report to print consolidated invoices based on PO number and location for a given customer.

Environment: Oracle Applications 11i (OM, PO, FA, GL, GA, AP, AR), Workflow Builder, SQL * Loader, PL/SQL, Developer 2000/6i, JDeveloper, XML Publisher, TOAD.

Confidential

Oracle Techno-Functional Consultant

Responsibilities:

• Involved in the Back to back orders setups.
• Involved in attending training sessions on OM, PO, BOM and INV in 11i.
• Developed many inbound/outbound interfaces using Oracle Standard APIs for Pricing Modules and Order Import Processes.
• Involved in adding new descriptive flex field in Order Management to capture additional data.
• Customization to display credit holds description at the time of Order Entry and develops a CUSTOM form to display all the information about credit check at one place.
• OM Customization - Forms Personalization for Related Item Price and Quantity.
• Workflow customization to auto creates PO for Low Value requisitions.
• Developed conversion to load AR Invoices from MAB to oracle.
• Prepared Requirements Specifications, Technical Design Document and Test plans for the requirements based on Client interaction.
• Onsite Co-ordination in Analysis, Design, Coding and Testing.
• Customized Cancelled Sales Order Report.
• Tuned SQL statements using HINTS and appropriate indexing and Re-organizations of tables to improve the performance.
• Developed AP Invoice by Source, Checks reports using Discoverer.

Environment: Oracle APPS 11i (AR, OM, QP, PO, AP, Alerts), Developer 2000, PL/SQL, SQL*Loader, Workflow, TOAD and UNIX.