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
  • Business process modeling (BPM)
  • Technical writing
Technical capabilities
Omnis 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 168-page guide.

FREE Preview (PDF)      Comments from Readers

Purchase the full Handbook (PDF) for US$49

Purchase entitles you to free updates of the handbook for 18 months.

Upcoming training

The following online classes are available:

Servoy Quickstart

Servoy Intermediate

No live classes are scheduled at this time. Live recordings of these classes are available for $395 each. This price includes one half-hour of live Q&A with Adrian McGilly. Email for details.

Private training sessions are also available upon request.

See feedback from past students.

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


Speaking Engagements
Sept. 2009 - Presenter at Servoy Virtual User's Group Meeting - topic: performance enhancement in Servoy/Sybase SQL Anywhere

Sept. 2008 - Speaker at the ServoyWorld 2008 Servoy developer's conference in Las Vegas, presenting a case study of the work I had done to date for American Trash Management Inc.

Sept. 2007 - Presenter at Servoy Virtual User's Group Meeting - topic: customizing security in your Servoy solutions.
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