Experience

Atlantix Partners

• United States
• Business Consulting and Services
• 1 - 100 Employee

• Data Analyst

  • Jun 2023 - Oct 2023

  Fort Lauderdale, Florida, United States Proficient in data acquisition, processing, and manipulation using Python and Alteryx, with expertise in creating indices and visualizations in Tableau to deliver valuable business insights, consistently achieving high client satisfaction • Built and refined more than 100 Tableau visualization sheets, delivering key business trends and compelling insights to clients, consistently achieving a 100% satisfaction rate and fostering lasting client relationships • Manipulated and maintained… Show more Proficient in data acquisition, processing, and manipulation using Python and Alteryx, with expertise in creating indices and visualizations in Tableau to deliver valuable business insights, consistently achieving high client satisfaction • Built and refined more than 100 Tableau visualization sheets, delivering key business trends and compelling insights to clients, consistently achieving a 100% satisfaction rate and fostering lasting client relationships • Manipulated and maintained over 30 Alteryx workflows, ensuring the cleansing and transformation of client ERP system data into a format ideal for rigorous analysis and dynamic presentation. • Development of Python scripts, resulting in an 80% reduction in data validation time and streamlining the ETL process for P&L data, enhancing data accuracy and analysis efficiency Show less

• Summer Associate

  • May 2022 - Aug 2022

  Fort Lauderdale, Florida, United States Participated in consulting firm’s largest client project to extract, transform and load cash disbursement and reconciliation data of two merging health companies. • Created and alternated complex Alteryx workflows to perform data transforming, matching and cleansing to reconcile state-level bank statement and controlled the mismatch rate around 10% • Used the text extractor tool in Amazon Web Services (AWS) to convert pdf bank statement into Excel spreadsheet and wrote Python script to… Show more Participated in consulting firm’s largest client project to extract, transform and load cash disbursement and reconciliation data of two merging health companies. • Created and alternated complex Alteryx workflows to perform data transforming, matching and cleansing to reconcile state-level bank statement and controlled the mismatch rate around 10% • Used the text extractor tool in Amazon Web Services (AWS) to convert pdf bank statement into Excel spreadsheet and wrote Python script to automize the bank data union process which reduced the working time by 80% Show less



DATALAS

• Belgium
• Health, Wellness & Fitness

• Spatial Data Analysis

  • Aug 2020 - Aug 2021

  Shanghai, China • Wrote a Python library compatible with company’s API to batch over 200 new charts and platform in company’s own app. Increased the working efficiency of $500K project by 300%. • Analyzed customer surveys with 12,000 pieces of data to categorize customers into 5 main groups and 11 small categories and identify each group’s preference. Drew over 20 scatter plots, heatmaps and OD diagrams for visualization. • Utilized the Sklearn BallTree model and Kernel density estimation to improve the… Show more • Wrote a Python library compatible with company’s API to batch over 200 new charts and platform in company’s own app. Increased the working efficiency of $500K project by 300%. • Analyzed customer surveys with 12,000 pieces of data to categorize customers into 5 main groups and 11 small categories and identify each group’s preference. Drew over 20 scatter plots, heatmaps and OD diagrams for visualization. • Utilized the Sklearn BallTree model and Kernel density estimation to improve the accuracy by 15% of the algorithm that estimates the residents’ salary distribution in Shanghai to build a house pricing map for developers. Show less



Humanistic GIS Laboratory

• Covid-19 Dashboard Project Leader

  • Jun 2020 - May 2021

  Seattle, Washington, United States Developed a web dashboard for workers to show Covid risk levels for different professions in Washington State. Led a team of four students to manage the projects’ timeline, including background study, data collecting, data crawling, website prototype, coding and testing. • Collaborated with the team to assign tasks and held weekly progress meeting to ensure on-time project… Show more Developed a web dashboard for workers to show Covid risk levels for different professions in Washington State. Led a team of four students to manage the projects’ timeline, including background study, data collecting, data crawling, website prototype, coding and testing. • Collaborated with the team to assign tasks and held weekly progress meeting to ensure on-time project completion. • Used update frequency, data scale, and data quality to select the proper dataset from 22 different sources and perform analysis on covid-19 case trend and tendency. • Built the main structure and layout for the dashboard website, including 4 pages and over 1,500 lines of JavaScript. Used the c3, leaflet, bootstrap library to add interactive features to enhance the user experience. Show less



Victorinox Swiss Army

• Retail

• Marketing Intern

  • Jul 2019 - Sep 2019

  Shanghai City, China • Designed users’ survey and analyzed over 500 users’ information to study users’ preference and improve the advertising efficiency by 20 percent. • Categorized and reorganized company’s whitelist for SMS publicity to spread corporate culture and enhanced corporate influence.



Splunk

• United States
• Software Development
• 700 & Above Employee

• UI Automation Internship

  • Jun 2019 - Jul 2019

  Shanghai City, China Learned the SPL languages and learned how splunk’s search engines works Worked with colleagues to figure out and report the bugs in the dark mode of the software Participated in hack week group to build a slack-splunk interacted program Attented weekly meeting and understanded the company culture and how a tech company works



Community Center Shanghai

• Civic and Social Organizations
• 1 - 100 Employee

• Marketing Intern

  • Jul 2018 - Sep 2018

  Shanghai City, China Edited and publish the newsletter weekly on public platform Design the visuals for “Gala” event include: posters, advertisements, bid sheet, stage backdrop Using excel to categorize the information of attendances for the event Communicate with other organizations to display CCS magazine sample