Dan Williams Email & Phone Number

Elkridge, Maryland, Us

Bethesda, Md, Us

• Provide guidance on technical details for contract proposal.• Develop technical specifications for proposed analytics solution.

Washington, Dc, Us

Worked with analytics teams to develop reporting and data mining database tools on the Netezza IBM PureData platform. Applied extensive Netezza experience to provide guidance toward best practices in new development, improvement of existing processes, and developing a knowledge base at SEC for existing resources.Database Developer III 2016 – Sept 2017• Developed and implemented complex round-trip reporting ability to measure security trading activity over time.• Designed and implemented new analytic reporting as requested by the client. • Developed name matching process to link identity records without comparable IDs• Implemented schema standardization for consistency across multiple instances of testing, development, and production environments.• Implemented code repository for SQL code management.• Developed technical documentation for code and references within the database solution.Netezza ETL and Database Consultant 2014 – 2016• Drove optimization and best practice application as subject matter expert of new Netezza-based data environment. • Designed and implemented new analytic reporting processes in NZSQL and NZPLSQL stored procedures. • Improved existing processes in both functionality and performance by applying unique hardware insight. • Designed and implemented an ID reference structure to increase performance 200% - 300% during database updates and report generation. • Implemented database schema standardization for reference consistency across multiple instances of testing, development, and production environments.• Developed technical documentation for Netezza basics as well as documenting the database solution.• Converted existing processes from SAS environment to execute within the new Netezza environment.

Columbia, Md, Us

Led the database development and operations teams within the United States, Canada, and Latin America. • Managed a team of ten developers, three business analysts, two account managers, and several production and QA resources through the full SDLC to implement new change requests and maintain on-time operations.• Drove on-time and accurate database operations execution, as well as campaign planning and execution, enabling the client to leverage an accurate and extensive database to compile marketing campaign strategies. • Managed resource allocation, budget forecasting, executive status reports, and database development and operations project plans. • Managed campaign model performance testing, as well as population segmentation for optimal audience selection.• Led on-boarding of new Latin American consumer database for marketing campaigns and BI analysis. • Implemented the automation of production processes, creating daily automated database updates and analytics reporting. This reduced manual operations by over 50%, allowing resources to focus on quality control. • Upgraded the solution to take advantage of new Netezza functionality, such as using NZPLSQL to create stored procedures.• Worked closely with analytics department leaders to coordinate campaign strategy and performance analysis.• Developed scripts that generated real-time alerts for managing Netezza server space and contention issues.

Columbia, Md, Us

Fully accountable for all campaign work for a Fortune 50 client covering the United States and Canada. Developed and managed complex campaign scheduling and planning to coordinate campaign selection and back-end analysis. Advised program lead on technical architecture.• Maintained a 100% on-time and accurate campaign execution record. In seven years of building or owning this process, never missed a single deliverable date, eliminating additional printing, manufacturing, and mailing costs for the client.• Generated between 5 and 15 distinct campaigns per month, with audiences averaging 10,000 records for triggered campaigns and up to 65 million for large-scale campaigns, driving hundreds of millions of dollars in revenue per quarter.• Developed and automated event-driven multi-touch marketing campaigns.• Integrated consumer data from a key financial subdivision to allow cross-marketing and increase membership.

Columbia, Md, Us

Assisted Program Director to ensure the overall health of the project and maintain flawless production and campaign execution. Managed the full scope of the campaign process, including initial client conversations, technical specifications, vendor coordination, and post-campaign analysis. Retained all Production Manager responsibilities. Several direct reports.• Oversaw changes in database update process to move from weekly updates to daily update.• Implemented changes across solution to allow for multi-touch attribution of marketing promotions to purchases, adding the ability to cross-market to audiences and measure the effectiveness of multiple contacts across channels.

Columbia, Md, Us

Managed dynamic scheduling and execution of all data warehouse operations. Worked closely with the client to coordinate deliverable dates and production cycles, and maintained an outstanding record of on-time and accurate delivery. Managed transition to next generation Netezza hardware.• Integrated Canadian consumer data to expand marketing reach, developed new campaign processes for new regions.• Integrated customer email data to enable email campaigns in addition to direct mail, as well as cross-channel campaigns.• Restructured existing production cycle to implement the transition from a monthly database update to a weekly update.

Columbia, Md, Us

Implemented complex database projects. Worked within one of the largest and most complex databases in Merkle, consisting of 250 million sales transaction records, 100 million residences, 150 million customer and prospect individual records, and well over 1 billion campaign promotion history records.• Created functional and technical specification documents for change requests.• Developed code for new database functionality, as well as extensive client and BI analytics reporting.• Drove improvements to existing processes, improving performance as well as data health visibility.

Columbia, Md, Us

Developed SQL processes to generate direct-marketing campaign lists for a Fortune 50 client, the largest Merkle technology client in revenue. Executed existing production processes to update reporting and database environments. • Contributed to Merkle’s first Netezza replatform project, converting and testing code from an existing SQL Server 2000 environment to NZSQL for an early-generation Netezza server. Solution performance dramatically increased for operations, analytics, and reporting processes. This work paved the way for other clients at Merkle to take advantage of the technology.• Managed all data inputs to the database, including any list conversion, QC, or input reporting required before updates. These files ranged in size from a few dozen to 110 million records, depending on the source.• Generated extensive post-update quality reports for validating production accuracy and database integrity.• Implemented minor database change requests, reports, and extracts.