Experience

Ngern Tid Lor

• Thailand
• Financial Services
• 200 - 300 Employee

• Management Information System Analyst

  • Jul 2022 - Present



AIS - Advanced Info Services Plc.

• Thailand
• Telecommunications
• 700 & Above Employee

• Data Analyst

  • Dec 2021 - Jun 2023

  - preparation data and data support as user requests. by using pyspark or SQL on Azure cloud. - data analysis and consult with the user - Create a dashboard with Tableau, PowerBI and MSExcel - Create a predictive model and data feature for marketing or user - Data exploration for implementation and optimization - Predictive model validation - Create ML model - preparation data and data support as user requests. by using pyspark or SQL on Azure cloud. - data analysis and consult with the user - Create a dashboard with Tableau, PowerBI and MSExcel - Create a predictive model and data feature for marketing or user - Data exploration for implementation and optimization - Predictive model validation - Create ML model



Advance innovation technology

• กรุงเทพมหานคร, ประเทศไทย

• Data Analyst

  • Jun 2021 - Nov 2021

  Create data report by queries from a database with MS SQL Create a database view to provide data for business intelligence dashboard with Tableau Analyze the data to provide a business intelligence dashboard in Tableau analyze data corruption in the database and cleansing data Test and finding bugs or errors for applications and web portals. Create data report by queries from a database with MS SQL Create a database view to provide data for business intelligence dashboard with Tableau Analyze the data to provide a business intelligence dashboard in Tableau analyze data corruption in the database and cleansing data Test and finding bugs or errors for applications and web portals.



Thai Smile Airways

• Thailand
• Aviation and Aerospace Component Manufacturing
• 200 - 300 Employee

• Revenue Accountant

  • May 2019 - Jun 2021

  Analysis sales report and payment data to produce a report and finding error. Manage flight reservations, refunds detail using the Amadeus, global distribution system (GDS) about 500-700 transactions per day. Make daily summary report, via Excel. Monitor customer payment and sale report such as credit card payments, Electronic Data Capture(EDC) and QR code payment to prevent payment error. Analysis sales report and payment data to produce a report and finding error. Manage flight reservations, refunds detail using the Amadeus, global distribution system (GDS) about 500-700 transactions per day. Make daily summary report, via Excel. Monitor customer payment and sale report such as credit card payments, Electronic Data Capture(EDC) and QR code payment to prevent payment error.