• Migrate database SAP/Oracle to Azure Database following document ssis or old
structure
• UAT compare data by unit count and field by field from old process on SAP/Oracle to
new process on Azure Databricks
• Using data factory on azure services to create process sent data from Azure to MS SQL
• Created Mapping process and data dictionary follow SSIS structure
• Developed and maintained process upload file adjust data month end
• Testing value and Compare Data field by field to check and find collect field follow
requirement
กุมภาพันธ์ 2563 ถึง เมษายน 2566
Management Information System(MIS)- IT
Tidlor, Bangkok, Thailand Company's
สำหรับสมาชิกเท่านั้น
• Using Access to create report following user requested
• Query data checking source data
• Developed process to create report(Yearly/Monthly/Weekly/Daily/One time)
by transaction &summary following user requested
• Export data following user requested
• Monitoring process onhand(Yearly/Monthly/Weekly/Daily)
• Using Excel pivot report following user requested • Develop Macro excel to create
automate refresh data and pivot report
พฤศจิกายน 2561 ถึง กุมภาพันธ์ 2563
Management Information System(MIS) - IT
AIS, Bangkok, Thailand Company's
สำหรับสมาชิกเท่านั้น
• Query data checking source data
• Developed process to create report(monthly/daily) by transaction &summary
following user requested
• Export data following user requested
• Monitoring process onhand(Monthly/Daily)
• Check source & extract data on tableau server
• Create tableau dashboard • Using Excel pivot report following user requested