Project: OPGT Modernization• Member of team migrating a legacy On-premise Oracle system to MS Dynamics 365 in Azure.• Developed SQL procedures used within an Azure MDP ETL process implemented in Azure Synapse / Data Factory.• Developed and maintained ETL pipelines in Azure Data Factory and Synapse Data Analytics.

Translated ~200 legacy SQL Server stored procedures to AWS Mysql / AuroraDesigned and implemented a message-queue based auditing / logging system in AWS (SQS and Lambda functions)Migrated 4 live SQL Server databases to AWS MySql, using DMSOptimize / tune long-running reportig queries in MySql

Project: IFRS17 DWH (Development Lead)• Developed and deployed a data warehouse system for IFRS17 financial reporting. Project: Group Health Financial Reporting (Development Lead)• Implemented a database system to import and process Premium, Claims, and Commission data from multiple sourcesProject: FinRe (Architect / Development Lead)• Designed system to manage existing and proposes FinRe 'Deals' and prepare IFRS9 and Statutory Financial reports.

Developed VB.Net Console and Desktop applications to: Integrate the client’s e-commerce website shopping cart and their Quickbooks accounting system. Automate credit card payment processing from Moneris and integrated payments with QuickBooksDeveloped VB.Net Desktop applications for inventory management and order management (Stock-taking, product picking / shipping / inventory management).

