Sales Planning Analyst Resume Sample
Work Experience
- Excellent data analytical skills with Microsoft excel or other analytical tools
- Excellent planning, communication, presentation and interpersonal skills
- Strong skills in analysis, definition and roll out of channel programs. Proficiency in Word, Excel and Powerpoint
- Enforcement of GPN’s MAP policy with known and unknown customer’s violation MAP to include
- Review Daily list of MAP Violators and assign them out to the MAP Team as needed
- Investigate MAP violators and ascertain (using best practices) who they are, how to contact and obtain compliance for unknown customers
- Contact known customers that are in MAP violation and obtain compliance
- Order Investigations as need for MAP violators
- Communicate with Distributors and the Sales Team regarding MAP violators and take appropriate action regarding sales
- Create and improve upon current analytics and report out weekly
- Create better practices and methodology of MAP enforcement and information retention in regards to violators
- Hold Bi-weekly MAP meetings and review with the MAP Compliance Team who the violators, complied violators are and next steps
- Ensure timely maintenance of sales planning template
- Present sales planning analytical output as required for senior management presentations
- Stimulate continuous enhancement in sales reporting packages given to internal management team, senior leadership team and account owners
- Collaborate with respective departments to ensure internal alignment on sales targets & promotional activity
- Generates production of scheduled reports. Fulfills ad hoc report requests
- Partner with the Sales group to aid in entering key metrics and promotions into internal tools, helping to complete customer templates/new item forms, and provide support
- S&OP data maintenance and update on a monthly basis as to Bookings, actual production, actual shipments, inventory, and forecast (Units & Values)
- Demand Planning, Analysis and Management
- Review historical sales trends, research demand drivers, prepare forecast data, develop statistical forecast models and evaluate forecast results while adhering to standardized demand planning procedures
- Create, maintain, and publish companywide forecast reports and analysis. Includes demand analysis at aggregated tier levels across the short and long-term forecasting horizon
- Conducts demand review meetings with every level of the Organization looking at demand trends from different reports
- Conducts Analysis on demand, Lead Time and OTD
Education
Professional Skills
- Strong analytical skills; ability to swiftly and effectively conduct sales analysis
- Demonstrated experience with Advanced Business Excel Modeling skills
- Good interpersonal skills and experienced with managing relationships at all levels
- Strong communication skills with the ability to work independently and within a team
- Strong customers service and interpersonal skills to collaborate internally/externally
- Strong PC skills, including proficiency in MS Office software programs
- Demonstrating Advanced skills in Excel and Access (to include PivotTables, vLookups, Business Modeling, and Building Databases)
How to write Sales Planning Analyst Resume
Sales Planning Analyst role is responsible for excel, advanced, analytical, microsoft, powerpoint, analysis, database, reporting, modeling, interpersonal.
To write great resume for sales planning analyst job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Sales Planning Analyst Resume
The section contact information is important in your sales planning analyst resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Sales Planning Analyst Resume
The section work experience is an essential part of your sales planning analyst resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous sales planning analyst responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular sales planning analyst position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Sales Planning Analyst resume experience can include:
- Expert Excel skills and related data manipulation
- Reviews and analyzes closeout offers to ensure brand efficiently and effectively moves through excess inventory
- Advanced computer skills with an emphasis in Microsoft Office suite of products
- Experience in the sales or finance sector, and experience with marketing and communications required
- Proven track record working in a consumer goods industry
- Experience, preferably in the consumer goods/beverages industry
Education on a Sales Planning Analyst Resume
Make sure to make education a priority on your sales planning analyst resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your sales planning analyst experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Sales Planning Analyst Resume
When listing skills on your sales planning analyst resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical sales planning analyst skills:
- Proven ability to work on multiple priorities while still achieving agreed upon deadlines
- Computer skills including MS Office programs such as Outlook, Excel PowerPoint and Business Objects
- Experience gathering, analyzing and interpreting data
- At least two years of experience with Forecasting and Planning activity
- Working experience in an analytical/planning role
- Experience in sales or in trade marketing and/or management
List of Typical Experience For a Sales Planning Analyst Resume
Experience For Senior Sales Planning Analyst Resume
- Strong communication skills with the ability to work independently and within a team environment and excellent group presentation skills
- Strong database and project management skills
- Advanced Excel skills required. Experience with data manipulation and Excel formulas (Date functions, V-lookup, Pivot Tables, etc)
- Communication Skills – Clearly communicates with multiple internal departments as well as Field Sales Regional Leadership for interdepartmental alignment
- Experience developing, maintaining, and owning milestones across multi-channel development
- Strong work ethics. Adaptable and willing to work flexible hours to meet deadlines
- Good in quantitative analysis, Excel and logical reasoning
Experience For PPD Sales Planning Analyst Resume
- Experience in consulting, finance, sales ops, or product management
- Help the operations groups in the identification of customer finished good kanban
- Analyze information for the purposes of preparing reports, data validation (using Diver information), coordinating efforts and solving problems
- Manage multiple tasks at once and to prioritize appropriately
- Providing support for sales planning activity (volume planning)
- Contributing member of retail team, responsible for identifying opportunities in market and channel distribution to drive sales growth
- Assist management in developing & reviewing the sales budget and rolling sales forecast including sales to budget variance analysis
- Perform analyses to help planners in monitoring and optimizing FG performance to reduce inventory levels and ensure availability
Experience For Lamborghini Sales Planning Analyst Resume
- Identify new sources of data and metrics and supports enhancements to existing data and reporting systems
- Act as backup to other department functions such as order processing, sales coordination, and competitive pricing requests
- Supports data gathering and analysis of customer targeting database
- Coordinate the complete sales reporting and forecasting process for all sales channels
- Generate ad-hoc reporting for Sales and Business Planning
- Assist in the planning and implementation of trade programming across portfolio/brand/channels
- Assist in the sales planning, communication, and execution of programming in the alternative channels
- Develop customized commercial projects for some categories of clients and generic plans with programming, events and licensing opportunities
Experience For Promotion & Sales Planning Analyst Resume
- Run, Analyze and publish weekly, monthly inventory reports according to agreed timeline
- Support annual business planning process, and development of sources of growth
- Analyse and assist in key account special requests and sales order phasing based on purchased made and/or planned
- Support cell-level Cost-to-Serve analysis to incorporate into CG+ program (e.g., promotional and pricing analysis)
- Contribute to department goal of continuously improving processes
- Participate in process review and evolution of planning practices
Experience For IPB Senior Sales Planning Analyst Resume
- Acts as the single point of contact for Sales Team for Route-Optimization Software, becoming the subject matter expert, trainer and tech support for the team
- Provides additional analysis and data gathering as needed
- Assist in driving improvements in our sales coverage model through scalable analytics
- Collaborate cross-functionally to establish reporting standards
- Help oversee the BDR Operations email alias for questions that are being asked from BDRs
- Work with the BDR Enablement organization to maintain BDR Operations training content
- Analyze results, rejection reasons and set up reports containing respective conclusions, ideas, general guidance and proposed solutions
- Coordinate roadshow planning with the sales manager and prepare logistics
- Run weekly beverage forecast including all promotional volume
Experience For Ad Sales Planning Analyst Resume
- Work with the Sales leadership on promotional planning and approvals
- Find creative solutions that meets the briefing of agencies and clients
- Support the ad sales team to understand the client needs and offer the best strategy using Discovery’s media solutions, platforms and projects
- Identify new and better ways of doing things and have a plan to execute them
- Partner with leaders in BDR, Marketing, and Sales to identify areas of risk and opportunity
- Conduct category and market landscape analysis using primary & secondary sources
- Comfort with large amounts of data; being able to source and interpret large data sets. High level of proficiency in Excel
- A diverse environment where everyone feels accepted and can bring their full self to work every single day
Experience For Sales Planning Analyst The North Face Resume
- Accountable for gathering forecasts and explaining how the demand versus the forecasts affects the business unit in terms of Sales and Unit Values to make sure that the business is in right direction
- Ensures that the demand gets at the right Manufacturing Site and coordinated with line move timing (Regionalization)
- Facilitates Monthly Inventory Meeting and Support the weekly meetings being held per site to determine the root causes of parts that are fat and are running short, set action plans within a specific timeline and strictly follow-up what’s going on
- Interacts with both OPA’s and worldwide supply base to optimize MRP and Kanban parameters to ensure proper raw material levels for the division
- Works directly with the Sites Plant Managers, Materials Manager, Planners, Sales, Customer Service, Engineering and other levels of the organization, to rapidly learn the system, processes, product and services
- Serve as primary contact to assist field sales with running Diver & Aperity reports and setting up report markers
- Create and update Excel spreadsheets and/or reports using Diver data and ensure accuracy of data through scrutiny and confirmation of information (once populated into spreadsheet)
- Provide ad hoc reports to Regional Managers for particular market/region, as requested, regarding compliance/non-compliance with national mandates after start of program, ensuring the accuracy and validity of the retrieved data
- Collect and analyze depletion data, distribution grids (opportunities and tracking), program updates, distributor invoicing, budget tracking, and POS orders, using a variety of programs, including, but not limited to, Nielsen, Spectra and Price Trac
Experience For Sales & Planning Analyst Resume
- Effectively organize time, manage diverse activities, and meet deadlines
- Create PowerPoint presentations (including distributor presentations) for regional and national meetings; assist with presentations
- Provide backup point of contact to the Dimensional Insights Project Manager (Diver)
- Work as liaison with distributors as needed; maintain the distributor contact list
- Act as liaison with the Marketing Department to maintain library of logos and ads; send promotional announcements via email blasts to key account customers and distributors
- Provide administrative and clerical support to sales team and Texas office staff as needed
- Read and write in English with knowledge of the structure and content of the English language, including the meaning and spelling of words, rules of composition and grammar. Ability to understand written sentences and paragraphs in work-related documents
- Responsible for development of various performance reports in support of the weekly/monthly performance management routines
- Analyzes sales data and summarizes key insights and implications, along with possible solutions to gaps in business plan
Experience For Retail Bank Sales Planning Analyst Resume
- Conducts issue specific deep-dive analytics, using both internal and syndicated data, clearly identifying business causals, risks, opportunities and potential actions
- Track and steward specific commercial initiatives and measure effectiveness. Able to apply simple financial concepts (break-even, NPV, IRR) to create a business case
- Experience in a sales support and/or customer success team role with proven leadership abilities
- Experience in similar roles
- Experience and knowledge of business issues and revenue and profit impact beyond data collection and analytical knowledge
- Experience focused on B2B/Consumer Electronics demand planning and inventory management
Experience For Citiphone Service / Sales Planning & Analyst Resume
- Financial planning and negotiation experience
- Experience delivering data driven insight
- Experience developing third party logistics presentation with actionable takeaways
- Analyzing results to identify trends and opportunities for upcoming budgets
- Forecasting weekly store sales & labour productivity plans
List of Typical Skills For a Sales Planning Analyst Resume
Skills For Senior Sales Planning Analyst Resume
- Strong analytical skills and high intellectual curiosity
- Moderate Excel skills - Vlook ups, pivot tables
- Experience with variable commission calculations, forecasting, data modeling, data analysis or sales reporting
- Experience working with Nielsen, Business Warehouse Reporting, SAP
- Experience and knowledge of Coca-Cola data sources and sales reporting systems i.e. CBL, B-cube, MVR, MRE, MOFEx
- Experience working in Coca-Cola system, especially in Foodservice and On-premise channels
- Proven efficiency working in Microsoft Excel
- Previous experience in advertising and/or entertainment field helpful
- High comfort level with digital solutions and technology -- experience using cloud storage solutions
Skills For PPD Sales Planning Analyst Resume
- Experience in Business Development Sales, Sales, or Sales Operations
- Maintain the correct item status and last purchase season of goods
- Multiple years experience in analytical or operational role
- Excellent attention to detail and ability to manage and analyze large volumes of data
- Advanced Excel and strong in Access
- Working closely with the manager, review and optimize activities and workflow on an on-going basis for efficiency and scale
- Forecasting and production planning
Skills For Lamborghini Sales Planning Analyst Resume
- Pulling reports and data
- Using those reports and data to build the deck
- Marketing Collateral and Resources Management
- Manage, develop, and deliver reporting on business initiatives with Finance, Marketing, and Planning departments
- Responsible for the tracking of the Overdues orderbook position, challenging the Sales team and ensuring that actions are carried out in a timely manner
- Result oriented, hard-working, willing to work over time to meet deadlines; ability to work across cultural boundaries
- Coordinate and organize onboarding training for new partner
- Maintain working relationship with manufacturing and other disciplines to optimize efficiency and ensure smooth product flow to the customer
- Lead sales reporting efforts for Cultivate Ventures platform: Coordinate all necessary reporting in Business Objects environment
Skills For Promotion & Sales Planning Analyst Resume
- Responsible for providing the Sales Planning Manager with an accurate monthly forecast to be used in all company communications
- Quarterly tracking of Net Sales achievement against RFC across both brands for Area North, communicating opportunities & risks to RFC achievement
- Manage and develop databases relating to customer specific expenses, promotional results & sales reports, promotional activity database and sales
- Distribute information and advice to field teams on promotional and ranging activities
- Lead initiatives to identify, report, and provide recommendations for executing on opportunities to improve business practices
- Limited travel required for occasional meetings and training
- Analyse information regarding budget, sales history, sales/market input and current sales order in order to produce an accurate future sales forecast
- Calculate and plan buys at SKU (Stock Keeping Unit) level, based on forecast, current inventory levels, open purchase orders and production constraints
Skills For IPB Senior Sales Planning Analyst Resume
- Coordinate global deadlines and share buy information with US Planning group in order to achieve a global buy plan
- Work with Marketing and web team to maintain partner list on ANSYS website
- Work with Channel managers worldwide to track marketing activity and new logos of Channel Partners
- Maintain inventory levels at the distribution warehouse based on established lead times while managing within approved budget
- Gather, compile and analyze data from various sources, including offsite sales personnel in the field
- Assist in annual planning and preparation of tools
Skills For Ad Sales Planning Analyst Resume
- Support Field Sales Trade Pro: Support Cultivate Ventures sales organization to appropriately plan for upcoming promotions; create post-promotion analyses
- Preparation of weekly forecasting data to provide visibility of bookings from customers
- Conduct oneself in an ethical and professional manner
- Collaborate in the preparation of product mix reviews, submissions & daily imperatives
- Create sales reports for management staff and use the data from reports to create sales forecasts
Skills For Sales Planning Analyst The North Face Resume
- Prepare relevant correspondence to internal and external customers to deliver high level customer service
- Provide high level sales reports to National Accounts Team
- Build market analysis reports to detail a variety of conditions in the market to deliver to management. These reports provide management with options for various market conditions
- Proven experience with Sales performance management solutions
- Proven experience with Sales process improvement
- Exceptional presentation skills: verbal and written communication
Skills For Sales & Planning Analyst Resume
- Experience using Excel (formulas, pivot tables and v look-ups)
- Experience using SAP or similar systems
- Provide correct item status and last purchase season of goods in JBA
- Work experience related to sales, operations or finance
- Relevant work experience in sales & operational environment, preferably from financial industry
- Experience in Business Development, Business Intelligence, Sales Planning or related field
- Experience in Finance, Strategy or Marketing role
- Makes recommendations for changes in sales techniques or promotional efforts to improve sales performance
- Review, update and reengineer current process / procedure to enhance control and remove
Skills For Retail Bank Sales Planning Analyst Resume
- Strong communication skills required, both verbal and written, communicating effectively with employees, staff, customers (both internal and external) in person, via telephone or email
- Computer proficiency required in Dynamics AX and Diver programs as well as MS Office products, including Word, Excel, PowerPoint and Outlook; ability to use advanced computer functions, including navigating the Internet
- Compile information regarding budget, sales history, sales/market input and current sales order (when available) in order to produce an accurate future sales forecast
- Calculate and plan SKU buys based on forecast, current inventory levels, open purchase orders and production constraints (ie minimums, lead time)
- Coordinate this buy information with US Planning group in advance of actual buy placement in order to achieve a global buy plan which assures EU critical buy windows
- Place SKU buys to the US planning group as calculated above
- Coordinate global deadlines with US group
- Check EU SKU buys placed by the US Planning group to the PA offices in order to assure correctness of any production constraint analysis as well as to assure data is transferred correctly
Skills For Citiphone Service / Sales Planning & Analyst Resume
- Advise Sales Team of sold out products during the PS campaign, offering product alternatives where available and maintaining sold out information in JBA
- Analyze and assist in key account special requests and sales order phasing based on purchased made and/or planned
- Successful record in setting business strategy and implementation plans within a large geographically dispersed area
- Analyze shortage and excess inventory positions to order to guarantee maximum efficiency
- Monitor regularly stock availability to fulfill reorders business
- Work well in a dynamic, fast-paced environment
- Experience working with PC database applications, SAP reporting, SAP Business Warehouse, SAP Business Planning and Consolidation and sales projection models is required
- Strong Microsoft Office skill set with an emphasis on advanced Excel skills
- Superior Microsoft Excel knowledge
List of Typical Responsibilities For a Sales Planning Analyst Resume
Responsibilities For Senior Sales Planning Analyst Resume
- A self-starter who has experience with direct client contact
- Assist in the planning and implementation of pricing and trade programming for beverage product lines
- Comprehensive understanding of direct mail specifications and pricing
- Perform complex analysis such as regression, forecasting, cannibalization and probability modeling
- Interact with Sales executives, Legal, Operations, Finance and Accounting on a frequent basis
- Annual Business Plan preparation – Volume Builds, Commercial & Sales Planning Alignment
- Drive sales and inventory forecasting, demand and supply management, and analysis for 3rd party channels
- In finance and/or operations
- Report conception, development and maintenance
Responsibilities For PPD Sales Planning Analyst Resume
- Advanced knowledge of Microsoft Excel and Microsoft Access ESSENTIAL
- Be the single point of contact for all Sales Planning related activities for Sky in the Retail Bank, including but not limited to frontline certification, Head Count Assessment and adequacy, change in compensation structure leading to Plan fulfillment etc.
- Implement the sales discipline across the US and Local managed business including the creation of KPI’s and metrics to measure and track sales
- Advise Sales Team of sold out products during the pre-season campaign, offering product alternatives where available and maintaining sold out information in ERP
- Analyse shortage and excess inventory positions to order to guarantee maximum efficiency
- Issuance of Digital & VOD IO’s
- Utilize available data resources to develop and maintain sales reports
- Analyze and process Kenworth sales promotional incentives
Responsibilities For Lamborghini Sales Planning Analyst Resume
- Communicate directly with Kenworth dealers and field sales team
- Deliver timely responses to data requests from senior level management
- Create and manage SQL queries within MS Access or Tableau
- Create Channel partner contracts and explain the contract terms to the Channel partners
- Provide instant help to the new partner prospects in the Due Diligence process
- Manage Channel Partner (for sales / marketing reps, application engineers and sales admins) access to ANSYS internal systems and tools – Siebel, Google community site, customer portal, Xchange, Temp Key Center, etc
- Administer and assure the partner recruitment process remains in full integrity
- Track partner capacity and generate worldwide CP capacity report quarterly
Responsibilities For Promotion & Sales Planning Analyst Resume
- Maintain worldwide channel partner database; working with regional channel leaders and legal, maintain repository of partner agreements and exhibits; document terms and ensure partners are in compliance with agreement terms
- Distribute and follow up on partner leads
- Document partner accounts on Participation Forms on a quarterly basis and provide copies to channel partner principals
- Quickly identify issues, communicate to management, and recommend solutions
- Create aggregate monthly sales forecast by model for assigned product class
- Prepare monthly inventory plan by model for assigned product class
Responsibilities For IPB Senior Sales Planning Analyst Resume
- Manage phase-in and phase-out of new product introductions and transitions
- Analyze large amounts of sales and inventory data to make proficient production decisions at the SKU level
- Communicate across all business disciplines both verbally and written
- Create/maintain sales/margin reports that assist key sales management personnel throughout business unit
- Bi-weekly Sales Pipeline Analysis and Data Management
- Strategic / critical lens on the data to call out pipeline activity that needs a strategic discussion to help accelerate or grow
- Project management -- calling out data that needs to be corrected, following gup with sales, making sure all happens on schedule, notes from meetings, hold accountability for follow up items
- Administration and Creation of Smart Rooms: creating a new smart room off of existing digital smart room templates as needed; assigning sales people ownership within the smart room team: ensuring all collateral is current in templates and smart rooms
Responsibilities For Ad Sales Planning Analyst Resume
- Upgraded Digital Demo: documenting what the ideal demo is and working with appropriate teams to identify gaps and work needed to reach that ideal
- Analytical mindset to review data
- Project management / matrixed management -- can hold colleagues and senior leaders accountable
- Field Sales Communication: Coordinate and communicate price change and new product efforts with company stakeholders and field sales
- Thrive in an entrepreneurial, fast paced environment
- Team player; willingness to roll up sleeves and get involved
Responsibilities For Sales Planning Analyst The North Face Resume
- Interpret data and translate into sales forecasts
- Perform ad-hoc analysis and provide recommendations/insights in support of Regional and Global requests and initiatives
- On occasion, attend key customer meetings as data SME on an as needed basis
- Publish dashboards and KPI portlets for the BDR Management and BDR Organization
- Prepare weekly, monthly, and quarterly attainment data
- Manage communication between Sales Operations Analysts and the BDR Program
- Help support the BDR Operations Manager with change initiatives for the BDR and Direct Sales Organization
- Run regular focus groups between BDRs and Direct Sales Reps
- Support and deliver local Operations trainings
Responsibilities For Sales & Planning Analyst Resume
- Ad-hoc data analysis and reports as needed
- Forecast sales for the Cultivate Ventures platform: Obtain input from all field sales teams, marketing leads, customer team leads and others in order to manage the sales forecast in the Hain Celestial proprietary forecasting system. This requires forecasting on an item level by customer, by region
- Contract, secure and coordinate the delivery of select ingredients to meet scheduled production dates
- Compile high volumes of material data sets in Excel. Map, migrate, and validate data sets in system. Accountable for the integrity of all sales data in database
- Audit deal terms of licensed product in the system and reconcile against the license agreement
- Provide Sales team with a comprehensive avails/status of licensed content to maximize sales avails and future sales opportunities
Responsibilities For Retail Bank Sales Planning Analyst Resume
- Assist with pre/post sale activity. Extract material deal points and create ad-hoc reports (targeted packages of available product, strategically selected for a particular licensee) and initial deal structure for the sales team
- Review counter offers and revise the deals accordingly for the sales team
- Maintain option trackers for all active deals. Prepare and distribute notices
- Review and approve monthly invoice entries
- Comprehensive understanding of underlying distribution rights and music rights, coupled with strong analytical skills to be able to perform analysis of exclusive vs. non-exclusive grant of rights, exclusivities, restrictions/holdbacks
- Excellent oral and written communication skills for interaction with legal team and sales staff
- Experience working with direct mail print vendors required
- Multi-task and manage direct mail projects
- Collaborate with production and coordinate direct mail jobs with El Dorado Hills, CA, Kansas City, MO and Hartford, CT
Responsibilities For Citiphone Service / Sales Planning & Analyst Resume
- Collect sales records & trends and evaluate performance measured against sales target
- Analyze sales and performance records, interpret results of overall sales, and recommend promotion or change of personnel in under-productive departments
- Analyze line of business operations to determine profitability and to establish a pipeline for action and operational changes
- Conduct quantitative analysis including but not limited to trending, identification and assessment of opportunity and risk, forecasting, regressions, correlation, cannibalization, and probability modeling
- Background: Finance/Accounting/Economics/Financial Maths/Statistics is preferable