We provide IT Staff Augmentation Services!

Sr. Oracle Apps Techno Functional Consultant Resume

5.00/5 (Submit Your Rating)

Horsham, PA

SUMMARY:

  • 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.
  • Good Knowledge base on EBS Cloud, have an experience analyzing the EBS cloud (SAAS) for the pilot project
  • 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: Oracle Applications 11.0.3, 11i, R12

Modules: AP,AR, GL, SLA, OM, INV, PO, WMS, ASCP, Demantra

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, Horsham, PA

Sr. Oracle Apps Techno Functional Consultant

Responsibilities:

  • Design, Analyze and develop business solutions for Supply Chain Application and Finance Applications.
  • Integration of Third Parties like High Jump and Tradesphere applications.
  • Major part of the design develop and implementation the project to solution the China Tariff Charges imposed on China imported items to USA.
  • On going support for Tariff charges to customers and generating invoices on regular basis or on demand.
  • Developed several XML publisher reports to show the china tariff metrics to users analyses the imposed taxes to customers vs paying to government.
  • Study the Order Management, Quote and Configurator legacy systems and understand the business processes. Solution the business processes in Oracle R12 environment by maximum utilization of standard Oracle features.
  • Worked on Order Management (OM), Account Receivables (AR), Account Payables (AP), Inventory and Purchasing Module.
  • Worked on the project to Auto Source the Blanket Purchase Orders based on Quotes from the Sourcing system
  • Worked on the project to Auto import the Suppliers and Sites from the Sourcing system.
  • Working on Volume reductions and other temporary process oriented changes to handle the Incidents in critical situations. Creating problem tickets to reduce recurring incidents by offering permanent solution.
  • Work on high / critical business impacting incidents in Oracle Order Management, Shipping, Receivables, General Ledger, EDI and Workflow support the export compliance and screening issues of orders, customer and shipment data in JPM Tradesphere 7.2 / 8.1.

Confidential, Charlotte, NC

Sr. Oracle Apps Techno Functional 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 order details getting back with Ship method, Trip Information
  • Design and Develop custom 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.
  • 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.
  • 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, Davidson, NC

Oracle Apps Techno Functional 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 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
  • 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.

Confidential, Horsham, PA

Technical Consultant

Responsibilities:

  • Involved in gathering business requirements and designed the process flow for the Application Process.
  • Prepared the Technical Design Document based on the Business Requirement for various modules.
  • Written interface programs for AR customers, AR invoices, PO vendors/AP Suppliers.
  • Developed the Sales Order Interface Program to Third Party systems like export Compliance systems and also developed the Order Import interface.
  • Did the major customizations in the standard PO workflow - POAPPRV
  • Developed a full-fledged approval workflow suite for Order Claims and Prices change approvals process.
  • Worked on the Sales Order Acknowledge Report and Packing Slip customizations
  • Developed new form to setup the customer and warehouse offset days and preferred scheduled dates
  • Used SQL*Loader, UTL FILE package and External Table concepts for loading data into the Database tables through an automated process.
  • Developed the logical Apps rules for better user friendly environment, customized the forms using form personalization and developed Oracle Alerts for the users based on the business transactions.
  • Analysis, design and development of Database procedures, functions and packages using PL/SQL as per the business process.
  • Developed the XML publisher report with bursting as per the client requirement
  • Used External Tables to load test data from CSV files to the database tables from Front end.
  • Involved in Optimizing SQL queries involving large tables.
  • Created database triggers to track of the transaction changes and kick of the business events.
  • Created Indexes and Materialized Views to improve the overall system performance.
  • Tested the application to ensure proper functionality, data accuracy, and modifications had no adverse impact on integrated system environment.
  • Registered PL/SQL packages as concurrent programs which allowed users to execute them on-demand.
  • Used Autonomous transactions in triggers for supporting Audit and also used in packages for logging the process information.
  • Used Ref-cursors, Collections and Bulk Collects for memory intensive processes and to improve traceability.
  • Used Global Temporary tables in the process giving ability to PROD support for running journals concurrently across multiple sessions.
  • Maintenance and support of existing applications with the users.
  • Worked in the production support to debug and fix the issues on quick time frames

Confidential

Oracle Apps Developer/Support Analyst

Responsibilities:

  • Application Developer: Worked on developing interfaces on receivables, payables and customers data with downstream systems. Worked on Order Management (OM), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Inventory, Purchasing (PO), Bill of Materials (BOM), EDI, Field Service, Install Base, Service Contracts modules.
  • Incident Management : Work on high / critical business impacting incidents in Oracle Order Management, Shipping, Receivables, General Ledger, EDI, Workflow and Service Contracts Modules. Also support the export compliance and screening issues of orders, customer and shipment data in JPM Tradesphere 7.2 / 8.1. Worked on Order Management (OM), Account Receivables (AR), Account Payables (AP), General Ledger (GL), Inventory, Purchasing (PO), Bill of Materials (BOM), EDI, Field Service, Install Base, Service Contracts modules.
  • Maintenance Fixes: Small enhancements and break fixes to production issues is also done following Change management, release management processes to ensure quality.
  • Problem Management: To assist the Incident Management team to drive down the number of incidents by identifying the root cause. Perform Post Incident Review on major incidents.
  • Worked on the forms personalization of Purchase order screen and Requisition form
  • Prepared program specifications for PL/SQL (Procedures, Functions and Packages) for daily policies and for the development of the application.
  • Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Exception Handling, Records and Collections.
  • Creation of database objects like tables, views, Materialized views, sequences, Synonyms, database links and indexes.
  • Fine Tuned procedures for the maximum efficiency in various schemas across the database using Oracle Hints, Explain plan and Trace sessions for Cost based optimization.
  • Generated and maintained Keys, Constraints and Relationships between the tables for OLTP instances.
  • Optimized critical queries to eliminate Full Table scans reduce Disk I/O and Sorts.
  • Wrote shell scripts for loading data from Flat Files to database tables using SQL*Loader.
  • Tuned the SQL using Explain Plan, TKProf and Stats pack for better performance.
  • Wrote UNIX Shell Scripts for automating the daily/weekly/monthly data process.
  • Worked in the production support to debug and fix the issues on quick time frames in all types of RICE objects line interfaces, enhancements, forms and reports.

We'd love your feedback!