Resume

Professional Summary

Detail-oriented and highly skilled IT professional with over 24 years of experience in database application development, IT support, and software training. Expert in designing, developing, and optimizing Microsoft Access and SQL Server database applications, with a strong proficiency in VBA programming, SQL query writing, and database administration. Experienced in setting up and configuring corporate networks and servers. Adept at conducting comprehensive training sessions on various Microsoft software, enhancing team productivity and technical fluency.

Experience

Freelance IT Consultant and Developer

Self Employed - Bradenton, FL October 2022 - Present

  • Completed work on several Microsoft Access applications including tables, queries, forms, reports, macros, and VBA code modules as well as custom Office ribbons and Access Add-ins.
  • Modernized the look and feel of several websites and improved SEO results for several clients.

Database Application Developer / IT Support / Software Trainer

Gulf Aerospace, Inc. - Oldsmar, FL November 1998 - October 2022

Database Application Roles

  • Developed, designed, tested, and delivered database applications to full production using Microsoft Access and SQL Server.
  • Optimized query performance through indexing, table normalization, and execution plans.
  • Created stored procedures and scalar functions in accordance with business logic.
  • Used VBA to automate sending emails directly from the database applications.
  • Used VBA to create automated functionality that integrated the database with Microsoft Word and Microsoft Excel including complex charts and graphs.
  • Used VBA to create automated functionality that would push reports and documents to a web server using FTP.

Networking & IT Support Roles

  • Setup corporate network including routers, managed switches, Ethernet cables, and Wi-Fi.
  • Configured corporate network including Active Directory, user groups, resource permissions, and database integration.
  • Setup virtual servers with four VM’s hosted on one physical server for load balancing between domain controllers, DNS, DHCP, file and printer sharing, database server, and internal web server.
  • Hardware support, including memory upgrades, and hardware replacement.

User Training Roles

  • Trained other employees on the use of Microsoft Windows, Word, Excel, Outlook, and the custom database applications that I created.

Software Trainer

ExecuTrain of Tampa. - Tampa, FL May 1996 - August 1998

  • Trained corporate students on the use of Microsoft Windows, Word, Excel, PowerPoint, Outlook, and Access.
  • Served as the lead trainer for Microsoft Access. Taught multi-day and multi-week courses.
  • Participated in morning and evening responsibilities of resetting training machines and preparing for the following day.
  • Participated in proofreading and updating training manuals and other printed materials.

Skills

Microsoft Software Skills

  • MS Access Front-end Development
  • MS SQL Server Back-end Development
  • MS Access Programming with VBA
  • SQL Query Building and Optimization
  • Stored Procedures, Scalar Functions
  • SQL Server Integration Services (SSIS)
  • SQL Server Reporting Services (SSRS)
  • Foundational Knowledge of C#
  • Foundational Knowledge of ASP.NET
  • Foundational Knowledge of Azure
    Cloud Resource and Services
  • Foundational Knowledge of Power BI

Web Software Skills

  • PHP, HTML, CSS, JavaScript
  • Web Application Development
  • MySQL, MariaDB, PostgreSQL
  • Laravel MVC Framework
  • Git Version Control
  • Agile Methodologies
  • AJAX, Fetch, JSON, XML, RESTful API
  • Foundational Knowledge of Python
  • Foundational of Java

Personal Interests

Website Design & Web Application Development

As a personal pursuit, I have created websites for a few small businesses and professional individuals. I have also created a few small database-driven web applications using the Laravel MVC framework. I am very familiar with PHP, HTML, CSS, and JavaScript. These projects have also given me experience with several relational database systems including MySQL, MariaDB, and PostgreSQL.

In addition to attending school and working as a freelance IT Consultant and Developer, this is how I have occupied my time since my position at Gulf Aerospace was outsourced in October of 2022.

Photography

I have been interested in photography since high school as a way of exploring my creative side. Keeping up with digital trends, I know the basics of Photoshop, video editing with Adobe Premiere Pro, and page layout with Adobe InDesign.

Education

State College of Florida - Bradenton, FL Currently Enrolled

Pursuing an A.S. degree in Computer Programming and Analysis.
Expected graduation in May 2026.

Certification

Microsoft Office Specialist - Access 2019 Expert December 22, 2023

verify.certiport.com KUan-uSRF
You can download my resume in a PDF format here.

Share This

Find Me

Copyright © 2024 John Osmond