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 involved 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 in Western New York and created some of the first web pages in Western NY, including the Buffalo Bisons, Buffalo Sabres, Delaware North Kennedy Space Center, MJ Peterson Realty, and 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 consulted and provided training for:

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

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, the Department of Library Science, and the Department of Computational and Data-Enabled Science and Engineering at the University at Buffalo since 1988. Some of my courses include:

I've been teaching for Computer information Systems Department at Buffalo State College since 2014. Some of my courses include:

I have also taught Computer Literacy and Information Technology for Trocaire College and Beginning and Advanced Web Design for Niagara County Community College.

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
  • HTML/CSS - Basic, Advanced
  • Database Design/Concepts
  • 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:

  • HTML/CSS - Basic, Advanced
  • Database Design/Concepts
  • 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