William Stranges


Summary:

Technically oriented individual with nineteen years experience in data processing as a consultant and as a member or team leader within the corporate environment. Strengths include database design, tuning and administration, web development, application development, systems management, systems design, communications/presentation, organizational, and planning skills. Proficient in project management and technical level involvement.

Hardware

Digital VMS, Various Unix, SUN, Pentium, Alpha

Software

SYBASE, Oracle Designer 2000, Oracle RDB/SQL 6.1, DECNET, SQL Server, Unix, FMS, Fortran, Cobol, VMS 6.1,6.0, K shell, Microsoft Visual Basic 4.0, C, Interdev, ActiveX, VB and Jscript, MS Access, FrontPage, IIS,, Windows NT, Pathworks, CDD, CMS, DCL, ACMS,

Experience:

Database, Web and Client/server Specialist

1987 through 1998

.Database development and modeling

.NT

.Oracle 7

.Designer 2000

Contracted to perform database modeling of trading and clearance systems. Use of designer 2000 to develop metadata repository, process and functional flow, ER model and database logical and physical design. Heavy interface with business and technology to create an acceptable design that would deliver business requirements and work within limits of developer expertise and distributed processing boundaries of NT environment. This is a terabyte system, comprising active, inactive and archive data.

.Performance Tuning

.Unix

.Sybase 10, 11.5

Engaged to perform a system, database and application tuning exercise. Involved in system tuning – evaluating hardware and network throughput. Involved in database tuning – implementing performance techniques such as named caching, network polling, process counts, placement of objects, pool i/o size, etc. Involved in query tuning – evaluation of clustered versus non-clustered index usage, forcing of plans, modification of indices to introduce covering, implementation of temporary tables and stored procedures. Also involved in staff instruction and documentation of benchmark results.

.Web Development

.NT

.Visual Basic 5.0

.MS Access

.Interdev/FrontPage

.Small Business Ecommerce

Developed several web sites using FrontPage, Interdev, IIS, Index Server, Personal Web Server, NT 4.0 and win95. Extensive deployment of ActiveX controls to support interactivity; dynamic HTML and animation to enhance the user experience; and database content to provide substance and richness contributed to the success of each site. Responsible for technical web development, database design, and composition of the sites. Used VB 5.0 control creation edition for ActiveX controls. Active Server Pages were used for database connectivity.

.Application Development

.NT and Unix

.Visual Basic 4.0

.Crystal Reports

.MS Access

.Sybase

.Repurchase Trading

Developed a Visual Basic application to support the Matchbook Desk’s requirement for allocation of costs for carrying the firm’s position - Cost of Carry. This system relied upon a Sybase engine as a data repository, using stored procedures, constraints and triggers to calculate profit and loss and maintain syncronicity. Was responsible for database development, all stored procedures, entire visual basic application, Unix shell environment and C programming. The Cost of Carry system is a daily operation and the code was written to be as self sufficient as possible, requiring very little support. Reports were written with Crystal Reports Professional. Documentation produced included functional specification, technical documentation, test plan, and user and operations documentation.

The Visual Basic application was coded using objects and classes, an OLE server for reporting, Sheridan data widgets for grids, frames, etc. It was an online transaction processing server whose product were data for corporate books and records, and matchbook and other trading desks.

.Application Development

.NT

.Visual Basic 3.0

.Crystal Reports

.RDB/ACMS

.General Information Service

Developed and maintained a client-server application which supported a data repository. The database served over 300 users, and fifteen sister application trading systems with general business information regarding legal entity, T account structure and ownership, and other business grade data.

Heavy user involvement and development of reliable application was required to complete the task successfully.

 

 

.Database Optimization

.VMS

.RDB/ACMS

.Banking

 

Conducted exercises resulting in an optimized database (7 gigabyte) within the retail banking environment. Also, led to the upgrade of relational database management software, simultaneously. Focused on large storage areas, and those that were used frequently. Resized storage areas, split tables, reloaded all data, remapped data and index areas, modified global database parameters, added indices while making others more unique, reviewed application software and advised staff on database access techniques. (have performed similar upgrade and optimizations for other sites)

.Client server

.Windows NT/VMS

.Visual Basic/RDB/ACMS

.Bond Trading

