Dennis Layman
Business Intelligence Analyst @Medical Mutual
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Analyst @Medical Mutual
Designed and implemented an ODBC database that drives monthly reporting, calculating data metrics for brokers and improving reporting accuracy and efficiency.Leveraged SQL in SSMS and Databricks (with Copilot integration) to extract, transform, and analyze data for internal performance reporting and segmentation analysis.Built robotic process automations (UiPath) to streamline recurring reporting tasks, reducing manual effort and improving timeliness.Provided regulatory support by pulling and preparing data for tax reporting and compliance requirements.Developed a centralized SharePoint site to host reports and KPIs, improving accessibility for internal stakeholders.Partnered with cross-functional teams to enhance product reporting, forecasting, and business insights.Produced dashboards and visualizations to support leadership decision-making on specialty products strategy.
EDUCATION
Baldwin Wallace University
Master of Business Administration, Analytics
Cleveland State University
Statistics
Baldwin Wallace University
Bachelor of Arts - BA, Finance and Business Admin.
Baldwin Wallace University
Criminal Justice
ABOUT DENNIS LAYMAN
Financial Planning & Analysis (FP & A)- Budgeting, Forecasting & Variance Analysis- CAPEX Planning, Depreciation & Fixed-Asset Analytics- ROI / Business Case Modeling- Profitability & Cost Analysis- Executive Reporting & Financial Dashboards- KPI Framework Design & Performance Management- Advanced Excel (Power Query/Power Pivot, complex models, macros/VBA-style automation)- Power BI (Dashboards, DAX, Report Builder / paginated reporting)- SQL (querying, data validation, performance reporting datasets)- Python for analytics automation (data transformation/validation workflows)- Databricks (notebook-based analytics workflows)- Data Modeling & Data Quality Controls- Data Transformation (ETL-style workflow design)- Automation / RPA (UiPath)- Stakeholder Management & Executive Presentations- Cross-functional Partnership (Finance, Ops, Product/Business Leaders)- Process Improvement & Continuous Improvement
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.