Enterprise Risk data warehouse project Supported and maintained an existing data warehouse implemented on IBM Netezza appliances.  Developed tables and loading procedures to support new dimension and facts according to client specifications. Prepared run books for weekly and monthly code deployments and performed non-production code deployments. Performed peer reviews on other team members’ code. Migrated Netezza code to Pivotal’s Greenplum database (a Postgres… Show more Enterprise Risk data warehouse project Supported and maintained an existing data warehouse implemented on IBM Netezza appliances.  Developed tables and loading procedures to support new dimension and facts according to client specifications. Prepared run books for weekly and monthly code deployments and performed non-production code deployments. Performed peer reviews on other team members’ code. Migrated Netezza code to Pivotal’s Greenplum database (a Postgres implementation).Environment: Netezza, Greenplum Show less

Responsible for migrating data from legacy system into multiple new and existing BMO target systems. Led a team of two developers in migrating the customer information of BMO / Harris Bank on-line (mobile / web) banking to a newly developed platform. Architected data migration from legacy system into multiple (7) existing and new bank systems Developed and implemented procedures to transfer 860,000 customers from the old on-line system to the new platform. Administered the… Show more Responsible for migrating data from legacy system into multiple new and existing BMO target systems. Led a team of two developers in migrating the customer information of BMO / Harris Bank on-line (mobile / web) banking to a newly developed platform. Architected data migration from legacy system into multiple (7) existing and new bank systems Developed and implemented procedures to transfer 860,000 customers from the old on-line system to the new platform. Administered the development database server Prepared deployment scripts and run books for Production deployments Input was received in a set of comma-delimited text files. It was loaded into a SQL Server database, validated, cleansed, and transformed into a set of outputs to be consumed and verified by the target systems. File formats and data encoding (ASCII, Unicode, UTF8) had to be used to match each target system’s requirements. In some cases, direct access to target databases was granted, allowing direct data transfers to the target system in SSIS. Show less

 Led a team of three developers in creating ETL processes for loading daily data feeds into ODS database of CAPCO client Sainsbury Bank Architected process control and daily load routines for multiple (9) source systems Authored Code Generator tool in C# to generate SSIS packages from table metadata Data was parsed from a set of flat files delivered to the ODS environment on a daily basis. The ETL process converted the data from ASCII and UTF8 format to Unicode, then merged the… Show more  Led a team of three developers in creating ETL processes for loading daily data feeds into ODS database of CAPCO client Sainsbury Bank Architected process control and daily load routines for multiple (9) source systems Authored Code Generator tool in C# to generate SSIS packages from table metadata Data was parsed from a set of flat files delivered to the ODS environment on a daily basis. The ETL process converted the data from ASCII and UTF8 format to Unicode, then merged the data into both an ODS and historical database. Show less

Analyzed and investigated data sources for data quality and completeness.Developed and optimized T-SQL solutions (tables, views, indexes, queries, functions) needed to produce the reports specified in the system requirements documents (SQL Server development).Developed SSRS reports using T-SQL and DAX to system specifications.

Developed and maintained SSIS packages to load data from Excel spreadsheets into the corporate data warehouse. Extended existing cubes in the warehouse. Developed an automated system for comparing and verifying DW cubes in the Development and Production environments.

Created an enterprise data warehouse using SSAS to monitor province-wide bed and resource utilization. Coded ETL using stored procedures processes to load the warehouse using SSIS. Developed MDX and T-SQL queries for reports. Authored reports using SSRS for use within the website. Developed auditing sub-system for the CritiCall Ontario Provincial Hospital Resource website using SQL Server 2012 CDC features, triggers, and Service Broker. Worked on multiple BI and Reporting projects for Navantis… Show more Created an enterprise data warehouse using SSAS to monitor province-wide bed and resource utilization. Coded ETL using stored procedures processes to load the warehouse using SSIS. Developed MDX and T-SQL queries for reports. Authored reports using SSRS for use within the website. Developed auditing sub-system for the CritiCall Ontario Provincial Hospital Resource website using SQL Server 2012 CDC features, triggers, and Service Broker. Worked on multiple BI and Reporting projects for Navantis customers (Hospital for Sick Children, LV Lomas Inc.). Tuned and refactored queries to improve performance and eliminate deadlocks. Show less

Provided DBA services for 20 application groups within the bank and its associated companies. Maintained SQL Server 2000, 2005, and 2008 database instances. Performed database and index tuning, maintained SQL logins and user accounts, deployed databases and maintenance (SQLAgent) jobs to development, QA, and Production environments. Consulted with application groups to improve stored Procedure and SSIS package performance. Instituted source code management practices for database schema changes… Show more Provided DBA services for 20 application groups within the bank and its associated companies. Maintained SQL Server 2000, 2005, and 2008 database instances. Performed database and index tuning, maintained SQL logins and user accounts, deployed databases and maintenance (SQLAgent) jobs to development, QA, and Production environments. Consulted with application groups to improve stored Procedure and SSIS package performance. Instituted source code management practices for database schema changes for all mid-range database technologies (SQL Server, Oracle, DB2, ADABAS) in the bank’s SCON environment. Show less

Analyzed and tuned loan payment database system. Instituted indexes and maintenance changes aimed at reducing batch execution times from 8 hours to 4 hours. Provided scheduled and on call DBA support for Production and UAT systems. Performed code and schema deployments to Production and UAT systems.

Re-built national data warehouse, with emphasis on improving data quality and accuracy of national sales and leasing data. Introduced proper data cleansing and de-duplication procedures to improve data quality of information coming from AS400 systems. Created interfaces with Oracle-based Siebel CRM system. Maintained existing internal reports developed using Crystal Reports. Created system for processing data captured at all 2010 Auto Shows.

Implemented payment-processing module using SQL Server 2005. Module interfaces with MS Dynamics 4.0 to extract data, perform payment processing, and then update the CRM database. Designed Payment database in SQL Server, coded payment processing in SQL, and developed SOAP routines in C# to interface with MS Dynamics via web service calls. Developed reports with SSRS and integrated them with CRM application.

Developed data loading packages in DTS. Performed database and server tuning using Microsoft tools (Perfmon, Profiler). Identified and optimized poorly-performing queries. Maintained Production ERD model.Maintained Dev, Test, and UAT database environments. Performed code and schema deployments. Prepared and tested ‘build-books’ and documentation for deployments performed by client. Migrated system to SQL Server 2008. Project is the Ontario Wait Times Information System, developed for… Show more Developed data loading packages in DTS. Performed database and server tuning using Microsoft tools (Perfmon, Profiler). Identified and optimized poorly-performing queries. Maintained Production ERD model.Maintained Dev, Test, and UAT database environments. Performed code and schema deployments. Prepared and tested ‘build-books’ and documentation for deployments performed by client. Migrated system to SQL Server 2008. Project is the Ontario Wait Times Information System, developed for Cancer Care Ontario / MOHLTC.Developed system monitoring and maintenance scripts using VBScript and deployment tools using C#. Show less

Mixed production & development DBA. Maintained VLDB-type databases. Assisted in database design. Supported / maintained development, SIT, UAT, and Production environments. Developed datamarts and cubes with SSAS. Maintained and debugged SSAS ETL packages.

SQL Server DBA and report developer on a RAD development team. Responsible for developing stored procedures, reviewing procedures developed by other team members, designing physical databases, developing management reports, and managing multiple development, testing, and production databases. Data loading, system optimization (performance tuning), and code deployment are also part of my responsibilities in this position.

Resposible for maintaining the databases and applications that form the BETA sytem, which distributes bulk liquid fuels from refineries to retail outlets. Specialized in MS SQL Server development and support, as well as development of application code in C, C++ and VB6. Areas of expertise include process control, sockets programming, system services, and multi-threaded application development.