Jon Pellitteri
Somerset
Summary
Data analyst whose strengths include raw data cleansing, transformation, regression analysis, and communicating insights through visualization. Adept at building processes for extraction, cleansing, and visualization using Python, SQL and Tableau (Tableau Desktop Certified). Career highlights include building a national recognized dashboard and automating dozens of ETL processes using Python.
Overview
6
6
years of professional experience
1
1
Certification
Work History
DATA ANALYST II
PUBLIC CONSULTING GROUP
04.2021 - Current
- Built and currently manage a substance prevention Tableau dashboard while transforming and linking over 20 data sources using parameters, calculated fields, and SQL which led to over $1M in extended contracts and recognized in the top 3 SEOW dashboards in the country by SAMHSA
- Conducted regression analysis on foster care and healthcare data using Python, SQL and Tableau which extended the contract with the client for future analysis
- Converted multiple analyses from SPSS process to solely Python and saved the company time and cost of renewing SPSS licensing
- Automated ETL processes using Pandas and other Python libraries for many projects, improving efficiency and documentation
- Designed and conducted multiple trainings for new and intermediate Tableau users, giving them skills to build their own reports and securing us as their Tableau TA support contractor
SOFTWARE SUPPORT SPECIALIST
TYLER TECHNOLOGIES
01.2020 - 04.2021
- Troubleshot complex internal and external software errors and created training videos for clients to increase the number of clients fixing issues before they call
- Built custom reports using SQL Server to fulfill unique client requests
- Used advanced Excel tools such as XLOOKUP, Pivot Tables, and formulas for data conversion and reporting and assisted other teammates to help save time spent with data cleansing
- Projects
CAPSTONE PROJECT
UTICA COLLEGE
05.2020 - 08.2020
- Collaborated with a global wind, to develop a change point detection model
- Built a change point detection model to detect changes in gearbox vibration values by integrating R statistical packages into Python
ACCOUNT MANAGER
SKS BOTTLE
06.2018 - 10.2019
- Grew Territory by 105% through new acquisition and client growth through networking and email marketing
- Proposed and implemented several strategies for use of market indicators to target ideal clientele, saving time and increasing book of business by over $500,000
Education
M.S - Data Science
UTICA COLLEGE ONLINE
B.A. - Economics, Mathematics
STATE UNIVERSITY
TABLEAU DESKTOP CERTIFIED ASSOCIATE -
Skills
- Tableau
- SQL
- Python
- R
- SPSS
- Excel
- Pandas
- ETL
- Regression Analysis
- Data Cleansing
- Data Visualization
- Machine Learning
- Data Modeling
Certification
Tableau Desktop Associate Certification
Timeline
DATA ANALYST II
PUBLIC CONSULTING GROUP
04.2021 - Current
CAPSTONE PROJECT
UTICA COLLEGE
05.2020 - 08.2020
SOFTWARE SUPPORT SPECIALIST
TYLER TECHNOLOGIES
01.2020 - 04.2021
ACCOUNT MANAGER
SKS BOTTLE
06.2018 - 10.2019
M.S - Data Science
UTICA COLLEGE ONLINE
B.A. - Economics, Mathematics
STATE UNIVERSITY
TABLEAU DESKTOP CERTIFIED ASSOCIATE -
Similar Profiles
ENID RIVERAENID RIVERA
Case Manager at Public Consulting GroupCase Manager at Public Consulting Group
Sara OnsomuSara Onsomu
Healthcare Compliance Investigator Supervisor at Public Consulting GroupHealthcare Compliance Investigator Supervisor at Public Consulting Group
Breanna TracyBreanna Tracy
Investigator Supervisor/ Contact Tracer Supervisor at Public Consulting GroupInvestigator Supervisor/ Contact Tracer Supervisor at Public Consulting Group
Alexandra DardatiAlexandra Dardati
Health Recruiter at Public Consulting GroupHealth Recruiter at Public Consulting Group
Sharon CarpenterSharon Carpenter
Sales Assitant at Four SeasonsSales Assitant at Four Seasons