System Migration & Business Intelligence for Packaging Industry

Executive Summary

The Client is a leader in packaging industry with global outreach & their client base includes Walmart, JCPenny, etc. The client had hired software consultant company to migrate their outdated Macola EPR system to latest version & the existing various custom built Business Intelligence reports to new platform but consultant found it daunting task and abandoned the client in the midst of the project and thatís where we jumped in.

Business Challenges

  • Understanding current arduous MS-Excel, Crystal Report based approach
  • Integrate data from various global units of the business for generation of various BI reports
  • Migrate the existing system to new platform without affecting the current production operations
  • No design documentation available for existing system
  • Understanding different business insights matrices

Objectives of Implementation

  • Data consolidation from multiple sources such as Macola ERP, multiple XLS sheets, data from international business units and other legacy applications
  • To derive interactive analysis for various distribution & manufacturing centers, sales department related Key Performance Indicators (KPI)
  • Create documentation of existing system, BIs and enhance for migration changes
  • Personalize dashboards for various decision makers
  • Data access control to enhance security
  • Low infrastructure & maintenance cost

Project Execution

  • Understand the existing system and user needs
  • Develop SSIS packages for data cleansing and to build comprehensive and consolidated data warehouse by harvesting data from required sources
  • Develop reports using Crystal Reports & Reporting Services
  • Implement interactive dashboards
  • Migrate ERP system to new version
  • Weekly meeting with client and updates on the progress
  • Software quality control using automation tools
  • Deployment on various environments

Benefits

  • Better system performance
  • Better forecasting on various packaging demand and manufacturing
  • More accurate BI reports
  • System consolidation reduced infrastructure maintenance cost
  • Customer
    Leader in Packaging Industry
  • Industry
    Packaging
  • Offering
    System Migration & Business Intelligence
  • Operating System
    Windows
  • Database
    MS SQL Server
  • Data Integration
    SSIS
  • Business Intelligence
    Crystal Reports, Reporting Services
  • ERP
    Macola