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. 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.