John Palmer
Boston,MA
Summary
Detail-oriented team player with strong communicative and organizational skills, and a proven track record of transforming business goals in a collaborative way, while efficiently handling multiple projects simultaneously with a high degree of accuracy.
Overview
5
5
years of professional experience
1
1
Certification
Work History
Junior Data Analyst
Connelly Partners
05.2022 - Current
- Using Supermetrics to seamlessly gather data from our various databases and vendors, and used Big Query to transfer this data into our warehouse.
- Streamlined reporting processes by automating routine tasks using Python.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Continually updated professional knowledge through participation in relevant training programs, workshops, and conferences, ensuring adherence to best practices within the field of data analytics.
- Utilized predictive modeling techniques to provide forecasts on future business trends, guiding strategic planning efforts.
- Identified patterns and trends in large data sets and provided actionable insights.
- Supported decision-making processes by conducting ad-hoc analyses based on specific business questions and objectives.
- Mitigated potential risks by proactively identifying inconsistencies or errors within datasets, addressing issues before they impacted project outcomes or timelines.
Data Analyst Intern
Connelly Partners
09.2021 - 05.2022
- Develop queries and dashboards using client data for tracking customer preferences and emerging markets
- Conducted thorough data validation and cleanup, ensuring accuracy and reliability of datasets used for analysis.
- Monitored and controlled data upload, checking for successful data import and quality.
- Explored new data sources to enhance current models.
- Utilized predictive modeling techniques to provide forecasts on future business trends, guiding strategic planning efforts.
- Used modeling and analytics to understand how business decisions impacted bottom line.
Assistant Site Supervisor
The Valle Group
12.2020 - 05.2022
- Ensure OSHA implemented safety measures are in place before work begins on the jobsite
- Sustained cleanliness standards at job sites while adhering to company policies regarding waste disposal procedures.
- Provided support during emergency situations at construction sites involving accidents or natural disasters.
- Improved on-site safety with regular inspections, identifying potential hazards and taking corrective action.
Intern / Integrated Behavioral Health Program
Boston Children’s Health Physician’s
05.2020 - 07.2021
- Developed spreadsheets and charts for purpose of tracking patient visits and forecasting budget expenses
- Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.
- Sorted and organized files, spreadsheets, and reports.
- Gained hands-on experience in various software programs, increasing proficiency and expanding technical skill set.
- Prepared project presentations and reports to assist senior staff.
Marketing Intern
Hyannis Harbor Hawks (Cape Cod Baseball League)
06.2019 - 08.2019
- Create ads for the team’s video board using Animaker
- Assisted in creating written, video, and image content for marketing channels.
- Researched interesting and relevant content to capture interest and improve site traffic.
- Supported sales team by creating promotional materials for client presentations.
- Conducted market research to identify target audiences and optimize marketing efforts.
Education
Bachelor of Science - Big Data and Business Analytics
Sawyer Business School Honors Program, Suffolk University
05.2022
Skills
- Python
- R Studio
- Supermetrics
- Tableau
- SPSS Statistics
- SAP
- SAP Predictive Analysis
- Business Explorer
- Query Designer
- Lumira Discovery Designer
- Microsoft Word
- Excel
- PowerPoint
- Access
Certification
- Microsoft Excel Certified
- HubSpot Certified
- Google Analytics Certified
Relatedcourses
- Data and Decision Analysis
- Business Analytics
- Big Data, BI and Analytics
- Data Privacy and Compliance
- Marketing Analytics
- Management Information Systems
- Operations Management
- Business Research Methods
- Leadership Practicum
Projects
Suffolk University: Data Privacy and Compliance, Spring '21, Completed an analysis on the efficiency and accuracy of the Information Systems and Security for Boston Children’s Health Physicians Suffolk University: Big Data, BI and Analytics, Spring '21, Tasked with completing various benchmarks using SAP and Business Explorer to develop and report on the different types of Business Intelligence data structures Suffolk University: Marketing Automation, Fall '20, Used SPSS Statistics and SQL develop a relevant dataset to find the chances of a team winning the World Series
Timeline
Junior Data Analyst
Connelly Partners
05.2022 - Current
Data Analyst Intern
Connelly Partners
09.2021 - 05.2022
Assistant Site Supervisor
The Valle Group
12.2020 - 05.2022
Intern / Integrated Behavioral Health Program
Boston Children’s Health Physician’s
05.2020 - 07.2021
Marketing Intern
Hyannis Harbor Hawks (Cape Cod Baseball League)
06.2019 - 08.2019
Bachelor of Science - Big Data and Business Analytics
Sawyer Business School Honors Program, Suffolk University
Similar Profiles
Lee JunkinLee Junkin
Platform Media Supervisor at Connelly PartnersPlatform Media Supervisor at Connelly Partners
Eric RunnelsEric Runnels
Concrete Mixer Driver at Connelly Ready MixConcrete Mixer Driver at Connelly Ready Mix
Annie GoldsteinAnnie Goldstein
Litigation Associate at Rock Fusco & Connelly, LLCLitigation Associate at Rock Fusco & Connelly, LLC
Margaret MarinoMargaret Marino
Advanced Family Nurse Practitioner at Massachusetts General HospitalAdvanced Family Nurse Practitioner at Massachusetts General Hospital
Ahmed ElmekkawyAhmed Elmekkawy
Assistant Director of Security at Allied UniversalAssistant Director of Security at Allied Universal