Joshua Walls
Summary
Driven and analytical data analyst proficient in data visualization, SQL and ETL automation. Skilled in creating and automating complex business reports and dashboards to help drive business decisions and improve efficiency.
Overview
4
4
years of professional experience
Work History
Data and Reporting Analyst
Wells Fargo
07.2022 - Current
- Created and maintained 70+ interactive Tableau dashboards to aid in decision making for numerous business areas including application risk/compliance, issues management, agile transformation, financial budgeting/forecasting and workforce location strategy
- Created complex data queries in SQL to extract information for reporting and analysis
- Utilized ETL tooling such as Tableau Prep and Alteryx to automate data cleaning processes saving 50+ hours of manual work
- Was a part of a cross functional agile scrum team that delivered tableau reports in two week sprints for 10+ stakeholder groups
- Communicated and demoed my dashboard deliverables to 30+ person audiences of senior leadership and stakeholders every two weeks during sprint reviews
Technology Analyst
Wells Fargo
07.2021 - 07.2022
- Created and maintained 15 Tableau dashboards to address business problems for multiple risk, compliance and application security workstreams at Wells Fargo
- Built out data dictionary with 300+ data field definitions, data types and attributes
- Utilized Visio to create flowcharts to organize the application validation procedures required for risk and compliance areas
- Assisted with application security DSOP reviews to address application risk and uncover potential vulnerabilities
Campaign fundraising intern
Office of NC Attorney General Josh Stein
02.2020 - 05.2020
- Responsible for updating campaign database and excel spreadsheets with relevant donor and campaign related information
- Made fundraising calls to raise money for AG Stein's campaign and to advertise campaign fundraising events
- Researched numerous Democratic officials donor history to prospect for new donors for AG Stein.
Education
Bachelor of Arts - Statistics And Political Science
Wake Forest University
Winston-Salem, NC05.2021
Skills
- Proficient: SQL, Tableau, Excel
- Intermediate: Tableau Prep, Alteryx, Jira, Confluence
- Beginner: Power BI, R, Visio
Timeline
Data and Reporting Analyst
Wells Fargo
07.2022 - Current
Technology Analyst
Wells Fargo
07.2021 - 07.2022
Campaign fundraising intern
Office of NC Attorney General Josh Stein
02.2020 - 05.2020
Bachelor of Arts - Statistics And Political Science
Wake Forest University