Iain Smith Email & Phone Number

Calgary, Alberta

Developed a geospatial data capture and automated analysis/reporting system for cathodic protection (CP) data (Trademarked), which brought value to the client base and increased internal operating efficiency resulting in better customer relationships and increased revenue stream. Established new processes for data collection, and data management to meet QCQA, Auditing and ISO requirements. Developed new business intelligence reporting that realized new KPIs for the company. Implemented custom tools for data mining, report automation, geospatial data processing and analysis. Carried out GIS technician duties including cartography, geospatial data management, analysis and development. Performed DBA responsibilities supporting core business productivity and management systems. Oversaw IT operations for service desk, telephony/MDM, desktop support, server, and network for over 300 employees, maintaining change management process, problem/incident tracking and applied ITIL best practices. Initiated and managed IT projects, leveraging new and emerging technology which brought process, efficiency and cost savings to the business. Performed software/hardware procurement, and influenced business purchasing trends and standards.

Calgary, Alberta

Migrated MS Access 2000 database/reporting application to SQL Server 2008r2. Analyzed existing database infrastructure for performance and scalability issues, and implemented changes to the system(s) while remaining within a fixed budget. Migrated existing SQL Server 2005 to MS SQL Server 2008r2. Increased performance of accounting system by an average of 50% and tweaked existing reporting queries and indexes. Created new reporting queries for the accounting application based on business requirements. Developed an inventory system for the IT department using MS SQL Server 2008 r2 with full documentation.

Calgary, Alberta

Oracle OCP Certification path curriculum and Database Administration.

Calgary, Canada Area

Implemented successfully recommended changes to print devices and achieved a net cost savings of approximately 2 million dollars per annum as part of a global project team whose strategy was to analyze potential cost savings of all print devices. Facilitated IT operations for multiple offices in downtown Calgary as well remote sites throughout Canada, which included Desktop/Server/Network operations. Acted as part of the global desktop support team and domain admin for approximately 2500+ users. Carried out Help Desk level II, III escalation support, and incident tracking.

Calgary, Canada Area

Provided technical support for proprietary point-of-sale software/hardware suite. Coordinated new site installations including planning, deployment and training.