Randy L. Smith
Senior Level Consultant (ColdFusion, Internet Applications)
Open to opportunities via W-2, 10-99, or C2C

Work Detail Examples

Technical Summary

Randy has been involved in IT since 1978 when he joined Sperry Univac as a mainframe operator. He moved to programming within the first 18 months and has not looked back until now. Randy has taught himself more computer languages than most people know exist, concentrating on data-based systems like Foxpro, and web languages such as ColdFusion and JavaScript. One of the primary focuses of all of his efforts has been at automating systems and helping people to be more productive.

An MBA helped Randy to enter management, and he has experience in corporate, private sector, and entrepreneurial. He has taken projects from cradle to grave, managing every aspect of the project: architecture, design, server administration, database, programming, management, marketing, and more. Randy has served as a supervisor, President, CIO, CEO, owner, partner, and Chairman of the board.

A sampling of the programming languages and technologies he has worked in include ColdFusion (1.x to 10), Microsoft SQL Server 2000/7 and SQL Express 2008/2005, Foxpro (DOS to Windows), Java/J++, JavaScript, jQuery, CSS, HTML, Pascal, C++, COBOL, MAPPER, Fortran, Assembler, and multitudes of mainframe languages. Randy has used Windows Server 2008, Windows Server 2003, Windows XP/Vista/7, DOS, and has touched on Linux/Unix.

Select Projects Detailed

To provide more depth as to what Randy has been involved with, some of the projects he has worked on are detailed below.

United States Fish and Wildlife Service

The U.S. Fish and Wildlife Service ("FWS") had an antiquated system for tracking and handling the daily progress reports of their field agents. After getting this system upgraded with the requirements they stipulated on the contract, Randy recommended a new approach using ColdFusion and SQL Server technology.

The Accomplishment Reporting System (now the FWS Journal) undertook a massive rewrite over the next few years as it went first to a long-page form and then to a series of short modules for each report, which allowed field agents with (then) poor connections to get in, update a portion as time allowed, and get out again before their sign on timed out.

Almost from the start, this system had great features, such as the ability of the manager to select "targets" for the reports to be sent to by email or fax. These targets included management, press and media contacts, and congress people.  Later versions have allowed field agents and managers to push reports to Twitter and Facebook as well.

Each field report was collected and massaged by a regional manager. In addition to sending press and other reports out, they could collect these items into a newsletter or other form of communication to let others in the service know what their fellow employees were doing. 

Each manager's compilations were then accumulated by a national manager who could then use these reports and statistics for press reports and congressional reports with the possibility that the values could rise to entries in the "green book" which the President uses for their State-of-the-Union address.

Technology: ColdFusion, JavaScript, HTML, CSS, SQL Server, Windows Server 2003; servers were managed by FWS Denver operations. Technical and user manuals were also produced by Randy.

Private HVAC Company

A rather complex project, this firm needed a method for allowing field inspectors to collect input and flow statistics on portable media devices and transmit that information to an online system where it was to be collected, organized, massaged, and used to generate a certification report in PDF format for State inspectors.

Randy hired a subcontract for the data collection portion, where field inspectors could use their choice of an HP input device, a laptop, or a smartphone to run an application that asked questions that were programmed into it.

The answers to these questions were then collected into an XML file that was pushed to a private internal web server and placed in a specific project folder. These files were then processed and loaded into a database, taking care to know whether an item was an update or a new value.

Additional features of the report manipulation allowed for the upload of images, comments / notations, and sign-off date features as well as automatic index building. On request, the system would then generate a PDF file ready for preview or transmission to the State inspection facility.

Technology: ColdFusion, JavaScript, HTML, CSS, XML, SQL Server Express 2008, Windows 7 acting as a server. ColdFusion provided the PDF generation functionality.

Private Dental Software Company

Looking to enter the lucrative dental market, this company was looking for a unique application. At the time, patient notification systems were very rare, and the use of SMS (text) technology was almost unheard of.

Randy invented an application that had both a desktop component and an Internet component. The desktop component would monitor the database of the scheduling software, looking for new patients, changes to patient information, new schedule items, or changes to schedules.  It would then communicate this information to an online database.

An online monitor would then pick up these changes and report them to the patient via SMS, email, and via their online account area.  Customers could respond to the changes any way they chose - by SMS, email, or online -- or, of course, by simply calling the dental office.

If the patient responded via online methods (for example: confirm an appointment, change their information, reschedule an appointment), that information would be transmitted back to the online database, down to the desktop application, and, if needed, alert the scheduling person. 

The scheduling person could confirm the change. If the change required verification back to the customer, it would be automatically transmitted to them by the same method they had just used to send in the change.

Additionally, the system would automatically update the dental office's schedule and the patients online information, so it all stayed synchronized.  Patients were also able to update an online account with their name, billing address, contact information, and preferences that were relayed to the dental office and updated into their records.

Technology: Foxpro, Java, JavaScript, ColdFusion, SQL Server 2003, Windows Server 2003, XML, HTML.

Various Web Customers

Under the companies MCPI and its successor Saphea, Randy has developed more web sites than could be easily counted today.  He began first with simple HTML and FrontPage systems, but he quickly advanced to ColdFusion applications. This is when he developed the Managed Pages system (see Inventions) that allowed his customers to easily be able to manage their own content (text, pictures, documents, links, and more).

By utilizing a template orientation, Randy hired design consultants to develop custom web sites for customers that wanted more than his standard set of customizable templates could deliver. He would then create customizable templates from these designs and his customer could then add as many pages as they wished, put in their own header photos and contact information, and the client could save money in the long run by not having to contact Randy every time they needed even a small change to their web site.

Many custom page types were developed (content, contact, photo gallery, video gallery, forums, and much more) that customers could choose from. 

Randy then advanced Managed Pages to a portal system (collection of web sites that have something in common), and allowed resellers to re-sell websites, manage their own customers, and also make a profit on the sites they sold.

UsedNewCars Portal

A variation on this theme took place when Randy developed a Car Sales portal that allowed each car dealer to have their own website and their own inventory, but the main portal site collected all of the inventory into one location that allowed web visitors to locate a vehicle and then be directed to the dealer that was advertising that vehicle.

Automated DOS and ColdFusion programs processed vehicle inventories, importing vehicles from vehcile services such as CarSoup and Dealer Services, exporting vehicle information to services such as BaeTech, CarSoup, and others, managing images, generating statistical reports, condensing logs for size, and more.

Technology: ColdFusion, SQL Server 2003, Windows Server 2003, HTML, CSS, PhotoShop, XML, DOS, FTP, dynamic WinZip, 123LogAnalyzer (automated), and more.

Guidant Corporation (now Boston Scientific)

Hired as a Foxpro consultant in the Clinical Studies area, Randy soon rose to the top of the development team and immediately effected changes to how clinical data was cleaned and FDA reports were generated. Throwing off the protected and antiquated routines of the past developers, he brought the relatively new Internet technology to bear. After setting up an Intranet and getting the basics of HTML web service going, Randy added ColdFusion, which allowed him to access the Foxpro database directly.  

His team set up data queries that allowed the clinical research team to view and clean the data as it came in, and he changed the Foxpro routines to use ODBC to dynamically stuff the Word documents to automatically generate the FDA reports on demand.

What used to be a six month process of data cleaning with many iterations of an hours-long report generation process turned into a 30 minute final report execution, significantly speeding up Guidant's time-to-market for new products.

Technology: Foxpro for Windows, ColdFusion, SQL Server 7, HTML, Microsoft Word, ODBC

Web Hosting Companies