We provide IT Staff Augmentation Services!

Oracle Apps Technical Consultant Resume

Irvine, CA

SUMMARY:

  • Over 9 years of work experience in the IT industry with expertise spanning over technical aspects of Oracle Applications 11i/R12.
  • Involved in Implementations, Version Upgrades, Enhancements, Data Conversions, Interfaces, and Customizations with post Go - Live, production support capabilities of Oracle e-Business Suite Applications.
  • Extensive technical and functional work expertise in various modules of Oracle Applications with major focus in General Ledger (GL), Accounts Receivable (AR), Accounts Payable (AP), Cash Management (CM), PA (Costing, Billing, Projects & Resource Management), AGIS, Advanced Pricing, E-Business Tax, Fixed Asserts (FA), Advanced Collections , Oracle Loans, Order Management (OM), Inventory (INV), Purchasing (PO), IExpense, IProcurement, Service Contracts (OKS), Supply Chain Management (SCM) .
  • Hands-on experience in Data Conversion, Data Migration, Report Generation and Developing Interfaces within several modules in Oracle Applications.
  • Technically proficient with development of forms and RICEW components (Reports, Interfaces, Conversions, Extensions, Workflows), CEMLI elements (Configurations or Customization, Extension, Modification, Localization, and Integration).
  • Worked extensively on full life cycle implementations of Order to Cash (O2C) and Procure to Pay (P2P) and Fixed Asset to GL and Supply chain business flows .
  • Proficient in development of Interfaces and Conversion programs to integrate Oracle applications modules to import data from various sources into Oracle Applications using PL/SQL, SQL*Loader.
  • Multiple project life cycle experiences with Initiating, Planning, Executing, Supporting and Monitoring. Business Analysis, Requirement Gathering including facilitate workshops, scope verification & validation, Alternative Identification and analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut-off, Go-Live and Post-Implementation Support.
  • Familiar with System Administration and Oracle Application Object Library (AOL) concepts like Application User Setup, Defining Responsibilities, Value Sets, Flexfields, Registering Menus, Forms, Reports, Concurrent Programs.
  • Expertise in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
  • Expertise on designing and implementing Oracle Alerts, Lookups, and in customizing existing OAF screens, forms and reports as per business requirements.
  • Developed new Concurrent Programs, Custom Forms, Reports and Flexfields Customizations.
  • Extensively used TCA (Trading Community Architecture) to create customers in AR.
  • Dextrous with client server environment and tools like SQL*Plus, PL/SQL, SQL*Loader, Toad, Oracle Forms, Oracle Reports, Workflow and BI Publisher (Formerly XML Publisher).
  • Experience in importing data from legacy systems to Oracle Applications using Oracle Interfacing, SQL*Loader, UTL FILE, Oracle Packaged APIs etc.
  • Expert in developing Technical design documents (MD70), Technical Test Documents (TE20), Conversion (CV50) and Migration Documents (MD120) using AIM (Application Implementation Methodology) and OUM (Oracle Unified Methodology).
  • Involved in Code Development, Unit Testing , Business Testing and Reconciliation of reports. Developed and executed test cases, test scenarios, test scripts. Involved in Functional, Performance and Regression testing.
  • Generate financial reports, such as income statements and balance sheets, based upon data in GL using FSG (Financial Statement Generator).
  • Gathering and reviewing of requirements specific to the Supply Chain, review and testing of global CEMLI elements.
  • Expertise with all ODI tools - Topology, Security Manager, Designer and Operator.
  • Expert in Requirement gathering, analysis, design, developing and Testing (CRP and UAT).
  • Interacted with users and provided daily support by resolving the bugs.
  • Excel in team collaboration, quick adaptation and problem-solving skills with good communication skills.
  • Strong debugging and analytical skills and troubleshooting.

TECHNICAL SKILLS:

ERP APPLICATIONS: Oracle Applications R12 (12.2.6/12.2.5/12.2.4/12.2.3 ) and 11i (11.5.10/11.0.3 ), AR, AP, GL, CE, FA, PA, AGIS, SLA, SCM, OM, PO, INV

