Post Job Free

Resume

Sign in

Sales Microsoft Office

Location:
York, PA
Posted:
December 21, 2016

Contact this candidate

Resume:

Shane Bluett

** **** **, ***** *******, PA ***** C: 717-***-**** acxy8l@r.postjobfree.com

Professional Summary

Highly motivated data analyst seeking a long-term position with a company where I can help them achieve their goals while growing my career.

Skills

Over 2 years of professional experience with data analytics related to sales, finances, and marketing

12 years of working with data analytics as a hobby. Since high school I have been using Excel to analyze and track different statistics and other data from the internet

Experience with different systems: Nielsen, SAP, IRI, SQL (Included: AS400, Site Line 9, Solutions), and a little exposure to other systems like Data Warehousing and Tableau

Creates stories for: key performance indicators, finding areas to attack, suggestions, ways to improve, and other data breakdowns

Thrives on the challenge of learning new types of analytical strategies, reports, and systems

Excel skills: pivot tables, charts, graphs, v lookup, formulas, and other functions

Ability to analyze or manipulate any type of data: sales, financial, marketing, purchasing, pricing, costs, and variances

Developed a wide arrange of reports or models that include: ranking, projections, forecasts, trends, trackers, executive summary, matrix, diagnosis, rates, and other requests

Capable of working with large or small amount of data

Analytical mindset

Thinks critically to solve problems

Effective communication skills

Highly organized

Able to adapt to new environments in a timely manner

Portfolio

Link to Page: www.portfoliogen.com/shanebluetts

Professional Experience

Temporary Assignment – Financial Analyst, 09/2016 to 09/2016

Robert Half Account Temps – Hunt Valley, MD

I worked as a temporary financial analyst under the CFO.

It was for an International mineral company who did business with US, China, Taiwan, and Australia.

Analyzed data and created the weekly sales dashboard, monthly global and other random requested reports.

Worked with a couple new SQL systems, they were Site Line 9 and Solutions.

Sales Analyst and Branded Administrator, 08/2014 to 07/2016

Hanover Foods Corporation – Hanover, PA

Worked with all components and parts of analytics for the Retail Sales Department. This included: Define objectives or business needs, research or explore all aspects, collect data, develops many different types of reports or models, analyze or interpret data, find solutions, and create a story.

Recommended new ideas, suggestions, improvements, adjustments, promotional spending, and other helpful tips based on tracking and analyzing all aspects of data or category. This assists the Sales Department and Corporate with decision making for current or new customer accounts.

Generated and came up with new suggestions or ideas by using research and studying: past history, customer traits, trends, markets, different parts of category, and competition.

Coordinated statistical data analysis, design, and information flow.

Created different reports or models for: trends, projections, forecasts, financial, and Promotions.

Transformed project data requirements into project data models: Distribution Matrix, Trackers, Comparison Reports, Rankings, Customer Account Analysis and Other Requests.

Prepared other monthly reports for Directors or Corporate management that include: Executive Summary, Profitability or P&L, Top Customer, and Sales Trends, and Category Reviews.

Assessed current and previous items, customers, the category, markets, and regional trends. I used this information to generate new ideas, suggest improvements think of outside the box ideas, Solve Problems, and create any stories or conclusions for the Sales Department.

Compiled annual cost of manufacturing and other cost or financial reports for Sales Director and Corporate.

Retail Sales Team was the only department to achieve revenue goals and earn a bonus for this past Fiscal Year. My Sales Director said the reason was because I could create more leveraging data stories and in depth analytics that previous analyst couldn't create for Sales Team and Management.

Most important project I worked on was given to me by the new Vice President of Sales. He wanted me to help research, break down data, create reports, and create a story for him to present to the board for a new Organic Line of Items. He was able to use my data analysis and reports to target and come up with 15 items that he thinks will be successful. These New Items will be hitting shelves sometime in the next year.

Developed database objects, including tables, views and materialized views using SQL.

Created all the various reports or models mentioned above using analytical platforms and Microsoft Office Programs. These include: Nielsen, AS400, Other SQL Queries, Some IRI, Excel, Word, Access, and Publisher.

Worked closely with Sales and Marketing departments to create and maintain marketing materials for sales presentations, trade shows, and new or current customer meetings.

Entered promotional and other requested data onto customer’s websites.

Answered customer product related questions, and helps the brokers or clients with account or data specific questions

International Assistant CSR for Shipping Office, 06/2012 to 12/2012

Exel Logistics – Mechanicsburg, PA

Started as a utility worker to learn company and processes. Then after a couple months was brought into shipping and Q/A office to became the Assistant International CSR and backed up Domestic CSR.

Learned SAP for most of the shipping process especially on the international side.

Also used SAP to create different reports for management to update staging and shipment processes.

Some exposure to data warehouse for inventory

Assigned shipments to carriers in the centralized database.

Communicated with dispatchers, warehouse and customers regarding outgoing orders.

Maintained accurate inventory records, invoices, billing and shipment schedules

Education

Kutztown University – Kutztown, PA

Bachelor’s Degree: Sports Studies with a concentration in Business Management, December 2011

Internship with the Operations Director of the Hanover YMCA, January - May 2012



Contact this candidate