Neil Wagner Email and Phone Number

My Virtual Desktop solution is based upon VMware View 4 technology targeted at SOHO based businesses. The concept provides a secured, centrally managed Windows based desktop hosted in a Datacenter which customers can access remotely. The solution is targeted at those companies which require IT like-services, but are not necessarily trained or have the budget to hire IT staff.

I am currently running a hosting company providing Virtual Desktop's, performing IT consulting, and installing rural based High Speed Internet.Projects include:- Gellner Farms (4 weeks): Currently designing conceptual data model for a Field Operations project. The Data Model is being built based upon Agricultural Field Operations, Seed Cleaning and Grain Storage and will be implemented using Access 2007.- SOHOspot (4 weeks): Performed an Infrastructure Assessment which analyzed the effectiveness of the SOHOspot.com website. My analysis reviewed the configurations and specifications of the various Infrastructure layers resulting in a report identifying areas of improvement.- SOHOspot (3 weeks): Researched and recommended User Experience Monitoring tools in order to understand End-User response times. My efforts involved guiding customer in order to identify requirements and deliverables, researching a number of solutions, installing and demonstrating, then provide a written report ranking each solution.- Virtual Desktop's (on-going): My Virtual Desktop solution is based upon VMware View 4 technology targeted at SOHO based businesses. The concept provides a secured, centrally managed Windows based desktop hosted in a Datacenter which customers can access remotely. The solution is targeted at those companies which require IT like-services, but are not necessarily trained or have the budget to hire IT staff. Efforts in launching this solution have included implementing VSphere and View 4 Infrastructure, establishing Service Provider agreements with Microsoft & VMware, becoming a VMware Certified Professional (VCP 410), Implementing and Testing solution, establishing internal accounting procedures and Marketing.

- This has involved designing an optimal environment to perform component Discovery and reconciliation with Remedy while distributing the environment so that the data can be consumed and reported on.- Discovery technology includes BMC Foundation and Topology, SMS and SolarWinds.- CMDB technology is BMC Atrium and is integrated with BMC Remedy IT Service Management (ITSM).- I worked closely with TransCanada to understand their requirements, and consulted BMC regularly to understand the technology and identify license structure.- The resulting Infrastructure contains many pieces which include utilizing Discovery proxy servers in TransCanada’s field offices, consolidating the data centrally then synchronizing the data stores with CGI Regina where ITSM resides.- I proposed alternative designs to TransCanada and CGI Executives of which the recommended solution was accepted.- I am now currently involved with implementing the recommended solution.

I have worn many hats in this position, and have been looked upon as a reliable resource. Most of the work has been focused on Performance Analysis, Planning & Design and recommending Event Monitoring technology. The major projects to this point include designing a CMDB, designing an R&D lab for the DBA team, Virtualizing current Operations (VMware) and the creation of a new revenue making service, Capacity Reporting.

- I have often been looked upon to provide expertise in troubleshooting performance issues. I was tasked with determining where there were bottlenecks within the Infrastructure. My analysis correlated metrics from the Infrastructure, Database and Network layers but revealed a gap in monitoring from a User Perspective.- I was asked to find a tool which provided response metrics from a User experience. I interpreted and documented the requirements of the potential tool and was able to come up with a ranking system.- I interviewed staff, performed research and sent inquiries to vendors which I have relationships with, to come up with a list of potential solutions.- Based on vendor demonstrations I ranked the products and presented my recommendations to the Management team. The tool was successful in POC, has been procured and is currently in use.- I have assisted the Infrastructure team in enabling alarms from HP Openview agents.

- The Capacity Reporting service was conceived, proposed and implemented by myself and has been viewed as a “Value Add” service that complements CGI’s Database Services. - The focus of the service is to report, analyze and project on the capacity of the individual components that make up a computer system by collecting and summarizing metrics on key resources over a period of time.- The work involved with getting the Capacity Reporting service launched has included providing and documenting business requirements, providing detailed analysis, projecting revenues, running a “Proof of Concept”, strategizing sales, designing solution Infrastructure, obtaining Trial Period clients and developing the Capacity Reports.- As a result of having the Capacity Reporting Service available, I have been engaged to perform detailed Performance Analysis on critical Production systems.

- Identified, and monitored Key Performance Indicators (KPI’s) of the physical and logical components. Based on historical data, I profiled and trended KPI’s from each processing stack and produced regular performance reports. These reports of Application, Network, Servers and Database systems included the DotCom Website, Exchange, BI and Global offices. - Provide guidance and recommendations for performance optimizations.- I was given a large initiative to evaluate and recommend an enterprise monitoring tool capable of tooling IT to manage to Service level commitments.- I started as first DBA for Neteller. Database systems grew from 5 SQL Instances to 35 instances with over 250 databases. Hired and led staff of 5 DBA’s to operate this environment until I transitioned to the Capacity Manager role.- As Neteller DBA I created a replicated database environment used by the BI team. This environment executes a regular batch schedule to populate an ODS and various Data Marts.