RDBMS: Oracle 12c, 11g, 10g, 9i/ 8i / 7.x, SQL Server

LANGUAGES:: C, C++, PL/SQL, Java, VB, HTML, XMLXSLT, UNIX Shell Script

BUSINESS INTELLIGENCE: XML/BI Publisher, Discoverer Reports, Developer 10g, 6i Reports

TOOLS: TOAD, SQL Navigator, SQL Developer, S QL* Plus, Visual Source Safe 6.0, SQL*Loader, JDeveloper, ODI, Forms Builder, Reports Builder, Workflow Builder 2.6.3, Discoverer.

HARDWARE:: AIX, Sun Solaris (SPARC 32-bit), Pentium M

OPERATING SYSTEM: UNIX, LINUX, Windows 95/98/2000/ XP/ NT/Windows10, Windows 7 and SunOS

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Oracle Apps Technical Consultant

Responsibilities:

  • Responsible as a primary Technical owner for Accounts Payable (AP), Inventory (INV), General Ledger (GL), Purchasing (PO), Order Management (OM) and Accounts Receivable (AR) Modules.
  • Developed staging tables, conversion routines, Custom PL/SQL API’s for converting Requisitions, Suppliers, Supplier Sites, Supplier Contacts and AP Invoices from legacy systems to Oracle Applications.
  • Journal Import: Developed an interface for monthly import of journal entries from Payroll system by using the journal import Interface provided by Oracle General Ledger.
  • Design and developed an interface between Confidential and (AR) Oracle Receivables for Cash Receipts (Auto Lockbox).
  • Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
  • Customized various transactions in Account Receivables like Invoice, Receipts, Credit Memos and Debit Memos etc. Customizations of Requisition Approval, PO Approval & Auto Create Workflows.
  • Extensively worked in SCM modules (INV, iSupplier, OM).
  • Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Application using the Payables Open Interface Import program and populated into the Base Tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
  • Designed and developed process to replace the Oracle Internet Expenses module with the Concur and process payments. Developed the following as part of Concur implementation, OAF
  • Designed and developed FTP process to load Standard Accounting Extract file from Concur server to local server.
  • Created a custom program to load employee expenses data received from Concur to Oracle staging table using SQL*Loader and upon validating the uniqueness of the data loading these records in GL INTERFACE table and running the program to load to Oracle.
  • Created custom program to create employee flat file.
  • Created program to load Confidential statement import.
  • Created custom process to import Payroll Remittance file from Concur.
  • Expertise in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper.
  • Designed and developed new workflow to send email notification to group of people when modifications to Item Attributes, or Modifications to Customer details or Supplier details.
  • Customized the PO approval Workflow to notify to include Cost Center, Account and Ship to Location values in the notification message body.
  • Customized the Oracle PO form using Forms Personalization.
  • Developed custom forms from TEMPLATE.fmb and customized existing forms in the PO module as per the Client’s Requirements.
  • Created descriptive Flexfields for standard forms to allow users to populate extra information.
  • Utilized Forms Personalization utility to call a PLSQL procedure and update the Order Management Descriptive flex fields with Depot Repair flex field data.
  • Used FNDLOAD to download and upload AOL data (data request groups, menus, forms, functions; responsibilities; flex field value sets; users) from one instance to another instance.
  • Designed and developed PLSQL package/ UNIX script to ftp, validate and load Procurement Card Transaction data files into Oracle base tables.
  • Developed shell script program to assist the DBA’s in moving the custom code packs.
  • Customized reports in GL such as Trail Balance (Assets, Liabilities, Expenses, Revenues) and developed new reports in AP.
  • Generated reports on Account Balances, Budget Balances and Variance Reports using Oracle Discoverer and FSG.
  • Customized AR-CE Bank Reconciliation Batch Info Report.
  • Involved in Design AR Invoice Report Customization for Customer Invoice Notes with Print facility in Reports 10g and customize the report using XML Publisher.
  • Completed analysis of SCM strategies and drafted evaluative client reports.
  • As per the company requirements, created and implemented XML/BI Publisher reports for different products like AP and GL.
  • Worked closely with end-users and clients through complex problems involving deployment, testing and conversion in the Procure to Pay and Order to Cash.
  • Worked closely with functional team and business to resolve bugs, defects and resolved severity tickets ads well.

