Mark Settergren

Franklin, TN

linkedin.com/in/marksettergren

Professional Summary

Analytical and results-driven data professional with 28+ years of experience in automotive fixed operations (aftersales – parts and service) and a strong foundation in data analytics. Adept at transforming complex datasets into actionable insights using SQL, Python, VBA, Excel, and Power BI. Currently completing a Bachelor's degree in Data Analytics with a strong emphasis on real-world application, visualization, and automation. Skilled in solving business problems, optimizing workflows, and communicating technical findings across teams.

Core Skills

• Data Analysis: SQL, Excel (Advanced), Python, VBA, Access
• BI & Visualization: Tableau, Power BI (in progress)
• Systems: SAP BusinessObjects, NMPS, G2B, MPS, FAST2000, Salesforce
• Automotive Fixed Operations: Parts, Service, Warranty, Cataloging, Inventory
• Tools & Automation: AutoHotKey, Visual Basic, Custom Reporting Dashboards
• Web Development: HTML, CSS, JavaScript, PHP

Professional Experience

Senior Planner, Parts Planning and Establishment

Nissan North America – Franklin, TN | Feb 2016 – Present

• Develop and maintain precise service parts catalogs across vehicle platforms, directly supporting aftersales operations.
• Leverage SQL, Excel, and VBA to create analytical tools and reports for catalog quality control and operational insight.
• Collaborate with engineering, service, and marketing teams to enhance catalog usability and dealer satisfaction.
• Identify and communicate data inconsistencies, including pricing or part application errors, for resolution.
• Recently completed Tableau coursework and actively developing Power BI dashboards to enhance internal reporting.

Parts and Labor Research Analyst

Reynolds and Reynolds – Tampa, FL | Feb 2014 – Feb 2016

• Conducted in-depth parts and labor data research for OEM clients (Ford, GM) with strong focus on data accuracy.
• Built automation tools using AutoHotKey and Excel to streamline cross-platform data entry and reporting.
• Applied SQL to validate records, troubleshoot issues, and deliver clean, actionable datasets.

Parts & Service Management and Technical Roles

Bergstrom Automotive – WI | 1998 – 2013

• Managed fixed operations departments with a focus on budget control, service efficiency, inventory accuracy, and customer retention.
• Implemented departmental reporting tools to support profitability tracking and sales growth.
• Supported cross-location IT coordination and technical systems support across fixed ops teams.

Certifications & Education

• Certified AWS Cloud Practitioner
• Certified CompTIA Data+
• Bachelor of Science – Data Analytics (Expected May 2025)
  Western Governors University
• Associate Degree – Automotive Technology
  Fox Valley Technical College | Graduated with Honors, GM-ASEP Program

Additional Information

• Strong understanding of Docker, Linux, cloud-based systems, and cross-platform integration.
• Creator of Twitch-based chatbot with real-time chat parsing and stat tracking using Python and SQLite.
• Passionate about uncovering insights, automating inefficiencies, and helping businesses make better data-driven decisions.

Web design by Mark Settergren