quickbooks.jpg (29827 bytes)

20 Years of Customized Database Development

¨ FileMaker Databases for Mac or Windows
¨ Large or small projects, and consulting on existing databases
¨ Financial Information can be sent to QuickBooks

Click Here To View BioTech Development Information

Database Development at Boston University
¨Boston University Dept. of Physical Education, Recreation and Dance
    ¨ Developed a system to track Faculty payroll


¨
Boston University Marketing and Communications
    ¨ Developed a system to track yearbook purchases and import data from external sources.

¨ Boston University Center for Information and Systems Engineering
    ¨ Modified an existing database to restrict access to certain information based on their password.

¨
Boston University Department of Biomedical Engineering
    ¨ Developed a system to track applicant information for the "Translational Partnership Award from the Wallace H. Coulter Foundation".

¨
Boston University Media Group
    ¨ Developed a student scheduling system that manages the distribution of media equipment to classrooms
       throughout the university.  The system tracks the status of equipment, classrooms and prints daily student job sheets.

¨
Boston University Productions
    ¨ Developed a System to manage jobs (video productions, editing, etc.) and manage their vast on-site physical media library.

¨
School of Social Work
    ¨ Modified their existing databases (Admissions, Financial Aid, and Registration) to accept
       data from the University Information System (UIS) mainframe.

¨
Provost’s Office
    ¨ System to record new faculty, produce formal appointment letters from the President,
       report on information from the UIS system with regard to salary and contracts, tenure,
       leaves and sabaticals.

¨ Office of Sponsored Programs
    ¨ System to produce, manage and report on Grant Applications and Awards.

¨ College of Arts & Sciences Business Office
    ¨ System to record and report on budgets and expenditures.

¨ Graduate School of Arts & Sciences
    ¨ System to track graduate school applicant information and produce admission letters.

¨ Office of Technology Development 
    ¨ System to track patent disclosure information, manage budget and licensing information and
       produce government compliance documentation, the system is searchable at the OTT website for
       technologies that are available for licensing.

¨ Community Technology Fund
    ¨ System to track University venture capital investments.

¨ Athletic Department
    ¨ System to track tickets for hockey team.
    ¨ System to track equipment room inventory.
    ¨ System to record and report on budgets and expenditures.

¨ Physical Education Department
    ¨ System to record and report on budgets and expenditures.


Other Database Development Projects
¨ University of Massachusetts - Boston, MA
    ¨ Support of various database issues.

¨ Children's Hospital, Vascular Biology Program - Boston, MA
    ¨ Developed a system to manage grants.
    ¨ Developed a system to track purchase orders for the department.

¨ Developed a Customer Relations Management system to record incoming customer service
   calls and create form letter based emails to follow up with the customer and internal departments.

¨
YCN School Transportation, Norwood, MA
    ¨ Developed a system to track students, employees, drivers, schedules, vehicles, etc.

¨ Dartmouth Publishing, Inc., Sudbury, MA
    ¨ Developed a system to track jobs through production via barcode

¨ Appliance Store Sales & Service Point of Sale Program  http://home.comcast.net/~yogel/
    ¨ Point of Sale program used by over 80 Appliance Dealers
    ¨ Prints Customer receipts, delivery schedules, balance due reports, sales reports, tax reports, etc.
    ¨ Connects to QuickBooks.   Sends Invoice and Payment information to QuickBooks.

¨ The Boston Institute for Arts Therapy, Boston, MA
    ¨ Developed a Fundraising Donor database.

biat.jpg (497091 bytes)

 

¨ Wimbledon 109 Tennis Club, Walpole, MA
    ¨ Developed a scheduling system to record court usage, track members, dues, teams, etc.
    ¨ Developed the point of sale module for the Pro Shop, with upc barcode scanning and receipt printing.


¨
BioTech Purchase Order System
   ¨ System to create and track requisitions and purchase orders and provide critical financial information used to make purchasing decisions.
   ¨ Used by many startups to manage purchasing.
   ¨
Connects to QuickBooks.

poscreen.jpg (616235 bytes)

¨ Ariad Pharmaceuticals, Cambridge, MA
  
¨ System to record invention patent information.
   ¨
System to record corporate agreement information.

¨ Parametric Technology Corporation, Needham, MA
   ¨ System to produce vendor purchase orders.
   ¨ System to track customer software maintenance contract quotations and
      provide key analysis reporting for top level management.
   ¨ System to track invoices and budgets for legal department.

¨ Sedona Cultural Park, Sedona, AZ & North Dakota Museum of Art, Grand Forks, ND
   ¨ System to track donor address and donor information and produce correspondence.

¨ LNS Communications, Cambridge, MA
   ¨ System to track editorial opportunities for clients and produce briefing summaries.

wpe4.jpg (7174 bytes)  

¨ Barcoding
   ¨ I have done many barcode projects that allow the user to put barcodes on material,
       providing for quick recall.


For more information on FileMaker Pro Database Development, please contact me:

Bruce Yogel
51 Brookline Street
Needham, MA  02492
781-444-1054
yogel@comcast.net

Boston Massachusetts FileMaker Developer Consultant - Biotech purchasing - School Transportation information management database