Senior Analyst, Business Intelligence and Marketing Analytics
2015 - 2017Conisus LLC- Consulted leadership of a large pharmaceutical firm to design custom, mobile analytics solutions in Tableau and SQL Server.
- Collaborated with internal senior leadership to flesh out new business intelligence line-up, adding additional company revenue streams.
- Orchestrated formation of visual-based analytics department to increase marketing efficacy, positive cash flow within first year.
- Designed and facilitated implementation of cutting-edge IT systems using SQL and SSIS, reducing average analysis time 60%.
- Studied and created new company processes to structure program coordination and reduce touch points by 30%.
- Designed accounting process and dashboard to track expenses and missing items, supplanting hours spent per day creating and reconciling spreadsheets.
- Managed a Tableau Server, using tabadmin, tabcmd, REST API, local authentication, and trusted ticket authentication to create unique functionality for end users.
Technologies: SQL, SSIS, TableauSenior Analyst, Inventory and Supply Chain Decisions
2012 - 2015The Home Depot- Designed Order and Truckload economic decision model and process saving 25% of transportation costs for $80 billion supply chain.
- Forecasted sales and least-cost options to reduce lead times by 50% and more using Poisson, Exponential, and Monte Carlo simulations.
- Built data model and tables for 25-person supply chain analytics teams, bringing together many disparate systems.
- Reduced emergency process by 50%, led UAT team, trained 45 associates, design and implemented enterprise-wide web app while serving on the Emergency Visibility Taskforce.
- Developed Assortment Tracking software project with Excel front-end and Access back-end to report daily and monthly trends and issues to senior leadership.
- Rewrote store Informix code to monitor and call out changes in high-velocity seasonal SKUs and changed ordering algorithms saving tens of thousands per store per year.
Technologies: DB2, Teradata, VBA, SQL Server, Hadoop, Informix, TableauAnalyst, Holiday Inventory
2011 - 2012The Home Depot- Coordinated and executed $360 million inventory transfer from vendors to distribution centers to stores.
- Exceeded all program metrics: turns of 5.21 vs. 4.72, sell through 82.8% vs. 81%, DC in-stock 99.6% vs. 99.17%.
- Helped create lost-sales algorithm and template to forecast future needs.
- Created Store-SKU allocation database to coordinate inbound orders, initial sets, and replenishment.
- Automated process for tracking and reporting products on ads.
- Distribution-Center-to-Store product receipt lookup.
Technologies: VBA, Excel, AccessSenior Analyst
2010 - 2011BirdDog Solutions, Inc.- Led project to bring parcel, LTL, Truckload, and Ocean data-entry in-house.
- Supported development and maintenance of Microsoft Access SQL database for data entry and analysis.
- Managed and trained eight temporary employees in data-entry processes.
- Reduced receipt-to-delivery entry times by 70%.
- Vastly increased breadth and depth of analysis and consultation capabilities.
- Lead analyst on full-network optimization/reorganization for national retail supplier.
- Supported the consolidation of parcel shipping and distribution centers by utilizing current and future package distribution strategies using Excel and SQL analysis techniques.
- Introduced new transportation management systems to facilitate shipment times and method.
- Updated warehousing strategies and layouts to accommodate expedited order process and trailer utilization.
Technologies: Excel, Access, VBAAnalyst
2008 - 2010BirdDog Solutions, Inc.- Supported consulting process for over 200 middle-market and national companies.
- Analyzed shipment and load-level data and contracts to create and present cost avoidance and reduction strategies through utilization of advanced Excel techniques (pivot tables, vlookups, etc.) and SQL.
- Supported the cost savings of over 30% of transportation spend for clients.
- Responsible for set-up of small parcel clients for invoicing and oversight of initial carrier implementation compliance.
Technologies: ExcelIntern, Technical Support
2007 - 2007Wandering Wifi, Inc.- Provided client support for wireless internet and computer and hardware configurations.
- Managed group of eight employees in project to improve processes and process management.
- Wrote foundation documents for training of new employees to cut time necessary by 33%.
- Managed daily operations and technical proficiency of 15 employees.
Technologies: Networking, WiFi standards, AirWatch