Sr. Oracle Apps Technical Consultant Resume
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