Ukrit Wong
Verified Expert in Engineering
Software Developer
Bangkok, Thailand
Toptal member since August 15, 2022
Ukrit have degrees in data science and MBA with experience in engineering and project management. He has developed in-house software for data analytics, forecasts, and dashboards. Ukrit has also created additional functionalities and extensions for SAP Business One (SAP B1) and connected it with open platforms.
Portfolio
Experience
- Excel VBA - 10 years
- Microsoft Excel - 10 years
- Python - 4 years
- SAP Business Intelligence (BI) - 3 years
- Data Visualization - 3 years
- Google AppSheet - 2 years
- SQL - 2 years
- Microsoft Power BI - 2 years
Preferred Environment
Windows, Visual Basic for Applications (VBA), Microsoft Power BI, Microsoft Access, Python 3, Visual Studio Code (VS Code), R, Microsoft Excel, Excel 2013
The most amazing...
...ERP SAP B1 extension I've developed is a mapped warehouse with item bin locations to visualize inventory.
Work Experience
Data Analytic and Application Development Manager
F&N Dairies (Thailand) Limited
- Developed data pipelines in Microsoft Fabric leveraging Dataflow Gen2, notebooks, pipelines, data lakes, delta tables, and parquet files to optimize dataset refreshes, achieving a 98% reduction in resource usage for daily updates.
- Led the implementation of a budget control system integrated with SAP.
- Built AI agents in Copilot Studio for internal L1 IT support, integrating automated ticket creation workflows to enhance IT operations.
- Oversaw the implementation of a new SaaS-based HRMS, managing data migration and ensuring secure handling of confidential employee information.
- Directed and mentored team members in building Power Apps solutions for employee data collection, enabling seamless data flows into Microsoft Fabric and Power BI dashboards for improved reporting.
Microsoft Access Expert
Plywood International, LLC DBA Delmar International Imports
- Modified the existing Microsoft Access system that previous developers created to meet the client's changing requirements.
- Used VBA to add new functionalities to their existing system, including integration with QuickBooks API.
- Created new forms and modified existing forms to display data and reports more efficiently.
Finance Manager and Software Developer
Green Innovation and Maintenance
- Developed multiple apps for internal management (apps for team petty cash tracking, project management, automated reports creation, step approval, and stock management). The apps are cross-platform (UI on Google AppSheet).
- Conducted server set up to transform data from the SQL/SCADA server to perform analytics for wind turbine monitoring operations and performance. Created a web platform with Python to view the dashboard/graphs as per the engineering team's request.
- Created a finance dashboard and report on a weekly and monthly basis. Data is connected from their existing platform, and the dashboard is created using Microsoft Power BI.
- Managed a team of developers to develop internal tools and supported other associate companies' internal tool development.
- Handled project management and coordination with overseas teams to implement new solutions to Thailand's renewable market. Managed a team that successfully installed sensors with a cloud monitoring system on more than 100 wind turbines.
Project Manager
K&B Cosmetic
- Developed a web app to connect the company's enterprise resource planning (ERP) to online platforms using their APIs.
- Created more than 10 dashboards with Power BI for various departments, including some with R transformation machine learning (ML) scripts.
- Developed a Microsoft Access app with many functionality extensions to the company's SAP Business One (SAP B1), an ERP software platform for small and medium-sized businesses.
Site Manager
Siemens Gamesa Renewable Energy
- Created Excel VBA for inventory tracking and management.
- Digitalized forms, logbooks, and documents for the team.
- Developed a Microsoft Power BI dashboard to track downtime and maintenance issues.
Service Representative
Rolls-Royce
- Provided on-site support for a new product introduction with multiple customers in at least four countries.
- Supported development of digital tools as a test user.
- Managed logistics and operational planning of sophisticated engineering products.
- Volunteered as an ethics advisor for a team in the region.
Engineering Officer
NokScoot Airlines
- Developed a Microsoft Access app to manage and track airline maintenance activities, including inventory functions, preventive maintenance planning, and automatic daily activity reporting. This was part of the authority's requirements.
- Managed aircraft rotation and maintenance planning. Reviewed engineering documents.
- Supported the development of the company's SharePoint portal.
Experience
Warehouse Inventory Map
Power BI Dashboard for ERP
Web App for API-ERP Connection
Education
Master's Degree in Data Science
Chulalongkorn University - Bangkok
Master's Degree in Business Administration (MBA)
Thammasat University - Bangkok, Thailand
Bachelor's Degree in Aerospace Engineering
Kasetsart University - Bangkok, Thailand
Skills
Libraries/APIs
REST APIs, Fabric, PySpark
Tools
Microsoft Power BI, Microsoft Access, Microsoft Excel, Excel 2013, Power BI Desktop, Power Query, Microsoft Power Apps, Power Pivot, Cloud Dataflow
Languages
Excel VBA, Visual Basic for Applications (VBA), Python 3, SQL, Python, Transact-SQL (T-SQL), R, HTML, Visual Basic, JavaScript
Platforms
Google AppSheet, Windows, Visual Studio Code (VS Code), SharePoint, Azure, Web, Power Automate Cloud Flow, Microsoft Power Automate
Storage
SQL Server 2016, Microsoft SQL Server, Azure SQL, SQLite, SQL Stored Procedures, Databases, Data Lakes, Data Pipelines
Frameworks
Bootstrap, Flask, Hadoop, Spark
Paradigms
Management, Dimensional Modeling, Business Intelligence (BI), App Development
Other
Operations, Planning, Dashboards, Data Visualization, Reports, SAP Business Intelligence (BI), Engines, Finance, Interactive Dashboards, Web Dashboards, BI Reports, BI Reporting, Bootstrap 4, Data Analysis, Data Analytics, Reporting, SAP ERP, Aerodynamics, Structure, Controls, Thermodynamics, B2C Marketing, Client Relations, APIs, Data Engineering, Internet Information Services (IIS), Data Queries, Data, Data Governance, Big Data, Cash Management, Cash Flow, Feasibility Studies, Feasibility, Excel Expert, Projects, Web Project Management, Low Code, Web Development, Apps, AI Agents, AI Copilots
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring