
Hello! I’m a data analyst for Sales & CX teams.
Summary
I have 7 years of data analyst experience within Sales and CX teams in SaaS startups, with strong emphasis on data analysis and data visualization (including ad-hoc analysis and reporting automation). I have 10+ years of Google Sheets experience, 3+ in SQL (Redshift, PostgreSQL), 3+ in Looker/LookML, and versed in Tableau and Google Data Studio.
Sample Projects
- Baton Rouge Traffic Incidents, 2021:
Google Data Studio - Visualizing TV Shows Added in 2021: Tableau, Python
- Surfacing Initial Sales Performance Trends: Tableau, Google Sheets, Google Data Studio
- Looker & LookML Projects: Dashboards, Views, and Project Calendar (Upon Request)
Recent Experience, Highlights
Looker Developer Consultant — Dec 2021 – Present
- Serve as a LookML developer or data visualization expert, dependent on project scope, with strong focus on CRMs (Salesforce, Zendesk) and other Support and Sales-oriented SaaS systems
Sr. Analyst: Go Disco — Feb 2020 – Oct 2021
- Defined initial Sales success metrics for GTM campaigns; generated reporting using Tableau (Public), Google Sheets and Google Data Studio
- Generated about 11K+ business leads in Auckland and Sydney using Jupyter Notebook and web scraping in Python (BeautifulSoup)
- Implemented process automation projects across the organization, using Zapier, APIs, and systems such as Mailchimp (customer journey), Zendesk, PandaDoc, Rippling, Slack (Workflow Builder), and JIRA; Sales process automation reduced sign-up process from 30 mins to 5
Sr. Analyst, Business (Care & Operations): ShopKeep by Lightspeed — Feb 2015 – Sep 2019
- Used SQL (Redshift) and LookML to create a semantic layer for Care and Operations, primarily from Salesforce objects; served as SME of the department’s Looker space
- Built and automated Looker dashboards for departmental key metrics; implemented the technical component of data cleaning initiatives, including legacy customers clean-up and support cases clean-up
- Lead exploratory and ad-hoc reports for cross-functional initiatives using SQLRunner and Google Sheets, impacting Sales, Product, eCommerce, HR, and Training
- Reported on Customer Care’s 24/7 workforce scheduling; developed a scheduling program in Google Sheets (which included a time-off tracker, attendance scorecards, timezone support, and lead dashboards)
Education
Data Scientist In Python (Data Science), Dataquest.io — 2020
Full Stack Web Development, PDX Code Guild — 2015
MIS, Information Technology, University of Phoenix — 2012 – 2014
IE was a force to be reckoned with during his time at ShopKeep… His passion for data and creating reports that answer critical questions made him an extremely valuable part of my team. I love IE’s drive to build great things, answer complex questions with data, and desire to help others succeed.
Kyle Thiemke, Senior Director at Lightspeed