Jessica Musial
Mesa,AZ
Summary
Dedicated and proactive professional with extensive experience in Excel reporting, leveraging large data sets to create comprehensive dashboards that drive business growth. Skilled in developing incentive and fiscal year goal trackers, with a strong ability to build and design reports from scratch using both internal and external databases for actionable insights. Proven track record of collaborating with senior leadership to effectively communicate results and analyses regarding business performance. Recognized as an analytical troubleshooter, adept at identifying challenges and implementing effective solutions, complemented by exceptional interpersonal, communication, and multitasking skills.
Overview
22
22
years of professional experience
Work History
Business Intelligence Analyst – Bacardi & Heaven Hill Brands
Southern Glazers Wine & Spirits
Phoenix, AZ
03.2023 - Current
- Nielsen analysis & reporting of brand category performance vs the competition to senior leadership and sales.
- Creating & analyzing sales data for 10 sales reps using excel & internal databases to achieve goals.
- Maintain and organize sales account lists, brand innovation items and brand spec sheets.
- Support sales teams with any ad hoc reporting requests and working with commercial strategy on specific projects.
- Sales Analyst – Constellation Brands
- Nielsen Trend Analysis for AZ & Total US Chain Business
- Reporting of overall state performance for Revenue & Volume vs Forecast and Plan.
- Reporting of KPI Team Performances using Business Objects (CRM Tool), Compass (Internal database) and Excel.
- Partner with supplier on reporting needs and access to dashboards shared on sharepoint.
Sr. Coordinator Data Analytics
Array Technologies
Chandler, AZ
02.2022 - 03.2023
- Cleaning up Account Data and standardizing Salesforce CRM System.
- Leading Project Team to rebuild Salesforce Objects, Fields, Dashboards and Reporting Templates.
- Reporting of KPI Team Performances using Salesforce data and excel.
- Trend analysis of win and losses of Solar Projects.
Sales Reporting Analyst
Slocum and Sons Inc
North Haven, CT
09.2018 - 01.2022
- Reporting of weekly, bi-monthly and monthly sales goals for 25 Sales Reps using internal databases and excel.
- Reporting of Company Performance for cases, dollars and gross profit for the owner and bank auditors.
- Creation of monthly dollar plans for 25 sales reps, work with upper management on forecasting for each rep.
- Support the Brand Managers on supplier goal tracking and analysis of brand performance.
- Support the VP of Sales on all adhoc reporting and sales analysis.
Sales Analytics Manager (National Accounts)
Diageo North America
Norwalk, CT
07.2008 - 04.2018
- Reported mid-month/monthly internal sales data using Microstrategy.
- Created multiple excel reports to track sale trends, compliance issues and market competition for internal sales team and executive leadership.
- Managed fiscal year plans for National Sales Team with forecasting and projections for following year business.
- Provided analysis of internal sales data to internal sales team and external customers using power point presentations and excel reporting.
- Maintained large databases for all customer information for accurate reporting.
- Supported sales team with assistance on presentations, customer analysis and any ad hoc requests needed.
- Customer Operations Associate – 07/08 to 10/11
- Partnered with distributors to manage their alcohol orders, from the ordering process until goods were delivered.
- Provided internal reports for the entire Supply team that contained analysis on orders, new products and inventory levels for customers.
- Developed the relationship between customer, sales and operations team in order to provide the best service for both the customer and the company.
Customer Relationship Specialist
Gartner Incorporated
Trumbull, CT
06.2004 - 06.2008
- Provided metrics reporting for three business units
- Project Management/Vendor Management
- Managed web based application (peregrine) for all client related issues
Education
Master of Business Administration - Business Administration And Management
University of New Haven
West Haven, CT05.2006
Skills
- Large data analysis
- Power BI expertise
- Proficient in Salesforce Lightning
- Proficient in Nielsen and IRI data analysis
- Expertise in advanced Excel functions
- Expertise in PowerPoint design
- Proficient in Microsoft Word
- Sales tracking optimization
- MicroStrategy analytics
- Creation of analytical reports
- Data-driven sales insights
- Annual financial forecasting
- Microsoft Business Objects expertise
- Consumer trend evaluation
- Strategic development
- Data organization and maintenance
Timeline
Business Intelligence Analyst – Bacardi & Heaven Hill Brands
Southern Glazers Wine & Spirits
03.2023 - Current
Sr. Coordinator Data Analytics
Array Technologies
02.2022 - 03.2023
Sales Reporting Analyst
Slocum and Sons Inc
09.2018 - 01.2022
Sales Analytics Manager (National Accounts)
Diageo North America
07.2008 - 04.2018
Customer Relationship Specialist
Gartner Incorporated
06.2004 - 06.2008
Master of Business Administration - Business Administration And Management
University of New Haven