Resume

David C. Goodall

Kintana (HP PPM) Developer Administrator

279 Leslie Ct #2, Mountain View, CA, 94043
Cell: 714 270 2252
www.ezds.com
dave.goodall@gmail.com

Canadian Citizen
Permanent Resident Status

SUMMARY Change Management, Configuration manager, Software developer, Systems programmer, Web developer.

Specialities : Kintana / Mercury ITG / HP PPM, ( Demand, Deliver, OM, ) Starbase / Starteam, SourceSafe, ClearCase, Intranet Content Management, InstallShield.
Languages : C, C++, C#, Assembler
Platform : Windows 2003 / Intel
Shell Scripting : Dos command, Unix Bourne and Bash.

Hewlett Packard PPM 7.1 ( Kintana / Mercury ITG) installation teamed with CVS version control system. Sun Solaris servers. Oracle 11i.

I provide PPM technical support to the Deloitte & Touche consulting team engagement at Sun Microsystems.

This has included analysing the major PPM deployment workflows and preparing recommendations for re-architecting them to meet current business needs.

I have also developed numerous custom sql queries, PPM custom reports, and PL/SQL stored procedures.

One of these supports the association of package-line migrations to demand requests. HP's built-in capability only associates packages to demand requests which is insufficiently granular.

Installed ZDS Corporations's metrics packages to measure the service levels of the Deployment and Demand modules. These provide deep insight into the quality of the Change Management operation, and precisely quantify the areas that need improvement.

Administrator Hewlett Packard PPM 6.0 ( Kintana / Mercury ITG) installation teamed with Borland's StarBase 2005 R2 version control system. The applications run on Windows Server. The database and target servers are on Oracle 11i / HP-UX Unix.

Wrote the StarBase access sql used by the Kintana command scripts and validations. I had to reverse engineer StarBase to do this as Borland do not provide a database schema!

Developed Kintana Demand (IT Collaboration) and Deliver ( Forms Personalization and Promotion Performance Group) workflows and objects to transport objects not currently supported by Kintana : XML Publisher, XML Workflow etc.

Starting from the scruffy handwritten note pad I inherited I have created to date 84 process documents detailing the operation of various parts of the system. This information base is shared with the other team members with Dave's web-based, searchable content management system.

Mercury's implementation of delegation is incomplete and buggy. I developed a trigger which provides the missing functionality. It generates emails and update requests when a request is delegated.

I drastically cut migration failures and system maintenance by condensing many variant object command code scripts into a single set of special commands.

Following upgrading the installation to 6.0 separating the Kintana (Windows) and (HP-UX Oracle 11i ) database servers, I have implemented a fully SOX compliant access security model.

Kintana Administrator providing support to a large (1400+ user) multiple Demand/Create workflow Mercury IT Governance (Kintana) 6.0 installation.

Ongoing request object and workflow updates and maintenance. Developed custom SQL and PL/SQL queries. Wrote Kintana Administrator procedure manual.

Tools: Embarcadero, Toad, Remedy, Sargento.   Databases: Oracle, Sybase

Developed a commercial 'ZDS Search for SourceSafe'product targeted at very large SourceSafe installations. The latest version of this product (1.43) was released on my site www.ezds.com on September 27, 2004. The design is based on a server, typically running under IIS, delivering search results to client browsers. It is written in 'C' and assembler.

The site has also developed over this period to contain over a hundred and fifty pages of configuration management content and many free tools and SQL scripts. The content management system that generates the site, and the site search engine were also written by me. The site is XHTML and CSS compliant.

The InsWeb environment is Windows 2000 Server, IIS, Visual C++, some Java, SQL Server, and one Oracle database.

Configuration Management team lead

I developed InsWeb's process automation strategy. When I joined the company they were using a version control system with some ad-hoc in-house tools.

When I left, they were running an automated work flow system to build, migrate, and track web page, application program, and database script changes for different product releases through multiple standardized environments (DEV, QA, Customer Acceptance, Agency, Training, Production), supported by over a hundred pages of on-line process documentation on the company Intranet.

I brought in Kintana Corporation's work flow system and used Create and Deliver to automate the software development life cycle. Kintana's work flow products are written in Java and run on an Oracle Server.

I designed and implemented work flows using Kintana Create to track the software development process from initial business requirement to release, and Kintana Deliver to migrate daily builds into the various environments. I wrote numerous bash shell scripts to run under the work flows, and many 'c' based tools to run off the scripts : for example, version stamping for exe's and dll's, a wrapper for SourceSafe command line tools, flag checking etc etc.

As tools engineer for the Configuration team I wrote numerous C, C++, and ring 0 driver utilities to automate daily management of the SourceSafe database, and PL SQL scripts to support the Kintana database.

I migrated both the Kintana and SourceSafe databases though many upgrades and splits.

I wrote a high performance search engine to index the corporate Microsoft SourceSafe database ( 90,000 files, 7.7GB, 3-30 millisecond response, 800 million raw tokens, 1.5 million terms).

I wrote a content management system to automatically generate Intranet sites for the Configuration and Software development teams including a search engine. The configuration site is used by the general user population to get help and lookup configuration procedures and policies, and by the configuration engineer to get technical information on configuration processes and tools.

System Programming

When a user clicks to submit an insurance application form the information submitted goes though communications link software which I wrote to provide dynamic linking between the IIS based Web and Application servers. This is time-critical multi-threaded socket programming.

I brought in C# and Visual Studio .NET and used ADO.NET, dataTable and DataGrid classes to render free form information from an SQL Server query result set as a demonstration project to try and get the department to move on from VBasic. As part of the education process I added 'how to C#' articles to the intranet site for the other engineers (these articles are on the ezds.com site).

