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
Skills
Infrastructures
Coding
DB
Data
Data Visualization
Data Science & AI
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
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.
- ALGORITHMS & AI.
- PARALLEL COMPUTING.
Common Core Courses
Specialize Courses
After finishing common core course, plan to continue with :
Bachelor of Business Administration
Major : Management, Concentration : Entrepreneurship
2006 - 2010
Assumption University Thailand (ABAC)
Courses:
- 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.
- 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.
- Project Management.
- Introduction to New Venture.
- Innovation and Change Management.
- Business Training.
- Entrepreneurship.
- Basic Philosophy.
- Introduction to Logic.
- Negotiation Stretagy.
Common
Major
Concentration
Freee Elective
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.
Certified
"Microsoft Certified: Power BI Data Analyst Associate
Microsoft Certified: Azure Enterprise Data Analyst Associate
Microsoft Certified: Azure Data Engineer Associate
Microsoft Certified: Azure Fundamentals
Microsoft Certified: Azure Data Fundamentals
Microsoft Certified: Azure AI Fundamentals
Microsoft Certified: Security, Compliance, and Identity Fundamentals
Microsoft Certified: Dynamics 365 Fundamentals (ERP)
Microsoft Certified: Dynamics 365 Fundamentals (CRM)
Microsoft Certified: Power Platform Fundamentals
[PCEP-30-02] PCEP™ – Certified Entry-Level Python Programmer
Cisco Certified Network Associate Routing and Switching (CCNA Routing and Switching)
Portfolio
Under developing.
- All
- AI Projects
- Visualizations
- Applications
Contact
Location:
Bangphli, Samutprakarn 10540
Email:
csorntha@outlook.com
Call:
(+66) 064 974 5195