Management Sql Server

William H. Knight, Jr.

Extensive experience and expertise in systems development, project/team

management, technology and business consulting, and training/development

services. Available for domestic and international travel.

Experience & Education Summary:

Since1985 Independent Computer Systems Consultant

1981-1985 Arthur Andersen & Co. (New York), Consultant and Senior

Consultant.

1978-1981 New York City Dept. Of Employment, Asst. to the Commissioner

and Director of Evaluation

1976-1978 Harvard Graduate School Of Business, Master in Business

Administration

1974-1976 Wharton School, University Of Pennsylvania Bachelor of Science

in Economics

1972-1974 Skidmore College, Majored in Economics and Political Science.

Industries: Financial (banking, brokerage, credit card, investment,

insurance), Government (local, state, federal), Misc. (arts,

education, entertainment, real estate, religion, testing)

Technologies: Java (Core Java, Javascript, JBuilder, JDBC, JDOM, JSPs,

Servlets, Swing), Java/XML (DOM, Sax, DTD, Schema, Xerces,

Xalan, XMetaL, XMLSpy, XPath, XSLT, XSelerator), Testing

(ATF, JProbe, WinRunner, SQA), Database (ODBC, Oracle, SQL

Server, UDB, Access, FoxPro), Application Servers

(Websphere, Apache), UML ( Rose, Select), Data Modeling

(ERwin, System Architect, IEF), Document Mgmt. (XMetaL,

Calligo, Livelink), Methodology (Method 1, Summit), Misc.

(AJAX, Assembler, HTML, PHP, Visual Basic, CoBOL). Workflow

(Chordiant, Filenet, Notes), Configuration (CVS, PVCS,

Razor),

Functions: Account/Client Management, Billing, Budgeting, Document

Management, Payables, Personnel, Policy Administration.

Receivables, Trading, Unemployment Insurance

Most Recent Systems Experience

- AJAX based web site for sports officials

- Java/XML/XSLT based Test Creation System for leading test administrator

- Java/XML/XSLT based insurance product administration system for Third

Party Administrator

- Java based enterprise document and workflow system for prominent Insurer

- Java/XML based enterprise document management system for leading Insurer

- For a preeminent mutual funds firm

- Architecture specification for trade quotes/orders telephony system

- Automated Trade Order Faxing and OCR feasibility study

- Remote call center architecture options review

- Automated test suites for core components

- Commodity derivatives trading system for a prominent international bank

- Advertising budget system for a premier international travel services

firm

- Payroll distribution and help desk systems to support a bank merger

- Billing system for the corporate trust division of a major international

bank

Selected Other Systems Experience

- Account receivable/billing and client management systems for a preeminent

auction house

- Suspense, accounts payable and staff tracking systems for a leading

securities firm

- Multiple building directory system for a preeminent property management

group

- Personnel and accounts management systems for a leading music licensing

agency

- State unemployment insurance system upgrade

- Automation plan for a large Diocese and automation plan review for a

major District Attorney

Other Selected Experience

- U.S. Department of Labor national task force on management assistance and

training

- Instructor for college technology courses

- Directed various program and management studies

38 Orleans St. Princeton Jct, NJ 08550 609-***-**** email:

******@*******.***

WILLIAM H. KNIGHT, JR.

Selected Project Experience

SUMMARY

Over 20 years of experience in the field of Information Tecchnology as a

Project/Team Leader, Architect, Consultant, Designer and

Programmer/Analyst. Expertise includes the design, analysis, development,

testing, implementation, maintenance, installation, system documentation,

enhancement and migration of object oriented, client/server, Windows and

web based systems. Applications include derivative products, banking, fixed

income securities, insurance, mutual funds, personnel, payroll,

receivables, payables, account management and telephony. Development

experience includes Access, ActiveX, AJAX, Assembler, ATF, Calligo,

CoBOL, COM, Crystal Reports, ERwin, FaxWorks, FoxPro, HTML, IEF,

Impromptu, Interdev, Java, JBuilder, JProbe, Livelink, Microsoft SQL