Environment: Oracle Apps Financials EBS R12 12.2.5, GL, AR, AP, PO, SCM, INV, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, Discoverer, UNIX, TOAD, SQL*Loader, Workflow.

Confidential, Connecticut

Oracle apps Technical Consultant

Responsibilities:

  • Worked on Production Support, attending production calls, troubleshooting the application and resolving bugs.
  • Handling daily tickets related to various user problems in AP, AR, AGIS, GL.
  • Co-ordination with various 3rd party vendors during business impacting changes and deployments.
  • Attending calls with the Business and Offshore team on daily basis for Requirement clarifications and delivery Issues.
  • Involved in the analysis of the assigned support tickets including replicating the issue, analyzing the custom processes/API’s/Reports/Forms and updating the ticket with the appropriate information.
  • Worked on the development activities such as part of issue resolution. Perform Unit Testing, migrate to next environments, assist user testing and closing the tickets.
  • Worked on inbound interface for importing the sales invoices from different Project billing application into oracle application using the Auto Invoice Master Program in R12.
  • Developed AUTOLOCKBOX Interface to load data that is received from bank into interface tables, from interface table to the Base Interim tables and finally to the base table.
  • Customized AR-CE Bank Reconciliation Batch Info Report as per the client requirements.
  • Involved in Requirement Analysis, Design and Develop custom applications in OAF. This involves analyzing MD50 (Functional Spec) and then writing MD70 (Technical Spec).
  • Identifying risks proactively and proposing solutions to resolve them.
  • Implementing, Customization of Oracle E Business Suit (EBS).
  • Developed AP Positive Pay Extract Reporting Oracle Payables which will extract the Canadian transactions from source systems and sent to bank.
  • Developed AP Check Printing Report to produce check file in the Oracle Accounts Payables to complete the correct formatting for checks processed from Oracle payables through check printing software.
  • Modified and updated existing custom forms to adapt to new database schema.
  • Developed AP Remittance batch report using XML/BI Publisher. Created Data Definition Templates, rtf templates and split the xml file using bursting feature in XML Publisher reports.
  • Developed Custom Reports for Billing History by Client, Invoices by Client Report and Projects NDR Report using Discoverer 10g.
  • Created SQL scripts and written Procedures using PL/SQL to load data from flat files into new tables (using both UTL and SQL Loader - for different cases).
  • Debugging the packages, functions, procedures and triggers.
  • Tuning the SQL queries for performance improvement.
  • Customized the Accounts Payable (AP) Vendor Entry Form as per business requirements.
  • Built numerous Custom value sets and defined values for value sets.

Environment: Oracle Apps Financials EBS R12 12.2.2, Finance (GL, AR, AP), PO, SQL, PL/SQL, Oracle Reports 10g, BI/XML Publisher, UNIX, TOAD, SQL*Loader, Workflow.

Confidential, Rhode Island

Oracle Apps Technical Consultant

