Kennard Tan

Experience

• 

  PPG

  Aug 2021 - Jul 2022

  Data Engineer

  Had a 1 year internship at PPG Industries, it was a fully Work From Home experience, there I had learnt about Microsoft Azure Cloud services and most of it features.Learnt most about SQL as I had a project that involved migrating an app from QlikView to Power Bi, the codes were written in Azure Databricks, then had to load the data into Power BI.Had learnt about SSIS and SSRS, beginner-level knowledge as most of the time I used SSIS to load monthly data into the database.Learnt about the responsibilities between Data Engineer and Data Analyst. Both have different roles. Data Engineer is the one preparing the data and the app/dashboard. Data Analyst is the one making sure that the dashboard/app is going into the right direction, directing data engineers - giving them the right direction.Assisted in a big project - Global Account Receivables - the goal was to create a Power BI Application to show PPG's Global Account Receivables, but PPG has different ERPs and a lot of branches across the world.The data is keyed-in with different formats depending on the branches. I created the mapping files to identify the data and transformed the data required in this project, from different ERPs, all into a standardized format, so that PPG can use those data readily in different project next time.For Global Account Receivables, I have also performed Gap Analysis between the legacy applications - as each ERP had their own Power BI application already, so when the new Power BI application is in UAT, I had performed Gap Analysis between the new one and the legacy ones to make sure there is no missing features. I had also performed Data Validation for this project. Show less

• 

  IZeno

  Sept 2022 - now

  Analytics Consultant

  ResponsibilitiesAnalyse, design and implement data analytics solution for customersCollaboratively work with customers, project team members and partners in defining business & technical requirementsLead functional discussions and leverage your knowledge of best practicesWork with the project team to translate requirements into project deliverables & prioritizationPlanning and executing both client and internal projects, following through entire software development lifecyclePerform project implementation offsite and onsiteMaintain and support new and/or existing customerResolve issues regarding to project assignedResearch & development of relevant knowledge and skillset Show less