- I was focused on defining and executing best practice process and activities to provide quality service as identified by ITIL. It was my responsibility to identify, and then to monitor key performance indicators (KPI) of the critical components identified in the Service Catalogue. I used an iterative process of monitoring and profiling so we could strategize performance optimization and project capacity for upcoming initiatives. This process resulted in improved architecture which allowed IT to be able to measure performance and operate within agreed to Service Levels.- I was able to profile and trend each KPI in order to generate projection, availability and performance reports to Management and Executive staff. These reports were used for operational budgeting and input for new business initiatives.- I interacted with other ITIL Service Management processes such as Availability, Service Level Management, Configuration, Change, Problem and Incident Management.- I was given a large initiative to evaluate and recommend an enterprise monitoring tool capable of tooling the Service Management team to manage to service level commitments.- I had also been tasked with designing and populating a Configuration Management Database (CMDB) to be integrated with the BMC Remedy system and participated as interim Configuration Manager.- I started as the first DBA for Neteller. The database systems quickly grew from 5 SQL Server Instances containing 30 databases to 35 instances with over 250 databases. I hired and led a staff of 5 DBA's to operate this environment.- I also built a replicated database environment used by the Business Intelligence team. This environment executes a regular batch schedule to populate an Operational Data Store and various Transaction Data Marts. Cognos Reportnet is being used as the reporting tool.

- Primary role on DBA Call Center, responding to various degrees of issues from clients. These issues are ranging from basic consultation including software installation, database creation, performance tuning and recommendations to emergency recoveries and restoration involving Oracle and SQL Server databases on various Operating system platforms. - Duties also include daily proactive monitoring of client databases as well as annual backup and recovery/security reviews.- Constantly researching/developing internal procedures to keep up with new technology.- Weekly on-site visit to specific client to provide DBA support for an integrated application using Oracle Advanced Replication and Tuxedo processes on a High Availability Cluster.- Especially focused on Oracle databases from versions 7.3 - 9i and SQL Server 6.5 to 2000.- Participated in 24 X 7 On-call rotations.

- Provided on-going Primary Production support and enhancements for client Corporate Data warehouse. - Major re-work of a specific Data warehouse application involving re-coding PL/SQL packages, diagnose performance issues, bug fixes - new business requirements - creation of new JCL, Unix Shell Scripts, XCOM scripts and scheduling - Involved in on-going transition to the team of SADB Production Support. - Proactively developed scripts to automate the checking of daily run batch stream load into the Data warehouse. - Involved in major Infrastructure Project which involved migrating Production to a new server and testing the batch stream on the new server for issues and benchmarking performance.- On-going support issues such as Performance Monitoring, correcting failures and analysis of data rejections; providing information to end users about daily batch stream results. - Participated in 24 X 7 On-call rotation.

- Provided on-going Primary Production support and enhancements for client Corporate Data warehouse.- Responsible for training new team members.- Major re-work of a specific Data warehouse application involving: re-coding PL/SQL packages performance issues bug fixes new business requirements- creation of new JCL, Unix Shell Scripts, XCOM scripts and scheduling- Involved in on-going transition to the team of SADB Production Support.- Proactively developed scripts to automate the checking of daily run batch stream load into the Data warehouse.- Involved in major Infrastructure Project which involved: Migrating Production to a new server. Primary role testing batch stream on the new server for issues and benchmarking performance.- On-going support issues such as Performance Monitoring, correcting failures and analysis of data rejections; providing information to end users about daily batch stream results.- Participated in 24 X 7 On-call rotation.

- Developed various applications for large agriculture-based companies using PowerBuilder, PL/SQL, Oracle and Datacom. - Participated in decommissioning legacy code. - Completed the Zone Allocations system which allocates grain cars to assigned stations; developed this system using Ideal, COBOL, Datacom and JCL. - Designed, tested and implemented the CWB Transmissions system that processes cash tickets which are then transmitted to the Canadian Wheat Board; Lead Developer using PL/SQL, Ideal, SQL*Plus, Oracle and Datacom. - Provided documentation and Production support for the CWB Transmissions system. - Developed, tested and implemented the SIPS GUI system; this is a business process which re-developed the Stocks, Inventory, and Payment system; Developed this system using PowerBuilder, PL/SQL, SQL*Plus and Oracle.