Alex J. Belitz

**** ***** *** **. ******, MN. ***03

Phone: 918-***-**** - adhpb3@r.postjobfree.com

Summary

Business Analyst professional with 8 years of experience in the analytics industry and a passion to understand and satisfy business needs. Proven skill set includes evaluating data, analyzing trends, and creating KPI’s and dashboards. Ability to provide data driven solutions with detailed knowledge of Microsoft Office Suite.

Experience

Phillips Distilling Company - Minneapolis, MN September 2017 - January 2020

Business Analyst

•Maintain enterprise sales planning tools for US and Canadian business to ensure alignment across all geographical regions and channels with national marketing plans and executive leadership’s vision.

•First point of contact for syndicated data (Nielsen) and OLAP tools (SAM NABCA, VIP) partners working with and ensuring high quality tools, data and insights to drive business results.

•Maintain a company “Keys to Growth” sales scorecard and National Accounts sales goal tracker.

•Develop a snapshot of syndicated data in excel for monthly distribution to the sales team.

•Maintain distribution gap reports to ensure that product launches are being rolled out to markets in a timely manner as well as any out of stock core items.

•Support National Sales Managers with analytics, presentation development and category management for on/off premise National Accounts.

•Develop weekly, monthly and quarterly reviews with the Sales Directors and Phillips Distilling CEO.

•Forecasting new products and line extensions as well as submitting new product data for consideration in National Accounts.

•Execute pre/post analytics for Marketing, Creative Services and Research & Development with reporting responsibilities for findings to Department Heads, Sales Directors and CEO.

Southern Glazers Wine & Spirits – Oklahoma City, OK September 2013 – September 2017

Brand Marketing Analyst

•Use SAP & SharePoint to create and maintain item pricing, pickup locations and FOB cost on all current & new items in Glazer's portfolio.

•Create templates and results trackers for sales KPI programs.

•Utilize Diver & Microsoft BI for ad hoc analysis to extract data in order to create Excel reports for management. detailing trends in sales, cost of goods sold, inventory and profit margin.

•Work with management on solving price variances, process improvement strategies and process implementation.

•Maintain the monthly ABLE commission posting and monthly incentives on SharePoint.

•Format and present various inventory & margin reports to management, using Excel. (VLookup, Sum-if, Count-if, Pivot Tables, Sort, Data Validation and Conditional Formatting)

•Communicate and present results/analysis of profitability and trends to upper management.

•Build excel worksheets to track depletions, available inventory, allocated items and discontinued items.

•Assist with forecasting monthly inventory using depletion trends and special programming goals.

Pilot Logistics Services – Oklahoma City, OK December 2011– April 2013

Master Data Analyst

•Worked with Accounts Payable, Credit, Billing and Dispatch Departments to create new vendors and new customers in SAP business suite.

•Performed audits and analysis on records created in SAP.

Software Experience

•Microsoft Office Suite

•VIP SRS, Karma & iDig

•SAP

•Toolkit

•Diver

•Google Suite, Drives & Dropbox

•Oracle

•Microsoft SharePoint

Microsoft BI

College Education

•Oklahoma State University 2010 - B.S. Degree in Marketing & Business Management

•Alumni member of Delta Sigma Pi Gamma Epsilon Chapter

Contact this candidate