In 2016 I made the decision to transition from a hands - on management career to a technical MS-SQL consulting focus, since then I have successfully held multiple contracts, each of which has been extended. In these focused, technical projects, I have proven that I am more than capable of interacting with a broad range of colleagues from infrastructure to senior stakeholders. My ability to communicate well and understand requirements, coupled with my technical acumen, helps me produce solutions that meet, often exceeding, requirements.
One of my core strengths is performance tuning. In part I excel in this area due to my coding skills (stored procedures, views, functions, SSIS, SSRS) and through my understanding of the MS-SQL toolset. When designing databases my expertise and experience lends itself to building an ecosystem, from load to archiving, that is well documented, performant and most of all, provides a strong stable platform for the future. I have successfully stabilized huge overnight batch processes, reducing call out rates from a nightly occurrence to call-outs being the exception. In each contract, I left a customer with a fully documented solution that exceeded their expectations.
Prior to transitioning from a hands-on managerial career to a more technical focus I was well versed in leading Agile and Waterfall projects. In fact, in many of my contracts I was also used to help with Agile and implementing the Atlassian toolset.
“Dave has a natural skill to communicate effectively at all levels of business and technology. His calm demeanor and effective communication style make him a likable individual to work with, and a key asset to any team. His technical knowledge and ability to deliver on point and on time displayed a work ethic that made working with Dave a pleasure. “
Gabe Moncada (Customer Success Manager)
SQL Server 2008/R2, 2012 and 2014
SQL Server Integration Services - 2008/R2, 2012 and 2014
SQL Server Reporting Services - 2008/R2 and 2012
PHP, C#, VBA (Excel, Word and Access) & VB-Script
XML & XSD
NON-COMMERCIAL experience: Python, & Linux (Debian) administration
Confidential, Addison, TX
My role within the Global Internet Security team involves ingesting large data sets from diverse sources into the department’s Hadoop data store using PHP on a Linux platform;
Data is transformed from various sources, MySQL, Oracle, Web API extracts of XML & JSON data, and re-enriching Hadoop data amongst others;
Making data available for downstream Clouderia reporting services;
Liaising with End User Computing (EUC) teams to support and migrate Excel process to IT supported platforms;
Providing guidance to the team to transition to Autosys from a cron based scheduling system;
Second level production support.
Senior SQL Developer
Developed and implemented monitoring enhancements resulting in full tracking and reconciliation for all MS-SQL Service Broker messages;
Designed and implemented a reporting framework in SSRS providing near-real-time monitoring and alerting of Service Broker messages;
Diagnosed and resolved multiple long-standing data inconsistencies with the company’s web front end team.
Supporting and extending a MS-Access based system, adding new workflows, providing day-to-day support and enhancing MI.
Developed a flexible process to bulk upload transactions into the MS-Access system saving approximately three month’s effort to manually capture data per annum;
I moved overnight data extracts and reporting off MS-Access platforms onto MS-SQL using SSIS & SSRS. This allowed a wider group to support the reports and more than halved the runtime of the overnight processes;
Developing data feeds between MS-SQL databases using SSIS reducing manual capture and dual updates, this saved on average an hour a day;
Redesigned a MS-Access based Trade Reconciliation process, reducing runtime from more than two hours down to less than an hour;
Developing new stored procedures supporting migration from a legacy OLTP system, all stored procedures outperformed the heritage procedures;
Providing first-line support;
Introduced best practices to the team with respect to source control in TFS and documentation using Confluence;
I assisted in the team in Agile processes and developed workflows and reports in Jira.
Integrating an OLTP Product Control system with an OLTP Front-Office system;
Liaising directly with all interested parties from BAs to end users to downstream development teams;
Trained the production support team while providing first line support during the transition to my system;
A core report incorporated two of the slowest legacy reports, the final report that I delivered was faster than either of the legacy reports;
SME for the Departments’ transition to Jira and Confluence, developed, implemented, and supported the Departments’ Jira workflows and process.
ETL Development Manager
The team of four Database developers that I managed had its primary focus on dataflows into the bank and the majority of external data feeds and extracts;
I was a member of the Bank’s IT Audit committee ensuring that process and systems are fully compliant with internal and regulatory controls;
Responsible for the implementation of the companies’ data governance and data obfuscation, which we developed, models;
Stabilisation of the Bank’s OLTP Operational Data store, working with third-party data providers on data feeds, redesigning the process in SSIS to be more resilient, and improving alerting. We moved from almost daily outages to the only failures occurring when the data provider changed structure of files without notification;
Design of new strategic payments process, moving from a disjointed system-based process to a service-based model. This reduced “data at rest” to a minimum improving audit and security controls;
Our team, myself included, supported MS-SQL & SSRS production systems - covering for production DBA’s;
Lead developer and support for Bank’s Jira and Confluence instances. Developing workflows, process, and associated reports.