林芳伊 Email & Phone Number

• Delivered Business intelligence solution from end to end by using SAP Analytics Cloud; conducted requirement interviews, system analysis and design, ETL, and data visualization. • Crafted comprehensive system specifications to delineate requirements with ER-Model, Sequence Diagram, ensuring precise communication of technical details among cross-functional teams. • Executed ETL in the MSSQL environment to construct data marts and built data models in SAC for data visualization.

Taiwan

Implementation Consultant of SIEMENS Opcenter Execution Foundation & Discrete (MES system)- Facilitated 20+ user requirement workshops and 10+ key user trainings.- Created sequence diagrams and activity diagrams using UML.- Communicate with software engineers and developers with system design specifications.- Collaborated with cross-functional team to encure the solution is delivered in high quality.- Created system UI prototype.Solution Developer of SIEMENS Opcenter Execution Electronic (MES system)- Development in Opcenter EX EL V8.9- Component testing.

－Built Google Data Studio dashboard with BigQuery to analyze product performances for Marketing team, Product team, and UI/UX team.－Maintained Tableau dashboard with SQL for Ad monetization to monitor advertisement revenue.

台灣

－Coordinated a marketing project to call for graduation songs, inspired a 5-person team to formulate marketing strategies with hypothesis thinking, and negotiated with 3 stakeholders to implement the final proposal, achieved the project target by 135%.

- XChange is the largest community of Internet workers in Taiwan, committing to expand the global influence of Taiwan' s Internet professionals. XChange has established overseas branches in 10 international city around the world to cultivate cross-border talent networks.

台灣 臺南市

－Analyzed over 50,000 pieces of data to build Tableau dashboard and introduce insights for the marketing department of“Kdan Mobile”to evaluate EDM strategy for reducing bounce rate and spam rate in 2022.

－Led a 3-person team to launch a data analysis workshop from 0 to 1 and built the S.O.P for Skyline campus workshop; earned 100% willingness of 250 participants to attend the workshop the next time.

台灣 Taichung City 臺中市

- Leaped at the web-maintain project reserved for a full-time web engineer; relaunched the official website in 2 months independently and enabled 30+ topics uploaded.- Directed a 10-person team to launch online exhibition, resulting in over 300 visitors.

Malaysia Sarawak

－Directed a 19-member volunteer abroad program; coordinated with the sponsor, The ASUS Foundation, and 50+ students in Malaysia; brought the information education resources to the rural area in Malaysia.－Solved the crisis of cancellation due to COVID-19 through leadership and negotiation with stakeholders.

- Boosted brand awareness by 150% of Wandering Challenge after a hiatus of 2 years through analyzing and strategizing about marketing goals, schedules, budgets, and resources.- Developed online and offline marketing campaigns to improve sales, which was 60% below target with 2 weeks left to register, leading to 105 participants which exceeded the sales target.