Patrick Seise

Merkle Inc.

01.2020 - Current

Queried, cleaned, and QA'd large data sets using SQL in multiple cloud environments, such as Snowflake and Google Cloud, to build tables and views.
Developed, maintained and improved dashboards in Tableau and Google Looker Studio to effectively visualize data, and extract impactful insights.
Led and collaborated with team members to produce monthly and ah-hoc reports to assist the client in making informed business decisions.
Facilitated client facing meetings and presentations to deliver analytical insight
Assessed KPIs to achieve in-depth understanding of campaign performance and monitor user behavior.
Utilized Fico Credit data to analyze and profile customer segments for direct mail marketing campaigns.
MINI Monthly Reporting: Updated Customer Analytics dashboards and Excel workbooks, to build out Power Point decks. Investigate important observations by progressively getting more granular in the data to uncover the drivers of said observations. Led monthly analysis meetings with the client to communicate easy to digest analysis, and highlight key insights
Stellantis Geostats Dashboard Enhancement: Built tables using SQL in Google Cloud Platform to incorporate geographical sale data with geographical spend data. Stood up 4 dashboards at varying levels of granularity to analyze the efficiency of client spend, and identify opportunities for the client to improve efficiency through strategic geographical targeting and limiting wasteful spending.

Summary