We provide IT Staff Augmentation Services!

Sr. Oracle Apps Technical Consultant Resume

4.00/5 (Submit Your Rating)

SUMMARY

  • Around 12 years of experience in Design, Development, Conversion, Customization, Interfacing and Implementation of business applications using EBS Oracle Applications R11i/11.0.x/R12.
  • Extensive experience in Project Life Cycle including requirement gathering and Analysis, Database design, Database development, Application development, Test and Support.
  • Extensive experience in Oracle Applications Modules (AR, AP, GL, SLA, OM, INV, PO, WMS), Advance Pricing, SQL, PL/SQL, SQL*Loader, Oracle Workflows, Developer 2000 (Forms 4.5/6i/9i/10g, and Reports 4.5/6i/9i/10g), BI (XML) publisher.
  • Very good experience with Order - to-Cash, Procure-to-Pay (P2P) and Financial Modules
  • Very good working experience with Agile Methodology
  • Worked extensively on Trading Community Architecture (TCA) and Multi-Org Environment.
  • Expertise Knowledge of Multi organization Access control (MOAC) architecture.
  • Good experience working in Advanced Supply Chain Planning ( ASCP )
  • Good experience working in Forecast system Demantra
  • Good exposer on the Service Contracts and CRM modules.
  • Extensive experience in Oracle 10g/9i/8i and hands on experience writing Oracle SQL queries and Oracle PL/SQL Stored Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors and using latest features to optimize performance (Bulk Collects, Collections, Ref Cursors, Materialized views, Global Temporary Tables).
  • Good experience on doing changes in WMS Telnet Java screens
  • Extensive experience in Reports Development in Oracle Applications R12/11i (OM, INV, AR, AP, PO, GL) using Reports 4.5/6i/9i/10g and BI (XML) publisher 5.6.2 and Discoverer.
  • Good working experience on developing Oracle Apex Reports.
  • Extensive experience in developing and customizing of workflows using Oracle Workflow Builder 2.6 with Applications 11i/R12, developed large complex workflows and customized the standard workflows.
  • Strong experience working with Web Services and EDI to interface the data to third party systems.
  • Extensive experience in developing Oracle forms and customizing Oracle seeded forms using Oracle Form builder 10g, especially expertise in developing Grid forms.
  • Good Experience in developing brand new OAF pages and doing changes in Oracle standard OAF pages.
  • Strong experience in all kinds of AOL objects, defining Logical Apps rules, Form Personalization, Oracle Alerts, defining Oracle Business Events and subscribing to them
  • Technically proficient in RICE (Reports, Interfaces, Configuration, Enhancements) methodologies in Oracle Supply Chain, Oracle Financials.
  • Experience in preparing AIM documents (MD50, MD70, MD120) during development and support and designing data/process flow diagrams using VISIO.
  • Experience in all phases of life cycle right from Planning, Requirements Gathering to Production support.
  • Proficient in writing and tuning complex SQL statements, complex joins co-related sub-queries and SQL statements.
  • Experience in tuning application using tools like Explain Plan, SQL*Trace and TKPROF for high efficiency.
  • Experience in writing dynamic SQL statements using EXECUTE IMMEDIATE.
  • Experienced in developing batch programs by using PL/SQL and shell scripts and in using SQL*Loader for loading data from flat files into Oracle tables.
  • Extensively worked with third party database tools like TOAD, SQL Navigator, SQL*PLUS, Jdeveloper .
  • Strong programming, debugging and problem solving skills and ability to translate customer requirements into technical solutions by utilizing business insights.
  • Ability to work within an aggressive and demanding project schedule and environment.
  • Excellent team player with strong analytical, presentation, and problem solving skills.

TECHNICAL SKILLS

Oracle Applications: AP,AR, GL, SLA, OM, INV, PO, WMS, ASCP, Demantra, CRM, Service Contracts

Languages: PL/SQL, SQL, C, C++, Unix Shell, XML, Java script

RDBMS: Oracle 11g/10g/9i/8i, MS Access

Oracle tools: Oracle Workflow 2.6, XML Publisher, Oracle Forms & Reports 6i/9i/10g, OAF, Oracle Apex Developer, WMS Telnet, Discoverer

Tools: /Utilities: SQL Loader, WS FTP, Putty, TOAD, Jdeveloper, SQL Navigator, PL/SQL developer, Oracle’s SQL*Plus, HP Kintana (4.7), Clear case, BMC Remedy

Operating Systems: Windows XP/2000/ 2003/Vista/7

Project Management Tools: MS Excel, MS Visio, MS Power Point

Testing Tools: Test Director 9.2, HP Quality Center

PROFESSIONAL EXPERIENCE

Confidential

Sr. Oracle Apps Technical Consultant

