MARK WALLER
Data Analyst
West Des Moines
Summary
Data Analyst with robust experience in Excel reporting along with Tableau, Python, and Relational Database experience who is currently becoming certified in Power BI. Demonstrated history of detailed analysis and issue resolution. Proven at collaborating with cross-functional teams to drive process improvements and support strategic business decisions.
Overview
27
27
years of professional experience
1
1
Language
Work History
Medical Management Specialist
Elevance Health
08.2019 - 04.2025
- Developed innovative funding tracking for the CHAMP program using advanced Excel techniques, improving leadership reporting efficiency by 20% for housing insecurity initiatives.
- Created daily, weekly, and monthly reports for Physical and Behavioral Health teams by manipulating large datasets in Excel, ensuring 100% compliance with state Service Level Agreements while supporting data-driven decision-making.
- Analysis and Reporting from 834 files.
- Revamped SharePoint site to optimize information retrieval processes, reducing document search times by 30% for over 40 team members.
- Coordinated vendor efforts with Mom's Meals and GA Foods, ensuring timely meal delivery during Public Health Emergency through effective stakeholder communication.
- Streamlined smoking cessation referral processes, enhancing service delivery across health teams by leveraging process improvement methodologies.
Death Claims Specialist
MetLife (via Midwest Professional Staffing)
10.2018 - 10.2019
- Managed complex death claim cases with a focus on data accuracy and detail, achieving 90% productivity and 95% accuracy standards.
- Delivered exceptional customer service by resolving escalations and ensuring adherence to SEC and MetLife guidelines through clear communication and problem-solving.
- Processed claim transactions efficiently using advanced Microsoft Office tools to meet stringent administrative timelines.
Account Manager
bswift
04.2017 - 10.2017
- Oversaw daily operations for four client accounts, achieving 100% on-time delivery for Open enrollment test plans.
- Managed client relationships, executing contract renewals and service requests while serving as the primary escalation point.
- Produced weekly status reports and Visio diagrams, streamlining data flows and process documentation.
- Collaborated with EDI team to maintain and test demographic and benefit election import files.
Benefits Service Consultant
ADP
10.2016 - 03.2017
- Administered Leave Administration services using Total Absence Management (TAM) system, ensuring compliance with FMLA and State Disability Insurance regulations.
- Served as lead escalation point for multiple clients, resolving complex absence management issues.
- Documented process improvements, enhancing service delivery for national and major accounts.
Retirement Plan Specialist
Aon Hewitt
08.2011 - 10.2014
- Implementation of Defined Contribution plans, managing requirements, testing, and client acceptance for 5-6-month projects.
- Automated transactional jobs, saving 110 hours monthly and reducing processing errors by 15%.
- Managed client relationships, payroll reconciliations, and vendor coordination with Financial Engines.
- Trained onshore and offshore teams, developed role procedures, and enhanced proprietary TBA system functionality.
- Provided daily support for plan participants, resolving escalations and improving process documentation.
Benefits Operations Manager
Aon Hewitt
05.2006 - 08.2011
- Robust reporting from evening daily valuation of multiple Fortune 500 clients 401(k) mutual fund/stock fund settlements.
- Daily contact with clients and vendors for complex issue resolution, planning, reporting, and future planning for 401(k) record keeping.
Business Analyst
Hewitt Associates
07.2003 - 05.2006
- Worked daily with client and vendors to provide processing insights for issue resolution.
- Automated transaction jobs, saving 110 hours monthly and reducing processing errors by 15%.
- Provided daily support for plan participants, resolving escalations and improving process documentation.
Processing Analyst
Hewitt Associates
03.2002 - 07.2003
- Worked daily with client and vendors to provide processing insights for issue resolution.
- Automated transaction jobs, saving 110 hours monthly and reducing processing errors by 15%.
- Provided daily support for plan participants, resolving escalations and improving process documentation.
Benefits Representative
Hewitt Associates
10.1998 - 03.2002
- Trained onshore and offshore teams, developed role procedures, and enhanced proprietary TBA system functionality.
- Provided daily support for plan participants, resolving escalations and improving process documentation.
Education
Microsoft Power BI Data Analyst -
Coursera
11-2025
Certificate - Extract, Transform And Load Data in Power BI
Coursera
10-2025
Certificate - Harnessing The Power of Data With Power BI
Coursera
09-2025
Certificate - Preparing Data for Analysis with Microsoft Excel
Coursera
08.2025
Certificate - Python For Data Science, AI & Development
Coursera
07.2025
Bachelor of Science - undefined
Iowa State University
Ames, IA08.1998
Skills
- Microsoft Office
- Sharepoint
- Tableau
- Data Reporting
- HRIS
- Python
- Power BI
- SQL
- Vendor Management
WEBSITE, PORTFOLIO AND PROFILES
- Https://www.linkedin.com/in/mark-waller-data-analyst/
Accomplishments
- Overhauled and managed the Physical Health teams SharePoint site to optimize information retrieval, reducing document search times by 30% for over 40 team members.
- Automated transaction jobs saving 110 hours monthly and reduced processing errors by 15%.
- Provided daily support to clients with over 90% positive ratings.
- Part of multiple teams implementing new clients for defined contributions which utilized my detailed review of requirements and testing to ensure success.
- Used self taught SQL skills to reduce client reporting turn around times by over 15%.
Timeline
Medical Management Specialist
Elevance Health
08.2019 - 04.2025
Death Claims Specialist
MetLife (via Midwest Professional Staffing)
10.2018 - 10.2019
Account Manager
bswift
04.2017 - 10.2017
Benefits Service Consultant
ADP
10.2016 - 03.2017
Retirement Plan Specialist
Aon Hewitt
08.2011 - 10.2014
Benefits Operations Manager
Aon Hewitt
05.2006 - 08.2011
Business Analyst
Hewitt Associates
07.2003 - 05.2006
Processing Analyst
Hewitt Associates
03.2002 - 07.2003
Benefits Representative
Hewitt Associates
10.1998 - 03.2002
Bachelor of Science - undefined
Iowa State University
Microsoft Power BI Data Analyst -
Coursera
Certificate - Extract, Transform And Load Data in Power BI
Coursera
Certificate - Harnessing The Power of Data With Power BI
Coursera
Certificate - Preparing Data for Analysis with Microsoft Excel
Coursera
Certificate - Python For Data Science, AI & Development
Coursera
Similar Profiles
Holly SheltonHolly Shelton
Director of Revenue Cycle Managment at Elevance HealthDirector of Revenue Cycle Managment at Elevance Health
Nicole GametNicole Gamet
Customer Care Representative at Elevance HealthCustomer Care Representative at Elevance Health
Litzy BenitezLitzy Benitez
Pharmacy Technician at Elevance HealthPharmacy Technician at Elevance Health
Caleb FullertonCaleb Fullerton
Police Officer at Indianola Police DepartmentPolice Officer at Indianola Police Department
Sophia MauroSophia Mauro
Seasonal Guest Seasonal at TargetSeasonal Guest Seasonal at Target