David Kirk Data Solutions logo David Kirk Data Solutions LLC

Case Studies Page

Proven Results in High-Stakes Data Environments

Real-world examples of recovery, implementation, reporting, analytics, and modernization projects delivered under pressure.

Featured Case Studies

Systems Recovered, Built, and Scaled

Ransomware Recovery (2019)

Rebuilt the entire BI and SQL ecosystem within 36 hours using clean Datto backups and a full WMS reinstall.

View Full Case Study

Led a high‑pressure enterprise recovery after a full‑environment ransomware attack. Restored SQL Server, Cognos, Manhattan SCALE, and all reporting systems using clean Datto backups. Rebuilt databases, validated data integrity, reconnected WMS integrations, and restored operational reporting within 36 hours.

Partnered with Manhattan Associates to reinstall SCALE, reconfigure RF devices, and reestablish all warehouse workflows. Full operational capacity was restored in under 48 hours, preventing catastrophic business interruption.

Manhattan Active Scale Implementation

Led all data modeling, integration, and reporting configuration for a full WMS modernization.

View Full Case Study

Directed the data architecture and reporting configuration for a Manhattan Active SCALE implementation. Designed data models, validated inbound/outbound integrations, and ensured operational readiness across receiving, picking, replenishment, and shipping.

Built foundational reporting layers, validated RF workflows, and ensured clean migration from legacy systems. Delivered a stable, scalable WMS environment ready for high‑volume distribution.

Operational Workspace Suite (Picking, Shipping, IC, Inbound)

Designed a unified operational intelligence platform with multi‑layer drill‑through dashboards across four warehouse departments.

View Full Case Study

Built a complete suite of Cognos operational workspaces for Picking, Shipping, Inventory Control, and Inbound. Each workspace featured tiled KPIs, real‑time metrics, and multi‑layer drill‑through paths down to item‑level and location‑level detail.

Developed SQL models, semantic layers, and reusable Cognos packages. Integrated data from Manhattan SCALE, RF devices, HRIS systems, and EDI/API feeds. Created full training guides and operational process maps for Cycle Counting, Replenishment, and Receiving.

These workspaces became the daily command center for supervisors and analysts, reducing manual reporting, improving visibility, and enabling faster, data‑driven decisions across the distribution network.

Enterprise Reporting Ecosystem

Designed 300+ Cognos reports, dashboards, and semantic layers supporting a multi‑site distribution network.

View Full Case Study

Architected a full enterprise reporting ecosystem including 300+ Cognos reports, reusable data models, semantic layers, and department‑specific dashboards. Standardized KPI definitions across operations, finance, purchasing, and customer service.

Implemented automated scheduling, parameterized reporting, and drill‑through structures that reduced manual reporting workload by over 80%.

Labor Analytics System (LMS)

Built a real‑time labor tracking system using SQL‑driven historical capture tables and HRIS integration.

View Full Case Study

Designed a custom SQL‑based Labor Management System integrating Manhattan SCALE task data with Ultipro wage/timeclock data. Built historical capture tables, real‑time cost‑per‑task metrics, and executive KPI dashboards.

Delivered accurate labor cost visibility, productivity insights, and department‑level performance tracking used daily by operations leadership.

WMS Document Automation (SSRS)

Engineered SSRS documents for Bills of Lading, Packing Lists, and Commercial Invoices integrated with SCALE.

View Full Case Study

Built SQL stored procedures and SSRS layouts for mission‑critical shipping documents including Bills of Lading, Packing Lists, and Commercial Invoices. Integrated document routing with Manhattan SCALE and multi‑carrier workflows.

Ensured compliance with carrier requirements, automated printing logic, and reduced manual document errors across outbound operations.

Cloud Migration (Cognos 11 → 12)

Migrated Cognos 11 to Cognos 12 Cloud with rebuilt metadata, security models, and reporting logic.

View Full Case Study

Led the migration of Cognos 11 to Cognos 12 Cloud. Rebuilt metadata layers, security models, and authentication logic for cloud compliance. Validated all reports, dashboards, and data sources.

Delivered a clean, modernized cloud reporting environment with improved performance and governance.

SAP Process Mapping & Workflow Design

Recreated warehouse workflows in SAP Signavio using BPMN 2.0 for Cycle Counting, Replenishment, and Receiving.

View Full Case Study

Translated warehouse operational workflows into SAP‑aligned BPMN 2.0 diagrams using SAP Signavio. Modeled Cycle Count, Replenishment, and Receiving processes with role‑based swimlanes and system interactions.

These diagrams demonstrate enterprise‑grade process architecture and support SAP EWM, Activate, and cross‑functional operational design.

Let us apply this same execution discipline to your data systems.

Get Started