Contributed to the development of a distributed SaaS platform for sports data analytics, improving data consistency and real-time updates across teams using Vue.js and AWS services. Refactored front-end components with Vuetify and implemented lazy loading, reducing initial load time by 28% and improving performance across devices. Integrated and tested RESTful APIs for live scores and user data using Postman and JavaScript; reduced front-end data issues by 45% with added validation and retry logic. Maintained CI/CD pipelines with GitHub Actions and AWS CodeDeploy, reducing deployment time by 50% and supporting faster iteration cycles.

Data Analyst at Taipei Fubon Bank

September 1, 2023 - September 1, 2023

Queried relational databases (RDBMS) with JOINs, CTEs, and window functions to analyze 5K+ monthly credit card applications; profiled data quality, and visualized risk trends in Excel, improving approval accuracy and regulatory compliance. Designed SQL validation rules and data reconciliation checks to cross-reference applicant records across internal systems and watchlists, flagging inconsistencies/anomalies and reducing reviewer effort and fraud risk. Collaborated with IT and risk teams to optimize approval workflows by proposing rule-based logic improvements and SQL-driven validation checks, optimized queries and indexes to cut average review ~20%. Built automation pipelines using scheduled SQL extracts + Excel VBA macros (PivotTables/Power Query) to generate standardized risk and compliance reports, reducing repetitive work 30% and improving reporting consistency/auditability.