Adrian McGilly, Information Systems Consultant
Is FileMaker driving you crazy? Is MS Access holding your data hostage? Are Oracle's fees breaking the bank? Is your custom .NET solution refusing to cooperate? Are you months behind on your web services initiative? Still doing everything on paper and Excel?
Whether you've got data scattered in multiple databases, reports you desperately need but can't get, or forms and data that need to be put securely on the web, I can help.
Services
  • Servoy solution design and development
  • Servoy training classes & one-on-one coaching
  • Business process modeling and management (BPM)
  • Technical writing
Technical capabilities
Servoy logo Omnis logoUltimus logo
Recent projects & clients

On-site Servoy Training:

    • Harcourt Group
      Austin, TX - website
    • Century Marketing Group
      Bowling Green, OH - website
    • American Health Group
      Maumee, OH - website

Servoy Consulting Projects:

    • American Trash Management (ATM)
      San Francisco, CA - website

      I developed ATM's SmartTrash Data Center which gathers telemetry data from a worldwide network of industrial trash compactor monitoring systems over a wireless IP network and presents this data to managers to inform day-to-day operations.
    • Home Health Digital Services (HHDS)
      Sarasota, FL - website

      I am assisting with a complete re-write of a multi-company patient services management system from FileMaker to Servoy.

Other Development Projects:

    • Canadian Government Client-server corporate directory for Dept of Natural Resources. Client-server project management tool for the Topgraphical Information Center.
    • Ernst & Young LLP Analysis and functional spec for a time-billing system used by Legal department.
    • Oregon Health Sciences University Analysis and system specifications for an accounts-receivable system used by the School of Dentistry.
    • Ross Systems, Inc Enhancement/conversion of Renaissance HR application from an English-only user interface to a UI capable of supporting many languages, initially French.
    • Bombardier, Inc Development and analysis for a number of mission-critical enterprise systems including financial, manufacturing and asset management.
    • University of Arizona Development of a mission-critical application for Emergency Medicine, used to gather patient information on an ambulance-based laptop in the field.
Servoy Beginner's Handbook
New to Servoy? I've compiled some of my best experience in getting started with Servoy into an easy-to-read 130-page guide. Updated for Servoy v3.5 (and still very relevant to 4.0). Preview it for FREE online or download the full PDF version for $49.

See comments from readers.

Upcoming training

I regularly offer 12-hour (4 half-days) online Servoy Quickstart and Servoy Intermediate training sessions, open to the public. Offered live via WebEx. Attendance is limited.

Upcoming class schedule (2008):

  • QuickStart: April 21 - 24
  • Intermediate: May 5 - 8
  • QuickStart: July 7 - 10
  • Intermediate: July 22 - 25

See feedback from past students.

To register, send an email indicating which class(es) you are interested in. I am also available for private online training classes.

Naming Conventions - when developing in Servoy, you'll be doing yourself and others a favor if you follow a naming convention and document your code clearly. Here are the conventions I follow.

Security Module - this article I wrote for Servoy Magazine discusses how to customize the security system of a Servoy solution, and includes a free module which automatically adds custom security features to any solution, and which you can easily customize further.

Global Dataproviders - here is an article I wrote for Servoy Magazine about strategies for cutting down on the number of global dataproviders required in your Servoy solutions. Includes a free module that enables you to create 'formvars'

How to contact me

Please contact me if you have questions, or if you think I might be able to help you:
Telephone (510) 428-1035
Fax (510) 655-2093
Email info@mcgilly.com
Address:
1685 34th Street, Oakland, CA 94608
More about me
I've been working in technology for more than 15 years. I have created dozens of custom database apps -- analysis, coding, testing, documentation and user training.
As head of McGilly Information Systems (1990-2000) I led a team of 18 IT professionals and two administrative staff. As Director of Operations for the Professional Services division of Versata, Inc. I implemented systems, policies and procedures to maximize the productivity of a 100-consultant organization.
I have delivered more than 1500 hours of classroom-based training on technical topics. Clients have included NASA, General Electric, Hughes Aircraft and the Canadian Government.
I have written technical articles, system specs, proposals, user guides, development standards, marketing pieces and policy handbooks.
I live in the San Francisco Bay Area with my wife and two daughters.

Products
Omnis Datafile Repair Wizard Developed this product and sold more than 200 copies. Used for administering and repairing databases. Product info
Articles
Cascading Valuelists Without Any Coding, Servoy Magazine [www.servoymagazine.com], April 2006.
Strategies for Cutting Down on Global Dataproviders in Servoy Solutions
Servoy Magazine, Sept. 2007

Real World XML, The Ragged Left [Society for Technical Communication], May 2005.

Servoy Naming Conventions,
[Self-published] Feb. 2007.
Education
BS Mathematics and Computer Science,
McGill University, Montreal, 1990.



















Copyright © 2006 Adrian McGilly. Design BLR