PAKKAPON POTHISORN

Personal Hobby: Digital Portfolio Development
Used html, CSS, github to deploy a personalized digital repository using GitHub Pages to host an extensive collection of my literary works and "projection stream" fragments.
"https://pakkaponpoth.github.io/Q-s-oeuvres/"

Relational Database Design for Financial Auditing Paper: analysed on financial applications especially financial auditing in conceptual and logical database schema in Oracle.
Macro-Policy Analysis: Empirical Testing of the IS-LM Framework; Conducted a longitudinal study on the Thai economy (2015–2024) to quantify the response of GDP to fiscal and monetary policy variables.
Financial Performance Analysis of East Water company; Developed a comprehensive financial report and interactive dashboard using Advanced Excel to analyze the fiscal health of the company.

Optimized and queried large-scale relational databases using Oracle and SQL Server to ensure data integrity and accessibility for business reporting further using power-BI.
Developed and maintained metadata repositories, improving data traceability and helping stakeholders understand complex data lineage and definitions.
Cleaned and transformed raw datasets into structured formats via M-query, enabling the creation of high-level visualizations and actionable business summaries.

Leveraged Large Language Models (LLMs) including ChatGPT, Gemini, Claude, Perplexity, Grok, JuliusAI, Notebooklm, etc. to automate complex data manipulation and extraction workflows.
Developed and deployed custom GPT models tailored for specific analytical tasks and financial data processing.
Utilized Julius AI and generative tools to transform raw datasets into actionable business insights and advanced visualizations.

• Received subject topper awards 2024 offered by Indus International School
• 1. Mathematics AA Higher Level
• 2. English B Standard Level

Spearheaded the establishment of a dedicated academic club to support Grade 12 boarding students in IB Mathematics (Analysis and Approaches), and Physics. Designed and delivered weekly instructional sessions, including pre-tests to assess student baselines and tailored curriculum coverage, improving student performance for summative, and board exams.

• "Variational Principles and the Brachistochrone Problem on a unit sphere"
• Conducted research to determine an optimal solution to the brachistochrone problem in 3D spherical space using variational principles.
• Applied multivariable calculus and optimization techniques to determine the optimal solution.
• Strengthened analytical and problem-solving skills through extensive theoretical exploration.

• "Optimal shape of ellipsoidal capsule for maximizing its capacity within the given limited external surface area using the Lagrange multiplier method"
• First experience in academic writing
• Intensive use of Lagrange Multipliers as optimisation tool

Conducted user-centric research via client interviews to identify core pain points in Intermittent Fasting (IF), such as inconsistency in time tracking and calorie management.
Then wrote an application using Java and SQL (Oracle/MySQL) to automate fasting window calculations and provide persistent data storage for user progress.
Integrated a relational database model to manage a food-calorie library and log-in data.
Designed a streamlined UI/UX specifically optimized for ease of use by non-technical demographics, featuring automated reminders.

• Enrolled in computer science and introduction to machine learning training courses from coursera.
• Participated "Data Science" Webinar by IU Indianapolis Luddy School of Informatics, Computing and Engineering.
• Java Core course certificate from sololearn.