William (Bill) E. Walters
403 824 Royal Avenue S.W.
Calgary, AB
T2T 0L3
Cell: (403) 830-8900
PROFILE
o
BSc
Computing Science. IT Professional since
1990.
o
Excellent
verbal and written communication skills.
o
Windows
Application using popular tools .NET/C#/VB.NET/ADO.NET, Visual C/C++, VB6,
Access and Delphi
o
SQL
Server Development, Administration and DTS, Oracle Development.
o
OSI PI
and Honeywell Uniformance PHD process data system application interfaces
o
Object
Oriented Methodologies
o
Test
Driven Development (TDD)
o
Web
Development in Microsoft and Apache environments using .NET, ASP, CGI Perl
scripting, HTML/DHTML and Javascript
o
Business
Analysis, UML, Full Development Lifecycle
o
UNIX development
and administration.
o
Document
management systems.
o
Able
to work in Canada or the United States without sponsorship.
PROFESSIONAL EXPERIENCE
Shell Canada Ltd., 1/2010 to 7/2010
Project: Earth Sciences Document Transfer
Application, 5/2010 to 7/2010
·
Developed
a scheduled C# application to locate, ZIP and transfer files between multiple UNC
and FTP locations.
·
FTP
via default libraries. ZIP via SharpZipLib, applying zero length file bug fix.
·
Distributed
architecture to encapsulate all functionality, referenced by the command-line
application and its WinForm console.
·
XML
settings driven application for future flexibility with data validating
console.
·
XML
Schemas used to auto-generate serialization classes via XSD tool.
Project: Stingray Aviation Customer Loyalty,
2/2010 to 4/2010
·
Ported
an existing Oracle Pro*C and UNIX Korn Shell Script application from the
FlyingJ to the Aviation Gas Loyalty program.
·
Regression
tested system, identifying deficiencies with the pre-ported code and database constraints.
Project: IHOG Bug Fixes 3/2010
·
Corrected
numerous bugs within a legacy ASP system.
·
Identified
incorrect database triggers mysteriously altering data.
Project: Management of Change (MOC) Database,
1/2010 to 2/2010
·
Upgraded
Existing MS Access Front End / Oracle Back End Application for use with
multiple sites.
·
Re-developed
forms to properly transaction data changes.
·
Upgraded
Stored Procedures.
Shell Canada Ltd., 9/2005 to 5/2009
Project: Brockville PHD Task Processor
Rewrite, 4/2007 to 5/2009
·
Ported
legacy task loading applications from Oracle Pro*C to VB.NET, Crystal Reports
with XML/DOM.
·
Interfacing
to Honeywell Uniformance PHD system OLE component of Visual PHD and to Oracle
databases via PL/SQL.
·
Distributed
architecture to provide common functionality through multiple application types
(windows services, service consoles, WinApp and console apps).
·
Test/Prod
switching layer built for quality assurance.
·
RSA
encryption for credentials persistence.
Project: PI General Loader, 1/2007 to 3/2007
- Redesigned a set of OSI 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.
·
Distributed
architecture to provide common functionality through multiple application types
(WinApp and console apps).
- Provided a processing method easily
extendible to new file formats using minimal configuration.
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 SQL Server.
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 and XML/DOM persistence.
- 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 PL/SQL generation
as required by sophisticated search capabilities.
Elk Valley Coal Corporation, 8/2004 to 9/2005
Project: B2B Project, 8/2004 to Present
- 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 COM 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: 2-Stroke Jetting Calculator, 6/2007
to 8/2007
- In C#, developed application for
predicting 2-stroke jetting choices based on historical ideal choices for
any given engine configuration.
- TDD methodology used with nUnit to
build matrix engine, n-order regression engine and final calculation
layers.
Project: Windows Mobile Integrated Stopwatch,
3/2007 to 4/2007
- Stopwatch functionality logically
extended for multiple competitors to Windows Mobile platform with backup
of results to SQL Server.
- Implemented in C#.
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: 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.