Distribution Analyst - Jobs in Markham, Ontario

Job Description

Job DescriptionJoining AbbVie means you will be part of a team of outstanding professionals dedicated to making a remarkable impact on patients #39; lives. At AbbVie, we conduct ground-breaking science on a global scale every day. AbbVie Canada is one of the Best Workplaces in Canada.When choosing your career path, choose to be remarkable.AbbVie’s mission is to discover and deliver innovative medicines that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people’s lives across several key therapeutic areas: immunology, oncology, neuroscience, vision care, virology, women’s health , and gastroenterology, in addition to products and services across its Allergan Aesthetics portfolio.We have an opportunity for a Distribution Analyst to join our Supply Chain team. In this role, you will be responsible for creating, analyzing data from different sources, and supporting the Logistics and Supply Chain team in different activities related to the supply and distribution of products in Canada.Key responsibilities:All activities associated with the management of inventory accuracy between the warehouse WMS and the AbbVie IMS (SAP). Including but not limited to:

• Create and maintain a cycle count matrix schedule, based on product ABC categorization.
• Ensure routine cycle counting process and schedule is followed by the 3PLs- i.e., counts are completed, documentation is received (perpetual inventory, screen shots, summaries, etc.), reviewed and approved.
• All adjustments due to cycle count discrepancies are summarized for review and approval by Finance prior to making any adjustments.
• Track and trend all adjustments need to align the inventory.
• File all supportive matrix cycle count documentation for future review by auditors.
• Be present at 3PL for financial audit purposes and ensure all requested documentation is provided in a timely and thorough manner.
• Request and follow through on ad hoc counts at 3PL.
• Review and file all other types of counting documentation from 3PLs (pick line audits, ad hoc counts, etc.).
• Monitor and ensure accuracy of all customer inquiry investigations (OS/SS/Incorrect shipments).
• Run the daily inventory reconciliation report between 3PL and AbbVie systems. Identify new discrepancies and follow up with internal stakeholders, 3PL or Global Information Technology teams to get timely and accurate resolution. Track and trend inventory reconciliation issues.

All activities associated with ensuring the EDI between the warehouse WMS and AbbVie IMS is functional:

• Monitor electronic data interchange message (IDOC) failures between AbbVie and 3PL inventory management systems and process these message failures as approved but Global Information Technology.

All activities associated with Financial and Data Analyses:

• Support financial audits by requesting shipping documentation and running reports in SAP.
• Support the Distribution Manager with key performance indicators (KPI), invoicing, SAP reporting, 3PL system reporting, SOP review, Investigation Review.
• Complete month-end analysis of inventory KPIs, as well as order accuracy and returns.
• Provide monthly 3PL invoicing reconciliation reports related to pallet storage, outbound deliveries, etc.
• Analyze, review, log, request credits, process and approve all 3PL invoices.
• Run other daily reports including completed daily outbound deliveries and returns reconciliation between SAP and 3PL.
• Complete daily verification of outbound deliveries.
• Support AbbVie Order Management team for order cancellations, batch determination, completing transactions in SAP for medical devices with asset values, etc.

All activities associated with destruction and outbound orders and returns:

• Create manual proforma invoices for passive shipper return or other returns when required.
• Review destruction requests for accuracy and prepare destruction lists to send for financial approval.
• Run and analyze the delivery interface report (ZDEL) on a daily basis and follow up on reasons why the deliveries are still open with the appropriate stakeholders and coordinate resolution if required.
• Track all destruction orders to ensure process is followed and all supportive documentation is received and filed according to the SOPs. Review, analyze and approve destruction invoices.
• Follow all AbbVie planning and pertinent AbbVie/3PL standard operating procedures (SOP). Ensure SOPs are up-to-date, accurate and provide recommendations to ensure continuous improvement and effectiveness.