Micah Depner
BUSINESS SYSTEMS IMPLEMENTATION and OPTIMIZATION Business Systems Analyst · Nite Ize
Denver Metropolitan Area, CO
In My Own Words
Growth-driven Professional with extensive experience in Business Intelligence, Data Analysis and Visualization, and Process Improvement with firms ranging from family-owned retailers to established global brands. Naturally skilled in defining the business question and collaborating to identify the best go-forward approach.
Work Experience
Business Intelligence Analyst
Nite Ize2016 – 2020
Domo Subject Matter Expert (Major Domo) and first resource to the Executive and Sales teams in providing Data Visualization, Training on Data Interpretation, Capturing and Tracking Internal Sales details and Point of Sale data from key retailers. • Provided Executive and Sales teams visibility to their Sales, Open Orders, Shipment Details, and progress to Goal in one single source of truth by building and orchestrating scheduled data feed reports in Oracle BI Publisher and other sources, joined in Domo using Magic ETL, and creating subsequent KPI Data Visualizations in a Dashboard format. • Created better visibility, better decisions, and increased sales by capturing, building, and orchestrating disparate POS data from various sources into Domo BI app for multiple key accounts. Created Dashboards and Data Visualizations for POS KPI’s, with easy to read tables, charts, and graphs in an organized environment for Sales and Executive teams to monitor and analyze account/regional/product performance at point of sale. • Developed, implemented, and trained users on a Sales Forecasting process that gave visibility to previous sales and allowed for more accurate sales forecasting by account/month. Connected to Domo BI app to provide real-time roll-up visibility for the executive team. • Conducted shared learning gatherings among Domo users to bring forth questions around BI functions and capabilities, and as a result, teaching Domo users how to fish and increasing the acceptance rate from nearly zero to 40% across the entire enterprise.
Oracle Business Intelligence SuperUser
Nite Ize2018 – 2019
Providing much-needed visibility to ongoing business performance as we stabilize the new systems. • Managing, tracking, and delegating all report request in order to accommodate all reporting needs while avoiding duplicate efforts and report proliferation. • Designing a Data Library with a core set of validated datasets that can be used cross-functionally and provide a trusted single source of truth and actionable insights. • Created and joined Sales Order and On-Hand Inventory Status reports in WMS & ERP to provide visibility of Sales Orders and Availability to the Sales teams and eliminate the disconnect along OTC (Order-to-Cash) flow.
Oracle Master Data SuperUser
Nite Ize2018 – 2019
Driving to improve the Nite Ize Oracle Cloud user experience as we stabilize the system with the new systems and tools. • Solved data issues after go-live as new requirements are brought to light by maintaining and updating all Customer and Item Master data via FBDI loads. • Developed and implemented a 7-tier Product Categorization methodology, which aligns Product with Finance on all Finished Goods. This resulted in flexible reporting by Brand, Category/Sub-category, Sub-Brand, etc, and alignment within Sales Revenue, G/L Accounting, Marketing and Procurement/Supply Chain areas. • Developed and implemented Royalties as a cost component in the BOM structure of root items, which eliminated the requirement to calculate and segment multiple royalty payouts on complex items and ensure payees are compensated accurately.
Oracle Cloud Implementation Data Support
Nite Ize2018 – 2018
Teamed with over 40 domestic and offshore experts within a 9-month go-live timeframe to configure and implement Oracle Cloud ERP, WMS, CRM, and PD enterprise solutions. • Aligned with the implementation team to be the on-site resource of current business process details which was crucial in joining Nite Ize business practices with Oracle Cloud solutions requirements. • Utilized Data Mining, Data Mapping, and Process Improvement skills to provide data from the legacy system and transition Order to Cash transactional processes in the new environment. • Architected New Item Creation process with system-based orchestration, which provides complete, accurate and more efficient item creation and prevents bottlenecks due to missing attributes down the line. • Developed, Configured, and Implemented a Data Import process to efficiently load orders from ERP to WMS to ensure the warehouse is receiving complete sales order information to their system in a timely manner, allowing them to allocate and ship on time. • Developed a work-around for Sales/Commission tracking at the Ship-To location in order calculate incentive pay for sales team members, necessary for Drop-Ship partners with mixed sales account managers.
Trade Marketing Manager
The Coleman Company, Inc2014 – 2015
Categories: Battery Lighting, Tents & Shelters Concept: Liaison between Sales and Product Development teams • Developed a Special Item Request submission form and approval process to vet out lucrative opportunities. Resulted in a significant reduction of “churn” for the Product Development team and allowed us to focus on developing products that would support the necessary volume and increase in profit margin
Product Development Coordinator
The Coleman Company, Inc2013 – 2014
Coordinated launches of dozens of products across several Product lines through two launch cycles Categories: Softlines including Tents & Shelters, Rainwear, Backpacks, Sleeping Bags & Pads, Furniture, Games, and Accessories
Global Customer Service Manager/Account Executive
Westlife Distribution - 686 Outerwear & Matix Apparel2008 – 2013
Managed all incoming customer inquiries, providing a human touch to all consumers and key retailers. • Developed and Trained CS associates on Warranty tracking process to capture recurring issues in MS Access, which resulted in identifying and quantifying factory defects. Submitted claims to factories which resulted in annual reimbursements. • Oversaw operations of the tradeshow booth at Outdoor Retailer (formerly SIA). Greeting clients, introducing them to new product, and putting faces to names improved working relationships after the show. • Provided weekly availability reports to key retail partners for reorder opportunities. Resulted in exponential sales growth for several accounts.
Retail Manager/Buyer/Analyst/Sales
Various Action Sports Retailers across the country1994 – 2008
Retail Manager/Buyer/Analyst/Sales VAL SURF – Valley Village, CA * WORLD BOARDS – Bozeman, MT * TORQUE CENTER – New Berlin, WI • Manager Retail Operations Manager for 5 store locations to Floor manager and Product Manager • Buyer for Snowboard Hardgoods, Soft goods, Apparel, Shoes, Skateboards, etc • Analyst assisting buyers in product assortment with data-based decision-making tools • Sales Snowboard, Mountain Bike, and Skateboard Equipment, Technical and Lifestyle Apparel and Footwear, Hotel and Conference Rooms, Automotive, Satellite TV services, etc.
Education
Associates of Applied Science in Environmental Technology
Milwaukee Area Technical College1995 – 1996
Associates of Applied Science in Environmental Technology
BS in Business-Marketing; Minor in Entrepreneurship and Small Business Management
Montana State University - Bozeman2004 – 2006
BS in Business-Marketing; Minor in Entrepreneurship and Small Business Management
