About Me.
Having earned a master's degree at the University of Washington in Seattle and a former Audit Senior with EY, bringing a wealth of experience in financial scrutiny, I aspire to leverage my observational prowess, unyielding curiosity, strategic planning abilities and fresh perspective to achieve the field of Data Analytics. Currently immersed in General Assembly's Data Bootcamp, I've mastered SQL, Excel, Power BI, Python, Tableau, and the art of data visualization. I'm passionate about extracting actionable insights from complex data and ready to apply my skills and analytical mindset to a dynamic Data Analyst role. Excited about all types of data analyst journeys! I love the process of how to make data into useful and fascinating dashboards with attractive storytelling.
I spend my free time enjoying various activities such as swimming, pickleball and karaoke. Currently consider starting my first Taekwondo class! Contact me on Linkedin to get to know me more!
%20(3).png)
Skills & Expertise
Technologies:
Python, SQL, PostgreSQL, Tableau, Power BI, Google Suite, Microsoft Excel, Jupyter Notebooks, Trello
Skills:
Data Cleaning, Data Visualization, Data Analysis, Data Transformation, VLOOKUP, INDEX/MATCH, HLOOKUP, Pivot Tables, Query Language, APIs, Verbal and Written communication skills, Statistics, Financial Reporting, External Audit, Professional Accounting, US GAAP, Legal Research, Project Management.
Python Libraries:
Pandas, Numpy
Languages:
English and Chinese
Work Experience
Aug 2023 - Current
Sunnyvale, CA (Remote)
General Assembly
Data Analytics Immersive Fellow
12-week full-time immersive program of hands-on professional training in Data Analytics skills including Python, SQL, data cleaning, data visualization (Tableau and Microsoft power BI), regression models, classification models, web-scraping, APIs, and statistics.
● Led an in-depth analysis of the Airbnb market in La Jolla, California, which included extensive data cleaning and the use of advanced data visualization techniques within Power BI. Designed comprehensive and clear data reports, successfully communicating insights to technical and non-technical stakeholders.
● Conducted a comprehensive investigation of Washington DC's bike-sharing program, Capital Bikes, using SQL and Tableau to analyze and recommend an expansion engineering driven by user demographic analytics and real-time transit system data.
Aug 2022 - Jun 2023
San Jose, CA
Ernst and Young LLP
Assurance Senior
● Utilized data visualization and statistical analysis to assess key metrics before and after the ERP transition, identifying process improvements and new testing strategies based on insights from the data.
● Performed analytics over payroll, revenue, assets, and expenses leveraging regression analysis, time series forecasting, and anomaly detection to identify risks and outliers.
● Built visual dashboards to track key business metrics and KPIs, enabling dynamic insights into financial performance.
● Analyzed various client’s revenues such as using pivot tables to quantify online clickstream data, using regression analysis to determine average revenue from new product releases to end of product life, calculating content subscription revenue, and performing ASC 606 5-step procedures over revenue contracts given the client’s wide range of revenue streams.
● Automated data extraction and analysis for revenue recognition testing using GL Analyzer (Global Analytics Platform); modeled expected revenue booking trends based on statistical analysis of historical data.
Sep 2020 - Aug 2022
San Jose, CA
Ernst and Young LLP
Assurance Staff
● Performed substantive analytical procedures primarily over high-risk accounts, engagement planning, testing and reporting of transactions while documenting and maintaining sufficient supporting information.
● Performed ASC 606 5-step procedures over customer revenue contracts including assessing contracts for contract modifications, material rights, appropriate SSP allocation, and more.
● Utilized GL Analyzer (Global Analytics Platform) to create correlation analysis to understand client revenue trends and investigate any anomalies outside of expectations.
● Analyzed legal documents and correspondence for risk analysis and financial projections.
Jan 2020 - Mar 2020
San Jose, CA
Ernst and Young LLP
Assurance Intern
● Managed multiple tasks simultaneously, including assisting in task delegation, communicating with 3rd party clients, and ensuring milestones were completed on time.
● Collaborated closely with my client’s onsite HR department to obtain payroll data in order to perform audit procedures and acknowledge the internal condition of the company and its processes.
● Translated several legal evidence materials for the team from Chinese to English, which saved 5+ hours for the project.
Jun 2018 - Aug 2018
Rockville, MD
Integrated Financial Engineering Inc.
Financial Analyst Intern
● Validated and cleaned input data which significantly enhanced more than 10% of the efficiency of subsequent analyses for the analysis.
● Assisted in drafting and formatting two marketing brochures that highlighted the firm's strengths and expertise.
● Performed administrative tasks on an ad-hoc basis. Always found meaning in these tasks as a contribution to the success of the group, no matter how tedious and cumbersome.
Education
Aug 2023 - Oct 2023
Sunnyvale , CA (Remote)
General Assembly
Data Analytics Immersive Certificate
12-week full-time immersive program of hands-on professional training in Data Analytics skills including Python, SQL, data cleaning, data visualization(Tableau and Power BI), regression models, classification models, web-scraping, APIs, and statistic
2019-2020
Seattle, WA
University of Washington
Michael G. Foster School of Business
Master of Professional Account - MPAcc
2015-2019
Taipei, Taiwan
National Taiwan Normal University (NTNU)
Bachelor of Business Administration - BBA