Joey Hanson
Huntsville,AL
Summary
- Results-driven Senior Business Intelligence Analyst with 7 years' experience. Expert in translating complex data into actionable insights for strategic decision-making. Proven track record of optimizing reporting processes and collaborating across teams for organizational success.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Senior Business Intelligence Analyst
Ally
03.2022 - Current
- Developed a star schema dataset in Power BI, consolidating information previously scattered across 12 different datasets. This initiative significantly boosted confidence in our metrics and streamlined the development process for future reports.
- Transformed and loaded millions of rows into our Snowflake data warehouse, facilitating seamless integration with our reporting tools.
- Implemented Row-Level Security (RLS) in Power BI for targeted data visibility.
- Facilitated access to HR data for internal customers by providing data shares in Snowflake.
- Revamped CEO Dashboard to prompt action and provide insights into key influencers.
- Trained team members on Business Intelligence best practices.
Business Intelligence Analyst
Regions Bank
01.2020 - 03.2022
- Architected and developed big data product that processes over 150 MM rows of data daily to recover $8 Million annually
- Streamlined reporting processes for increased efficiency and accuracy with the development of custom dashboards.
- Integrated real-time Splunk alerting program that monitors business critical Robotic Process Automation (RPA) and notifies stakeholders when anomalies are detected or error exception is outside the standard deviation
- Trained end-users on BI tools usage to maximize adoption rates and improve overall company data literacy levels.
- Deployed A/B testing to guide Artificial Intelligence Chatbot direction
- Collaborated with program manager to increase adoption of Docusign by 40%
- Operationalized Power BI dashboard to track stimulus payments during global pandemic.
Data Analyst
Lehman-Roberts Company
06.2017 - 01.2020
- Created dynamic dashboards using Power BI in order to increase asset utilization
- Presented data to assist director of asset management with strategic decisions
- Worked with IT department to build relational databases in MS SQL in order to store data.
Education
Bachelor of Science - Management Information Systems
Auburn University
Auburn, AL12.2016
Skills
- SQL
- Power BI / Tableau
- Data Warehousing
- Data Warehousing
- Data Engineering
- Data Modeling
- Azure, AWS, GCP
- Snowflake, Oracle, Impala
- Problem Solving
Certification
- Snowflake - SnowPro Core
- Microsoft - Power BI Data Analyst
- Comptia - Security +
Timeline
Senior Business Intelligence Analyst
Ally
03.2022 - Current
Business Intelligence Analyst
Regions Bank
01.2020 - 03.2022
Data Analyst
Lehman-Roberts Company
06.2017 - 01.2020
Bachelor of Science - Management Information Systems
Auburn University
Similar Profiles
Noah OlveraNoah Olvera
Customer Service Chat Representative at AllyCustomer Service Chat Representative at Ally
JONATHAN HIPPJONATHAN HIPP
Digital Optimization Sr. Analyst at AllyDigital Optimization Sr. Analyst at Ally
Trevor SmallTrevor Small
Customer Solutions Representative at AllyCustomer Solutions Representative at Ally
Talia CallenTalia Callen
Behavioral Technician at AllyBehavioral Technician at Ally
James SpinosoJames Spinoso
Pardons and Parole Officer at Alabama Bureau of Pardons & ParolesPardons and Parole Officer at Alabama Bureau of Pardons & Paroles