WORK EXPERIENCES

COOP at A-HOST Company Limited • Assistant Software Professional

• Support Oracle Application Express (APEX) product.
• Writing PL/SQL procedures for import and export data.
• Implement cloud interface for export data to Jasper report.
• Manage database table triggers and job schedulers,
• Build demo for testing SSO with Microsoft Azure ADB2C.
• Solve issues, fix bugs, document related changes.

COLLEGE EXPERIENCES

Laravel - PHP • Web Programming • Online Store

A responsive e-commerce website for a single seller. The seller (site owner) can list products, define product categories, edit users information and access level, create conditional coupon with expiration date, create bundle sales with algorithm-assisted (apriori) suggestion, change orders status, answer inquiries from users, see statistics page with simple charts, edit site settings. The users are separated into two groups, member and guest. All users will have access to product index page where they can search and filter to find products, and a cart page where they'll see products that have been added to cart. In cart page, users may insert coupon code if they have one. The system will also suggest products that often bought together with items in cart using past transaction data in database. Guest users will have their cart items store in session variables, and they can only access order page using direct link only. Member users, aside from aforementioned features, will have access to Wishlist, inquiry about products, writing reviews for purchased products, order history, and ability to edit their information. Payment powered by PayPal. Users may download their receipts in PDF format. The site support varied display port, additionally it also support two interface languages, Thai and English.

Kotlin - PHP • Android Programming • Online Marketplace 2

Initially planned to integrate with the old website, but previous design doesn't has API nor can it be easily created without breaking things. This one features almost the exact same things as the former, using different practice and implementation by creating PHP backend API with an android client for frontend. New features worth mentioning include session management by storing authentication key generated on login locally using shared-preference allowing users to resume session without re-login, automatically sign-out of other devices that have mismatched authentication key. Storing picture as file on web server rather than blob on the database which resulted in support for other image formats and increased efficiency, users now have a store page which let them set store name, description, and cover image.

Javascript - PHP • Web Programming • Online Marketplace

An online responsive store page. Functionalities include listing product which users can optionally attach image or a youtube link that will display on product page, store data and manage referential integrities on MySQL database, login and register functions, cart management, admin page for managing users, edit personal information, search and filter for products, transaction records, and some more. Image stored as blobs on database. Any user can buy or sell products on the website using the same account.

JAVA • Software Programming • Income-Expense Tracker

A software for recording personal financial account. It can save the type of transaction, amount, timestamp, and save result in a structured text file locally which can later be loaded, display, and reuse.