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

KSC Shuttle Clean Room

Results
In 1983 at the Kennedy Space Center working on the Space Shuttle. Assigned to the External Tank (ET) group, we were tasked with preparing the ET for mating with the Solid Rocket Boosters and the Orbiter. When the ET came into the Vehicle Assembly Building (VAB), it had been shipped in from the plant outside of New Orleans with shipping covers on many of the tubes and valves. Because of the risk of contamination, when the shipping covers were removed and the working covers were installed, it required a “clean room” environment. The technicians would construct a room using uni-strut which could take 2 to 3 hours to construct, then when the task was finished, the technicians would disassemble the room. Nicholas redesigned the “room” so that by loosening just…
Read More

KSC Shuttle Parts

Results
1984 at KSC, writing out the parts tags for hardware that was taken off of the ET was a time consuming task, taking Techs and Quality Control personnel about 2 hours to hand write out all of these tags. Working with a friend in another division that used a Wang word processor, Nicholas and his friend were able to produce 9 sets of these parts tags in just 15 minutes, a savings of almost 18 hours, a 72x's improvement. 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