Jeffrey Pan Email & Phone Number

Boston, MA, US

Woburn, Massachusetts, United States

- Facilitated the migration of production databases from MySQL to Microsoft SQL Server- Designed and developed data-driven software solutions and tools to optimize analysis processes across multiple teams- Created and maintained ETL pipelines and scripts using Python- Managed and maintained MySQL databases through comprehensive maintenance solutions.

Boston, Massachusetts, United States

Content creator for Pan-Try

Belgium

- Designing Python library using Object Oriented Programming to determine etymology of specific organisms using BioPython and Geolocator- Designing and implementing a relational database with bat-fly and Laboulbeniales samples collected globally using MYSQL - Cleaning, validating, and analyzing 17,000+ bat-fly and Laboulbeniales samples for geospatial.

- Enhancing search functionalities by integrating interactive maps and comprehensive statistical summaries using Python- Elevating user experience by crafting and refining a more intuitive website on the WordPress platform- Streamlining data cleansing processes through a combination of Excel and Python for increased efficiency and accuracy- Leveraging GIS.

Boston, Massachusetts, United States

- Reinforce the development of technical skills with Python programming, introducing topics such as dataanalysis with Pandas and basic machine learning methodologies such as linear regression- Facilitate and manage a learning environment for 400+ incoming and prospective Data Science students

Boston, Massachusetts, United States

- Assisting in experimental design, data analysis, content analysis, literature reviews, and running studies using Python, R, and Qualtrics for Northeastern University’s SSC Lab- Scraping and Analyzing Labor Union Twitter and Speech data from various sources on Climate Change and performing sentiment analysis, natural language processing, and topic.

Boston, MA

- Gathering and consolidating data from varied sources, including building data for BERDO 2.0 reporting- Managing utility information for multiple customers on a daily and monthly basis- Validating and verifying customer costs and utilization using rate engines- Fielding inquiry requests and managing problem resolution for customer utility-billing issues.

North Reading, Massachusetts, United States

- Engaged customers on the sales floor and provided an easy and pleasant experience for them- Unloaded and processed new merchandise from the supply truck in the backroom - Stocked the sales floor with merchandise

- Assisted Danny Haelewaters, Ph.D. in finding ladybug samples virtually on inaturalist that had the fungal ectoparasite Laboulbeniales in the U.S. on a weekly basis- Recorded findings onto a spreadsheet for further use and analysis with Microsoft Excel - The data was then imported into Microsoft Access to be further cleaned and manipulated

Bachelor'S Degree, Data Science

Activities and Societies: Huntington 100 Inductee

Bachelor'S Degree, Environmental Science

Bachelor'S Degree, Data Science And Environmental And Sustainability Sciences, 4Th Year

Activities and Societies: Society of Asian Scientists and Engineers, New England Water Environment Association, NU Science Magazine club.

High School Diploma

Activities and Societies: Boys Varsity Indoor and Outdoor Track, Boys Varsity Soccer, National Honor's SocietyTook multiple AP courses and.