Server, MQSeries, ODBC, OLE, OS/2, Novell, Oracle Database, PVCS, PC-

Anywhere, PHP, RDO, RoboHelp, SQA, Method 1, Summit, Rational Rose,

Select, System Architect, Sybase System 10/11, TCP/IP, TypeReader, Unix,

Visual Basic, Visual Modeler and Windows/Windows NT, WinRunner, Xerces,

XMetaL, XML, Xselerator and XSLT.

11/06 - Present: PhillyRef.com

PhillyRef.com provides web based information for sports officials including

real time news and sports feeds, rules references, events listings,

resource links and customized search facilities. Mr. Knight is the

architect and primary developer for the site which employs AJAX,

Javascript, HTML, PHP and RSS technologies.

07/02 - 08/06: Educational Testing Services (ETS)

ETS annually produces and administers approximately 12 million tests in

more than 180 countries. Mr. Knight was a senior developer for the ETS

Java/XML implementation of ETS test creation systems. System components

operate across Unix and Windows platforms and include the following

development and implementation technologies:

- JBuilder and Eclipse Interactive Development Environments

- Apache Application Server

- Core Java, J2EE

- XMetaL, XMLSpy and XSelerator Editors

- Lotus Notes

- Oracle Data Base Services

Mr. Knight was primarily responsible for the item authoring, pre-scoring

validation and item conversion efforts.

06/01 - 05/02: Andesa TPA

Andesa is the premier third party administrator of Corporate Owned Life

Insurance systems. Andesa provides rapid development and cost-effective

administration of custom systems for its client base of large insurers.

Mr. Knight was a senior developer for Andesa's first Java implementation of

an insurance administration system. The system operates on the UNIX and

Windows platforms with the following development and implementation

technologies:

- JBuilder Interactive Development Environment

- JProbe Performance Testing & Optimization

- Microsoft SQL Server Data Base Services

- Razor Source Control

- Core Java and Sun Java Web Start

- Xerces XML Parsing and Xalan XSL Transformation

- XMLSpy and Xselerator Editors

Mr. Knight was responsible for the design and development of the

transaction feed and rate subsystems, including:

- participating in overall system architecture design

- incorporating Acord Insurance industry standards into Andesa XML

schema and Java objects

- developing class and document build utility (improved cycle time

1000%)

- implementing Java study sessions for staff development

The rate subsystem includes rate source entry, XML generation, binary file

generation and rate retrieval. The feed process converts insurance

transactions from proprietary client formats to Andesa's format.

Intermediate XML files and XSL transformation are used for this purpose.

Both subsystems are Java applications and incorporate XML schema.

Page 1

09/00 - 04/01: MetLife Insurance (Image & Workflow)

The MetLife Image and Workflow (I&W) department provides enterprise

document based-services primarily to support individual life insurance

business. The Turn Around Document (TAD) project delivers coordinated

document generation, distribution, scanning, indexing and workflow. TAD

focuses on documents that require client update and signed approval after

initial automated generation and before additional MetLife processing and

routing to receiving applications. The TAD product encompasses multiple

technologies including:

- Core Java, J2EE, Forte and Visual Basic Component Development

- Chordiant Workflow

- JetForm Document Generation and Transformation

- Oracle 8i Database Services

- Filenet Scanning and Indexing

- Business Objects Reporting

- Sun Solaris Servers, Windows NT Servers, Windows NT Workstations

Mr. Knight joined the TAD project team near the end of Phase I development.

He was the development team manager responsible for coordinating Java,

Forte, Visual Basic and Chordiant development. Mr. Knight also evaluated

potential TAD technologies including Digital Signatures and Smart Forms. He

also participated in planning and budgeting for future TAD phases as well

as reviews of architectural options including Enterprise Java Beans and

XML.

03/99 - 09/00: CIGNA Group Insurance

CIGNA Group Insurance (CGI) provides life, accident and disability

insurance products and services primarily to employees via employer plans.

CGI is implementing an Enterprise Document Generation and Management

