Fox Tien

Experience

• 

  日月光半導體製造股份有限公司

  Apr 2001 - Jul 2004

  Software Programmer

  Major to build a system that tracks the quantity, location, and status of wafers at various stages of the manufacturing process, from incoming inspection and testing to storage, processing, and shipment. This includes monitoring the availability and quality of wafers, ensuring that the right type and quantity of wafers are used for specific products, and minimizing waste or defects.

• 

  Apex Group Ltd

  Jul 2004 - Jul 2006

  Trading Strategy Consultant

  The primary function of this role is to assess various trading systems in order to assist traders in identifying profitable trading opportunities, optimizing their risk management strategies, and improving their overall trading performance. This position may involve a variety of tasks, such as analyzing market trends and data using customized trading algorithms and models, as well as testing and refining trading strategies through simulations and backtesting.

• 

  Kelly Chemical Corporation

  Apr 2008 - Apr 2009

  Business Intelligence Specialist

  Developed dashboards that consolidate data from multiple ERP software applications used by various subsidiaries of the corporation.Collaborated with cross-functional teams to gather requirements and design the solution architecture.Utilized web pages to visualize data in a meaningful way.Designed and developed ETL scripts to integrate data from different sources.Implemented security measures to ensure data privacy and protection.Conducted testing and quality assurance to ensure the accuracy and reliability of the dashboard.Presented the dashboard to the management team, enabling them to make informed decisions based on real-time data. 收回

• 

  Xuenn Private Limited

  Jun 2009 - Feb 2023

  As a Technical Specialist(Risk Management), I had the opportunity to work on a project related to the implementation of ISO27001 information security standard within our organization. My responsibilities included identifying risks associated with various business units and technologies, creating a risk matrix, and developing risk assessment reports and treatment plans. We began by conducting a thorough analysis of our organization's information security posture, identifying potential risks and vulnerabilities across all departments and IT systems. I then worked with other members of the team to establish a risk matrix, which helped to prioritize risks based on their severity and potential impact on our organization.Using this risk matrix as a guide, we then created detailed risk assessment reports, which included recommendations for mitigating potential risks and enhancing our overall security posture. These reports were used to inform our risk treatment plan, which outlined specific steps that needed to be taken to reduce our exposure to identified risks. 收回 As an enterprise architect, I have been responsible for ensuring our the quality, stability, and security of web applications, databases, and operating systems. This has involved comparing different versions of front-ends, back-ends framework, databases, and operating systems to determine the best combination of technologies for our organization.To achieve this, I have regularly reviewed the latest industry trends and emerging technologies and conducted Proof of Concept (POC) testing to identify the strengths and weaknesses of different technologies. I have also worked closely with developers to provide guidance on the most secure and efficient technology stack for our applications.As part of my responsibilities, I have also monitored the vulnerabilities and risks associated with different versions of FE/BE framework, databases, and operating systems. I also provided regular suggestions to developers on the latest security threats and recommended solutions to mitigate those risks.In addition, I have developed and maintained a repository of best practices for FE/BE framework, database management, and operating system administration. This has helped to ensure consistency and standardization across the organization, and has facilitated the sharing of knowledge and expertise among developers. 收回 I have extensive experience in data governance, including managing metadata, schema, datatypes, business names, and logical names for different databases. To achieve this, I have used various tools such as Alation, which is a popular data cataloging and governance tool.With Alation, I have created data dictionaries for different databases, which can be accessed by authorized users through LDAP integration. I have worked closely with business users and data owners to ensure that the data dictionary is comprehensive, accurate, and up-to-date.To automate the process of managing metadata and data governance, I have also used Python to develop scripts and tools that can automatically generate and update metadata, schema, and data dictionaries. These tools have been instrumental in ensuring that data governance processes are streamlined and efficient. 收回 I have extensive experience in building Business Intelligence (BI) systems, including designing data models in Teradata for Raw, Core, and Mart data layers. I have used various data modeling tools such as ERwin, Oracle Modeler, and Teradata Studio to design and manage data models.For ETL processes and scheduling, I have utilized Trinity, which is a highly compatible with teradata BTEQ scripts , to extract data from multiple sources, transform it, and load it into a Teradata database. I have also used other CDC tools such as Qlik Replicate for data integration tasks in real time.In addition to data modeling and ETL development, I have designed and developed Tableau dashboards and reports to provide visualizations and insights to business users. I have worked closely with business analysts to understand their reporting needs and have designed interactive dashboards that can display data in different dimensions and at various levels of granularity. These dashboards have helped business users to quickly analyze large volumes of data and make informed decisions. 收回 I was responsible for managing Oracle databases management which included ensuring the performance, availability, and security of the database systems.One of my key responsibilities was implementing partitioning strategies to improve the efficiency of database backups. I utilized the partition switch method to periodically switch partitions between online and offline states, making it possible to back up the data without affecting the live system. This approach significantly reduced backup time and minimized the impact on the production environment.I also used Automatic Workload Repository (AWR) reports to analyze database performance and identify system bottlenecks. I regularly reviewed these reports to identify and optimize areas of concern, including query optimization, index tuning, and memory allocation. By proactively identifying and addressing performance issues, I was able to improve overall database efficiency and reduce downtime. 收回 I am responsible for collecting Oracle data and transforming it into a format that could be used for analysis through the ETL (Extract, Transform, Load) process. I major in using Microsoft SQL Server Integration Services (SSIS) to increase the efficiency of data processing.Additionally, I actively participated in many business projects including data analysis, business process optimization, and system integration, and frequently communicated and coordinated with team members and customers.After the data was transformed, I used SQL Server Analysis Services (SSAS) to create a multi-dimensional dataset to support different analytical needs. I developed a series of reports based on the multi-dimensional dataset, which could analyze data from different angles and perspectives such as time, geography, products, and customers. Report users used these reports for decision-making, monitoring business performance, and identifying market trends. 收回

  • Technical Specialist(Risk Management)

    Oct 2022 - Feb 2023

  • Enterprise Architect(Group)

    Jun 2021 - Oct 2022

  • Data Architect(BI)

    Jun 2019 - Jun 2021

  • Senior Information Technology Consultant(BI)

    Jun 2016 - Jun 2019

  • Senior Information Technology Consultant

    Jun 2011 - Jun 2016

  • Information Technology Consultant

    Jun 2009 - Jun 2011
• 

  Microsoft

  Sept 2023 - now

  Technical Support Engineer(CADU_IP)

  With the experience specializing in supporting Azure Data Factory (ADF). Adept at resolving diverse challengesrelated to data integration, various data sources, network configurations, and virtual networks. Committed todelivering high-quality solutions that meet and exceed client expectations.- Provide expert guidance and support to clients in utilizing Azure Data Factory for seamless data integrationand transformation.- Resolve complex issues related to different data sources, ensuring smooth data workflows within Azure DataFactory.- Collaborate with clients to optimize network configurations, troubleshoot virtual network issues, and enhanceoverall system performance.- Conduct comprehensive assessments of clients' existing infrastructure to identify areas for improvement andoptimization. 收回