Ukrit Wong，泰国曼谷的开发者
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拥有MBA学位和工程和项目管理经验. 他开发了用于数据分析、预测和仪表板的内部软件. Ukrit还为SAP Business One (SAP B1)创建了额外的功能和扩展，并将其与开放平台连接起来.

Data VisualizationMicrosoft ExcelExcel 2013Microsoft AccessSQL Server 2016Microsoft Power BIData AnalysisData AnalyticsBI ReportsBootstrap 4WindowsVisual Basic for Applications (VBA)PythonBusiness Intelligence (BI)Microsoft SQL ServerSAP ERP

Portfolio

Green Innovation and Maintenance
财务，现金管理，现金流，可行性研究，可行性...
K&B Cosmetic
Python 3, Microsoft Power BI, Microsoft Access, SQL, Microsoft Excel, api...
Siemens Gamesa Renewable Energy
管理，Excel VBA, Microsoft Power BI, Microsoft Excel, dashboard...

Experience

Excel VBA - 10 yearsMicrosoft Excel - 10 yearsPython - 4 yearsSAP Business Intelligence (BI) - 3 yearsData Visualization - 3 yearsGoogle AppSheet - 2 yearsSQL - 2 yearsMicrosoft Power BI - 2 years

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扩展是一个具有项目bin位置的映射仓库，以可视化库存.

Work Experience

Finance Manager and Software Developer

2023 - PRESENT
Green Innovation and Maintenance
  • 开发多个内部管理应用程序(团队零用现金跟踪应用程序), project management, automated reports creation, step approval, and stock management). 应用程序是跨平台的(UI在Google Appsheet上).
  • 进行服务器设置，转换来自SQL/SCADA服务器的数据，以执行风力涡轮机监控操作和性能的分析. 根据工程团队的要求，用Python创建了一个web平台来查看仪表板/图表.
  • 创建每周和每月的财务仪表板和报告. 数据从他们现有的平台连接, 仪表板是用Microsoft Power BI创建的.
  • 管理开发团队开发内部工具，并支持其他关联公司的内部工具开发.
  • 负责项目管理，并与海外团队协调，为泰国可再生能源市场实施新的解决方案. 管理一个团队，成功地在100多个风力涡轮机上安装了带有云监测系统的传感器.
Technologies: 财务，现金管理，现金流，可行性研究，可行性, 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
  • 开发了一个网络应用程序，将公司的企业资源规划(ERP)与使用其api的在线平台连接起来.
  • 使用Power BI为各个部门创建了10多个仪表板, 包括一些带有R转换机器学习(ML)脚本的.
  • 开发了一个Microsoft Access应用程序，该应用程序具有公司SAP Business One (SAP B1)的许多功能扩展, 中小型企业的ERP软件平台.
Technologies: Python 3, Microsoft Power BI, Microsoft Access, SQL, Microsoft Excel, api, 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
  • 创建Excel VBA用于库存跟踪和管理.
  • 数字化表格、日志和团队文件.
  • 开发了一个Microsoft Power BI仪表板来跟踪停机和维护问题.
Technologies: 管理，Excel VBA, Microsoft Power BI, Microsoft Excel, dashboard, Data Visualization, Interactive Dashboards, Web Dashboards, Reports, BI Reports, BI Reporting, Excel 2013, Business Intelligence (BI), Reporting

Service Representative

2016 - 2020
Rolls-Royce
  • 为至少四个国家的多个客户的新产品推出提供现场支持.
  • 作为测试用户支持数字工具的开发.
  • 管理复杂工程产品的物流和运营计划.
  • 自愿为该地区的一个团队担任道德顾问.
Technologies: Engines, Client Relations, Planning, Operations, Management, Microsoft Excel, Reports, Excel 2013, Reporting

Engineering Officer

2015 - 2016
NokScoot Airlines
  • 开发了一个Microsoft Access应用程序来管理和跟踪航空公司的维护活动, including inventory functions, preventive maintenance planning, and automatic daily activity reporting. 这是当局要求的一部分.
  • 管理飞机轮换和维修计划. Reviewed engineering documents.
  • 支持公司SharePoint门户网站的开发.
Technologies: Microsoft Access, Visual Basic for Applications (VBA), Excel VBA, SharePoint, Operations, Planning, Microsoft Excel, Reports, Python, Excel 2013

Warehouse Inventory Map

作为公司ERP SAP B1的附加功能, I developed a Microsoft Access app, Visual Basic for Applications (VBA), to meet the company's specific needs. 应用程序的这一部分可以让你查看整个仓库的所有垃圾箱位置或货架, search for specific items, 或者选择一个特定的容器并查看其中的项目. 它还利用二维码扫描垃圾箱的位置.

Power BI Dashboard for ERP

With Power BI, 我为一家公司的各个部门创建了几个仪表板，使用SAP Business One作为他们的ERP. 直接连接仪表板与ERP数据库, 员工可以将浏览ERP每个页面获取所需信息的时间减少到几分钟，所有信息都显示在一个仪表板上，再加上一定程度的预分析.

Web App for API-ERP Connection

一个定制的内部web应用程序(用Flask和Bootstrap创建)是为了连接各种在线购物平台而构建的.e.比如Shopee、Lazada、TikTok)和公司的ERP (SAP Business One). 我创建了这个网络应用程序来自动执行重复性劳动任务，比如从各个平台将订单重新输入公司的ERP.
2023 - 2024

Master's Degree in Data Science

Chulalongkorn University - Bangkok

2016 - 2018

工商管理硕士(MBA)

Thammasat University - Bangkok, Thailand

2011 - 2014

航空航天工程学士学位

Kasetsart University - Bangkok, Thailand

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存储过程，数据库

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

管理，维度建模，商业智能(BI)，应用程序开发

Libraries/APIs

REST APIs

Collaboration That Works

How to Work with Toptal

在数小时内，而不是数周或数月，我们的网络将为您直接匹配全球行业专家.

1

Share your needs

在与Toptal领域专家的电话中讨论您的需求并细化您的范围.
2

Choose your talent

在24小时内获得专业匹配人才的简短列表，以进行审查，面试和选择.
3

Start your risk-free talent trial

与你选择的人才一起工作，试用最多两周. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring