Manager Business Analytics

• Apr 2023 - Present

Senior Business Intelligence Analyst

• Apr 2022 - Apr 2023

Senior Business Analyst

• Nov 2018 - Apr 2022

• Use Microsoft SQL Server Management Studio to formulate and develop scripts for all user hierarchy reporting in multiple user facing reporting tools. • Work with internal and external users to develop meaningful reports, KPI’s, and metrics in Power BI and Periscope. • Liaison between multiple business units to identify areas of improvement and develop effective solutions and reporting metrics. • Work with developers to design, develop, and test custom web based applications and… Show more • Use Microsoft SQL Server Management Studio to formulate and develop scripts for all user hierarchy reporting in multiple user facing reporting tools. • Work with internal and external users to develop meaningful reports, KPI’s, and metrics in Power BI and Periscope. • Liaison between multiple business units to identify areas of improvement and develop effective solutions and reporting metrics. • Work with developers to design, develop, and test custom web based applications and system processes. • Use advanced data mining techniques using SQL, VBA and Power Query to validate and transform large datasets.

Business Analyst

• May 2017 - Nov 2018

• Use excel to create customized reports using advanced formulas and VBA coding for on site management and corporate executives. • Work with customers in developing inventory management and slotting programs for over 75,000 unique item numbers. • Work with the inventory team on identifying items with variances and cycle count programs for top 20 clients. • Manage monthly P&L reports and manage expenses for 3 business stations. • Task and monitor special case projects regarding… Show more • Use excel to create customized reports using advanced formulas and VBA coding for on site management and corporate executives. • Work with customers in developing inventory management and slotting programs for over 75,000 unique item numbers. • Work with the inventory team on identifying items with variances and cycle count programs for top 20 clients. • Manage monthly P&L reports and manage expenses for 3 business stations. • Task and monitor special case projects regarding movement and disposal of customer inventory.

SR. Sales & Supply Chain Analyst

• May 2016 - May 2017

• Manage and maintain forecasts from the sales ops and demand planning group with annual revenue of $14.4 billion. • Data mine from 4 different reporting systems (SAP, Analyzer, Logility and Sales Discovery) for business reporting. Translate large data sets into meaningful reports, scorecards, and metrics for internal teams, directors and VP’s. • Implemented advanced excel documents and VBA coding to automate reporting within the department with has lead to completion efficiencies and… Show more • Manage and maintain forecasts from the sales ops and demand planning group with annual revenue of $14.4 billion. • Data mine from 4 different reporting systems (SAP, Analyzer, Logility and Sales Discovery) for business reporting. Translate large data sets into meaningful reports, scorecards, and metrics for internal teams, directors and VP’s. • Implemented advanced excel documents and VBA coding to automate reporting within the department with has lead to completion efficiencies and improved report accuracy. • Point of contact and performed QA testing for the on SAP project. Data cubes were to be used in Analysis for Office and Power BI. • Manage customer hier levels sales rep, broker order confirms for over 900 unique ids across 2 sales organizations and 5 primary channels. Show less • Manage and maintain forecasts from the sales ops and demand planning group with annual revenue of $14.4 billion. • Data mine from 4 different reporting systems (SAP, Analyzer, Logility and Sales Discovery) for business reporting. Translate large data sets into meaningful reports, scorecards, and metrics for internal teams, directors and VP’s. • Implemented advanced excel documents and VBA coding to automate reporting within the department with has lead to completion efficiencies and… Show more • Manage and maintain forecasts from the sales ops and demand planning group with annual revenue of $14.4 billion. • Data mine from 4 different reporting systems (SAP, Analyzer, Logility and Sales Discovery) for business reporting. Translate large data sets into meaningful reports, scorecards, and metrics for internal teams, directors and VP’s. • Implemented advanced excel documents and VBA coding to automate reporting within the department with has lead to completion efficiencies and improved report accuracy. • Point of contact and performed QA testing for the on SAP project. Data cubes were to be used in Analysis for Office and Power BI. • Manage customer hier levels sales rep, broker order confirms for over 900 unique ids across 2 sales organizations and 5 primary channels. Show less

DC Manager

• Feb 2016 - May 2016

• Over-see a team of 30 employees. Mentor and train associates through 1 on 1 mentoring or written feedback. • Oversee warehouse inventory and ensure accurate date in 2 databases. • Oversee shipping operations and picking accuracy. • Conduct root cause analysis on inventory discrepancies and ensure effective communication throughout the warehouse. • Over-see a team of 30 employees. Mentor and train associates through 1 on 1 mentoring or written feedback. • Oversee warehouse inventory and ensure accurate date in 2 databases. • Oversee shipping operations and picking accuracy. • Conduct root cause analysis on inventory discrepancies and ensure effective communication throughout the warehouse.

Operations Manager

• Oct 2015 - Feb 2016

• Monitor department expenses and labor costs to ensure company budgets are met. • Monitor inventory levels and ensure safety stock levels are met and coordinate with production to ensure all raw materials needed are accounted for. • Oversee that all stock is being rotated according to FIFO for inventory worth millions of dollars. • Ensure all team members are crossed trailed with has lead to over a 99% picking accuracy in a full paper warehouse. • Over-see a team of 14 team… Show more • Monitor department expenses and labor costs to ensure company budgets are met. • Monitor inventory levels and ensure safety stock levels are met and coordinate with production to ensure all raw materials needed are accounted for. • Oversee that all stock is being rotated according to FIFO for inventory worth millions of dollars. • Ensure all team members are crossed trailed with has lead to over a 99% picking accuracy in a full paper warehouse. • Over-see a team of 14 team members. Mentor and train associates through 1 on 1 mentoring or written feedback.

Warehouse & Inventory Control Lead

• May 2014 - Oct 2015

• Over-see all warehouse inventories for an 80,000 sq ft facility and 20,000 sq feet offsite storage with over 400 unique item numbers. • Created advanced Excel documents using, VBA coding, macros, array’s, vlookups and other tools in excel. • Determine/resolve core causes for inventory discrepancies from cycle counts for 2 computer systems. Also make inventory stock adjustments into 2 WMS systems. • Implemented new strategies on warehouse floor which resulted in inventory and bin… Show more • Over-see all warehouse inventories for an 80,000 sq ft facility and 20,000 sq feet offsite storage with over 400 unique item numbers. • Created advanced Excel documents using, VBA coding, macros, array’s, vlookups and other tools in excel. • Determine/resolve core causes for inventory discrepancies from cycle counts for 2 computer systems. Also make inventory stock adjustments into 2 WMS systems. • Implemented new strategies on warehouse floor which resulted in inventory and bin location accuracy of over 99% for a full paper warehouse. • Coordinated with Customer Service Representatives to ensure customer orders leave on time and are picked with over a 99% accuracy rate.