Business Analyst Intern
PRISM+
12.2022 - 06.2023
- Developed Python scripts to streamline data retrieval from Airtable, significantly enhancing data retrieval efficiency.
- Automated data cleaning process for sales data to ensure faster and more accurate reporting using Python
- Assisted Overseas Department in creating a program to automate the insertion URL links to large quantity of order numbers in Shopify using the Selenium library with Python
- Assisted Finance Department in creating programs to help cross-check payment from various platform to sales data from Shopify
- Created Excel pivot tables to keep track of sales and for daily reporting
- Create dashboards in Tableau as an alternative to using Excel Pivot tables for reporting for increased efficiency and accessibility
