We provide IT Staff Augmentation Services!

Senior Oracle Functional Consultant Resume

PROFESSIONAL SUMMARY:

  • Over 10 years of IT experience as an Oracle Functional Consultant using Oracle Applications (11i and R12) with Strong analytical skills in Finance and SCM Modules
  • Experience in Client Management, Users, Guiding Technical team and Strong Oracle Applications Gap Analysis, fresh implementation, up gradation, Customizations and support experience in Finance modules.
  • Experience in understanding business requirements for analysis, and mapping applications as per the client requirement.
  • Extensive knowledge in Oracle ERP Application modules such as BOM, Inventory, Order Management, IStore, Quoting
  • Extensive experience in four full life cycle implementation and upgrades 11i & R12
  • Successfully completed Four full life cycle (FLC) implementations of Oracle Applications release 11i (11.0.3, 11.5.4, 11.5.6, 11.5.8, 11.5.9, 11.5.10, 12.1.1, 12.2.2).
  • Experience in implementing full life cycle, scoping and supporting Oracle Applications 11i and R12 Areas of expertise include: General Ledger(GL), Sub ledger Accounting, Accounts Receivables(AR), Fixed Assets(FA), Accounts Payables(AP) and Oracle iExpense,, iProcurement, Purchasing, Order Management, Cash management, Project Accounting, Project Management, Billing, Inventory, Advanced Pricing, Financial Statement generator .
  • Extensive experience in Procure to Pay (P2P) and Order to Cash (O2C) in 11i and R12.
  • Active participation in Application evaluation, Process flow reviews and Requirements definitions
  • Extensive experience in set up the approval hierarchy p2p
  • Extensive experience in TAX systems, Vertex and SABRIX integrating with Oracle Applications for tax calculations.
  • Expertise in Preparation of Process Documentations, Materials & User s like BR100, MD50, etc using AIM Methodology.
  • Expertise in business process analysis, requirement analysis, Gap Analysis, system mapping, CRP testing, system configuration, data conversions, master data loading and production go - live support.
  • Extensive experience identifying product gaps coordinated with development team by creating TAR/SR and obtained one-off fixes. Managed and monitored Tar’s for several P1 issues.
  • Extensive experience in using SQL, PL/SQL, Developer 2000/6i, Oracle Forms 6i/9i,Discoverer3i/4i, Workflow, Procedures, Functions, Custom PLSQL APIs, and SQL Loader Oracle 9i/8i/8/7.x, Unix, Linux and Oracle Applications .
  • Expert in System Administration (AOL) in defining users, menus, responsibilities, printer set-ups and maintaining concurrent programs. Defined Custom Applications, which includes new Menus, Request Groups and Responsibilities using Application Developer and System Administrator responsibilities and Financial Statement generator
  • Completed four full life cycle Oracle Finance implementations of General Ledge (GL),Accounts Payable (AP), Accounts Receivable (AR), Purchasing (PO), Fixed Assets (FA) Order Management (OM), Inventory (INV), 11.03 and 11i (latest version 11.5.10.2)&R12 using AIM, FFRM (Fast Forward Rapid Implementation) and R2i methodology.
  • Responsible for maintaining and improving the Finance and Purchasing business processes, Oracle Configuration and data reporting while ensuring regulatory compliance.
  • Highly organized. Ability to work under pressure in fast-paced environment. Excellent interpersonal skills with an ability to interact with individuals at all levels and to mobilize and lead a team.
  • Experience working in Production and Development support.
  • The Deployment cycle involved Item Mapping, cut over activities, the users, helping the pilot divisions go-live, providing post-production support.

TECHNICAL SKILLS:

Databases: Oracle Database Version 10g/9i/8i, MS SQL Server 2000

Languages: C,SQL,PL SQL

Internet Technologies: JSP, JDBC and Servlets

Oracle Applications: E - Business Suite- 11.0.3/11.5.7/11.5.8/11.5.10/ R12.

Oracle Apps Modules: Oracle Financials(GL,AP,AR,FA,PO,GIS,CM)(P2P & O2C) Order Management(OM), Inventory, Shipping, iExpense, iProcurement, Advanced Pricing &Advanced Collections

