|
Gary
A. Bonhiver
PROJECT
HISTORY
| CREDIT SUISSE FIRST
BOSTON |
01/2003
to Present |
| New
York, NY |
Employee, AVP |
| Intranet Application Developer |
|
Business:
|
Converted to CSFB employee in January 2003. Moved to Performance Mangagement group, which provides Global Technology Infrastructure division with sophisticated project management tracking tools and reports, production problem escalation facility, and many developer self-service registration and request tools. |
|
Project:
|
Intranet Web Application Development and Support |
|
Tasks:
|
-
Database Registration Tool: Modified sophisticated self-service tool for displaying and modifying contact information of related databases / applications. Added ability to designate individual and group email addresses for escalation notification emails.
-
Database Escalation Tool: Designed and developed tool for viewing relationships between applications, databases, servers, responsible DBAs related to current production problems. Builds, logs and sends escalation emails containing gathered information to operations and database contacts for resolving related problems. Query tool provides ability to flexibly monitor and report on current and past escalations.
-
Error Console Reporting Tool: Designed and developed tool for reporting counts, patterns, details of logged database and application errors.
-
Middleware Support Logging Tool: Designed and developed tool for middleware support team call logging, providing repository to describe call problems/resolutions and subsequent reporting.
-
Database Error Knowledgebase Tool: Designed and developed tool for DBAs to log common database error messages along with their resolution for subsequent research and use by other DBAs.
-
DBA Service Requests: Designed and developed DBA service request facility used by developers to request database services. Provides queue of active requests for DBA task assignment and recording of resolution/completion. Provided online management reports with very flexible selection criteria.
|
|
Project:
|
Tandem Support and Decommissioning |
|
Tasks:
|
-
Provide database, performance and overall technical support until Tandem is fully decommissioned.
-
Resident Tandem NonStop SQL expert and mentor.
|
|
System:
|
Sun Spark servers, Sun Unix; SYBASE Adaptive Server Enterprise, PERL, CGI, Cold Fusion, Javascript, Dynamic HTML, Business Objects, Exceed, DBArtisan. TANDEM Himalaya S72000/G06 server, NonStop SQL/MP, Enscribe, TM/MP, ODBC, DynaSQL, DynaScribe, CONTROL, PATHWAY, COBOL85, TACL, MEASURE. |
| CREDIT SUISSE FIRST
BOSTON |
11/2000
to 12/2002 |
| New
York, NY |
Contract
Consultant, via Stratem |
|
Business:
|
Retained by CSFB
when they purchased DLJ in November 2000. Assisted with
technology transition. Tandem-based applications for CSFB Fixed Income
back office operations, including Security Master, Principal and
Interest, Dividend and Interest, Name and Address, Clearance,
Allocations, 1099, Sungard Phase3, Financial Control and Audit, and many
smaller applications. Additionally supported Sybase data
warehouse and UDB applications, developed numerous intranet-based web
tools for the DBA group. |
|
Project:
|
Tandem Support and Decommissioning |
|
Tasks:
|
-
Supported physical system move from DLJ DR
site to CSFB production data center, and later switched machine use
between development and production. Provided database support for
operating system upgrades, remediation, testing, data movement and
implementation.
-
Supported moving business data off Tandem
DLJ applications over to corresponding CSFB applications.
-
Researched and documented remaining active/dead
applications and external data links.
-
Supported Tandem database interoperability in
a heterogeneous environment, involving many products and applications
using database gateways including ODBC, DynaSQL, DynaScribe, ISG
Navigator/Attunity Connect, FTP, NDM, connecting with Sybase on Sun and
NT, with Oracle on Sun, and with numerous external sources including
Bloomberg, Bond Buyer, Trepp, Pershing, Phase3. Assisted with
decommissioning these gateways as DLJ applications absorbed into CSFB
computing environment.
-
Supported Sungard Phase3 custom environment,
an in-house application based upon NDM feeds from Sungard
Brokerage Systems' Phase3 Securities processing service, for 4 CSFB
firms. Assisted with decommissioning 2 of these firms.
-
Monitored daily production, including database
management, performance analysis and tuning, problem research and
solutions.
-
Resident Tandem NonStop SQL expert and mentor.
|
|
Project:
|
Sybase/UDB Database Support |
|
Tasks:
|
-
Monitored and resolved batch/online performance and abend problems
-
Analyzed and tuned long-running queries
-
Applied database changes including sizing, permissions, schema updates.
|
|
Project:
|
Mainframe DB2 Support |
|
Tasks:
|
-
Analyzed features of QMF, QMF for Windows,
other similar reporting tools including possible in-house development,
made recommendation.
|
|
Project:
|
Intranet Web Application Development and Support |
|
Tasks:
|
-
Designed and developed tool for reporting counts, patterns, details of logged database and application errors.
-
Designed and developed tool for viewing relationships between applications, databases, servers, responsible DBAs. Builds and sends email containing gathered information to operations for resolving related problems.
-
Designed and developed tool for middleware support team call logging, providing repository to describe call problems/resolutions and subsequent reporting.
-
Designed and developed tool for DBAs to log common database error messages along with their resolution for subsequent research and use by other DBAs.
-
Designed and developed DBA service request facility used by developers to request database services. Provides queue of active requests for DBA task assignment and recording of resolution/completion. Provided online management reports with very flexible selection criteria.
-
Reviewed DBA group intranet site, updated outdated information.
|
|
System:
|
TANDEM Himalaya
S72000/G06 server, NonStop SQL/MP, Enscribe, TM/MP, ODBC, DynaSQL, DynaScribe,
CONTROL, PATHWAY, COBOL85, TACL, MEASURE. Sun Spark servers, Sun OS;
SYBASE Adaptive Server Enterprise, UDB, Cold Fusion, Javascript, HTML,
Exceed, DBArtisan. IBM mainframe, MVS; DB2, QMF. |
| GEORGE J. GOODSTADT, FINE ART PUBLISHERS |
08/2001 to 12/2002 |
| Ridgefield, CT |
Contract
Consultant (part-time), direct |
|
Project:
|
Web Site Enhancement - www.GeorgeJGoodstadt.com |
|
Tasks:
|
-
Added new artwork, web features to existing web site, matching original appearance
|
|
System:
|
UNIX web host server; HTML, Adobe Illustrator, BBEdit, FTP |
| BONHIVER AND COMPANY, ONLINE AUCTIONEERS |
10/2000
to present |
| Redding, CT |
Contract
Consultant (part-time), direct |
|
Project:
|
Corporate Image and web site design - www.BonhiverAndCo.com |
|
Tasks:
|
-
Created corporate image through web design, implemented web site.
|
|
Project:
|
Auction Layout and Posting |
|
Tasks:
|
-
Designed custom eBay auction template with corporate logo and image.
-
Post eBay auctions using custom template.
|
|
System:
|
UNIX web host server; HTML, Adobe Illustrator, BBEdit, FTP |
| PEOPLE FOR LEGAL AND NONSECTARIAN SCHOOLS (PLANS) |
08/2000
to present |
| San Francisco, CA |
Volunteer |
|
Project:
|
Web Site Redesign - www.WaldorfCritics.com |
|
Tasks:
|
-
Completely redesigned and implemented their web site.
-
Reorganized and moved old content to newly designed areas.
-
Coordinated gathering of new information from core team of international volunteers located around the world.
-
Managed process from inception to implementation.
|
|
Project:
|
Web Site Enhancement - www.DanDugan.com/Waldorf |
|
Tasks:
|
-
Added new articles, discussion list archives, etc. to original web site that was designed by founder of PLANS.
|
|
System:
|
UNIX web host server; HTML, Adobe Illustrator, BBEdit, FTP |
| GOODWINTER DATABASE ARCHITECTS, INC. |
01/2000
to present |
|
Project:
|
Corporate Image and web site design - www.GoodWinter.com |
|
Tasks:
|
-
Created corporate image through web design, implemented web site.
|
|
System:
|
UNIX web host server; HTML, Adobe Illustrator, BBEdit, FTP |
| DONALDSON, LUFKIN & JENRETTE |
08/1995
to 10/2000 |
| New
York, NY |
Contract
Consultant, via Stratem |
|
Business:
|
Tandem-based applications
in DLJ Fixed Income Division back office operations, including Security
Master, Principal and Interest, Dividend and Interest, Name and Address,
Clearance, Allocations, 1099, Sungard Phase3, Financial Control and Audit,
and many smaller applications. |
|
Project:
|
Database Interoperability
in Heterogeneous Environment |
|
Tasks:
|
-
Researched, prototyped, evaluated, and implemented
many products and applications using database gateways including ODBC,
DynaSQL, DynaScribe, ISG Navigator, FTP, NDM, Golden Gate replication,
Shadowbase replication, connecting with Sybase on Sun and NT, with Oracle
on Sun, and with numerous external sources including Bloomberg, Bond Buyer,
Trepp, Pershing, Phase3.
|
|
Project:
|
Y2K Analysis, Testing
and Implementation |
|
Tasks:
|
-
Focused on SQL and Enscribe database selection
and sorting issues related to Y2K problem identification, remediation,
testing, implementation, crossover, and post-crossover monitoring.
|
|
Project:
|
Dividend and Interest
Application |
|
Tasks:
|
-
Designed logical ERD and physical SQL database
architecture using systematic design methodologies.
-
Designed Data Access Layer subprogram architecture.
-
Coded most complex functions, including near-realtime
Stock Record.
-
Managed multiple database environments through
development
-
Continue to manage and maintain production application.
-
Configured and managed ODBC stored-procedure
environment.
-
Analyzed and designed next phase database and
application architecture.
|
|
Project:
|
SQL Database and
Query Design |
|
Tasks:
|
-
Resident SQL expert and mentor to multiple project
teams.
|
|
Project:
|
Database Standards |
|
Tasks:
|
-
Wrote detailed database naming standards document
-
Evaluated existing production and development
database environment, recommended changes for improving database identification,
consistency, design, management, performance monitoring and tuning.
|
|
Project:
|
Production Database
Management |
|
Tasks:
|
-
Daily monitoring, database management, performance
analysis and tuning, problem research and solutions.
-
Reviewed all SQL changes promoted into production.
|
|
Project:
|
SQL Singleton Select
/ Multiple Rows Returned Coding Repair |
|
Tasks:
|
-
Identified and documented SQL coding technique
known as "singleton select / multiple rows returned," highlighted its dangers
with upgrading operating system.
-
Led project to find, fix, and implement changes
for all occurences in production.
|
|
Project:
|
System Migration
From Cyclone/C30.09 To K20000/D36, And Later To S72000/G06 |
|
Tasks:
|
-
Provided database support for operating system
upgrades, remediation, testing, data movement and implementation.
|
|
Project:
|
Sungard Phase3
Custom Environment |
|
Tasks:
|
-
Documented, managed and improved in-house application
based upon custom NDM feeds from Sungard Brokerage Systems' Phase3 Securities
processing service, for seven DLJ firms.
|
|
Project:
|
Disaster Recovery
Review |
|
Tasks:
|
-
Focused on SQL and Enscribe database issues related
to disaster recovery data availability, maintenance and cutover.
|
|
Project:
|
Technical Interviews |
|
Tasks:
|
-
Conducted many Tandem technical interviews with
prospective employees, contract consultants, and consulting firms
|
|
Project:
|
Vendor Product
Reviews |
|
Tasks:
|
-
Analyzed and prototyped many prospective Compaq/Tandem
and third-party vendor products and services, provided recommendations
|
|
System:
|
TANDEM Himalaya S72000/G06,
S70000/G05, K20000/D36, Cyclone/C30.09, NonStop SQL/MP, TM/MP, ODBC, DynaSQL,
DynaScribe, CONTROL, ERwin, S-Designor, PATHWAY, COBOL85, TACL, MEASURE. |
| THE
SELECT GROUP, INC. |
01/1998
to 02/1998 |
| Oyster
Bay, NY |
Contract
Consultant (part-time), direct |
|
Project:
|
Technical Interviews |
|
Tasks:
|
-
Conducted Tandem technical interviews with prospective
consultants
|
|
System:
|
TANDEM technology |
| PITNEY
BOWES INCORPORATED |
12/1994
to 12/1995 |
| Stamford,
CT |
Contract
Consultant, direct |
| SQL
Database Administrator |
|
Project:
|
Postage By Phone
system, which tracks customer postage meter accounts. |
|
Tasks:
|
-
On retainer, assisted with planning, tuning queries,
and testing migration from C30 to D30 in multiple-node system involving
RDF-fed disaster recovery site.
|
|
System:
|
TANDEM K20000, VLX,
Cyclone, Pathway, COBOL85, SCOBOL, NonStop SQL, TMF, RDF, GPA, Tandem Reload
Analyzer (TRA), Object Monitoring Facility (OMF), Tacl. |
| AMERITECH |
09/1994
to 12/1994 |
| Southfield,
MI |
Contract
Consultant (part-time), via IDI |
|
Project:
|
Customer Usage
Tracking System (CUTS), a Decision Support System that gathers daily
phone call marketing information into a massive NonStop SQL database and
reports customer usage information for marketing department. |
|
Tasks:
|
-
On retainer, provided periodic NonStop SQL database
design and query design review and guidance to project team.
-
Reviewed initial design, discussed design issues.
-
Placed several consultants on project.
|
|
System:
|
TANDEM Himalaya K10000;
D30.01; NonStop SQL/MP. |
| NYNEX
COMPUTER SERVICES / NY Port Authority |
08/1994
to 07/1995 |
| Pearl
River, NY |
Contract
Consultant, via Lancaster |
| System
Architect, SQL Database Administrator, Programmer |
|
Project:
|
Computer Security
System (CSS) operates and monitors access points between public and
restricted areas at LaGuardia, Newark and JFK airports. Client-Server application
using Remote Server Call from OS/2 2.1 workstations. |
|
Tasks:
|
-
Designed System Monitor function, which provides
batch logging and online display of access point activity, logs events
to EMS, provides ability to alter EMS filtering via online screen.
-
Wrote complex COBOL85 server providing interface
between Line Handler and System Monitor user interfaces. Chose COBOL85
for this server to re-use many existing common functions that were also
written in COBOL85.
-
Fixed many bugs in badging system interface.
-
Provided NonStop SQL database management advice
and support.
|
|
System:
|
TANDEM CLX; C30.08;
NonStop SQL, Pathway, TAL, COBOL85, TACL; GFDX; Remote Server Call. |
| CELLNET
/ TANDEM TELECOM |
06/1994
to 08/1994 |
| Omaha,
NE |
Contract
Consultant, via Tandem TSvC |
| SQL
Database Test Analyst |
|
Project:
|
Fraud detection,
monitoring and management enhancement to Advanced Cellular Network
/ Location Register (ACN/LR) system for Cellnet in Great Britain. |
|
Tasks:
|
-
Wrote detailed test procedures and cases for
Fraud Monitoring subsystem.
-
Executed all test cases.
-
Evaluated NonStop SQL database and query design
and operations procedures for all subsystems, highlighted some problems.
-
Served as NonStop SQL expert for test team.
|
|
System:
|
TANDEM Cyclone/R,
C.O.; C30.10; TSCP-2000 Platform, LAN, Pathway, NonStop SQL, TACL; MS Word. |
| PITNEY
BOWES INCORPORATED |
05/1994
to 06/1994 |
| Stamford,
CT |
Contract
Consultant, direct |
| SQL
Database Administrator |
|
Project:
|
Postage By Phone
system, which tracks customer postage meter accounts. Uses Remote Database
Facility (RDF) to provide disaster recovery. |
|
Tasks:
|
-
Audited development and production environments
and procedures, focusing on NonStop SQL usage and management.
-
Wrote document detailing findings and recommendations
to improve environments and procedures.
-
Areas studied include: logical and physical database
design tools and procedures; primary and RDF backup production environments;
SQL database change evaluation, control, testing and migration; SQL catalog
statistics gathering, management and tools; SQL explain plan evaluation
procedures and tools; database integrity documentation and tools; defines
management; program object validity management; SQL table and index reorganization
analysis and procedures; SQL catalog reports; naming standards.
|
|
System:
|
TANDEM VLX, Cyclone,
Pathway, COBOL85, SCOBOL, NonStop SQL, TMF, RDF, Tandem Reload Analyzer
(TRA), Object Monitoring Facility (OMF), Tacl; Microsoft Word. |
| JOHN
DEERE & COMPANY / EDS / TandemTIES |
01/1992
to 03/1994 |
| Moline,
IL |
Contract
Consultant, via Sequent to Tandem TIES |
| SQL
Database Architect, System Architect |
|
Project:
|
Logistical Inventory
Control System (LINCS) is a complex integrated warehouse inventory
control system for the John Deere Parts Distribution Center and 11 regional
warehouses located across the U.S. and Canada, designed for Tandem NonStop
Cyclone/R and CLX/R computer systems utilizing NORAND radio-frequency hand-held
terminal and bar-code scanning technology. |
|
Tasks:
|
Responsibilities
at EDS facility in Flint, Michigan for first year:
-
System Architect and SQL Database Architect for
TIES for one year to provide technical guidance for overall system architecture
and SQL relational data base design, and to oversee EDS during the technical
design and coding phases of the project, reporting project progress and
technical issues to TIES.
-
EDS's team numbered over 100 system engineers,
supervisors and managers located in Flint, Troy, and Lansing, MI, and Denver,
CO.
-
Arranged and attended Physical Database Design
(PDBD) and Application Design (ADS) services at EDS.
-
Wrote NonStop SQL data base design and query
design documents describing standards and techniques.
-
Using sophisticated Excel-based transaction and
data base design model, analyzed to ensure that on-line time-critical transactions
were designed for high-performance and that heavy-hitting transactions
did not interfere with the performance of on-line transactions.
-
Assisted two EDS DBAs with logical and physical
data base design issues.
-
Led SQL query design training sessions and consulted
to EDS team.
-
Established development environment naming standards,
SQL DDL format, SQL Explain environment, and data base denormalization
change request review and disposition procedures.
Responsibilities at John Deere PDC facility
in Milan, Illinois for second year:
-
Relocated to the John Deere Parts Distribution
Center in Milan, IL, as the TIES project SQL DBA for integration testing
and implementation planning.
-
Highlighted many serious system design and coding
deficiencies that needed to be addressed by EDS, and assisted with the
formation and direction of teams to analyze and resolve problems.
-
Created and managed the many (about 15) testing
environments required for integration and formal quality assurance testing.
-
Reviewed and either approved or rejected new
data base changes.
-
Gathered production-simulated SQL catalog statistics
for the test environments to ensure that the SQL optimizer behaves as it
will in production.
-
Created SQL data base for the production system,
incorporating high-performance features such as table and index partitioning,
distribution of tables and indexes across disks to take advantage of the
parallel access paths through CPU/disk controller/disks, disk cache planning,
slack, etc.
-
Measured test and production systems for performance
problems, recommended technical solutions.
-
Reviewed hundreds of embedded-SQL query Explain
Plans for performance optimization, recommended query, program and database
solutions.
-
Assisted with the analysis, technical design,
testing, and implementation of system enhancements.
-
Directed interviews of over 50 technical consultant
prospects.
-
Trained two John Deere DBAs to take over tasks.
|
|
System:
|
TANDEM Cyclone/R;
Guardian C30.10, NonStop SQL, Pathway, COBOL85, SCOBOL, TMF, INSPECT, SQLCI,
SQL Report Writer, TACL, Measure, Enlighten, EMS, Transfer Queue Manager,
SQL/Explain Manager, SQL/DB Access, DSM/PM, PDBD Excel-based performance
model. |
| SAFEWAY
STORES, INC. |
10/1990
to 12/1991 |
| Oakland,
CA |
Contract
Consultant, direct |
| SQL
Database Administrator |
|
Project:
|
SQL Database Administration
forSafeway’s
DCMCS grocery distribution management system and COM store order processing
system that feeds DCMCS. |
|
Tasks:
|
-
Evaluated and implemented many NSSQL database
change requests for table modifications and for new tables, and recommended
solutions to serious database performance problems.
-
Planned and implemented database conversion for
major application installation and subsequent major enhancements in six
division nodes.
-
Evaluated and managed upgrading existing applications
to SQL release 2.0.
-
Managed over 10 development and six production
SQL database environments.
-
Developed NSSQL-based database to track outstanding
database change requests and implementation status.
-
Developed strategy for using CONTROL to manage
DDL versions, controlling table schema separately from environment-specific
sizing and partitioning commands.
-
Developed strategy and tools for manipulating
NSSQL catalog statistics to influence optimizer into choosing appropriate
access paths and to make development environments mimic production databases
without production-size tables.
-
Assisted systems group with restoring NSSQL environments
involved with disk crashes and planned disk maintenance.
-
Modified TACL-based tool for capturing EXPLAIN
plans and parsing them into an NSSQL database used for access plan analysis
reporting.
-
Isolated many NSSQL system bugs and initiated
Tandem Problem Reports.
-
Provided ongoing NSSQL consultation to the development
teams.
|
|
System:
|
TANDEM VLX, Pathway,
COBOL85, SCOBOL, NonStop SQL, SQLCI , SQL Report Writer, TMF, TACL, SQLDBM. |
| BOEING
COMPUTER SERVICES |
02/1990
to 09/1990 |
| Bellevue,
WA |
Contract
Consultant, via CPG |
| System
Architect, SQL Database Performance Tuning |
|
Project:
|
The Genesys system
is an artificial intelligence-based Computer-Aided Process Planning (CAPP)
system designed for the Boeing Fabrication Division Sheet Metal Center.
CAPP is the process of assisting a manufacturing engineer in converting
product requirements (engineering drawings, specifications, bills-of-material
and process standards) into production instructions (detailed process plan)
to be used on the factory floor to process raw materials into the desired
airplane part. The Genesys Management Subsystem (GMS) and Conversion Management
System (CMS) are customized versions of the Boeing Product and Process
Document Management (PPDM) commercial software product, providing sophisticated
version control, tracking and management of engineering plans and documents
as they flow through various stages of development and review. |
|
Tasks:
|
-
Wrote SQL ad-hoc reports and provided system
performance troubleshooting for CMS at Boeing Sheet Metal plant for several
months.
-
Joined GMS team as co-architect, customizing
Tandem-based CMS into GMS to manage VAX-based Genesys subsystems and data.
-
Evaluated and modified conceptual design and
wrote functional specification documents, working closely with other Genesys
subsystem teams and user analysts.
-
Provided overall Tandem architectural direction.
-
Wrote detailed design specifications for several
pieces.
-
Assisted other team members with detailed designs.
|
|
System:
|
TANDEM VLX, CLX, Pathway,
COBOL85, SCOBOL, TAL, NonStop SQL, TMF, EMS, TCP/IP, Transfer Queue Manager;
VAX VMS, VAX Document, VAX editors, VAX Notes, VAX Mail. |
| McKESSON
CORPORATION |
07/1989
to 12/1989 |
| San
Francisco, CA |
Contract
Consultant, direct |
| SQL
Database Administrator, System Administrator |
|
Project:
|
Pharmacy Order
Processing System. Existing order processing system was significantly
enhanced to accept electronic orders from hospital, chain and independent
pharmacies throughout the nation, and to provide an order verification
to the customer within 15 minutes, introducing NSSQL to the system architecture. |
|
Tasks:
|
-
Evaluated existing NonStop SQL database design,
environment and management procedures, and recommended and implemented
changes, including new development environment and naming standards.
-
Set up and maintained NSSQL catalog and utilities
for each environment.
-
Analyzed existing database design, noting deviations
from relational database standards.
-
Consulted programming teams in NSSQL environment
management and NSSQL usage within SQLCI and programs.
-
Developed procedures for migrating program source,
objects, TACLs, obey files, database definitions, copylibs through unit,
system and acceptance test environments and into production environment.
-
Evaluated move from split development on IBM
Roscoe and Tandem to total development on Tandem.
|
|
System:
|
TANDEM VLX, CLX, Pathway,
COBOL85, SCOBOL, NonStop SQL, TMF, Tacl, Safeguard; IBM 3090, Roscoe; WordPerfect,
MacDraw II. |
| SAFEWAY
STORES, INC. / Andersen Consulting |
04/1989
to 07/1989 |
| Alameda,
CA |
Contract
Consultant, via Andersen |
| System
Architect, SQL Database Designer |
|
Project:
|
Continuation
of Safeway Customer Order Management System. The
Safeway Customer Order Management system (COM) receives orders from stores
in a division and from other Safeway ordering systems and performs order
validation, routing, substitution, maintenance and analysis functions before
passing the orders to the DCMCS warehouse management system. |
|
Tasks:
|
-
Completion of the Safeway COM project (see Safeway
described below) was awarded to Andersen Consulting, where I continued
system architecture and database design.
-
Analyzed functional specification developed by
business analysts, recommending changes to better suit Tandem processing
environment.
-
Validated logical data model and scaled down
to phase 1 needs.
-
Developed logical data access models from functional
specification and logical data model, leading to physical data model, data
I/O specifications and NSSQL table definitions.
-
Analyzed TMF transactions and data concurrency.
-
Partitioned functional specification into physical
programs, including online Pathway requestors and servers, background queue-based
requestors and servers, NetBatch initiated batch servers, common subroutines,
system utilities and existing DCMCS programs to be modified.
-
Provided ongoing Tandem technical consultation
to project team.
-
Programs developed using Expression, a model-based
program generation product.
|
|
System:
|
TANDEM VLX, Pathway,
COBOL85, SCOBOL, NonStop SQL, TMF, Tacl, NetBatch, Expression; Excel, Design/1,
Method/1. |
| SAFEWAY
STORES, INC. |
04/1988
to 03/1989 |
| Oakland,
CA |
Contract
Consultant, direct |
|
Project:
|
Customer Order
Management System. The Safeway Customer Order Management system (COM)
receives orders from stores in a division and from other Safeway ordering
systems and performs order validation, routing, substitution, maintenance
and analysis functions before passing the orders to the DCMCS warehouse
management system. |
|
Tasks:
|
-
Evaluated grocery store order processing package
(DCOPS) that was originally developed for the IBM 8100 and then converted
to the Tandem environment.
-
Identified many serious architectural problems
and recommended writing custom order processing system.
-
Attended McDonnell-Douglas Stradis Derived Design
class in preparation for developing the project using the Stradis methodology.
-
Evaluated CASE tools including Prokit, Expression,
Vista/Foundation.
-
Developed PC Cobol and RBase tools to provide
improved Prokit reporting.
-
Led team in developing high-level system architecture,
following the McDonnell-Douglas Stradis Outline Physical Design (OPD) methodology.
-
The first OPD step involved evaluating and recommending
changes to the high level functional specification (DRS), which consisted
of a fully populated DFD and process descriptions.
-
Subsequent steps followed the OPD derived design
rules, analyzing the DRS and factoring and partitioning the functionality
into design units, where each design unit had the same operating characteristics,
and each design unit generally corresponded directly to a program.
-
Completed three Tandem self-paced NSSQL classes.
-
Performed detailed state transition analysis
on the store order entities, showing all possible states and transitions
that an order and its related entities could go through.
-
Developed requirements for an order database
shared by COM and the DCMCS warehouse system.
|
|
System:
|
TANDEM VLX, Pathway,
COBOL85, SCOBOL, NonStop SQL, TMF, Tacl, Expression; Stradis physical design
methodology; Prokit, RBase, PC COBOL; Macintosh SE, MacDraft, MacDraw II,
Microsoft Word, Excel. |
| BANK
OF AMERICA |
01/1987
to 03/1988 |
| Concord,
CA |
Contract
Consultant, via TransNet |
| System
Analyst, Designer, Test Team Leader |
|
Project:
|
Fedwire Processing
System Enhancement to Domestic Money Transfer Application System.
Major
software release that incorporated new Fedwire functionality into BofA's
MTA domestic electronic wire funds transfer accounting system to support
new Fedwire interface system. |
|
Tasks:
|
-
Researched detailed user requirements based on
minimal documentation, wrote functional specification, design specification,
and detailed program specifications for on-line Fedwire Debit Advising
functionality.
-
Designed documentation formats for functional,
design, and detailed program specifications; wrote detailed instructions
for other analysts and designers.
-
Organized, tracked, edited and reformatted functional,
design, and detailed program specification sections written by other analysts
and designers; wrote introduction, project overview, document modification
history, table of contents, and appendices, and published each document;
continued in this role for several subsequent document version publications.
-
Developed detailed test plans and schedules for
all test phases, including integration, network, production simulation,
implementation fallback, user acceptance, and installation certification
tests, all of which involved testing major new functions and extensive
regression testing.
-
Coordinated MTA testing requirements with other
interfacing systems in network.
-
Designed test specification and test case formats,
wrote instructions for test analysts, and directed test analysts in development
of test specifications, cases and test data.
-
Created test environment, managed and executed
tests, and tracked software fixes resulting from tests.
-
Provided ongoing technical consultation to manager
and other team members.
-
Employed Apple Macintosh software tools in all
phases of development.
|
|
System:
|
TANDEM TNS-II, TXP,
Enscribe, Pathway, COBOL, SCOBOL, TAL, Enform, Enable, DDL, Exec, Tacl,
Fastrax; Apple Macintosh, MacProject, MacDraw, MacWrite. |
| WELLS
FARGO BANK |
07/1986
to 12/1986 |
| San
Francisco, CA |
Contract
Consultant, via PRC |
| Lead
QA Technical Analyst, Tutor, Technical Consultant |
|
Project:
|
Trust Operations
Support System (TOSS). TOSS tracks
securities transactions for the Trust department. |
|
Tasks:
|
-
Evaluated existing QA testing environment and
program module library procedures, recommending modifications necessary
for tighter controls.
-
Rewrote program library control system using
Exec and Tal, converted program library environment.
-
Developed many QA toolsusing Exec, Enform, Enable,
Inspect, and Encore to automate setting up, running and validating QA tests,
and promoting accepted software to production.
-
Tutored non-programmer QA staff to use Tandem
system utilities.
-
Provided ongoing technical assistance to programming
staff.
-
Executed extensive system and acceptance tests.
|
|
System:
|
TANDEM TXP, Pathway,
COBOL, SCOBOL, TAL, Enform, Exec, Enable, Inspect, Encore. |
| TICKETWORLD |
04/1985
to 07/1985 |
| Cupertino,
CA |
Contract
Consultant (part-time), direct |
| Database
Designer, Programmer |
|
Project:
|
Ticket Reservations
System |
|
Tasks:
|
-
Designed and coded requestors, servers and reports
for first phase.
-
Assisted with database design of second phase,
which added season-ticket reservations/sales to the single-event ticket
system.
|
|
System:
|
TANDEM TNS-II, Pathway,
Cobol, Scobol, Tal, Enform, Pathaid, DDL, Enable. |
| WELLS
FARGO BANK |
10/1984
to 06/1986 |
| San
Francisco, CA |
Contract
Consultant, via SFSystems |
| Lead
Systems Analyst and Designer, Programmer |
|
Project:
|
Loan Application
Processing System (APS). The Application Processing System tracks and
analyzes consumer loan applications for auto, boat, airplane, personal,
line of credit, and real estate loan products. APS was being redesigned
to provide a system structure that is easier to modify to quickly accommodate
the rapidly changing loan marketplace. |
|
Tasks:
|
-
Developed project plans and charter, coordinated
and performed current system study of Tandem-based application involving
four user groups and seven operation centers.
-
Produced high-level user requirements and system
design, incorporating data flow diagrams and dictionary, entity-relationship
data analysis, state-transition analysis, online screen design, and program
structure diagrams.
-
Worked on several short-term design and programming
projects that upgraded current application processing system to support
urgent business needs.
-
Provided ongoing technical consultation for various
current-system production problems and enhancements; carried beeper for
on-call production support.
-
Modified various current system programs to support
Wells Fargo-Crocker merger.
-
Evaluated Excelerator PC-based CASE tool.
|
|
System:
|
TANDEM TNS-II, TXP,
VLX in a five-node state-wide network, Pathway, COBOL, SCOBOL, Enform,
Exec, Enable, DDL, Pathaid. |
| KNAUER
COMPUTER CONSULTING |
10/1983
to 10/1984 |
| San
Francisco, CA |
Senior
Staff Consultant, employee |
| System
Analyst, Designer, Programmer |
|
Project:
|
STANDARD OIL OF
CALIFORNIA, COS Oil and Gas Allocation System. |
|
Tasks:
|
-
Converted several complex report programs from
Mark IV to PL/X
|
|
System:
|
IBM 3033, 370, VP/CSS,
OS/MVS, CASE TS/X. |
|
Project:
|
WELLS FARGO BANK,
Consumer Credit Division, Express Automobile Lease Accounting system. |
|
Tasks:
|
-
Designed, coded and enhanced many new and existing
Cobol/Scobol requesters and servers, Cobol batch programs, and Enform report
programs
|
|
System:
|
TANDEM TNS-II, Pathway,
Cobol, Scobol, Enform, DDL, Pathaid, Enable, Exec. |
|
Project:
|
CONTROL DATA CORPORATION,
Small Bank Service Bureau system. |
|
Tasks:
|
-
Analyzed customer information file requirements
and wrote portion of Functional Specification that detailed the online
screens.
|
|
System:
|
IBM 370, OS/MVS, TSO/SPF,Script |
|
Project:
|
WELLS FARGO BANK,
Auto Lease Center, Automobile lease tax reports. |
|
Tasks:
|
-
Designed and coded automobile lease tax reports.
|
|
System:
|
ALEXIS system on NCSS
Timesharing Network, Basic. |
| DATA
ARCHITECTS, INC. |
01/1982
to 09/1983 |
| San
Francisco, CA |
Staff
Consultant, employee |
| QA
Manager, Team Leader, Data Communications Programmer |
|
Project:
|
GTE/SPRINT CORPORATION,
Call History Information Processing System (CHIPS) |
|
Tasks:
|
-
Wrote system and acceptance test plans.
-
Led team of seven analysts in designing acceptance
and system test scripts.
-
Developed quality assurance guidelines and controls
for project.
-
Technical consultant to development team.
|
|
System:
|
TANDEM TNS-I, TNS-II
in 31-node network across country, Pathway, Tal, Cobol, Scobol, Enform,
Enable, Envoy, DDL, Pathaid. |
|
Project:
|
CROCKER NATIONAL
BANK, International Division, SWIFT/Computer Bank Terminal (CBT) interface
for DAI's BESS Wireroom/Payments Automation product. |
|
Tasks:
|
-
Led team of eight programmer/analysts in development
of subsystem.
|
|
System:
|
TANDEM TNS-I, TNS-II
in 5-node network across world, Pathway, Tal, Cobol, Scobol, Envoy, Pathaid,
Enform, Enable, DDL. |
|
Project:
|
CROCKER NATIONAL
BANK, International Division, Intra-day Account Balance Reporting System |
|
Tasks:
|
-
Developed nonstop multi-threaded line handler
program using finite-state automata design, supporting full-duplex real-time
X.25 packet-switch data communications between CNB's TANDEM TNS-II and
ADP's timeshare network.
|
|
System:
|
TANDEM TNS-II, Pathway,
Tal, Axcess, Cobol, Scobol, TMF, Nonstop. |
| FINANCIAL
SECURITIES CORPORATION |
09/1981
to 11/1981 |
| Corte
Madera, CA |
Contract
Consultant, direct |
|
Project:
|
Security Trades
Tracking System |
|
Tasks:
|
-
Developed non-Pathway full-screen online programs
|
|
System:
|
TANDEM TNS-I, Tal. |
| THE
CAMERON GROUP, INC. |
12/1980
to 09/1981 |
| San
Francisco, CA |
Staff
Consultant, employee |
| System
Analyst, Designer, Programmer |
|
Project:
|
WELLS FARGO BANK,
Merchant Services, batch bankcard processing system |
|
Tasks:
|
|
|
System:
|
IBM 370, OS/MVS, TSO/SPF,
Cobol |
|
Project:
|
WELLS FARGO BANK,
Proof of Deposit, Online Reconciling System |
|
Tasks:
|
-
Designed and coded batch report programs
|
|
System:
|
IBM 370, OS/MVS, TSO,
Cobol |
|
Project:
|
WELLS FARGO BANK,
Automated Teller Machines |
|
Tasks:
|
-
Designed and coded batch beginning of day installment
loan update program
|
|
System:
|
IBM 370, TSO/SPF,
Cobol |
|
Project:
|
CAMERON, In-House
Accounting Automation |
|
Tasks:
|
-
Installed Peachtree accounting software, customized
several Peachtree programs.
|
|
System:
|
Apple II, CP/M, C-Basic,
M-Basic. |
|
Project:
|
Attended Tandem
classes. |
|
Tasks:
|
-
Concepts and Facilities, COBOL, Pathway, TAL
|
|
System:
|
TANDEM TNS-I |
| DR.
SAM ROSENBERG, U.C. DAVIS ECONOMICS PROFESSOR |
06/1979
to 12/1981 |
| Berkeley,
CA |
Contract
Consultant (part-time), direct |
| System
Analyst, Designer, Programmer |
|
Project:
|
Worker Upward Mobility
Study |
|
Tasks:
|
-
Produced statistical analysis programs using
computer facility at Lawrence Berkeley Labs
|
|
System:
|
CDC 7600, 6600, 6400,
BKY/Scope, Fortran IV, SPSS |
| INNOSYS,
INC. |
01/1979
to 11/1980 |
| Berkeley,
CA |
Staff
Consultant, employee |
| System
Analyst, Designer, Programmer |
|
Project:
|
INNOSYS, In-house
Accounting Automation |
|
Tasks:
|
-
Installed Structured Systems Group accounting
software package
|
|
System:
|
Northstar Horizon
S-100 bus microcomputer |
|
Project:
|
AMERICAN PRESIDENT
LINES, Ship Cost Accounting system |
|
Tasks:
|
-
Developed detailed report programs
|
|
System:
|
IDC timesharing system,
XDMS database language |
|
Project:
|
BLUE CROSS OF NORTHERN
CALIFORNIA, Medicare Provider Payment system |
|
Tasks:
|
|
|
System:
|
IBM 370, TSO/SPF,
Cobol |
| PACIFIC
GAS AND ELECTRIC COMPANY |
06/1978
to 09/1978 |
| San
Francisco, CA |
Summer
Intern, employee |
| System
Analyst, Designer, Programmer |
|
Project:
|
Economic Rate Case
Model |
|
Tasks:
|
-
Designed and coded report development system
|
|
System:
|
IBM 370, TSO, PL/1 |
| U.C.
BERKELEY SCHOOL OF ARCHITECTURE |
04/1978
to 06/1978 |
| Student
Teaching Assistant |
|
Class:
|
Computer Applications
In Architectural Design |
|
Tasks:
|
-
Tutored architecture students enrolled in class
|
|
System:
|
TERAK microcomputers,
Basic, MU-Basic (with enhanced graphics). |
|
