Travant Solutions, Inc.
   

About
Services
Clients
Experience
Contact

Client Story: Ed Miniat, Inc.

Client Since July, 2010

Data Warehouse
Ed Miniat, Inc. (EMI) prepares, cooks, and ships fine meat products for restaurants, food manufacturers, and other institutions. EMI leverages an enterprise resource planning (ERP) system to manage their business; however, they had a need to take snapshots of data at specific points of time and conduct analytics at those points and aggregated over a long period of time. Travant defined and implemented a data warehouse to capture commodity costs, operating costs, recipe formulas, pricing, sales, and other pertinent data.
  • Microsoft SQL Service Analytical Services
  • Microsoft Reporting Services

 
Ed Miniat, Inc. Logo "Travant helped us to create an infrastructure that fostered our ability to analyze our data. This was a substantial improvement to depending on backups of ERP data to capture information at various points in time. Their experience with reporting and analysis tools was also very beneficial in helping us to leverage the data warehouse."

- Don McClain, Director of IT

Database Performance Tuning
Ed Miniat, Inc. (EMI) prepares, cooks, and ships fine meat products for restaurants, food manufacturers, and other institutions. EMI had an established implementation of their ERP system in a Microsoft SQL Server database environment. Over the course of time, various database queries that were used to facilitate certain system extensions, reports, and spreadsheets had experienced substantial performance decreases. Furthermore, these queries would slow the ERP transactional system when executing. Travant reviewed the queries, table indexes, and configuration of SQL Server. Travant then implemented enhancements in these areas, which substantially improved performance.
 
"Travant was an excellent advocate for our technical team. They provided guidance on performance tuning techniques and worked with our team members to improve their skills."

- Don McClain, Director of IT

Research and Development Product System (RDPS)
Ed Miniat, Inc. (EMI) prepares, cooks, and ships fine meat products for restaurants, food manufacturers, and other institutions. A key part of EMI's business model is to research new recipes for nutritional value and desired taste to meet the needs of their customers. EMI conducts projects to facilitate those efforts, and they produce sample for their customers in the process. They had been tracking this information in a variety of internal Access databases, spreadsheets, email, and other documents. Travant constructed the RDPS software application for EMI to manage their research projects and associated samples. EMI now has a central location that is available across the enterprise to view and update activities on research projects, and track and provide analytics for food samples.
  • Object Oriented Design and Development
  • Microsoft ASP.NET web application written in C#
  • Microsoft ASP.NET web service written in C#
  • AJAX Control Toolkit
  • Microsoft SQL Server
  • Microsoft SQL Server Reporting Services
  • Windows Service written in C#
  • Integrated with UPS shipping web API

 
"Travant has helped us to automate was a very tedious and manual process for shipping and tracking samples. The RDPS system has also provided a central repository that the research, sales, and executive management teams can all access. This has significantly simplified key processes in our research division."

- Bill Christenson, Senior Director, Research & Development