Ukrit Wong
Verified Expert in Engineering
Software Developer
Bangkok, Thailand
Toptal member since August 15, 2022
Ukrit has an MBA degree and 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
Availability
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
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 SQL/SCADA server to perform analytics for wind turbines 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
Tools
Microsoft Power BI, Microsoft Access, Microsoft Excel, Excel 2013, Power BI Desktop, Power Query
Languages
Excel VBA, Visual Basic for Applications (VBA), Python 3, SQL, Python, T-SQL (Transact-SQL), R, HTML, Visual Basic, JavaScript
Platforms
Google AppSheet, Windows, Visual Studio Code (VS Code), SharePoint, Azure, Web
Storage
SQL Server 2016, Microsoft SQL Server, Azure SQL, SQLite, SQL Stored Procedures, Databases
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
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