Cathy (Yi-An) Ko Email & Phone Number

Charlotte, North Carolina, United States

Hsinchu City, Taiwan

Summary: Contributed to digital transformation initiative to enhance wafer production management and monitor key performance indicators. Streamlined data extraction, processing, and reporting processes to increase operational efficiency.► Utilized SQL queries to extract data from 7 different related data tables spread across 3 fab databases.► Ensured data quality by transforming and preprocessing fab data using DAX, Power Query, and Excel.► Built Power BI dashboards to standardize report formats according to fab respective requirements. Power BI dashboards allowed users to monitor KPIs and provide insights on daily production planning and fab utilization capacity. ► Optimized operational efficiency by consolidating and automating six-step procedures using Excel VBA, saving 20+ hours per week.

Taichung City, Taiwan

Summary: Retrieved data to identify potential clients and recognized customers’ needs to enhance revenue and relationships. Compiled investment reports and collaborated with cross-functional teams to ensure seamless IPO deals.► Established 153 prospective clients by collecting data from financial databases, defining criteria for revenue growth rate, assessing cash flow, and analyzing companies’ capital raises over the last five years using vlookup.► Initiated new negotiation strategies with 121 prospective clients across diverse industries and broadened engagement with 28 companies, achieving 25% conversion rate. Won the 1st place in cold call performance in the team.► Recognized customers’ needs in their capital-raising processes and organized clients into quarterly or semi-annual visits to foster relationships with stakeholders, seizing potential business opportunities.► Predicted future IPO target price by compiling investment reports in various sectors encompassing background surveys of prospects, industry trends, financial analysis, and comparable company analyses to present to senior management.► Led projects and collaborated with cross-functional teams, partnering with mergers and acquisitions (M&A) and venture capital for business development, as well as risk and legal departments for seamless deal process.

Taipei City, Taiwan

Summary: Communicated with distributors to monitor production schedules, organized information for presentation in bi-weekly meetings, and undertook a project on 5G customer premises equipment (CPE) for future business initiatives. ► Streamlined the supervision of the production process by acting as liaison to 12 distributors to track production schedule and future activities.► Provided business expansion reference guide to entire team by collaborating with engineers and conducting market research through news articles and company’s internal documents.► Increased efficiency by 80% by analyzing sales data from various brands of smartphones and laptops through Excel pivot tables.

Beijing, China

► Met with potential clients with manager to expand business and recorded detailed meeting minutes► Ensured compliance with local credit regulations by verifying accuracy of loan contracts

Master'S Degree, Applied Analytics, 3.9/4.3

Bachelor'S Degree, Money And Banking, 3.8/4.3

Semester Exchange Program, Economics