Kevin Dageforde Email & Phone Number

Denver, CO, US

Berlin, Berlin, DE

Lead a team of Analytics Engineers in building and promoting a self-service analytical layer of the data warehouse, and creating dashboards that identify actionable insights with North America Marketing.

Berlin, Berlin, DE

• Partnered with business stakeholders to understand and document reporting requirements, then developed intuitive, actionable reports and dashboards that allowed the business to understand their data and make informed.
• Site administrator of Tableau Server, responsible for designing architecture and security of server, developing enterprise data sources for use across the organization.
• Designed data warehouse architecture by analyzing source system (QNXT, MedImpact, EPIC) data models and consulting with business stakeholders.
• Developed ETL using SSIS and stored procedures that generate dynamic SQL from source-target mappings to perform ETL into the data warehouse.
• Collaborated with company vendors in the design and coding of automated extracts to support business processes, regulatory audits, and interfaces between company systems.
• Responsible for oversight and code review of team, provided helpful and tactful feedback to help team grow and learn and ensure a consistent and high-quality work product.

Seattle, Washington, US

• Designed, developed, and maintained front-end and relational back-end MS Access databases responsible for managing and organizing class member information.
• Cultivated relationships with clients as a project manager.
• Communicated with and work alongside Operations Department to ensure a high quality work product and development of efficient processes.
• Created and refined proprietary internal databases to handle specialized aspects of settlement administration and company processes.
• Developed SQL queries to retrieve data used for reporting purposes and performing complex calculations.
• Reviewed settlement notice documents for quality and consistency; recommend alternations to streamline and improve the administration of the settlement.

• Created framework for assessing initial exposure to potential class action lawsuits.
• Developed specialized damage models for estimating financial damages and calculating individual damages and benefits.
• Worked with a team to analyze data related to class certification, settlement manageability, and allocation methodology.