Home Health Administrator

ROBERT (Bob) THOMAS

Home: 416-***-**** Email: **********@*********.**

System Support Specialist and Database Programmer/Administrator

PROFILE

Knowledgeable System/Network Administrator in MS WindowsStrong technical knowledge of PC servers and workstation both hardware and software.In-depth knowledge of the MS Sequel Server back-end for Sage Accpac system.Proficient VBA programmer in Microsoft Access database and Excel and SQL.

EMPLOYMENT HISTORY

Database Programmer/Analyst, End-User Support -- Fairmount Books Inc. 2003 - 2012

Converted the single-user database into a multi-user database interfacing with the Sage Accpac system. This enhanced the data extraction and report generation for multiple users.Developed many of the process calculation into nightly routines, therefore allowing for faster report generation during office hours. Established an automatic process for incorporating invoiced products into a formatted U.S. Customs document for broker/customs clearance. Designed and developed from end-user input the ability for the invoicing & shipping dept. to log and communicate via a ledger database.Maintained and ensured the efficient operation of the company network of servers and workstations through the setup and maintenance.

Programmer Analyst Shoppers Drug Mart 1999 -2002

Maintained the existing inventory, bookkeeping and inventory/rental asset management databases (Home Health Care Division) in the Microsoft Access and SQL. Created financial reports of daily transactions from the databases. Provided full technical support to system administrators in forty (40) stores using the developed MS Access databases and the MS-Windows environment, Microsoft Office Suite and Internet-Email.Designed and developed a database upgrade to generate customer statements. This automated the generation of the monthly customer statements thus reducing the time needed to produce manual information. It enabled the Store Administrators to focus on other critical tasks.

TRAINING & DEVELOPMENT

UNIX System Administration - ‘C’ Programming, Microsoft Access/SQL, Crystal Reports

Trios Centre, CanadaSQL Server 2005 - Database Setup and Administrator - Centennial College (Winter 2008).NET Visual Basic - Programming - Centennial College (Winter 2009)

Contact this candidate