Ukrit Wong, Developer in Bangkok, Thailand
Ukrit is available for hire
Hire Ukrit

Ukrit Wong

Verified Expert  in Engineering

Software Developer

Location
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

Green Innovation and Maintenance
Finance, Cash Management, Cash Flow, Feasibility Studies, Feasibility...
K&B Cosmetic
Python 3, Microsoft Power BI, Microsoft Access, SQL, Microsoft Excel, APIs...
Siemens Gamesa Renewable Energy
Management, Excel VBA, Microsoft Power BI, Microsoft Excel, Dashboards...

Experience

Availability

Part-time

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

2023 - PRESENT
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.
Technologies: Finance, Cash Management, Cash Flow, Feasibility Studies, Feasibility, Excel Expert, Google AppSheet, Azure, Azure SQL, SQL, Python, Data Queries, Databases, Data Visualization, Microsoft Power BI, Power BI Desktop, Visual Basic, JavaScript, Projects, Web Project Management, Low Code, BI Reports, BI Reporting, Reports, Reporting, App Development, Web, Web Development

Project Manager

2021 - 2022
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.
Technologies: Python 3, Microsoft Power BI, Microsoft Access, SQL, Microsoft Excel, APIs, Dashboards, Data Visualization, Interactive Dashboards, Web Dashboards, Reports, BI Reports, BI Reporting, Python, SQL Server 2016, Bootstrap, Bootstrap 4, Azure SQL, Azure, Data Engineering, Flask, SQLite, Internet Information Services (IIS), Microsoft SQL Server, Data Analysis, Excel 2013, Dimensional Modeling, Business Intelligence (BI), T-SQL (Transact-SQL), SQL Stored Procedures, Data Analytics, Data Queries, Reporting, SAP Business Intelligence (BI), SAP ERP

Site Manager

2020 - 2021
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.
Technologies: Management, Excel VBA, Microsoft Power BI, Microsoft Excel, Dashboards, Data Visualization, Interactive Dashboards, Web Dashboards, Reports, BI Reports, BI Reporting, Excel 2013, Business Intelligence (BI), Reporting

Service Representative

2016 - 2020
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.
Technologies: Engines, Client Relations, Planning, Operations, Management, Microsoft Excel, Reports, Excel 2013, Reporting

Engineering Officer

2015 - 2016
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.
Technologies: Microsoft Access, Visual Basic for Applications (VBA), Excel VBA, SharePoint, Operations, Planning, Microsoft Excel, Reports, Python, Excel 2013

Warehouse Inventory Map

As an additional functionality to the company's ERP SAP B1, I developed a Microsoft Access app, Visual Basic for Applications (VBA), to meet the company's specific needs. This part of the app lets you view the whole warehouse with all the bin locations or shelves, search for specific items, or pick a particular bin and view the items in it. It also utilizes QR code scanning for bin locations.

Power BI Dashboard for ERP

With Power BI, I created several dashboards for various departments in a company using SAP Business One as their ERP. Directly connecting the dashboard live with the ERP database, employees could reduce hours of browsing through each page on the ERP to get the required information for analyzing to minutes with all the information presented in one dashboard plus a level of pre-analysis.

Web App for API-ERP Connection

A customized internal web app (created with Flask and Bootstrap) was built with the intention to connect various online shopping platforms (i.e., Shopee, Lazada, TikTok) with the company's ERP (SAP Business One). I created this web app to automate repetitive laboring tasks like retyping a PO onto the company's ERP from the various platforms.

Languages

Excel VBA, Visual Basic for Applications (VBA), Python 3, SQL, Python, T-SQL (Transact-SQL), R, HTML, Visual Basic, JavaScript

Tools

Microsoft Power BI, Microsoft Access, Microsoft Excel, Excel 2013, Power BI Desktop, Power Query

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

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

Frameworks

Bootstrap, Flask, Hadoop, Spark

Paradigms

Management, Dimensional Modeling, Business Intelligence (BI), App Development

Libraries/APIs

REST APIs

2023 - 2024

Master's Degree in Data Science

Chulalongkorn University - Bangkok

2016 - 2018

Master's Degree in Business Administration (MBA)

Thammasat University - Bangkok, Thailand

2011 - 2014

Bachelor's Degree in Aerospace Engineering

Kasetsart University - Bangkok, Thailand

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring