Project Manager System

F. Raymond Knight

*** ****** ***** ***. 215-***-****

Cell: 215-***-****

Warminster, Pa. 18974-4487 E-mail: *****@*******.***

EDUCATION: M.B.A. COMPUTER SCIENCE(GPA: 3.75/4.00)

Philadelphia College of Textiles and Science, Philadelphia, Pa., December, 1987.

B.B.A. COMPUTER AND INFORMATION SCIENCES/MANAGEMENT(GPA:3.05/4.00).

Temple University, Philadelphia, Pa., May 1981.

A.S. CRIMINAL JUSTICE

Temple University, Philadelphia, Pa., May 1979.

SUMMARY:

27 years development experience since 1981 with heavy user contact and 4 years of call center (1991-

1995) experience at the Naval Air Warfare Center (NAWC) in Warminster. Heavy C#/Visual Studio 2005

and ADO.NET along with heavy VISUAL FOXPRO design and programming through version 8. Very

strong relational database background including heavy hands on SQL Server 2000/2005. For example,

designed SQL tables for conversion of CCALC system from DBF’s to SQL tables. Presently converting a

Salesman Commission System (CCALC) from VISUAL FOXPRO 8 to C#/ADO.NET and SQL Server

2000/2005. Presently working in VISUAL BASIC 6.0. Also, taking a course at the local community college

in VB.NET.

EXPERIENCE:

01/09-Present Fidelio Dental Insurance Company, 2826 Mount Carmel Avenue, Glenside, Pa. 19038.

Programmer Analyst. As a consultant, presently writing and modifying programs for a Dental

System written in Visual Basic 6.0 and SQL Server 2000.

11/08-12/08 Becker Staffing, 3 Bala Plaza, Bala Cynwyd, Pa 19004.

Programmer Analyst. As a consultant, worked on rewriting a recruiting system, which was written in

Visual FOXPRO 9.0. The complete rewrite was required because the programmer who wrote the

system did not provide any source code and when the system was moved to a different drive it

ceased to work correctly. Because of the rewrite, I was required to analyze the old system and

design the new system based on already existing tables and data.

06/06-11/08 VOLT Information Sciences, Inc., One Sentry Parkway, STE 1000, Blue Bell, Pa. 19422.

Programmer Analyst. Presently converting the VISUAL FOXPRO CCALC system from FOXPRO to

VISUAL C#. Project head and sole programmer for the VISUAL FOXPRO to VISUAL C#

conversion. The CCALC system is a complete Salesman Commission System that takes data from

a mainframe and converts it and stores it in SQL tables (unconverted system stores it in DBF’s) on

the PC. This data is then massaged and used to create commission statements, payroll files, and

reports. Salesman and manager’s information is created and stored on the PC and on a weekly

basis it is uploaded to the mainframe in the form of flat-files. The weekly information is also

massaged and stored in history tables. Wrote the design document for the conversion process as

well as designing and implementing the SQL tables. Wrote conversion code to convert DBF data to

SQL data. I am presently writing and testing the conversion code. The conversion process is

expected to take three years to complete. Previously, wrote program in Visual C# to allow Yellow

Page Directory Information on our computers to be converted to a format which will allow our data to

be hosted and displayed on the Yellow Pages Association’s website.

• Documented the present FOXPRO system in preparation for the conversion to C#.

• W orked with XML to create a report file, which is used to build reports within the CCALC program.

• Created user combo boxes to allow for the presentation of multi-column data. Also created an

improved calendar selection box.

• W rote code in C# to convert the data contained in the FOXPRO databases and store it in

Microsoft SQL SERVER 2005/2000. The development system uses Microsoft SQL SERVER

2005 but the data will ultimately be hosted on a server using Microsoft SQL Server 2000.

• Designed and created Database schemas for the CCALC conversion using SQL Server

Management Studio Express 2005.

• W rote a large number of programs in VISUAL C# to mimic and improve the various processes

which existed in the old FOXPRO system.

• Converted reports from the VISUAL FOXPRO 8.0 report writer to Winforms Reporting (rdlc report

writer files).

• W rote program to convert our directory data to a format which the YPA (Yellow Pages

Association) can use to display directory information there website. The conversion process

included creating header files, zipped image files and trailer files which were all FTPed from inside

the C# program. The information for this process was obtained from flat files, SQL databases as

well as from JPGs contained in various file folders. Because of problems with the .NET FTP

process a complicated parsing algorithm was developed so that DOS FTP could be used to

