Experience

Dafran Inc.

• Canada
• Information Technology & Services
• 1 - 100 Employee

• Senior .NET/SharePoint/MS Access Developer IT Consultant and Architect (Owner)

  • Oct 2003 - Present

  I have over 30 years experience with MS Access/VBA development and have 3 MS Access Certifications dating back to version 2.0 in 1998. I also install, administered and enhanced SharePoint, completed several SharePoint migrations, to SSSE and SharePoint Online and developed internal and external web sites and applications. I have also worked on a data migration projects, procurement projects that leverage the MVC frameworks, including jQuery for Mobile integration. Most recently developing with MVC5, ASP.NET Core MVC. Client's list (current and past): •Stantec Engineering - MS Access/SQL Server/SSRS. ASP.NET Core MVC. •Parkland Fuel - MVC/MS Access/SQL Server •Marex Canada - SharePoint On-Premises. Migrations from 2007-2010-2013. •Vision Integrity Engineering - MS Access/SharePoint/MVC/Azure Apps and Azure SQL. Trello Integration. •JACOS (Japan Canada Oil Sands) now Greenfire Resources - SharePoint 2013, .NET, MS Access and SQL Server. SharePoint 2013 to SharePoint Online migration. •Auditor General of British Columbia (via Annex Group) MS Access/SQL Server •Alberta Wilderness Association - MS Access •Media Logic (Natural Resources) - SharePoint 2013 •Canadian Food Inspection Agency (via Si Systems) - MS Access •North West Redwater - MS Access/SQL Server •NKF Devencore - MS Access/SQL Server •Alberta Bike Swap - MS Access/SMS •Canadian Propane Association - MS Access •CBRE Downtown & Industrial - MS Access/SQL Server •Supreme Windows - MS Access/Progress SQL •TechWest Downhole Tools - SharePoint Online, MS Access, SQL Server •Summit Liability Solutions - SharePoint 2010 •SAIT (Art Smith Aero Centre) - MS Access/SQL Server •ClearBakk Energy Services - MS Access •Aero-Tech Welding - MS Access •Intelligent Data Solutions - SharePoint 2010/SQL Server •Three Streams Engineering - SharePoint/MS Access •TAQA North - SharePoint 2010 FBA •Strike Energy - ASP.NET MVC Show less



Marex Canada Limited

• Canada
• Construction
• 1 - 100 Employee

• Senior .NET/SharePoint/MS Access Developer

  • Aug 2010 - Present

  Maintained pre-built Web Parts and developed custom Web Parts for the Marex Canada SharePoint Portal, which is also used as a collaborative site for their customers. Also the SharePoint Administrator and I was responsible for the architecture design and security of SharePoint. I also build a newer and more improved SharePoint solution for TAQA North's Electrical Inspection reports, similar to the Marex Canada version. The solution included installing and configuring SharePoint Foundation 2010 using claims based authentication with FBA. Marex Canada are an Electrical Safety Codes Inspection company and have customers such as Shell Canada, CononcoPhillips and Husky Energy, just to name a few. o Installed and configured SharePoint 2010 Foundation. o Migrated SharePoint 2007 to 2010, then to 2013. Soon to be upgraded to SharePoint 2016. o Designed and built a SharePoint solution consisting of 22+ site collections (and counting) for electrical inspection reporting with custom web parts using Microsoft Charting and FBA security. o Maintain the farm environments with cumulative updates and backups. o Continued support and development is ongoing. o Marex clients include Shell Canada, ConocoPhillips, and MEG Energy etc. Show less



Canada Energy Regulator | Régie de l’énergie du Canada

• Canada
• Government Administration
• 300 - 400 Employee

• Senior .NET/MS Access/GIS Developer

  • Oct 2014 - Mar 2017

  This role involved data analysis of Pipeline and Facilities Data stored in MS Access that was to be migrated to the NEB GIS System and brought in line with the most current systems. The migrated data touched many .NET Web applications, including SSRS reports. A lot of ArcGIS development was also included as an Add-In to Arc MAP. MS Access was used to migrate the data and compare the results. The project was successfully completed in April 2016 and was a huge milestone for the NEB as it now allows them much better access to Pipeline and Facility data. This role also involved development of applications for Field Inspection written in MS Access 2010/2013 32/64 bit. The application detects when the laptop is offline and when it has connectivity to the NEB network via VPN so that the Field Inspector and always have access to local reports. It also measured the speed of the internet connection to ensure it is quick enough to upload data (Rows of Data, Attachments and Photos) from the local Inspections database. This project attracted public interest as the NEB met its goal of capturing Field inspections by the summer of 2015. IT support was also key with many applications supported such as MS Access, ASP.NET, MVC, SSRS to name just a few. Show less



