Rose Hoffman Email & Phone Number

Saint Paul, Mn, Us

San Francisco, California, Us

• Used GA4 to analyze website usage metrics (end-to-end customer journeys & customized application tracking) and channel acquisition for financial institutions• Utilized BigQuery to optimize report functionality and cluster users by audiences/activity and visualize using Looker Studio to create meaningful dashboards for leadership and marketing teams• Created customer segments based on website activity to personalize sessions & optimize conversion rates on product ads

Milwaukee, Wi, Us

• Provided end-to-end, automated data pipelines which transform raw data tables into seamless Tableau reporting solutions for a start-up, DTC e-commerce company• Developed complex Tableau relationship models for a curated data self-service experience that’s approachable for stakeholders with & without data backgrounds• Created and transform Redshift data marts through the use of dbt Cloud’s ELT framework• Administered Tableau Online by creating content, adjusting permissions, assigning roles, and onboarding new users• Gathered requirements from stakeholders to define KPIs and create dashboards that describe changes within the business & foster data-driven decisions• Optimized queries/SQL logic, tackle bugs upstream, and QA for data edge-cases to maintain a comprehensive view of data accessibility/accuracy within the warehouse • Launched a system migration and independently transitioned all existing reports from Sisense (Periscope) into Tableau

Medina, Minnesota, Us

• Created a portfolio of reports using Power BI and Alteryx to automate the analysis of USMCA Trade Agreement impacts on off-roading vehicles utilized by stakeholders across the business• Conducted part/supplier scenario analysis to be more proactive about the qualification status of vehicles and mitigating up to $100+ million in off-road vehicle duties• Eliminated a day long manual process to create vehicle build files utilized by analysts across the company by developing a complex Alteryx flow that was automated and ran in under 6 minutes• Reported out to new vehicle product teams to keep them updated on the qualification status of their prototype builds and help them re-work sourcing decisions where needed• Created Alteryx processes to standardize numerous USMCA considerations such as self-produced profit factors, vehicle production volumes, and sister plant parts crossing international borders

Us

• Developed consumer lending dashboards in Tableau for leadership to monitor loan details with clickable actions and the ability to dynamically filter views• Constructed k-means clustering models in R to categorize lending customers and help the retail lending product team develop new products to suit customer needs• Investigated unexpected changes in KPI’s and escalate issues with sending automatic emails from the Tableau Server to the appropriate stakeholders• Merged external data with internal databases with Alteryx to create a holistic customer profile for the wealth management teams and detect TCF account growth opportunities• Educated team members on how to use R to manipulate data and explained how to analyze statistical methods during model selection • Tackled massive tables of data and efficiently processed/visualized queries > 100 million rows• Collaborated with data engineers to centralize and test the new lending data within EDP

Us

• Modified configurations and made styling changes on the TCF Bank mobile app & online banking platform using HTML• Created reports for the digital team to track online money movement transactions, customer self-service events, attrition/engagement metrics, and device usage• Monitored audit and customer activity logs to detect unusual activity• Investigated negative customer app reviews and escalated potential feature or device-specific defects• Created reports on app impressions, app versions, active devices, and platform versions to quantify customer impact of feature releases, defects, and mobile application platform uplifts• Pushed configuration changes into production and helped with new feature releases such as account to account transfers and increased mobile deposit limits

Ames, Iowa, Us

• Compiled and organized account data for financial reporting • Automated financial reporting of departmental accounts and grants using spreadsheets• Reconciled departmental accounts for current fiscal year• Completed bi-monthly payroll for hourly, undergraduate computer science students• Assisted in the Accreditation Board for Engineering and Technology (ABET) process for the undergraduate computer science program