Description
Backup/Recovery * Some of the important and critical reports/interfaces to highlight in many P2P and O2C modules (e.g. OM, WSH, INV, PO, AP, AR, GL, WSH) were: GEMS AR Invoice printing report for New Zealand, GEYMS Inventory Summary Report for Japan, Workflow package fixes related to Requisition Approval, PO Receipt Error Report, Requisition Interface, PO Conversion, Dropship ASN Re-Processing RCV Transactions Interface, ASN Import, China Blanket PO Release Report, Purchase Requisition Import, Inventory Material Issue Report, Pick Slip Report for Canada, Creating Drop Ship Extract, GL Daily Rates Interface, AP Trial balance Report * Working with Unix Shell Scripts, SQL Loader and UTL_FILE package * Implemented Oracle 9i Data Mining Features in Business Intelligence module of the above product based on 'Naïve Bayes' and 'Association Rules' algorithms for the predictions classifications and finding patterns and analyzing co-occurring events. * Implemented Transparent Gateway Heterogeneous Services Connectivity feature of Oracle 9i to pull application data from non-Oracle databases. * Schema design for all database tables and procedures and for Data Mapping and migration to new Oracle 8i DB from existing Sybase DB.