Top bar


 Home --> Programming --> Projects

Programming Projects

Sales: 800-355-9855

Back

Home

About Us

Training Catalog

Contact Us

Summary of programming projects worked on...

Request a free programming or consulting quote

Below is a summary of some of the programming projects we have worked on in recent years. (Updates will be issued over time.) Most work has been done in Laguna Niguel, California and/or onsite. However, we often work with an offshore partner to reduce overall project costs.

BackTop

Real Estate Loan Documents Management (Laguna Hills, CA)
Industry: Financial Services

 

Designed and implemented an entirely new intranet-based system to track loan documents. System uses Microsoft SQL Sever and IIS running on a local windows server. Web scripting is handled by PHP and jQuery. Modules include management, new document review with Excel data upload, and administration including user management and reports. There are also modules for updating loan review documents, quality assurance and analytics.

 

Medical Supplies Distributor (Lake Forest, CA)
Industry: Medical Services

Updated reporting capabilities of a multi-user Microsoft Access database used by legal department to track litigation. Reports include open matters and year end summaries.

 

Insurance Agency (Corona Del Mar, CA)
Industry: Financial Services

This multi-user Microsoft Access project implemented a leads tracking and bonus reporting system. It uses a shared backend database on the office server. Reports include applications, leads, bonuses and contacts.

 

Bond Trading Firm (Corona Del Mar, CA)
Industry: Financial Services

This Microsoft Access project implemented a business intelligence front end to the existing trades database. The trades database recorded information on all bond and equity trades the firm placed. Reports provided included trade blotters, daily sales, trade recaps, settlement spreadsheets and many other.

In a subsequent project the data was moved into a SQL Server back end database using views and pass-through queries. This resulted in increased stability and substantial performance improvement.

 

Industrial Products (Lake Forest, CA)
Industry: Manufacturing

This application was created for the marketing department of a major manufacturer of tankless water heaters. The database tracks demographic information by plumber, distributor and sales representative. Drill down forms and graphs were provided by each of the above categories showing performance by goal area.

 

Telecommunications Support (Laguna Niguel, CA)
Industry: Construction

This Microsoft Access database basically maintains the information of employee, functions, equipments, jobs and invoices for a firm laying underground communications lines. Reports are available for weekly sales, weekly time log, and invoices. Along with the same the database has statistical reports based on employee, function and equipments.

 

National Homebuilder (Corona, CA)
Industry: Construction

This construction management database contains information related to community, phase, supplier, labor etc. There are several forms (such as maintaining Temp Labor, Purchase Order, and Inspection Cycle Time etc) and reports (such as Cost, Labor, Test Listing, Purchase Order, Preview, Delivery items etc.) available in the application. There are several Charts used to fulfill some specific presentation requirements. Also users can export (or import) data to (or from) Excel spreadsheets.

 

ClassWare Web ERP (Laguna Niguel, CA)
Industry: Education

Php/MySQL web application for private schools. Maintains information on students, vendors, classes, courses, time charges, etc. Information is captured directly from web forms and placed in a MySQL database on the web in real time. Numerous reports available. System runs on a Linux/Unix server and is available through any standard web browser. No installation required. Beta release but in production use.

 

 

Laboratory Testing (Culver City, CA)
Industry: Medical Services

This was an object-oriented Middle Tier application written in Visual Foxpro. It collected information from legacy FoxPro databases and normalized it The data was then applied to a SQL Server database in near real time. This allowed users to see test results over the web.

 

 

Psychiatric Services for Youths (Long Beach, CA)
Industry: Medical Services

This medical database has been designed to keep track of the all the processes that are followed for providing psychiatric services to youths and children. It maintains the information related to staff, team, position, training, client (agency), guardian, referral contacts, discharge, funding, diagnosis, relationship. We did the original design and implementation and have subsequently worked on several forms and reports.

 

 

Independent Software Vendor (Coto de Caza, CA)
Industry: Legal Software

Worked with team that developed a retail Visual FoxPro database for use by law firms. Comprehensive application including forms, reports and help documentation. Application fetured flexible relationships between attorneys, judges, jurisdictions, witnesses, etc.

 

 

Related Services

Need quick, convenient training for yourself or your organization? We also provide custom on-site training for groups and individual training at our facility in San Juan Capistrano. Contact us @ 800-355-9855 for more information or request a quote.

Orange Coast Database Associates Page Footer


Programming & Consulting | Inquiries & Quotes | Orders | Enroll | Referral Program | Privacy Statement | Contact Information | FAQ'sSite Map | BackHome | Top