Oracle Ebs Techno Functional Consultant Resume
Sunnyvale, CA
SUMMARY
- Over 10+ years of extensive experience as Oracle Applications Techno - Functional Consultant in implementation, upgrade and customization of Oracle e-Business Suite Applications. dis includes system study, design, development, post implementation maintenance and support of Oracle EBS.
- Extensive experience in Oracle EBS RICEW (Reports, Interfaces, Conversions, Extensions and Workflows), OAF pages customizations and development of Interfaces using SOA/BPEL.
- Extensive experience in Implementation, Migration, Customization, Production and Support of various modules in Oracle Applications with major focus in Order Management (OM), Inventory (INV), General Ledger (GL), Accounts Receivable (AR), Accounts Payables (AP), Purchasing (PO), I-Expenses, I-Procurement, I-Receivables, Fixed Assets(FA)
- Expertise in SQL, PL/SQL, Packages, Functions, Procedures, Triggers, Views and Indexes.
- Expertise in configuring Sub-ledger Accounting (SLA), configured for specific accounting requirement in Release 12 for Cost Management, Payables and Fixed Assets.
- Wide experience in requirement analysis, GAP analysis, Design the ‘to be’ process, Process mapping, Data Conversion Management, Testing (unit/integration/system)
- Experience in Application Object Library (AOL) Framework for forms based applications as well as Oracle Applications Framework (OAF) for Self Service Frame Work.
- Experienced in various test cycles like Unit Testing (UT), System Integration Testing (SIT), User Acceptance Testing (UAT) and Testing Strategy like entry/exit criteria, test plan, test scenarios and test cases.
- Hands-on experience with Oracle Application Framework, Oracle Forms/Reports, OeBS Interfaces and APIs, Oracle BI Answers and Dashboards, BI and XML Publisher, Oracle Workflow, Oracle Discoverer.
- Worked on developing Oracle APEX Forms and Reports using Oracle Application Express version 5.0,
- Developed Technical Design Documents, keeping in line with the AIM Methodology (MD70, MD50, CV040, and CV060 MD120).
- Strong noledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards, Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
- Experience in designing, developing, testing, performance tuning and supporting data base applications using Developer Tools (Reports 6i/9i/10g, Discoverer4i/9i/10g, XML/BI Publisher), PL/SQL on UNIX and Windows platforms.
- Expertise in extending Oracle workflows, specifically related to Oracle Purchasing Module like Requisition Approval, PO Approval, Change Order and Requisition and PO Account Generator.
- Experience in various development tools like SQL Developer, SQL*Loader, Oracle JDeveloper 10g/9i, Forms 10g/6i, Reports 10g/6i.
- Resolution of functional issues within Oracle Applications dat may include setup modifications and/or identifying approved workarounds when patching is not available.
- Extensive technical and business experience in Procure-to-pay, Order-to-cash, Quote to Cash and Assets to GL Record to Report and Bill of Materials (BOM).
- Expertise in Data Conversion and Interface development.
- Experience in Oracle Discoverer and XML Publisher, XPath and WSDL.
- Exposure in R12 Financial Modules and SLA, MOAC, TCA, E-BUSINESS TAX.
- Expertise in development tools such as Oracle Forms, Oracle Reports, PL/SQL, SQL*PLUS, UNIX Shell Scripts.
TECHNICAL SKILLS
Oracle Applications: Oracle Applications 11.5.x/11.0.3/10.7. (Accounts Receivables (AR), General Ledger (GL), Accounts Payables (AP), Fixed Assets (FA), Order Management (OM), Inventory (INV), Purchasing (PO) Bills of Material (BOM), iProcurement, iReceivables, iStore and Application Object Library (AOL)).
Languages: Java, SQL, PL/SQL, HTML, PHP, C, C++ UNIX Shell Scripting
RDBMS: Oracle 10g/9i/8i, MS SQL Server 6.5/7.0, MySQL 4.1, MS Access
Oracle Tools: Forms 6i/9i, Reports 6i/9i, Oracle 8i/9i, Discoverer 4i/9i, JDeveloper, Work Flow Builder and XML Publisher.
Database Tools and Utilities: SQL*Plus, SQL* Loader, Toad
Operating Systems: UNIX, LINUX, Windows 98/NT/2000, MS DOS, Solaris 8.0
PROFESSIONAL EXPERIENCE
Confidential, Sunnyvale, CA
Oracle EBS Techno Functional Consultant
Responsibilities:
- Involved in documenting the business processes, requirements definition, and performed gap/fit analysis for General Ledger, Payables, and Purchasing modules.
- Involved in the design of Supplier Master, configuring system options, distribution sets, bank setups, etc. in Payables.
- Gathered business requirements for the centralized payment process across multiple organizations and translated them to business processes to set up payment processing formats, payment process profiles, etc.
- Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to validate and import the Suppliers, Supplier Sites, Open Purchase Orders (PO), Open Payable Invoices (AP) and Item Import (INV)
- Documented (Technical (MD70) and Conversion Mapping document (CV40) and developed an Interface between Third party System Ceridian and General Ledger Interface to import monthly Journal entries.
- Developed staging tables, Custom PL/SQL API to validate and load data into Interface table.
- Developed PL/SQL packages to load data into interface tables for Item Assignment, Item Cost Update, on hand Conversion, AR Invoice Conversions.
- Developed an Interface Program to import Supplier Invoices from legacy into Oracle AP.
- Analyzed and developed custom OAF Pages for Multi Language Translation
- Business Requirements Mapping for AR, GL, E-Biz Tax and Sub ledger Accounting method (SLA)
- Worked on Sub ledger Accounting (SLA) to modify accounting derivation rules for Accounts receivables & Tax.
- Involved in the design of AIM (Application Implementation Methodology) documents (MD50, MD 70, and MD120) for all the RICEW.
- Developed AP Expense Report interface to load the invoices from multiple sources like Legal Invoices, Quarterly Payroll, OfficeMax, Charitable Contributions, Travel EFT etc., into Accounts Payable in a periodic basis.
- Created custom Budget Over Head Report for payables used to create and distribute the overhead reports for all departments and users using reports 10g and XML Publisher.
- Used SOA for monitoring the workflow errors which failed or got stuck in EBS.
- Worked on OAF Extensions CO and VO Extension of iProcurement pages.
Confidential, Fort Worth, TX
Oracle EBS Techno Functional Consultant/Implementation
Responsibilities:
- Involved in implementation and testing of Oracle Applications Financial R12 GL, AP,AR and CM modules
- Involved in requirement gathering and analysis and design of the application.
- Responsible for the implementation of Receivables(AR) & E-Business Tax
- Interact with the Business Users to gather the Business Requirements, analyze the system impacts and to provide Technical solutions.
- Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
- Worked with Sales Orders Open Interface in Oracle Order management module to import Sales Orders from legacy system to Oracle Order Management by using the Oracle API.
- Worked on customizing a webpage to initiate custom workflow from OA Framework webpage.
- Worked on extracting information from Oracle Applications base tables to Intermediate tables for outbound interfaces.
- Designed and developed the custom package to validate the legacy item Categories and assigned the categories to converted items using standard Item Category Assignment import program.
- Developed PL/SQL procedures, functions and packages.
- Created the materialized views and also created the partitioning tables.
- Worked on database triggers for automatically updating the tables.
- Created host programs using UNIX shell scripting for remote database access and ftp of files to the supplier site database.
- Created Custom, Simple, Complex folders, Business Areas, workbooks and assigned privileges and registered the reports on Oracle Applications.
Confidential, Oakbrook, IL
Oracle EBS Consultant
Responsibilities:
- Actively participate in the design, development and maintenance of interfaces to and from the Oracle E-business Applications.
- Work closely with the Business Analysts and Functional Consultants to gather requirements for reports, interfaces, extensions and conversions for eBusiness applications.
- Worked on form customizations in Purchasing, Inventory. Developed custom forms in Inventory, Engineering modules.
- Developed reports in Oracle Purchasing, Inventory, and Order Management. Also customized a number of oracle seeded reports. Developed scripts for importing Items, Item revisions, Item categories, Default shipping/receiving sub inventories and Bills of materials into Oracle.
- Involved in design, development and testing of new and existing Interfaces using PL/SQL to interface non-oracle and Oracle systems to Oracle applications Modules AR, GL, AP, FA, OM, SCM, INV, Service Contracts, Install Base modules and PO. All the interfaces were registered and run through the concurrent manager.
- Worked in preparation of AIM (Application Implementation Methodology) documents for Functional and Technical specifications of Conversions, Interfaces, Reports and Forms customizations.
- Implemented Order to Cash modules: OM, Inventory, Warehouse, Purchasing, Receiving and module integrations with OM GL, AP, AR, CM, INV within EBS System.
- Developed New Reports and Customizations in XML Based reports using OBI/XML Publisher.
- Customized Standard Forms Using Oracle Applications Frame Work(OAF)
- Developed language based Reports (Spanish, German, Polish, Denmark, Nether land, Dutch, Italian…Etc) Using Oracle Report Builder, APEX and Oracle Form Builder in Financial, Manufacturing, Distribution, CRM (Services, Contracts and CSF) Modules.
Confidential, San Jose, CA
Oracle EBS Developer/Consultant
Responsibilities:
- Performed Setup steps, defined various Key Flex fields and Descriptive Flex fields for AP, AR, and GL.
- Developed control file to load sales orders created in legacy system into staging tables using SQL * loader tan validated data and inserted into OM interface tables.
- Worked extensively on System Administration responsibility by doing set ups in AR, AP and GL Modules.
- Personalized Oracle Core Forms by using Form level, Item Level and Block Level Triggers in several modules such as AR, AP and OM, as per the Business requirements.
- Prepared Deployment/Promotion and integration documents for moving custom objects from the development instance to production after coding/ testing. Extensively used Rational Clear Case for Version control and Kintana for code migration.
- Developed PL/SQL Procedures for Customer interface using Trading Community Architecture (TCA) in Accounts Receivables according to Client Requirements.
- Customized Receipts Form as per business requirement.
- Developed Order Management, Inventory, Receivables queries to compare summary information of the standard and custom reports.
- Customized various XML/BI Publisher Reports using RTF templates and defined their respective Templates and Data Definitions.
- Customized Reports like the Order Summary Report, Pick Slip Report and Packing Slip Report in Order Management using XML/BI publisher.
- Converted Supplier Payment History Report in Account Payables from Report 6i to XML/BI Publisher.
- Followed (MD50) functional documents and written the technical (MD70) specifications, provided support for end users and documented the modifications.
Confidential
Oracle EBS Developer/Consultant
Responsibilities:
- Worked as a team member to implement and develop interfaces according to business requirements for Purchasing (PO), Inventory (INV) and Receivables (AR)
- Customized Reports in PO, AR and AP like Printed Purchase Order Report, Aging 4 Bucket Report etc using Reports 10g.
- Involved in setup and customization of Oracle Payables and data conversion from legacy system into Oracle Payables.
- Involved in customization of reports in PO, AR and AP, such as Printed Purchase Order Report, Aging 4 Bucket Report etc. using Reports6i and XML/BI Publisher.
- Developed reports in Oracle inventory for comparison of available and on-hand quantities in various lots.
- Registered Reports, SQL*Loader Scripts and PL/SQL Packages as Concurrent Programs using System Administrator Responsibility.
- Involved in Open Transaction Interface to import transactions from legacy system to Inventory and set up Transaction Manager as background program to import validated data from interface table periodically.
- Responsible for development of open interface for interfacing AR transactions from legacy system into AR in Oracle Applications
- Used Oracle API's across the customization of the Order to Cash process.
- Used SQL Loader and UNIX shell scripting to load data for the orders in 11.5.10 instance.
- Created new Oracle Reports and Customized standard Oracle Reports using Reports 9i
- Created custom utility packages in PL/SQL.
- Prepared MD 70 Technical Design Documents for critical objects using the AIM Methodology.
- Developed and designed various reports using XML Publisher.
- Developed and migrated Reports using Discoverer 4i for on-site users.
Confidential
Oracle EBS Developer
Responsibilities:
- Developed PL/SQL Stored Procedures, Functions, Packages and Database Triggers.
- Worked on the Journal Import in General Ledger (GL) module and on the GL-AR link.
- Design and Developed Oracle APPS Forms using Forms 10g and BPEL.
- Worked on Order Import interface program.
- Developed custom reports using Oracle XML Publisher Reports.
- Developed programs using PL/SQL and many packages to do the validations as per requirements.
- Prepared design document test scripts for the applications.
- Developed Forms /Reports using Forms 4.5 and Reports 2.5 and solved Problems in Reports.
- Understanding the requirements, developing custom objects in Oracle Application.
- Development of custom Oracle Forms, Form Personalization.
- Development of Inbound and Outbound Interfaces from/to Legacy systems.
- Generate reports, day-to-day administration jobs