Chayaphon Sornthananon

*I'm a

About

Hello, my name is Chayaphon Sornthananon. I specialize in designing and creating comprehensive data analytics and data science solutions.
With a robust background in enterprise-scale business intelligence and data technology, I have developed a keen expertise in transforming complex datasets into actionable insights. Additionally, I am skilled in application development, including web stack technologies and REST APIs, leveraging my programming experience in C, C#, and Python to build versatile and efficient systems.

Full-Stack Developer & Data Analyst/Engineer

  • Name: Chayaphon Sornthananon
  • TH: ชยพล สรธนานนท์
  • Nick Name: เอก EK, Chayah
  • Phone: (+66) 064 974 5195
  • City: Samutprakarn, Thailand
  • Birthday: 01 Dec, 1987
  • Age:
  • Degree: M.S. Data Analytics & Data Science
  • Email: csorntha@outlook.com
  • Hobby: Coding / Home lab (servers).

This website is one of my hobby, it's running on my own home lab server by using mini PC (Minisforum NAB6) operate with VmwareEsxi with various services on Linux server e.g. Web server (Integrating CI/CD with Github Dev/Main branch), Mail Server, DNS Server, Postgresql Primary server and Replicated (Mirror) server, Jupyter Hub etc.

Facts

  • Starting my career in IT support and advancing to a System Engineer, I implemented comprehensive network and server infrastructures for an entire organization. This included configuring and managing firewalls and deploying a variety of servers using virtual machine technology. As a Cisco Certified Network Associate (CCNA), I possess a robust technical foundation in network management.

  • Software Development: My passion for technology led me to software development, where I worked with VB.NET and C#. I developed warehousing applications for manufacturing, showcasing my ability to integrate sophisticated software solutions into practical business processes.

  • ERP Systems Exploration: In my role as a IS Business Analyst for ERP systems, I gained deep insights into ERP architecture with the goal of developing my own system at that time. This experience was pivotal in understanding enterprise-level application structures and resource management.

  • Dedication to Data and Analytics: My journey continued into Data Analytics, where I've spent nearly 6 years mastering data transformation, warehousing, and visualization. I am currently pursuing a master’s degree in Data Analytics and Data Science, further deepening my expertise in the field.

  • Lifelong Learning and Coding: My enthusiasm for technology and exploration has never waned. I joined 42 Bangkok (école42), a prestigious coding school, to further hone my coding skills and stay on the cutting edge of technology.
  • Skills

    Infrastructures

    Server (Windowns & Linux)90%
    Web Server (Nginx) & DNS (bind9)75%
    VMware Esxi80%
    Network & Firewall85%
    Docker70%

    Coding

    Python85%
    VB.NET, C#.NET 80%
    C, C++75%
    HTML, CSS, Bootstrap75%
    Javascript50%
    Webstack : Flask, Django70%

    DB

    MS SQL90%
    MySQL85%
    Postgresql70%

    Data

    SQL, Python85%
    Data Warehousing Architecture (Fact/Dimension)90%
    ETL & ELT (SSIS, ADF, API etc.)85%
    Databricks85%
    Hadoop & Spark80%
    Real-time (Kafka)60%

    Data Visualization

    Power BI95%
    Qlikview85%
    Dash70%

    Data Science & AI

    Statatistic (Discrete/Inferential)80%
    Machine Learning (Supervised / Unsupervised, Clustering)75%
    Deep Learning (Tensorflow, Pytorch)50%
    Image and Video Processing (Open CV)60%

    Resume

    Education

    Master of Data Analytics and Data Science

    2023 - Present

    *Currently studying 3/4

    National Institute of Development and Administration (NIDA)

    Courses :

    • English for Data Analytics and Data Science. (completed)
    • Statistics and Mathematics Foundation. (completed)
    • Basic Programming and Database Management. (exemption)
    • Data Analytics and Data Science Tools and Programming. (completed)
    • Business Model Simulation and Design Thinking. (completed)
    • Applied Modern Statistical Analysis. (completed)
    • Big Data Analytics. (completed)
    • Applied Machine Learning. (completed)
    • Data Streaming and Real Time Analytics. (Studying)
    • Deep Learning. (Studying)
    • Image and Video Analytics. (Studying)
    • Financial and Risk Analytics. (Studying)
    • Text Analytics and Natural Language Processing. (planned)
    • Reinforcement Learning and Advanced Machine Learning. (planned)
    • IS Project : To be determined - Starting October,2024. (planned)

    Computer Programing (Project base learning)

    2023 - Present

    42 Bangkok (école42) by KMITL

    Courses:

      Common Core Courses

    • Libft (Complete): Built a C library replicating useful standard functions to deepen understanding of C and memory management.
    • Printf (Complete): Recreated the C standard library printf function, enhancing skills in variadic functions and character string processing.
    • Get Next Line (Complete): Developed a function to read content line by line from a file, which improved file handling and data processing capabilities.
    • FdF (Complete): Created a 3D wireframe renderer, applying mathematical concepts to computer graphics.
    • So-Long: Developed a 2D game, focusing on graphic rendering, event handling, and game loop architecture.
    • Push-Swap (Complete): Designed an algorithm to sort data with a limited set of operations, optimizing data processing techniques.
    • Mini-Talk (Complete): Implemented a communication program using UNIX signals, demonstrating interprocess communication.
    • Pipex: Simulated the UNIX pipe mechanism to understand process creation and file descriptors.
    • Philosophers: Created a simulation of the dining philosophers problem to understand multi-threading and process synchronization.
    • Mini-Shell: Built a simple UNIX shell, showcasing knowledge of shells, processes, and file descriptors.
    • Ft_IRC: Developed an Internet Relay Chat server, enhancing understanding of network sockets and server-client communication.
    • Mini-RT: Developed a mini ray-tracer, enhancing understanding of computer graphics and geometric computation.
    • Cub3D: Implemented a 3D game using the ray-casting technique to simulate a three-dimensional environment in real time.
    • Net Practice: Engaged in practical network programming exercises, improving skills in networking protocols and socket programming.
    • Inception: Deployed multiple Docker containers to set up a web service, reinforcing concepts in containerization and orchestration.
    • Webserv: Created a web server from scratch, which involved understanding HTTP protocols and server management.
    • CPP Module: Mastered advanced C++ features including object-oriented programming, STL, and real-time problem-solving through a series of complex projects.
    • Ft_Services: Configured a Kubernetes cluster to manage multiple Dockerized services, focusing on automation and continuous integration.
    • Ft_Container: Implemented custom versions of C++ Standard Template Library containers, demonstrating deep understanding of data structures and algorithms.
    • Ft_Transcendence: Developed a full-stack application, integrating advanced web technologies and database management.

    • Specialize Courses

      After finishing common core course, plan to continue with :

    • ALGORITHMS & AI.
    • PARALLEL COMPUTING.

    Bachelor of Business Administration

    Major : Management, Concentration : Entrepreneurship
    2006 - 2010

    Assumption University Thailand (ABAC)

    Courses:

      Common

    • English I,II,III,IV.
    • Statistic I,II.
    • Business Law I,II.
    • Mathematic for Business.
    • Principle of Marketing.
    • Principle of Management.
    • Managerial Psychology.
    • Money, Bank and FIN Markets.
    • Corporate Finance.
    • Fundamentals of Accounting.
    • Managerial Accounting.
    • Microeconomics.
    • Macroeconomics.
    • International Business Environment.
    • Operation Management.
    • Business Communication.
    • Business Ethic Seminars.
    • Microcomputer Application.
    • Computer tools in Research.
    • Information Technology.
    • Business Research Methodology.

    • Major

    • Organization​ Theory.
    • Digital Business Enterprice.
    • Productivity and Quality Management.
    • Strategic Human Resource Management.
    • Quantitative Business Analysis
    • Business Condition Analysis.
    • Marketing Mangement.
    • Financial Management.
    • Corporate Strategy.
    • Seminar in Management.

    • Concentration

    • Project Management.
    • Introduction to New Venture.
    • Innovation and Change Management.
    • Business Training.
    • Entrepreneurship.

    • Freee Elective

    • Basic Philosophy.
    • Introduction to Logic.
    • Negotiation Stretagy.

    Professional Experience

    Data Analytics - Business Report Analyst

    2023 - Present

    CP Axtra Public Complany Limited

    Main Responsibilities :

    • Collaborated with stakeholders to gather requirements and deliver tailored data-driven insights.
    • Designed and optimized data models, enhancing data interpretation and decision-making.
    • Collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
    • Managed and transformed data using SQL and Python in Databricks, incorporating external API data and comprehensive business logic.
    • Developed interactive dashboards in Power BI, streamlining data visualization and reporting.
    • Developed best practices for Power BI, establishing standards for scalable and reusable data models and workspace organization.
    • Proficiency in Power BI, including DAX and Power Query, and data modeling concepts.

    Data Analytics - Front-End Engineer

    2021 - 2023

    Pandora Production Co., Ltd.

    Main Responsibilities :

    • Partnered with product teams to define requirements and design functional dashboards.
    • Specialized in data modeling for efficient reporting and analytics.
    • Developed BI reporting in QlikView, enhancing business operations insights.
    • Led the transition from QlikView to Power BI, ensuring a smooth upgrade in BI tools.
    • Managing large datasets and transforming raw data into actionable insights.
    • Expertise in QlikView and Power BI, with strong skills in data visualization and user interface design.

    BI Developer (Back-end)

    Data Engineer (Job title change in late 2020)

    2019 - 2021

    Pandora Production Co., Ltd.

    Main Responsibilities :

    • Developed and optimized SSIS packages for robust ETL processes, efficiently transferring and transforming data to maintain a high-performance data warehouse.
    • Implemented incremental (delta) loading techniques to optimize data synchronization and reduce load times, ensuring data freshness for daily operations.
    • Managed SSAS cubes, ensuring accurate and timely data availability in both multi-dimensional and tabular models for complex analytical processing.
    • Monitored and managed batch processes to complete within SLA requirements, ensuring all data was ready for early-morning dashboard use.
    • Reconciliation processes with source systems to guarantee data accuracy and consistency across platforms.
    • Later migration to Azure cloud services, integrating modern data management tools including Azure Data Factory, Data Lake, and Databricks, adopting the Lakehouse architecture to improve scalability and data accessibility.

    IS Business Analyst (ERP)

    2017 - 2019

    Zodiac Air Cargo Equipment Co., Ltd.

    Taken over by Safran Cabin Bangkok Ltd. in 2019

    Main Responsibilities :

    • Translate business and users requirement into specifications for the business applications.
    • Ensure business unit ERP solutions adhere to corporate architecture standards and requirements.
    • Design, develop/implement, test and document IS applications and reports as per requirements.
    • Supporting a day to day request from business units according to SLA defined via the Servicedesk and recommend solution.
    • Developing, maintaining training materials, write user instructions and conducting end users training.
    • Develop report or dashboard information from ERP database as per business requirement. (cyberscience for reporting and Hidox report for ERP document printing)

    Developer

    2015 - 2017

    Freelance

    Main Responsibilities :

    • Developed Windows platform applications in .NET for manufacturing, warehousing and MRP.
    • Handled full-cycle software development, from design to implementation and testing.
    • Managed database design and development to support application functionality.
    • Strong skills in .NET Framework, VB.NET, and C#, with a good grasp of object-oriented programming.

    IT Administrator / System Engineer

    2013 - 2017

    Thai Yanagawa Co., Ltd. (Contract : Remote/Onsite)

    Main Responsibilities :

    • Managed IT infrastructure, including ERP, AD, SMB, DHCP, and various application servers, ensuring optimal performance and security.
    • Developed and executed comprehensive data backup and disaster recovery strategies to safeguard organizational data.
    • Planned and executed IT budgeting and infrastructure upgrades, adapting technology to evolving business needs.
    • Designed and implemented network configurations to ensure secure, continuous connectivity for all business units.
    • Maintained firewall and security settings, enforced internet usage policies, and monitored logs to comply with IT laws and detect anomalies.
    • Performed regular system maintenance, updates, and patches to secure and optimize operations.

    IT Support

    2010 - 2012

    Thai Yanagawa Co., Ltd.

    Main Responsibilities :

    • Managed service desk operations, and provided helpdesk support.
    • Supported key business applications such as finance and accounting, procurement, and warehouse etc.
    • Coordinated with IT vendors for onsite and remote support, overseeing quality and timely issue resolution.
    • Maintained IT infrastructure, monitoring systems to ensure continuous functionality.
    • Developed and maintained IT documentation and user manuals, enhancing cross-departmental understanding and operational efficiency.
    • Software license management, balancing cost-efficiency with quality, and secured favorable terms.

    Portfolio


    Under developing.

    • All
    • AI Projects
    • Visualizations
    • Applications

    Contact

    Location:

    Bangphli, Samutprakarn 10540

    Call:

    (+66) 064 974 5195

    Loading
    Your message has been sent. Thank you!