SUMMARY

• Over 10+ years of experience as an Oracle Applications Functional, Techno - Functional Consultant with experience in designing, developing, implementing supporting and Testing Oracle ERP P2P modules and O2C custom solutions.
• Strong experience in various versions of Oracle Applications such as R12, 11i. Experienced in 5 full life cycle implementations from requirements gathering to post production.
• Experience in Procure to Pay cycle Purchasing, Account Payables, Fixed Assets and System Administrator.
• Rich Experience in Order to Cash Cycle Order Management, inventory, Accounts Receivables, Cash Management, General Ledger and Trading Community Architecture.
• Proficient in the concepts of Multi-Org, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Good Knowledge in Revaluation, Translation and Consolidation process. Experience and good understanding of R12 modules new concepts like Sub-Ledger Accounting (SLA), Accounting Setup Manager, configuration of security controls using Multi-org Access Control, Data Access Sets, Definition Access Sets.
• Designed and implemented iProcurement. Tailored many web pages to accommodate business requirements. Developed new LOVs for the accounting structure. Prepared setup and test documents.
• Experience in setting up eBuisness Tax module to capture requirements of US Sale and Use Tax and EMEA VAT.
• System administration skills include defining request groups, responsibilities, and users, assigning responsibilities to user setup of profile options and maintaining concurrent programs.
• Good knowledge on System administrator tasks like creating menu, function. Helped developer team to perform system administration tasks like register executable and concurrent programs
• Perform customization in system administration responsibility to create new profile options and making the report output available to all uses.

TECHNICAL SKILLS

ERP Application: Oracle Release 12 and 11i Financials Modules covering General Ledger (GL), Report Manager, Accounts Payables (AP), Payments Setup Administrator (IBY), Accounts Receivables (AR), Revenue Manager, Fixed Assets (FA), Cash Management (CE), E-Business Tax (EBT) and also System Administrator.

Integration knowledge with: Supply Chain Modules covering Purchasing (PO), Inventory (INV), Order Management (OM) and Cost Management - SLA (R12).

Self Service Modules: iProcurement, iSupplier, iExpense

