Katy Yarke
Minnetonka,MN
Summary
Experienced data professional with 9+ years in converting intricate data into clear insights and recommendations. Skilled in SQL, Tableau, and Power BI, specializing in effective data visualization techniques. Track record of producing impactful data analyses that enhance business outcomes.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Data Scientist
U.S. Bank
03.2022 - Current
- Assisted in setup and development of IT, UAT, and Production databases for two annual review applications serving over 2,000 users.
- Managed user permissions and rights within SQL databases in SSMS.
- Developed and maintained over 50 interactive dashboards in Tableau and Power BI for real time business metric visualization.
- Created models and reports by querying an enterprise data warehouse with over 100 million records.
- Spearheaded business conversion process, extracting data for over 5,000 new customers to analyze and recalibrate pricing.
- Developed Alteryx workflows to extract, clean, transform, and load data from multiple sources onto a Tableau server.
- Converted over 50 Presto queries to SQL for execution in Azure Cloud database.
- Analyzed customer portfolios to identify potential revenue uplift, resulting in a $60K increase in revenue.
Business Operations Analyst
U.S. Bank
05.2017 - 03.2022
- Improved efficiency by 50-60% by supporting the automation of the departments manual processes through writing VBA code and deploying 45+ macros.
- Facilitated data retrieval and Ad-Hoc reporting by formulating exportable Excel reports and writing SQL procedures, leading to enhanced operational efficiency and cost reductions by 15%.
- Harnessed SSMS, Toad Datapoint, Presto and Hive to query and manipulate large datasets with 20+ million records for analysis and reporting.
- Extracted key observations and insights from internal data sources to drive decision making.
- Built a custom SQL database with tables, views, and stored procedures in SSMS to support an application built in Excel/VBA
- Designed automated reporting processes utilizing SQL/Presto queries and Excel VBA macros for streamlined data analysis.
- Implemented visualizations and dashboards in Tableau/Power BI to help senior management make informed decisions.
- Provided technical support for existing reports, dashboards, and tools.
- Contributed to Tableau admin duties: workbook publication, permission setting, ownership management, user accessibility, and report scheduling on the Tableau Server.
Loan Document Specialist
Wells Fargo Home Mortgage
06.2015 - 05.2017
- Conducted research on loan documents to align with regulations and customer criteria.
- Adopted Direct Bill Audit methodology for operational audits to deliver precise results.
- Managed two shared inboxes to oversee incoming documents promptly.
- Minimized over $1 million in refunds/write offs yearly by ensuring optimum quality control through the audits of incoming documents.
- Built macros in Microsoft Outlook to automate repetitive tasks, leading to a 20% increase in productivity.
- Interacted with internal departments and stakeholders to ensure timely delivery of required documents.
- Verified and examined information and accuracy of closing documents.
Education
Master of Science - Data Science
University of St. Thomas
Saint Paul, MN05.2024
Bachelor of Science - Mathematics
University of Minnesota
12.2014
Bachelor of Science - Statistics & Actuarial Science
University of Minnesota
12.2014
Skills
- Tableau and Power BI
- SQL and Presto
- Python and MATLAB
- Alteryx and ETL
- SSMS and Toad Datapoint
- Microsoft Excel expertise
- Data research and analysis
- Data modeling techniques
- Business intelligence tools
Certification
- Tableau Desktop Specialist - Tableau - Jul 2020
- Alteryx Designer Core - Alteryx - Nov 2024
Timeline
Data Scientist
U.S. Bank
03.2022 - Current
Business Operations Analyst
U.S. Bank
05.2017 - 03.2022
Loan Document Specialist
Wells Fargo Home Mortgage
06.2015 - 05.2017
Bachelor of Science - Mathematics
University of Minnesota
Bachelor of Science - Statistics & Actuarial Science
University of Minnesota
Master of Science - Data Science
University of St. Thomas