• Gathering requirements form user to developed report following user requested
• Calculated Commission for monthly report following performance report & Schema
• Prepare data about assign collection phone, field ,OA Requirements
• Prepare process to generate report Assign collection follow user requirements
กันยายน 2566 ถึง มีนาคม 2567
Data Engineer
Kiatnakin Phatra Financial Group
สำหรับสมาชิกเท่านั้น
• Migrate database from Oracle/Sap 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 With Pipeline
• Created Mapping process and data dictionary follow SSIS structure
• Developed and maintained process upload file adjust data month end
กุมภาพันธ์ 2563 ถึง เมษายน 2566
MIS IT
Tidlor
สำหรับสมาชิกเท่านั้น
⦁ Using Access to create report following user requested
⦁ Query data checking source data
⦁ Depvelop 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