Job Details: Business Analyst (Oracle Retail) Date: Sep 21 2022

Job Tools

-Supply chain (logistics) experience Required 5 Years
-Retail experience (merchandizing systems inventory management systems)Required 5Years
-Robocom Warehouse Management System (RIMS) Highly desired 2 Years
-Oracle Retail Suite (Retail Management System, Store Inventory Management System) Highly desired 2 Years
-Oracle e-Business Suite (financials) Highly desired 2 Years
-Oracle Retail Data Warehouse and Business Intelligence (OBIEE) Highly desired 2 Years
-Complex account reconciliations Required 2 Years
-Ability to develop inventory controls and reports Required 2 Years
-Ability to assess system usability and efficiency of processes Required 2 Years


Experience: 7 plus years
Education: 4 year college degree or equivalent and IIBA-certified Business Analyst.
� Document and assess inventory control issues, recommend and complete process improvements and test to assure that improvements enable daily reconciliation of inventory quantities and dollars across the disparate Oracle modules.
� Assess that proper accounting entries are made in all modules and that internal controls are adequate to fully safeguard LCB inventory.
� Determine that system interfaces are working as intended and can be reconciled one to the other.
� If needed, work closely with our suppliers� inventory control personnel to monitor and control movement of product within PLCB warehouses to over 600 retail locations. Approximately 80% of inventory in PLCB warehouses is under bailment.
� Function as an expert in the data flow from the store handheld devices (scanner guns) into Point of Service (POS) to SIM to RMS and finally, to the General Ledger.
� Establish and maintain good working relationships with all levels of management in Finance, IT, Supply Chain, Retail Operations, Comptroller, and potentially with 3rd party logistics providers.
� Develop database queries from Oracle database based applications and an Oracle data warehouse along with capability to implement multi-faceted improvement processes to better control inventory.
� Exercises considerable independence and initiative for inventory movement and control processes.

The selected candidate will be involved in reconciling inventory between all Oracle Modules in a bailment inventory setting. This is a hands-on analysis role.