Oracle Apps Consultant Resume
CT
SUMMARY
- Around 8 years of experience in the IT industry mainly implementing Oracle ERP systems primarily using, PL/SQL, Oracle Forms and Reports, XML publisher and Oracle Applications.
- Successfully completed 3 Full life cycles projects with Oracle Applications 11i (11.5.10) and R12.
- Worked on all stages of SDLC (Software Development Life Cycle) including requirement analysis, design, development, testing and implementation.
- Extensive knowledge of Testing of Oracle databases, Oracle Forms, PL/SQL and UNIX with Excellent functional Testing and analytical skills
- Experience in All Financial Modules, Account Payables (AP), Account Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), iProcurement, Project Accounting (PA), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM), Advanced Pricing, Customer Relations Management (CRM), Shipping(WSH) and AOL modules.
- Proficient in Procure to Pay (P2P), Order to Cash (O2C) and Supply Chain Modules.
- Good understanding of data flow in the different modules of Oracle Applications.
- In - Depth knowledge of the Apps data model, which helps in all aspects of development cycle such as building Custom Reports, data validation, data import etc.
- Involved in Implementation, customization of several Oracle Financial Applications, Data mapping of Oracle functionality with Business requirements, historical conversions, interfaces and customizations.
- Involved in writing documents MD50, MD70, CV40, etc using AIM (Application Implementation Methodology).
- Experience in OA Framework, customization and Personalization of JSP pages.
- Integration of Modules and Business rules along with Setups, Standard and Custom Interfaces, custom reports and other customizations in Oracle Applications have been successfully implemented using strong technical and functional understanding of modules.
- Technically proficient in RICE (Reports, Interfaces, Conversions, and Extensions) methodologies including Implementation, Interfacing, Conversion and Data Migration, experience in up gradation to Oracle Apps R12.
- Experience in using Oracle Discoverer and XML publisher for reports generation.
- Expert in SQL, PL/SQL, Developer 6i/9i (Forms 6i/9i/Reports 6i/9i), Workflow Builder 2.6, SQL* Loader, Shell Scripting etc.
- Expert in troubleshooting and fixing the bugs, creation of SR/TAR with metalink, obtaining patches from oracle support and applying patches with coordination of Apps DBA.
TECHNICAL SKILLS
ERP Versions: Oracle E-Business Suite (10.7, 11i and R12).
ERP Modules: Payables (AP), Receivables (AR), General Ledger (GL), Fixed Assets (FA), Cash Management (CM), Purchasing (PO), Order Management (OM), Inventory (INV), Bills of Materials (BOM), Work in process (WIP).
I Modules: I-Procurement, I-Expense, I-Supplier, I-Store
Tools: TOAD, SQL*Loader, Developer 2000/6i/9i, Discoverer 4i/9i/10g, XML Publisher, Workflow Builder.
Operating Systems: Windows XP/NT/2000/98/95, DOS 6.0/3.0, UNIX, Linux.
Languages: C, C++, JAVA, SQL, PL/SQL, Shell Scripting.
RDBMS: Oracle 10g/9i/ 8i/8/7.3, SQL Server, and Ms-Access.
Web Technologies: HTML, XML, Java Script, Java Servlets, and JSP.
Administration: Oracle DBA, Server Manager.
PROFESSIONAL EXPERIENCE
Confidential, CT
Oracle Apps Consultant
Responsibilities:
- Design, Documented and developed Conversion routines, Custom PL/SQL API’s for Invoices, Suppliers, Requisitions and Purchase Orders from legacy application.
- Designed customizations, interface/conversion mapping, pre production testing, and related documentation.
- Managing a team for support of Oracle Financials (General Ledger (GL), Account Payables (AP), Account Receivables (AR), Cash Management (CM), Fixed Assets (FA) modules)
- Provided Order to Cash (O2C) process analysis for the integration of Scholastic’s newly acquired business units into their existing R12 environment.
- Experience in Procure to Pay (P2P), Order to Cash (O2C) and Supply Chain business flows.
- Proficient in customizing Workflow in Oracle apps.
- Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs .
- Involved in Requirement Analysis, Design and Develop custom applications in OAF.
- In OAF, developed the new custom pages from scratch, done the EO, VO and AM extensions and page personalization’s.
- Design and developed user interface components using ADF Rich Faces.
- Developed UI fragments, templates and bounded task flows in ADF using Jdeveloper 11g
- Designed and developed an Inbound Interface between web based Order management systems Odyssey to Order Management (OM) for import Sales Orders.
- Understand the functional requirement and prepare MD.070 - Technical design document for various GAPs of functionality around Order Management, Service Contract and AR, Vendor Refund, iStore Integration to Quoting.
- Personalized page to enable submit button on the train flow of iProcurement page
- View Object extension for several OAF pages to display a new custom attribute column in the LOV
- Used XML Gateway Execution Engine for interfacing E - Business Suite via business events subscriptions to retrieve data from or populate data into the Oracle e - Business Suite tables
- Used XML publisher to print, email and fax the reports.
- Designed XML Templates, XML publisher reports. These are configured to generate output in PDF format
- Developed PL/SQL Procedures for Customer interface using TCA in Accounts Receivables according to Client Requirements.
- Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for Suppliers, Supplier Sites, Supplier Contacts, Customer Import (Parties, Party Sites, Party Accounts, and Party Account Uses) using TCA, Order Import from legacy system to Oracle Applications implementation of oracle Applications (PO, AP, INV, iProcurement, iExpenses and AR)
- Oracle On-Demand; Modules: PO, IProcurement, OM, INV, Discrete Manufacturing and Quality and numerous 3rd Parties’ Software.
- Responsible for converting the entire Historical Purchase Orders (PO) using Import standard Purchase Orders into Production.
- Responsible for converting all the Historical Purchase Order Receipts using Receiving Transactions Processor into Production.
- Transferred all the Payments to General Ledger and then imported the journals by Payables.
- Worked on Inbound and Outbound programs for passing the Picked lines to the 3rd party system and shipping the records sent from 3rd party system back to Oracle.
- Imported the journal entries from legacy system to Oracle General Ledger using SQL*Loader, PL/SQL package and populated the data into the GL interface.
- Developed the interface program for GL Interface, which takes data from the Custom Tables and generating Journals in Oracle General Ledger as of Client’s Requirements.
- Customized the Journal Line Report in Oracle General Ledger and Invoice Aging Report in Oracle Payables.
- Created Data Definitions and Data Templates for XML Publisher reports.
- Fixed accounting issues with Invoice Reconciliation Report and write offs with lot of analysis.
- Developed a custom report to daily list all the rejected invoices based on the interface table using BI Publisher.
- Designed and Developed Suppliers report and sorted data by Invoice Amount in BI Publisher.
- Customized Printed Purchase Order Report, Invoice Printing Report, Aging - 4 Buckets Report, Trail Balance Aging Report.
- Customized the Backorders Detail Report, Backorder Summary Reports, Tax Reports and Revenue reports.
Environment: Oracle Application 11.5.10.2, 11i, R12, AP, AR, FA, GL, OM, jdeveloper, Oracle RDBMS 10g, Discoverer, OAF, ADF, Developer 2000 (Forms 6i/9i and Reports 6i/9i), UNIX, and Sql Loader, order management.
Confidential, Philadelphia, PA
Oracle Techno-Functional Consultant
Responsibilities:
- Inserting records into custom notification table Sending/resending notification to customers & Sending a reminder notification Inserting records into custom notification history table
- Designed and developed a custom package for validating email address format & DomainConversions/interfaces:
- Involved in functional document review and prepared technical requirement specification based on the business requirement.
- Involved in Production Support for Oracle R12 Invoicing and Suppliers related issues.
- Involved in Code Review Process to make sure that code is in compliance with AIM methodology.
- Designed and developed an Inbound Interface between web based Order management systems to Order Management (OM) for import Sales Orders.
- Developed a Custom Interface in OM that accomplishes Pick Release and Ship Confirm Process in Oracle using APIs.
- Customized iProcurement page using Jdeveloper (OAF).
- Analyzed an SR on interface trip stop program and modified and executed the script for different internal requisitions and sales orders (OM). Converted the same script into Concurrent request.
- Configure Service Contract Module for Europe Operating Units
- Design Service Contract Maintenance interfaces with various sources
- Prepared Technical specification documents (MD70) for Reports customized.
- Built Functional spec (MD50) documents on reports developed in Purchasing and Accounts Payables while interacting with the end users.
- Involved in creating Views for Custom Reports.
Environment: Oracle Applications 11.5.10.2, AP, AR, GL, OM, INV, BOM, WIP, PL/SQL, TOAD, jDeveloper, Forms 6i and Reports 6i, SQL*Loader, SQL*Plus, XMLP, UNIX, Shell scripts.
Confidential, Arlington, VA
Oracle Applications Techno-Functional Consultant
Responsibilities:
- Prepared various AIM documents like MD50, MD70, CV40 etc.
- Designed, documented and developed Staging tables, Conversion routines, and Custom PL/SQL API for Suppliers, Supplier Sites, Supplier Contacts, Customer Import (Parties, Party Sites, Party Accounts, and Party Account Uses) using TCA, Order Import from legacy system to Oracle Applications.
- Developing Generic Packages using PL/SQL to build flat files to manage transmissions across Legacy and Oracle Systems.
- Developing Flexible PL/SQL Scripts/Packages for Data Objects Creation such as Tables to store legacy data and to maintain data for staging interim phase.
- Developing SQL Loader control scripts to process the legacy data and to load them into Temp Staging Area.
- Developed PL/SQL Scripts/Packages for Payables Invoice Import, AR Auto-Invoices Interface
- Defined Customer Profiles, Customers, Payment terms, Payment methods and tax structures including tax exemptions and tax exceptions in accounts receivables.
- Insured that TCA (Trading Community Architecture) was implemented properly and all the customers are loaded in HZ Tables.
- Design and development of Auto Lockbox interface so that the bank file will be automatically imported into Accounts Receivables.
- Personalized JSP pages for I-Receivables.
- Defined various lookups/quick codes which can be used in different data conversions from legacy systems to oracle system
- Wrote a package containing different procedures and functions using PL/SQL to cross validate invoice information and load automatically invoices into auto invoice interface tables.
- Created Invoices against Purchase orders using Payable Invoice Interface program.
- Developed validation programs to validate the data before loading into interface tables from staging tables.
- Developed Dunning Letters using XML Publisher and sent to customer. Created Data Definitions and Data Templates.
- Developed a custom report using XML Publisher in Manufacturing that lists New Discrete Jobs created (since last report was run) and shows all the material requirements for the job
- Customized reports in OM and Inventory such as: Pick Slip Report, Warehouse Performance Report, Open Orders with deliveries, Inventory Reserve Report.
- Involved in Building Customizations and Enhancements using Reports and Forms.
Environment: Oracle Applications R12 GL, AR, AP, PO, iReceivables, PL/SQL, TOAD, Forms 6i and Reports 6i, Discoverer 10g, Jdeveloper, SQL*Loader, SQL*Plus, UNIX, Shell scripts.
Confidential
Oracle Apps Technical Consultant
Responsibilities:
- Wrote Technical Specifications, Conversion-mapping documents for Item Import, BOM Import and Payables Open Interface Import.
- Designed and Developed Conversion Routines, Custom PL SQL API’s for Item Import and Payables Open Interface Import (Invoice Import)
- Designed and Developed Custom PL/SQL program to assign categories, cross s, sourcing rules and locations to items.
- Designed, documented and developed Wells Fargo Bank to Oracle Cash Management Interface.
- Customized NACHA file format for Wells Fargo and BANK ONE.
- 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.
- Involved in Oracle Application’s Database Administration.
- Design, Documented and Developed Conversion routines, Custom PLSQL API’s for Purchase Orders (Headers, Lines, Distributions) from legacy mainframe applications.
- Design, Documented and Developed Conversion Routines, Custom PLSQL API for Item Conversion and successfully Loaded the items.
- Design and Developed Detail Payment Reports with to Salesperson, Branch Level Transaction report and Customer’s outstanding report.
- Customized the Backorders Detail Report, Backorder Summary Reports, Tax Reports and Revenue reports.
- Fixed bugs and Resolved issues related to Key Flex Field Security Rules, Cross Validation Rules, Item Property Rules, etc,
- Created EUL using Discoverer Administration and granted Privileges and Security Roles to all users.
- Created Business Areas, Workbooks, Folders, Items built on SQL, PL/SQL Functions and Joins.
Environment: ORACLE Applications 11i (11.5.6), Oracle 8i, Forms 6i, Reports 6i, SQL*Plus, Toad, SQL Navigator, PL/SQL, Sun-Solaris 7.
Confidential
Oracle apps Technical consultant
Responsibilities:
- Responsible for development of Purchasing & Inventory Control Modules for implementing security based roles, created users in Oracle also involved in development of Financial Accounting System, production, Dispatch & Maintenance System.
- Created Tables & Views and referential integrity constraints using SQL.
- Wrote Database Triggers, Procedure & Functions using PL/SQL.
- Analyzed requirement of client and worked on developing and designing reports.
- Design and development of data entry screens.
- Developed all the sales reports for the company using Reports.
- Implemented Security by creating different users/roles and assigning roles to users forms.
Environment: Oracle 7.x, Developer 2000, PL/SQL, Windows 95