JPL Emails

Results
In 1991 while temping at the Jet Propulsion Lab in Pasadena, Ca, before email systems like we have today, scientists at JPL would receive twice daily electronic mail messages from various governmental agencies across the U.S. These “e” mail messages came in all at one time and had to be parsed out, removing the headers and footers, and printed for each recipient. This task typically took 45 minutes to 1 hour twice a day manually. Nicholas developed a macro that ran in Word Perfect that could parse out each message, remove the headers and footers, and print it out all in under 2 minutes. Download Brochure
Read More

JPL Resource Cost Planning

Results
In 1992 at JPL, Nicholas was hired to develop MS Excel macros for the Resource Cost Planning system. The project was way over budget and almost a year past the delivery deadline. The bottleneck was that the Excel spreadsheet categories were continually being added to. Thus reading them into MS FoxPro utilizing Dynamic Data Exchange (DDE) calls was fighting a losing battle. The FoxPro expert tasked with reading in these values from the Excel Spreadsheet was terminated and Nicholas was assigned the task and given 2 weeks to accomplish what his predecessor had been unable to do in 9 months. After 2 days of analyzing the existing code, Nicholas decided to scrap all of it and come at it from an entirely different approach. Since Excel and FoxPro were both…
Read More

JPL Procurement Automation

Results
In 1993 at JPL, shadow systems were a huge time, energy, and resource waste at the Lab. While working as a Group Admin Assistant, one of my tasks was to generate Procurement forms for parts used by the scientists and engineers. There were several “shadow” systems for Procurements but none that were very efficient. Nicholas built a database using dBaseIII+ on a little 286 Novell networking server that used the multi-part “official” form of the Procurement Division and made it available to all 8,000 people on the entire Lab. Even the “Just in Time” guys utilized the system as it was much more efficient than the mainframe system. Download Brochure
Read More

JPL Workforce Analysis

Results
In 1995 at JPL, keeping track of all the labor hours by project was a very time consuming task each month for the Section Admins. Division required them to produce a report each month to check to make sure that their projected man-hours and actual man-hours were relatively close. Nicholas was able to pull down from the lab's mainframe all of the Divisions monthly labor times and charges. A program was developed that accomplished the task for the entire Division (6 Sections) in just under 90 minutes, as opposed to just one Section of the Division taking 19 hours to do manually, an efficiency of 12.6x's more efficient. Download Brochure
Read More