William (Bill) E. Walters

403 824 Royal Avenue S.W.

Calgary, AB T2T 0L3

Cell: (403) 830-8900

Email: bwalters@clearresolution.com

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.