Analyst II Sales and Operations Planning
emerson
Quezon City, National Capital Region, Philippines
1d ago

Responsibilities

  • Gathers, manipulate and scrub supply chain related data needed as per pre-defined instructions
  • Extracts / generates supply chain and S&OP related information from databases using basic coding (e.g. tables, basic queries) Ex.
  • Spend and On Time delivery. Combines extracted data from different system tools in one single database using tables and basic queries (MS Access)

  • Performs data validation to achieve data consistency.
  • Review and Analyze Planning Bills of Materials. Accounts for how product families are related.
  • Communicates with resource person to get input / raw data needed for report generation
  • Calculates data using available fields within the gathered information. (basic math)
  • Analyzes the data and provides in depth interpretation and recommendation based on findings (e.g. price parity, DPO parity, KPI metrics) thru comparative analysis (e.
  • g. comparing actuals vs historical information)

  • Prepares standard supply chain related reports based on standard templates.
  • Combines extracted data from multiple resources using automated tools (excel, macro, database, Crystal reports)
  • Calculates S&OP Line rate for existing Line ID's
  • Review and updates Pre-S&OP Decks based on the required changes to align with the organization goals
  • Gathers S&OP meeting result and implement adjustments needed for the material plan and forecast.
  • Follow business process in updating the system to ensure accuracy of information.
  • Updates Planning Parameters for New Product lines based on the guidelines provided. Act as liaison to ensure workflows are updated and are approve on time.
  • Requirements

  • BS IE, BS OPERATIONS MANAGEMENT, BSBA in Supply Chain, Purchasing or other Engineering / Management related discipline
  • 2.5 years related experience in Buying, Planning, Supply Chain, Logistics with data mining, manipulation, analysis and reporting experience
  • Basic understanding of MRP, ERP and SRM systems and tools
  • Familiarity with Planning Bills and basic commodities,
  • Able to read, analyze & interpret various data types in Excel, Outlook or PDF formats
  • Has experience in analyzing data in different formats and finding commonalities or discrepancies
  • Can understand / interpret technical documents such as product datasheets & price lists, manuals, catalogs
  • Good working knowledge on data interpretation & business processes
  • Knowledge in supply chain, buying, planning functions
  • Able to perform ad hoc and project-spend analysis and reports
  • Intermediate Microsoft Excel proficiency (Level 2)
  • Proficient in other Microsoft office programs : Power Point, Word, Outlook
  • Good level communication skills for interacting with technical & non-technical people via email or phone correspondence in fluent English
  • Can provide data in an efficient and understandable manner
  • Uses Oracle or other similar applications for data entry
  • Capable of simultaneously using various systems / tools to complete requests.
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form