Data Architect supporting and building the next generation of the flagship linear advertising platform. Adding AI Model metrics to buy lines, developing an AI driven development process used within the data team. Migration of on-premises servers to Azure cloud servers. Overall support of the linear advertising buying process.
Marketing Architects, Inc.Jun 2022–Jun 2023
ERP Integration. Architectural assessment of Pivotal platform resulting in roadmap in Wrike. 19 modules targeted for migration and coexistence with 8 related applications. Migration of accounting to MS Dynamics Business Central. SSIS packages for A4 invoices, SSRS reconciliation reports.
Marketing Architects, Inc.Sep 2020–May 2021
ERP Migration from Pivotal to in-house solution. Architectural assessment of legacy ERP/Workflow platform. Roadmap targeting technology replacement with internally developed applications.
Marketing Architects, Inc.Aug 2008–Apr 2011
SQL Server SSIS / SSRS / Transact SQL. ERP migration architecture. Domo Workbench integration.
Lead developer in the MediaGuide spot detection application. This SQL Server SSIS solution processes radio airings provided each day by MediaGuide and matches those airings to customer calls and orders, creating records directly in Marketing Architects CRM solution. Developer of Transact-SQL for Planning and Performance application, joining CRM and station airing data into a daily refreshed aggregated view of data for media planning. Developer of numerous reports in both SSRS 2005 and 2008, supported by Transact-SQL stored procedures.