Senior Software Developer

Highlight of Qualifications

· Over 20 years of experience in successfully providing users with the best software & hardware solutions for their needs & giving friendly technical support

· An enterprise application designer, developer & data architect skilled in testing, troubleshooting, technical writing & providing solutions for integration, revitalising & seamless migration of legacy client applications

· MCDBA, MCITP DBA, MCITP DBA Dev, extensive experience with SSRS & SSIS

· MCPD Enterprise, MCSA & MCTS: Microsoft Office Project, Managing Projects

· Microsoft Certified Business Management Solutions Professional: Developer for Microsoft Dynamics CRM

· Masters Certificate in Project Management (University of Victoria / S.E.E.C. of York University), working on gaining PMI’s CAPM.

· Enrolled in Camosun College’s “Leadership Development Certificate Program”.

· Methodical team worker with experience in teaching basic to advanced I.T. skills & mentoring software development & database architecture at all levels

· Fluent in English & German

Summary of Technical Expertise

Operating Systems

· MS-Windows (all versions)

· Windows CE (PocketPC)

· Linux (diverse distributions)

· UNIX (diverse implementations)

· QNX (real-time UNIX derivative)

· Mac OS, Apple iOS

· Diverse legacy systems

Applications

· MS-Office (all versions, all applications)

· MS CRM 1.2 & 3, Scribe Insight for MS-CRM

· Databases: MS-SQL (all versions) including DTS, SSIS & MS SQL Reporting Services, MS-Access, MySQL, Oracle 8, IBM iSeries, and diverse legacy DB systems

· Extended knowledge of internal workings of Infosys ERP & AWE Wireless

· Diverse graphic applications

· Terminal & host applications

· Financial & HR applications

Main Programming Languages

· C#, ANSI C++, ANSI/K&R C, Objective C

· SQL: Microsoft (all versions), MySQL (all versions), Oracle 8, JDE/AS400 DB2

· MS Visual Basic .NET, VB1 to VB6, VBA

· Scripting: ASP, PHP, JavaScript, VBS/VBA, Python, PERL

· Page description: HTML, CSS, XML/XSLT, Postscript L1/L2

· Diverse legacy languages (Forth, Smalltalk, etc…)

Environments & Frameworks

· MS-Visual Studio (all versions)

· MS-Source Safe (all versions)

· IIS, .NET WinForms, Win32 API, COM/COM+/DCOM, ATX, MFC, STL

· LAMP (LINUX, Apache, MySQL, PHP)

· Extreme Programming, UML 1, ATF

· MS-eMbedded Visual Tools

· Ecommerce payment processing: BEANSTREAM, EZIC, EIGEN, CHASE

· Facebook API

· MySpace / Google OpenSocial API

Professional Experience

Senior DBA/Programmer/Analyst

Parkland Fuel Corporation (www.parkland.ca) 06.2009 – present

· Continued duties & responsibilities to the Columbia Fuels division as described below

· Became part of the I.T. “Supply, Distribution, Retail and Integration Team” as of July 2010

· Expanded internal web based associate phone book to automatically synchronise Parkland Industries’ associates’ data from & to active directory

· Created fuel rack price move & cost estimate web application to generate compatible data for integration into JDE based corporate ERP system

· Reverse engineered & corrected a legacy FoxPro based Cardlock application “MicroTron” to accept ESSO cards, removing “Husky” card restrictions

· Created an ESSO to Husky transaction file converter, to allow modern ESSO transaction to be integrated into “MicroTron”

· Supplied 3^rd level support for such areas as Active Directory, Database administration & development, Infosys ERP, Cardlock & Fuel Site Controller system issues

· Created automated Cardlock volume reports to internal customers

· For the PMO, created & wrote the standard policy for SQL development, integration testing & implementation to ensure assiduous auditing, change management & data consistency

· Mentor to senior, intermediate & junior database administrators / programmers & I.T. members

Senior DBA/Programmer/Analyst

Columbia Fuels Inc (www.columbiafuels.com) - Victoria, BC 05.2005 – present

· Senior Microsoft SQL Server 2000 / 2005 / 2008 database administrator responsible for the integrity, maintenance, optimisation & catastrophe proofing (replication/mirroring) of the company's varied data & SQL servers

· Senior analyst responsible for the design & implementation of the company's varied internal applications

· Mentor to intermediate & junior database administrators / programmers & I.T. members

· Designed & implemented proof of concept for Columbia Fuels WebPortal – continued on major backend implementation of currently active product

