Ukrit W.

Ukrit W.

Bangkok, Thailand
Hire Ukrit W. Hire Ukrit W. Hire Ukrit W.

About Me

Ukrit holds an MBA degree and possesses a strong background in engineering and project management. He has adeptly engineered in-house software solutions for data analytics, forecasts, and dashboards. Further demonstrating his expertise, Ukrit has skillfully developed additional functionalities and extensions for SAP Business One (SAP B1) and seamlessly integrated it with open platforms.

Frontend

HTML JavaScript Bootstrap 4 Bootstrap

Backend

Python 3 Python APIs Flask REST APIs

Database

SQL T-SQL (Transact-SQL) SQL Server 2016 Microsoft SQL Server Azure SQL SQLite SQL Stored Procedures Databases

DevOps

Azure

Other

Excel VBA Visual Basic for Applications (VBA) R Visual Basic Microsoft Power BI Microsoft Access Microsoft Excel Excel 2013 Power BI Desktop Power Query Google AppSheet Windows Visual Studio Code (VS Code) Sharepoint Web Operations Planning Dashboards Data Visualization Reports SAP Business Intelligence (BI) Engines Finance Interactive Dashboards Web Dashboards BI Reports BI Reporting Data Analysis Data Analytics Reporting SAP ERP Aerodynamics Structure Controls Thermodynamics B2C Marketing Client Relations 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 Hadoop Spark Management Dimensional Modeling Business Intelligence (BI) App Development

Work history

Green Innovation and Maintenance
Finance Manager and Software Developer
2023 - Present (2 years)
Remote

  • Digital tools development (Appsheet, Access, Azure SQL, Power BI) – inventory, project management, reporting tools, automation, notification services

  • Project Management – coordinate with suppliers and customer to pilot projects, planning, progress tracking and reporting, Government projects

  • Finance Analysis – track weekly cashflow, AR, overview of each project financial status

  • Commercial / Contractual documents review

  • Feasibility studies – estimate cost, pricing, cashflow projection

K&B Cosmetic
Project Manager
2021 - 2023 (2 years)
Remote

  • New office and warehouse constructio

  • Workflow process improvements which reduces work time and error rate

  • Visualization tools development for managers and executives with Power BI

  • ERP functionalities extension with Access (VBA) including warehouse management system, QR code scanning

  • Web development for ERP/SAP connection with Python (APIs, flask, bootstrap)

  • ERP, Network, and Server maintenance

Rolls-Royce
Service Representative
2016 - 2020 (4 years)
Remote

  • International technical and operational support

  • Deployed on short term assignments to various countries

  • Supported commercial and sales campaign activities

  • Supported development of digital tools

  • Managed logistics and operational planning (large cargo movement)

  • Volunteered ethics advisor within the region

NokScoot Airlines
Engineering Officer
2015 - 2016 (1 year)
Remote

  • Supported airline technical services and publications

  • Managed aircraft maintenance planning

  • Managed aircraft rotation scheduling

  • Maintenance ERP Development with Access (VBA) ie. Tech record, inventory management

  • Facilitated the IOSA audit requirements and corrective action (Engineering)

Showcase

Warehouse Inventory Map

  • Developed a custom Microsoft Access app using Visual Basic for Applications (VBA) to enhance the existing ERP SAP B1 system

  • App facilitates comprehensive warehouse visualization including bin locations and item search capabilities, and allows inspection of bin contents

  • Additionally, integrated QR code scanning functionality for efficient bin location management

Power BI Dashboard for ERP

  • Utilized Power BI and SAP Business One to develop multiple dashboards for different organizational departments.

  • Established live connect between the dashboard and the ERP database, significantly boosting employee productivity.

  • The comprehensive dashboards consolidate all pertinent information, saving significant time by offering preliminary analysis over scrutinizing individual ERP pages.

Web App for API-ERP Connection

  • Developer created an internal web application using Flask and Bootstrap, aimed at connecting multiple online shopping platforms to company's ERP system, SAP Business One.

  • The web application was tailor-made to link platforms like Shopee, Lazada, TikTok to the ERP system.

  • The primary purpose of the application was to automate repetitive tasks involving manual re-entry of purchase orders across different platforms into the company's ERP.

Education

Education
Master's Degree in Data Science
Chulalongkorn University
2023 - 2024 (1 year)
Education
Master's Degree in Business Administration (MBA)
Thammasat University
2016 - 2018 (2 years)
Education
Bachelor's Degree in Aerospace Engineering
Kasetsart University
2011 - 2014 (3 years)