Tools: & Utilities: User Productivity Kit (UPK), Application Desktop Integrator (ADI), Web ADI, TOAD, Data Loader, Microsoft Office (Project, Visio, Excel, Word & Power Point.

PROFESSIONAL EXPERIENCE

Confidential, Los Angeles, CA

Lead Oracle Apps Functional consultant

Responsibilities:

• Implementation of Oracle Financials 12.1.3. Responsible for configuring Purchasing, I-procurement, I-expense, I-supplier and Sourcing.
• Responsible for creating baseline document, Business requirements documents and functional specifications document.
• Perform System administrator task customizing the messages for PO modules. Changed sourcing email template messages in System administrator.
• Used Data loader scripts in Users and Responsibilities in System administrator. Responsible for configuring the AME approve rules.
• Developed custom solution for requisition approval. Upload imaged using bulk upload. Managed Team for 5 people. Worked on offshore Model.
• Performed production support activities for Australia and New Zealand.
• Automated Invoice Interface as a part of production support.

Confidential, Santa Clara, CA

Lead Oracle Apps Functional consultant

Responsibilities:

• Responsible for Consolidation implementation in GCS. Responsible for developing 180 Allocation rule. Implementation of Journal Approval.
• Create Cross validation Rules. Defined Revaluations and trained user on it. Trained users on translation, Consolidation and Data load.
• Create project plan for cut over activities. Managed in house team. Update menus and function for the responsibilities in System administrator responsibility.
• Updated report set and created new report sets for custom responsibilities in System administrator.
• Resolved production support tickets involving Journal Approval, Web ADI and Gl reports.
• Created change request documentation for production support tickets.

Confidential, Oklahoma City, OK

Oracle Payment SME

Responsibilities:

• Complete Oracle Payment Implementation requirement gathering to Testing. Involved New Year (2013) setup for all 21Federal DOT and non DOT agencies.
• Updating and validating BR100 documents for AP, PO, FA and AR. Worked on resolving KSN Issue in STG4 and RSNB instance.
• Created test cases and perform testing for complete P2P process. Registered new executable in System administrator module.

Confidential, Morgantown, WV

Oracle Apps Functional

Responsibilities:

• Implementation of Oracle Account Payables (AP) ver 12.1.3 and its integration with PO, CM and GL.
• Study of current business processes, future business flows and identification of gaps and workarounds in order to provide an integrated Procure to Pay business flow to meet the business needs of the company.
• Conference Room Pilot (CRP1, CRP2, CRP3) execution according with Oracle’s AIM. Log, view, access, monitor, follow-up and close Service Requests (SRs) online - Oracle MetaLink and Oracle Applications Patch Management.
• Budget control was used in AP implementation. Prepare an integral Accounting Close Cycle procedure including the standard reports to reconcile sub-ledgers (PO, AP, and INV) with GL. Provide training in this topic to the key users.
• AP integration with PO, CE and GL modules was extensively tested and verified (accounting and budget control) before go live.
• Perform Production Support Activities for all the procure to pay modules.
• Designed the Test Scripts and Test Scenarios for iProcurement and iSupplier Portal. Loaded Catalogs in to iProcurement (Buyer Hosted Catalog and Supplier Hosted Catalog).
• AP module setup, configuration and implementation involving all the mandatory and optional steps.
• Implementation is pointed to extract the maximum benefit available in the AP module functionality.
• Deliverables according with Oracle’s AIM including need analysis, functional mapping, gap analysis, finding solutions, setup and prototyping & testing.
• Wide analysis of the module functionality in order to avoid gaps. They were handled with customizations when the functional solutions or workarounds were not available.
• Standardized checkout types for each category of items, setting up approval limits in I-Procurement.
• Set up profile options, favorite items/categories, requisition approval workflow, training users in requisition tracking and desktop receiving in I-Procurement.
• Define user responsibilities, set up custom menus and request sets based on user responsibilities.
• Provided training and conducted practice and additional business requirements sessions.

Confidential

Oracle Apps Functional

Responsibilities:

• Implementation and support of Oracle Applications R12. Set up information templates, public lists and expense charge account rules in I-Procurement.
• Standardized receiving, expense receiving and returns in I-Procurement.
• Performed System Administration tasks such as setting up custom responsibilities, function /menu exclusions, updating user profiles iSupplier & Core, setup DFFs/Value Sets/Values etc.
• Testing modules’ setup for inconsistencies. Perform the tasks of communicating with clients for managing test data and ensure that it meets the requirements from customer point of view.
• Customizations using oracle client extensions. Performed responsibilities of defect tracking and identifying requirements of manual testing.
• Assisting in developing and testing software applications. Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Supported production environments and users on a daily basis by responding to emergency requests
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems.

Confidential

Oracle Apps Functional

Responsibilities:

• Work with an offshore team in India. Upgrade Assessment of current business process in R12 (GL, AR and Cash Management).
• Impact analysis in current business process due upgrade changes/enhancements. Business process mapping with all standard and customized modules.
• Design test scripts of all sub-process identified in assessment phase. Unit testing execution for each business process.
• Provided Training & Conducted Practice & Additional Business Requirements sessions.
• Supported production environments and users on a daily basis by responding to emergency requests.
• Analyzing user needs, conferring with users to improve procedures and identifying and solving problems. Post go-live support.

Confidential

Oracle Apps Functional

Responsibilities:

• Analysis of current business processes and definition of new processes within Oracle Application.
• Business requirements gathering, mapping, gap identification and workarounds.
• Responsible to trainee IT personal and implementers within modules of ASCP, OPM, Inventory and Quality Management (Process Manufacturing).
• Data conversion mapping and support to technical team for requirements.
• Business processes definitions to be implemented within new environment.
• Definition of custom process to have pending forecast at the end of the month for planning. BR100 and MP050 documentation.
• Environment configuration and scenarios preparation, documentation and proof of concepts. Setup, Test and training on Internal Sales Orders functionality.
• Inventory Items configuration for OPM, ASCP, Forecast, ISO and Quality capable. Organizations configuration to allow ISO between them.
• Inventory Plan configuration for OPM functionality.
• Formula and Recipe configuration for Batching within OPM to allow ASCP and custom code create batches to drive Production Plan.
• Quality Specification configuration and QC business definitions.
• ASCP souring rules configuration to allow ATP and OM’s SO scheduling process to define “source from” calculation based on customer site’s region
• Patching and bug research, implementation requests, test and delivery. Task and Cutover listing.
• Diagram and nightly routings (Planning) definition and documentation. Post Go-live production support.

Confidential

Oracle Apps Functional

Responsibilities:

• Resolving the issues reported by the users on a daily basis based on the priority in Financial and Supply Chain Modules in 11i (FAH, PO, AP, FA, GL, OM, INV and AR).
• Involved in developing two interface programs and reports for FA. Generating the Asset Keys automatically.
• Involved in performance tuning of few of the programs that run in the month end for consolidation.
• Writing and testing the unit test cases to test all the flows.
• Work with Oracle on Service Requests. Creating a Supplier Bank Audit Report.
• Involved and headed the team in coming up with the new and latest standards for coding, development and testing.

Confidential

Functional

Responsibilities:

• Defined the Accounting Flex-field, Segments and Value sets.
• Defined the Responsibilities for all the Set of books and attached the Responsibilities to each Sets of Books.
• Defined Currency, calendar and Period types. Loaded the accounts using the Data loader
• Defined the Consolidation Mappings. Defined the Legal Entities for all the Subsidiary companies
• Defined Parent accounts and entered Child ranges for rollups.
• Defined the Rollup rules, developed the Row Set and a Column Set for the Balance Sheet Using FSG.
• Defined the Business Group and operating Unit and assigned Business Group’s profile options.
• Mapped individual Subsidiary Chart of Accounts to Consolidated COA.
• Transferred Balances from the Subsidiary sets of books to the parent sets of Books.
• Posted Journals created by subsidiary data transfer in Consolidated Set of Books.
• Defined Segment Rules and Rollup Rules using the Consolidation Workbench.
• Created FSG Consolidation Balance sheet, Income statement and reports.
• Developed the training guide to process the consolidation and trained the users how to Process the Consolidation process.
• Process of Intercompany transactions.
• Developed Weekly and monthly Status reports.

Confidential

Functional

Responsibilities:

• Gathered the requirements for GL/AR/AP/CM and FA
• Defined Suppliers and AP invoice Profile options.
• Define Receipt Batch sources and created Transaction batch source in AR.
• Defined Tax Codes, Tax names and groups in AP.
• Setup Credit card Expense mapping and Data file download.
• Setup Supplier sites, Matching Tolerances and Distribution Sets in AP
• Setup Bank Accounts and Payment Terms in AP.
• Updated county, Territory information and assigned flexible address formats AR
• Translated, Loaded and Validate converted Asset. Loaded Balances to Production.
• Document all the Setups in BR 100 Template for GL/AR/AP and FA
• Set up the application in both Test and In production instance For AR/AP/FA/GL/CM.
• Executed the Test Scripts for GL/AP/AR/CM and FA.
• Conducted and documented current and future Business Processes for GL/AP/AR/FA/CM.
• Wrote Test Scripts to test processes for CRP 1, CRP2 and UAT.
• Documented and distributed Weekly and Monthly status reports.
• Developed Navigation Document and basic transactional guidelines for End-users.

Confidential

Functional

Responsibilities:

• Worked with the Finance super users in determining what historical data was to be converted and loaded into the New GL System.
• Developed custom spreadsheet in WEB ADI for upload process entering the Historical data into Oracle GL.
• Created the layout and mappings using Web ADI for Loading GL Historical data into Production system.
• Performed reconciliation of historical data conversion of GL account balances and transactions.
• Translated European Set of Books and ensures that the first end Close Occurred on a timely basis.
• Loaded GL Historical data to 11.5.10 using Web ADI.
• Worked as primary liaison between Business users and technical staff, lead problem resolution process by working with Oracle Support team by creating TARs.
• Designed the MD.050 design document for the AR invoice Print.

Confidential

Functional

Responsibilities:

• Created test plans, performed system testing, and worked with end users on all facets of the customer record for AR
• Production Support of Oracle AR/GL/AP
• Collection, analysis and consolidation of users reporting requirements.
• Helping Finance users with Month end Process for AR/GL/AP and solving day-to-day problems.
• Development of reports using FSG.

Confidential

Functional

Responsibilities:

• As part of the definition completed the Questionnaires for GL/AP/AR/CM and documented the current and future business flows
• Held COA workshops, gathered the data for Chart Design.
• Designed the COA and mapped Old COA to the New COA.
• Combined COA of six companies to a consolidated COA
• Set up GL Sets of Books for Jamaica and Barbados in Dev, Test and Production Environment. Defined the Accounting Key Flex
• Created the Macros to load the COA to the system using Data Loader and loaded the COA to GL.
• Defined Row set, Column Sets Using FSG.
• Defined the Set of Books, Currency and the Transaction Calendar in GL
• Defined the Recurring journals, Journal sources and Journal Categories GL
• Defined Budgets and Budget organizations.
• Setup matching tolerance and distribution sets AP.
• Define Banks, bank Accounts, Banks transmissions details and Payment Terms.
• Opened AP accounting period and Defined Withholding tax certificates and exceptions.
• Defined the format for the invoice Aging Report AP.
• Define tax codes and withholding tax groups for use automatic withholding tax AP.
• Defined US 1099 income tax regions AP and AP invoice Profile Option.
• Define customers Define Receipt Batch source and created the transaction batch source
• Defined AR system Options, Setup Tax names, Groups and Expense Reports templates.
• Prepared the Test Data, Test Scripts, executed the testing and documented the results.
• Defined Cross validation rules, Segments and Value sets.
• Created Summary accounts and defined automatic posting criteria.