Learn Data Skills
Beta

Madison Macaulay

Senior Data Analyst

Guidehouse

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Project

Dr. Semmelweis and the Discovery of Handwashing

My New Track

Data Manipulation

Data whisperer, decoding the language of numbers with finesse.

My Work

Take a look at my latest work.

project

Dr. Semmelweis and the Discovery of Handwashing

Python
course

Data Manipulation with pandas

course

Analyzing Police Activity with pandas

Python
course

Introduction to Python

course

Intermediate Python

My Certifications

These are the industry credentials that I’ve earned.

Other Certificates

Tableau Data Analyst

DataCamp Course Completion

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

My Work Experience

Where I've interned and worked during my career.

Guidehouse | Feb 2024 - Present

Senior Data Analytics Consultant

Build new Python ETL process to ingest data from diverse sources, clean and aggregate the data to provide in depth analysis of nautical charts, bathymetric data, and imagery to ensure data sources are being kept current within agency standards. Create visualizations of data output by ETL pipeline to provide both high-level and in-depth analytics to key stakeholders within NGA using Tableau and ArcGIS. Serve on Geospatial Analytics Community of Practice leadership team promoting GIS training, networking, and proposal initiatives across the company. Conduct extensive research to support bid proposals for government contracts, enhancing proposal quality and contextual understanding.
Show More

Guidehouse | Mar 2023 - Feb 2024

Data Analytics Consultatnt

Redesigned ETL process from outdated, inefficient script utilizing multiple APIs to incorporating direct database access, faster run time, and automated scripting. Launched company-wide GIS Community of Practice. Serving on leadership team promoting GIS training, networking, and proposal initiatives across the company. Developed Python ETL scripts to ingest and clean data from diverse sources, including Excel sheets, PDFs, and Word documents, resulting in complete and usable datasets. Connected Python scripts to AWS to efficiently extract and export data, leveraging S3 buckets for seamless storage and retrieval. Performed data visualization and analytics using Tableau, providing valuable insights to clients. Conducted extensive research to support bid proposals for government contracts, enhancing proposal quality and contextual understanding.

Central Intelligence Agency | May 2021 - Mar 2023

Business Analyst

Led the development of a Key Performance Indicator (KPI) for the Chief Strategy Officer's Strategic Playbook, showcasing progress aligned with the Director's priorities. Analyzed enterprise-wide workforce data to drive insights into workforce well-being, facilitating informed decision-making. Automated a talent management dashboard, reducing manual effort by 10+ hours per week and improving HR analytics efficiency. Implemented project management review processes, utilizing Access database and Tableau dashboard to enhance team performance analysis. Coordinated information exchange with external business analytics organizations, fostering collaboration and knowledge sharing.

Central Intelligence Agency | Jan 2020 - Aug 2020

Digital Data & Innovation Intern

Developed network protocol and encryption software, prioritizing speed improvements for users. Owned high-value bugs on Jira and led code changes to enhance reliability in classified projects within Agile software development team. Led the reorganization of product management practices, optimizing operations within the department. Researched and implemented innovative concepts for masked learning models, expanding project capabilities. Kick-started projects to meet departmental needs, resulting in significant speed improvements and increased information retrieval efficiency.

Disney Parks, Experiences and Products | Aug 2019 - Dec 2019

Digital Product Analyst

Owned feature launches & enhancements for mobile ordering at both DLR & WDW, using Confluence & Jira Oversaw analytics projects to determine how current marketing strategies were supporting mobile ordering KPIs Chartered internal review using analytics determining how a project could have been better & how to improve similar projects in the future Led weekly analytic reviews to monitor performance, weekly and overall

The University of Alabama | Apr 2018 - May 2019

Ambassador to the College of Engineering

Provided 1-hour tours to an average of 50 prospective students per semester Facilitated college fairs and other events that service over 3000 students per event

Deshazo LLC | Aug 2017 - May 2019

Automation Co Op

processes for manufacturing companies all over the US Designed & programmed HMIs for 10+ projects Was project manager for $MM automated crane project for Boeing Implemented major Toyota project, listed below Toyota: Executed 4-person team in implementation of new software to achieve 2D vision automation project Improved client’s manufacturing speed by 35% & met safety standards Authored technical documentation for reprogramming and diagnostics

The University of Alabama | Aug 2017 - Apr 2018

Tutor

Offered academic help to an average of 10 students per week focusing on mathematics, physics, engineering foundations, and computer science

Walt Disney World | Jan 2017 - May 2017

Disney College Program Participant

While working in the Quick Service Food & Beverage industry, I networked with current Disney engineers and took an Engineering Professional Development Seminar. I also had the pleasure of participating in Disney's Ultimate Engineering Experience (DUEE), where I worked as an electrical engineer on a four person engineering team.

The University of Alabama | Oct 2015 - Oct 2016

Avanti

By becoming well acquainted with Capstone academic programs and co- curricular opportunities, the Avanti Team provides essential support in preparing incoming students to meet the challenges of enrollment and in welcoming high school groups to campus for large-scale recruitment events.

My Education

Take a look at my formal education

Master's of Science in Data ScienceEastern University | 2024
Bachelor’s of Science in Computer ScienceThe University of Alabama | 2021

About Me

I have a passion for tech for social good, accessibility, and kindness. I'm searching for data analytics and data scientist positions that allow me to share rich, inspirational stories backed by the data.

Powered by

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