Christopher Carleton-Smith
Seattle, WA 98103 |-|-
Skills
•
•
•
Tool kit: Advanced Excel, Google Sheets (Pivot Tables, VLookup, advanced formulas), Tableau
Programming: SQL (MySQL, PostgreSQL), Python (Jupyter Notebooks, Machine Learning w/ Scikit-Learn, NumPy,
Pandas, Matplotlib, Seaborn),
Languages: English, Spanish (native)
Work Experience
Procore
Business Data Analyst
Oct 2024 – December 2024
Seattle, Washington
•
Compiled, cleaned and analyzed large datasets from 50+ teams across the company to assist stakeholders with
decision-making and the creation of their 2025 Annual Operating Plan
•
Collaborated with my Enablement colleagues to streamline Google Sheet dashboards by creating visualizations,
integrating data from multiple sources and facilitating communications and meetings with other teams
•
Implementing advanced formulas in Google Sheets to automate calculations and data retrieval, which resulted in
reducing Annual Operating Plan preparation time by 40%
Meta
Data Analyst
Jun 2022 – Oct 2023
Seattle, Washington
•
Developed and maintained Google Sheets and Tableau dashboards to track and visualize KPIs, call center metrics,
sales, and WFM (Workforce Management) data for the Small Business Sales Group (SBG)
•
Led weekly meetings with regional managers and call center vendors to evaluate KPI, call and sales performance,
assess SME headcount, check Meta’s CRM and align on future operational plans
•
Utilized SQL (frequently) or Python to extract ad hoc data and Excel or Tableau to create and present weekly
performance reports or dashboards for global call centers and WFO managers
•
Created KPI’s that helped identify specific call types that were not being addressed, reducing missed or late calls by
70% and improving call center performance
Amazon
Business Analyst
Jul 2021 – Dec 2021
Seattle, Washington
•
Extracted and analyzed data from AWS Redshift databases using SQL and loaded it onto AWS QuickSight dashboards
to support recruiting research
•
Administered and presented data in QuickSight dashboards that facilitated decision-making for Human Resources and
PAIR (People Analytics, Innovation and Research) Talent Acquisition leaders.
•
Conducted ad hoc data analysis using Agile/Scrum practices to support needs of the recruiting and PAIR TA teams as
we sought to increase the volume and quality of hiring for our business teams.
Sigma SAFI
Data Analyst
Nov 2019 – Jul 2021
Lima, Peru
•
Pioneered a statistical Client Risk-Scoring model using linear regression and a Foreign Exchange Risk model. Both
models were made in Excel using financial, accounting and qualitative data.
•
Presented data-driven financial findings and models to C-Suite and Board members. The Client Risk-Scoring model
was well-received and added to their main client-screening report and helped saved the company time and money
Education
B.S. Physics – Trinity College
B.S. Mathematics – Trinity College
Data Visualization Portfolio
Tableau: https://public.tableau.com/app/profile/christopher.smith3394
May 2019
May 2019