(EDGE) Engine to provide automated outbound document services. This Engine

is part of a 3-tier architect and has two partitions. EDGE resources

including third party document generation and management tools are the

primary service producers. An EDGE Server augments services and manages

requests. The Server is an intermediary between CGI automated processes and

engine resources. It is a server-side Java application employing

Enterprise Java Beans and an XML interface.

Mr. Knight was the poject leader for EDGE conceptual design and the

technical leader for EDGE engine development.

The EDGE conceptual design phase included:

* Requirements, objectives and scope gathering, review and definition

* Preparation of a straw man architecture

* Evaluation and selection of vendors and products for document

generation, management and workflow

* Preparation of initial detailed design and development plans

The EDGE detailed design and development phase included:

* UML/Rational Rose design including Use Cases, Class Diagrams/Object

Model, Sequence and Activity Diagrams

* Document preparation for Server API, batch processing, XML Document Type

Definition, security, model document specification and server deployment

* Development of EDGE Server, Client Application Front End (CAFE) and Test

Harness utilizing:

-- NT Server 4.0, Internet Information Server 4.0, Websphere Application

Server 3.0

-- Visual Age For Java Integrated Development Environment 3.02, PVCS

Version manager

-- Core Java, EJBs, Servlets, JavaMail, JSPs, Java Beans, JNDI, Xerces

-- XMLSpy XML/DTD/XSL/Schema Editor, Jintegra Java to COM Bridge

-- Microsoft Sql Server 6.5 and Universal DataBase (UDB) 6.1

* Deployment of EDGE Resources

-- Calligo Assembly Server 2.1.1 and Livelink Document Management System

-- MQSeries, Connect Direct, Xenos PCL to AFP Transform

-- CIGNA Central Print/Mail Facilities

* Automated Server Testing Using WinRunner 6

Mr. Knight was most directly responsible for server development and his

hands on Java development focused on XML, JSPs and Servlets.

Page 2

04/96 - 12/98: The Vanguard Group

The Vanguard Group is one of the largest and most successful mutual fund

firms with over 400 billion dollars in client assets. Mr. Knight was a

consultant in the Core Infrastructure group which provides enterprise-wide,

reusable components and related services to Vanguard's application

development groups.

. Project architect for merger of Vanguard VBS Quotes and AutoBroker

telephony systems. Prepared architecture plan supporting three-tier

architecture with message communication via TCP/IP connections using

sockets protocol. Tier 1 provides client request capture and data

presentation services. It includes a PBX switch, multiple voice

recognition units (VRUs) and windows based workstations for client query

and report generation. Each VRU is a UNIX-based workstation running the

Oracle RDBMS and proprietary Conversant software from Lucent

Technologies. Report and transaction servers, both running Sybase System

11, comprise the second tier. Back end order processing, security

quotation and account maintenance services are provided by the third

tier. This tier includes a local db2 database as well as remote third

party quotes and order processing systems with links to the security

exchanges.

. Led development of automated test suites for Vanguard Core components

including the UI Framework, Inter-process Data Controller and Network

Data Services facility. Test suites were developed using Automated Test

Facility (ATF) scripts, capture utility and comparison utility along

with custom test harnesses created using Visual Basic.

. Assisted with review of options for implementing a remote call center at

client site to respond to account inquiries and requests for transaction

submissions. Major system options considered were adaptation of an

existing Web application, creation of a new Web application and

implementation of a subset of an internal call center application. Also

assisted with review of remote access options, risks and performance

considerations.

. Developed proof-of-concept prototype to access selected data via Visual

Basic's RDO facilities. Sybase data was accessed via stored procedures

and ad hoc queries. db2 data was accessed via a Sybase gateway using CICS

transactions. The transaction server prototype supports simultaneous,

asynchronous connections and queries, multiple result set generation and

query input parameters.

. Reviewed internet, intranet and client-server options for electronic

access of Vanguard and third party training material. Defined a strategy

to migrate from 1) interim client-server application with HTML export to

