MS SQL Server, O365, MS Project, Visio, Jira, Confluence, Power BI
Mark Garberding
Sr Manager - Data Analytics & Business Systems
Summary
Versatile Senior Manager in IT Engineering seeking opportunity to stretch skills in systems, data analytics, operations, and enterprise project management to unlock potential with timely actions and insights while helping others grow and succeed.
Overview
26
26
years of professional experience
5
5
years of post-secondary education
Work History
Sr Manager Data Analytics & Merch Systems
LTD Commodities LLC
Lincolnshire, IL
05.2019 - 04.2023
- Delivered analytical and operational reporting and analysis informing and influencing key revenue and cost savings initiatives; frequently advising C suite and VPs.
- Adept at database design and complex stored procedure development in MS SQL Server; some with hundreds of millions of rows.
- Designed, developed, and maintained core integrations between our Merchandising system and SAP, eCommerce, Warehouse, Inventory Planning, and numerous third-party vendors.
- Led build-out of our Enterprise SQL Server data warehouse; including dimensions and facts to analyze customer segmentation, life-time-value, costs and margin.
- Identified opportunity to extend holiday shipping window; designed, developed, and administered solution; achieving incremental revenue growth up to $1MM annually.
- Led design and development of Merchandising system enhancements to onboard newly acquired brand and its product assortment.
Merchandising Systems Manager
LTD Commodities LLC
Lincolnshire, IL
02.2015 - 05.2019
- Re-assigned as Merchandising Systems Manager to course correct significant project that was both over-budget and behind schedule. Achieved successful implementation within three months.
- Designed and led development of Merchandising, SAP, and Web changes to add drop shipping; boosting annual revenue by up to $10MM.
- Worked closely with management teams to plan, develop and execute technical strategies aligned to company vision.
- Recommended systems improvements to business leadership, prioritizing maximum return on investment (ROI).
Sr Business Analyst/MGR SAP MM and Order to Cash
LTD Commodities LLC
Lincolnshire, IL
01.2012 - 02.2015
- Produced requirements and led SAP development to minimize outbound customer shipping freight spend; saving in excess of $5MM annually.
- Led cross-functional implementation of Paypal
- Designed and led SAP, Merchandising, and Web implementation of product availability and web page sort order logic; minimizing backorder cancellations while promoting in stock, high margin, high demand items.
- Facilitated Business Strategy Team sessions to plan, develop and execute technical strategies aligned to client's vision.
Business Analyst, Project Lead/Project Manager/Senior Project Manager
LTD Commodities LLC
Lincolnshire, IL
03.2002 - 01.2012
- Produced detailed requirements and functional designs for small to enterprise projects; including custom Warehouse Management System design and development and its supporting integrations to pack-to-light, traffic/packing/shipping sorters, printers, RF devices, etc.
- Led all internal system design and development of system enhancements and interface development to/from SAP R/3 during its implementation.
- Project Managed implementation of new third party hosted eCommerce website from inception through system and user acceptance testing and cutover with no unplanned system downtime.
- Developed and implemented strategic project plans in excess of 1000 tasks to meet business objectives.
Warehouse Operations Supervisor
LTD Commodities LLC
Bannockburn, Gurnee, IL
05.1997 - 03.2002
- Redesigned returns function, incorporating new equipment, processes, and procedures; achieving 50% headcount reduction.
- Oversaw all warehouse functions; receiving, inspection, pick-pack-shipping, and maintenance of 60,000 sq ft facility with 60 plus employees.
- Achieved best-in-company quality and productivity targets.
Education
Bachelor of Science - Business Management
Northern Illinois University
Dekalb, IL 05.2001 -
MBA - Business Administration
Northern Illinois University
Dekalb, IL 05.2001 - 12.2005
Skills
Enterprise Reporting & Data Analytics, Project Management, Operations
Software
Accomplishments
- 2 time employee/manager of the year out of several thousand candidates
- Gardening, hiking, biking, KiMudo
Timeline
Sr Manager Data Analytics & Merch Systems
LTD Commodities LLC
05.2019 - 04.2023
Merchandising Systems Manager
LTD Commodities LLC
02.2015 - 05.2019
Sr Business Analyst/MGR SAP MM and Order to Cash
LTD Commodities LLC
01.2012 - 02.2015
Business Analyst, Project Lead/Project Manager/Senior Project Manager
LTD Commodities LLC
03.2002 - 01.2012
Bachelor of Science - Business Management
Northern Illinois University
05.2001 -
MBA - Business Administration
Northern Illinois University
05.2001 - 12.2005
Warehouse Operations Supervisor
LTD Commodities LLC
05.1997 - 03.2002