Back

Education	Skills	O/S used	Languages
Employment	Hardware	Databases	References

Jacques Raymond Kilchoer
614 Shasta Lane
Costa Mesa, California 92626-3100
(714) 557-8427
Citizenship : USA / Switzerland

• Education
  Extension Classes : Object-Oriented Design, C++ (both from Cal State Fullerton, 1996). HP-UX Systems Administration (from Hewlett-Packard), Oracle Network Administration (Oracle Corporation), Parallel Server (Oracle Corporation).
  Bachelor's of Science. Boise State University, Boise, Idaho. July 1985.
  (Major : Mathematics. Minor : Computer Science.)
  Baccalauréat Section Scientifique, Collège St-Michel, Fribourg, Switzerland. 1981.
  (Major : Classical Studies. Minor : Biology.)
  
  
• Professional Employment
  • January 2001 - present
    Quest Software, Irvine, California
    Database Administrator.
    Duties
    • Assist in development and testing of Space Manager software package.
    • Investigate new features of Oracle for implementation in said software package.

    Tools used

    • Oracle Enterprise Edition Server 8.0

     

  • September 1999 - September 2000
    Monitoring Automation Systems, Irvine, California
    Database Administrator.
    Duties
    • Support of various development databases and occasionally client production databases (Oracle 8.0 and Sybase 11.5)
    • Upgrade Sybase adaptive server to new version.
    • Move all Oracle and Sybase databases to new server.
    • Assist developers in debugging Oracle PL/SQL code.
    • Implement backup and recovery strategy.

    Tools used

    • PL/SQL, Oracle Enterprise Manager, Oracle Enterprise Edition Server 8.0, Sybase Adaptive Server 11.5

     

  • January 1998 - September 1999
    Ceridian Tax Service, Fountain Valley, California
    Database Administrator.
    Duties
    • Production support of 20 Oracle databases on HP3000 MPE, HP-UX, Windows NT.
    • Monitor databases for performance.
    • Implement new database models.
    • Verify consistency of development/production environments.
    • Test and certify new versions of Oracle.

    Tools used

    • PL/SQL, Oracle Enterprise Manager, Oracle Enterprise Edition Server 8.00

     

  • January 1997 - December 1997
    Cost Care, Inc. Newport Beach, California.
    Assistant Database Administrator.
    Duties
    • Maintaining ORACLE and INGRES databases on VMS and Digital UNIX.
    • Monitor databases for performance.
    • Database modelling for new systems, designing and implementing database using database rules/triggers.
    • Import/export of data between different environments.

    Tools used

    • ESQLC and Pro*C (C with embedded SQL), ESQLCBL and Pro*COBOL (COBOL with embedded SQL), PL/SQL, Oracle Server 7.3

     

  • April 1992 - December 1996
    Cost Care, Inc. Newport Beach, California.
    Programmer/Analyst.
    Duties
    • Creating a 3-tier client/server application for a Health Care Provider network directory.
    • Creating a 3-tier client/server application for tracking long-term and short-term disability patients.
    • Enhancements to medical bill validation systems, Health Care Provider network directory systems, and medical Utilisation Review systems.

    Tools used for Client/Server development

    • Windows 3.x, Windows 95, Windows NT, Digital UNIX, DEC C, PowerBuilder, INGRES, Oracle.

    Tools used for other systems

    • VAX/VMS, VAX C, VAX COBOL, FMS.

    Tools used for reporting

    • Powerhouse Quiz, Datatrieve and INGRES Report Writer.

       

  • May 1991 - January 1992
    Professional Coin Grading Service. Santa Ana, California.
    Programmer Analyst.
    Duties
    
    • creating and maintaining an inventory, invoicing and data entry system for business.
    • Maintaining a system designed using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary), and COBOL.
    • Used the software tools MPEX, STREAMX and ADAGER.
    • In charge of Macintosh support.

   

  • November 1985 - May 1991
    David Hall's Numismatic Investment Group. Santa Ana, California.
    Programmer Analyst.
    Duties
    
    • Creating and maintaining an inventory, invoicing and mailing list system for business.
    • Designing and implementing databases.
    • Designing and coding database retrieval, reporting, entry and updating systems.
    • Wrote all programs using Cognos' Powerhouse fourth generation languages (Quiz, QTP, Quick and their data dictionary).
    • Set up Vesoft's security system.
    • Wrote enhanced JCL using Vesoft's MPEX and STREAMX.
    • Maintained data bases with Adager.
    • Recommended buying COBOL and rewrote the frequently used programs in COBOL.
    • Some work in providing an interface between our custom system and the accounting package MULTIVIEW from POWERHOUSE.

• January 1983 - September 1985
  Idaho Transportation Department. Boise, Idaho.
  Planning Technician Aide.
  Duties
  
  • Create, update and optimize software for statistical applications.
  • Designing of mathematical model for prediction of pavement damage.
  • Teaching SAS language classes.
  • Programs were written in COBOL, FORTRAN and SAS.

   

• Professional Skills

  Computer Programming Languages
  BASIC, C, COBOL, FORTRAN, SAS, Pascal, Quick/Quiz/Qtp, PowerBuilder.
  Professional experience in SAS, COBOL, FORTRAN, HP COBOL, VAX COBOL, DEC C, Quick/Quiz/Qtp, PowerBuilder, SQL, PL/SQL.

  Shell scripting in DCL, Korn Shell.

• Computers Employed

  PC : Macintosh, IBM PC compatibles (DOS,Windows).
  Mini : HP 3000, DEC VAX, DEC Alpha.
  Mainframe : IBM 370, IBM 4341, IBM 4381.

• Operating Systems

  Digital UNIX
  VAX/VMS
  MPE XL (HP 3000), MPE V (HP 3000)
  DOS (IBM 370), OS/MVS (IBM 4341, IBM 4381), CMS (IBM 4341)
  Windows 3.1, Windows 95
  Macintosh OS

• Database managers used

  INGRES (ABF, ESQLC, ESQLCBL, Report Writer, DB management)
  Oracle - versions 7.1, 7.2, 7.3, 8.0 - (PL/SQL, stored procedures, Pro*C, Pro*COBOL, Enterprise Manager, Oracle Names)
  VAX RMS indexed files
  DATACOM DB/DC, PAN/VALET
  IMAGE/Turbo IMAGE, KSAM

• Languages

  English Native fluency. Am capable of translating from English to French and vice-versa.
  French Native fluency; schooling in Switzerland from 1969 through 1981. Am capable of translating from French to English and vice-versa.
  German Seven years of schooling. Reading : good. Writing/conversation : fair.
  Italian Three years schooling. Reading/writing/conversation : fair.

• References

  Available upon request.