Streaming Service Backend for Korean Meditech Company
Laravel 12, PHP 8.2, Laravel Sanctum, MySQL, Filament, REST APIs, WebSockets, MQTT, SSE
iPad Analytics CMS for US Pharmacy Company
Laravel 12, PHP 8.2, Filament 3, Laravel Sanctum, MySQL, Maatwebsite Excel, Redis, REST APIs, Laravel Reverb, PestPHP
My Online Wedding Invitation
React 18, Vite 6, TypeScript, Tailwind CSS v4, motion, embla-carousel-react
Automated Log Data Processing and Integration System
Shell Scripting, Node.js, AWS Lambda, AWS API Gateway, Google App Script, Google Sheets
MySkinRecipes E-commerce Platform Migration
PrestaShop, PHP, MySQL, Redis, Symfony Framework, MySQL, Twig Template Engine (or Smarty Templates), and TypeScript
CMS for the Broadcasting Corporation
Go, Gin, PostgreSQL, SQLC, AWS S3
CSV Upload Project (1 Million Records)
Laravel, JavaScript, MySQL, and WebSocket
Souvenir Map of Japan
HTML, CSS, and JavaScript
Web Scraping Project: Extracting Data from Multiple Websites
Symfony Dom Crawler, Roach PHP, Laravel, and MySQL
Japan 47 Prefectures Game: An Interactive Experience
JavaScript, Laravel, and MySQL
Generating JSON for the Irodori Website and App
Google App Script, VBA

Automated Log Data Processing and Integration System

Objective:

To automate the processing of generating daily traffic logs for the server.

Responsibilities:

Developed a Shell script to parse Apache logs into CSV files and a Node.js script to convert these files into JSON and send them to a Google App Script WebApp. For China servers, an AWS API Gateway and Lambda function was implemented to bypass the China firewall. Integrated the workflow with Google Sheets using Google App Script to dynamically store and organize data for reporting.

Technologies:

Shell Scripting, Node.js, AWS Lambda, AWS API Gateway, Google App Script, Google Sheets.