Analyst II, Demand Planning

JOB SUMMARY:

Responsible for overseeing the forecasting process by analyzing historical data, market trends and other relevant factors to predict future demand. Collaborate with Sales, Contracts, Marketing, Supply Planning and Pricing departments to gather necessary information and develop accurate forecasts to support business decisions, bid management and optimize inventory management. Assists and supports the Demand Review Process for Integrated Business Planning, with the goal to drive revenue growth, improve profitability, and enhance the overall commercial performance of the product or product line.

FORECAST MANAGEMENT:

• Gather and analyze customer sales forecasts, compare forecasts to actual customer demand and make appropriate changes using trend analysis and utilizing the SAP IBP forecasting tool.
• Analyze, track and maintain changes to forecasts based on customer awards and losses.
• Responsible for providing demand dynamics and recommendations to the Integrated Business Planning (IBP) processes to align strategic, operational, and financial business objectives.
• Engage in the IBP process by supporting Executives in gathering information and developing presentations.
• Participate in customer monthly meetings (internal and external) to align on forecast and order variances.
• Act as the team lead within Commercial Operations to execute on Business Objectives (KPI’s) that drives collaborative behaviors towards continuous improvement.
• Communicate forecast results, insights and recommendations to key stakeholders.
• Identify and mitigate potential risks to forecast accuracy, such as changes in market conditions or business operations.
• Support the transition of forecasting new product launch skus from Marketing to Commercial Operations.
• Continuously improve forecasting processes and methodologies to enhance accuracy and efficiency.
• Act as functional mentor and trainer to team members within the Commercial Operations group.
• Act as the lead for cross functional team meetings by planning and developing presentations to ensure the most relevant topics are brought up for information sharing and decision making.
• Provide recommendations on unconstrained demand to optimize inventory levels, production schedules and other business decisions based on forecast results.
• Collaborate with the Marketing Team to convert new product launch forecasts to customer level forecasts.
• Coordinate cross-functional trend activities (Marketing and Financial information) to reconcile significant variances and refine the forecast model to reflect updated sales assumptions.
• Analyze wholesaler inventory levels utilizing customer portals or internal tools in order to evaluate stock and communicate to the Sales Team when necessary.
• Support Sales Team by working collaboratively on customer forecast compliance.
• Department SME for SAP transactions within Commercial Operations and the IBP Forecasting Tool.
• Recommend products for rationalization by reviewing IMS Market Share reports, analysis of Apotex inventory vs. demand and product profitability.
• Provide guidance to management on customer specific product allocation.

INVENTORY MANAGEMENT:

• Oversee the Daily Stock Monitor Report in Qlik and Excel.
• Oversee inventory reports including but not limited to:
• Short dated inventory
• Risk inventory
• Bid Wins and Losses
• Value centric inventory and adhoc reports
• Allocation and Backorder history tracking
• Production Sales and Inventory report (PSI)
• Weekly inventory status memo
• Adhoc reports as requested
• Analyze inventory levels to ensure enough supply and recommend product allocation changes.
• Mitigate risks for failure to supply by analyzing daily sales orders and provide instructions for release, hold and offering alternate products.
• Drive customer compliance and promote short dated and risk inventory to Sales and Customer Service Teams.
• Provide guidance and recommendations on storage locations, target inventory levels, safety stock levels and maximum inventory levels.

BID MANAGEMENT:

• Work independently to manage the Bid Process prior to contracts for final decision.
• Analyze inventory for customer RFP’s and One Time Buys.
• Update and maintain Vistex and SAP with Supply results and bid results.
• Collaborate with the Contracts Team on customer bid results and closure.
• Collaborate with the Global Demand Planning Team to analyze bid proposals.
• Act as a subject matter expert in consolidating and summarizing customer bid outcomes within Vistex and Qlik reporting.

MISCELLANEOUS:

• Participate in monthly Commercial Operations Team meetings and One on One meetings with Management/Supervisor.
• Work closely with Managers and other departments throughout the company in order to resolve issues that could financially impact the organization.
• Performs all work in support of our Corporate Values of Collaboration, Courage, Passion and Perseverance by working as a member of a team to achieve all outcomes.

• Performs all work in accordance with all established regulatory and compliance and safety requirements.
• Other Commercial Operation functions as required.

SUPERVISORY RESPONSIBILITIES

Position does not supervise others; requires general or nominal direction. Receives general guidance with respect to overall objectives. Works independent of others operating within policy guidelines. Uses independent judgment and creativity in achieving assigned objectives.

OTHER DUTIES AND RESPONSIBILITIES

Performs other duties as assigned.

MANDATORY or MINIMUM EXPERIENCE AND EDUCATION REQUIRED

• A BA/BS Degree or 3-5 years pharmaceutical or Supply Chain experience.
• Strong and proven detail oriented individual with analytical and decision making skills .
• Knowledge of the generic pharmaceutical industry.
• Superior verbal and written communication skills.

COMPUTER OPERATIONS

Position requires superior personal computer skills including electronic mail, routine database activity, word processing, spreadsheet and graphics. Advance skills in Excel and PowerPoint are necessary to perform regular day to day jobs. SAP, IBP Forecasting, Salesforce & IMS database experience an asset.

PLANNING AND ORGANIZING TASKS

Must be able to handle multiple tasks and prioritize.

PHYSICAL AND ENVIRONMENTAL CONDITIONS

The physical requirements of the position generally include: standing, walking, sitting, using hands and fingers, reaching with hands and arms, talking and hearing. In some circumstances, bending, kneeling, crouching, stooping, and crawling may apply. In general, the activity level one usually performs is light physical activity performing non-strenuous daily activities of an administrative and sedentary nature. Generally, work is performed in a well-lighted, heated and/or air-conditioned indoor office setting with adequate ventilation.

WORK SCHEDULE

The regularly scheduled work week is Monday through Friday and the hours are 8:30a - 5:30p.

TRAVEL REQUIREMENTS

Minimal overnight travel (up to 10%).