about
Background
I am pursuing a Master’s degree in Computer Science at Northeastern University, San Jose campus. As a software engineer, I specialize in full-stack development and am particularly interested in mobile app development. I love that with the power of programming, we are able to build incredible tools for people, especially the ones that make lives easier. I started this blog to document my studies, and I genuinely hope you find it interesting and/or helpful.
When I’m not in front of my computer screen, I am probably busy training at dance studios, hitting the gym, sipping coffee under the sun, or traveling the world.
Work Experience
Data Engineer @ Dashmote | Jan 2022 - June 2022
- Developed web scrapers based on Scrapy to gather raw data from 5+ delivery platforms. Processed large-scale datasets of 1M+ records using Python, Pandas, SpiderKeeper, Jupyter Notebook and AWS S3
- Utilized AWS S3, ECS, Lambda and EventBridge to automate data collection, resulting in a 90% increase in time efficiency. Migrated deprecated projects to the new schema and monitored the results weekly
- Investigated low-quality data and identified issues using queries against MySQL and Amazon Athena. Researched on Google Places API, conducted experiments and increased the accuracy by 9%
- Collaborated with an engineering team of 7 and cross-functional teams on GitHub across 6 repositories
Operations Intern @ ShopBack | Sep 2020 - Jul 2021
- Integrated TUNE Network API to assist merchant onboarding, setup Salesforce accounts for clients, queried order records using SQL and performed data manipulations using Pandas and Numpy
- Initiated automation projects using Python, Google Sheets API, and hosted on Google Cloud Platform. Supported 1% weekly growth in partner numbers and achieved 98% decrease in support requests
- Constructed JavaScript in Google Tag Manager to support merchant integration via tracking pixels. Provided technical consultation to merchants on Shopify, SHOPLINE, 91App and performed tracking tests
- Assisted data collection using BeautifulSoup and Selenium, supported operations of 20+ merchants with programs deployed to AWS Lambda, resolved ad-hoc issues and designed systematic solutions
- Worked collaboratively with Engineering, Customer Service, Marketing and Business Development teams to optimize and scale merchant operations. Monitored tracking reliability for 700+ merchants
Skills
- Programming Languages: Python, Java, JavaScript, C, HTML, CSS
- Frameworks/Libraries: React, React Native, Node.js, Express, Spring Boot, Django, Flask, Scrapy, Selenium
- Infrastructure: AWS, GCP, Docker
- Database: MySQL, PostgreSQL, SQLite, MongoDB, Firebase
- Tools: Bash, Zsh, Vim, Git, Postman
Connect with me
- LinkedIn:https://www.linkedin.com/in/yunchipang
- GitHub: https://github.com/yunchipang
- Travel Blog:https://triztravel.com