NewMark Merrill

portfolio item

The Merrill Companies Property Management

The Challenge
With several departments responsible for different types of data it made it virtually impossible for the company to operate as a cohesive unit. Since this was a service company, communicating information to clients was extremely important, but it was not happening efficiently. Clients were being lost at a high rate.

The JMC Solution
After examining the departments and the network infrastructure we determined that new working procedures were in order. A custom-designed database was created and information was shared among several departmental lines to improve communication.

Each department enters their particular data and is able to produce individual reports. In addition, each employee can now view the information for all departments from there desktop, thus increasing efficiency and overall communications.

Princess Cruises & Tours

portfolio item

The Challenge
The sales department of this cruise line required a database to assist in  generating financial reports.

The JMC Solution
A new application was created to import raw data from the company's mainframe computer and perform the necessary calculations to generate financial reports. Among a dozen reports available is one that shows financial revenue based on category of cruise lines, specific cruises and offers year-end and year-to-date comparisons with annual percentage increases over a four-year period.

Technicolor

portfolio item

Processor, manufacturer and distributor of film, video, DVD and CD's

The Challenge
Production time was being lost because assembly line machines responsible for the production of VHS tapes were automatically shutting down numerous times a day for short periods of time. The department head needed to know what was causing these errors so that adjustments could be made to prevent it from happening in the future.

The JMC Solution
We designed a database that communicated with the assembly line computers and logged each error. An interface was created that automatically sent the error code directly into the database which contained a description of each error code. Every time an error code occurred, the database automatically logged the type of error, date and time. A report was generated with a detailed description of what had occurred, and corrections were then made.

Initially this database was used to generate production reports, maintenance reports, failure analysis and conditional equipment status reports. It also provides a detailed graphical representation of production by types of errors for specific time periods. Armed with this data, a clear course of action was plotted to ensure that product output remained at optimal levels.

Prev 1 2 3 Next

Case Studies

This is one of those times where you can really get what you want. Don't settle for off-the-shelf database systems. Let Joseph Mauro Consulting develop a custom database that is designed to work for your company and, in particular, your business needs.

Below are samples of how JMC provided a cost-effective solution to their client's challenge. As you read through some of these examples, begin to think about what you would like to achieve in your company.

Are you responsible for a particular report that requires analysis of data to support your recommendation?

How are you keeping track of client and potential client contacts and follow up?

Do you have preferred vendor information in a central location for easy access by your staff?

Are you looking for a system that would eliminate replication of processes?

Do you need to streamline operations functions and reduce staff requirements?

Are you about to embark on a major direct mail campaign and need to track progress?

How are your purchase order and invoice tracking systems working?

Do you need an inventory control process?

Would it be less expensive to have custom forms, fax cover sheets, budget estimates and even letterhead as part of your database system instead of having them printed and then completing the forms by hand?
The bottom line is that if you have a challenge, I'll bet we have the solution.