Lead Software Design Engineer

I joined the 'N2000 Network Manager OMC' team. This 32-Bit Windows NT 4.0 application monitors alarms from networks of remote pager transmitter sites. The application is very large: over 2000 classes totaling about 160,000 lines of C++ code, built with zApp Application Framework, Rogue Wave C++ class libraries, Borland C++ 4.51, and Visual C++.

As the team's build engineer, I redesigned the make support system, and was responsible for daily builds, checkin and checkout to the unix based ClearCase version control system using an Xterm, commercial library builds, and class hierarchy documentation.

As a C++ developer I implemented the Alarm Relay, Alarm Stream, Alarm Forwarding, On-Line Help, and Configuration Manager modules. Alarm Relay drives a ComputerBoards PDIS08 opto-isolated relay board using a ring 0 driver.

I wrote the internationalized setup for the application using InstallShield. The script is monstrous - over 10,000 lines.

Interesting tasks included modifying the system for Year 2000 compliance in multiple time-zones based on GMT, supplying content for application technical data web pages, and SDK/DDK/Resource Kit fun stuff such as thunk DLL support for Windows 95, Web access, and Performance Monitor extension DLL's.

Extended ManneQuinPRO 3.0 Windows 3.1 shrinkwrap package to capture video from VCR - Camcorder to disc using Creative Labs Video Blaster DLL functions.

Wrote additional dialogs to allow user to select single or multiple frames from the captured video for overlay by wire frame mannequin figure. Borland C 3.1 with extensive use of GDI - DIB Windows SDK functions.

Software Project Engineer leading 6 man team developing `MKS RCS for Windows', (Since renamed `Source Integrity'), a shrink wrap source code configuration management tool.

Most critical contribution: getting management to agree to dump old Tichy SCCS code base and develop about 10,000 lines of new code packaged as a Version Control (VC) DLL which could also be sold as an independent product to developers incorporating Version Control in their own products.

Personal output: GUI design, Configuration sub-system, and DDE hook DLL interface to File and Program Managers.

Project Consultant. Re-wrote the City Councilors Rbase 4GL contact database system running on 17 Novell servers, then converted it to `ACT' shrink wrap contact management software. Setup source code change management procedures. Wrote custom Edit screens directly against the RDBMS using Microrim library and Microsoft C.

Develop numerous Symantec C++ database validation and conversion utilities.

Wrote a TSR power outage management program in Symantec C for the Novell Servers, reprogram the 8250/8259 chips, put an interrupt handler behind the serial port, and dialog with the UPS and Novell by pulling up levels on a custom Y cable to the UPS & mouseport.

VP Finance and Administration. Managed the technical pre-sale, configuration, installation and support function.

Wrote support, customization and added-value software, including 'Cubits' PC Telephone inventory package.

Communications Manager. Responsible for the company's data, voice and local area networks.

SNA Network: Designed and installed the branch IBM 3600/4700 local loops and the SNA/Dataroute spine network. Integrated previously separate Bisync 3270 network with SNA/SDLC 3600 network, adding 57% more capacity at 27% cost saving.

Voice Network: Project Manager for project to replace the Head Office 7001 PBX with 600 locals installed with ROLM CBXII with 940 installed digital sets. Project started February, 1983 with hiring of key voice personnel, cut over on scheduled date April, 1984 and $40,000 under the authorized $1,376,000 budget. Project required building new PBX room from scratch and new riser system.

Installed SL1 PBXs in Montreal and Calgary main offices and ran a pilot project of Shell Voice Messaging System.

Integration projects included writing a PC Telephone Inventory System and interfacing it to the vendor supplied Call Detail Recording system and installation of a Gateway to patch micro-computer communications outwards through the PBX and bring in outside customers to the host under X25.

Office Automation projects:

Designed and implemented an Electronic Mail system to switch E-mail overnight between Head Office and the regional offices at 50% saving over courier costs and with 99.5% reliability.

Wrote fully automated switching software to collect data from eight regional Datapoint 5500 mini-computers; a JES/MVS emulator to upload the captured data to the IBM mainframe; and intercept reports from Cobol applications and route them back over the E-mail system to the regional offices.

POS project: Designed and setup working demonstration system to support company proposal for nationwide Cheque Guarantee Card system in Supermarkets using Concorde POS terminals.

Replaced a costly and incompatible collection of IBM System 6, Micom, AES and Wang word processors with 140 NBI wp systems in 11 NBInet Lans then added WAN capability by developing a 3274 software emulation to transfer documents between NBI hub processors and the host PROFS electronic mail system.

Project Leader National Selective TV sales project responsible for the Datapoint and DEC mini-computer systems handling TV commercial spot inventory, airing confirmation and billing and generating 70% of CBC's non-grant revenue.

As Assistant Manager, Systems Design, responsible for new project reviews and on-line programmer training.

Joined Demand Deposit Accounting application team as a system analyst. This Cobol application is the bank's largest system servicing 450 branches nationwide. It maintains the bank's personal and corporate chequing accounts, posts clearings to them nightly and produces monthly statements to clients.

Promoted 10/72 to DDA project leader and managed a major conversion of the system from Honeywell to IBM equipment. The project amounted to a re-write of the system from the inside out.

Consultant to Bank of Nova Scotia Jamaica during their implementation of an Assembler Transit/DDA system. Wrote the CICS Non-Dollar data entry sub-system.

Held successive administrative positions 1964-1969 as Deputy Supervisor or Supervisor of Costing, Invoicing, Order Processing, and Central Stock Recording.

Trained as Systems Analyst 1969. Responsible for the inventory, pricing, sales analysis, and profitability systems.