Database Migration

Database Migration

Overview

Canine to Five is Metro Detroit’s finest dog daycare, boarding, and grooming facility, located in the heart of Detroit’s Historic Midtown Neighborhood. Canine to Five is a staple in Detroit culture and, through its commitment to dogs and their owners, it has grown to include a second location in Ferndale.

Challenge

Canine to Five was looking to overhaul its entire customer management software into an all-new, all-inclusive, cloud-based software. PDS was tasked with the data transformation process from the old format to the new for daycare, boarding, and grooming. This transformation had to be undertaken for both C25 facilities.

Solution

PDS worked with the Canine to Five staff to analyze and design the target format. We helped them scope and identify only the data needed to fulfill the requirements of the new system. This included analyzing the SQL database containing the raw data so that we could extract the data to a usable format. We assessed the data for column names, data types, the relationships between columns, the range of values, the frequency of missing or junk data, and the number of rows.

Next, PDS performed a data cleanse to transform formats including date, numerical and phone numbers for the new system, clean the address information, and check for columns that may show a large frequency of missing values or junk data. After, PDS was able to map the cleansed source data to the target data and upload the newly transformed data into the new system.

PDS then provided on-site support to Canine to Five staff during the software migration process in order to ensure data viability and to immediately address any issues that may have existed.

Summary

PDS carefully and successfully extracted, examined, refined, and delivered the data in such a way as to maximize its value. This process included rigorous user acceptance testing, and the PDS transformation team was able to quickly address any anomalies found in the new system. Canine to Five was able to smoothly transfer to the new system without any loss of data or negative impact on their daily business.

Market Analysis – Automotive Supplier

“Beta” Company is a regional retailer of tires and automotive repair. Beta is a leader in the industry and sells to a diverse audience. Beta was interested in determining which markets represented the greatest opportunity for growth, so as to expand their brand.

Staff Planning System for Field Offices

This national client wanted a way for its individual store managers to plan their staff and equipment needs using their own local knowledge of seasonal trends, coupled with in-depth statistics provided at the corporate level. The client had previously handled this via the loose collection of Excel documents in various formats using data that wasn't current enough to be useful.

Marketing Event Management System

This client holds thousands of local marketing events across the country, hosted by its field offices. Raffles and giveaways are held and leads are collected. They needed a way to collect the lead data, coupled with responses to a few strategic questions, and integrate the data into a CRM effort where the leads could then be contacted by phone and email with discount offers. Client wanted real-time visibility to event activity, CRM activity, and subsequent conversion rates.

Managed Mail Solution

This client provides seniors and their families with senior living options for all stages of their lives. They have several locations in multiple states. They focus not only on their senior residents and families, but also take great pride in being an employer-of-choice for their employees.

Reporting Portal Development

A Fortune 5000 company was looking for a mobile solution that included event management to capture lead data in real time in order to better manage communication to any given individual through the marketing funnel, as well as to facilitate effectiveness metrics for management.