Responsibilities:

  • Design, Analyze and develop business solutions for Supply Chain, Planning, Process Manufacturing and Demand Application.
  • Integration of Third Parties like Transport insight (TI), Wilke Feed, APS (Automatic Palletizer System, Consumer Goods, Kronos Application).
  • Designed and Build various RICE - Objects using SQL,PL/SQL, Oracle API’s and Interfaces, BI Publisher, Oracle Reports, Oracle Forms and Workflows
  • Tremendous Experience in design & development of Reports, Interface, Conversion, Extension, Workflow (RICE-W) components.
  • Customized ISO process using Blanket PLO and flipping PLO to smaller ISO chunks by Warehouse Supervisor or Manager.
  • Design and Develop integration of TMS (Transport Management System) with Oracle EBS. Sending Details order details getting back with Ship method, Trip Information including Master BOL Number.
  • Design and Develop Shipping Workbench to have all functionalities Pick Releasing, Assign/Un Assign Trip/ Create Deliveries, Assigning to Employee for fulfillment of order execution, Assigning Stage/ Dock Door
  • Build and Designed Dispatch Form (Used for Pick Confirm) based on Trip.
  • Build Custom Process to Run Ship Confirm and Trip Close Functionalities based Delivery Date maintained in one of DFF Attribute.
  • Customized Order Workflow two integrated to populate auto schedule dates based on ship method and shipping calendar. Validating data based on booking event no of pallets.
  • Added Additional Nodes for creating Broker information transferring to third party and as well integrating other complex functionalities in while order fulfillment process.
  • Build Complete Custom Cycle Count Process Telnet Pages for Aggregate, Un Scheduled Counts, and Detail Cycle Count and Build monitor process to auto-generated cycle counts based on material movement in Warehouse.
  • Build Global WMS Rules based on Order Type, Customer and Pull Date of Product generated in Process Organization.
  • Order interface to Third party applications
  • Purchase Order conversion and Receiving interface
  • Developed new GL Interface program to upload the GL entries in the process.
  • Developed AR Invoice Interface which launch Auto Invoice Batch program and developed a custom form on this process as per the business requirements.
  • Developed complex custom forms with Grid functionality to meet the custom business process.
  • Developed Customer Conversion programs to load the legacy system data.
  • Developed Modifiers Qualifiers Conversion program
  • Developed Pricing & Promotion Conversion programs
  • Developed several reports using Oracle Apex Developer to reduce the production operational IT support.
  • Developed custom programs to massage the data after the planning pull is completed in ASCP.
  • Developed the custom programs to manage the data in different forecasting buckets in Demantra.
  • Developed several XML publisher reports show the detailed analysis between supply vs demand in ASCP and in Demantra.
  • Worked on the changes to Oracle OAF pages like customers and Vendors.
  • Developed AR Customer Statements using XML publisher with the bursting functionality.
  • Developed OAF form for Customer Statements Inquiry process.
  • Worked on the several WMS Telnet page changes like Interorg Express Receipt, Pick Reverse, Tasks, Case Pick.
  • Customized the AR Collections form to enable the Oracle provided custom tabs
  • Developed new custom process to interface the purchase orders details to third party system for Logistics purposes using web service calls.
  • Developed EDI processes to interface order shipments and LPN details to third party warehouses and to customers.
  • Thorough unit testing of all the components. Supporting QA &user testing and bug fixes.
  • Preparing install scripts and coordinating for the deployments.
  • Post go-live support.

Confidential

Sr. Oracle Apps Technical Consultant

Responsibilities:

  • Study the legacy systems and understand the business processes. Solution the business processes in Oracle R12 environment by maximum utilization of standard Oracle features.
  • Customer Requirement Study, Preparation of Development Requirements from customer Requirements
  • Worked on the interfaces like Oracle General Ledger Import interface, GL Daily Conversion Rates interface, AP Invoice Interface and AR Auto lockbox Interface.
  • Worked on the XML Publisher reports like AR Transactions Audit Report, Sales Order Holds Report and Purchase Order Acknowledgement Report
  • Worked on the forms personalization on the invoice transactions screen and Sales order form
  • Worked on the major customization in OEOL and OEH workflows
  • Major role in developing MD70, core development and preparation of MD120 for several modules
  • Developed Oracle Custom forms to enhance the functionality as per the business requirements.
  • Involved in analysis and development of major conversions and interfaces
  • Developed the new workflow process to enhance hold functionality from the scratch
  • Developed the new customer report using XML publisher with bursting functionality
  • Developed the Sales order inbound and outbound interfaces to third party export compliance system
  • Worked on building XML SOAP requests to interface the order details to third party systems
  • Participations in the code reviews and Technical design reviews in across all the modules.
  • Performing unit testing and coordinating for CAT testing and fixing the issues
  • Used SQL*Loader, UTL FILE package and External Table concepts for loading data into the Database tables through an automated process.
  • Analysis, design and development of Database procedures, functions and packages using PL/SQL as per the business process.
  • Involved in Optimizing SQL queries involving large tables.
  • Logging service requests with Oracle and working with Oracle to resolve Applications Software defects.
  • Providing assistance in coordinating and troubleshooting with different side system developers and business owners for side system interface application support.

Environment: : Oracle Applications R12, Procure to Pay ( PTP), Oracle Order Management(OM), Inventory, Oracle General Ledger(GL), Account Receivables(AR), Account Payables(AP), PL/SQL, Workflows, XML Publisher, Advanced Pricing

We'd love your feedback!