Detail Account

Gender:Male
Contact Us:+62 2151122675
Job Category: Fulltime Consultant (More Than 1 Year)
Status:Available
Freelance:No
Job Category:Tech Manufacturing Module, Tech Financial Module, Tech Distribution Module

Qualification


International Certified Oracle Boot Camp (2006) o Oracle Warehouse Builder 10g (10.1.0.4) o Oracle Discoverer Administration o Oracle Discoverer Desktop o AWM 10g (Analytic Workspace Manager) o Oracle AS Discoverer 10g o Oracle Business Intelligence Discoverer Administrator 10g o Oracle Database 10g – Using OLAP




Experience (Year)


5 - 10 Years


Experience


Fuji Xerox Asia Pacific Pte Ltd, July 2008
– Present Scope of Work covers of Oracle Distribution
– Support for Oracle Application Fuji Xerox Asia Pacific. Responsibilities and skills:
 Develop custom Reports, PL/SQL plus concurrent and sets. o PO Module:
• SS_TW_POXRQERQ
• SS CN:Purchase Order Summarized
• SS OM Pick Release and Ship Confirm from ALC/ANZ
• SS SG Receiving Account Distribution Report Report to display Account Distributions of PO Receiving Transaction for FXS
o INV Module:
• SS FXK Used Item Collection Detail Report Sell and used item collection detail printing for FXK, This report is provided to check the collection performance for ISO 14001 environment policy. This report is used as a fundamental data to export the collected used items to THFX. This report is used to manage the collection performance of subcontract company and to evaluate FXK collection performance as one of KPI. FXK Logistics team will use this report to inquiry the Collection information.
• SS FXK Emergency PO Report This report check the needed purchase order quantity, date and value based on the current available quantity, outstanding purchase order quantity and receipt schedule, usage quantity and lead time by item and supplier site.
• SS FXK Transactions by Supplier/Customer The report will display the transactions by supplier/ customer details.
• SS FXK Used Item Collection Summary Report Sell and used item collection printing for FXK, This report is provided to check the collection performance for ISO 14001 environment policy. This report is used as a fundamental data to export the collected used items to THFX. This report is used to manage the collection performance of Subcontract Company and to evaluate FXK collection performance as one of KPI. FXK Logistics team will use this report to inquiry the Collection information
• SS Interface Usage Information File to FXAP This will generate the output file for different OPCO’s based on the parameter. The output file will have usage information on daily or monthly basis depending on the parameter given.
• SS INV WIC Item category update processing program To update item Category and Update Item Attribute, The customization program “SS INV WIC Item category update processing program” will be used to update/create new item category. This program checks if category exists in Oracle, if it does not then category is created and assigned to item. This programs also updates serial control code to 5 if item code ='@' and product code = 'PC' and set attribute 15 =’Y’ when item is ‘EI’ and serial control.
• SS INV WIC Item Update Processing Program The customization program “SS INV WIC Item Update Processing Program” is update item attributes. This program updates the existing items attributes, In the program we populate items attribute data in the items interface table. From there standard program update the item attributes into the items base table. And also program generates one out file and writes details of the items processed by this program.
• SS MY Delivery Note By Move Order Report to generate Delivery Note for Move Order Number, This report is required to generate Delivery Note for specific move order numbers or range of move order numbers and stores a unique Document number in custom table for future reference in case of reprint. • SS MY Material Transaction Distribution Report with SN This report displays errors encountered during the processing of SS MY Material Transaction Distribution Report with SN(NEW) • SS MY Stock Replenishment Report - FXM
• SS TH BOM Upload Interface Set FX Logistics team will use programs to upload BOM from a text file. There are three major steps involved to upload data to a custom interface table, BOM validate and Create Common Bill.
• SS TH Monthly Transactions & Onhand Report • SS THFX Inventory Aging Data File • SS TW Inventory Monthly Closing Program • SS TW Transact Engineer Request (Mass Transfer) o OM Module:
• SS FXK Used Item Collection Detail Report The purpose of this report is to check the used item collection status by item and org. This report is provided to check the collection performance for ISO 14001 environment policy. This report is used as a fundamental data to export the collected used items to THFX. This report is used to manage the collection performance of subcontract company and to evaluate FXK collection performance as one of KPI. FXK Logistics team will use this report to inquiry the Collection information. • SS Back To Back PO Creation from SO Back to Back PO process start with sales order is in booked status and line is source from supplier not from own warehouse stock. The objective is to create one concurrent program • SS CN:OUE Report This report is printed in a process of Ship Confirm. Once Ship Confirm process is completed, a report is generated to display records for ‘Sales Order Issue’, ‘COGS Recognition’ and ‘RMA Receipt’. • SS Current Month Orders Detail Report The purpose of this document is to describe the technical design of Current Month Orders Detail Report. The report contains details pertaining to the Sub Category, Base Model, Product Model, Sales Terr, Account, EMP Name, Customer, Order Type, Line No, Order Date, Schedule Ship Date, Order Number, Order Qty, Dely Qty, Install Date, Serial Number, Do Number, and AAP XSI • SS FXK Delivery Notes • SS FXK Delivery Notes - Ship Confirm • SS FXK Delivery Schedule Plan • SS FXK Pick Slip Report • SS FXK Pricing Agreement Loading API ( DC ) • SS FXPC Backlog Report • SS HK Installation Report In Details • SS HK Installation Report In Details R11 • SS HK Supplies Delivery Note By Move Order • SS Incoming File Registration and Processed File Backup_test • SS MA Supplies Delivery Note by Move Order
• SS MY Equipment Upgrade & Contract Conversion Delivery Note
• SS MY Equipment Upgrade & Contract Conversion RMA
• SS MY NEI Outstanding Sales Order Report with Supersede & Qty
• SS OM Invoice RFR Fix
• SS OM Order/RMA Import Loader to Temp Table
• SS OM Order/RMA Import Validation and Send Notification
• SS OM to PA Push back Interface
• SS PC OM Internal Auto Order Import
• SS PH Delivery Receipt Report
• SS SG Costing Sheet Interface to Varicent
• SS SG Installation Detail for Mgmt Reporting_New
• SS SG Installation Summary for channel info New • SS SG Revenue By Salesperson & Customer
• SS TW OM SO Outbound Interface • FXTW Round Up WIP Transaction Quantity • SS CONS Open and Fulfilled Order Information (THFX) • SS Outbound Inventory Information File (THFX) • SS WIC Loading Parent Item Data to Item Interface (THFX)
• SS (FXPC) ALC Order Interface File Generation Program(PCS)
• SS Active Service Contracts to Excel
• SS ALC Pick Release and Pick Confirm
• SS CN Inter Org Auto Generate COGS • SS CN Miscellaneous Receipt
• SS CN OM Auto Misc. Receipt and Ship for KIT (by flat file)
• SS CN OM Auto Misc. Receipt and Ship for KIT Set
• SS CN OM OrderRMA Import Set
• SS CN OrderRMA Send Notification
• SS Current Month Orders Detail Report
• SS FXK Delivery Notes
• SS FXK Order Base Revenue Detail Report • SS FXPC (AUS) ANZ Order File Generation Program • SS FXPC AU RMA Report • SS FXPC Custom Invoice(SG) • SS FXPC DeliveryNote(SG)
• SS FXPC KR DHL Auto Ship Confirmation Program • SS FXPC Packing List(SG) • SS FXPC Service Agreement Acknowledgment Report(PS)
• SS FXPC Shipped Report • SS HK BOM Extraction Listing Report
• SS HK Installation Report In Details • SS Journal Entry Reserve Ledger Report • SS MY OpCo StockMovement Report • SS OM FA Data Extraction report(SQL)
• SS PC Opco CodeUpdate • SS PCA Order to ANZ Reconciliation Report • SS PH Delivery Receipt Report • SS PH RMA Report • SS Pick List Report without Locator • SS Price Comparison Report (FXCL) • SS Print Projects Invoices • SS SG ALC RMA File Generation Program • SS SG GL Balances • SS SG Installation Detail for Mgmt Reporting_New
• SS SG Installation Summary for Mgmt Reporting New
• SS SG INV Item Master Outbound Interface For 3PL • SS SG INV Onhand Outbound Interface For 3PL • SS SG Outstanding Equipment Orders Listing • SS SG Transport Billing Report (New)
• SS Tax Audit Trail • SS TH Outbound Gross in Usage File Daily
• SS TW OM SO Outbound Interface • SS TW SO InquiryForm and Release Hold
• SS VN BOM Upload Interface Set • SS VN OM Equipment Delivery Note (Postscript) • SS VN OM Sales Revenue report by Dealer o FIN Module: • SS FXK Used Item Collection Detail Report • SS Concur EDI to Expense Report • SS CONCUR SAE Data Mapping • SS FXPC Credit Note Printing • SS FXPC Print Invoices (Initiate Printing) • SS FXPC Taiwan Government Invoice Printing - Excel Format • SS FXPC Tax Invoice Printing • SS FXPC Transactions By Batch ID • SS HK Applied Invoice Report o Contracts Service Module: • SS MIF interface to Legacy - GSI  Modify / Develop custom Form, PL/SQL plus concurrent and sets. o PO Module: • Requisition (miss calculate total amount with ccy) • SS FXK Quantity On-Hand for Substitutes o INV Module: • SS THFX Item Master Update Attribute • SS Item On-Hand with supersession o AR Module: • SS TH Upload ALC Invoice to Interface Table o Contracts Service Module: • SS Contract Creation • SS Custom Task Management ( All Tasks - except Leave Tasks) • SS FXAP custom SR form  Modify custom.pll, Compile custom.pll. • FXPC Popup Supersession Screen • CUSTOM.pll  Create New and Modify Package, Procedure, and Function. o PO Module: • FXPC Popup Supersession Screen o INV Module: • SS TH Inventory Transactions Inbound Interface  Create New and Modify Oracle Application Personalization. o INV Module: • THFX form personalization on Item master  Create New and Modify Oracle Application Workflow. o OM Module: • OM Lines • ITSS Third Party PO Creation o AR Module: • ITSS-AL-OBE1-AR • ITSS-AL-OBE2-AR Project Experiences PT. Rajawali Nusantara Indonesia, January 2008 – Present Project scope covers implementation of Oracle Financials, Distribution, and Manufacturing module. Analytical Business Process of Oracle Financials, Distribution, Manufacturing module. Responsibilities and skills:  Develop custom Reports, PL/SQL plus concurrent and sets. o GL Module: • General Ledger Detail Report • Memorial Journal Report o AP Module: • Payment Distribution Report Custom o PO Module: • Purchase Requisition List Report • Master Vendor Last Report o AR Module: • Invoice o OM Module: • Delivery Order Report • Picking Slip Report - Sugar o CM Module : • Daily Cash In/Out Report • Realized Cash and Bank Report o FA Module: • Fixed Asset Report List and Depreciation o INV Module: • Inventory Stock Item Receipt • Inventory Stock Item Out • Available Item / Stock On Hand List Report • Inventory Item Usage List Report • Daily Inventory Receiving Activities Report • Daily Inventory Item Usage Activities Report • Material Item Usage Report • Master Inventory Item List Report o OPM Module: • Analysis Rendemen Individual  System Administrator o Create User Oracle o Setup Oracle Report Concurrent o Setup Printer Server o Creating/setup Concurrent Request (request set)  Customize Oracle Interface for Account Payables and Account Receivables (Part of Financial Module) : o Creating automatic journal from AR and AP module from one operating unit (A) to create automatic journal to other operating unit (B). Automatic journal take from AP/AR invoice DFF which already define by user in (A), then I am create some query (which already registered as a request set, so user just run request to create automatic journal) to fill field in GL_INTERFACE, then other site (B) just run journal import from General Ledger to import journal PT. HM Sampoerna Tbk, July 2007 – January 2008 Project scope Provide Script for BI in Purchasing Department Analytical Business Process of Oracle Purchasing to Create PO BI Report Responsibilities and skills:  Script for BI in Purchasing Module Project scope Provide Script for BI in Purchasing Department The script that integrated with all table that connect to PO transaction (user table, history, multi org table, transaction, distribution, shipment, etc), because this not like creating SQL script for oracle Report, the script more complex. The script must contain a historical of PO transaction so the query result can be duplicated row data. The most difficult is to make the query for data warehouse is not false with duplicated rows so the BI Report can be the right information to make decision Analytical Business Process of Oracle Purchasing to Create PO BI Report The analytical of Purchasing from the beginning of purchasing transaction, start from analytical making quotation from the supplier then making purchase requisition end then Purchase order to the end of receiving the item, I must analysis what and how much the dimensions to create, analysis the fact table that I create from the script. PT. Rajawali Nusantara Indonesia, Maret 2007 - July 2007 Project scope covers implementation of Oracle Balance Scorecard and Oracle Daily Business Intelligence Module Responsibilities and skills:  Installation Linux RedHat 3 update 6 o In charge to Install the Operating System (Linux Rathat 3)  Installation Oracle Apps 9.5.10 o In charge to install the oracle application (with database and Oracle Application) PT. HM Sampoerna Tbk, October 2006 – Maret 2007 Project scope covers implementation of Distribution module. Responsibilities and skills:  Develop custom Reports o INV Module: • INV-Berita Acara Claim Rokok • INV-Form Movement Transaction Report LPB • INV-Form Movement Transaction Report PAGD • INV-Form Movement Transaction Report PAGK • INV-Good in Transit Report • INV-Goods Receipt - Goods Issue Report AWO • INV-Goods Receipt - Goods Issue Report Factory • INV-LAPORAN BPPB • INV-Laporan Posisi Stok • INV-Move Order Report • INV-Pengiriman Rokok B/S HO Report • INV-Physical Inventory Report • INV-Picking List • INV-Realization Shipping Advice • INV-Recapitulation Differences per Area • INV-Stock in Distribution System Bad Stock • INV-Stock Movement • INV-Stock Take Form  Sql plus concurrent and sets for Register Oracle Report Custom.  Created an interface to integrate from Oracle Receivables Module with iSMS (SQL Server Database) system to validate the item that already receipt. PT. Rajawali Nusindo, July 2005 – October 2006 Project scope covers implementation of Oracle Financials and Distribution module. Environment: Linux RedHat 5, Oracle Applications 11.5.9, Oracle Database 9i, Oracle Developer Forms & Reports 6i Responsibilities and skills:  Develop custom Reports o GL Module: • General Ledger Detail Report Custom • Memorial Journal Report o AP Module: • Prepayment Transaction List Report • Reconcile Apply Prepayment Report • Reconcile to FoxPro Invoice Report • Reconcile to FoxPro Prepayment Report • Transportation Expenses Detail Report • Suspended Prepayment Report • Payables Accounting Entries Report o PO Module: • Purchasing Asset Report  SQL Loader o Make the PL/SQL script to load the beginning balance  Sql plus concurrent and sets. o Create Value sets o Setup Concurrent Program for Custom Report PT. Rajawali Nusantara Indonesia, January 2004 – July 2005 Project scope covers implementation of Oracle Financials and Distribution module. Environment: Linux RedHat 5, Oracle Applications 11.5.9, Oracle Database 9i, Oracle Developer Forms & Reports 6i Responsibilities and skills:  Develop custom Reports o GL Module: • General Ledger Detail Report Custom • Memorial Journal Report o AP Module: • Cash In Advance Report • Accounts Payable Report list • PO register • Cash In Advance Report • Payables Invoice Payment Detail • Payables Accounting Entries Report o PO Module: • PO Report o AR Module: • Credit Limit Summary Report • Receivables Transaction Receipt Detail o OM Module: • Sales Bonus Report • Sales Item Report • Weekly Sales Report • Summary Bonus Report o CM Module: • Cash/Bank Activity Report o INV Module: • Sales Area Report • Claim Report List • Loan Administration Report • Return Goods Report List


Back to previous page
^