Ukrit W.

Ukrit W.

Senior Software Engineer

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.

Excel VBA Visual Basic for Applications (VBA) Python 3 SQL Python T-SQL (Transact-SQL) R HTML Visual Basic JavaScript Microsoft Power BI Microsoft Access Microsoft Excel Excel 2013 Power BI Desktop Power Query Google AppSheet Windows Visual Studio Code (VS Code) Sharepoint Azure Web SQL Server 2016 Microsoft SQL Server Azure SQL SQLite SQL Stored Procedures Databases 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 Bootstrap Flask Hadoop Spark Management Dimensional Modeling Business Intelligence (BI) App Development REST APIs

Work history

Green Innovation and Maintenance
Finance Manager and Software Developer
2023 - Present (1 year)
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)

Portfolio

Warehouse Inventory Map

In complementing the company's ERP SAP B1 system, I proficiently crafted a tailor-made Microsoft Access app, leveraging Visual Basic for Applications (VBA), aimed at satisfying the organization's distinctive requirements. This component of the application facilitates comprehensive warehouse visualization encompassing bin locations or shelves, streamlined item search capabilities, and the ability to inspect the contents of a designated bin. Additionally, the app seamlessly integrates QR code scanning functionality for efficient bin location management.

Power BI Dashboard for ERP

Utilizing Power BI alongside SAP Business One as the ERP system, I skillfully developed multiple dashboards catering to diverse departments within the organization. By establishing a live connection between the dashboard and the ERP database, employees experienced a remarkable enhancement in productivity, transitioning from spending hours scrutinizing individual ERP pages to mere minutes, as all relevant information was conveniently consolidated within a single, comprehensive dashboard, offering a preliminary analysis.

Web App for API-ERP Connection

I developed a tailor-made internal web application utilizing Flask and Bootstrap frameworks with the primary objective of linking multiple online shopping platforms (e.g., Shopee, Lazada, TikTok) to the company's ERP system, SAP Business One. The purpose behind creating this web application was to automate mundane and repetitive tasks entailing manual re-entry of purchase orders across different platforms onto 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)