About

Jim Gerland

Jim Gerland, Owner

I formed Gerland LLC as a DBA for my contract training and consulting work. I've been providing consulting and training on software applications since 1984 when I began my career at the University at Buffalo. While growing my experience there as a mainframe/mini computer consultant I started teaching the Millard Fillmore College teaching BASIC Programming, Microcomputer Applications, Intro to the Internet, Database Design, Systems Analysis & Design, and Web Design. In the early 1990s I was lucky enough to be invovled in the national nascient Internet scene which provided an opportunity for my colleague, Mark Winer, and I to form After Five Technology in 1993. After Five was the first web hosting and design company and created some of the first web pages in Western NY (Buffalo Sabres, Delaware North Kennedy Space Center), MJ Peterson Realty, WBEN, WGRQ, WHTT radio stations, just to name a few. In 1993 I also co-founded the Buffalo Free-Net with Dr. Neil Yerkey (University at Buffalo) and Jim Finnamore (Town of Tonawanda) which initially provided free dial-up services (courtesy of the University at Buffalo) for Western New Yorkers and free web hosting for local and regional non-profits organizations and government entities.

Applications

Here is a list of some the applications I provide training on:

  • Adobe Acrobat - Basic, Forms, Data Collecction
  • Crystal Reports - Basic, Intermediate
  • CSS 2/3 - Basic, Intermediate
  • Database Design/Concepts
  • HTML 4/5 - Basic, Intermediate
  • JavaScript - Basic, Intermediate
  • Microsoft Access - Basic, Intermediate, Advanced (VBA)
  • Microsoft Excel - Basic, Intermediaate, Advanced, VBA, Pivot Tables
  • Microsoft PowerPoint - Basic, Intermediate
  • Microsoft Project - Basic, Intermediate
  • Microsoft Visio - Basic, Intermediate
  • Microsoft Word - Basic, Intermediate
  • Minitab
  • SQL - Fundamentals, Advanced Querying, Toad, MSSQL
  • Web Design - PHP/MySQL

Consulting

Here is a list of some the clients and areas I have consult for:

  • Avox Systems (Excel Pivot Tables/Lookup Funcitons)
  • Catholic Medical Partners (Visio)
  • Certo Bros (MS Outlook)
  • D’Youville College (Office 2007)
  • Independent Health (Oracle/SQL, Visio)
  • Ivoclar Vivadent (Visio)
  • JW Danforth (Office 2007)
  • Purina Foods (Minitab – Six Sigma)
  • Roswell Park Cancer Institute (Access Advanced)
  • Tops Markets (Excel Pivot Tables)
  • Welch Foods (Oracle/SQL)
  • WNYLRC (HTML, CSS, & JavaScript)

Database

Here is a list of my database related consulting and training:

  • Crystal Reports - Basic, Intermediate
  • Database Design/Concepts
  • Microsoft Access - Basic, Intermediate, Advanced (VBA)
  • SQL - Fundamentals, Advanced Querying, Toad, MSSQL
  • Web Design - PHP/MySQL

Teaching

I've been teaching for Millard Fillmore College, the Computer Science Department, and the Department of Library Science (University at Buffalo) since the mid-1980s. I also teach Computer Literacy for Trocaire College. Some of my courses include:

Training

Here is a list of the applications I have consulted or providing training on:

  • Adobe Acrobat - Basic, Forms, Data Collecction
  • Crystal Reports - Basic, Intermediate
  • CSS 2/3 - Basic, Intermediate
  • Database Design/Concepts
  • HTML 4/5 - Basic, Intermediate
  • JavaScript - Basic, Intermediate
  • Microsoft Access - Basic, Intermediate, Advanced (VBA)
  • Microsoft Excel - Basic, Intermediaate, Advanced, VBA, Pivot Tables
  • Microsoft PowerPoint - Basic, Intermediate
  • Microsoft Project - Basic, Intermediate
  • Microsoft Visio - Basic, Intermediate
  • Microsoft Word - Basic, Intermediate
  • Minitab
  • SQL - Fundamentals, Advanced Querying, Toad, MSSQL
  • Web Design - PHP/MySQL

Web Design

I've been teaching Web Design for Millard Fillmore College (University at Buffalo) since the mid-1990s, including:

  • CSS 2/3 - Basic, Intermediate
  • Database Design/Concepts
  • HTML 4/5 - Basic, Intermediate
  • JavaScript - Basic, Intermediate
  • SQL - Fundamentals, Advanced Querying, Toad, MSSQL
  • Web Design - PHP/MySQL, ASP/MSSQL, PERL/MySQL

Some of the web sites I've been involved with:

Contact Me

* Indicates a Required Field