· Integrated MS CRM 3 with Infosys Enterprise (fuel & heating oil delivery & cardlock management system), designed & implemented MS-CRM v3 callouts & MS Windows services in C# to facilitate the integration

· Designed & implemented a NMEA based GPS listener for Airlink mobile modems for CFI’s truck fleet, using Google Maps as the web based GUI (CFI GPS version 1)

· Designed & implemented internal web based associate phone book, kudos system & IT inventory

· Designed & implemented a complex web based fuel pricing system to take the regional pricing differences into account, & to save up to 20 person hours a week entering the daily price fluctuations

· Designed & implemented invoice printing for Columbia Fuels’ Fleet / Select Service

· Designed & implemented transportation fee system in Infosys ERP & AWE

· Designed & implemented automated Cardlock transaction integration into Infosys (ERP), automated Cardlock misuse reporting (pre-emptive possible fuel theft warning), & internal Cardlock information portal for quick data access & reporting of lost/stolen cards for CSAs

· Designed & implemented complex volume reports & gross margin reports to facilitate corporate leaders in their decision & planning processes

· Designed, implemented, updated & corrected hundreds of new & existing queries & Infosys Enterprise reports, SQL Server Reports, SQL Server DTS & SQL Server Integrated Services

· Imported a wide variety of foreign customer data after company acquisitions into Infosys Enterprise, MSCRM & RM2000

· Completely re-engineered & updated a legacy Fuel Long Haul tankday prediction & delivery manager as a multi-user web application “CFITRUCK”

Senior Software Developer / DBA / Database Developer

Additional Experience 1990 – present

· Built a company website using Joomla 6, adjusting a standard default template to their specifications and requirements.

· Designed & implemented robust ecommerce payment/refund web based processes using BEANSTREAM, EZIC, EIGEN & CHASE online payment providers

· Designed & implemented, modified & consulted on existent diverse Facebook & MySpace Web Applications

· Converted existing Facebook Web Apps to MySpace Web Apps using new MySpace API

· Experience with NetSuite’s CRM & ERP “NetTalk” web service API

· HTML to PDF automated report processing including intelligent emailing in PHP

· Diverse business dashboards in ASP.Net with MS-Access or MS-SQL backends

· Created a Visual Basic / Access driven contact/inventory/contract management system for a Swiss company specializing in creating & managing travelling museum exhibitions.

· Created a Clipper87 based student registry & management system for a Swiss driving school.

· Created a floppy disk based software licence enforcer (DRM) & installer for a Swiss software company.

Web Developer & project co-ordinator/manager

Third Sector Software Solutions Inc - Victoria, BC 03.2004 – 05.2005

· Senior developer of the company's main web based third sector management product, "NPAIS", using a three tiered system of ASP with XML/XSLT for the front end, Visual Basic 6 DLLs for the middle tier, & Microsoft SQL server 2000 for the back end

· Project co-ordinator/manager for N-PAIS

· Testing & issue tracking co-ordinator

· Mentor to internal associates & lead various Coop students

Senior Software Developer

Real Time Centre AG (www.rtc.ch) – Bern, Switzerland 07.1997 – 08.2003

· Started as sole developer & co-designer for RTC's IT management system "RENO Suite" based on BKB’s proprietary “LAN-TOOLS”, providing TCO reducing solutions for IT infrastructure management, desktop management & automated software distribution, installation & configuration.

· Co-designed & solely implemented the prototype for RTC’s “RENO Suite”, used productively in 3 banks (over 3,000 Windows NT workstations & 100 NT servers)

· Designed & implemented Microsoft SQL Server multi-customer database with Microsoft Visual Basic frontend, several desktop management tools (software installation & configuration using proprietary package system) & software distributions system

· Helped refine, design & implement final product in a homogeneous team of internal & external developers after successful trials (product now used on over 10,000 workstations & 500 servers) using Oracle (PL/SQL) & Microsoft C++

· Re-factored RENO Suite core applications for future Microsoft Windows versions

· Mentored new employees & lead 3 outsourced junior developers

Software Developer, Novell Admin

Basler Kantonalbank (www.bkb.ch) – Basle, Switzerland 06.1996 – 06.1997

· Critically enhanced BKB’s existing proprietary IT infrastructure management system “LAN-TOOLS” used on over 3,000 MS-Windows clients & 200 Novell servers at 3 banks

· Created automatic configuration utilities for complex application suites such as Attachmate INFOConnect terminal emulator & Reuters Client for MS-Windows

· Designed & implemented automated software installation & desktop management for Microsoft Windows

· Enhanced & corrected the existing proprietary software distribution system