upload the YPA information.

8/05-11/08 VOLT Information Sciences, Inc., One Sentry Parkway, STE 1000, Blue Bell, Pa. 19422.

Programmer Analyst. Maintained and supported a VISUAL FOXPRO Salesmen Commission

system called CCALC. The system was originally developed by a consultant in VISUAL FOXPRO

8.0 using the Mere-Mortals Framework and at the time I was hired the system was transferred to

VOLT and myself. The CCALC system is used by a number of different sites that include countries

such as Uruguay and Spain. Project head and sole programmer for the VISUAL FOXPRO CCALC

system. Also developed and wrote several VISUAL FOXPRO programs to allow Western Canada

directory Data to be incorporated into the National Data System.

• Re-wrote a number of functions to speed up processing as well as making various functions easier

to use. As an example, the import file process consisted of six separate menu entries, which were

run one after the other as well as requiring user input during each step of the process. Combined

these six separate menu entries into one process, which is run automatically and only required

user input at the start of the process. Also, fixed a large number of problems in CCALC which

existed at the time the program was transferred to VOLT

• Altered and wrote several new reports to provide information requested by management. As an

example, wrote a report called the Salesman Analysis report that determined how many salesmen

were not meeting their quota. Based on this report a number of salesmen had there commissions

adjusted.

5/05-7/05 Metro Technology Services, Inc., 1436 Lancaster Ave, STE 360, Berwyn, Pa. 19312.

Programmer Analyst. Wrote various programs in VISUAL FOXPRO 8.0 to support a police based

record keeping system. The police based record keeping system was in the process of being

converted from FOXPRO 2.6 to VISUAL FOXPRO 8.0.

• W rote several new reports in VISUAL FOXPRO as well as making changes to the program to

support the upgrade from FOXPRO 2.6 to VISUAL FOXPRO.

2/90-4/05 Digital Systems Group, Inc., 650 Louis Dr., STE 110, Warminster, Pa., 18974

Senior Programmer Analyst. Wrote various programs in COBOL, and SQL for the IFMIS

Accounting system on the SGI.

• Development of the Interfund Subsystem, which allows billing information to be transferred from

one NAVY base to another. This project involved converting a manual system to an automated

online system. It required a full System Analysis, design, development and implementation.

ORACLE was used as the Database interface for this project. It also involved the use of

INDEXED SEQUENTIAL files as well as text files within the Interfund process. Code was

combined into procedures, which were used across the Interfund system. In addition this involved

removing bad data, converting and posting the information to the IFMIS Accounting system.

Various reports needed to be created such as History reports, posting reports, validation reports,

and balancing reports. These reports were created using SQL and the IPL report writer. Wrote

various scripts in C-SHELL and Bourne Shell. Wrote various design documents for the Interfund

Subsystem. During this project, I supervised up to two other programmers at one time or another.

During this project, assisted the financial analysts who performed testing of the various

components of the Interfund Subsystem. Test plans were written and tested before the Interfund

Subsystem could be moved from one test environment to another (i.e. test, accept, production).

The Interfund Subystem exceeded all milestones and was brought in well ahead of the deadline

date.

• W rote various COBOL programs to support the various IFMIS subsystems such as Billing,

Accounts Receivable, Cost Posting, property, and inventory.

• Assisted in converting the IFMIS Financial System from the MIPS computer to the SGI.

• Developed various programs to convert Training data, Rental and Maintenance, DD1155

Contracts, Travel and Housing data from one system to another. These programs were written in

COBOL to facilitate the transfer of data from the customer’s old system to the new IFMIS system.

• Used DSG developed panel library to display and retrieve data.

• W rote a couple of programs in java to analyze data that the ICORE system had produced.

• Developed a number of programs in COBOL to handle depreciation for the IFMIS Subsytem.

• W rote various programs in SQL to produce reports, fix bad data, and analyze customer’s

problems.

Senior Programmer Analyst. Reporting to RDS Supervisor. Wrote various programs to support the

Personnel department at the Naval Air Development Center in Warminster. These programs were

written in FORTRAN, C and SQL on the SGI. Also wrote FORTRAN and COBOL programs on the

CDC Cyber as well as ORACLE FORMS 4.5, CLIPPER, FOXPRO and DBASE programs on the

PC. Some of these programs were written to support the Integrated Financial Management

Information System at NAWC. Wrote various programs in Micro-focus COBOL on the MIPS using

