As a member of PINUP, a startup providing legal and design support tools, I worked in the Research phase to process geospatial data. My responsibilities included converting Shapefiles (.shp, .shx, .dbf, .prj, .sbn/.sbx, .cpg) into GeoJSON for further analysis and visualization, deriving useful insights such as distances and areas from geographic coordinates. I also handled initial data cleaning and standardization—for example, mapping Thai-English mixed fields to a consistent format—ensuring that accurate and meaningful information was displayed on our website using OpenStreetMap as the base map.

In the subsequent backend development phase, I took ownership of designing a more scalable system architecture. I redesigned the database schema by decoupling high-level metadata (datasets) from granular geometric objects (features) into separate collections, effectively minimizing data redundancy and optimizing query performance. Furthermore, I completely restructured the backend repository to improve maintainability. By modularizing routers, schemas, and services, I systematically organized the API endpoints based on specific geospatial data categories—such as Administrative, Infrastructure, and Points of Interest (POI). These architectural improvements have now been successfully integrated and applied to the active codebase.

During the second month of my internship (July), due to limited time, I focused on learning best practices for HTML and CSS from team members and independently studied JavaScript to complement my frontend work. I was tasked with implementing the UI for two desktop pages: 

1) the DiD page, presenting service recommendations

2) the About Us page, showcasing information about PromptPost.

In developing these pages, I implemented transitions, animations, and mobile responsiveness, enabling the pages to support both Thai and English content—features I explored and applied based on design requirements and self-study.

represents my core contribution to the initial setup of our database system. I've defined all the CREATE TABLE statements necessary for the entire system, directly reflecting our design in the ER Diagram. This foundational work provides a clear overview of the project's data structure, which is essential for understanding the system as a whole and allows for effective task distribution among the team, considering their interests and ensuring balanced workloads.

Through this process, I gained a deeper understanding of what data each table truly requires and its purpose—helping to identify redundancies or missing elements in our original ER design.

Note: This DDL code is just an example. See the full project code on GitHub (link above at the GitHub button). 

I implemented game mechanics from an existing game, coded the rules, developed the backend to fetch APIs, and designed the game graphics. This was part of the Computer Engineering Essential course, where I earned an A.