Description
Professional Summary: * 5 Years of IT experience in Oracle Technology with emphasis on Oracle Manufacturing & Distribution modules. * Experience in analysis, design, development, customization and implementation of various business applications using Oracle Applications E Business Suite R12 / 11i. * Successfully completed 3 full life cycle (FLC) implementations of Oracle Applications in Release 11i (11.5.10) & Release 12. * Experience in Supply chain Management (SCM), Inventory (INV), Bill of Materials (BOM), Work in Process (WIP), Purchasing (PO), Order Management (OM), Istore, HTML Quoting and Oracle Configurator Module. * RICE components: Oracle 11i ERP - Oracle Configurator Developer and Configurator Administrator module. * Strong in writing Java Extensions for Oracle Configurator. * Strong Experience in Conversions, Interfaces, Extensions, Customization (Forms/Reports) and Shell Scripting. * Development of In-bound interfaces, Out-bound interfaces and Conversions by using SQL* Loader and UTL File. * Expert in Procure to Pay (P2P), Order to Cash (O2C) and Supply Chain business flows. * Good Experience in SQL, PL/SQL, Developer 6i/9i (Forms 6i/9i/10gReports 6i/9i/10g, SQL* Loader, UNIX/LINUX, Shell Scripting etc. * Functional Knowledge in INV, PO, BOM, OM and Configurator. * Expertise in developing documents MD50, MD70, CV40, etc using AIM (Application Implementation Methodology). * Extensive experience in new forms development, Form personalization, reports, AOL, System administration, Custom.pll, Performance Tuning etc. * Expert in requirement gathering, analysis, design, developing and Testing (CRP and UAT). * Strong analytical, technical, communication and team skills. * Experience in onsite/offshore model of Software development. Project Summary: * The project involved Deployment and Customization of Oracle Configurator to enable customers to configure their product to suit their requirements. Invoke the Configurator from the Sales Order line of Order Management responsibility and configure the product, bring all the BOM details to the Sales Order line, then perform the complete Manufacturing cycle which includes creation of configured item (Star Number), Discrete Jobs, Assembly, packing and Shipping. * Build the Configuration Models 21k, 41k about 40 models based on different configurations. * Build the Oracle Configurator for the product lines such as Control Valve series to incorporate the complete engineering and design aspects (Sizing and selections) and publish to Order management. Responsibilities: * Requirement Analysis based on the MD50. * Generate MD70 - Technical design document - using AIM 3.0. * Generate CMD-Configurator Model document - for each control valve series. * Creation of Model structure along with rules, GUI and price attributes. * Created custom GUI Templates and Master Templates as per customer requirements. * Publishing the model to Host application. * Unit testing (after publishing to Host Application). * Oracle 11i (11.5.10) Apps- Inventory, Bills Of material, Oracle Configurator Developer, Oracle Configurator Administrator, Order Management, HTML Quoting. * Developed Configurator extension rules based on the requirement. * Developed customer user interfaces using java. * Responsible for Model publishing. * Order and Quote Attachment: To get an attachment (File Type) at the Order and Quote line which gets generated within the Configurator in case of complete configuration for each line in the sales order. Environment: Oracle R11.5.10.2, TOAD, Inventory, OM, BOM, Oracle Configurator, HTML Quoting, PL/SQL, Shell Script, Oracle 9i, JAVA. True Temper Sports, Memphis, USA- Offshore Oct' 06 - Jul'08 Role: Oracle Apps Technical Consultant True Temper's golf shafts have probably withstood many golf course temper tantrums. The firm primarily makes golf shafts and bicycle tubing, forks, and seat posts. Its steel manufacturing facility in Mississippi makes steel products for the bicycle, automobile, and golfing industries. Responsibilities: * Preparation of Technical specification documents like CV60, MD70 using AIM 3.0 from the functional specifications received from the functional team. * Writing custom packages to develop conversion and interface programs. * Developing reports, conversion and interface programs that are registered as concurrent programs and which are run from SRS form. * Item Import Conversion: This deliverable was to convert Items from legacy to Oracle. * Standard Item Import program was submitted from the custom code itself. * Developed PO Requisition Import Interface program. * Import Customer Items & Cross Reference Interface. * Developed a program for importing Customer Items and Item Cross Reference. * Vendor Import Conversion: This program imports new vendors and vendor sites from feeder systems. * Developed Standard Purchase Order Interface. * Approved Supplier Lists Using API. * Developed Quotation Import Interface program. * Developed Bill of Materials Conversion Programs. Forms and Reports: Reverse Auction Form: Developed a new form for Reverse Auction. BOM Substitute Component Report: Developed report to give the list of substitute components for the component items in the bill of material through XML Publisher. Environment: Oracle E-Business Suite 11.5.10.2 (Modules: INV, OM, BOM, PO), Toad 9.6.1, tables, views, packages, procedures, functions, triggers, PL/SQL, Oracle Reports 6i, Oracle Forms 6i, XML Unix, Shell Scripts, Putty, Microsoft Outlook, Microsoft Office Suite 2007 and Windows XP Professional
Accomplishments
Highlights:
Keywords
