藍翊華 Yi-Hua Lan
👩🏻💻 Data-driven storyteller with experience in financial and marketing industries
🖥 M.S. in Business Analytics degree at the University of Maryland, College Park; BA in Public Finance from the best business school in Taiwan
📊 Passionate about data science. I’m excited to help companies make the most effective data-driven decisions and actionable plans by visualizing and interpreting data
工作經歷
Data Visualization Teaching Assistant • University of Maryland, College Park
一月 2023 - 五月 2023
• Assisted students in resolving analytical problems using Python, Tableau, and Google Analytics, while preparing engaging course materials
• Mentored students on best practices in data visualization and web analytics for improved business decision-making
Tax Consultant • Deloitte & Touche Taiwan
八月 2020 - 九月 2021
• Collaborated with multinational companies seeking to set up a new subsidiary in another country by analyzing and determining optimal tax solutions by providing risk analysis using the Deloitte International Tax Source DITS, which resulted in an 80% successful rate
• Conducted data analysis and visualization on financial conditions using Excel, Tableau and PowerBI for multinational clients and used Excel to provide financial forecasting, leading to improved financial performances
• Prepared - 35 transfer pricing reports for global companies, presented insights and managed the tax risk of intercompany transactions by using Pivot Tables in Excel to waive a 20% tax payment
Data Analyst • Dunmei Construction Company
十一月 2019 - 八月 2020
• Applied regression models and predictive analysis in R to measure customer behaviors, which improved the efficiency of customer service by 40%
• Performed data cleaning, testing, and analysis for large financial datasets using Python, and provided proper reporting solution to reduce financial risk
• Collaborated with a marketing team of six and presented insights based on industry trends and competitive intelligence and provided data-driven recommendations via data visualization in SQL and Tableau, which led to a 15% increase in profit due to new social media promotion
Financial Assistant • LINE Taiwan Limited
七月 2018 - 九月 2018
• Reviewed, analyzed, and arranged balance sheets, cash flow statements and financial statements for accuracy over a two-month period while company experienced a 15% increase in revenue
• Completed VAT filing and employee reimbursement via Excel to reduce 10% tax payment for company
學歷
2022 - 2023
University of Maryland, College Park
Master of Science Business Analytics
2015 - 2019
National Taipei University
Bachelor of Arts, Public Finance
技能
Programming/Database
Python, R, SQL, Snowflake
Deep/Machine Learning
Keras, TensorFlow, Numpy, Scikit-learn
Linear/Logistics Regression, Boosting, Random Forest, K-means, Naive Bayes, K-means Clustering, Decision Tree
Productivity Software
MS Office (Excel, Word, PowerPoint), Adobe (Photoshop, Premiere Pro), Google Analytics
Language
Chinese (Native)
English (Professional Proficiency)
