Shamus Smail Email & Phone Number

Los Angeles, Ca, Us

Santa Monica, California, Us

Santa Monica, California, Us

Santa Monica, California, Us

Managed and automated POS reporting feeds for all offline retailers to facility trend analysis and drive strategic, data driven decision making while reducing need for data management by 60 hours a month. Created process to plan, forecast, and analyze promotions.Launched Tableau reporting platform, enabling sales teams and other internal customers to understand their business through interactive data visualizations. Managed sales strategy for Ring Alarm category ensuring continued growth and high adoption

Modesto, California, Us

Business Systems Analyst, Sales Technology Development, Information TechnologyOctober 2016 – March 2018 • Provided Chain Teams with visual representations of sales performance metrics through the creation of interactive Tableau Dashboards.• Worked with various stakeholders to ideate, develop, and launch a new Tableau dashboard focused on analyzing how shelf location of wine and spirit products affects sales performance.• Managed a project that tested the performance of an alternative shelf methodology and compared it to the performance of a standard shelf layout.• Saved Chain Teams 100+ hours of manual data input by managing the development and roll out of a Promotional Lift Analysis application. This app provided users with a simple way to flag products when they go on sale and analyze the effectiveness of the promotion (lift, sales, trend) after the promotion has ended. • Led our team's summer intern in a project to ensure the state of security access within our applications was up to date. Associate Business Systems Analyst, Category Management Development, Information ServicesSeptember 2015 – October 2016• Assisted in regular wine department reset projects for the major US grocers through the mastery of JDA's Category Management Software.• Reduced JDA Space Planning training time by 50% while increasing retainment through completely redesigning and simplifying the training program. • Saved Marketing analysts over 1000 hours of data pulls by converting Excel Pivot Tables into an interactive Tableau dashboard.

Modesto, California, Us

• Responsible for maintaining E&J Gallo's use of SAP's Enterprise Performance Management software to ensure up to date data for financial planning and budgeting purposes. • Worked closely with customers to ensure proper security access to all applications.