John Von Holten Email & Phone Number

Anaheim, California, United States

Used Tableau to create Marketing spend and conversion dashboard. The dashboard shows data by marketing channels over time. Used R Studio to combine summarize data from multiple sources.Used R to create a script that reads customer data from MSSQL database and create an data feed for the Adobe Analytics platform.Reconciled Adobe customer selections with lists generated from MSSQL.

New York City Metropolitan Area

Created mailing lists of prospective customers based on vendor supplied names. Needed to make sure prospective names were not already customers. Determined how many new customers were added after each mailing.Analyzed purchases that used a gift card as payment. Determined how much of the transaction was paid by gift card and how much was paid by another payment method. Analysis was used to determine how much additional revenue was generated.Analyzed Klarna payment transactions. Looked at the customers using Klarna to determine if they were new customers.

Greater New York City Area

Created customized reports of financial transactions for the Legal and Compliance department for FINRA and SEC investigations. Worked closely with senior level management in Finance and Marketing to analyze client transaction data to predict revenue growth and trends. Used data mining tools such as Teradata SQL Assistant and MS SQL Server Management Studio to query and analyze large and complex data sources. Created technical specifications based on business requirements.