|
|
Andy Cohen
Software Engineer
|
Tilden Park Software
2808 Adeline Street, #1
Berkeley, California 94703
510-843-0839, ext. 3
acohen@tildenpark.com
|
Java, SQL, HTML, C, Perl, JavaScript
WWW, JDBC, CGI, RDBMS, TCP/IP, Client/Server, Unix, Sybase, Oracle, PostgreSQL,
Clarify, Windows 95, Windows NT, Windows 3.1, DLL, GUI, Open Server,
Open Client, DB-Library, Kerberos, Sun, AIX, RS/6000
An opportunity to use my Internet, Java, TCP/IP, RDBMS and
client/server software development experience to help you meet your
business needs by designing custom Java interfaces to systems of
record, designing specialized databases, and constructing Java server
and client application software.
|
|
|
|
October 1997 to Present
Consultant,
Tilden Park Software, Berkeley, CA
See the details.
|
|
|
|
October 1995 to October 1997
President,
Cohen Software Development Services, Oakland, CA
See the details.
|
|
|
|
September 1993 to October 1995
Senior Consultant,
Context Integration, Emeryville, CA
See the details.
|
|
|
|
October 1985 to September 1993
Senior Software Engineer,
Sybase Inc., Emeryville, CA
See the details.
|
|
|
|
September 1983 to September 1985
Software Engineer,
Lucasfilm Ltd./The Droid Works, San Rafael, CA
See the details.
|
|
|
|
July 1981 to September 1983
Senior Scientific Programmer,
Lockheed Missiles and Space Company, Sunnyvale, CA
See the details.
|
|
|
|
|
|
|
|
October 1997 to Present
Consultant,
Tilden Park Software, Berkeley, CA
|
Java, JDBC, SQL
|
Tapstone, Walnut Creek, CA
|
|
Implemented the persistence layer of the Tapstone
Server Change Center, a system which keeps track
of large numbers of server configurations in an
organization, and continuously compares those
configurations for compliance with model configurations.
|
|
Java, JDBC, SQL
|
Stanford University, Stanford, CA
|
|
Designed and implemented an event-driven business-rules server
to control the life-cycle of contracts for Stanford University
IT services.
|
|
Java, JDBC, RDBMS, SQL, HTML, HTTP, HTTPS, Cookies
|
Portera Systems, Berkeley, CA
|
Designed and implemented the authentication system for
Serviceport, Portera's flagship product, and extended that
authentication system to unify additional software modules
from various vendors.
I completed part of this project as an employee of Portera
Systems.
|
|
Java, JDBC, SQL, C, ODBC
|
|
|
Designed and implemented the Tilden Park Bridge, an ODBC driver
that allows standard ODBC-compliant programs to access JDBC-only
databases.
|
|
|
|
|
October 1995 to October 1997
President,
Cohen Software Development Services, Oakland, CA
|
Java, LDAP
|
Stanford University, Stanford, CA
|
|
Designed and implemented a pure-Java directory-service gateway
to provide LDAP directory access to whois-compliant client
programs.
|
|
Java, JDBC, RDBMS, SQL
|
Stanford University, Stanford, CA
|
|
Designed and implemented a pure-Java database gateway server
to allow legacy applications to interact with relational
databases.
|
|
WWW, CGI, Perl, HTML, RDBMS, SQL, Clarify, Sybase
|
UB Networks, Santa Clara, CA
|
|
Wrote SQL stored procedures, Perl programs and HTML pages to
add new functionality to the WWW interface of the Clarify
call-tracking system.
|
|
Java, JDBC, SQL, Sybase, Windows 95, NT, GUI
|
Alta Bates Hospital, Berkeley, CA
|
|
Designed and implemented a Java application that takes a
partial name from the user and retrieves matching names, pager
numbers and voice numbers from a Sybase database.
|
|
C, Sybase Open Server, SQL, Unix
|
Sybase Inc., Emeryville, CA
|
|
Defined high-level product requirements for a
sort-order-translation gateway server. This server sorts SQL
Server results according to Thai language rules, for use by
Sybase customers in Thailand.
|
|
C, Kerberos, Windows 3.1, Unix
|
Sybase Inc., Emeryville, CA
|
|
Ported Kerberos-related portions of Sybases Open Client and
Open Server internals code from Sun Unix to HP-UX and Windows
3.1.
|
|
SQL, Sybase, Windows NT
|
San Francisco Dept. of Public Health,
San Francisco, CA
|
|
Designed and implemented a SQL Server schema and associated
stored procedures to serve as the back end to a city-wide
registration system for recipients of AIDS-related services.
|
|
WWW, CGI, C, SQL, Sybase, Unix, Clarify
|
Sybase Inc., Emeryville, CA
|
|
Wrote new SQL scripts and modified existing SQL scripts
and C programs to interface a Clarify tech-support
call-tracking system to the World Wide Web.
|
|
|
|
|
September 1993 to October 1995
Senior Consultant,
Context Integration, Emeryville, CA
|
C, Sybase, Open Client, Open Server, DB-Library
|
Sun Microsystems, Milpitas, CA
|
Taught these Sybase classes to Sun's in-house support staff:
- DB-Library
- Open Server for DB-Library
|
|
C, Sybase, Open Server, AIX, RS/6000
|
Alta Bates Hospital, Berkeley, CA
|
|
Designed and implemented a custom Open-Server-based gateway
program which makes data from RPG programs on an IBM AS/400
accessible to standard Sybase client programs.
|
|
C, Windows 3.1, DLL
|
Alta Bates Hospital, Berkeley, CA
|
|
Designed and implemented a custom DLL to perform data-parsing
functions for a PowerBuilder program.
|
|
C, Sybase, Open Server, Unix
|
Stanford University, Stanford, CA
|
|
Designed and implemented the Mandarin/Sybase dispatcher, a
custom Open-Server-based gateway program which makes data in a
Sybase SQL Server accessible to Mandarin clients. Stanford is
a member of the Mandarin Consortium, a group of universities
which work together to develop and extend the Mandarin
client/server development system.
|
|
C, Sybase, Open Server, Unix, Legacy Data
|
Stanford University, Stanford, CA
|
|
Designed and implemented FOSDIC, a custom Open-Server-based
gateway program which makes data in a proprietary mainframe
database accessible to standard Sybase client programs.
|
|
Internet, TCP/IP, C, SQL, Sybase, Unix
|
Stanford University, Stanford, CA
|
|
Designed and implemented the Portfolio Server, a multi-user
server which allows its clients to browse through hierarchical
collections of documents, queries, and applications, and to
retrieve information from heterogeneous data sources via
multiple client protocols via both the campus-wide network and
the Internet. The Portfolio Server uses the Sybase SQL Server
as its metadata repository.
|
|
|
|
|
October 1985 to September 1993
Senior Software Engineer,
Sybase Inc., Emeryville, CA
|
C, SQL, Sybase, Unix
|
|
Specified, designed, and implemented new features for the Sybase
SQL Server:
-
Added new SQL keywords and statements for ANSI SQL
compatibility.
-
Added chained and serializable transactions for ANSI SQL
compatibility.
-
Allowed DDL (Data Definition Language) statements inside
user-defined transactions.
-
Added new information to system tables to facilitate
distributed deadlock detection.
|
|
C, TCP/IP, Sybase, Unix, VMS
|
|
|
Specified, designed, and implemented Net-Library, an API
which provides a platform-independent and protocol-independent
interface to transport-layer network services. Responsibilities
included the design and implementation of all
platform-independent code, and coordination of the efforts of
3 other engineers, who worked to adapt Net-Library to Sun Unix,
VAX VMS, and OS/2.
|
|
C, TCP/IP, Sybase, Open Client, DB-Library, Unix, VMS
|
|
Produced new releases of Sybase's DB-Library product. DB-Library
is an API which allows application programmers to send SQL
queries across a network to the Sybase SQL Server, and to
interpret the tables and other results which are returned by
the SQL Server. Improvements in these new releases included:
-
Internationalization.
-
TEXT and IMAGE data types, to handle very large data items.
-
Redesign of some DB-Library interfaces to improve usability
and functionality while maintaining compatibility with the
installed customer base.
-
Other bug-fixes and new features.
|
|
C, SQL, Sybase, Open Client, DB-Library, Unix
|
|
Specified, designed, and implemented window-oriented tools for
database administration. These tools, all part of the Sybase
Data Workbench, include:
-
A data-dictionary tool, which allows users to examine
databases, tables, columns, rules, defaults, triggers,
and stored procedures.
-
A front-end to Sybase's database consistency checker, which
discovers and repairs corruptions in database files.
-
A history-list mechanism, which allows users to recall,
edit, and re-run a sequence of queries.
|
|
|
|
|
September 1983 to September 1985
Software Engineer,
Lucasfilm Ltd./The Droid Works, San Rafael, CA
|
C, Unix, GUI
|
|
|
Participated in the design, development and demonstration of
EditDroid, a large video editing system which included a
network database, a window-oriented bitmap graphics device,
and real-time control of video equipment. Primary areas of
responsibility included the console- and graphics-based user
interface, and software modeling of the process of conventional
film editing.
|
|
|
|
|
July 1981 to September 1983
Senior Scientific Programmer,
Lockheed Missiles and Space Company, Sunnyvale, CA
|
Ada, GUI
|
|
|
Explored new directions in interactive, device-independent
graphics and dynamic window-oriented user interfaces for the
prototype of a system which included database, communication,
and data analysis facilities.
|
|
Assembly Language
|
|
|
Wrote assembly-language components of a system which
transferred data packets via satellite.
|
|
|
|
|
|
|
|
|
1977 to 1981
Washington University, St. Louis, MO
|
|
|
BS Computer Science
BS Electrical Engineering with a major in Applied Science
|
|
|
|
|
|
|
|
|
|
|
Summer 1995
Sybase Server Magazine, a publication ofThe International Sybase User Group
|
|
|
|
Building Custom Open-Server Gateways
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Excellent references are available upon request.
|
|
|
|
|
|
|
|
|
|
|
|
|
|