Build Customized HR Database
PROJECT OBJECTIVE:
Client required a database to manage applicants and projects for a Human Resources temp agency. They had previously contracted with another developer who had left some of the functionality out of the project, rendering it unusable.
SOLUTION:
We reviewed the existing code in the database, and developed a plan to improve and fix the database. We were able to reuse some of the existing code in the application, saving the client time and cost over a complete rewrite. This application has now been in use for over 10 years, and helps the client better manage their business.
Develop Manufacturing Tracking Database
PROJECT OBJECTIVE:
Our client had contracted with management consultants to improve their manufacturing processes and efficiencies. Due to incompatibilities with their existing mainframe system, they were unable to develop an application that would track key performance indicators in a timely manner.
SOLUTION:
We developed a customized data-entry and reporting application that allowed users to enter end-of-shift performance information into a centralized database, allowing supervisors and managers to view performance data the same day. This system helped the company improve their manufacturing processes, saving them significant amounts of money.
Create Customized Reporting Solution
PROJECT OBJECTIVE:
Our client required data reports output in formats not supported by their ERP software system. They required reports to track sales by industry category, and contacted us for assistance.
PROJECT SOLUTION:
After initial consulting and planning sessions, we created a database framework in Microsoft Access to automate the import and categorization of sales information downloaded from the ERP system. We created customized reports that were able to run in batch mode for easy management, as well as outputting the data into Excel spreadsheets, complete with formulas, to allow the sales force to run additional analyses.