We provide IT Staff Augmentation Services!

Oracle Ebs Consultant Resume

4.00/5 (Submit Your Rating)

Long Beach, CA

SUMMARY

  • Have 15+ Years of Oracle Applications (E - Business Suite 11i and R12) Experience - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation.
  • Developed Interface/Conversion (inbound and outbound) Programs using Open Interfaces and API’s.
  • Good Experience in implementing Order-to-Cash and Procure-to-Pay Business Process flows.
  • Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
  • Excellent in Forms, Reports, Workflow, AME, OAF, Java, JSP and WebAPI.
  • Strong experience in customizing Oracle Forms, Reports, and PL/SQL programming.
  • Expertise in Design and Development of RICEW (Reports, Interfaces, Conversions, Extensions, Workflow).
  • Strong on OBIEE design, development and implementation.
  • Extensive experience in customizations, interfaces and data conversions using Oracle technology and tools.
  • Have experience in supporting the production system, handling day-to-day issues and train the users on developed/enhanced components.
  • Implementation experience in AME (Approvals Management Engine).
  • Worked with Business team for creating Technical (MD070 and MD120) design documents.

TECHNICAL SKILLS

Application: Oracle Financials including General Ledger, AP,AR, iProcurement, Fixed Asset, Project Accounting, Purchasing, Payables, Order Management, Oracle time and labor and HR, Oracle CRM including iStore, Partner Management, Trade management, Oracle Quoting, iSuppliers.

Application Integration: JDeveloper, Oracle ADF 11g, OBIEE, Discoverer, Web Services, JSP, Java, XML, Web Servers, Servlet and Oracle Application Server

Database and Tools: Oracle SQL*PLUS, PL/SQL Store Procedure, Oracle Application Express (APEX), Packages, Oracle Developer, Toad, Workflow and CVS, Macromedia Flash, Fireworks, Dream weaver.

Languages: C, C++, JAVA, HTML, XML, UNIX Shell Script.

Methodologies: Oracle Application Implementation Methodology (AIM)

Industrial Exposure: Internet Search, Semi-Conductor, Software, Consumer Products, Airport Authority Aviation, Publishing, Network storage switches, construction Services, Specialty Retail and Security, Content service, connectivity system.

PROFESSIONAL EXPERIENCE

Confidential, Long Beach, CA

Oracle EBS Consultant

Responsibilities:

  • E-Business Suite R12.2.6 Finance implementation and production support including day-to-day support, enhancements, system and process improvements, change management for Oracle Financials Modules General Ledger, Receivables, Payables, Purchasing, Order Management, iProcurement, Projects, HRMS and Oracle OTL (Oracle Time and Labor), LCD (Oracle Labor Distribution) and FTS Modules.
  • Conversion of implementation for Confidential Limited acquires Confidential Inc. Energy, Chemicals and Resources division (ECR).
  • Oracle Projects Interface design for Oracle Time and Labor and Oracle Labor Distribution.
  • Dayforce Ceridian integration for Oracle LCD (OTL and FTS) Hours and cost to payroll process.
  • LCD custom process Labor Distribution is fully integrated with Oracle Human Resources, Oracle Payroll, Oracle General Ledger and Oracle Projects.
  • Global country weekly timesheets schedule process and support with LCD interfaced to project account and GL interface table.
  • Custom WebADI designs for AP Invoice, PO template uploaded using API and interface the custom WebADI process.
  • US ADP and Canada Dayforce Ceridian integration production support for payroll weekly and Bi-weekly.
  • Production support day to day activities OTL and FTS timecard issue and processing costing for projecting.
  • Oracle Time and Labor timecard validation for fast formula with HR Holiday and vacations Rules.
  • Developing Interface and Conversion (inbound and outbound) programs using oracle standard Open Interfaces and API and interface tables.

Confidential, San Clemente, CA

Senior Oracle Techno-Functional

Responsibilities:

  • E-Business Suite R12.2.4 production support including day-to-day support, enhancements, system and
  • Process improvements, change management for Oracle Financials Modules, oracle supply chain Management and Oracle Service.
  • EDI integration inbounds for RMA (Return Material Authorizations) and OSP (Outside Processing).
  • EDI integration Outbound for Purchase order ship notice to UPS.
  • Internal Audit Supplier report multiple excel sheet and sales order shipping report using BI Publisher.
  • Custom process created for Miscellaneous Accrual Reconciliation Write Off for intercompany transaction with Reconciled and Unreconciled report.
  • Custom WebADI template design for AP Supplier and Items cost upload process and VO view Object extension added new filed using the JDeveloper for Install Base.

