SUMMARY

• More TEMPthan 8 years of experience as consultant in Oracle ERP Implementations, Upgrades and support mainly inGeneral 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 wif 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 wif multi currency business environment.
• Experienced in ERP Applications & Client Server Technologies, along wif 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 wif GL, Accounting Setup Manager, Inter Company Accounting and MOAC.
• Experience in all phases of teh 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 teh Functional solutions to teh 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 wif 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 wif users during requirements gathering, solution designing, solution build, testing and production support.
• Excellent interpersonal communication and knowledge management skills displayed during communication wif client, planning and review meetings and during various trainings in all phases and levels of teh 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 teh 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: Teh process of procuring material from teh organization and getting paid for teh process of handling material. This process picks teh PO’s, which have AP invoice option defined in DFF and create Requisitions and creates against teh Supplier.
• Gross Sales Report, Report displays teh 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 teh GL Accounts for AP Invoice Payments.
• Defined teh setups required for Auto Reversing, Auto Posting and for scheduling teh 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 teh business requirements.
• Identified RICE components according to teh client needs.
• Involved in teh setup of inter-company balancing and global inter-company system.
• Designed and created reports for client using teh FSG.
• Define State, County, City, Tax Regimes, Tax, Tax Rates and Tax Rules in eBusiness Tax module.
• Defined setup steps of teh 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 wif Oracle Payables, Advanced Collections and Oracle Receivable.
• Configure System Options in CE.
• Configured Oracle Payments wif 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 teh 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 teh functional design documents to explain teh functionality of teh custom concurrent programs in Oracle Costing application by analyzing teh PL/SQL programs.
• Configured GCS (Global Consolidation System) to consolidate balances from Foreign Ledger wif Parent company Ledger.
• Configured AGIS to handle their inter-company transactions along wif defining intra-company rules.
• Involved in configuration of CRP1, UAT and test instance.
• Conducted CRP 1, CRP2, CRP3 and tested all teh setup.
• Involved wif 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 teh 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 teh 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 wif bank statement in Cash Management.
• Activation of various flex fields in teh forms to gather teh additional information.
• Participated in testing, user accepting testing in test instance and worked wif 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 wif multi-currencies.
• Involved in set up for consolidations and customizing FSGs and generating reports using RXi Reports tool along wif 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 teh employees, setting up of buyer and creation of requisitions, RFQ, quotations, and PO (purchase order).
• Customized teh PO Requisition Approval workflow to add custom approvers, additional validation, derivation and verification depending upon teh 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 teh Purchase requisition and auto creation of a standard purchase order based on a quote and generated receipt.
• Customized teh Print Purchase Order Report based upon user requirements and added bitmap image of company logo to teh 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 wif default approval routing hierarchies.
• Acted as a liaison between teh client and technical team to enable product development wif 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 teh project and coordinated wif business and technical team for implementation, production support, and training and maintenance activities.
• Performed end-to-end functional and technical aspects of teh 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 wif 11i.
• Customized teh 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 teh 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 teh time of Order Entry and develops a CUSTOM form to display all teh 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 teh 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 teh 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.