Jeffrey Pan

Jeffrey Pan Email and Phone Number

Data Specialist @ VIA
Boston, MA, US
Jeffrey Pan's Location
Greater Boston, United States
Jeffrey Pan's Contact Details

Jeffrey Pan personal email

n/a
About Jeffrey Pan

I am a driven fifth-year student aspiring to obtain a combined bachelor's degree in Data Science and Environmental and Sustainability Sciences. I am passionate about the environment and I am interested in sustainable resources and business practices. I have lab experience as well as data collection and manipulation experience. I am also a co-writer on a published paper as well as being published on the Northeastern Science Magazine. I always want to learn new things and how they work.

Jeffrey Pan's Current Company Details
VIA

Via

View
Data Specialist
Boston, MA, US
Website:
solvewithvia.com
Employees:
99
Jeffrey Pan Work Experience Details
  • Via
    Data Specialist
    Via
    Boston, Ma, Us
  • Boston Metal
    Database Engineer
    Boston Metal Mar 2024 - Present
    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- Utilized SQL Server Integration Services (SSIS) to develop and implement database maintenance procedures
  • Pan-Try
    Content Creator
    Pan-Try Jun 2024 - Present
    Boston, Massachusetts, United States
    Content creator for Pan-Try
  • Ghent University
    Assistant Research Analyst And Database Engineer
    Ghent University Jan 2024 - Present
    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 analyses
  • Ghent University
    Research Assistant And Web Designer
    Ghent University Nov 2021 - Present
    - 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 technologies to generate insightful Land Use statistics and conduct advanced raster analysis, empowering informed decision-making
  • Northeastern University
    Teaching Assistant - Ds 2000
    Northeastern University Dec 2023 - Apr 2024
    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
  • Northeastern University
    Research Assistant At Social Science Lab
    Northeastern University Dec 2022 - Dec 2023
    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 modeling using Python- Designing and implementing social-economic status casual graph experiments coded in PsychoPy code
  • Veolia North America
    Energy Data Analyst
    Veolia North America Jan 2022 - Sep 2023
    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- Coordinating and assisting with new customer account creation- Collect and organize various energy data sources, develop analysis into processes and code using various tools such as Excel, VBA, MS Access, Tableau, SQL, and SQL Server Integration Services (SSIS), and improve existing processes- Use Python to increase task efficiency by cleaning and manipulating data- Perform Quality Assurance of data integrated into the system- Supporting project management requests as required by the rest of the upper management team- Onboard and training new members of Energy Management team
  • Marshalls Convenience Stores
    Sales Associate
    Marshalls Convenience Stores Jul 2018 - Sep 2021
    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
  • Harvard University
    Research Assistant
    Harvard University Aug 2017 - Mar 2018
    - 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

Jeffrey Pan Skills

Python Sustainability Data Analysis Experimental Design Microsoft Sql Server R (Programming Language Research Data Analytics Microsoft Excel Analytics Data Science Tableau Statistics Energy Quality Assurance Qualtrics

Jeffrey Pan Education Details

Frequently Asked Questions about Jeffrey Pan

What company does Jeffrey Pan work for?

Jeffrey Pan works for Via

What is Jeffrey Pan's role at the current company?

Jeffrey Pan's current role is Data Specialist.

What is Jeffrey Pan's email address?

Jeffrey Pan's email address is je****@****rgy.com

What schools did Jeffrey Pan attend?

Jeffrey Pan attended Khoury College Of Computer Sciences, Northeastern University College Of Science, Northeastern University, Reading Memorial High School.

What skills is Jeffrey Pan known for?

Jeffrey Pan has skills like Python, Sustainability, Data Analysis, Experimental Design, Microsoft Sql Server, R (Programming Language, Research, Data Analytics, Microsoft Excel, Analytics, Data Science, Tableau.

Who are Jeffrey Pan's colleagues?

Jeffrey Pan's colleagues are Maura Keith, Zachary Jarnagin, Matthew Hakar, Anya Piatrova, Jonathan Chirwa, Madeline Monroe, Mohit Patel.

Not the Jeffrey Pan you were looking for?

  • Jeffrey Pan

    Software Engineer @ Splunk | B.S/M.S Computer Science At Vanderbilt
    Greater Philadelphia
  • Jeffrey Pan

    San Francisco, Ca
    1
    picsart.com
  • Jeffrey Pan

    Los Angeles Metropolitan Area
    5
    gmail.com, gmail.com, campbellalliance.com, uchicago.edu, ringspanncorp.com

    4 +184866XXXXX

  • Jeffrey Pan

    San Diego County, Ca
    4
    gmail.com, epic.com, ucsd.edu, health.ucsd.edu

    1 +162680XXXXX

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.