Experience Summary

I have * years experience using technology to create innovative solutions and reports to help teams in the quality assurance, senior living, and manufacturing environments understand their data and monitor the flow of information to achieve results. Above all, my soft-skills have allowed me to build strong relationships that have proven directly beneficial to understand and develop solutions together with the lines of business.

Work Experience

LifeSpace Communities Inc. Oct '21 - Present

Business Intelligence Data Analysis

●Collaborated alongside the Business Intelligence Architect and Data Warehouse Manager to produce innovative system and database solutions using SQL Server, Azure, and Power BI reports and services

●Worked in an agile sprint environment to create Power BI reports that supplemented senior leaders in operations

●Acted as a business analyst and established repour with the lines of business to accurately capture requirements and track Power BI reporting efficiency with regards to decision making and information transparency

●Led team meetings to maintain sprint goals, prioritize requests, and facilitate the flow of information between our development team and the lines of business using JIRA and Azure Repository to track and monitor workflow

Titan Tire International Jul '21 – Oct '21

Business Intelligence Analyst

●Utilized Power BI to create and manage reports using Power Query and DAX languages to optimize data summarization and visualization techniques

●Collaborated with manufacturing engineers and management to create KPIs to measure employee efficiencies and create progress trackers to meet quarterly production goals

●Manipulated and visualized complex manufacturing trend data using Pandas, Matplotlib, and Seaborn in Python to facilitate management strategy conversations and planning

●Utilized SQL to optimize data manipulation and loading time directly into Power BI dashboard reports

●Created Python GUI for HR to automate creating and printing personalized efficiency reports for over 150 employees through an easy UI with backend design connecting to database server and manipulating data according to user parameters

Wells Fargo, Des Moines, IA Mar '20 – Jul '21

Analytical Specialist

●Designed a forecasting tool to assist management in tracking over 80 projects and an estimated half a billion dollars in total costs with an integrated project assessment tool to evaluate a project’s overall impact to portfolio

●Engineered a capacity model in Excel using Power Pivot, Power Query, and Power BI by consulting with portfolio management team to assist with determining project urgency and resource availability/allocation

●Consulted with management to recreate 3 performance metrics used to evaluate portfolio success rates

●Provided management with ad-hoc data analysis/visualization requests to supplement strategy planning meetings

●Constructed Excel dashboard by joining data tables from Tableau and other data sources to track portfolio project movement and success metrics with customized queries and complex calculations using Power BI

●Created a data-driven portfolio summary/strategy deck to be presented to executive management

Wells Fargo, Des Moines, IA Jul '19 – Mar '20

QA Analyst I

●Reviewed reports prepared by 3rd party vendors by utilizing different test cases to evaluate accuracy of qualitative and quantitative information using SharePoint and Epic Facilitator

●Redesigned quality assurance process to overcome backlog by consulting with stakeholders to capture business rules and engineer a new automated method to capture the data population using Power Query & Power Pivot in Excel

●Trained a team of five analysts on a new QA procedure and oversaw work completion on behalf of management

●Utilized Excel VBA, Power Pivot, and Power Query to streamline a weekly data preparation process by removing over 100 manual steps and an average reduction of one hour per instance

●Consulted the Quality Assurance management team by capturing and updating business requirements to query complex data populations for transactional QA processes and provided a customized live performance monitoring tool that joined SharePoint and Epic Facilitator data tables to view live results

Education

University of Iowa, Iowa City, IA May '19

B.B.A. Business Analytic