Warren RI *****
Cell: 401-***-****
acw8ix@r.postjobfree.com
Mark Smiley
Objective
To obtain a position where I can utilize my creative problem solving skills in definition, design, programming, testing, implementation, training, and long-term support of software related projects.
Experience
2015 – Present Discover Solutions Warren, RI
Lead Consultant Owner
Retrofitted MS Access based process manufacturing system written for Monogram Metals in mid 90’s. This system handles purchasing, shipping, and manufacturing for a small manufacture. Upgraded front end from MS Access 97 to 2013, replaced back end with SQL Server 2008. Integrated with Bartender Barcode labeling software.
Created a new process manufacturing system for AFC Cable Systems. This system handles raw material expenditure, processing, and finished good reporting as well as labeling. MS Access 2013 Front end, SQL Server 2008 backend.
Developed CommonSenseRI.org using Microsoft Azure, SQL Server, and VB.NET. CommonSenseRI.org is a public access TV show that I also am the Executive Director of.
2001- 2015 Insight Health Solutions Inc. E. Providence, RI
Senior Developer and Data Architect
Oversaw and was lead developer in the needs analysis, design, development, implementation, training, and support of 8 commercially sold software systems related to Quality Improvement Management within the healthcare industry.
PerformanceInsight – This system is designed to allow hospital to store and track their performance using Statistical Process Control (SPC) theories and practices.
Version 1 was developed in MS Access 97 & 2000, Visual Basic 6.
Version 2 was developed in Visual Studio 2005 .NET., ASP.NET, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
StudyInsight – This system was designed to capture and report a wide range of data involving Medical Record Abstraction within a hospital.
Version 1 was developed in SQL Server 7-2000, Visual Basic 6 (COM+) & ASP.
Version 2 was developed in Visual Studio 2005 .NET., ASP.NET, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
CaseInsight – This system was designed to capture and track data regarding the Peer Review Process within a hospital.
Version 1 was developed in SQL Server 7-2000, Visual Basic 6 (COM+) ASP, & JavaScript. Reporting done in HTML
Version 2 was developed in Visual Studio 2005 .NET., ASP.NET, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
OccurrenceInsight – This system was designed to capture Risk Event Reports from anywhere within a hospital and then track follow-up to those reports.
Version 1 was developed in SQL Server 2000, Visual Basic 6 (COM+), ASP & JavaScript, Reporting done in MS Access and Crystal Reports.
Version 2 was developed in Visual Studio 2005 .NET., ASP.NET, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
ReappointmentInsight – This system was designed to “snapshot” data from multiple sources in regards to the performance of a physician within the hospital.
Version 1 was developed in SQL Server 7-2000, Visual Basic 6 (COM+), ASP, & JavaScript, Reporting done in HTML.
Version 2 was developed in Visual Studio 2005 .NET., Windows Forms, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
HL7 Data Warehouse – This system was designed to capture HL7 ADT and other transactions and warehouse that data for use within the above systems and allow customers to develop custom reports.
Version 1 was developed in SQL Server 7-2000, Visual Basic 6 (COM+) including Winsock support.
Version 2 was developed in Visual Studio 2005 .NET., and SQL Server 2000/2005/2008.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
CoreInsight – This system was designed to allow for the capture of Core Measures data and report it to CMS and The Joint Commission.
Version 2 was developed in Visual Studio 2005 .NET., ASP.NET, and SQL Server 2000/2005/2008. Reporting was developed using SQL Server Reporting Services.
Version 2.5 Upgraded to Visual Studio 2010 and SQL Server 2008
ResearchInsight – This system was developed to capture large quantities of text data and index the words for recall by a research department looking for exams that qualify for a specific project.
Data is fed to the system using HL7.
Was developed in Visual Studio .NET (Visual Basic), ASP.NET and Oracle 11g.
Other Accomplishments & Responsibilities
Hired and supervised 4 programmer/developers/report writers.
Built corporate wireless LAN/WAN including a TowerStream, a DMZ, web servers (Dell), laptops & desktop PC’s. Windows 2000
Consultant to Newport, Miriam Hospital & AFC Cable Systems
Email administrator
2000-2001 MerrillClark, Inc. Providence, RI
Senior Software Engineer
Member of Insight Health Solutions “spin-off” team.
Developed the prototype of PerformanceInsight 1.
Prepared PerformanceInsight 1 for commercial release.
Member of the development platform selection team.
Developed upgrade for Vector Healthcare System
Upgraded VB 3 16 bit, C, and Oracle 7.2 to VB 6 (32 bit), C, Oracle 8i.
1998-2000 Lifespan Providence, RI
Senior Applications Analyst
Developed, implemented, and maintained the corporate Administrative Data Warehouse (ADR).
This system was is an Oracle 8i data warehouse utilizing PL/SQL and Visual Basic 6.
Developed, implemented, and maintained the corporate Patient Satisfaction Survey System.
The system was is an Oracle 8i, MS Access and Visual Basic 6 System. Utilized the ADR patient demographic data.
Developed and implemented the FTC Reporting System – This was s specialized data warehouse that allowed Lifespan to develop and report according to the Federal Trade Commission requirement to supply data for the merger of Lifespan & Care New England Hospital Systems.
Developed, implemented, and supported many (in excess of 10) small MS Access workgroup databases.
1998 John Hancock Funds Boston MA
Consultant/contractor
Maintained 2 systems utilizing MS Access, Visual Basic 6, and SQL Server 6.5
1998 Royal Ahold, Inc (Stop & Shop) Quincy MA
Consultant/contractor
Member of a team that developed a MS Access based reporting system for the Pyramid Risk Management System.
1996 - 1998 AFC Cable Systems New Bedford MA
Consultant/contractor
Developed, implemented, and maintained the Production & Quality Control Reporting System for 6 production facilities nationwide.
This system was developed in MS Access 95-97. This system was upgraded to MS Access 2000 and greatly expanded upon in 2001 & 2002. (See Insight Health Solutions)
Developed, implemented, and maintained a Process Control & MRP System for a small Slit Steel Manufacturing Operation. (Monogram Metals)
This system utilizes MS Access, Visual Basic 6, PLC Ladder Logic communications, integrated bar code scanners, bar code printers, and touch screens.
Developed and maintained a system that communicated testing procedures to a robotic wire testing machine.
This system utilized MS Access, PLC ladder logic communications and bar code scanners.
1995-1996 Perry Blackburn, Inc Pawtucket RI
MIS Manager
Developed and maintained multiple MS Access and MS Excel application.
Built LAN – Windows 3.1 peer to peer network
1995-1996 Aquidneck Business Solutions Portsmouth, RI
Owner/consultant
Owned and operated a VAR operation that specialized in selling and implementing Microbiz POS Cash Register Systems.
These systems used Microbiz Software, Visual Foxpro, MS Dos 5-6, and Peer-to-Peer and/or Novell Servers.
1989-1992 Minuteman Press of Newport Newport, RI
President
Owned and operated a small franchised offset printing business.
Education
VB.NET Lost Weekend Certificate (2002)
Introductory and advanced Crystal Reports 7.0 Certificate (2000)
Oracle 8i Introduction to Oracle for Experienced SQL Users Certificate (1999)
Oracle 8i PL/SQL Units Certificate (1999)
Oracle 8i Database Administration Certificate (1999)
Oracle 8i Backup and Recovery Workshop Certificate (1999)
Oracle 8i Network Administration (1999)
Computer Information Systems Certificate Program, Bryant College (1996)
High School Diploma, Portsmouth High School (1983)