• Processed commercial assets' raw data by performing multiple data profiling actions, including removing outliers based on the accuracy rate generated by Excel Power Query• Conducted data visualization by costumed parameterized clustering and delivered the analyzed result in Tableau

• Generated 50+ monthly profitability reports, regional analyses, trend studies, and rate renewal checks for all life benefits by retrieving the data set by connecting DB Visualizer to Access Database and visualizing the result by Microsoft Power BI• Refined and automated the regression testing by creating 100+ test cases to improve code coverage up to 93%• Assisted in managing the team meeting schedule and contents, 5 new members’ training, and created detailed templates and procedure documentation for transition

• Collected data about annual commercial residence pricing levels for specific cities and districts and visualized the required data by Excel PivotTables and graphs• Gained experience in self-studying interdisciplinary knowledge and software and collaborated with architectural assignments

•Accomplished daily accounting tasks (Billings, Tax return, Trail balance) by utilizing QuickBooks and Excel independentlyand efficiently with precision prior to the deadline• Performed queries in ERP system based on SQL database to support accounting data• Prepared global and regional sales data analysis through spreadsheets and graphs for the company’s annual meeting