· Enhanced & corrected the existing proprietary timesheet application

Software Developer, Novell/UNIX Admin, HW/SW Supporter

Scobag Private Bank AG (www.scobag.ch) – Basle, Switzerland 09.1993 – 05.1996

· Designed & implemented an Epson printer driver emulator in Postscript Lv2

· Created a real-time currency cross-rate information system on QNX

· Rolled out & supported MS-Windows & MS-Office (30 workstations)

· Administered the in-house PC, Novell, UNIX & network systems

Novell/UNIX Admin, HW/SW Supporter 1) 05.1990 – 07.1991

Commodore Electronics Ltd. (Financial Headquarter) – Switzerland 2) 07.1992 – 08.1993

· Administered the in-house Novell, UNIX (SysVR4), cc:Mail & network systems

· Provided technical support of hardware & software to in-house staff & international clients

Software Developer, MS-Windows/MS-Office Teacher, HW/SW Support

KGV (local social security administration) – Liestal, Switzerland 01.1992 – 06.1992

· Successfully completed a 6-month contract to roll out MS-Windows & MS-Office in a small environment of 30+ workstations

· Developed extensive MS-Office VBA macros to facilitate document automation using MS-Query & OLE

· Supported & trained basic usage of MS-Windows & MS-Office to 35 staff

Software Developer

Sandoz Chemicals AG 1988, 1989

· Developed in partnership with a graphic designer “Koepfchen 1” & “Koepfchen 2”, two fully interactive educational tools for Sandoz AG for technical job fairs, testing such areas as logic, correct colour recognition & understanding of physics

Memberships & Volunteer Work

Member in good standing

Project Management Institute (PMI.ORG) 2010 - present

VicDotNet.org, Victoria BC 2004 – present

Volunteer & Supporter

BC SPCA Wild Animal Rehabilitation Centre (www.wildarc.com) 2007 - present

Teacher, HW/SW Supporter, Systems Administrator

DIAL Computer Club – Basel, Switzerland 12.1985 – 08.2003

Certifications

Microsoft Certified Professional Developer: Enterprise Sep 2010

Microsoft Certified IT Professional: Database Developer (SQL Server 2008) May 2010

Microsoft Certified IT Professional: Database Admin (SQL Server 2008) May 2010

Masters Certificate in Project Management (UVIC/S.E.E.C) March 2010

Microsoft Certified Solution Developer (.Net) March 2009

Microsoft Certified Systems Administrator (Windows Server 2003) January 2009

Microsoft Certified IT Professional: Database Developer (SQL Server 2005) August 2008

Microsoft Certified IT Professional: Database Admin (SQL Server 2005) August 2008

MCTS: Microsoft Office Project 2007, Managing Projects July 2008

Microsoft Certified Database Administrator June 2008

Microsoft Certified IT Professional – Developer Dynamics CRM 3.0 May 2008

Microsoft Certified Application Developer (.Net) April 2008

Microsoft Certified Professional December 2004

See the full transcript at http://www.microsoft.com/learning/mcp/transcripts/

Use Transcript ID: “683921”, Access Code: “AccessCode”.

Education

Continuing Education

Personally Effective Leadership (LDCT 524V), Camosun College, BC April 2011

Dealing with Difficult Interactions (LDCT 600V), Camosun College, BC February 2011

Managing Performance (LDCT 510V), Camosun College, BC February 2011

Introduction to Improv Comedy (VSAR 561G), Camosun College, BC January 2011

Art of Dialog (LDCT 533V), Camosun College, BC December 2010

Speaking with Confidence (LDCT 509V), Camosun College, BC November 2010

Increasing Human Effectiveness (LDCT-606G), Camosun College, BC November 2010

Strategic Planning (LDCT-513V), Camosun College, BC October 2010

Coaching (LDCT-504V), Camosun College, BC October 2010

Workplace Communication (LDCT-501V), Camosun College, BC October 2010

Leadership for Supervisors – Overview (LDCT-500V), Camosun College, BC September 2010

High Speed Project Management, WestShore Centre for Learning & Training, BC June 2006
Instructor: Tom Myers @ www.ed2go.com

College

Mathematisch-Naturwissenschaftliches Gymnasium – Basel, Switzerland 1985 – 1988
(Mathematical & Scientific College)

High school

S.E.E.D. – Toronto, Ontario 1982 – 1985

Swiss Military

Infantry & Infantry Command Center 1989 - 1994

Served as squad leader, medical corps (yearly 3 weeks duty run) 1995 - 2003