Software Design & Development
Retail

A Pattern for Growth: Removal of Hard Coding

Trility helped this client meet the demands of a competitive industry by removing hard-coded relationships within stored procedures. The code prevented improvements in efficiency, controls, and reporting for two new applications that enabled faster setup for new locations, new lines of business, and accuracy in reporting.

Problem Statement

As this regional retail company acquired and added new stores while dramatically growing and evolving its service model, it had 1,000 lines of hard-coded stored procedures that prevented efficiencies when opening new stores and accuracy in financial reporting based on lines of business (LOB) within each new and old store.

Solution Approach

By removing the hard-coded values used throughout the stored procedures and applications, the IT teams could quickly add new stores and LOBs to new and existing stores. The removal would also improve financial reporting accuracy by store, store type, and LOBs, and create flexibility in the reporting process. Trility's approach included:

  • Eliminating 1,000 procedures. 

  • Removing 1:1 relationship between stores and the lines of business within the stores.

  • Building a standard for new store procedures and applications.

  • Leveraging SQL server integration services (Microsoft ETL) to move data around, Microsoft SQL for reporting services, Redgate for standard search of hard-coded values, and Intellij and Kotlin for testing.

Outcomes

The solution led internal teams to adopt an expedited pattern for new store setup and LOBs and resulted in the following outcomes:

  • Consolidated financial reporting for types of stores and various LOBs.

  • Created consistency for database objects and values across the company.

  • Future savings in time and money as the company expands and adds locations and LOB within each location.

  • Improved analysis of store profitability and LOBs.

Project Attributes

  • Reduced COA
  • Reduced COO
  • Reduced Technical Debt
  • Reusable Patterns
  • Increased Scalability
  • Increased Capabilities
  • Verifiable Compliance
  • Documentation

Technologies Used

  • Intellij
  • Kotlin
  • Redgate
  • Microsoft SQL
  • Terraform Enterprise
  • AWS Kubernetes Service (EKS)