CNOOC International

• Oil and Gas
• 700 & Above Employee

• Senior .NET/SharePoint/MS Access Developer

  • Jul 2013 - Jul 2014

  This role involves multi-tasking between up to eight projects from VB.NET/C# and SharePoint. Also MS Access 2010 and SQL Server 2008 R2. Long Lake Construction projects in the Project Development and Execution team. Planning strategic production releases for existing Web and Desktop applications as well as SharePoint 2010 solutions for Project Management and Document Control. This role involves multi-tasking between up to eight projects from VB.NET/C# and SharePoint. Also MS Access 2010 and SQL Server 2008 R2. Long Lake Construction projects in the Project Development and Execution team. Planning strategic production releases for existing Web and Desktop applications as well as SharePoint 2010 solutions for Project Management and Document Control.



ITopia Corporation

• Canada
• Information Services
• 1 - 100 Employee

• Senior Software Developer

  • Mar 2011 - Nov 2013

  Itopia Client Outsourcing: Three Streams Engineering • Migrated SharePoint 2007 to 2010. • Installed and configured SharePoint 2010 Foundation. User base is 500+, and international. • Maintain the farm environments with cumulative updates and backups. • Continued support and development is ongoing. • Developed an MVC3 web application for procurement tracking, which is used by 200+ users daily and has export to Excel featured for reporting to clients. Made extensive use of Telerik controls for the entire web application. • MS Access 2007/SQL Server 2008R2 solution for Document Control Tracking, soon to be integrated into SharePoint and SSRS. Intelligent Data Solutions • Installed and configured SharePoint Enterprise 2010. • Developed several sites for various clients for tracking Vessel inspections. • Branding of the SharePoint sites. • Developed an ASP.NET website with integration with InfoPath forms via Web Services and WCF for communication with SharePoint and SQL Server. Extensive use of Telerik controls. • Developed a Tilt Settlement Windows Desktop application for calculating the status of a vessel. • SSRS BI reporting for several different databases. • Installed and configured Reporting services on SharePoint 2010. Show less



FortisAlberta

• Canada
• Utilities
• 700 & Above Employee

• Senior .NET/SharePoint Developer

  • Aug 2012 - May 2013

  The first project was a Java/Oracle conversion/rewrite to .NET MVC4/SQL Server 2008R2, including Oracle to SQL Server data migration and PL-SQL to T-SQL conversion. I used MS Access to migrate the Oracle data to SQL Server via ODBC linked tables using VBA. SSRS reports were also converted from 2005 to SharePoint Reporting Services. The second project was a SharePoint 2010 Enterprise project using jQuery UI with the metro look and feel using specific CSS. This project introduced new standards for Fortis based around the use of jQuery and jQuery UI. I also used CSOM and JSON for pulling SharePoint Lists into the front end. Tools and technologies used: • Visual Studio 2010 with Oracle Developer Tools • MVC4, jQuery, Kendo UI • MS Access for data migration from Oracle to SQL Server • jQuery UI (extensive) • SQL Developer, Oracle Drivers • SQL Server 2008 R2 • DevArt Toolset (Oracle driver replacement) • SharePoint 2010 development • InfoPath 2010 development Show less



Cenovus Energy

• Canada
• Oil and Gas
• 700 & Above Employee

