Scott Jacob Email & Phone Number

Mattoon, Illinois, US

• Predictive Data Analysis and Statistical Modeling: Analyzed panelist mobile app data involving millions of daily data points to determine trends in app usage using a variety of demographics, geographic location, and.
• Automation and coding: Created automated python script to weight daily active panelists for both US and UK based on census data and geographic location.
• SQL Reporting: Designed customized Snowflake queries used for external client reporting.
• Initiative: Proactively investigated the veracity of questionable findings by tracking down source tables and corroborating with external research. Identified the root causes of data issues and took appropriate short.
• Data Visualization and Strategic Insights: Created Tableau dashboards to support decision making by marketing team and senior leadership and to highlight panel value to potential partners. Trained team on dashboard.

• Financial Analysis: Analyzed revenue and usage trends. Adjusted both monthly and long-term forecast based on current trends, signed leases, and the probability of winning new contracts.
• Reporting: Generated a variety of partner and product-based reporting. Used Excel to analyze data and create charts and PowerPoint to convey findings to leadership.
• Data Visualization and Strategic Insights: Created dashboards in Tableau to support strategic decision making. Used data to make rate-plan recommendations to improve sales and margin performance. Analyzed satellite.
• Process Improvement: Automated multiple reports and improved GX pricing model using VBA macros.

• Data Analysis and Reporting: Determined price points for Pork and Poultry for Stop and Shop Supermarkets. Generated reports assessing effectiveness of weekly promotions.
• Strategic Thinking: Made recommendations to improve sales and margin performance.

• Data Analysis: Created automated reports and determined the feasibility of various business ventures. Compiled data for and helped to implement new client health weighting system for quarterly business reviews.
• Data Visualization and Strategic Insights: Created new data set for use in Tableau dashboards to support strategic decision making by Client Services team.

• Automation and Coding: Used VBA to combine data from Microsoft Access, Teradata, and online Adobe reporting platform and automatically generate and distribute vendor reports and dashboards. Created a revised template.
• Data Analysis and Reporting: Regularly assisted merchants and vendors with reporting requests using SQL, MS Access, and MicroStrategy. Assisted merchants and vendors with data analysis needed to launch projects.
• Data Visualization and Strategic Insights: Met with Staples merchants to determine needs, then used Tableau to provide them with improved access to data required to make daily decisions concerning their businesses..

• Business Modeling: Assisted in concept and design of a business model that used advanced metrics to simulate subscribers, revenue, and costs for Live Circle.

• Data Analysis: Analyzed data for Lionel Battle Train to determine suitable prices and values for game attributes prior to U.S. launch. Established new parameters for data collection and methodology that could be used.
• Business Planning: Conducted research and provided strategic analysis to inform future monetization efforts for GameSprout website.

• Data and Strategic Analysis: Collected and analyzed outcome data covering hundreds of variables and tens of thousands of records. Worked with management to determine how to show the relationship between our work and.
• Teamwork / Collaboration: Personally worked on-site with IT subcontractor to complete project in one week after a months-long failure to meet requirements. Achieved team buy-in to revamp document approval workflow for.
• Coding and Process Improvement: Used mail merge to reduce package generation times by 75%. Created or improved MS Access Databases, creating VBA macros to optimize the efficiency of data entry and reporting. Designed.

• Benefit Calculation: Determined eligibility for and amount of compensation Plan Participants and their beneficiaries were entitled to by analyzing applications in accordance with Plan rules.
• Initiative: Voluntarily took the largest and most difficult caseload in department despite being the most junior member. Mentored and assisted other team members.

Master Of Business Administration (Mba), Operations Management, Finance, Organizational Behavior, Quantitative Analysis, Economics

Ba, Philosophy