Transportation Industry Case Study – Microsoft .NET Data Warehouse

CHALLENGE:

A steamship equipment depot management facility that stores and repairs equipment for some of the largest steamship companies in the world had the following challenges:

  • Sharing information among its multiple facilities.
  • Providing customers with timely and credible repair estimates.
  • Providing timely and accurate information to their customers regarding their equipment.
  • Providing customers with an interface that would allow them to view equipment activity, approve repairs and create bookings.
  • Providing customers data that can be integrated into their own systems and applications.
SOLUTION:

Working together with our client, Aptude built a robust data warehouse application that allowed the depot’s customers to access the new enterprise system via a secure Internet connection.

  • Gate activity (storage) was captured in real-time using a hand-held device with images that updated a live database via a 802.11 b connection.
  • Repair estimates were also generated on the hand-held unit as intermodal equipment came into the depot. The repair estimates were also sent to the database via an 802.11 connection. Once the repair was stored in the database, a scheduled job would electronically notify the depot’s client that a repair estimate was created for a particular unit and an approval or disapproval action was needed. With password authority to view the repair estimate and the images related to the repair, the depot’s client could then approve or disapprove the repair estimate.

The new hand-held/repair piece can potentially save days in the repair estimating process. Furthermore, the new application sends hourly data feeds to its customers in the format they require. This is truly a business-to-business application that has increased labor efficiencies, provided immediacy and increased customer satisfaction.

Profit Improvement Benefits
Repair estimates that are more credible, accurate and timely lead to more repair approvals which led to higher sales. Reducing labor resources via the hand-held, online reports and business to business transactions reduces our client’s expenses.

Keep Moving Forward with Aptude

Aptude is your own personal IT professional services firm. We provide our clients with first class resources in a continuous, cost-containment fashion.

Our support services will free up your senior IT staff from the overwhelming burden of day-to-day maintenance issues. Now they’ll have time to launch those new projects and applications you’ve been waiting for. Simply put, we can free up your resources and contain your costs. Let’s have a quick chat to discuss our exclusive services.

Contact Us

Gain Time, Increase Currency, Contact Us

It’s amazing how one quick email can change your life. Give us a shout! We’ll get back to you right away with the right person for what you’re looking to accomplish.

You don't have to go into a lot of detail now, we'll dial it in later.
=
Testimonials

Aptude provides onsite and offshore Oracle DBA support, which includes troubleshooting, back-up, recovery, migration, upgrades, and daily maintenance of Oracle database servers. Aptude has been working with our team for the past four years and we continue to use them and are satisfied with their work

Warren E., Schneider National


Aptude provided us with Oracle DBA migration support, including an upgrade from Oracle 11.1 to Oracle 11.2, and the project was completed on time and to specifications. The project manager and project consultants were responsive and proactive, resulting in a successful conclusion to the work. I would definitely contract with them again, and have recommended them to other technical offices at the University of Georgia.

David C., University of Georgia