18 Years of Customized Database Development

¨ FileMaker Databases for Mac or Windows
¨ Large or small projects, and consulting on existing databases

Database Development at Boston University
¨ Boston University College of Fine Arts
    ¨ Developed a system to track inquiries and applicants.  Print Letters & Labels
    ¨ Download data from the University Information System (UIS) mainframe

¨
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 Transfer      
Example: Click here and click the "Search" link
    ¨ 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

¨
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.

¨ 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.


¨
Ariad Pharmaceuticals, SPRL Pharmaceuticals, The Science Hotel, Cambridge, MA,
   Eyetech Pharmaceuticals, Woburn, MA, EnVivo Pharmaceuticals, Watertown, MA
   ¨ System to create and track requisitions and purchase orders and provide.
      critical financial information used to make purchasing decisions.

poscreen.jpg (616235 bytes)

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

¨ Lakeshirts, Detroit Lakes, MN & Mola Sport, Somersworth, NH  
   ¨ System to receive and track orders via email from the nationwide sales force and provide.
     reporting such as top designs, top styles, and top colors.

¨ 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.

¨ New England Satellite Systems, Shrewsbury, MA
   ¨ System to track customers, customer quotes and job scheduling.

¨ 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