David Smith Email & Phone Number

Mississauga, ON

Create, test, and maintain Microsoft SQL Server scripts, stored procedures, functions, etc.Optimise and troubleshoot calls using SQL Profiler and Extended Events.Perform DBA functions in the development environment such as backups, replication, user administration, etc.Create, enhance, and maintain SSIS packages.

Toronto, Canada Area

Solution Architect and Business Analyst for several large financial IVR migrations (CIBC, PC Financial)o Led workshops to determine and document requirements and design for new platformo Communicated requirements to several development groups and resolved discrepancieso Requirements were documented primarily in Excel and Visio, and SharePoint was used as.

Toronto, Canada Area

Designed and developed numerous internal projects using C#, ASP.NET, T-SQL, SSIS, Web Services, etc.:o Revenue Share engine to calculate payments for OEM Partners based on vehicle sales and conversions to paying subscriberso Primary intranet site to allow business users and contact centre agents to customise and execute queries against the corporate data.

Toronto, Canada Area

Designed and developed InterVoice IVR (Interactive Voice Response) solutionsCreated workflow applications that allowed call centre agents to submit requests to either back-office agents or automated systems for resolutionBuilt a network socket load tester to stress test the mainframe back endDesigned and developed desktop and intranet solutions for the.

Toronto, Canada Area

• Developed requirements and specifications for several InterVoice-Brite IVR engagements;
• Designed, developed, and modified InterVoice-Brite IVR solutions for various clients;
• Developed Cisco Intelligent Call Manager (ICM) applications for several large clients;
• Developed internal web application using HTML and a CGI program (in C) to interface to an ODBC database;

Toronto, Canada Area

Toronto, Canada Area