2) internet application to 3) intranet-to-intranet application. Developed

prototype for interim application using Visual Basic.

10/94 - 04/96: JP Morgan

Mr. Knight was a member of the support and enhancement team for the

CONQUEST system. CONQUEST processes forward, future, swap, option and swap-

option derivative deals involving energy and base metal underlying

contracts. It records market rates, captures and values trades, produces

accounting transactions and generates related notices and reports. CONQUEST

also shares rate and trade data with related JP Morgan systems.

CONQUEST is a multi-user application programmed using FoxPro, C routines

for valuation and Excel for ad hoc analysis. It runs on a Novell local area

network with Pentium-based trader workstations.

Mr. Knight was responsible for enhancing the futures rate entry, forwards

deal entry and accounting modules. His responsibilities included analysis,

design and coding as well as test planning and implementation. He also

developed a FoxPro to System Architect reverse data engineering facility.

09/93 - 10/94: American Express

The Travel Related Services (TRS) division manages one of the world's

largest corporate advertising budgets. Mr. Knight was a member of the team

that developed an Advertising Control and Tracking System (ACTS) to replace

the current TRS mainframe budget system.

ACTS is a client/server application employing SQL Server and FoxPro for

Windows and the Macintosh as the server and client platforms. Microsoft's

Open Database Connectivity (ODBC) provides FoxPro to SQL Server

communication. The ACTS development environment included an RS-6000 server

running IBM's AIX operating system and Sybase SQL Server. A second, Pentium-

based database server ran Microsoft SQL Server and OS/2.

ACTS was developed using the AMEX Code Book which consists of FoxPro

programs, supporting tables and programming standards. Mr. Knight was

primarily responsible for modifying the third-party Code Book to meet AMEX

requirements. Modifications include SQL Server access and update, table

driven maintenance and table versioning.

Page 3

Mr. Knight was solely responsible for developing a two part application

generator based on the AMEX Code Book.

Mr. Knight was responsible for coding selected FoxPro routines and related

SQL Server stored procedures. He also assisted with application data

modeling using System Architect. He created routines to transfer modeling

data from Information Engineering Facility (IEF).

06/93 - 08/93: Comtex Systems

Comtex is a leading provider of system development services to New York

City financial institutions. Mr. Knight and permanent Comtex staff

developed a Corporate Information Management System that identifies Comtex

relationships to individuals and other organizations. The system maintains

employee, project, assignment and time keeping records. It also generates

client bills.

The Comtex Corporate Information Management System is a multiple user

application programmed using Foxpro in a Novell environment. The project

team also used Microsoft Access for selected prototypes.

04/93 - 05/93: Bankers Trust (RSG)

The Retirement Services Group (RSG) of Bankers Trust Company provides

Trustee services for corporate, institutional and government retirement,

investment portfolios. RSG began a multiple year, multiple project effort

to migrate its account management systems to a client/server architecture.

Mr. Knight helped to complete the functional specifications for the Manage

Derivative Deals project. He also prepared screen prototypes using Visual

Basic.

09/92 - 01/93: Chemical Bank

The merger of Manufacturers Hanover Corporation and Chemical Bank

Corporation created one of the nation's largest banks with more than 30,000

employees. Mr. Knight was a member of the payroll consolidation consulting

team. He developed microcomputer based payroll distribution and help desk

systems, and related manual procedures.

Primary bank payroll applications and data resided on an IBM mainframe.

Local area network gateways and terminal emulation software provided

microcomputer access. Two Novell networks were used for distribution and

help desk system development. Both systems are multi-user applications

programmed using FoxPro.

08/91 - 09/92: Bankers Trust (CTAG)

The Corporate Trust and Agency Group (CTAG) of Bankers Trust Company

provides Trustee, Paying Agent, Registrar, Transfer Agent and other capital

market support services to its corporate, institutional and municipal

clients. The purpose of this project was to migrate the CTAG billing system

from an IBM mainframe platform to a local area network. Migration entailed

a total system rewrite including technical and functional enhancements. A

separate team converted existing data. The teams completed this year long

