William (Bill) E. Walters
403
824 Royal Avenue S.W.
Calgary, AB T2T 0L3
Cell: (403) 830-8900
PROFILE
o
BSc Computing Science and 16 years as an IT professional
o
Excellent verbal
and written communication skills.
o
Windows
Application using popular tools .NET/C#/VB.NET/ADO.NET, Visual C/C++, VB6 and Delphi
o
Web Development
in Microsoft and Apache environments using .NET, ASP, CGI Perl scripting,
HTML/DHTML and Javascript
o
Object Oriented
Methodologies
o
SQL Server 2000 Development,
Administration and DTS, Oracle 7/8 development.
o
Business
Analysis, UML, Full Development Lifecycle
o
UNIX system
administration and C development.
o
Document
management systems.
o
Microstation Customization.
o
Able to work in Canada or the United States without sponsorship.
PROFESSIONAL EXPERIENCE
Shell Canada Ltd.,
9/2005 to Present
Project: Brockville PHD Task Processor
Rewrite, 4/2007 to present
·
Porting legacy
task loading application from Oracle Pro*C to VB.NET.
·
Interfacing to
Honeywell PHD system OLE component of Visual PHD and to Oracle databases.
Project: PI General Loader, 1/2007
to 3/2007
- Redesigned a set of PI batch processing
applications to use a unified processing method via a set of VB.NET class libraries.
- Windows forms applications and PI ACE schedules
use the same unified process to load from a variety of file formats.
- The processing method can easily be extended to
new file formats with little effort.
Project: MAS Password Component, 11/2006 to 1/2007
·
Developed a
distributed password VB.NET type library to allow distributed applications with
common database credentials to be managed as a single entity.
·
Secured management
application facilitates changing connection credentials on all client machines
easily along with scheduled changes to master credentials.
·
RSA encryption
used to ensure security in network traffic, with local caching and with data
storage on SQLServer.
Project: InSite
Yearly Development Project, 6/2006 to 10/2006
- Upgrading legacy VB6 and Access based contract
management system with a variety of features and bug-fixes.
Project: GreenBooks, 4/2005 to 6/2006
- Developed a series of applications to install,
relocate and test an Excel-based fuel volume logging system each using
VB.NET with Excel Automation
- Converted an entirely Excel based installation
system on CD to an application in order to allow deployment over slow
networks.
- Built testing application that compares folders
of Excel files for formula, data and macro differences.
- Built Excel relocation application to hunt down
and fix paths in formulas and macros.
Project: Nucleus Call Management System , 9/2005
to 5/2006
- Business analysis, design and development of
client interface to a price management system using VB.NET with an Oracle database.
- Worked closely with business experts to
iteratively develop an intuitive highly suited interface for managing
price messaging with Shell stations.
- Application performance required extensive use of
cached and normalized object collections loaded from an externally defined
denormalized database.
- Special interface features required a number of
customized controls inherited from standard .NET interface controls.
- Single logon security model necessitated use of
public and private key encryption
- Extensive on-the-fly SQL generation as required
by sophisticated search capabilities.
Elk Valley Coal Corporation, 8/2004 to 9/2005
Project: B2B
Project ,
8/2004 to 9/2005
- Analysis, detailed design and development of
multi-tier B2B transaction system using VB.NET, Oracle Stored Procedures
and Triggers, Web Services and XML (XCBL Standard).
- Interfaced multithreading asynchronous
transaction layers with existing VB6 applications making use of thread
operations such as blocking and mutexes.
- Analysis documentation presented in UML as part
of a full SDLC lifecycle using OO Analysis and Design making use of Design
Patterns.
Clear Resolution Inc. (Owner Operator) ,
7/2002 to Present
Project: Hourglass Beads Inventory
Management System, 2/2004
to 12/2004
- Business Analysis and development of inventory
management system using C#, SQL Server 2000 Stored Procedures/Triggers and
Web Services.
- Reports via XML/XSLT.
- Analysis documented in UML, database Entity-Relationship
diagrams and Process Diagrams as part of a full SDLC.
- Backup system built in DTS.
Project: NoteAble
Music Training Application,
2/2002 to present
- Primary application interface implemented in C#.
- Implemented with full OO Analysis and Design.
- Visual C++ ActiveX/COM+ components for Win32 SDK
access to Midi and sound.
- System design documentation in UML.
Project: Hourglass Beads eWebsite,
1/2003 to 8/2003
- Business Analysis and development of commercial
website using C#, SQL Server 2000, ASP.NET, ADO.NET, XML/XSLT and Paypal.
- Implemented with full OO Analysis and Design.
- Web based management area including remote
thumbnail upload and manipulation with .NET objects along with
HTML/DHTML/JavaScript.
- Video look Flash introduction using Flash MX and ActionScript.
Project: Rat-Free Racing Website, 7/2002 to 12/2002
- Dynamic Flash, C# and ASP.NET website with ActionScript and embedded movies.
- Implemented Macromedia development kit for
plug-in detection.
- Interactive content supplied from Flash and
DHTML/Javascript.
Openlatitude Inc.
2/2003 to 11/2003
Project: mPower Order
Management Application,
2/2003 to 11/2003
- Business analyst, designer and lead developer of
rule modules using VB.NET, SQL Server 2000 Stored Procedures, ADO.NET and
XML/XMLDom.
Documented with Data Flow Diagrams, Workflow Diagrams in a full OO
Analysis and Design.
- Interface implementations with XML/XSLT, ASP.NET
web pages, Windows Forms and Web Services.
- SQL Server database lead, schema designer using Entity-Relationship
diagrams and DBA.
- Time shift test application developer using
VB.NET and delegates to windows system time Win32 API.
- Other Skills Required: Exchange, Outlook, Active
Directory, n-Tier system design and Ironspeed
Designer.
SBC Communications (Southwestern
Bell Corporation), 11/1999
to 5/2002
Project: SAS Replacement Project, 12/2001 to 5/2002
- Developed secure substance abuse data gathering
system for web-based scheduling, test retrieval and reporting system.
- Replaced and functionally enhanced a VB6 based
substance abuse test scheduling and results delivery system with SQL
Server 2000 DTS packages.
- Single FTP data source replaced by DTS FTP
component and socket application inputs.
- External application interface to WorldSecure encryption for secure transfer of sensitive
substance abuse test results.
- Updated SQL Server schema, stored procedures and
triggers to match new data requirements.
- ASP, HTML and JavaScript modifications for
updated web interface along with enhancements to VB6 ActiveX/COM+ security
component to allow secure update of test site information.
- Full SDLC including Business Analysis, rigorous
QA, full delivery planning and documentation with Data Flow Diagrams,
Workflow Diagrams and Entity-Relationship drawings for database schemas.
Project: PMR Web Reports, 11/1999 to 12/2001
- Maintained and enhanced operations of n-Tier
personnel management web reporting system through modification of ASP
interface, VB6 ActiveX/COM+ component middleware and SQL Server queries,
stored procedures and security access against a large Data Warehouse.
- Team Leadership for group of 5 developers.
- Maintained contractor group time reporting Access
tool along with associated ASP web reporting pages.
- Configured IIS for various enhancements and
security changes on ASP web based reports.
- Produced Entity-Relationship diagrams for various
all schemas involved in projects.
First International
Finance Corporation, 2/1999 to 11/1999
Project: FreeRealTime
User Administration, 6/1999
to 11/1999
- Business Analyst and developer of user
administration tracking system using Borland Delphi 4 with Interbase 5.1 and ODBC to access DB2.
- SQL scripting for updating and reading client
information.
- Apache configuration, SunOS operation, Perl
scripting and JavaScript to gather usage statistics from a farm of Sun
servers and display the results via web pages.
Project: Bullsession Replacement Project, 2/1999 to 6/1999
- Business Analysis and design of a real-time stock
portfolio tracking system built with Borland Delphi 4, a Winsock quote
server interface and the TopGrid component.
- Negotiated user symbol registration design with quote
server consultants to minimize socket traffic.
- Designed and developed Delphi
objects for implementing user-definable ad-hoc formulas against stock
quote symbol values in a spreadsheet-like visual component.
- Liaised with server and client developers and
produced resulting Data Flow Diagrams and Workflow Diagrams using full OO
Analysis and Design.
TransCanada Pipelines (Formerly Nova Corporation), 4/1990 to 2/1999
CADD Management
Environment (CME), 5/1995
to 2/1999
- Developed a variety
of processes and applications for management of CADD drawings and EDMS
process flow using Visual C++/MFC and SDKs for application development,
Oracle 7/8 PL/SQL/Pro*C for database access and Microstation
MDL for CADD system customization.
- Primary designer and
developer of CADD drawing check in and check out
system using Visual C++ DLLs and Centra 2000
performs.
- Learned advanced Microstation CADD operation to assist in identifying
efficiencies that the EDMS system could bring.
- Developed a system
to synchronize EDMS meta-data and drawing header information using MDL,
DDE and Visual C++ DLLs.
- Produced system
documentation with Data Flow Diagrams, Workflow Diagrams and
Entity-Relationship diagrams for EDMS schema.
- Produced training
documentation and instructed training seminars.
EFMIS Toolkit, 12/1993 to 5/1995
- Technical Project Lead for a Powerbuilder
based remote process equipment monitor and
control application.
- Produced Data Flow Diagrams and Workflow diagrams
for modular design.
- Designed DLLs to overcome bugs and slowness of Powerbuilder.
- Using Borland C and Windows SDK,
developed DLLs for gas flow calculations and for data plotting.
- Developed Powerbuilder
interface.
Mobile A.G.T. Upgrade Integration (MAUI),
9/1993 to 11/1993
- Completed development and enhanced operation of a
mobile radio interconnect system controlled from VMS and built using VAX
Pascal with VMS System Programming and data streams to Redcom
MSP digital switch.
- Improved Digital VT Terminal control interface
software.
- Improved VMS software boot-up procedures for
faster system turnaround.
- Produced training documentation and instructed
training sessions.
Data Retrieval and Supervisory System
(DRSS), 6/1990
to 5/1995
- Provided system enhancements and on-call support
for gas pipeline real-time SCADA system running on VMS using VAX Pascal/Macro/VMS
System programming and on distributed PDP systems with PDP assembler code.
- Diagnosed and corrected problems with Aydin display system hardware.
UNIX Administration and Programming, 4/1990 to 6/1990
- Developed C and C-script programming for
distributed printing of pipeline simulation reports on a network of Sun Sparcstations running SunOS.
- Maintained and configured G2 AI software.
- Administered X-Windows client and server
software.
EDUCATION
BSc Computing Science, 1989
The University
of Alberta
Edmonton, Alberta
OTHER ACCOMPLISHMENTS
Kalthoff International EDM/PDM Conference
Guest Speaker,
September, 1997
Produced and presented a seminar entitled “The Can's
and Cannot's of and EDMS
Implementation” which discussed a practical approach on the implementation of
an Engineering Document Management System (EDMS). I was recommended for this opportunity by the
Centra 2000 company president. Kalthoff
International offered two conferences per year that brought together a variety
of topics and vendors associated with EDMS and Product Data Management
(PDM). The presentation,
composed in Microsoft PowerPoint, offered suggestions to other EDMS
implementers on how to avoid problems we encountered on our project. The evaluations indicated that attendees felt
the information was valuable and well presented.