Kyle Yates

Worked with data science team to automate email campaign groups in Python, R and SQL into audiences in RTCDP Utilized GA Universal Analytics for ad-hoc analysis on user traffic on site including Looker for reporting on LinkedIn Ads ROI Leveraged Power BI and Adobe Target for A/B testing and web marketing campaign performance Created an Abandoned Cart Dashboard for the sales team to provide high value cart leads to sales reps

Developed a KPI data dictionary, identified website challenges, top terms searched as well as email campaign performance using Acoustic, SAP Marketing Cloud, Google Analytics 360, Segment and GA4 to increase conversion rate and revenue of Moen Owners to support ecommerce team Partnered with GIM team to implement website error pop-up tracking in FullStory, resulted in IT resolving high impact website errors in customer journey and decreasing cart abandonment Implemented a low stock alert on Moen site to increase customer engagement and inventory management for low stock items Presented data reporting using Qlik Sense with documentation and hosted training sessions to cross-functional teams including our Chief Marketing Officer (CMO)

Organized data for the wholesale division including testing, reporting and insights for sales, marketing and operational elements Identified website traffic using Google Analytics, email campaigns in Pardot and activity in Total Expert to monitor user behavior Worked with the sales team to provide data from Salesforce on the full lifecycle of a sale including audits to perform necessary connections between Salesforce data and our main database Trained new analysts on the team as well as stakeholders on data definitions and how to use tools such as Microstrategy

Improved current processes by implementing a competition report analyzing Upstrēm Inc. vs competitors Improved current processes by implementing a competition report analyzing Upstrēm Inc. vs competitors Assisted in design of automated processes with bots using WinAutomation Collaborated with another data analyst on data flow, data testing and data structure using MySQL  Assembled and analyzed data for business reports, making sure data and calculations are accurate Incorporated data modeling as well as dashboard and report management using MySQL and Python in MODE Analytics Identified inventory issues which created solutions for inventory items

Introduced a Tableau tutorial session presentation to several program directors on how to use Tableau Server to access data visualizations Utilized Tableau Server and Tableau Desktop for enrollment and tuition data for the marketing department and programs teams  Connected data sources and created prototypes for data models such as bubble charts, trend lines, bar graphs, geolocation, data tables/matrices in sheets, dashboards, stories and created columns using SQL Organized Excel spreadsheets using VLOOKUP, pivot tables and graphs in Excel

-Nonprofit organization I had the pleasure of working with during their summer internship -Contacted district directors, principals, admin, and school staff for contract renewals -Expanded computer skills using Salesforce.com -Communicated with a team of contract specialists for contract renewals

-Reached out to local businesses to establish relationships with business owners -Managed the Facebook page for Homestreet Bank in Kearny Mesa -Hybrid job of bank teller and sales associate

-Participated in organization of six local Jazz 88.3 events -Performed pre-recorded voice spots in the recording studio -Promoted Jazz 88.3 merchandise for San Diego Jazz events

-Sales mentor for multiple tellers in the Mighty Central District -Sold credit cards/referred checking accounts to customers -Handled deposits, withdrawals, Western Union and cash advances