Morgan Ellis
Tableau Developer
Chicago, Illinois, United States | morgan.ellis@example.com | +1-312-555-0146
Summary
Tableau Developer with six years of experience turning operational and financial data into dashboards for business decision-making. Combines SQL development, Tableau performance tuning, and stakeholder discovery to deliver reliable reporting for distribution and logistics teams.
Experience
Tableau DeveloperFeb 2023 – Present
Alderway Distribution, Chicago, IL
Develop and maintain 18 Tableau dashboards covering inventory availability, order fulfillment, and gross margin for approximately 140 operations and finance users.
Reduced median dashboard load time from 14 seconds to 6 seconds by optimizing SQL, simplifying calculations, and replacing unnecessary live connections with scheduled extracts.
Partner with finance and warehouse leads to define shared metrics, document calculation logic, and reconcile dashboard totals against source reports before release.
Implemented region-based row-level security using an entitlement table and Tableau user functions, validating access with business owners before publishing.
Replaced weekly spreadsheet consolidation with a scheduled Tableau reporting workflow, saving the operations team approximately eight hours of preparation each week.
Business Intelligence AnalystJul 2020 – Jan 2023
Cedarline Freight Services, Chicago, IL
Built Tableau dashboards for shipment punctuality, carrier costs, and customer service exceptions using SQL Server data from transportation and billing systems.
Created SQL views that standardized shipment status and delivery timestamps, giving analysts a consistent source for weekly service-level reporting.
Introduced reconciliation queries and documented test cases that caught duplicate shipment records and missing delivery events before dashboard publication.
Led dashboard walkthroughs for dispatch supervisors and revised filters, tooltips, and drill-down paths based on their daily exception-management needs.
Consolidated nine recurring reports into four interactive dashboards, reducing duplicate reporting while retaining customer-specific service views.
Projects
Distribution Dashboard StandardsAug 2024 – Nov 2024
Tableau Developer
Internal workbook template and review checklist used to standardize dashboard development at Alderway Distribution.
Technologies: Tableau Desktop, Tableau Server, SQL
Created reusable navigation, filter layouts, metric definitions, and accessible color conventions to make dashboards easier to interpret across departments.
Piloted the template on three dashboards and documented publishing, permission testing, and performance checks for subsequent releases.
Skills
Tableau Development: Tableau Desktop, Tableau Server, Level of detail expressions, Table calculations, Parameters and dashboard actions, Extract scheduling, Row-level security, Performance recording
Data and Reporting: SQL, SQL Server, Snowflake, SQL query optimization, Data modeling, Data reconciliation, Excel
Delivery Practices: Requirements discovery, Metric definition, Dashboard usability testing, User acceptance testing, Technical documentation, User training
Education
Bachelor of Science, Information and Decision SciencesAug 2016 – May 2020
University of Illinois Chicago, Chicago, IL
Completed coursework in database management, business analytics, statistics, and systems analysis.