the Unix System 5 operating System. These programs were written in support of the Supply

Department and involved improving their Inventory tracking system. Also, wrote various

management maintenance reports for the Supply Department. Also provided PC and Mainframe

Help Desk Support for NAWC.

• W rote various programs in Clipper and FOXPRO to upload, download and process information

between a PC and the CDC CYBER.

• W rote a Personnal Information Database System in FOXPRO for the Personnel Department.

• Provides user support for Microsoft Word, FOXPRO, CLIPPER, HARVARD GRAPHICS,

CROSSTALK, MS-MAIL, MICROSOFT EXCEL as well as various other windows programs.

• W rote a TRAVEL SYSTEM in ORACLE FORMS 4.5 to support TRAVEL at NAWC.

(1987-1993) Professional Data Systems, Inc.- Warminster, Pa., Consultant.

In conjunction with a dentist, I developed a Dental System in FOXBASE 2.6 for the IBM PC. The

system consisted of all the functions needed for the efficient operation of a medical- business office

system. The dental program consists of 50,000 lines of source code and took two years to

complete. This program was later converted to FOXPRO. It provides all the accounting functions

and tracking features that a dentist would need including: Family Account Inquiry, quickstatements,

End of Day/Month processing, Posting of transactions, and Practice Analysis reports. The dentist

can quickly add, modify or delete patients. It is a state of the art program which supports a mouse

pull-down windows and full screen editing. This program provides the capability to quickly enter and

modify insurance information for both pre-treatment estimates and current services rendered. Beta

tester for DBASE IV version 1.1.

1/85-1/90 Intermetrics, Inc., Defense Systems Division, 607 Louis Dr., Warminster, Pa. 18974

(8/87-1/90) Technical Manager. Reporting to PG&D Project Manager. Responsible for designing, developing,

and maintaining software which is used to simulate a Signal Processing Language on both a CDC

6600, VAX 11/785, and IBM 4331 using CMS and DOS/VSE. Also responsible for managing the

programming tasks of four programmers. The code used to simulate this assembly language is

written in FORTRAN 77 and C on the VAX 11/785 and FORTRAN 66 on the CDC 6600. The

Operating System used for the simulator on the VAX is BOURNE SHELL. The simulator consists

of a Compiler, Linker, SPL Assembler, Relocating Loader, DCA Simulator, Microprogram

Translator, and Microprogram Simulator.

• Rehosted Microprogram Translator from the CDC 6600 to the VAX 11/785. This process involves

several steps. The first step is to convert the code from CDC format to VAX format. This includes

changing machine dependencies and converting the code from FORTRAN 66 to FORTRAN 77.

The second step involves running tests to verify that the tests at least run. The third step involves

debugging the types of code which are used by the Translator(AP Microcode, CP Microcode, and

RBC Microcode). The fourth step involves verifying that all tests run correctly.

• Corrected problems in the SPL Assembler, Microprogram Translator, Relocating Loader, and

Microprogram Simulator. Some of these problems included correcting the AP Microcode to run

correctly following CP Microcode in the Microprogram Simulator. Another problem involved

correcting the Relocating Loader to put out proper error messages.

• W rote programs in C to count the number of executable lines of code in a particular file, remove

trailing spaces from a file, and change one character to another in a file.

(1/85-8/87) Scientific Programmer Analyst. Reporting to CIS project manager. Responsible for designing,

developing, and maintaining software for a Financial Data System and assisting another

programmer with the Payroll System. This involved creating and modifying payroll programs and

management reports. The code for the Financial Data System and Payroll System is written in

COBOL and FORTRAN on the CDC. Worked independently on the FDS task with guidance

mainly from the government employees.

• Various programs in the Financial Data System were upgraded from COBOL3 to COBOL5 and

FORTRAN 3 to FORTRAN 4.

• Converted a number of Payroll programs from FORTRAN TO COBOL.

• Completely rewrote several programs which were responsible for creating, and maintaining the

master file. This included the addition of additional error checks and the conversion of many of the

programs from FORTRAN 3 to COBOL 5. This included the production of a 300 page user's

guide.

• Assisted in the rehost of each new version of the Payroll program.

(1984/1985) System Development Corporation(SDC)- Warminster, Pa.

(5/84-1/85) Scientific Programmer Analyst. Designed and wrote programs in PASCAL on a BURROUGHS 6700

and BURROUGHS 874 for a NATO Message Processing System. This system will be installed in

EUROPE to link the various countries that are part of NATO.

