Kaelah Fordyce
Willow
Summary
Results-driven Business Intelligence and Data Analyst with a strong focus on data visualization, predictive modeling, and performance optimization. Committed to harnessing data to inform strategic decision-making and enhance user experiences. Proven expertise in cross-functional collaboration, designing scalable database solutions, and leading actionable analyses that improve business processes. Proficient in SQL, Python, Tableau, and Advanced Excel, consistently delivering insights that drive measurable impact.
Overview
10
10
years of professional experience
1
1
Certification
Work History
Business Intelligence Analyst
El Rio Community Health Center (via TEKsystems)
Tucson, AZ (Remote)
03.2025 - Current
- Developed and optimized automated SSIS workflows, reducing manual data handling by 20+ hours/week and enabling secure data exchanges between internal and external systems.
- Delivered actionable insights using Epic reporting tools (Cogito, Clarity, Caboodle) and custom SQL queries, which informed key strategic decisions and led to securing over $100k in funding through grants for healthcare initiatives.
- Developed and maintained interactive Epic dashboards to visualize critical operational metrics, enabling healthcare leadership to make data-driven decisions and improve patient care outcomes.
- Collaborated with cross-functional teams to identify business requirements and deliver tailored BI solutions leveraging PowerApps and SQL, enhancing process automation and supporting key business objectives.
Senior Business Intelligence Analyst
Arizona State University, AI Acceleration Data Enrichment & Architecture
Tempe, AZ (Hybrid)
06.2022 - 03.2025
- Created scalable AWS Redshift data pipelines and automated ETL workflows with Matillion and SQL, reducing manual processes by 30% and improving data reporting accuracy across departments.
- Leveraged SQL, Python, and Alteryx to conduct advanced analytics and resolve discrepancies in data, improving accuracy in student data reports and ensuring consistency of metrics across systems.
- Integrated data quality controls and collaborated with data engineering teams to ensure consistency in key metrics used for decision-making, contributing to significant improvements in data reliability.
- Implemented Tableau dashboards to track real-time performance of a chatbot designed to handle student inquiries, improving employee adoption of the chatbot by 70% during the pilot phase by leveraging data-driven optimizations.
- Developed a time-series forecasting model to predict attendance at ASU home football games within 5% of actual attendance, optimizing operational staffing and improving resource allocation for concessions, security, and stadium services.
Dimension Architecture Analyst
Information Resources, Inc. (IRI)
Chicago, IL (Remote)
10.2018 - 06.2022
- Built custom relational and dimensional data models for large-scale reporting solutions for Fortune 500 clients, enabling timely and accurate delivery of data.
- Led training on SQL best practices and data model architecture, enhancing team competency in BI tools and ensuring seamless integration between data sources and reporting platforms.
- Provided strategic data insights using advanced analytics, delivering self-service BI solutions that empowered executive teams to make faster, more informed decisions with minimal reliance on analysts.
- Led training sessions for client stakeholders on business intelligence tools, enhancing overall team capabilities in data interpretation.
- Conducted QA and validation checks on ETL pipelines for weekly and monthly data refreshes, performing root cause analysis on data integrity issues.
Data Operations Analyst
Evive Health
Chicago, IL (On-site)
02.2017 - 10.2018
- Developed mapping systems for complex healthcare claims data, ensuring HIPAA compliance while optimizing user engagement and health benefit utilization for a national client base.
- Applied A/B testing frameworks to measure content performance and refine user engagement strategies, leading to improved patient outreach and service utilization.
- Collaborated with cross-functional teams to implement data-driven solutions that optimized business processes and enhanced operational efficiency.
- Developed process documentation and a new-hire training program, accelerating onboarding process and ensuring consistency in data analysis work.
Operations Analyst
American Express, Global Marketing Operations
New York City, NY (Hybrid)
10.2015 - 02.2017
- Managed marketing campaigns by using structured performance metrics and KPI dashboards developed in Excel and Power BI to track campaign success and guide decision-making.
- Led process redesign initiatives that improved team workflows and increased campaign approval rates by 60%, driving greater marketing effectiveness and resource optimization.
- Analyzed operational data to identify process inefficiencies and recommend improvements to facilitate timely resolutions.
- Strengthened communication between departments, facilitating a seamless flow of information for faster decision-making processes.
Education
Master of Science - Data Science
University of Arizona
Tucson, AZBachelor of Science - Finance
University of Connecticut
Storrs, CTSkills
- Data warehousing and database management expertise using Alteryx, AWS, Azure, Matillion, Redshift, and SnapLogic
- Advanced data analysis, trend forecasting, and visualization using SQL, R, Python, Tableau, and Power BI
- Automation solutions using Power Apps
- Expertise in Microsoft Office applications Word, Excel, Access, and PowerPoint
- Experience with Jupyter and Python libraries
- Proficiency in verbal and written communication to senior and executive leadership to influence decision making
- Process documentation and version control using collaboration tools including Confluence, Jira, GitHub, Google Suite, Microsoft Suite
- Agile project management
Certification
- Caboodle Data Model, Epic
- Cogito Fundamentals, Epic
Timeline
Business Intelligence Analyst
El Rio Community Health Center (via TEKsystems)
03.2025 - Current
Senior Business Intelligence Analyst
Arizona State University, AI Acceleration Data Enrichment & Architecture
06.2022 - 03.2025
Dimension Architecture Analyst
Information Resources, Inc. (IRI)
10.2018 - 06.2022
Data Operations Analyst
Evive Health
02.2017 - 10.2018
Operations Analyst
American Express, Global Marketing Operations
10.2015 - 02.2017
Bachelor of Science - Finance
University of Connecticut
Master of Science - Data Science
University of Arizona