project within the planned budget and ahead of schedule.

Mr. Knight was the project leader of the development team. His

responsibilities included participation in system design and selection of

team members, on site supervision, team training, and consultation with

conversion team staff and the Bankers Trust technical support group. Mr.

Knight also participated in the planning of the conversion, system

documentation and user training efforts.

The development environment was a Novell/Token Ring network comprised of a

single IBM PS/2 server and 15 workstations. The production network

environment for this system has multiple servers and workstation access to

the Group's mainframe via 3270 terminal emulation.

09/89 - 07/91: Sotheby's

Sotheby's is a preeminent, international Auction House that offers rare art

and other valuable properties.

The technical environment for this client included 20 Ungermann Bass (UB)

local area networks using UB Net One Network Operating system software. 300

standalone and networked workstations were also included. Workstations

accessed the company's mainframe via UB and Attachmate terminal emulation.

Mr. Knight's first project required enhancement and modification of

Sotheby's client management system to consolidate a number of existing

versions.

The second and third projects for this client entailed development of

personnel and accounts receivable/billing systems for Sotheby's Restoration

Division.

Page 4

Mr. Knight also developed database and formatted text browse routines and

incorporated them into numerous Sotheby's systems. All systems used Clipper

and some text browse routines were written in PC assembler.

02/88 - 08/89: Shearson Lehman Commercial Paper Inc. (SCLPI)

SCLPI and related companies trade fixed income securities including

commercial paper, certificates of deposit and mortgage backed securities.

The technical environment for the three projects performed for this client

was based on 9 Token Ring/Novell local area networks. The more than 250

workstations accessed all servers and an IBM mainframe.

Mr. Knight was responsible for preparing a review of back office network

systems that covered the following applications: Accounts

Receivable/Payable, Bank Reconciliation, Backlog, Balancing, Cash

Management, Financial Reporting, Principal & Interest and Systems

Administration. Review topics included business background, systems and

user organization and personnel, network hardware and software, space

utilization and requirements, security and recovery, and application

functions, input, output and processes.

Mr. Knight also developed an accounts payable system for SCLPI and a

suspense account management (SAM) system for Hutton Resources Management

Inc. His responsibilities included system design (SAM only), programming,

testing and preparation of technical and user documentation. Both systems

were programmed using Clipper.

08/87 - 01/88: The Rockefeller Group, Inc.

The primary activity of the Rockefeller Group is management of Rockefeller

Center properties. Mr. Knight was responsible for developing an automated

lobby directory and events system for four Rockefeller Center buildings.

The technical environment for this application was comprised of 4 separate

Novell local area networks. There are three system modules, namely:

directory and events maintenance, lobby display and workstation monitoring,

Lobby graphics display and workstation monitoring were programmed in

assembler. Remaining lobby modules were programmed with Clipper and the

maintenance module was programmed with FoxPro. Mr. Knight was responsible

for system analysis and design, hardware and software specifications and

recommendations, programming, testing, preparation of technical

documentation and review of user documentation.

10/85 - 08/87: Broadcast Music Inc., (BMI)

BMI is the world's largest music licensing organization, representing more

than 80,000 writers and publishers. Mr. Knight participated in 5

microcomputer systems development projects for BMI. BMI's microcomputer

facilities included two Novell and two Macintosh-based local area networks,

approximately 50 PC workstations in 8 regional offices, and a number of

standalone Macintosh computers.

Selected workstations in the regional offices were operated remotely using

PC Anywhere for technical support and data transfer. IBM 3270 terminal

emulation software and hardware provided access to the company's IBM

mainframe.

Mr. Knight's BMI project responsibilities included:

. Design of legal infringement, license leads, license fees collection and

billing systems

. Supervision of programming, testing technical manual preparation and

installation for above systems

. Design, programming, testing and installation of a company wide personnel

system including personal and family

data, job classification, benefits determination, and salary and

performance review history.

. Development of programming tools and common utility and data maintenance

modules for above systems.

Page 5

Contact this candidate