Joonmo Jeong (13months)

Developed features for the Chemical Information Platform Service

• Migrated data from TIBERO to MariaDB.
• Indexing migrated data and implemented partitioning for statistical data.
• Optimized queries from TIBERO to MariaDB.
• Implemented hierarchical queries and sorting using WITH RECURSIVE and SORT_PATH.
• Refactored high-cost statistical queries, improving performance (873.231ms → 214.245ms).
• Visualized statistical data using ApexChart and implemented favorites and table search features.

Enhanced functionalities of the DBpia service

• Integrated Redis for floating banners and developed APIs to connect the back office with the DBpia service.
• Modified Elasticsearch queries and existing mappings for the unified search feature, restructured the research paper index.
• Analyzed execution plans, reindexed data, and optimized high-cost queries (4481.926ms → 1111.281ms).
• Maintained DBpia service operations – Fixed Excel download bugs, managed the PDF download server, and handled long-term inactive users.

Developed DBpia Content Maker (DCM)

• Analyzed legacy source code written in C# and C++ and designed a new web-based system.
• Utilized Git Flow strategy for seamless collaboration, analyzed user requirements and system processes.
• Set up and managed project configurations and operations.
• Configured Spring Security with custom filters and authenticators, implemented LDAP-based login.
• Resolved DataSource TLS compatibility issue with SQL Server 2005.
• Fixed incompatibility between the latest Spring Batch version and SQL Server 2005 sequences.
• Established certificates and domains, set up reverse proxy routing for development and production servers using NGINX.
• Deployed and managed Tomcat on Windows Server, resolved symbolic link-related network drive permission issues.
• Configured Tomcat JVM memory and implemented redundancy for production and development servers.
• Handled penetration testing issues, including XSS, CSRF, and sensitive data masking.
• Utilized SQL Server's Linked Server to remotely call stored procedures from different locations.
• Research Paper Metadata Production System Development
• Developed a PDF splitting algorithm using PDFBox, ensuring differentiation between logical and physical pages in pdf.
• Integrated ERP and DCM services using Spring Batch, implemented business logic based on Job / Step.
• Developed a temporary storage system for research papers to periodically save input data.
• Implemented an email-based research paper author search feature using Elasticsearch.
• Efficiency Improvements & Service Optimization
• Revamped the research paper production system, reducing metadata processing time (30 min → 15 min for 50 papers).
• Optimized batch processing, cutting publication time (3 days → 1 day).

Developed the ASD Screening AI Integrated Platform System

• Implemented conditional branching surveys using SurveyJS.
• Transmitted video and audio data via WebSocket for real-time communication with the AI inference server.
• Visualized inference results in real-time using ApexCharts and D3.js.
• Set up system execution environment and deployed images using Docker.
• Developed JWT authentication and CRUD functionality for participants and test results using FastAPI.
• Built and developed the frontend using Vue.

Enhanced functionalities of the ETRI School website

• Unified non-registered student and faculty data into a single table.
• Implemented bulletin board pagination and step-by-step registration using Vue Quasar.
• Developed a Spring Boot and JPA-based back-office system and integrated with the ETRI School service.
• Deployed and managed the system on ETRI's internal servers using Docker.

Developed the Drone Mission Data Management System

• Developed batch business logic for drone data storage.
• Traversed directories using DFS and stored image metadata.
• Detected changes at the project level and updated only modified data.
• Used AtomicBoolean api to ensure only one scheduler runs at a time.
• Handled scheduler tasks asynchronously with CompletableFuture api.
• Conducted performance benchmarking tests considering JVM warm-up.
• Visualized image data on a map using React.
• Deployed Frontend, Backend, and Database as a unified system using docker-compose.

Enhanced functionalities of the National Supercomputing Center website

• Redesigned the main page and developed the back-office system.
• Added an email verification step for user registration, including security measures and expiration settings for verification codes.
• Visualized supercomputer usage statistics using D3.js and optimized queries (6.376s → 0.430s).
• Implemented a WebSocket-based broadcast feature for connected users.

11th NTIS Information Utilization Competition

• Developed "NTIS STUDIO" a scientific document editor using Vue and FastAPI.

K-Digital Challenge: 2023 MyData Idea Competition

• Developed "Trippy" a personalized travel app using Flutter.

2023 Environmental Data Utilization and Analysis Competition

• Planned "CEAP" a platform for analyzing company-specific carbon emissions using greenhouse gas data.

Chungnam National University Algorithm Competition – DevDay

• University-wide algorithm competition held every spring and fall.

Chungnam National University Algorithm Competition – DevDay

• University-wide algorithm competition held every spring and fall.

Chungnam National University Junior Creative Works Competition

• Developed a refrigerator management service using deep learning-based image recognition.

Chungnam National University

43rd Advanced Data Analytics Semi-Professional (ADsP)

54th Structured Query Language Developer (SQLD)