Confidential, Los Angeles, CA

Senior Oracle EBS Techno-Functional

Responsibilities:

  • E-Business Suite R12 Experience - specializes in the development of Oracle software solutions utilizing expertise in requirements definition, business analysis, design, systems integration, and implementation.
  • E-Business Suite R12 Finance production support including day-to-day support, enhancements, system and process improvements, change management for Oracle Financials Modules General Ledger, Receivables, Payables, Purchasing, Order Management, iProcurement, Inventory, Assets, Oracle Install Base, iExpenses and HRMS.
  • Developed lot of Interface/Conversion (inbound and outbound) programs using Open Interfaces and API.
  • EMC, MTN and MTNGS Acquisition data conversion for Supplier, Customer, Open PO, and AP invoices, AR invoices, Items, on-Hand Load and Employee.
  • Chart of Accounts 8 into 11 segments changes into integration and custom tables, views, procedure, packages and discoverer and XML publisher reports.
  • AR, AP Invoice, PO template and AR receipt uploaded using the custom WebADI process.
  • Account Payable AME Implementation rules.
  • AP Payment Automation with Bank of America and Citibank for EMEA region and EMC, MTN and MTNGS.
  • American Express and MasterCard credit card integration with Oracle iExpenses.
  • AP Payment check printing Citibank and Bank of America for Canada and EMC, MTN and MTNGS.
  • MRP Implementation of inventory, Order Management/Shipping, Bill of Materials, Depot repair, Install base, work in process, items conversion, on hand item load interface, COC and pack and packing slip Report, barcode label design for Inspection Tag, Inventory Tag and Shipping Label.
  • External Billing system (Safe, MediaNet, MediaDB and Tittle tracker) integration with Oracle AP and AR invoices.
  • HCM Cloud integration with oracle HRMS inbound and outbound interface.
  • Taleo to Oracle HRMS integration using BPEL(SOA) HRMS inbound and outbound interface.
  • Outbound integration for GL data into blackline and employee data into Legal Hold pro system.
  • Integrated Content Purchases (maintained in the various legacy systems) into Oracle Purchasing module to provide visibility into current outstanding liability as well as secure/control AP to require approved PO before invoices are paid.
  • Report creation and production support using Oracle Discoverer, BI Publisher and oracle Report.
  • Internal Audit Alert daily alert for employee new hire and termination and custom process created for onboard and termination.
  • Internal and External Audit report created for user and responsibility access by quarterly.

Confidential, Santa Monica, CA

Oracle EBS Technical

Responsibilities:

  • Oracles E- Business Finance production support provided for procure to pay modules.
  • Oracle Time & Labor (OTL) R12 module new design customization with OAF Pages using MVC architecture using 3basic components MCV(Model, View, Controller),Inserting into temp table Project, Task, Expenditure and hour’s information and once submitted calling the API and starting the workflow approve process.
  • Finance’s reports created based on the user request using Discoverer and BI Publisher.

Confidential, Los Angeles, CA

Oracle EBS Techno-Functional

Responsibilities:

  • Oracles E- Business Finance production support provided for procure to pay modules. KOFAX Mark View for Account Payable Support issue fixing change the API.
  • Mass invoice attached document printing based on the project and invoice number. Payment batch process create payment template with various format.
  • Multi-Currency Payment setup for Account Payable payment AME (Approvals Management Engine) Setup for UK Confidential process design. iExpenses VO and Controller Extension OAF R12.
Confidential, Washington, DC

Oracle EBS Technical Functional

