Ernest Lin Email & Phone Number

Singapore

Singapore, Singapore, Sg

• Data Architecture & Analytics Framework• Data Analytics Solution Delivery• Data Management Processes & Procedures• Solution Architecture• Controls & Standards• Analytics Project Delivery

Singapore, Sg

• Developed strategy, goals, and led the execution of data engineering and data architecture to align with inter-department and organization goals.• Collaborated with teams to shape and drive tactical and strategic development of data infrastructure, reporting and analytical capabilities.• Drove day-to-day service delivery for the data platform, leading initiatives to improve long-term performance, system stability, scalability, security, and resilience of services.• Identified opportunities to leverage and improve platform and data integration capabilities.• Engaged stakeholders to lead technical discovery, whiteboarding, architecture, and data strategy sessions

Singapore, Sg

• Provided guidance and design support around data pipelines & flows, code reviews and processes• Designed optimal data structures and drove data engineering processes to facilitate data science and analytics use cases• Led engagement with partners and business to drive processes that delivers data engineering pipeline according to business needs• Established monitoring process of data pipelines and infrastructure ensuring governance of data operations• Led Data Quality Assessments exercise using Quality metrics defined in IM8• Collaborated with stakeholders to understand data quality challenges faced• Led the Architecture design and review of the Enterprise Data Platform

Singapore, Sg

• Built the working framework for data search and retrieval that brings the right data into A*STAR's analytics ecosystem•Setup and operationalized the data pipelines ensuring performance and scalability• Ensured data quality through data profiling, data cleaning, and other methods• Desensitized confidential information through masking or other methods and ensure data are securely shared• Guided and advised business users in discovering the right dataset through using data catalogue and lineage• Assisted business users with data preparation and in data analytics

Singapore, Singapore, Sg

• Project Lead for Datahub and Public WiFi• Engaged Government Agencies, Industry partners & Institutes of Higher Learning for data collaboration• Created, enhanced and maintained management and operational dashboards• Setup Data Pipelines and Warehouse using Google Data Flow and Big Query for data ingestion from multiple sources • Setup API and facilitate sharing of data with external parties • Performed Data Transformation on flat files in Python (Pandas)• Web Scraping for visitor reviews (Beautiful Soap)• Created and maintained database jobs in MSSQL that sends out daily ticketing reports• Performed Data Modelling using SQL Server Management Studio (SSMS)• Performed Data storage and transformation for Ticketing, WiFi, Retail & People Counter Sensor data in PostgreSQL database• Explored Image extraction & recognition from photos and video clips for plants & visitors POC in Python (OpenCV)• Automated bi-hourly retrieval and broadcasting of GB popularity index and weather forecast deployed in Wayscript using Python (Request & Twilio)• Automated retrieval of WiFi data files via SFTP Tools used : Python, Power BI, Tableau, WinScp, Google Cloud, IBM Cloud, Google Data Studio, Wayscript, Twilio, Postgresql, SSMS, MSSQL, Android Studio & Firebase

Singapore, Sg

• Business Continuity Management (BCM) Coordinator for Department• Business Lead & Tender Evaluation Committee member for Data Lake Project (DaGreat)• Lead for Big Data POC• Recommender System using Collaborative Filtering with Python for cross and up selling of products to customers• Motor Image Recognition with OCBC AI Lab to determine severity of vehicle damage• Project & Vendor Managment of Anti-Money Laundering Analytics (Traps)• Web Scraping for motor images using Python (Selenium)• OCR of claim forms into text using Python (pytesseract & opencv)Tools used : Python,SAS(Base,EG & Viya), Qlikview,Batch File Programming, VBScript, SQL, Microsoft Access, HPQC, AS400, Teradata & Netezza

Singapore, Sg

• Conduct UAT on Enterprise Analytic Dartmart & SAS datamart to ensure business rules and logics are accurate• Integrate and manipulate data from data warehouses, information systems, system master and external files using SAS & SQL• Support in the strategizing of the analytics information roadmap by analyzing the business value arising from existing and new data sources• Development of a coherent information system to store, organize and preserve consolidated views on insurance policy information, customer interaction and other data sources• Gather business rules, provide business requirements and communicating with stakeholders• Development of Customer Single View by doing master data management to provide a holistic 360° view of the customers• Automation of searching and retrieving of source files and the ETL process• Build and enhance Qlikview dashboards to provide users with a more interactive and dynamic visualization of data• Perform analysis to identify gaps in data • Determine schema and sources for the datamart • Preparing of Mapping Documents, Data Dictionary & Taxonomy for Datamarts• Maintenance of Banca Access programs

Singapore, Sg

• Developed a Roadshow Scheduling System for staff to create or book roadshows• Developed a Conference Management System for staff to create or join conferences• Developed Accounts Checking System so information from multiple sources can be consolidated and centralised into a single system• Developed Generate Account Exceptional Report to alert of any exceptions or outliers in reports• Developed Investor centre charting module for management and staff to view sales figures graphically• Developed Priority calls charting to visualized number of calls made or received by sales through the use of graph and charts for management• Developed Correction Short Sell for TRs to declare their shortsells transactions to MAS• Developed Asean Link Reports for Thailand market where the reports are displayed for authorised backroom office staff• Developed Bloomberg Code Module to import data into bloomberg terminal• Enhanced Generation of Analyst mapping list and Client Reports for management• Enhanced Course Registration System for TRs to register for courses and the creation of courses by HR• Enhanced TR Credits Module for credits management in registering for courses• Defined format for Regional Morning Notes templates provided to analysts for use daily• Developed Intranet uploader program to upload documents directly via intranet• Enhanced Contract and CFD Amendment System• Enhanced Order Routing System in the contract amendment system to route different orders to different users from different departments• Setup Test Partner to automate daily repetitive processes of data entry• Institutional Clients application to generate reports from CIB to prevent timeout• Enhanced CIB Notes for analysts and sales representatives to leave remarks and discussion• Build Data Transformation Services objects to automate daily data flow to serversTools used: ASP,ASP.net,Java,VB.net,VB Script,Test Partner & SQL

Singapore, Sg

Participated in the development of Military Civillian Flight Planning Sub-system and Sentosa Access Control Ticketing Systems.• Enhanced functionality of Military Civillian Flight Planning Sub-system by adding flight alert modules• Test lead in charge of conducting training sessions on whitebox coverage testing using Parasoft JTest• ArcGIS demo team member for NEA Project Tender• Sentosa Access Control Ticketing • Developed motion detection and opening and closing of flaps on detection of card for sentosa flap gates to interact with hardware • Conducted training and demonstration of new Ticketing Sales Machine (TSM) interface to Sentosa Stakeholders • Developed Module for Sentosa Spooktacular Event for Ticketing Sales Machine • Island Wide Deployment of software updates to every TSM in Sentosa • Requirement gathering and discussion with Sentosa Stakeholders

Singapore, Sg

• Basic Military Training• Advance Infantry Training• Infantry Scout Proficiency Course• Military Class 3 Driving Course• Life Saver Course• POI Deployment• Intelligent Portable Surveillance System Deployment• SAW gunner appointment during Reservist (611 SIR - MR in 2021)

Master Of Science (Msc), Information Studies

Bachelor, Computer Science

Specialist Diploma, Fund Management And Administration

Diploma, Information Technology, Major Multimedia Applications Development

Gce 'O' Level, Science