Ziv Hsu

Search and Analysis Platform - A self-service platform that provides business insights, including product intelligence, customer intelligence, and sales intelligence to Trend Micro employees, helping them easily validate assumptions.

Specific Contributions:

• Feature Development: Responsible for the core feature development of the platform, ensuring system stability and meeting user needs.
• Data Segmentation: Developed the data segmentation feature, allowing users to customize and merge data to quickly obtain the required information.
• Power BI Embedded: Implemented Power BI Embedded, significantly reducing development time from a week to a day or even minutes.
• Generic Filter: Created a generic filter feature, enabling users to quickly filter data based on different scenarios. Previously, data analysts (DAs) had to provide the data, but now users can retrieve the necessary reports themselves through the platform.

Challenges and Solutions:

• Data Source Diversity: The system's data comes from multiple sources and requires ETL processing to update. Developed the segmentation feature to address the challenge of quickly providing information.
• Rapidly Changing Requirements: Company policies and directions change rapidly, increasing development costs. By implementing Power BI Embedded, development efficiency was significantly improved.

Results and Impact:

• Optimized data processing workflows and introduced new technologies, significantly enhancing system usability and flexibility, providing timely and accurate data support for company decision-making.

Technologies Used:

• Python, C#, MSSQL, React, TypeScript, Azure Data Explorer, Highchart, Microsoft PowerBI

Search Engine Services:

• Document Search Platform: Systematically classifies and indexes the company's professional articles, providing keyword search functionality.
• Keyword Trending Search Platform: Offers a Google Trends-like keyword trend query feature.
• Customer Case Search Platform: Provides a search platform for technical support staff to find documents and historical cases related to customer issues.

Specific Contributions:

• Requirement Discussion and Feature Development: Independently discussed requirements with users and developed corresponding features, ensuring the system meets actual usage needs.
• Project Initiation: Established new projects based on in-depth data understanding, offering targeted services and information to improve service quality.

Challenges and Solutions:

• Search Engine Replacement: Replaced the original search engine with Solr, supporting existing services and improving data update speed.
• Data Organization and Retrieval: Needed to effectively organize and retrieve large volumes of documents and data. Solved the data retrieval challenge using Solr and efficient indexing techniques.

Results and Impact:

• These platforms improved the accessibility and utilization of internal company data, significantly reducing the time users spend searching for articles and helping technical support staff resolve customer issues faster, thereby enhancing overall service quality.

Management System Services:

• Services Monitoring Platform: Provides ETL performance and result monitoring platform and data visualization reports.
• Sales Commission Management Platform: Allows users to add business information and automatically generate customized reports.

Specific Contributions:

• Performance Monitoring and Report Generation: Developed monitoring and report generation features, helping users monitor system performance in real-time and generate required reports.

Challenges and Solutions:

• Data Processing: Needed to process large volumes of data and perform real-time monitoring. Solved this challenge through efficient data processing and visualization techniques.

Results and Impact:

• Improved system monitorability and report generation efficiency, providing reliable data support for business decisions.

Data Reporting System Services:

• Data Visualization Platform: Monitors ETL performance and visualizes data for the Hubble project, providing intuitive user information.
• Startup Company Information Search and Analysis Report Platform: Systematically collects and analyzes startup company information, providing reports to the CEO.

Specific Contributions:

• Data Visualization: Developed data visualization features to help users intuitively understand and analyze data.

Challenges and Solutions:

• Data Integration and Analysis: Needed to integrate data from different sources and perform analysis. Solved this challenge through efficient data processing techniques.

Results and Impact:

• Provided comprehensive data analysis reports, helping company executives make informed business decisions.

Technologies Used:

• C#, JavaScript, MSSQL, Angular, Python, Highchart