Iqzero.net - software for a diverse range of businesses -

IQZero.net

Custom Software for a diverse range of businesses
Jonathan Galpin, BS., MCSD, GSSP-Net, GSEC, GPEN

Past/Current Software I have Written
+
Systems Administration Tasks Completed

View my IT credentials here.

Type of Software	Industry	Description
.Net Service Backend	Medical	Built a .net service in c#, designed to securely connect to the pdfQuick web-service to download patient documents and print them internally to a medical practice. Two components, a service and a configuration gui.
Web App LAMP (Linux, Apache, MYSQL, PHP) + Amazons Elastic Beanstalk + RDS	Medical	Built a secure, scalable cloud based application using the Amazon Cloud: Elastic Beanstalk, RDS (Relational Database Services), Load Balancers. Application was designed to be secure in a HIPAA field. It also uses the headless browser wkhtmltopdf rendering engine, and intergrates with the Greenway Medical Technologies API. PDFQuick, Greenway Marketplace.
Adobe Air + Adobe Flex + PHP + MYSQL	Employment Profiling	Worked with six developers on an air/flex app to replace a legacy system. The application has an Adobe flex desktop client, a web based client Adobe air interface and other web facing systems. Server side logic is via php and MYSQL.
CRM Web App	Insurance	Worked on a custom insurance industry web application using LAMP and the codeigniter framework. Siginificant redesigns to encrypt PII data, revamped the logon system for security, and hundreds of misc system changes and fixes.
Backend	Medical	This application takes Electro Cardiogram Images (ECG's) from two mobile ECG machines and imports them into an electronic medical records system. This task is perfomed every minute, saving staff from having to do this manually. PHP, Bash Scripting, Linux.
Web App	Medical	Wrote a web application to notify staff of the number of voicemails waiting to be heard from a particular voice mail box. The object oriented design in PHP allows it to be re-used for any particular extension.
Web App	Medical	Wrote a web application to interface with a phone system to answer an age old problem: In a large office, many people make outgoing calls and the phone system (Asterisk) usually presents one telephone number to the recipients of the calls. So when someone sees that a call came from a number and calls back, the question is...who out of perhaps forty people called this number....usually the receptionist has no idea. With this web app, by supplying the phone number, the system will tell you which extension called that number and when.
Backend	Misc	Set up a MySQL Cluster in a development environment. Ported over eighty MSSQL stored procedures to MySQL.
Backend	Misc	Set up an open source Mantis/SVN server combination. This provides revision control and project management services to a programming team.
Backend	Misc	Set up an open source SSL VPN server. The purpose is to provide a port 433 and browser based VPN so that any hospital constrained pc can be used to gain secure access to office based resources. Provides browser based remote desktop, web applications and various tunnel functionality.
GUI	Misc	Wrote an application in C. sharp for an educational institution that takes a SCORM XML file, produces an object oriented topology of the exam including an exam object, a section object, a question object, and answer objects. An HTML page is created with the questions being randomized with particular rules on the number of questions mandatory questions etc. being followed. Allows the creation of varying exams from the same base questions.
Backend	Misc	Wrote an application in C. sharp to spider and scrape data from 7000 odd webpages.
Backend	Medical	Wrote an application in C. sharp (c#) to monitor particular processes on the server of the PrimeSuite practice management system from Greenway Medical Technologies. This application corrects a problem before it begins. About 25 times a year printing of encounter forms and other important functions stop (or they print black) and IT or Greenway have to be called in. This automatically solves that problem.
Backend	Medical	Physician Procedure CPT Comparison Summary Report. For all physicians (techs etc selected), the report compares the number of times each procedure (cpt code) has been performed and then combines this with the RVU value per procedure within the time frame selected. Allows a practice to objectively compare the performance of their providers and other tech resources. The report is concise, summarized and can be displayed through charts / graphs. Based on data from the PrimeSuite practice management system from Greenway Medical Technologies. VB, automates Excel.
Backend	Medical	Procedure Productivity Report This report provides a summary by month and with totals and averages of the number of times every procedure or CPT code has been performed within a particular time frame. The user can use the procedure date or the posted date and display alternative procedure codes and the procedure descriptions. The user can choose whether to include zero service charge procedures. It allows a medical practice to have a birds eye view of their productivity through the procedures that they perform. The data comes from the PrimeSuite practice management system EMR from Greenway Medical Technologies. VB, automates Excel.
Backend	Medical	Created a report to detail Echo's to Cath's for compliance reporting with data being gathered from Greenway Medical Technologies PrimeSuite practice management software. Also produces reports on Echo to Nuclear's, Nuclear to Cath and Echo + Nuclear then to Cath. VB, automates Excel.
Backend	Medical	Provided management with web based reports to compare the total phone calls made per extension, the total call minutes of the calls and averages over certain time periods.
Backend	Medical	Wrote software to call medical practice patients to inform/remind them of their upcoming appointment. Provides management with a real time web interface to monitor current calls, and calls that need human followup, allows transferring of patients to the needed staff. Allows staff one click patient calling (click within a web-browser, and your desk phone rings with the patient on the line). Emails a daily report to staff, fully automatic, no staff work required to have the daily calls operate) replaces phone tree (phonetree) which in our testing failed to detect answering machines and leave adequate messages in this instance. Intefaces with Greenway Medical Technologies PrimeSuite practice management software. The message can be modified by dialing an extension of the phone system. Under normal circumstances, the staff would need to perform certain functions within PrimeSuite to produce the list of patients to call. This reduces the staff workload. The system allows test calls to any phone number to check it's operation.
Backend	Medical	Set up a Qmail, Linux based email server.
Backend/Web App	Service	Contractor payment system. Developed using extensive ajax. Includes modules for inventory invoices, work orders, contract changes, summary of all contractor fiscal and operational details. Pdf invoices, php OOP, MSSQL.
Backend	Medical	Set up, run, maintain VMWARE server (virtual machines) systems to recapture hardware etc. Also ESX4 based systems.
Backend	Medical	Open-source VPN/firewall based on linux and pcCop.
Backend	Medical	Custom failover phone system. Linux based Asterisk, alongside fax system based on IAX modem and Hylafax. Open-source.
Backend	Medical	Integration: adding various interoperability functions between an existing Medical Manager system and a new practice management system, PrimeSuite from Greenway Medical Technologies.
Backend/Web App	Service	Wrote a customer service email application to receive, manage, reply, archive and notify staff of any customer issues received via email.
Backend	Medical	Designed, purchased and set up an open-source LAMP based backup system. Using Linux, a Dell server, an MD1000 SAN storage device, and backupPC on an encrypted file system. Backs up many many servers and machines using a grandfather, father, son routine. All open-source software.
Web App	Service	Created a google map application showing the customer locations, and when needed, overlaying this with the independent contractor locations. This can be displayed on a district, regional or national level. Assists in pairing up customers with local contractors.
Backend	Service	Created a daily emailed report updating management of time sensitive, missing contractor information, district information sent to the district manager, consolidated for each regional and national manager, and further consolidated for human resources.
Backend	Real Estate	Created an email system to warn agents when their listings expire. Daily, specifying expirys that day, the next seven, fourteen and thirty days. Allows brokerage to not "lose" their investment in signs etc and to manage their listings better.
Backend	Medical	Nuclear imaging file importer. Wrote apps and set up systems to "Pre Load" nuclear images for physicians every minute.
Backend	Medical	Linux hearbeat. Set up failover MYSQL servers. Wrote bash, php and sql applications to import and massage certain data. Ported various windows apps to this LAMP environment. Automatic creation and printing of patient pdf appointment documents. Amongst other apps. Command line PHP.
Backend/Web App	Real Estate	Created an email alert system to provide early notification to the public about new listings in the brokerage based on search criterion the user chooses. Built a web based front end to allow the public to sign up for the email alerts.
Web Application	Service	Calendaring App. Allows managers to schedule tasks for subordinates using the same event flexibility that Outlook provides....daily, weekly, monthly, annual tasks. Calendar shows service tasks rendered, future tasks, and allows for task completion, emails etc to be generated for the clients served.
Backend	Service - Dispatch	Text message service. Allows server to send and receive text messages to courier phones. Based on the request, server side work is performed and replies are generated.
Web Application	Real Estate	Palm Listing System: Web Application (LAMP). Website to sell houses. Individual listing views total more than 30,000 per month. the business sells more than 450 homes a year in a very small market (New Port Richey). The backend allows agents to manage the public display of listed homes and provides listing reports and business statistics. Century 21 Palm. Re-wrote the existing site from an ASP/MS SQL/IIS web app to the Linux/Apache/MySql/PHP environment.
Backend	Restaurant	Daily Store Update: Application that parses numerous cash register files overnight, inserting the data into a SQL database
Web Application	Restaurant	Helpdesk: Asp based, helpdesk to keep track of restaurant IT calls, to allocate them to the appropriate tech, and to allow tech's to research past issues to solve current ones. Displays graphs of completed, pending and open issues, counts etc.
Backend	Restaurant	Oracle Backup: Application that creates an Oracle backup script and archives the backup for safe keeping.
Backend	Restaurant	Wendy Matrix: Com DLL that distills a Wendy's study of restaurant labor needs based on the restaurant type and equipment into labor hours needed per dollar sales expected.
Backend	Restaurant	Update service: Nt Service, VB Application that preprocesses current and past restaurant sales data by the quarter hour to forecast current sales data quarter hour trends. It takes sales data for the particular day in question for the past five weeks (one year ago), and compares that with the most recent two weeks of data for that day (one year ago). This produces a differential for each quarter hour slot that is applied to the current five weeks quarter hour sales trends to predict the upcoming sales for a restaurant by the quarter hour for the day in question.
Web Application	Service	Added an operations management module to and existing service business web app to manage the courier nightly tasks. Used by dispatchers to keep track of the service provided to the clients on a daily basis. Interfaces with the call/task tracking systems.
Web Application	Restaurant	Labor Scheduling: A web application that allows several hundred restaurants to allocate their labor resource by the quarter hour based on sales forecasts. The application provides the store manager with data showing how many staff need to be scheduled for a particular time period on a particular day. Between three and four thousand employees hours are scheduled on this system each week. Employees can look up their schedules from home. Managers receive various reports.
Backend	Restaurant	Service Time: Application that pulls data files from a restaurant drive through window timer. Data is shipped home, where other applications insert the data into databases for later retrieval.
Backend	Restaurant	ERS reporter: Application controlled by a web app. The app produces numerous reports in both html form and Excel Spreadsheet form. The E Restaurant services web application does not produce the needed reports, especially when you need the results displayed and summer by Store, District, Region and Company. The data comes from an Oracle database. Reports written include: Daily Operating Report, Daily Service Excellence Day Part, Weekly Operating Report, Consolidated Weekly Sales Report, Service Times Weekly, Late Night Sales Report, POC Averages, Inter Unit Transfer Report, Combo Percentage Weekly, Garnet and Gold report.....just one company's reports, many others not mentioned.
Backend	Restaurant	Price Update Vendor: Application that parses vendors price lists received by ftp and updates the stores database with the current price. Keeps a record of price changes.
Web Application	Service	Various business reports added to the system for management.
Backend	Restaurant	To ERS Integration / To Speed Integration: Two separate applications. One moves data from and Oracle DB to a Speed DB, and the other does the reverse.
Backend	Restaurant	Time Data Update: Application that parses timer data files and inserts into DB
Backend	Restaurant	FTP XML: Application that builds various XML files and FTP's them to Wendy's International.
Backend	Restaurant	Unzip Import: Application that unzips certain compressed files.
Web Application	Restaurant	Cash Audit: Allows District managers to edit or insert various sales/cash register numbers under certain conditions. Emails and documents all changes. Provides an audit trail.
Web Application	Service	Created web application to allow an apartment waste removal company to manage it's couriers, staff, clients and to keep track of it's call logs and to assign them to staff. VB, Sql Server, ASP, custom dll's.
Web Application	General	Florida Land Rover Club: Web application. Database oriented club website and bulletin board. Ported to LAMP. www.floridalandroverclub.com
Web Application	Medical	Document Center: Web application. Part of the EMR suite. This is a document processing hub. Allows medical staff to view incoming documents (faxes, scanned, word etc), to then look up a patients electronic folder, and with a couple of clicks, rename the document and insert it into the patient (or staff or department) folder.
Web Application	Medical	Patient Folder: Web application. Part of the EMR suite. Allows quick searching for patient folders and the viewing of the contents.
Web Application	Medical	Page System: Web application. Part of the EMR suite. Allows pager paging and desktop paging of staff on their PC's.
Web Application	Medical	Time clock: Web application. This web application is a time clock, keeping track of hours worked, vacation earned, sick time used, occurrences earned and provides numerous payroll and employee reports. Allows staff to clock in remotely where needed, or in office.
Web Application	Medical	Coumadin/Amiodarone Clinic: Web application. Part of the EMR suite. Two separate applications. Keeps track of clinical studies. Pulls patient data from the practice medical billing system.
Web Application	Medical	Transcription Outsourcing: Web application. Allows internal transcriptionists to select sound files to be made available to outside transcriptionists. Outside transcription talent can retrieve their work orders and upload finished documents to the internal staff.
Web Application	Medical	Prescription WebFax: Web application. Part of the EMR suite. Allows a prescription to be ordered via web browser. The record of the prescription is faxed to the pharmacy, and a copy is placed in the patient folder.
Backend	Medical	Medical Manager Data Importer: Web application. Imports data from a Medical Manager Database into an SQL database.
Web Application	Medical	Patient Folder Creator: Web application. Part of the EMR suite. When new patients are added to the Medical Manager Practice Management System, new Electronic Medical Record folders are created. Runs every minute during the week day.
Web Application	Medical	Appointment Document Creator: Web application. Part of the EMR suite. Creates word and excel documents and inserts the patient information needed. Produces the documents based on the schedule of patients to be seen in the various specialties.
Web Application	Medical	Check-in / Check-out Sheets: Web application. Part of the EMR suite. Provides a schedule of the patients expected to check in for the day. Check out sheet provides this schedule and adds the balance information that the staff need to collect upon departure.
Backend	Medical	Tiff Combine: Application searches for tiff files that should be combined into larger files, and combines them.
Backend	Medical	Word Count: Scan's system for all word documents, collects stats on the author, the number of words, sentences, created date etc, interfaces with time clock data, then produces statistics on words per minute etc.
Web Application	Medical	TC Notify: Application sends out email alerts based on upcoming staff birthdays, pension and insurance eligibility warnings.
Client Application	Medical	JDicom: A client application that provides a quick, simple interface to view medical DICOM images. Designed for a physician to merely hit the space bar to proceed through the images.
Client Application	Medical	Medical Manager Data Reporter: Provides a practice using the Medical Manager Practice Management system with custom reports that are missing from the MM application. Some of the reports are: Procedure History, Procedure History Totals, Procedure Productivity, Procedure Revenue/Number Comparison by Month, Physician Total Revenue/Procedure Number Comparison by month, Procedure Code Statistics, CPT Code Fee Comparison, Procedure to Cath Report, Charges by Month, Year ER Outpatient, Inpatient Insurance report, Accounts Receivable by Patient Report, Physician Procedure Summary.
Web Application	Service	Created a web based database application to allow a waste contractor to manage their cusomers, vendors, staff and the service calls and complaints.
Web Crawler	Real Estate	Produced an object oriented Web App which visits seven pages on a top three real estate web system to add the clients listing to that system to eliminate redundancy. Totally managed via web pages. Essentially, it acts as a regular web browser, submits Secure Socket Layer pages that have been populated and parses the replies. This keeps an HTML log which provides two advantages: web based viewing of the log and viewing of html server based errors which are in the form of web pages.
Point of Sale	Pawn Shop Chain	Worked on Salespot, a troubled, complex and large point of sale system that was still under development. Developed in Visual basic, it uses 131 data-centric Dll�s in MTS to access SQL Server and a similar number if client side objects, custom controls and forms. I fixed bugs, added custom controls, client and data-centric Dll�s. Due to the state of this solution and poor relationship between the owners and original developers, the project was shelved.
Web Crawler	Pawn Shop Chain	Built a Visual Basic web crawler for Spotus.com. This app places auction items on Ebay and checks the items status and manages the auction end. It acts as a web user, but can place hundreds of items on Ebay in a few seconds. It parses the Ebay server replies and captures the ID assigned to each item. When an Auction has ended, it emails the winning bidder, adds the sale to the point of sale system and provides a link to a website for the buyer to pay. (At the time this was created...) Current market systems did not totally automate this process since Ebay does not provide for this means of access. Provided web based logging to report the unattended activity.
Web Application	Pawn Shop Chain	Built web based reporting applications for a Pawn Shop chain to report on the business activities of their eight stores, based on the Salespot SQL database. Built using Active Server Pages in Visual Interdev.
Web Application	Real Estate	Built Intel family of real estate web sites specializing in allowing the web-viewer to search for and see homes that are for sale. The Intel project provided a turnkey real estate web-sites complete with online site administration and online listing management features. All listing images, virtual tours and listing management tasks are handled through the web. The home page featured properties, and all site content are managed trough the web admin. Existing sites can use plug-in applets to add Intel�s data warehousing and powerful search and display systems to their current sites. LocalBuyowner is an Intel based web app which integrates turnkey sites and the www.buyownerservices.com system. www.centeam.com and www.century21palm.com are sister sites to the Intel site and Buyownerservices.com is the original member, which includes credit card and order handling, data search (display of listings by criteria), direct input of listing data by the web-user, email and dhtml features. These sites are SQL 7.0, Active Server Page based, Visual Interdev projects.
Desktop	Medical	Developed an access based VB GUI based app to manage a Cardiology practice's Coumadin and Lipid Clinic.
Desktop	Service	Extended a VB desktop app using Access to improve functionality for a service based company.

Back