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

IQZero.net

Custom Software for a diverse range of businesses
Jonathan Galpin, LAMP (Linux, Apache, Mysql & PHP), ASP, VB, Mcsd, Bsc. տլ

Past/Current Software I have Written

Type of Software	Industry	Description
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, 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.
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