Oracle Tools: SQL*Loader, Toad, Developer 6i/2000 (Forms 6i/4.5, 8.0, Application Object Library

Operating Systems: IBM/AIX, HP UNIX, Sun Solaris, Red hat Linux, Windows XP, Windows 2K

Other Tools: PVCS Version Manager, Kintana, Mercury Test Director, Quality Center, MS Word, MS Office, MS Excel, MS Power Point, MS Project, Clarify Web Support, Cool Compliance.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Oracle Functional Consultant

Responsibilities:

  • Setups TCA Architecture, Invoice to Cash, 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. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including EBTAX, AR, AP, PO, GL, AGIS, and CE, for 14 countries Perform system analysis, requirement gathering, specifications generation.
  • Task - include configure Ebtax for UAS, Canada
  • Upgrad from 12.1.3 to 12.2.4 and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Designed and prepared MD50 for customization for Vertex reports.
  • Actively participated in resolving complex project issues concerning multi-modular interfaces, Multi currency issues and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide Ebtax and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, Consolidation
  • Setups, Calendar, and currencies.
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in Ebtax, AGS, GL, AP, AR
  • Involved in Regression testing for Ebtax, AR, AP, GL, Payment Terms in AP, and AR
  • Customizing/Formatting FSG Reports and Discoverer
  • Working on production support issues (24x7) for Ebtax, AGIS, AP, AR, GL, and CE and FA.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Configure Approvals Management Administrator (AME) for General Ledger
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.

Confidential, DALLAS, TX

Senior Oracle financial Functional lead Consultant

Responsibilities:

  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL, AP, AR, EBtax, AGIS and CE, Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
  • Perform system analysis, requirement studies, specifications generation, new implementation R12 (12.1.3) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Integrated Vertax with ERP for USA and Canada
  • Write rules and logic for value added tax, goods and service tax.
  • Configured customer exemption in vertax
  • Worked on production support issues (24x7)
  • Support month end Ebtax reporting needs for GST PST, HST, VAT and Sales tax.
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Validate DFF Setups for in AP, GL, AR, reports and AP reports in prod and other instances
  • Implemented a fully integrated solution utilizing Oracle Financials for Financial Reporting, General Ledger, Accounts Payable, Account receivables and Cash management
  • Actively participated in resolving complex project issues concerning multi-modular interfaces and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, and Consolidation.
  • Implemented secondary ledger to meet Columbia and Mexico government requirements
  • Implemented localization for Colombia withholding tax and vat tax
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in AP, GL, AR and CE
  • Invoiced in Data conversion for GL, AP, and AR and on hands and assist User Acceptance testing/ Sign off, and interfaces Design.
  • Extensive experience in Advanced Collections
  • Setup ADVANCED GLOBAL INTERCOMPANY SYSTEM (AGIS)
  • I implemented P2P and worked in Order to Cash. Procure to Pay configuration support, Oracle EBS Procurement Contracts implementation, functional test scripts, User Acceptance Testing/ sign off, Interfaces Design between legacy systems and Oracle Applications and cut over support
  • Involved in Regression testing for AR, AP, GL, Pay Terms in AP, CE, Ebtax
  • Implemented Lockbox, and BAI2 files
  • Working on Oracle Financial Accounting Hub, and Mass Allocations
  • Customizing/Formatting FSG Reports and Discoverer
  • Worked on SLA
  • Extensive experience in EBTax
  • Configured ebtax for Australia, Singapore, Mexico and Colombia localization
  • Working on production support issues (24x7) for AP, AR, GL, ebtax and CE.
  • Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
  • Configured Vertax: United States US Sales and Use Tax, Canada GST and EST.

Confidential, Boston, MA

Senior Oracle Functional Consultant

Responsibilities:

  • Setups TCA Architecture, Invoice to Cash, 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. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including EBTAX, AR, AP, PO, GL, AGIS, and CE, for 14 countries Perform system analysis, requirement gathering, specifications generation.
  • For USA and Canada Integrated Vertax with oracle for sales tax, GST, PST, HST and QST.
  • Worked on tax reporting for Sales Tax, GST, PST and VAT.
  • Supported the system after go live.
  • Task - include configure Ebtax for 14 countries Germany, United Kingdom, Switzerland, Austria, Australia, Luxemburg, France, Italy, Canada, Ireland, Netherland, Belgium, Spain and Denmark implementing R12 (12.2.4) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Setup ADVANCED GLOBAL INTERCOMPANY SYSTEM (AGIS)
  • Designed and prepared MD50 for customization for Ebtax reports.
  • Implemented a fully automated solution utilizing Oracle Financials for Financial Reporting, General Ledger, Accounts Payable, Account receivables, AGIS and Cash management
  • Actively participated in resolving complex project issues concerning multi-modular interfaces, Multi currency issues and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide Ebtax and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, Consolidation
  • Setups, Calendar, and currencies.
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in Ebtax, AGS, GL, AP, AR
  • Involved in Regression testing for Ebtax, AR, AP, GL, Payment Terms in AP, and AR
  • Customizing/Formatting FSG Reports and Discoverer
  • Working on production support issues (24x7) for Ebtax, AGIS, AP, AR, GL, and CE.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Configure Approvals Management Administrator (AME) for Payables
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.

Confidential, Houston, TX

Senior Oracle financial Functional lead Consultant

Responsibilities:

  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including GL, AP, AR, EBtax, AGIS and CE, Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
  • Perform system analysis, requirement studies, specifications generation, new implementation R12 (12.1.3) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Integrated Vertax with ERP for USA and Canada
  • Write rules and logic for value added tax, goods and service tax.
  • Configured customer exemption in vertax
  • Worked on production support issues (24x7)
  • Support month end Ebtax reporting needs for GST PST, HST, VAT and Sales tax.
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Validate DFF Setups for in AP, GL, AR, reports and AP reports in prod and other instances
  • Implemented a fully integrated solution utilizing Oracle Financials for Financial Reporting, General Ledger, Accounts Payable, Account receivables and Cash management
  • Actively participated in resolving complex project issues concerning multi-modular interfaces and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, and Consolidation.
  • Implemented secondary ledger to meet Columbia and Mexico government requirements
  • Implemented localization for Colombia withholding tax and vat tax
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in AP, GL, AR and CE
  • Invoiced in Data conversion for GL, AP, and AR and on hands and assist User Acceptance testing/ Sign off, and interfaces Design.
  • Extensive experience in Advanced Collections
  • Setup ADVANCED GLOBAL INTERCOMPANY SYSTEM (AGIS)
  • I implemented P2P and worked in Order to Cash. Procure to Pay configuration support, Oracle EBS Procurement Contracts implementation, functional test scripts, User Acceptance Testing/ sign off, Interfaces Design between legacy systems and Oracle Applications and cut over support
  • Involved in Regression testing for AR, AP, GL, Pay Terms in AP, CE, Ebtax
  • Implemented Lockbox, and BAI2 files
  • Working on Oracle Financial Accounting Hub, and Mass Allocations
  • Customizing/Formatting FSG Reports and Discoverer
  • Worked on SLA
  • Extensive experience in EBTax
  • Configured ebtax for Australia, Singapore, Mexico and Colombia localization
  • Working on production support issues (24x7) for AP, AR, GL, ebtax and CE.
  • Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
  • Configured Vertax: United States US Sales and Use Tax, Canada GST and EST.

Confidential, Manhattan, NY

Senior Oracle Functional Consultant

Responsibilities:

  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, PO, FA, Iexpense and CE, Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
  • Perform system analysis, requirement studies, specifications generation, upgrade from 11. (12.1.3) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Validate DFF Setups for in AP, GL reports and AP reports in prod and other instances
  • Implemented a fully integrated solution utilizing Oracle Financials for Financial Reporting, General Ledger, Accounts Payable, Account receivables and Cash management
  • Actively participated in resolving complex project issues concerning multi-modular interfaces and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • Account Receivables(AR): Setups Trading community Architecture configure Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules, also, train employees for Invoice to cash Processes flow.
  • Configure Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges,
  • Setup Lock Boxes, Transmission Formats, Collectors, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
  • CA 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. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, Consolidation.
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in AP, PO, IExpense and CE
  • Extensive experience in Advanced Collections
  • I implemented P2P and worked in Order To Cash. Procure to Pay configuration support, Oracle EBS Procurement Contracts implementation, functional test scripts, User Acceptance Testing/ sign off, Interfaces Design between legacy systems and Oracle Applications and cut over support
  • Involved in Regression testing for AR, AP, GL, Pay Terms in AP, CE
  • Working on Oracle Financial Accounting Hub, and Mass Allocations
  • Customizing/Formatting FSG Reports and Discoverer
  • Worked on SLA
  • Extensive experience in EBTax for United Kingdome, Untied States, Canada, Japan.
  • Working on production support issues (24x7) for AP, AR, GL, and CE.
  • Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Configure Approvals Management Administrator (AME) for Payables
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.
  • Configured Ebtax: United States US Sales and Use Tax, Canada GST, EU VAT - UK, also Honk Kong, Singapore, and Australia tax.

Confidential, Manhattan, NY

Senior Oracle Functional Consultant

Responsibilities:

  • Setups for Trading community Architecture also, Test and train employees for Invoice to cash Processes flow in addition configure Customer Profiles, System Options, Transaction Types, Sources, Accounting Rules,
  • Configure Auto Accounting Rules, Auto Invoice Line Ordering Rules, Grouping Rules, Receipt Sources, Receipt Classes, Banks, Bank Charges,
  • Setup Lock Boxes, Transmission Formats, Collectors, Aging Buckets. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc. CA 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. Define Parameters for Item Validation Organization & Customer Relationship in OM, System Options, Location Flex field, Auto Accounting, Transaction Sources, Transaction Types, Receivable Activities, Remittance Banks, Receipt Class, Receipt Sources, Salespersons, Customer & Sites, Remit to Address, Tax Codes, System profiles etc.
  • Created Business Group, Legal Entity, Operating unit, Inventory org. Did GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, Consolidation
  • Setups, Calendar, and currencies. creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR, CE, and IExpense
  • 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. 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, invoice aging report formats. Set the profile options for AP. iExpense: Define Accounting Flexfield, updated Internet Expense Messages, defined Contact us Information, Global Policy Information, define Employees, Security Profiles, System Profiles, Define Payable Lookups, Expense Clearing Account, Expense Report Options, Enable auto Tax Calculation, Auto Tax Calculation, Tax Code Default Hierarch, define Expense Report Templates, Establishing Corporate Credit Cards Define Oracle Internet Expense Setup .
  • Configure Approvals Management Administrator (AME) for Payables
  • Cash forecasting & Cash positioning with bank wise details. Define System Parameters, Bank Transaction Codes, Forecast Templates, Bank Statement mapping.
  • Manual reconciliation before implementing automatic reconciliation and Automatic reconciliation after defining bank transaction codes and bank statement mapping.

Confidential, HOUSTON, TX

Senior Oracle Functional Consultant

Responsibilities:

  • Analyze design, customize, configure and test implement detailed Oracle applications and modules including AR, AP, GL, and CE, Gather, manage and document functional requirements for technical customization including reports, forms, workflows and scripting;
  • Perform system analysis, requirement studies, specifications generation, implementing R12 (12.1.1) and system integrations; Develop creative solutions to support business needs, and help determine opportunities for exercising additional application capabilities;
  • Assist with functional configurations, implementations, and production support activities; Perform system configuration required to satisfy requests from end-users for fixes, changes, and enhancements to financial/accounting management functionality.
  • Task - include integrate P2 energy upstream solution software, Allegro marketing software with oracle financials. Setup Gl, AR, AP, and CE also involved in conversion of Customers and Suppliers using Data loader.
  • Validate DFF Setups for in AP, GL reports and AP reports in prod and other instances
  • Implemented a fully integrated solution utilizing Oracle Financials for Financial Reporting, General Ledger, Accounts Payable, Account receivables and Cash management
  • Actively participated in resolving complex project issues concerning multi-modular interfaces and integration in a non-networked environment
  • Performed process analysis, solution design, build, test, delivery, and post production support for enterprise-wide General Ledger and related documentation/deliverables
  • Designed various data loading programs and documentation pertaining to different project phases
  • General Ledger (GL): involved in GL Setups Chart of Account Structure, Accounting Flex Field, Cross Validation Rules, Value Sets, Security Rules, Ledgers, Profile Options, Journal Sources, Consolidation
  • Setups, Calendar, and currencies.
  • Involved in creating Responsibilities with appropriate menus and functions for specific job roles in GL, AP, AR
  • Extensive experience in Advanced Collections
  • I implemented P2P and worked in Order To Cash. Procure to Pay configuration support, Oracle EBS Procurement Contracts implementation, functional test scripts, User Acceptance Testing/ sign off, Interfaces Design between legacy systems and Oracle Applications and cut over support
  • Involved in Regression testing for AR, AP, GL, Pay Terms in AP, CE
  • Working on Oracle Financial Accounting Hub, and Mass Allocations
  • Customizing/Formatting FSG Reports and Discoverer
  • Working on production support issues (24x7) for AP, AR, GL, and CE.
  • Designed and prepared MD50 for customization of interface to load Journals for Reconciliation.
  • Define, analyze, document business and systems user requirements; Configure dimension rules, datasets, balance rules, data sources, loading metadata; Perform data extracts to and from Oracle modules such as GL, AP, CE and AR; Write detailed descriptions of project needs, program functions, and steps required to develop or modify computer programs;
  • Design of Accounting Flex Field Structure: Helped in arriving to an appropriate Chart of Accounts structure, which was simple to grasp and yet captured all reporting requirements.
  • Security and Cross Validation Rules: Created security and cross validation rules for restricting the use of account code combinations by company and department
  • Configure Approvals Management Administrator (AME) for Payables
  • Setup oracle seeded workflow Approval limit for General Ledger
  • Review computer system capabilities, workflow, and scheduling limitations to determine if requested program or program change is possible within existing systems; Study existing systems to evaluate effectiveness and develop new systems to improve efficiency and workflow.
  • Working with different teams to resolve all issues for the assigned sites. Resarch the issues on Metalink and Open the TAR with Oracle for critical issues. Coordinate with Oracle Support on various TAR’s on daily basis through Metalink.

Hire Now