Responsibilities:

  • Oracle E- Business Finance Implemented and production support provided for procure to pay, order to cash and custom modules. (Mostly iProcurement, Purchase order, Account Payable, Project Account, Grants Accounting, Inventory, Fixed Asset, Expensed Asset, EOP, Suppliers, Order Management).
  • AME (Approvals Management Engine) implementation with Purchase Requisition (iProcurement) complex rules Approval based on the Airports, Department, Railroad and Accounting Fund.
  • Expensed Asset new custom module implementation for Property management department using the Oracle Forms standard GUI form development (API, Table, View, Manu, Function and Forms and Enabled Attachment Function) and Attachment API one too many function attached into Asset Number.
  • Oracle Alert setup for iProcurement when cancel the Line approval level.
  • Data conversation Fixed Asset to Custom Expensed Asset using API asset type expensed asset only.
  • PO Approval workflow customization Purchase order type of Standard, Blanket, and Contract custom PDF report email sent to Supplier instant of seeded PO Print as a PDF to Supplier on PO approval using Workflow and packages.
  • BI Publisher Reports created output Excel and PDF those reports created based client requirement functional design.
  • Enhancement Customization PO Standard, Blanket, Contract type of Purchase order RFT and RDF reports based on the function documents.
  • Oracle Forms Personalization for Accounts Payables supplier contact directory.
  • Oracle Reports Enhancement for pick slip and commercial invoice reports and PO reports.
  • Oracle Forms New Enhancement for Grants Accounting search and detail forms based on the Project and Award.
  • Customize Oracle iExpenses Workflows based on department and fund insert special approval in the workflow hierarchy.
  • Enhancement Extend a Controller in OA Framework Validation based on the Fund and Account (PATEO) in Oracle iExpenses on Airports Deportment.
  • Worked R12.1.1 to R12.1.3 upgrade Analysis, Development and Testing.

Confidential, Santa Monica, CA

Consultant, Oracle Application and OBIEE

Responsibilities:

  • Oracle Time & Labor (OTL) R12 module new design customization with Java and JSP.
  • Inserting into temp table for project information and once submitted calling the API and starting the workflow approve process and Update and delete project rows from the OTL page.
  • HRMS Module Employee emergency contact and bonus information updated throws the API using the custom concurrent Program.
  • Oracle AP Module discount amount inserted line level throws the oracle API.
  • Design oracle time labor screen make it simple user friendly and dynamic row creation with project number LOV.
  • Developed the Oracle Finance and Procurement and ORAE reports with dashboard, Developed different kinds of Reports (Compound layout, Table, Chart, Pivot Table, Gauge, View Selector, narrative, Ticker, Static Text,) using global and local Filters.
  • Developed Metadata repository (RPT), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
  • Migrated with Oracle Discoverer (Discoverer) metadata to Oracle Business Intelligence Suite Enterprise Edition (OBIEE).

Confidential, Boca Raton, FL

Consultant, Oracle Application CRM

Responsibilities:

  • Oracle Application CRM iSupport store operations issues proactively. Currently this team has Info Path forms to submit the requests and an email-based resolution process to resolve any issue related to Store Operations. Info Path forms will be replaced by self-service (iSupport) process of Oracle E-business suite. And email-based resolution process will replace by Agent Dashboard functionality of Oracle Service Modules.
  • The Dashboard provides a queued list of Service Requests (SR’s) that need to be resolved by the resources such as Store Operations backend support team. This process is to meet the above objectives and to overcome any potential points of failure in the existing process and this process includes 4 sub processes
  • Store Portal Submission Process 12 type Custom Java Server Page survey form created in JSP and integrated with Oracle iSupport Oracle E-business suite.
  • All the custom form created JSP and insert into EBS database custom table Store Portal Form page calling the custom Pages and EBS iSupport Conformation standard page customized integrated with our custom page.
  • Confidential Director views all service requests under the director control. Director eligible to update and approve any Service Request and this functionality not there oracle standard, create a custom responsibility for the director.

Confidential, San Jose, CA

Consultant, Oracle OBIEE

Responsibilities:

  • Developed the Oracle Finance report with dashboard, created report with financial year and financial quarter and financial Week,
  • Developed Metadata repository (.rpd), configured metadata the Business Model Layer & Physical Data Model and Web Catalog Objects as per the reporting requirements using OBIEE Admin and Web tool.
  • Worked on Oracle BI Answers to build Interactive Dashboards with drill-down capabilities.
  • OBIEE conditional format using arrows images and symbols and Configured OBIEE for LDAP Authentication.
  • Developed different kinds of Reports (Compound layout, Table, Chart, Pivot Table, Gauge, View Selector, narrative, Ticker, Static Text,) using global and local Filters.

We'd love your feedback!