City of San Jose – Data Analyst
The project aimed to develop a relational database system to improve contract administration for the City of San Jose. It sought to streamline contract tracking, enhance compliance monitoring, and support data-driven decision-making. Additionally, it focused on strengthening SQL skills, data analysis, and AI-assisted database design. I successfully built a functional database that connected departments, vendors, contracts, and payments, improving efficiency and resource tracking. AI tools optimized the database structure, and collaboration strengthened problem-solving skills. Challenges like data sourcing and time constraints were addressed through the progress of development and iterative improvements. Future enhancements include better data validation and performance analysis.