Business Center Analyst - LEYTE Based

San Miguel Corporation

  • Leyte, Leyte
  • Permanent
  • Full-time
  • 2 months ago
PURPOSE OF THE POSITION
  • Data Input of Chicken Station sales from supermarkets and distributors in SMSIS (Supermarket Sales Information System) and prescribed excel templates.
  • Supermarket Encoding
  • Database Encoding
  • Sales Order Encoding
  • Provisional Receipt Encoding
  • Merchandise Slip Encoding
SUPERMARKET ENCODING
  • Downloads (from supermarket server) and collates (manually submitted information) supermarket sales of chicken stations & meatshops.
  • Prepares a spreadsheet summary table per material per outlet and per chain with volume, revenue and selling process.
  • Converts sales quantities into standard KG unit.
  • Computes for the net revenues and average selling prices from the raw data downloaded from the supermarket systems using a template.
  • Collates and sends via email the following Sales Reports on a per Area, per Chain, per Outlet, and per SKU Level:
  • Actual bi-monthly sales
  • Sales accrual for the month
  • Variance reports
  • Helps Sales Group on the following: (To be confirmed if this will be retained as Prosync's scope)
  • Monitoring of daily, weekly and monthly sales for Sales' accrual report for the preceding month.
  • Monitoring of timely submission of reports from the Supermarkets.
SALES ORDER ENCODING
  • Receives daily forecast and orders of customers for Poultry and Meats.
  • Collates purchased orders of customers, including house brand and institutional requirements and forwards collated data to responsible plant personnel.
  • Receives summary of allocation of products from the plant.
  • Coordinates with Sales on the final order to be booked.
  • Inputs sales orders for Poultry and Meats in the SAP.
  • Makes order revisions to accommodate changes in orders and allocation plans as directed by Sales.
PROVISIONAL RECEIPT ENCODING
  • Receives the deposit slip from the cashier.
  • Prepares Provisional Receipt (PR).
  • Sends PRs to the scanner thru DAR.
  • Reconciling of billing data versus PRs issued.
  • Updates customer ledgers.
  • Sends a summary report to Sales.
MERCHANDISE SLIP ENCODING
  • Receives the merchandise slips from the Supermarkets.
  • Inputs daily merchandise slips to prescribed sales templates.
  • Prepares a spreadsheet summary table per material per outlet and per chain with volume, revenue and selling process.
  • Converts sales quantities into standard KG unit.
  • Computes for the net revenues and average selling prices from the raw data downloaded from the supermarket systems using a template.
DATABASE ENCODING
  • Extracts detailed SAP BW reports per request of the Sales Information Group on a daily, weekly and monthly basis for the preparation of presentation materials in periodic business reviews.
  • Consolidates Market and Industry data from territories nationwide: broiled prices, hog farm gate prices, slaughter output, broiled production.
  • Extracts raw data from BW and consolidates data on material, channel, and segment levels and submits to Sales Information Group.
  • Updates Sales Information database for KPI monitoring. Including, but not limited to, per material sales, per customer sales, and customer ranking per market segment.
  • Consolidates market share per territory, per capita consumption, per province, among other levels, for the annual budget cycle.
MINIMUM REQUIREMENT

(Education, skills, experience)
  • EDUCATION
  • At least 2 year college graduate related to Sales, Inventory, Logistics, Warehousing and Finance.
  • WORKING EXPERIENCE
  • Has worked or background in the following:
  • Sales Reporting
  • Sales Analyst
  • Commercial Sales Analytics
  • Point of Sales systems and operations
  • Credit/Collection
  • Warehousing
  • SKILLS
  • Proficient typing skills
  • Proficiency in Microsoft Excel
  • Basic literacy and numeracy skills
  • Organizational abilities
  • Administrative skills
  • Good communication skills both written and verbal
  • The ability to work independently and as part of a team
  • A conscientious and responsible working attitude
  • Accuracy and good attention to detail
  • The ability to work under pressure and to tight deadlines
  • Good spelling, punctuation and grammar
  • A good understanding of data confidentiality issues

San Miguel Corporation

Similar Jobs

  • Business Center Analyst - ORMOC, LEYTE

    San Miguel Corporation

    • Ormoc City, Leyte
    Work Site: DBSM, Ormoc, Leyte Sales Liquidator Receives delivery and sales documents of poultry and meats (P&M) finished products and spice mixes such as, but not limited to…
    • 2 months ago
  • Junior Software Engineer Start Now Home Based Job

    Neksjob

    • Tacloban City, Leyte
    Work from Home! OFFER: 35000-45000 Java Developer (Jr-Level) REQUIREMENTS *Preferably with experience in JAVA ENTERPRISE EDITION *Knowledge with RDBMS and SQL queries *Knowl…
    • 1 month ago
  • Motorcycle Loan Team Leader | Leyte

    PETNET, Inc.

    • Tacloban City, Leyte
    Market and solicit MC loans through the following approaches: dealer relations/sourcing, individual and/or community selling, institutional/group selling. Active participation in …
    • 1 month ago