Responsibilities:

  • Studied existing system and developed strategies for conversion of Legacy system data into Oracle Applications R12 (12.1.3)
  • Planning and performing the configuration, testing and documentation of the Oracle Accounts Receivable (AR) application version 12.1.3 after the reorganization of the company.
  • Developed Staging Tables, Conversion Routines, and Custom PLSQL API to import.
  • AR Invoices
  • Customers, Parties, Party Sites, Party Accounts (TCA Architecture).
  • Designed, Developed and Documented MD070 for Custom Interface for the AR Lockbox for Client’s requirement with Confidential, implemented this from writing control file according to transmission format defined for Confidential till Calling of Oracle Standard Process Lockboxes Program with Importing the data and Validation and Post Quick Cash Stage.
  • Worked on rounding customizations of dollar amount in iExpense using OAF. This involves customizing and extending controller CO and entity object EO.
  • Designed, Developed and Documented Custom Interface Program for Cash Management Bank Statement Interface with Confidential and Confidential . Achieved this from loading Bank file into CE TEMP table by calling standard Oracle Programs to till Import and Reconciliation of the Data.
  • Participated in the definition of Oracle lookups for SWIFT Auto-client Server
  • Designed, Developed and Documented Custom Interface for GL Journal Import by getting the file from FTP to import the data into Staging and Interface Tables and calling Oracle standard program Journal Import.
  • Designed, Developed and Documented Custom Interface Program for Cash Management Bank Statement Interface with Confidential and Confidential . Achieved this from loading Bank file into CE TEMP table by calling standard Oracle Programs to till Import and Reconciliation of the Data
  • Designed, Developed and Documented Custom Interface for GL Journal Import by getting the file from FTP to import the data into Staging and Interface Tables and calling Oracle standard program Journal Import.
  • Responsible for the Migration of code for other instances using version control software SVN and Kintana.
  • Designed and developed Customer Statement Reports using XML Serialize API and BI Publisher.
  • Worked with finance department (AP, AR, GL, FA, Projects ) on various reports like
  • Returns report,
  • Trail Balance Reports
  • General Ledger (GL) reports,
  • Check Register report, Receipt Balancing report,
  • AR Bill Balancing report,
  • Cash payment voucher
  • Bank Receipt Voucher
  • Cash Receipt voucher
  • Material distribution report by Product line,
  • Vendor exposure report.
  • Developed PL/SQL Packages, Procedures, Functions for validating the invoices and payment information from the legacy system and imported into Oracle Applications using the Payables Open Interface Import program and populated the base tables, which involved in Releasing Invoices from Hold, Approval of invoices and creating of New Invoices.
  • Developed the interface to integrate Oracle Projects with Oracle Loans.
  • Involved in customization for Oracle Loans/Accounts Payables/Fixed Assets Module
  • Worked on the issue where the drill-down from the GL to the FA Sub-Ledger was not available. (Found bug in the Oracle Standard system).
  • Worked on AR interfaces & discoverer reports of Disgorgements, Section 31, Host Pay and Outstanding Receivables.
  • Customized AR-CE Bank Reconciliation Batch Info Report.
  • Used FNDLOAD to migrate Concurrent Programs and Data Definitions in Various Instances
  • Populated element information into group of employees Using Batch Element Entry web ADI. Also did the user training, on how to use the BEE spreadsheet interface.
  • Handling daily tickets related to various user problems in FA, AP, AR, GL, CE modules.
  • Did SQL and PL/SQL programming for ODI.
  • Performance tuned the ODI interfaces.
  • Developed new OAF forms/ FMB forms as per requirement.
  • Personalized and customized OAF pages.
  • Involved in implementing iSupplier Portal that supplier can view orders, notifications, invoices and their status.
  • Invoice, Customer Invoice, Bill of lading, Purchase order, Mailing Label.
  • Developed Ad hoc Reports for clients.
  • Define your reports with reusable report objects, making it easy to create new reports from the components of reports using FSG.
  • Customized seeded reports to XML Publisher Standards per the business Requirements.
  • Developed Projects budgets, Projects Expenditures, Projects revenue and invoices, purchasing views using Discoverer
  • Modified the existing SQL reports to XML Publisher reports as per the requirements.
  • Create new OAF Page for Supplier Search and wrote Page Controller in Java with JDeveloper IDE.
  • Developed custom forms from TEMPLATE.fmb.
  • Scheduling reports to run automatically with the support FSG.
  • Developed a report using XML Publisher of the search results (Order bookable SKU’s) from the Order Booking Validation report.
  • Used Bursting technique to email the XML publisher output file.

