Esther Loo

Experience

• 

  Sunway Group

  Dec 2019 - Mar 2020

  Part time Data Entry

  - Assist with data entry- Key in raw data into the system and update existing data; sort and organize paperwork after entering data- Fulfill any duties from seniors or superiors assign in a professional manner

• 

  Plaza Premium Group

  Dec 2020 - Aug 2021

  Finance Intern

  - Assist RTR Finance team on day-to-day operational support.- Perform account allocation, accounting records, and entries, trial accounting balances.- Assist in statements reconciliation, and book-keeping.- Prepare ad-hoc information and statistical breakdowns

• 

  Plaza Premium Group

  Feb 2023 - now

  Data Engineer

  [Business Intelligence & Data Analytic Team]Improve data reliability and quality. Combine raw information from different sources to create consistent and machine readable formats (build Data Pipelines) and final output of PowerBI reportsTools & Tasks:1. AWS Service(SandBox&Production Environment)-S3(for Bronze Layer,Data Lake)/Lambda/Glue/Step Function/Secret Manager/ Athena/SES-Configured file using Json to build Data Pipelines-Call Snowflake/GoogleTrans API to Lambda-Construct AWS Glue&Step Function workflow-Construct AWS SES to send email2. Databricks(Data Warehouse& Data Transformation) for Sliver&Gold Layer-Workspace using notebook scripting(pyspark)-Cleanse (Data Cleaning)&Curated Layer(Data Transformation)-Leverage Databricks in tackling a Natural Language Processing (NLP) task (Extraction Keywords/Noun Phrases, Sentimental Score) &GoogleTrans API3. Snowflake (Data Warehouse&Data Transformation) from External table&Physical Table,to Snowflake View- Using Snowflake SQL scripting to retrieve relevant data to solve business problem e.g. using ForwardKey to analyze daily flight PAX and scheduleTools: DBeaver, SQL Server Management Studio4. PowerBI Pro (Build real-time dashboard, interactive forecast reports to assists for operational planning)5. Microsoft Power Automate (workflow)-Create automated workflow to perform tasks without manual intervention (approval processess, data collection to sharepoint, integration with Office365) 6. Ad-hoc Analysis (updating Role-Level Security RLS on Snowflake, using SQL to input) & Daily Management and Maintenance on PowerBI Dashboard and Data PipelinesTraining/ Course Certificate:1. AWS Certified Machine Learning: Data Engineering, Machine Learning, & AWS2. AWS Certified Machine Learning: Model Training & Evaluation3. Database Fundamentals: Working with SQL Commands4. SQL Concepts & Queries5. Business Reporting: PowerBI Desktop for Data Analysis6. Distributed Systems & Big Data Show less