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

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.

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

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