Work Samples by Brent Jones                                                               Home                           

More complete listing of my computer experience than was on my resume

(I have highlighted in red the areas that particularly apply
 to the job at Loyola for which I am applying.)

1970	College					 
	Fortran IV and PL1	College course:  Intro to Programming				
	Calculus I and II, Advanced Calc, Differential Equations					 
1974	Graduate School					 
	Learned "Tutor" language on Plato system	Independent study course			
	
1989    Chemistry teacher Learned BASIC on Apple II, TRS-80, and did word processing					
1982	Taught business users in IBM Product Center Classrooms					
	DOS 1.1, Lotus 123, DisplayWrite 2, WordStar, WordPerfect 					
	Framework, Symphony, dBase II, VisiCalc, SuperCalc, MultiMate					
1985	Missionary in Pakistan					
	Used DOS ver 3 through 7 and various apps					
	Computer support for missionaries, word proc, database, accounting	
1994	Catapult Software Training	taught business users in 39 courses at different levels
	Intro to Win 3.1 and 95	Advanced Windows
	Lotus 123, SmartSuite Ami Pro, 	Netscape Communicator, Internet Explorer
	WordPerfect Suite, Paradox, Quatro Pro, Lotus Notes	
	Extensive experience with MS Office-Win 3.1x; 95; 97;2000; XP; 2005	
	Microsoft Certified Professional -- Windows 95	
1996	PC and Network Support for NYK Line (Centennial Express) Japanese shipping co.	
	NT 4.0 LAN installation and administration-Ethernet 10/100	
	Novel 3.x LAN installation and administration-ARCnet, Token Ring	
	Lotus cc:Mail installation and administration	
	Install & configuration of  modems, DSU/CSU, MAU, hubs, routers, switches	
	Repair and upgrade PCs: motherboard, RAM, power supplies	
	AS/400 to PC data migration/translation	
	Developed database applications using MS SQL and Access 
	Visual Basic 4 coding
1999	Senior Computer Analyst	PC and network support at West Sub Hospital
	DataBreeze, Sybase SQL queries and reports	
	Trained users in registration part of application
	Loaded Fee schedules into server database
	Supervised backup  (even replaced HD and restored all night)	
	Developed MS Access and MS SQL applications to scrub data against HMO, PPO databases	
	Developed billing system database application that shortened a 4 day report to 2 hours.	
	Made department web site portal with MS Front Page on IIS
	Assisted with transition from DataBreeze to Informix based RDBMS 
	Developed Cognos reports 
2002	Chemistry teacher	
	Tested the new school enterprise software and trained other to use it	
	Used and helped others with electronic gradebooks and personal web pages
	MISC over several years 
	Linux and MySQL servers set up
	Wireless Internet installed
	Fixed PC that had virus infections, spyware, spam etc.
	Built a several of PCs from scratch
	Web Site development with Dreamweaver --  MS Visual Web Developer --  NVU
	Palm Pilot and Pocket PC
  1. At Centennial Express, I developed a SQL database with a MS Access front end.   The company managed the
    movement of containers on the rail portion of an international shipment.  They rented empty containers and
    constantly had to track their movements on several railroads.

        Here are screen shots I made to show how the application worked.

     Home    Top
  1. In work at West Suburban Physician Services I prepared many reports using data from the main database
    (a Sybase SQL database application) and files provided by external sources.  Here are screen shots of that allowed
    administrators to adjust the fees for various CPT procedures based on Medicare rates and the quantity done.
    The blank box on the Fee Comparison was where the new "price" was entered and then typed into a file.
     I later did an insert on the database to put in the new fee schedule in place.  (Because of HIPAA I did not
     retain any of the database info that included patient information.  I did many of these as we scrubbed the database
    of info that did not agree with HMO monthly data reports.)

     Home    Top

    Final report                   Table 1                         Table 2                       Table 3

  1. HTML based report

As a teacher I developed a method to allow parents and students to view progress in their course.

The data is old but shows the idea.  Your Grade Use the sample.

  1. Below are sample screens of a possible credentialing portal at Loyola House Staff and GME.
    I was not able to spend much time on this.

        Portal entry    MD information screen

  Home    Top