• Modified and produced documentation for a PASCAL Compiler and Linker. Also worked on

responder reports which involved retrieval, formatting and printing of circuit, terminal and message

information.

(6/81-5/84) Sperry Corporation- Technical Services Division- Trevose, Pa.

Scientific Programmer/Analyst. Designed and wrote programs in CMS-2Y and ULTRA-32 on an

AN/UYK-7 for the CV-ASWM system (Aircraft Carrier based system). Was in charge of Tabular

Display Management Subprogram, Mag Tape Utilities subprogram and Security Administration.

• Tabular Display Management involved responsibility for six separate programs. Current code

encompasses 50,000 lines of CMS-2Y and ULTRA-32 (assembly language) code. Debugging of

this code is done in machine language on the operational system. Was in charge of another

individual who built Tableau source definitions (MAPS) under my direction. Tabular Display

Management is involved with the entry, display, and manipulation of data that is passed to it from

other subprograms. The Analysis and design portion of this subprogram involved writing a

Program Design Specification Document and a User's Manual. Mag Tape Utilities involved writing

new code and modifying existing code for the following programs; Copy Tape, Print Tape, Print

Headers on a Tape, Compare Tape, Position Tape to a Certain Header, and Write a Header on a

Tape. The Security Administration program was modified to add additional features such as; new

switches, additional function screening, etc as well as rewriting the documentation for the Security

System.

(1987-1987) Apple Core Associates, Inc.- Warminster, Pa. Consultant.

As a consultant, worked on a Medical System (MEDSYS) in DBASE III+ and Clipper for the IBM PC. This

system consisted of inventory, insurance, utilities, and a listing menu.

HARDWARE: SGI, HP9000, AN/UYK-7, IBM 4331, BURROUGHS 6700, BURROUGHS 874 (16-bit mini), CDC

CYBER 6600,VAX-11/785, DATA GENERAL ECLIPSE, APPLE MACINTOSH+, IBM PC AT, and

PENTIUMS. Academic: IBM 4331, IBM 4341, IBM 360, CDC CYBER 174, CDC CYBER 172, DEC

PDP-8I(MINI), DEC PDP-8L(MINI), HP-3000(MINI), MIPS.

SOFTWARE: HTML (Developed Webpage for Civil War Reenactment Group at

http://www3.50megs.com/104pa/index.html, SQL SERVER 2000/2005, SQL SERVER

MANAGEMENT STUDIO EXPRESS, java, VISUAL C#, VISUAL FOXPRO 8.0, ORACLE, ORACLE

FORMS, PASCAL, CMS-2Y (Algorithmic HOL), ULTRA-32 (ASSEMBLY LANGUAGE),

ERRATA(Machine Language), FORTRAN-77, FORTRAN-66, COBOL, CLIPPER, FOXBASE+,

FOXPRO 2.6, DBASE III+, DBASE IV, C, BOURNE SHELL, SQL, VISUAL BASIC 6.0. Academic:

FOCAL, PAL-III(ASSEMBLY LANGUAGE), BAL (ASSEMBLY LANGUAGE), PL/1, BASIC, DOS/VS,

DOS/VSE, DOS JCL, DISK UTILITIES AND SORT/MERGE FACILITY, IMAGE (DATA BASE

MANAGEMENT SYSTEM/DBMS), CMS, CICS, BURROUGHS OPERATING SYSTEM, and JAVA.

PROFESSIONAL AFFILIATIONS, HONORS, ETC:

Delta Mu Delta, National Eagle Scout Association, EAGLE SCOUT With a Silver Palm, DBASE IV

Beta tester.

REFERENCES

JAMES F. DOMINY (FORMER SUPERVISOR AT DSG)

876 COOLIDGE CT

WARRINGTON PA 18976-1754

HOME: 215-***-****

WORK: 215-***-**** Ex. 243

JOHN HILLENBRAND (REPORTING SUPERVISOR AT VOLT)

338 ABBEY LN

LANSDALE PA 19446-6441

HOME: 215-***-****

CELL PHONE: 215-***-****

WORK: 610-***-****

EDGAR MARCHA (CO-WORKER AT DSG)

639 BELMONT AVE

SOUTHAMPTON PA 18966

HOME: 215-***-****

WILLIAM WIRTH (CO-WORKER AT DSG)

348 MAGNOLIA RD

WARMINSTER PA 18974

HOME: 215-***-****

WORK: 215-***-**** Ex. 252

Contact this candidate