Environment: Oracle R12 (12.1.3), SQL Plus 9.2.0.4.0, TOAD, FSG AP, AR, INV, PO, OM, PA, GL, CE, Projects, SCM, AGIS, Custom Grants, FA, CM, Oracle Loans, Order to Cash(O2C), ODI, OAF, Pentium M’, Windows XP, AIX, PL/SQL, Shell Script, AWK Scripts, Oracle Forms and Reports 6i, XML/BI Publisher.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in the up-gradation from Oracle 11i (11.5.8) to Oracle R12 (12.2.2).
  • Understanding of EBS architecture and underlying tables / columns in Oracle EBS R12 (12.2.2).
  • Designed and implemented custom Summary Billing Utility in AR with integration to Trading Community and Receivables.
  • Prepared Technical Specification (MD70) documents and conversion mapping (CV40) documents, created Staging tables, conversion routines developed custom PL/SQL API’s to import
  • Preparation of GL extract for the legal Audit purpose.
  • Migrated GL and AP custom interfaces and reports, during oracle financials upgrade project.
  • Troubleshooted the ODI connection with oracle by fixing the tnsnames.ora file, TNS listener and DNS entries
  • Responsible for Journal Imports from all other modules like Accounts Payables (AP) and Account Receivables (AR) into General Ledger (GL).
  • Analyse, Design and Develop OBIEE Analytics Metadata repository (RPD) that consists of Physical Layer, Business Mapping and Model Layer, and Presentation Layer.
  • Worked on the Budget Upload Open Interface to load the data from legacy systems to the GL Budget Interface table using SQL*Loader.
  • Designed, documented and developed Billing to GL Inbound Interface and validated the data before creating the journal entries.
  • Designed, documented and developed Auto-Lockbox interface with Confidential and Confidential Bank.
  • Expert in Oracle Application Framework (OAF) applications, customization of OAF pages, extension and creation of new OAF pages in JDeveloper 9i and 10g environment.
  • Unit and Integration testing of Receivables, Payables, General Ledger, Cash Management and Assets
  • Designed, wrote Functional (MD050), Technical (MD070) documents, developed custom PL/SQL API’s for interfaces
  • Inbound Interface to load Journals from ADP into General Ledger (GL).
  • Customized Confidential file formats for Confidential Bank and Confidential using XML/BI Publisher
  • Inbound interface with web based application to Customer Master to register prospective customers.
  • Customized Requisition Approval workflow for iProcurement, Purchase Order Approval Workflow.
  • Debugged workflow using workflow administrator to approve Requisitions, Purchase Orders.
  • Involved in customization of several standard reports to serve important business processes very specific to the client using XML/BI Publisher. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and Customer, receipts, invoice, and adjustment reports in AR.
  • Defined and generated FSG's report for Balance Sheets Marquette where rollup groups are considered for aren't/child relationship.
  • Prepare custom financial reports for month end MU process using FSG
  • Involved in customization of several standard reports to serve important business processes very specific to the client.
  • Reports included Purchase Order Detail Report in PO, Invoice on hold report Vendor, Payments, and analysis reports in AP , and Customer, Receipts, Invoice, and Adjustment reports in AR using Reports 10g.
  • Involve Functional, Performance and Regression testing.
  • Design and development of several PL/SQL packages, procedures and functions that were used in Custom Reports and Forms development.
  • As per the company requirements, created and implemented XML/BI Publisher reports for the different products like PO, AP and GL.
  • Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and also the required setup through Payables Options form
  • Customized seeded reports such as Invoice print report, Commercial Invoice, Customer Invoice report, Print Selected Invoice, transaction detail report, Account Status report in AR.
  • Provided on site solutions and resolved showstopper issues.
  • Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases.
  • Developed Reports in Billing and Costing like Customized sales summary report to evaluate the performance of the ware, Billing Review report and Detail Expenses report.

