Hsuan-Wei Liao
- Role
- Financial Analyst Accountant at Foxconn E BG Group
- Location
- Redmond, WA, US
- LinkedIn followers
- 500 followers
Experience
Financial Analyst Accountant
Sep 2020 — Present · Austin, TX, US
Expertise in financial modeling and dynamic dashboard with Excel, including INDEX, MATCH, VLOOKUP, Pivot table, data table, goal seek and so on • Simplify invoicing process and enhance 30% data accuracy • Streamline daily process and reduce 5 working hours per week • Lead the automation project where the user can capture information related to the payment request and avoid printing the documentation and go through each department to obtain signatures • Support the preparation of Month/Quarter/Year End closing tasks and assist in preparation of financial statements in accordance with GAAP • Develop an excel model to batch upload AP/AR/GL to SAP, saving 15 hours weekly • Forecast expenditure of 4 retirement plans by building Excel dynamic graph and chart models • Perform the processing of functional and departmental expense allocations, amortization of prepaid expenses, fixed assets depreciation and adjusting reclassification journal entries • Review employee expense reports, credit card reports, check request and purchase requisition • Review and record the invoices in the accounts payable general ledger using SAP
Education
The University of Texas at Austin
Master's degree, Finance
2019 — 2020
National Cheng Chi University
Bachelor's degree, Risk management and Incurance, • Senior/Junior Year GPA: 4.00/4.00 • Advanced English Program GPA: 4.00/4.00
2011 — 2015
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.