Designs, assesses, and implements multiple high profile data projects writing complex ETL processes.Rebuilt the crucial State Farm marketing household contact program’s pre and post data processing used for 70-80 corporate marketing campaigns for US and Canada customers of 8-10 million records per month. This facilitated in standardizing the files outputted from Unica Campaign for print and email.Built a large ETL process using SAS, accessing multiple DB2, Hadoop, AWS, and Excel data sources for a major marketing analytical environment. Brought data project from concept to implementation to automation using Python and KornShell. This was the first agile data project in Marketing using Kanban. Five million to 30 million rows are sent to the environment on a weekly basis since 2018 with additional data sources added as needed. Graphing of record output and data groups are used for weekly validation.Continuously developing and managing a smaller, high profile monthly data project assigning marketing subsidy dollars to each of its 19,000+ State Farm agents. Support of more than ten internal and external data vendors with the creation and output of CSV files and Excel reports using SAS.Large scale monthly load of small business data with over 110 million records. Built an extraordinarily complex set of tools for lead assignment based on latitude and longitude of office to business, agent rankings, control groups, and multiple suppressions with SAS. Additionally designed load tables, lookup tables, views, and optimized indexes for marketing campaigns in DB2.Python PDF scrape of text for previous year of hundreds of PDFs for an annual compliance project. New creation of PDFs for the current compliance year of 700-800 State Farm agents’ current office data.

Product support for Enterprise applicationsSupported the installation DB2 products on over 60,000 Windows workstations and servers, including DB2 Runtime Client, DB2 Personal Edition and IBM Data Studio.Supported the ODBC and OLE DB connections with all State Farm homegrown applications that connected to DB2 via Windows. Performed connection traces on Java and Visual Basic applications and partnered with IBM support on solutions.Built issuances to release hotfixes and/or fixpacks to the Enterprise.Helped support and fix Visual Basic applications for three applications, which was outside of normal duties.Designated team lead of three individuals for just under three years.

Developer of pivotal applications for a small company working with large organizationsAs a programmer, developed applications with data from multiple fortune 500 insurance and financial companies, to support the marketing activities using FoxPro, Visual Basic, SQL Server and VB.NET.Developed internal automation systems for Direct Mail programs, constructed UPS and FedEx shipping related applications for others to interface with, agent related graphics conversion, tracking and logging and Quality Control auditing applications, and developed print files using PostScript for large scale Xerox high-capacity printing as a Developer. Led a team of 6-8 individuals as a Variable Solutions supervisor for the daily production of direct mail print files through the postscript language for both black and white and color Xerox printers.