◼️ 𝗖𝗥𝗠 𝗠𝗮𝘀𝘁𝗲𝗿 𝗗𝗮𝘁𝗮 𝗪𝗮𝗿𝗲𝗵𝗼𝘂𝘀𝗶𝗻𝗴- 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗱 𝗮 𝗖𝗥𝗠 𝗔𝗰𝗰𝗼𝘂𝗻𝘁 & 𝗖𝗼𝗻𝘁𝗮𝗰𝘁 𝗠𝗮𝘀𝘁𝗲𝗿 𝗦𝘆𝘀𝘁𝗲𝗺 from scratch, integrating customer-related data from multiple sources, including ERP (MS SQL), user interactions (ADX, MongoDB), and external services (APIs), ensuring data consistency across various databases.- 𝗢𝗿𝗰𝗵𝗲𝘀𝘁𝗿𝗮𝘁𝗲𝗱 𝗱𝗮𝘁𝗮 𝗰𝗼𝗹𝗹𝗲𝗰𝘁𝗶𝗼𝗻 using Salesforce via 𝘐𝘯𝘧𝘰𝘳𝘮𝘢𝘵𝘪𝘤𝘢, internal data sources through 𝘈𝘻𝘶𝘳𝘦 𝘚𝘺𝘯𝘢𝘱𝘴𝘦, and third-party APIs via 𝘈𝘻𝘶𝘳𝘦 𝘍𝘶𝘯𝘤𝘵𝘪𝘰𝘯𝘴, consolidating the information into an OLAP database for advanced analytics and reporting.◼️ 𝗗𝗮𝘁𝗮 𝗜𝗻𝘁𝗲𝗴𝗿𝗮𝘁𝗶𝗼𝗻 & 𝗖𝗹𝗲𝗮𝗻𝗶𝗻𝗴- 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗱 𝗹𝗼𝗴𝗶𝗰 for correcting account-contact relationships and establishing a single source of truth in the database, ensuring data consistency across the system.- 𝗘𝗹𝗶𝗺𝗶𝗻𝗮𝘁𝗲𝗱 𝟭𝟬% 𝗼𝗳 𝗱𝗮𝘁𝗮 𝗱𝘂𝗽𝗹𝗶𝗰𝗮𝘁𝗶𝗼𝗻 by leveraging 𝘈𝘱𝘢𝘤𝘩𝘦 𝘚𝘱𝘢𝘳𝘬 for efficient data processing, significantly improving data integrity and accuracy across the platform.- 𝗗𝗲𝘀𝗶𝗴𝗻𝗲𝗱 𝗮𝗻𝗱 𝗶𝗺𝗽𝗹𝗲𝗺𝗲𝗻𝘁𝗲𝗱 𝗔𝗣𝗜𝘀 to enhance real-time data manipulation for the UI backend, resulting in a smoother user experience and better accessibility of data.- 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗱 𝗮 𝗠𝗼𝗻𝗴𝗼𝗗𝗕 𝘃𝗲𝗰𝘁𝗼𝗿 𝘀𝗲𝗮𝗿𝗰𝗵 𝘀𝗼𝗹𝘂𝘁𝗶𝗼𝗻, boosting CRM data search accuracy by 20%. Enable faster identification of similar customer records, leading to more efficient data analysis and improved decision-making.

⬛️ Data Pipeline- Designed and built data pipelines for both analytical and operational data applications, enabling efficient data flow for various business needs.- Successfully migrated over 25 existing data pipelines from Linux Crontab jobs to Apache Airflow, containerized with Docker for improved scalability and manageability.⬛️ BI Dashboard- Leveraged Tableau to create over 10 high-value business reports, accelerating the pace of business reporting transformation and providing valuable insights to stakeholders.⬛️ Data Migration- Championed the migration from on-premise to cloud services for data pipelines, ensuring smooth transition while providing ongoing support and maintenance.

⬛️ Conduct Experiment & Develop New Measuring Method- Have cooperation with Columbia University for 8 months and mainly conduct Centrifuge experiments ( 2019/6-2020/1 ). - Develop a new laser measuring method which is a key breakthrough in laboratory experiment to build a 3D model.