{
  "basics": {
    "name": "Sonni Gunnels",
    "label": "Python Developer",
    "email": "hello@aura.com",
    "website": "https://sonni.dev",
    "summary": "Self-motivated Python developer with 2+ years of intensive learning experience, \n        transitioning from EHS compliance to software development. Demonstrated technical growth through \n        progressive projects including this portfolio site, data analysis applications, and web development. \n        Brings analytical thinking, problem-solving skills, and attention to detail from compliance background. \n        Ready to contribute technical abilities while continuing to learn in a professional environment.",
    "location": {
      "city": "Raleigh",
      "region": "North Carolina",
      "countryCode": "US"
    },
    "profiles": [
      {
        "network": "GitHub",
        "url": "https://github.com/sonni-dev",
        "username": "@sonni-dev"
      },
      {
        "network": "LinkedIn",
        "url": "https://linkedin.com/in/sonni-gunnels",
        "username": "@sonni-gunnels"
      }
    ]
  },
  "work": [
    {
      "company": "White Cap",
      "position": "EHS Product Compliance",
      "startDate": "2022-05",
      "endDate": null,
      "summary": "Building and maintaining data systems for EHS compliance across a national distribution network of 400+ branch locations.\r\n\r\n\u25b8 Designed and built a VOC compliance data pipeline replacing a manual Excel/macro workflow \u2014 engineered a relational data model with automated ETL via Power Query, dependent validation dropdowns, automated zip-code-to-air-district lookups, and dynamic restricted org list generation. Reduced a multi-hour manual process to a single query refresh.\r\n\r\n\u25b8 Built a VOC Audit Tool that replaced repetitive recorded macros with automated Power Query steps \u2014 pulls the latest ISR export, evaluates compliance across all stocked SKUs, and surfaces violations requiring action.\r\n\r\n\u25b8 Managed EHS data migration for Oracle ERP conversions across multiple acquired companies, cleaning and validating datasets of 50\u20132,200+ SKUs with 50\u201360 EHS attributes per record including hazmat shipping, VOC restrictions, fire code, SDS, and Prop 65 classifications.\r\n\r\n\u25b8 Built Delta reporting system using Power Query to track incremental changes in EHS dataset over time, enabling data quality monitoring and audit trail generation.\r\n\r\n\u25b8 Contributed to MDM platform rollout (Semarchy) \u2014 collaborated on data model design, field configuration, list-of-values setup, and QA validation testing.\r\n\r\n\u25b8 Rearchitected master EHS dataset with structured data validation, dependent dropdowns, and standardized field definitions, reducing data entry errors and improving downstream reporting reliability.\r\n\r\n\u25b8 Selected as team AI Champion to evaluate and pilot Microsoft Copilot and agent-based automations for department-specific workflows.",
      "highlights": [
        "Oracle",
        "Semarchy (MDM)",
        "Power Query",
        "PowerBI",
        "Python",
        "Agility",
        "Smartsheet",
        "Microsoft 365"
      ]
    },
    {
      "company": "Ram Tool Construction Supply Co",
      "position": "Compliance Analyst",
      "startDate": "2019-12",
      "endDate": "2022-05",
      "summary": "Data-driven compliance and operations analyst supporting executive reporting, fleet management, and company-wide system rollouts.\r\n\r\n\u25b8 Developed KPI metrics and data visualizations for Safety and Transportation metrics, enabling executive teams to identify performance trends and improvement opportunities.\r\n\r\n\u25b8 Led company-wide rollout of SDS data management platform (3E Verisk) \u2014 defined data requirements, coordinated with IT and project management, populated system data, deployed to field locations, and managed ongoing maintenance.\r\n\r\n\u25b8 Designed and implemented COVID-19 data collection and tracking system \u2014 built structured dataset of reported symptoms to identify high-priority symptom patterns and support workforce management decisions.\r\n\r\n\u25b8 Conducted internal compliance audits across HR, Legal, Safety, and Transportation using data-driven gap analysis to identify process improvement opportunities.\r\n\r\n\u25b8 Created and maintained weekly new branch timeline reporting delivered to C-Suite, tracking multi-location expansion projects.",
      "highlights": [
        "SAP",
        "Jira",
        "Excel",
        "Citrix"
      ]
    },
    {
      "company": "ATS Services Inc",
      "position": "Account Manager",
      "startDate": "2017-01",
      "endDate": "2019-12",
      "summary": "Managed 20+ small business accounts while architecting the company's first digital data infrastructure.\r\n\r\n\u25b8 Designed and built a searchable client document database in AirTable, digitizing and cataloging thousands of records across 300+ businesses \u2014 including filings, licenses, permits, owner documentation, and compliance records. Replaced a paper-based filing system with a fully searchable, cross-referenced digital archive.\r\n\r\n\u25b8 Developed a data-driven requirements management process for payroll scheduling and document organization, improving operational efficiency and contributing to 16% YoY revenue growth.\r\n\r\n\u25b8 Managed complex financial data workflows including weekly/monthly payroll processing for ~20 businesses, quarterly payroll tax reporting, and IRS audit support requiring detailed financial record analysis.",
      "highlights": [
        "Airtable",
        "QuickBooks",
        "CrossLink"
      ]
    },
    {
      "company": "ATS Services Inc",
      "position": "Bookkeeper",
      "startDate": "2016-01",
      "endDate": "2017-01",
      "summary": "- Business/Personal Taxes\r\n- Payroll\r\n- Compliance Filing",
      "highlights": [
        "Excel",
        "CrossLink",
        "Quickbooks"
      ]
    }
  ],
  "education": [],
  "skills": [
    {
      "name": "Version Control",
      "level": "Level 5/5",
      "keywords": [
        "Git"
      ]
    },
    {
      "name": "API Design",
      "level": "Level 4/5",
      "keywords": [
        "Python",
        "Django",
        "Flask",
        "FastAPI"
      ]
    },
    {
      "name": "API Integration",
      "level": "Level 4/5",
      "keywords": [
        "FastAPI"
      ]
    },
    {
      "name": "Automation Scripting",
      "level": "Level 4/5",
      "keywords": [
        "Python"
      ]
    },
    {
      "name": "Data Analysis",
      "level": "Level 4/5",
      "keywords": [
        "Pandas",
        "NumPy"
      ]
    },
    {
      "name": "Database Design",
      "level": "Level 4/5",
      "keywords": [
        "PostgreSQL",
        "SQLAlchemy"
      ]
    },
    {
      "name": "Data Visualization",
      "level": "Level 4/5",
      "keywords": []
    },
    {
      "name": "Debugging",
      "level": "Level 4/5",
      "keywords": []
    },
    {
      "name": "Error Handling",
      "level": "Level 4/5",
      "keywords": []
    },
    {
      "name": "Real-time Data Processing",
      "level": "Level 4/5",
      "keywords": []
    },
    {
      "name": "System Architecture",
      "level": "Level 4/5",
      "keywords": [
        "SQLAlchemy"
      ]
    },
    {
      "name": "Web Development",
      "level": "Level 4/5",
      "keywords": []
    },
    {
      "name": "Algorithm Design",
      "level": "Level 3/5",
      "keywords": [
        "Python"
      ]
    },
    {
      "name": "Deployment",
      "level": "Level 3/5",
      "keywords": [
        "Python"
      ]
    },
    {
      "name": "Machine Learning",
      "level": "Level 3/5",
      "keywords": [
        "Keras",
        "TensorFlow"
      ]
    },
    {
      "name": "UI/UX Design",
      "level": "Level 3/5",
      "keywords": []
    },
    {
      "name": "Caching Strategies",
      "level": "Level 2/5",
      "keywords": [
        "Flask-SocketIO"
      ]
    },
    {
      "name": "Cloud Architecture",
      "level": "Level 1/5",
      "keywords": []
    },
    {
      "name": "Documentation",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Code Review",
      "level": "Level 4/5",
      "keywords": [
        "VS Code"
      ]
    },
    {
      "name": "Project Management",
      "level": "Level 3/5",
      "keywords": []
    },
    {
      "name": "Agile Development",
      "level": "Level 2/5",
      "keywords": []
    },
    {
      "name": "Testing Strategy",
      "level": "Level 2/5",
      "keywords": []
    },
    {
      "name": "DevOps Practices",
      "level": "Level 1/5",
      "keywords": []
    },
    {
      "name": "Continuous Learning",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Creative Problem Solving",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Mentoring",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Problem Solving",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Team Collaboration",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Technical Communication",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Time Management",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Environmental Science",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Health & Safety",
      "level": "Level 5/5",
      "keywords": []
    },
    {
      "name": "Regulatory Compliance",
      "level": "Level 5/5",
      "keywords": []
    }
  ],
  "projects": [],
  "meta": {
    "canonical": "https://sonni.dev/resume.json",
    "version": "v1.0.0",
    "lastModified": "2026-04-17T22:22:32.828419",
    "generated_by": "AURA Portfolio System"
  }
}