Michael Rando Email & Phone Number

Boise, Idaho, Us

Driving actionable business analytical solutions at a national scale. Aligning accuracy, depth, breadth and ease/speed of use. Aiding in the democratization of data, empowering our teams across the organization with the development of BI Tools.- Primary reporting product (PBI Merchandising use case) used by over 3,500 individuals at the division and national level. Started as a pet project- Managed a cross-functional team of twelve- Managed an annual budget of over $3M- Provided best-in-class reporting that was set as a standard for others to follow- Financial alignment of POS transactional data

Boise, Idaho, Us

Boise, Idaho, Us

- Developed Price Elasticity Model and Price Optimization Tool balancing predicted Sales & Gross- Category Optimization Program has consistently added to Division profit while increasing sales and units- Corporate Marketing & Merchandising Analytical Leadership Group Member- Analytics Council Member, Corporate Promotions and Pricing Advisory Council- Managed P&L for Under performing Categories and led them to growth in sales, units and profit- Aligned Category pricing in step with market & house brands- Built and maintained Division tools tracking a variety of metrics- Provided analysis in regard to Sales, AGP, Promotional Offers, Competition and Pricing- Developed and maintained dozens of Division(& Company) wide programs, including, but not limited to, predictive analytical tools & price elasticity models- Provided support to Executive Leadership and Sales Leadership- Taught and mentored 250+ individuals in SQL, Excel and various analytical tools, both in person (1v1) and in large groups- Compiled and provided data for Division recap to Corporate Executive Leadership on a quarterly basis- Assisted in quarterly Projection process and developed tools to streamline execution

Boise, Idaho, Us

- Built and maintained expert level Excel Spreadsheets tracking a vaierty of metrics- Provided analysis in regard to Sales, AGP, Promotional Offers, Competition and Pricing- Developed and maintained dozens of Division(& Company) wide programs, including, but not limited to, predictive analytical tools & price elasticity models- Provided support to 300+ members of Marketing, Merchandising and Operations- Taught and mentored 250+ individuals in SQL, Excel and various analytical tools, both in person (1v1) and in large groups- Compiled and provided data for Division recap to Corporate Executive Leadership on a quarterly basis- Earned three separate awards for excellence within the Division for Finance and Analytics respectively

Boise, Idaho, Us

- Built and maintained advanced/expert level Excel Spreadsheets- Provided analysis in regard to Sales, AGP, Promotional Offers, Competition- Developed and maintained dozens of Division wide programs- Provided support to 300+ members of Marketing, Merchandising and Operations- Taught and mentored 250+ individuals in SQL, Excel and various analytical tools, both in person (1v1) and in large groups

Boise, Idaho, Us

- Built and maintained advanced level spreadsheets tracking a variety of metrics- Performed Excel support for Retail and Marketing Support Teams- Developed and maintained dozens of Division wide programs- Scouted and assisted in the integration and marketing of over one hundred Local products- Facilitated the implementation of new items into facilities on the Division level

Boise, Idaho, Us

- Managed a staff of up to 150- Performed payroll operations for several facilities- Hired and trained over 300 employees- Performed scheduling for several facilities- Performed facility level bookkeeping and general accounting

- Completed projects for dozens of small businesses (web design, social media).- Provided marketing support for said small businesses.