Learn Data Skills
Beta
Matthew Campbell

Matthew Campbell

Data Analyst

Bucks County Community College

Technologies

My Portfolio Highlights

My New Track

Data Scientist

My New Track

SQL Fundamentals

My New Track

Data Scientist

Data Analyst | Technologist | Writer

My Work

Take a look at my latest work.

track

Data Scientist

course

Importing & Cleaning Data in R: Case Studies

track

SQL Fundamentals

track

Data Scientist

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to R
Understanding Data Science

My Work Experience

Where I've interned and worked during my career.

Bucks County Community College | Mar 2021 - Present

Lead ERP/SIS Analyst

Subject matter expert for Workday Reporting including Advanced Reporting and PRISM. Consults on building data dashboards and visualizations in Workday and SQL Report Manager. Assists other college areas with data management and and research topics. Responsible for data integrations that require content from the Colleague SQL database. Gathers and implements functional requirements for ERP/SIS reporting tasks in Ellucian Colleage, Workday, and other supporting IT systems. - Serving as lead in the data conversion process for the Workday Student implementation - Coding SQL queries to support the Element 451 CRM data integrations - Providing technical assistance to the RADAR team to enable research data analysis
Show More

Bucks County Community College | Nov 2019 - Mar 2021

Data Analyst

Provided compliance reporting for state and federal governments, ad-hoc data analysis, SQL coding, and process documentation. Gathered and implemented research data analysis for all areas in the College including the Deans and the Office of the President. Automated and redesigned reoccurring reporting tasks using SQL. - Provided data reporting for IPEDS, PIMS, NCCBP, VFA and other compliance requirements - Extracted and transformed SQL Server datasets for higher education reporting and data analysis - Used SQL, SSRS, and Tableau to provide insightful data dashboards - Created quality assurance procedures with SQL and R

Code Professors, LLC | Nov 2018 - Oct 2019

Independent Contractor

Provided freelance web design and content marketing support to clients. Created content for marketing and educational purposes to be deployed on client blogs and social media accounts. Codes web apps using the MERN (MongoDB, Express, React, Node) stack. - Pitched, designed and created the Apress book "Learn RStudio, Quick, Effective, and Productive Data Science" - Authored proxy content for social media influencers - Coded a front end app and backend API prototype for a hobbyist drone trading application

The College Board | Mar 2018 - Oct 2018

Data Scientist

N/A

The College Board | Sep 2014 - Mar 2018

Research Statistician II

Aggregated large datasets by school, district, race, gender and other specialized groups to support statistical reporting for College Bound Seniors and AP Report to the Nation. Provided ad-hoc data analysis to the Access to Knowledge team to support internal data requests. Responsible for quality assurance and data preparation for external research teams and media outlets. - Developed an interactive data dashboard in Excel and Tableau for the WICHE dataset - Trained SAS users optimize SQL queries that execute on an AWS cloud data warehouse - Developed tidyverse inspired R packages cbcohortr and datapointsr to optimize data management and QC

App Shop, LLC | Nov 2008 - Sep 2014

iOS Boot Camp Instructor

Founded App Shop, LLC to explore opportunities in the emerging iPhone app market. Coded iOS notepad style apps, created technology content for hobbyists and engineers, used digital marketing techniques to drive traffic and sales to the How to Make iPhone Apps blog and provided boot camp style training classes. - Grew a 40,000+ customer email mailing list via Twitter, YouTube and blog traffic - Developed a custom WordPress website to provide a video training product - Designed and coded nine SQLite based mobile apps - Used Google Analytics and A/B testing to drive sales and web traffic - Managed virtual assistants and consultants to manage a sales funnel - Coded landing and sales pages in HTML and CSS

Educational Testing Service | Jul 2000 - Nov 2008

Lead Statistical Programmer

Progressed through several positions of increasing responsibility starting as a Statistical Assistant before moving on to Statistical Associate and eventually Lead Statistical Programmer. Responsible for psychometric and data management to support assessments such as PRAXIS, TOEFL and SAT. Used SAS to product ad-hoc data analysis for special request projects. Automated processes with VBA and .NET programming. - Provided project management for seasonal PRAXIS test administrations - Built a Test Analysis Generator that automated the process used to create test analysis and improved report quality for the PRAXIS testing program - Designed, planned out and coded the Data Tool app that produced standard visualizations and automated reporting that could be configured for all ETS testing programs - Developed and documented extensive procedures to ensure best practices were followed - Evangelized the effort to implement a SQL Server database system to help manage the large psychometric data requirements for testing and research programs - Built the Trend Plot visualization with VBA and MS Access that the PRAXIS testing program used to detect defects in scaled scores over test administrations

Penndel Mental Health Center | Jun 1997 - Jun 2000

Mental Health Counselor

Provided group and individual counseling to at-risk adolescents. Liaised with social work agencies, schools and mental health institutions. Provided mental health group facilitation on topics such as coping skills and building resiliency.

My Education

Take a look at my formal education

Master of Information Systems (MIS), Management Information Systems, GeneralUniversity of Phoenix | 2007
Bachelor of Science (BS), Psychology, Quantification OptionPenn State University | 1997

About Me

Matthew Campbell

Open to interesting job offers

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free