Madelyn Dunlap Email & Phone Number

Denver, Co, Us

Bellevue, Wa, Us

Salt Lake City, Utah, Us

-- Lead a high-performing global data team responsible for the entire BI data stack - data pipelines,enterprise data warehouse, reporting suite (Power BI), and strategic analysis-- Oversee the accelerated build and continued maintenance of the enterprise data warehouse(4TB, with 70+ integrated source systems, spanning finance, operations, sales, marketing, andecommerce data) to maintain data integrity and support complex querying capabilities forbusiness intelligence applications across the 13 different portfolio brands-- Spearhead the development and maintenance of a comprehensive reporting suite, providing keystakeholders with intuitive dashboards and visualizations that enable informed decision-making(rolled out first organization-wide reporting suite, growing to over 100 users in less than 3months)-- Collaborate with cross-functional teams to identify key business questions and provide data-driven recommendations that support omni-channel growth initiatives-- Develop and implement a comprehensive BI strategy that aligns with company goals, enhancingdata accessibility and usability for stakeholders at all levels-- Foster a culture of data literacy, conducting training sessions and workshops to empower teammembers and stakeholders to leverage data effectively

Westminster, Colorado, Us

--Learn and understand client data warehouse model in order to perform ETL process on largedata sets--Requirement gather, design, build, and deploy project-specific relational databases (productionenvironments)--Perform exploratory analysis to understand existing data and relevance to project--Develop multifaceted damage models, damage calculations, and sensitivity analysis--Write reports to present data-derived insights to non-technical audiences

Westminster, Co, Us

--Responsible for identifying, implementing, and maintaining business-critical software includingCRM, file sharing portal, and Learning Management System (LMS)--Led the business development team with data-driven strategies for marketing, sales, andcustomer service in Business-to-Consumer (B2C) and Business-to-Business (B2B) markets--Grew and mentored a high-performance team operating in an agile workflow; training andcollaborating with an international network of professional consultants--Strategically prioritized development roadmap, with a focus on steadily delivering iterativecustomer value--Developed and delivered presentations to business executives across the globe--Embraced strong learning agility with a relentless desire for continuous improvement andcontinued education - incorporated the newest ideas, technologies, and approaches to business

--Researched and acquired (ETL) data to support class litigation (i.e. property records, tax records,property owner information)--Designed, developed, validated, and launched case-specific relational databases and underlyingdata models for ongoing maintenance of class data--Combined the querying and analyzing of class data with strategic thinking to define and evaluateactionable opportunities--Produced reports to present data-derived insights to non-technical audiences, including datavisualization

Seattle, Washington, Us

--Managed 10-20 projects simultaneously, each with their own stakeholders, requirements, anddeadlines; responsible for project oversight, data management, and data visualization reportdesign and presentation--Responsible for processing of project data, ETL, data cleansing, data integrity, and data quality--Co-led the design, development, validation, and implementation of a proprietary relationaldatabase for handling the wage withholding and tax filing process, relevant in employmentlitigation; replaced a manual process, saving 40+ hours of work on each project--Developed and implemented multifaceted, project-specific benefit calculations in MS Access SQL--Interacted with and maintained relationships with CAA's external clients--Interacted with internal project teams to design innovative solutions and resolve challenges--Designed, developed, and maintained proprietary CRM system to support marketing efforts

Westminster, Co, Us

--Directed operations department of 15 – 20 people, responsible for hiring, mentoring, managing,and leading staff in inbound/outbound mail center, call center, and claims processing teams--Oversaw 50 to 75 projects simultaneously, each with their own stakeholders, requirements, anddeadlines; responsible for project management, staff management, and resource management--Led multi-year initiative to standardize processes, improve efficiency and accuracy, and increaseautomation; recognized as the subject matter expert on operational procedures--Represented department to internal and external clients--Developed and documented project-specific procedures and training to effectuate claimsprocesses at 100% accuracy

Westminster, Co, Us

--Managed 15-25 active projects simultaneously, each with their own stakeholders, requirements,and deadlines; responsible for claims processing, workflow, and team supervision--Assisted in project process design, document drafts, document review, and database design--Identified and communicated project issues, along with suggested solutions, to management--Performed quality assurance functions--Mentored and trained 3-5 associates at a time

Master'S Degree, Decision Science/Business Analytics

Bachelor'S, Finance And Economics

Bachelor'S, Finance And Economics