Industry Projects

PROACE has the experience necessary to bring your industry specific project to successful implementation. The following is our current industry portfolio.

Business Services : Process Improvement and System Upsize

Research business conditions and recommend business improvements to increase revenues and overall process efficiency. Upsize outdated access database to SQL Server. Implement reporting tools to help operation management. Put safety measures in place to ensure data integrity.

Retail: Process Automation

Design database integration as part of business transition to information technology. Eliminated manual paper-based system of account keeping by implementing software that automates entire process. Create a data-warehouse, accessible via the web, that stores, updates, and analyzes the ground level data in order to keep pace with regional and national competition. Develop reporting tools to help improve sales forecast. Implement login processes for a web applications that restrict scope of access based on the level of security of the user’s ID.

Healthcare: Business Development

Design database system to support personnel and patients of psychiatric clinics; the application’s main functions include claim processing, scheduling, and prescription/refill processing. Developed test scripts to confirm data integrity. Implement a friendly Graphical User Interface to help operate system.

Public Sector: Application Development, Home Land Security

Develop a maintenance suite allowing secure access and manipulation rights to a data warehouse. Configured a purge process to filter and remove obsolete data from the database. Developed a data archiving system to backup data triggered by users.

Transportation: Airline Scheduling

Design back-end database to house data for all flights, reservations, customers, employees, and statistics. VB front end interface for management's control of flights, reporting tools, airfare, promotions, employees, and payroll. Real time web site integration for customer reservations and vacation planning.

Financial: Stock Market Trading, _Oracle

Oracle database holds financial trading information for stock prices, stock history, and individual stock portfolios. Web front end, via PL/SQL object control, for customer trading. Buy or sell using options and margins. Keep track of specific account details with daily account emails updates. Break down of specific tax consequences based on financial gain or loss.