• Extract data from SQL databases to design and develop interactive Tableau dashboards for visualizing and analyzing legal and financial data for senior management.• Collaborate with marketing vendor to provide data-driven insights and recommendations for targeted campaigns, resulting in a 22% increase in website traffic and leads.• Manage and maintain existing Tableau dashboards, ensuring data accuracy and completeness through regular data quality checks and updates.• Build Excel models to calculate potential awards and settlements, providing crucial data to the legal team for informed decision-making and negotiations.• Generate P&L spreadsheets and build financial dashboards to help financial department track financial performance and support budgeting and forecasting processes.• Train and mentor colleagues on best practices for data visualization, dashboard design, and Tableau usage.

• Managed inquiries and client database by using Google sheets, Excel and Salesforce• Generated and presented weekly, quarterly and annually report to support manager-level’s decision-making• Analyzed 5000 historical client data by using Excel and R, and created user image report to help marketing team budget and target user groups • Collaborated with teammates and vendors to design and launch new products; meanwhile run effective marketing campaign

- Constructed the Emory campus spatial database independently using ArcMap and Excel VBA- Successfully collected spatial data from 74 categories by communicating with eight different departments - Designed and built a web map using basic Python in ArcMap by cooperating with IT professionals

• Assisted with lab researches by transferring 120 sample patients’ fMRI images into numerical data using MATLAB • Provided descriptive statistics for 325 patients’ information records using Excel and suggested model improvements• Improved QBIL website by independently learning HTML and added 40 new lab publications with teammates• Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers

• Constructed a spatial database for the “Senufo Art” project using Excel and ArcGIS• Collected and arranged relevant data from historical documents and used SAS to output merged datasets into Excel workbooks• Visualized art trading route in Senufo area in a web map by cooperating with teammates- Introduced relevant researches and discovered new topics to the lab group by summarizing and explaining research papers