• .NET/MS Access Developer

  • Jan 2011 - Aug 2012

  I worked in the Supply Chain Management portfolio, Document Control and Environmental departments. The initial project was a Java to .NET application re-write and that was followed by 3 extensive MS Access 2003/2007 development projects. One of the MS Access applications had a user base of 300+. Tools and technologies used: • MS Access 2003/2007 to SQL Server 2005/2008 conversions & MS Access Support/Maintenance • Visual Studio 2008/2010 with Oracle Developer Tools (C# projects) • AJAX Controls and AJAX-enabled WCF Service with JSON/JavaScript/JQuery/Page-Methods • Infragistics NetAdvantage 2011 Controls • Telerik 2012 Ultimate Controls Collection • SharePoint 2007 (WSS and MOSS) • TOAD with Oracle up to 11g • Concurrent Versioning System (CVS) with Tortoise CVS • Oracle Developer Tools for Visual Studio (2008/2010), including Entity Framework. Show less



Hewlett Packard Enterprise

• United States
• IT Services and IT Consulting
• 700 & Above Employee

• Business/Data Analyst

  • Oct 2010 - Jan 2011

  This was my first dedicated Business Analyst position. I was one of 4 Business/Data Analyst working on one of the largest Data Migration projects in North America, which involved moving legacy data from an old VAX system to more modern Oracle databases. Tools and technologies used: PLSQL Developer DBDesigner 4 by fabFORCE Oracle SQL Developer Data Modeler Microsoft Access 2007 This was my first dedicated Business Analyst position. I was one of 4 Business/Data Analyst working on one of the largest Data Migration projects in North America, which involved moving legacy data from an old VAX system to more modern Oracle databases. Tools and technologies used: PLSQL Developer DBDesigner 4 by fabFORCE Oracle SQL Developer Data Modeler Microsoft Access 2007



Propak Systems Ltd.

• Canada
• Oil and Gas
• 400 - 500 Employee

• .NET/SharePoint Developer

  • Jul 2010 - Oct 2010

  This role involves designing and developing C# .NET solutions using Visual Studio 2008 & 2010 for SharePoint 2007 WebParts. The development platforms and technologies used: Visual Studio .NET 2010/2008 WinForms & WebForms (.NET 2.0/3.5) MVP design pattern SharePoint WebPart development Ajax Toolkit, CSS, HTML, jQuery LINQ IIS7 Web Services SQL Server 2008 This role involves designing and developing C# .NET solutions using Visual Studio 2008 & 2010 for SharePoint 2007 WebParts. The development platforms and technologies used: Visual Studio .NET 2010/2008 WinForms & WebForms (.NET 2.0/3.5) MVP design pattern SharePoint WebPart development Ajax Toolkit, CSS, HTML, jQuery LINQ IIS7 Web Services SQL Server 2008



Graham

• Canada
• Construction
• 700 & Above Employee

• .NET Developer

  • Sep 2009 - Jul 2010

  This role involved developing and supporting several Extranet, Internet and Intranet Web Sites and Web Services for Graham's employees and external customers. One of my main achievements was developing .NET Web Services which integrated with Active Directory via LDAP and with SharePoint Web Services. I was also a key player in was the Graham Investment site for employee investing and the Health Spending Accounts for the Graham HR Intranet site. The development platforms and technologies used: Visual Studio .NET 2010/2008/2005/2003 (C#) WinForms & WebForms Custom Web Controls/User Controls/Libraries/Custom Attributes/SQL Data Types Deploy/Publish Web Sites IIS 6.0 and Index Services configuration and maintenance LDAP Web Services custom development (AD integration, creation of Security Groups) SharePoint 2003 Web Services & WebParts development 3rd party Controls - Dundas & Infragistics. SQL Server 2005, SQL XML using XPath Administration of web sites running on Windows Server 2003 using IIS 6.0 for .NET 1.1, 2.0, 4.0. Company: Con-Force Show less



Armtec

• Canada
• Civil Engineering
• 300 - 400 Employee

• .NET/MS Access Developer & Team Lead

  • Nov 2007 - Aug 2009

  The main software development was based on employee time capture using a touch screen kiosk system, using VB.NET/C# and SQL Server 2005. SAP upload file creation was also an important part of the development process for job costing information and the design of an SAP interface provided data for multiple .NET applications in multiple regions across Canada. A major challenge was supporting multiple locations in different provinces as all regions contained common data, provided by one central database. I also implemented several instances of SQL Server 2005 for production, QA Testing and Development environments and implemented Test and UAT procedures. I also maintained many databases, including nightly full backups and daily incremental backup, testing the restores on a regular basis. I also maintained and monitored the performance of the SQL Server databases across multiple regions. The development platforms and technologies used: Visual Studio .NET 2008/2005/2003 (C# & VB.NET) WinForms & WebForms using Design Patterns. SQL Server 2005 Standard and Express, including Reporting Services. Web Services and WCF. T-SQL for SQL Server 2005. Agile Methodology using ScrumWorks. Show less



CNOOC International

• Oil and Gas
• 700 & Above Employee

• .NET Developer

  • May 2007 - Nov 2007

  This position was a developer role to replace a legacy Time Tracking/Estimating system. It was a VB.NET 2005 desktop application used for time capture and project cost tracking, using a common architecture of base classes, developed by Nexen which employed the Microsoft Enterprise library. I was the lead developer on this project of 2 developers and completed all of the Sprint planning. The initial release was completed in October 2007. Phase 2 of this software release was released at the end of November, 2007. I had taken a lead role in the Requirements gathering and Sprint Planning for this product. The development platforms and technologies used: Visual Studio .NET 2005 (Framework 2.0), with Team Foundation Server Source Control TOAD (Tool for Oracle Application Developers). Visual Source Safe 6.0. Oracle 9.0i, 10g, PL/SQL NUnit and other 3rd party unit testing software Company: Shell Canada Show less



Shell

• United Kingdom
• Oil and Gas
• 700 & Above Employee

• Developer/Analyst

  • Nov 2003 - May 2007

  This was a long term support/developer role to enhance, maintain and support a large portfolio of Down Stream Marketing applications used to forecast, analyze and run the Retail markets for Shell Canada at the Retail store level. The applications consisted of interfaces to Oracle (ODBC), AS400 (Client Access) and MS Access, Visual Basic 6.0, VB.NET & C#. Technical support to Shell retailers, Shell helpdesk, and Desktop support teams, Back Office Systems, network communications, POS device communications, PC hardware issues, Windows configuration, VPN & PC Anywhere configuration, PC image testing and security patching; I was also responsible for the Security Reviews for all the applications and systems I supported. I have been responsible for upgrading application from Access 97 to 2000, which run on the Windows 2000 worldwide rollout as of early 2004. One of my major achievements at Shell was taking a lead role in the development of a .NET desktop application which interacted with VoIP to communicate gas prices to stations across the country. The development platforms and technologies used: Visual Studio .NET 2005 Visual Studio .NET 2003 Microsoft Access 2000/2003. Visual Basic 6.0 & Microsoft Excel Macros with VBA. TOAD (Tool for Oracle Application Developers). Visual Source Safe 6.0. Oracle 8.0 & 9.0i, PL/SQL. WISE 4.0 Installation Tool.; Support for IVR Servers (Interactive Voice Response) used for easyPay and Credit Card Processing. Remedy 4.0 support and development. Distributing software to Retailers on auto-run configured CD's. Show less



EDS Group

• IT Services and IT Consulting
• 300 - 400 Employee

• Developer/Analyst

  • Aug 2003 - Nov 2003

  This was an on-going contract which was extended until November 30th. It involved writing Excel reports via MS Access 97/2000 using the Excel VBA object model. The reports were based on call center data such as Avaya and problem tracking systems such as Remedy. The backend data was retrieved from many DBMS's such as SQL Server, Oracle, Sybase, Informix and FoxPro. This roll also involved the development of SQL Server 2000 DTS Packages in order to import data from the many different data sources into one central Data Warehouse. The development platforms and technologies used: Microsoft Access 97 and 2000, including the use of MDA library files, DLL's, API's and COM. Excel 2000 and Excel VBA Object Model via Microsoft Access TOAD. Show less



Halifax

• Banking
• 700 & Above Employee

• VB/MS Access Developer/Analyst

  • Oct 1998 - May 2003

  This position involved the analysis, design, development, regression testing, user acceptance testing (UAT), implementation and support of applications based on the Financial Markets for HBOS Treasury written using Visual Basic 6.0, MS Access 97/2000, Visual C++ 6.0, Sybase, Oracle, Business Objects 5.0. The systems were used by as many as 500 users, from the Dealing Floor to Back Office operations and Credit Risk. The systems included dealer input of trades, back office monitoring, credit checking, and risk analysis of counterparties, automated market rates gathering from Reuters and Bloomberg and interfacing VB/Access applications with AS400/DB2 systems, just to mention a few. Overnight processing for accrual calculations was also a major part of the support process, including the integration of the Bank of Scotland systems and entities. Show less



Britannia Building Society

• Financial Services
• 1 - 100 Employee

• Developer/Analyst

  • Oct 1997 - Oct 1998

  This was a 12-month contract with Britannia Building Society (Financial Institution) in Leek, Staffordshire. This position involved millennium checking of all systems written in MS Access 2.0, writing user/development manuals, user support/maintenance and conversion to Visual Basic 5.0/MS Access 95 systems. I used NT 4.0, NT 3.51 and Windows 3.11, Access 2.0, Access95, Access97 and Visual Basic 4.0 and 5.0. This was a 12-month contract with Britannia Building Society (Financial Institution) in Leek, Staffordshire. This position involved millennium checking of all systems written in MS Access 2.0, writing user/development manuals, user support/maintenance and conversion to Visual Basic 5.0/MS Access 95 systems. I used NT 4.0, NT 3.51 and Windows 3.11, Access 2.0, Access95, Access97 and Visual Basic 4.0 and 5.0.



SEMA Operations

• Australia
• Advertising Services
• 1 - 100 Employee

• Developer/Analyst

  • Dec 1996 - Sep 1997

  I was involved with SAS, SQL Server, MS Access and Visual Basic development environments. Most of the projects were for the Home Office (UK Government), which necessitated full Security Clearance. The Home Office demanded a high level of quality, meaning that the work went through many checkpoints before it was accepted. Because of my meticulous habits, I was assigned many projects concurrently. One of the projects I worked on was a Visual Basic Application using a SQL Server backend database for the Government's "Gun's Amnesty Program" in 1997. Show less



Electrical Industries

• Service Manager

  • 1992 - 1994