Experience

Okcoin

• United States
• Financial Services
• 100 - 200 Employee

• Risk Analyst

  • Jan 2022 - Present



Microsoft

• United States
• Software Development
• 700 & Above Employee

• Business Analyst

  • Apr 2020 - Dec 2021

  • Provided actionable business insights for stakeholders by building and maintaining 8 high-quality Power BI reports and dashboards, as well as creating ad hoc reports by requests • Actively communicated with internal and external stakeholders to understand their data and analytical needs, scope data requests, synthesize insights, and recommend solutions in collaboration with engineers and PMs • Managed the backend data by scripting critical stored procedures and views using SQL, built the tabular model cube using Power BI Dax coding to feed the Power BI dashboards • Troubleshot data and code issues, provided support across various product teams within internal systems • Trained and educated client teams on metrics and report functionalities, documented and maintained reports guidance on the team’s wiki page to help users understand and navigate the reports • Worked closely with the BAG Survey Engineering Team to identify issues in existing data pipelines, and optimize data models and DAX query in Power BI reports, which has improved the reports performance by increasing the loading speed by approximately 20% • Built a cost simulation model using statistical analysis (p-value, percentile), Kusto (SQL) and Excel, which could help thousands of Azure File Sync customers to estimate their transaction cost based on their account features Show less



U-Haul

• United States
• Retail
• 700 & Above Employee

• Legder System Intern

  • Jan 2019 - Mar 2019

  • Automated inventory reconciliation between the general ledger and subledger by building reports using SQL • Helped the team to monitor the inventory data in detail and summary by building 8 reports using SQL • Improved data integrity by developing 4 user-friendly front-ends using Microsoft Access which allows the team to pull discrepancies records between subledger and general ledger handily • Automated inventory reconciliation between the general ledger and subledger by building reports using SQL • Helped the team to monitor the inventory data in detail and summary by building 8 reports using SQL • Improved data integrity by developing 4 user-friendly front-ends using Microsoft Access which allows the team to pull discrepancies records between subledger and general ledger handily



Deloitte

• Business Consulting and Services
• 700 & Above Employee

• Financial Advisory Intern

  • Jun 2017 - Jul 2017

  • Analyzed clients’ financial information to complete M&A evaluation by creating comparable analyses with Excel • Sourced reliable data and policies of solar industry and preschool education for due diligence which was then organized with Excel charts and graphs • Translated different documents and contracts between Chinese and English for different companies • Proofread reports to ensure quality for clients • Analyzed clients’ financial information to complete M&A evaluation by creating comparable analyses with Excel • Sourced reliable data and policies of solar industry and preschool education for due diligence which was then organized with Excel charts and graphs • Translated different documents and contracts between Chinese and English for different companies • Proofread reports to ensure quality for clients



ASU School of Molecular Sciences

• Higher Education
• 1 - 100 Employee

• Accounting Aide

  • Sep 2016 - Feb 2017

  • Collaborate with the business office to reconcile the account receivables and payables to ensure accurate data • Interacted and communicated effectively with other departments to backfill missing documents • Collaborate with the business office to reconcile the account receivables and payables to ensure accurate data • Interacted and communicated effectively with other departments to backfill missing documents