Mariah Smith
Jacksonville,FL
Summary
Computer Science graduate with hands-on experience in enterprise data environments at DTE Energy and General Motors. Proven ability to analyze large operational datasets, build and maintain production Power BI dashboards, and support data-driven decision-making across claims and warranty operations. Skilled in SQL, Excel, Power BI, SAP, and CRM systems with a strong focus on reporting, process improvement, and business insights.
Overview
6
6
years of professional experience
Work History
Claims Analyst (Data & Reporting Focus)
DTE Energy
03.2025 - 02.2026
- Owned and maintained 3 production Power BI dashboards actively used by claims operations teams for tracking performance metrics, claims trends, and workflow visibility
- Analyzed large claims datasets to identify operational trends, issues, and process improvement opportunities
- Built and maintained reporting tools using Power BI, Excel, and CSV-based data sources
- Managed ticket queues and assigned requests to appropriate support teams to ensure timely resolution
- Utilized SQL, SAP, and CRM systems for data extraction, validation, and reporting workflows
- Collaborated with cross-functional teams to improve data accuracy and operational efficiency
- Ensured data integrity by reviewing, cleaning, and validating claims records
Warranty Analyst
General Motors
02.2024 - 01.2025
- Analyzed warranty claim data to ensure compliance and reduce operational losses
- Generated recurring reports supporting business decision-making and performance tracking
- Identified trends in warranty claims to support process improvement initiatives
- Maintained accurate documentation for auditing and reporting purposes
- Collaborated with internal teams to resolve system and data-related issues
- Supported data-driven decisions through structured analysis of warranty datasets
Call Center Representative
Proctor Loan Protector
10.2023 - 01.2024
- Responded to customer inquiries with empathy, addressing needs and providing effective solutions while maintaining high quality service standards.
- Managed challenging customer interactions calmly, fostering trust through personalized conversations and active listening.
- Efficiently handled high call volumes, consistently meeting performance goals and call center metrics in a fast-paced environment.
- Executed payment procedures for customers.
Student Intern
DTE Energy
06.2020 - 06.2023
- Built interactive Power BI dashboards to support claims and operational reporting
- Assisted in supervising ticket queues and routing issues to appropriate teams
- Researched claims and incident data to support resolution efforts
- Performed data entry, validation, and Excel-based dataset transformation (CSV files)
- Maintained confidentiality of sensitive customer and operational data
- Supported CRM and SAP-based workflows for claims processing and reporting
Education
Master of Science - Data Science
University of Phoenix
Tempe, AZ11.2027
Bachelor of Science (B.S.) - Computer Science
Central State University
Wilberforce, OH05.2023
Skills
Data & Analytics: SQL, Power BI, Tableau, Excel (Pivot Tables, VLOOKUP, Data Cleaning), Data Visualization, Reporting, KPI Dashboards
Systems: SAP, CRM Platforms, Ticketing Systems, Enterprise Data Tools
Technical: Data Analysis, Dashboard Development, Data Cleaning, CSV Processing
IT & Foundations: Linux, Windows, Networking Fundamentals (TCP/IP), Troubleshooting
Programming: SQL, HTML, JavaScript, C
Strengths: Process Improvement, Documentation, Operational Support, Stakeholder Collaboration
Labs and Projects
Power BI Dashboards
- Designed interactive dashboards analyzing claims and warranty data.
- Created visual reports to track trends, performance metrics, and operational KPIs.
TryHackMe Labs
- Hands-on practice with Linux file systems, networking concepts, and basic cybersecurity tasks.
- Worked with command line, file permissions, and threat identification exercises.
Google IT Support Labs
- Completed labs covering troubleshooting, operating systems, networking, and IT support concepts.
Timeline
Claims Analyst (Data & Reporting Focus)
DTE Energy
03.2025 - 02.2026
Warranty Analyst
General Motors
02.2024 - 01.2025
Call Center Representative
Proctor Loan Protector
10.2023 - 01.2024
Student Intern
DTE Energy
06.2020 - 06.2023
Bachelor of Science (B.S.) - Computer Science
Central State University
Master of Science - Data Science
University of Phoenix