Derek Williams Email and Phone Number

- Implementation of T-SQL Stored Procedures and optimization of design for Enterprise Customer Initiative. - Advise and present best practices for Enterprise Customer database design. - Database schema creation. Security practices implementation including encryption in Azure and on premises. - Creation and maintenance of Operations manual - Design and process flow documentation. - Assisting co-workers with T-SQL query development and refinement.

Data Integration using SSIS. Stored procedures T-SQL. Development of Key Risk Indicators (KRIs) for ongoing compliance related data across the bank. Data modeling and development. Automation and creation of data pipelines.Design and process flow documentation and source to target mapping.Mentoring Junior SQL developers.

Customization of BigHand's Quantum solution for the unique requirements of Milbank LLC according to design documents and the project plan Modification and enhancement of the SSIS ETL packages from the off-the-shelf solution to the accounting practices of Milbank Enhancing the SSRS front end to facilitate dynamic grouping for real time stratification Implementing and testing changes to existing stored procedures for addition customer graphs of billings, collections and hours. Implementing additions and changes to the SSRS interface as planned in the project wireframes and planning documents. Code documentation and team code reviews

Led the project to demonstrate the feasibility of converting documents to an automated data warehousing solution - Conversion of unstructured documents using Python scripts to structures CSV files - Design of SSIS packages to check file systems for files existence and notify support of issues - SSIS package creation for execution of Python scripts, moving data to staging tables, reformatting and data conversion - Creation of Fact and Dimension tables for tracking and storage of history - Testing and documentation of processes and components created by team - Implemented TSQL scripts, views and stored procedures to support the SSRS reporting system for automated balancing of daily transactional data from the aforementioned files - Created and modified reports at the behest of the IT and Finance subject matter experts

Design and implementation of SSIS packages and stored procedures. Modeling and implementation of algorithms to support the building of Data Marts for the Heavy Equipment Rental company. - Creation of Fact and Dimension tables- Creation of stored procedures to automate BI processes- Reporting on KPIs and assets with Power BI. - Implemented a Graph database in SQL Server 2017 for data mining and insight discovery.- Created a package for dynamic partitioning of large daily staging tables > 2.5 M records.

- Design and implementation of SSIS dtsx packages and data warehouse components - T-SQL Stored procedures.- Collaboration with Business Analysts to create workflows for ETL processes, relational and dimensional models.- Provide support and management for new project development with external Cloud vendor and offshore development teammates.- Oversee SSIS, C# and XML implementations for data validation and management of multiple data sources (flat file and XML).- Apply in-depth knowledge of Visual Studio 2010-2017 and SQL Server 2005-2016 for data management and automated analysis and validation of XML sources.- Manage conversion of project design document specifications into middle tier components for data processing and data integration.

Performed data warehouse maintenance using SQL Server 2005, and 2008 R2. Gained experience with SQL Server 2012, 2014 and Visual Studio 2008, 2010. Provided knowledgeable production support for DB2 on AS400. Directed implementation of business rules through data management and automation of business processes including data validation. Completed data extraction and manipulation of flat files and text files using stored procedures, SSIS and Reporting Services on SQL Server SSRS for automated report generation for review and dissemination. Created and coded SQL scripts in SQL Server for over 200 financial reports. Handled programming ETL using Visual Basic and C#. Oversaw BI (Business Intelligence) processes to meet organization goals of data analysis. Translated Business requirements into SQL Server queries and stored procedures using T-SQL. Managed reverse engineering of IBM DB2 procedures and business processes into T-SQL code and migration to SQL Server for consolidation of multiple sources of data. Led transformation of DTS packages from SQL Server 2005 to DTSX on SQL Server 2008 R2. Generated reports and automated critical business processes using daily and monthly jobs with SQL Server Agent system. Some of these reports contained data sourced from multiple financial institutions. Reviewed and created reports using data from multiple financial institutions for data quality and assessment Maintained Multi- Dimensional Model representation of financial data as needed. Maintained documentation of processes, business rules and business logic for reports and automated processes outlining the integration of multiple data sources. Maintained documentation of database schemas, datasets, scripted procedures and production issues. Created SQL Server Analysis Services (SSAS) cube based on dimensional tables for ad hoc financial analysis; included data from multiple financial sources.

Managed transformation of Access applications to SQL Server 2005. Handled implementation of automated data forecasting algorithms using T-SQL stored procedures. Generated, maintained and backed up SQL Server 2005 databases knowledgeably.Led automation the Extract transform and load processes using Integration Services (SSIS) including data validation procedures. Maintained automated reports based in Excel using VBA procedures.

Analyzed Mutual Fund performance, creating Stored procedures, tables, and views in SQL Server 2000 effectively. Maintained data warehouse of assets and net sales for TD and industry funds accurately. Generated automated monthly reports for senior management regarding market share, assets, and sales, tracking relative performance according to fund company and fund type for executive's data analysis. Analyzed data from multiple financial institutions. Created, designed and coded SQL scripts for financial reports. Implemented process improvements, linking various data sources (Excel, Access, and SQL Server) via Microsoft Query to create reports updatable with current month's data instantly. Created dynamic reports in Excel, presenting different views of Mutual Fund data based on dropdown lists and command buttons (utilizing Visual Basic code and Excel forms). Utilized SQL Server and Analysis Services (SSAS) to create data warehouse and analyses using AS cubes for consolidation of data sources and rapid ad-hoc queries Wrote permanent scripts in SQL for financial reports. Created back end stored procedures. Established reporting services (SSRS) for monthly reporting efficiently. Applied MDX statements to mine data. Oversaw BI (Business Intelligence) development and maintenance of multidimensional data representation. Completed course in Oracle 9i successfully

Created three databases in Access 2000 to collect and report on the progress of branch technology conversions (1,200 sites across Canada). Created reports for the BMO Leadership on types of workstations deployed, created grading reports for analysis and validation of installation teams. Responsible for running queries against the website's back - end legacy database relating to 17,000 workstation installations. Created forms in Access for data entry. Automated the process of data extraction to Excel 2000 for weekly graphical reports. Generated ad-hoc queries against SQL Server and Access data stores to report on installation progress. Consolidated and disseminated those reports to the department leaders

Report generation based on data from multiple data sources including Remedy, SQL Server 2000 and SAS jobs run against the bank's mainframe systems. Office automation for the updating of data on the mainframe, automatic letter generation via Microsoft Word, report generation, employee time logging, employee performance statistics. Ongoing report generation for information related to merchant equipment status, location and the revenue generated through rental. Data validation of the same. User support for the users in the Research, VISA and Call Center departments for data validation. Ongoing expansion and modification of several Access 97 databases in department, their front-end forms and collection and automation of reports. Creation of processes using Access macros. Support for Western and Eastern divisions of the VISA department and dissemination of reports to the aforementioned regions.

Created an Access 97 application to collect data from twelve business units within TD Canada Trust. This project was initiated to track performance related metrics during the merger of TD Bank and Canada Trust. Converted data through Visual Basic code within the application to produce a series of reports which closely modeled the structure and consolidation style of a pre - existing Excel data collection template. Designed a section of the corporate website to host PDF files containing data for each business unit's statistics and Excel data from the Access application. Created an installation CD to allow multiple business units to enter metrics from front end Access forms to a backend database.

Charged with automation of the Customer Service Department for Image Processing Systems This project involved the creation of a Customer Service database built initially using MS Access 97 then modified for Access 2000 with the long term goal of conversion to a web application using MS Visual InterDev, ASP (Active Server Pages ) , ADO , MS SQL Server