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 the document repositoryDocumented existing code using Visio, Excel, and Word for use in designing new solutionsAdded functions and VBA code to several of the Excel and Visio documents to automate data entry and to perform error checking

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 warehouseo Intranet site to allow business users to update vendor informationo Programs to zip/unzip, encrypt/decrypt, and import/export files on-the-fly based on configuration files, and send emails upon completiono Solutions to extract data from the Supply Chain system and present to user for corrections, submit corrected data back for processingo Test harnesses to support development, testing, and trainingo Migrated data between SQL Server and OraclePerformed various operational duties as requiredo Deployments of Internet, intranet, and database projectso Database administration duties such as database and table design, optimisation of tables, queries, and indexes, scheduling backups, and troubleshootingo Troubleshooting problems with Windows Server, desktops, and IIS using standard system toolsTechnical lead for new retail commission system (T-SQL, C#.NET, SSIS)o Led design sessions with internal stakeholders and external partnerso Developed code to link new system and existing data sourceso Maintained and enhanced system post-productionCreated numerous database scripts and stored procedures (T-SQL, Crystal Reports)Produced support documentation and training guides for projects

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 various contact centresCollected customer requirements, documented designs and presented solutionsParticipated in design sessions and walkthroughsReceived two team awards, one for IVR and one for workflow

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