Designed and developed a bond trading profit and loss aggregation and reporting system. Development included entire design and development of the relational database to be used. Used Visual Basic, Excel/VBA as front end development tools. The server was written in Fortran and ACMS, and accessed a VAX based relational database. The aggregation tool was also VAX based, written in C, and maintained the VAX database. Several complicated routines to calculate yields, prices and discounts were written in C for both VAX and Windows platforms.

Client server

Windows NT/UNIX/Sybase

PowerBuilder

Information Service

Participated in the database design and application development of a foundation grant information service tool. The standard front end was written in PowerBuilder. Served as application coder during development of stored procedures and front ends, and as DB design specialist during system requirements/specifications phases of the project.

.Client server

.Windows NT/VMS

.Visual Basic/C language

.Securities Analytics

Developed a securities pricing receipt system and database. The service system was written using C, Fortran and ACMS, accessing a VAX database specially designed for performance. The unique nature of the users’ requests required dynamic SQL to be employed heavily. Emphasis of the project laid upon speed and accuracy of data. Development tools were written using Visual Basic, MS Access (using ODBC), and Excel/VBA.

.Database design/devel

.VMS

.RDB

.Trading and Analytics

Served as database administrator and design specialist during the development of a large bond trading system. The application involved trade and static data entry/correction, clearance, splits and amends, extensive reporting, communication with exterior systems, and archiving. The database developed into a host to over 100 tables and more than one gigabyte of data. Conducted functional and logical modeling, prototyping and development of the database, and testing and exercising of the database during application development and optimization. Supported and trained technical staff during development regarding optimal coding techniques for databases. Heavy use of SQL and optimization skills.

.Database Optimization

.VMS

.C/Cobol/Fortran/ACMS

.Publishing

Undertook a four month database optimization of a VAX based, 5 gigabyte relational database. Activities involved complete database review and observation, stress testing, denormalization, system and user quota reviews/changes, and the introduction of clustering, hashing, area sizing, and the like. Next, the application routines were reviewed and modified to an extent that achieved the desired effect on response. Full documentation, including benchmark measurements and logical and physical diagrams, was created to present the project’s success and savings to executive management.

 

 

.Application development

.SUN/VMS

.C/Fortran/FMS

.Engineering

Designed and developed a multiplatform engineering schematic maintenance and requisition system. The SUN stations were used to develop diagrams, from which parts lists were withdrawn and transferred to a VAX based relational database. The lists would undergo further maintenance and be used for ordering, in single and composite manners. Once each list was production ready, it would then be transferred to an IBM system which supported mass production needs. Heavy relational database modeling and design, user involvement, and programming skills were necessary for a successful completion of the project.

.Systems programming

.Unix

.C

.n/a

Created a system to control the conversion of a source and object library, containing 5000+ programs. The system was written in C, and utilized SCCS. It's function was to perform low-level reads of object files, as created, and match them according to their check sum, or other characteristics, to the production version of the application.

.Database Optimization

.VMS

.C language

.Trading

Normalized an application's file structure from Sequential and Indexed RMS and PC files to a multifile Relational Database form. The normalization required a prototyping and tuning to be done, and a benchmark to be provided using RDB, RMS and PC files - over a local and wide area network. Pathworks, SQL, SQL/Services, VMS and C were used. A written benchmark document, with operations output, was provided to evidence the results. Used RMU utilities and logicals, DecNet parameters, and SYSGEN and Authorize parameters to successfully tune the database and establish a 'cookbook' for modifying the parameters as the database grew.

.Management

.VMS/AOSVS/Windows

.C/Cobol/SAS

.Healthcare

Retained as systems manager of multi-cpu, multi-vendor, (Digital Equipment/IBM PC/Data General), installation servicing two organizations. Staff - 30+ personnel - includes systems development, data operations, and statistical analysis departments. Duties involved database administration and design, specifications and systems analysis; application development, hardware, software/languages, communications evaluation and purchasing recommendation; departmental planning on a 1,2 and 5 year basis, and presentation to executive management of said plans and new concepts in written and oral form.

 

 

 

 

 

 

List of recent clients:

Barclays Bank Bertlesmann Group

Bankers Trust Financial Systems Technology Allied Signal

Citicorp Private Banking Group Jefferson Pilot Insurance

References and samples of work furnished upon request.


Member number:1880
Additional Contact information is available on the Information Page.
Return to The Software Contractors' Guild Home Page.
Copyright(c) 1997 William Stranges and The Software Contractors' Guild, Post Office Box 257, Nottingham, NH USA 03290-0257