Forecasting Analyst Resume Examples

Sr. Sales Forecasting Analyst | Business Intelligence

Organized process and created reporting tools to check performance. Used comprehensive analysis of statistical methods in conjunction with market trends and company initiatives to forecast demand from different brands and portfolios. Ensure master data was aligned trough the organization.

• Reduced Operating cost significantly by decreasing the inconsistency in master data during the first year by matching the old products with the new products and using the inventory on hand.
• Achieved 5% improvement in forecast accuracy from 75% to 80%. "USA Division MAT score is above the target and it is the first division in the Group to achieve the target".
• Partnered with Category Management Team to influence promotional plans, rollout, and product launch. Trained the new team in Demand Planning.
• Developed KPIs and main files allowing full view of financial forecast process in organization and strategic focus.
• Customized forecast accuracy report and accountable for analyzing, presenting and explaining forecast accuracy and deviations in Sale and Operation Planning Process meeting (S&OP).

Sr. Forecasting Analyst

• Utilizing Retail Link and other vendor portals analyzed weekly sales, in-stocks & WOS
• Led planning/forecasting meetings to review shipments against forecast vs open orders
• Decreased our excess inventory list by 30% by creating opportunity buys.
• Responsible for 7 sales reps and their weekly contribution to the organization.
• Created KPI by item to assist in reducing inventory and cutting warehouse costs.

Gross Margin Forecasting Analyst

• Created new forecasting model that consolidated different markets leading to quicker, more dynamic forecasts and greater efficiencies
• Thorough analysis and adjustment of gross margin estimation processes led to significant reduction in estimation to actualized variances and prior period adjustments
• Leading various aspects of a cross functional team systems modification project that will allow for greater accuracy of daily profit and loss movement and month end gross margin accrual

Sales Demand Forecasting Analyst

• Preparing SKU level forecast for all product lines of Fitbit (600+ SKUs) for both Sell Thru and Sell In
• Developing new metrics and Reports for improving quality and accuracy of forecast.
• Present monthly forecasts to regional VPs and CBO. For those purposes created report templates and tools to adjust forecast based on feedback by top-management.
• Administrate and manage SQL based forecasting software (Steelwedge) and Excel database that contained forecast(400k+ rows of data).
• Formerly also gathered and reported on Sell Thru information for NA region.
• Weekly report on company performance vs forecast.

Traffic Modeling and Forecasting Analyst

• Assist transportation engineers with traffic forecasting by processing and analyzing traffic counts/data for Metropolitan Planning Organization models.
• Review and evaluate the quality and accuracy of traffic counts provided by consultants for a traffic forecast request.
• Construct traffic flow forecasts and turning movement forecasts for low risk county routes by methods of linear regression and growth rates for design aspects.
• Design a yearly accuracy report, which consists of comparing previous calculated average daily traffic forecasts to newly collected traffic volume counts for all state routes in Ohio.
• Build traffic count plates using MicroStations to support open year and design year forecasts for projects with multiple alternatives.

Treasury Financial Forecasting Analyst

• Analyze asset and liability volumes for forecast discussions, update balance sheet volumes, durations and pricing in QRM for forecasting NII
• Perform monthly variance analysis on balance sheet and income statement, analyze the impact of interest rate scenarios and changes to portfolio assumptions on base NII
• Assist business units with asset and liability forecasts for budgeting purposes. Run valuation and planning in QRM to forecast base balance sheet and income statement for monthly forecast, annual budget, CCAR and DFAST
• Provided monthly forecast reports to Liquidity, Liability, Capital and Balance Sheet management teams
• Prepared monthly and quarterly statement of condition for internal use and regulatory reporting.
• Assisted in the implementation of new deposit modeling in QRM and perform user accepted testing for new versions of QRM

Sales Automation Forecasting Analyst

Perform monthly, quarterly and annual bookings reports and forecasting analysis

• Prepare monthly and quarterly presentations for BD Review and Board Members
• Manage inbound opportunities process through weekly meetings and ensure that issues are address and that all items are transitioned in a timely manner.
• Run weekly BD/PM Staff meetings, help support with customer requests and program
• Work closely with finance to update and maintain the forecast up to date
• Reconcile orders daily against Salesforce and internal IFS system

Demand Forecasting Analyst Intern

• Analyzed the demand and production of parts
• Compared several different forecasting models
• Ran forecasts using past data to establish reliability of models
• Provided consulting as to which forecasting model to use
• Presented my findings to the top executives at company

Clinical Supplies Planning and Forecasting Analyst

• Responsible for collecting and aggregating clinical supply planning data from multiple sources, including spreadsheets and databases, for the generation of planning and forecasting presentation materials to be utilized in monthly meetings with cross-functional departments.
• Interact with clinical supply leads and other clinical supply stakeholders to obtain and communicate clinical supply timelines.
• Input Clinical study and planning data into Clinical Applications Smart Supplies system.
• Assist in developing, measuring and tracking metrics in a timely manner.

Loss Forecasting Analyst

• Formulate, maintain and support [company name] personal loan delinquency and loss forecasts on an annual and monthly basis by utilizing historical data, reports, and analyses
• Manage and monitor delinquency forecasts on a daily basis and distribute estimates to team members and management
• Report and present loss forecasts to internal and external audiences, including senior management, regulators and rating agencies
• Conduct regular portfolio analyses to identify trends and provide recommendations and insight to delinquency and losses
• Enhance existing controls related to delinquency and loss forecasting procedures
• Complete ad-hoc analyses, on a regular basis, for senior management and various teams including Risk, Finance, and Marketing