J. R. Smoots Consulting

J. R. Smoots Consulting

MS Access / MS SQL Server database development

ארה"ב
פרילנסר

אודותינו

I've been developing for MS Access and MS SQL Server for over 20 years. Please see my LinkedIn profile/resume: https://www.linkedin.com/in/jeffrey-smoots-50727878/

I have experience developing complex Electronic Healthcare Record applications using MS Access as the Front End and MS SQL Server as the Back End. These apps included clinical notes, internal communication via a tasking system, document management (PDF files), and inventory control for durable medical equipment.

I've also created Tool Trackers, Job Estimators, and Purchase Order Trackers.

The code I write is simple, well documented, and easy to modify. I focus on creating applications that do their job quickly and efficiently. I believe the customer is best served by straightforward, no-nonsense programming.

I am US-based, residing just North of Seattle, Washington. I look forward to hearing from you and am happy to answer any questions you may have.

שפות

אנגלית
שפת אם

תחומי התמחות

תכנות ופיתוח תוכנה

152 ₪ לשעה
DB - MS Access
Twenty years' experience developing applications using Microsoft Access.
DB - MSSQL, SQL Server
Twelve years' experience using Microsoft SQL Server in a split front end / back end environment: Microsoft Access front end, Microsoft SQL Server back end.
VBA, Office, Excel Programming
Twenty years' experience using VBA, chiefly in MS Access. Also have used VBA in MS Word and MS Excel.

נסיון תעסוקתי

יולי 2005 - ספטמבר 2018

Information Systems Manager / Programmer

Sound Sleep Health , Seattle, WA
  • • Design, creation and implementation of a split Microsoft Access / SQL Server patient database application (Sounds Sleep Health EMR)
  • • Network maintenance (MS Windows environment)
  • • Maintenance of office computer systems (Desktop PCs, Laptops, Copiers, Point of Sale devices)
  • • Technical support, training for end users
  • • Office 365 maintenance
  • • Durable Medical Equipment inventory management
יוני 1995 - יוני 2005

Information Systems Manager / Programmer

Richard J. Pisani MD / Nexstep Medical Resources, Woodinville, WA
  • • Design, creation and implementation of a Microsoft Access patient database application (Sleep Apnea Manager)
  • • Technical support for users of retail version of Sleep Apnea Manager
  • • Network maintenance
  • • Implementation of computer-based patient scheduling
  • • Maintenance of office computer systems
  • • Computer training for office staff
  • • Clinical Research (via patient questionnaires, and data culled from patient electronic healthcare record)

תארים אקדמיים

ספטמבר 1991 - יולי 1995

Bachelor of Arts in Business Administration

University of Washington
ספטמבר 1988 - יוני 1991

Associate of Arts and Sciences in Business

Edmonds Community College

3 תחומי התמחות

152 ₪ לשעה

תכנות ופיתוח תוכנה

DB - MS Access DB - MSSQL, SQL Server VBA, Office, Excel Programming