Environment: Oracle EBS 11i (11.5.8), R12 (12.2.2), SQL Plus 9.2.0.4.0, TOAD, FSG, AP, AR, PA, GL, CM, FA, Project Accounting (PA), SCM, AME, Pentium M’, Windows XP, AIX, PL/SQL, Shell Script, AWK Scripts, Oracle Forms and Reports 6i, JDeveloper, PVCS, XML/BI Publisher, SFTP, SSH.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

  • Involved in the up-gradation from Oracle 11i (11.5.10) to Oracle R12 (12.1.3).
  • Involved as a team member by interacting with the client to understand user requirements, preparing the Functional (MD50), Technical (MD70) design document and Conversion Mapping Document (CV40) to extract data from legacy system into open interface tables.
  • Analysis and Design strategy for conversion of Legacy Data into Oracle 11i Project Accounting module.
  • Worked on journal import interface program to import journal data from legacy system into GL Base tables.
  • Designed and Developed an Outbound Interface of GL Balances from Oracle GL to Assurant System as per the complex extract requirement depending on the flex field segment hierarchy.
  • Designed and Developed Staging tables, Data Conversion SQL Loader Program and Custom PL/SQL API to validate and import the Suppliers, Supplier Sites, Open Payable Invoices (AP).
  • Designed, documented (Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40) and developed an Interface between Third Party Payroll System and General Ledger Interface to import monthly Journal entries. Developed staging tables, Custom PL/SQL API to validate and load data into Interface table.
  • Integrated Kofax software system to read scanned pdf, fax pdf, email pdf invoice files and loaded them into staging tables and sub-sequently loaded into AP Invoice Interface tables and run Payables Invoice Import program to create AP Invoices.
  • Performance tuned the ODI interfaces.
  • Involved in customization of several standard reports to serve important business processes very specific to the client. Such reports include Purchase Order Detail Report in PO, Invoice on hold report, Vendor, Payments, and analysis reports in AP, and Customer, receipts, invoice, and adjustment reports in AR.
  • Involved in creating business areas, user views, custom folders and joins for reporting using Oracle Discoverer 4i in Administrative edition as per the user requirements.
  • Debug and resolve and Financial Statement Generator (FSG) reporting problems for month end purpose
  • Involved in Code Development, Unit Testing, Business Testing and Reconciliation of reports. Developed and executed test cases. Involved in Functional, Performance and Regression testing

Environment: Oracle EBS 11i (11.5.10), R12 (12.1.3), SQL Plus 9.2.0.4.0, TOAD, FSG report, AP, AR, PO, OM, INV, GL, FA, SCM, Project Accounting (PA), Oracle Grants, Pentium M’, Windows XP, AIX, PL/SQL, Shell Script, AWK Scripts, Oracle Forms and Reports 6i, Visio 2003, JDeveloper, SFTP, SSH, PVCS, Oracle 9i (9.2.0.5.0), Discoverer 3i/ 4i/ 9i.

Confidential

Oracle Apps Developer

Responsibilities:

  • Customized Oracle standard reports like AP and AR aging Reports , Purchase Price Variance , and ECO Report . And changed the output format to XML and created new templates for XML Publisher to display in pdf or Excel Format.
  • Performed various levels of testing (unit testing, functionality testing, integration testing, system testing).
  • Wrote test plans, test cases, test scripts to test the Procure to Pay, Order to Cash business process.
  • Provided post implementation support for SCM modules.
  • Involved in writing test scripts, unit testing of Forms, PL/SQL API’s.
  • Designed and developed Item LOT form.
  • Designed and developed Move Quantities for Bin-Transfer form.
  • Designed and Developed Sales Orders Items shortages report, Daily Inventory Transaction Report.
  • Performed Security Profile Setups, created new Responsibility, New Menus, New Functions, New Users and Supported the User community with daily interactions.

Environment: Oracle 11i (11.5.10.2), TOAD, SQL Developer, OPM Inventory, Formulator, OPM Process Execution, AP, AR, PO, INV, GL, FA, Sun Solaris Operating System (SPARC 32-bit) 5.8, PL/SQL, Shell Script, Oracle Forms and Reports 6i, Visio 2000, SCCS, SQL*Loader, Hummingbird Connectivity V8.0, Oracle 8i.

Hire Now