Level of Education of Students Involved
Graduate
Faculty Sponsor
Haydar Cukurtepe
College
College of Arts & Sciences (CAS)
Discipline(s)
Computer Science, Information Technology
ORCID Identifier(s)
Haydar Cukurtepe 0000-0002-4670-4877
Presentation Type
Poster Presentation
Symposium Date
Spring 4-24-2025
Abstract
Backend design requires a deeper understanding of systems and technologies in a software project. In Sales Data Insights Project for Family Express, we designed and developed a secure, modular, and scalable backend system to support the analysis of multi-year, multi-store retail and fuel sales data. It also enables automation of data workflows to enhance strategic decision-making.
The system infrastructure supports data analysis by pre-processing and transforming data into a suitable format for effective analysis and insight generation. The backend is designed to deliver analytical output for frontend visualization while ensuring secure, reliable, and high-performance access through authorization controls. A well-structured backend architecture enables the dynamic routing of analytical data based on timeframe and location filters, with FastAPIimplemented for clarity, scalability, and efficient routing. To address secure authentication challenges, APIs are equipped with token management and refined permission layers using secure JWT-based authentication and role-based access control. Generative AI-based reasoning posed challenges, particularly when using externally hosted cloud models, leading to access restrictions, latency issues, and reduced flexibility. The developed architecture integrates generative AI tools to provide narrative insights, leveraging locally hosted models on platforms like LM Studio and LLaMA3 for greater customization, privacy, and control.
In this project, we designed and developed a structured backend system that effectively bridges data analysis with user-facing tools, while coordinating multiple backend components seamlessly, incorporating machine learning algorithms and AI-reasoning into the project. Our design serves as a practical reference for future projects requiring coordinated data analytics, automation, AI-reasoning, and insight delivery.
Recommended Citation
Sinkaiye, Oluwaseun; Boyapati, Bhargav; Nagubandi, Sashank; Bollepalli, Pradeep Kumar; Polasani, Sai Krishna Rao; and Cukurtepe, Haydar, "Backend Design and Development for Sales Data Insights Project" (2025). Symposium on Undergraduate Research and Creative Expression (SOURCE). 1403.
https://scholar.valpo.edu/cus/1403
Biographical Information about Author(s)
We are IT students from Valparaiso University—Bhargav Boyapati, Sashank Nagubandi, Oluwaseun Sinkaiye, Pradeep Kumar Bollepalli, and Sai Krishna Rao Polasani—working under the guidance of Professor Haydar Cukurtepe. Our expertise spans backend development, API integration, and AI-driven data processing. We are developing a robust backend system for the Family Express Sales Data Insights Project, focusing on automation, forecasting, and secure data analytics to drive strategic business insights.