Ashleigh Ware

Data & Operations Professional
Turning Data into Decisions
SQL • R • Data Cleaning • Visualization

MS in Information Science with a track record of turning complex financial and organizational data into clear policy, cost savings, and smarter decisions.

• LinkedIn
• GitHub
• Resume

• Email
• Mobile
• Message
• WhatsApp

Projects
Database Management: Retail Business Application
• Designed and built a relational SQL database for a simulated grocery business, enabling scalable data management and operational tracking.
• Architected a flexible data model to support future expansion, including delivery services and customer loyalty programs.
• Developed analytical queries to surface key business insights, including restock costs, average transaction value, and losses from expired inventory.Information Architecture: University of Tennessee Registrar Site Conceptual Redesign
• Led a full-scale conceptual redesign of a live university website, delivering a user-centered solution to improve navigation and usability.
• Diagnosed critical usability issues through navigation stress testing, user behavior analysis, and comprehensive content audits.
• Executed A/B testing on a prototype site to optimize user experience and validate design decisions with performance data.
• Produced high- and low-fidelity wireframes using LucidChart and Figma, translating insights into actionable design improvements.Metadata & Data Modeling
• Engineered a structured metadata framework for consumer products, standardizing attributes to enhance data organization and analytical reporting.
• Applied industry standards and tools to ensure consistency, interoperability, and scalability.
• Utilized Oxygen XML Editor and Excel to develop, validate, and manage metadata schemas.Data Visualization of the 2024 NFL Draft
• Built a comprehensive dataset from scratch by scraping and consolidating data from multiple sources, then utilized OpenRefine to clean, standardize, and validate data for accurate, analysis-ready use.
• Conducted statistical analysis in R to evaluate relationships between NFL Combine performance and draft position.
• Built data visualizations (scatter plots, box plots, bar charts) to communicate insights effectively to stakeholders.
• Identified and presented a key finding: NFL Combine performance shows no significant impact on draft position.