Allan Fox Email & Phone Number

Toronto, ON, CA

Toronto, Ontario, Canada

• 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.

Toronto, Ontario, Canada

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

Toronto, Canada Area

• 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.

Toronto, Ontario, Canada

Toronto, Ontario, Canada

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.

Toronto, Ontario, Canada

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..

Toronto, Canada Area

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.

 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.

Toronto, Canada Area

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.

Toronto, Canada Area

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.

Toronto

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.

Toronto, Canada Area

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.

Mississauga, ON

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.

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.

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.

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.

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.

B.Sc., Computer Science, Urban Geography

Education record