Objective: Seeking an Application Analyst/Access Developer/VBA/SQL Server reports position.

Experience

Confidential

MS Access Programmer

• I am a volunteer in the volunteer department at the Shawnee Mission Hospital - a former employer. I have been a volunteer since 2005. I support all MS Access applications I developed for the volunteer department free of charge used to manage the 600 volunteers at the hospital. Although I currently do not have a full time job as an Access programmer/developer I do consider myself an active employee.
• I am and have been the principal IT/database support person in the Volunteer department at the Shawnee Mission Medical center in Shawnee Mission Kansas a suburb in the Kansas City Kansas and Kansas City Missouri area . I actively support all of the Access database applications I developed and created for the Volunteer department. My applications manage completely all scheduling and hours for some 600 volunteers for the hospital scheduling approximately 50 80 volunteers per day .
• I have been an active volunteer for the department since 2005. I donate all of my time for free to the department. I worked approximately 600 800 hours during year 2012 working on each of the database applications converting them from Access version 2003 to Access version 2007.
• I login daily through a VPN account from my home. I import all hours from corporate head quarters databases on servers in the IT department at SMMC Shawnee Mission Hospital using an import utility I developed.
• We recently calculated all hours for all volunteers for year 2012 using an Access application I created. This report is used for the annual Volunteer Awards Ceremony. It used to take weeks for the department to manually calculate and summarize all hours. My application now does the same thing in less than 2-3 minutes.
• I am willing to demo these applications during a face to face interview if required.

Confidential

MM System Analyst

• System analyst and technical and project implementation temporary support for the Pathways Materials Management application from version 11.0 to 15.0.
• Tested and converted 120 custom Access applications and reports used with the Pathways Materials Management PMM application in the Materials Management Department. SQL Server 2008 R2 is the database platform for PMM. All applications linked to the server via MDAC Microsoft ActiveX Data Objects via VBA and SQL scripting no linked tables .
• Developed eight new Access applications for process improvement used in conjunction with PMM Pathways Materials Management .
• Converted all custom Access applications to Office/Access 2007.
• Each Access application improved process improvement by enhancing or adding functionality to the PMM application. All of the Access applications saved hundreds of hours of labor in the department as a result.
• Developed a model to deploy all Access applications to a Citrix environment.
• Most applications allowed users to export to Excel via an interface within Access.
• Some applications were automated to run unattended without manual intervention 24 X 7.

Confidential

Application Support Analyst

Delivered application support to affiliate end users by troubleshooting applications and software for all internal users such as operations, development, and other business units. My role also assisted in the design, delivery, and improvement of software applications with training and related courseware.

Confidential

Access Programmer

• Supported existing custom Access applications and reports for various engineering groups.
• Developed new custom Access applications used for process improvement in the industrial engineering group. SQL Server 2005 was the database platform.

Confidential

MM System Analyst

• System analyst, technical and project implementation support for the Pathways Materials Management application.
• Created and developed approximately 50 custom Access applications and reports for the Pathways Materials Management application in the Materials Management Department. Microsoft SQL Server 2005 is the DBMS for this application. Several of these applications monitored the Item Master table for pricing accuracy.
• Supported Access programming development and support for approximately 100 existing MS Access database applications in the Materials Management department.
• Performed electronic price change updates into the Item Master in PMM over 35,000 year 2007 . As a result of electronic updates accuracy in the item master table was reduced significantly.

Confidential

Sr. Analyst

• System analyst, technical and project implementation support for eClublogic, Contract Management, Riskmaster, Procare, ESC and other health care applications.
• Supported and developed custom reports for AskANurse, Quality Management, Incident Reporting and Materials Management. The DBMS for these applications included MS SQL Server and MS Access.
• Supported programming development and support for new Access applications in addition to approximately 35 existing MS Access database applications within the SMMC organization.

Confidential

Sr. Programmer Analyst

• Technical and project implementation support for Karch International software for Saint Luke's fitness centers, Midas, RalsPlus and other health care applications.
• Supported and developed custom reports for Kronos Timekeeping systems, Picis Anesthesia Critical Care Suite, and Karch International fitness center software. DBMS for these applications included MS SQL Server, Sybase, Oracle and MS Access 2.0, 7.0, and 8.0.
• Supported programming development and support for new and existing MS Access database applications within the Saint Luke's organization.

Confidential

Programmer Analyst

• Provided programming development and support for new and existing MS Access database applications in Estimating group.
• Computer Liaison and MS Office applications user support for Project Services groups.