ABIGAIL JOHNSON
Buford
Summary
Insight-driven analytics professional with experience turning high-volume logistics and business datasets into dashboards and operational improvements. Skilled in SQL, Excel, Power BI, Tableau, and Python (Pandas, NumPy) with a strong focus on data accuracy, anomaly detection, and KPI reporting. Background in business intelligence, data operations, and platform analytics supports roles across analytics, reporting, and data-driven decision making.
Overview
5
5
years of professional experience
Work History
Data Analyst
FX Logistics
02.2025 - Current
- Increased USPS shipment tracking compliance from 60% to 90% by standardizing data validation workflows in Excel and SQL, reducing missing tracking events by 45%.
- Built executive KPI dashboards in Power BI and Tableau, cutting manual reporting time for leadership by 35%.
- Monitored 1,000+ weekly deliveries using SQL aggregations to evaluate KPIs, identifying delays that reduced late deliveries by 20%.
- Diagnosed 50+ monthly tracking anomalies through geofence and ping trend analysis, improving system data accuracy by 25%.
- Acted as platform subject matter expert, translating tracking datasets into workflow improvements that increased resolution efficiency by 30%.
Student Assistant
Lewis College of Nursing and Health Professions
10.2022 - 03.2024
- Audited and maintained 100+ student and faculty records, reducing dataset discrepancies by 40%.
- Compiled weekly and monthly operational reports in Excel, supporting planning for 4+ department leads.
- Corrected inconsistent entries and implemented structured formatting, improving internal record reliability by 25%.
Personal Assistant
Walmart
06.2021 - 08.2021
- Processed 100+ orders per shift using handheld fulfillment systems, maintaining 98% accuracy in high-volume operations.
- Coordinated order batching across 15+ associates, reducing handoff delays by 15% during peak throughput.
- Tracked and reported daily order fulfillment metrics, identifying workflow bottlenecks and improving team efficiency.
Education
Master of Science - Computer Science
GEORGIA INSTITUTE OF TECHNOLOGY
Atlanta05-2027
Bachelor of Science - Computer Science
GEORGIA STATE UNIVERSITY
Atlanta05.2024
Skills
Data Analysis: SQL (Joins, Aggregations, Window Functions), Excel (PivotTables, XLOOKUP, Power Query)
Business Intelligence & Visualization: Power BI, Tableau, Dashboard Design, DAX, KPI & Executive Reporting
Data Processing & Pipelines: Python (Pandas, NumPy), Data Cleaning, ETL Support, Anomaly Detection, Data Validation
Platforms & Databases: FourKites (Geofence Configuration, Ping/Tracking Analysis, Compliance Metrics), MySQL, Query Optimization
Projects
Customer Transaction Analysis
- Identified purchasing trends across 1,000+ customer transactions by analyzing data with Python and Pandas, improving campaign targeting efficiency by 15%.
- Reduced dataset inconsistencies by 30% by implementing automated data cleaning and validation workflows.
- Generated an analytical report defining 5 key customer segments, enabling data-informed strategy recommendations for business decision making.
Database Management System
- Designed a 15-table MySQL database by applying normalization and indexing, reducing query processing time by 40%.
- Improved data retrieval efficiency by 25% by writing optimized SQL joins and aggregation queries for multi-table analytics.
- Strengthened database integrity by enforcing constraints and schema validation, preventing invalid entries and improving query reliability.
BI Dashboard Delivery
- Developed Power BI and Tableau KPI dashboards by integrating structured logistics datasets, improving reporting clarity and reducing manual compilation time by 35%.
- Designed anomaly tracking visuals that improved insight delivery speed for operations review by 30%.
- Automated metric calculations using DAX, decreasing formula build time by 20% while improving visualization accuracy.
Timeline
Data Analyst
FX Logistics
02.2025 - Current
Student Assistant
Lewis College of Nursing and Health Professions
10.2022 - 03.2024
Personal Assistant
Walmart
06.2021 - 08.2021
Bachelor of Science - Computer Science
GEORGIA STATE UNIVERSITY
Master of Science - Computer Science
GEORGIA INSTITUTE OF TECHNOLOGY