Mick Wagner Email & Phone Number

Seattle, Washington, United States

Advanced Analytics Capability lead responsible for defining future practice capabilities, go to market offerings, strategy, delivery quality assurance, delivering complex projects, enabling client outcomes, and developing the organization.Leadership• Defined analytics offerings and developed practice capabilities• 35 person, 4 tier organization• Member of Consulting Leadership team• Focused on building and maintaining practice culture of trust and ownershipSales• Delivery sales lead for all analytics projects• Opened several new strategic accounts• Responsible for over $3.7M in sales and over $2M in pipeline development• Designed and built all analytics proposal collateralDelivery• Led the highest risk, most technically challenging technology projects• Provided QA on high risk projects and new accounts• Focused on strategy, providing subject matter expertise, and architecture support for new programs in SaaS, education and healthcare

Greater Seattle Area

Advanced Analytics Practice lead responsible for defining future BI capabilities, developing the organization, strategy, quality assurance, and delivering complex projects.Leadership• Defined analytics offerings and developed practice capabilities• 30 person, 4 tier organization • Member of Consulting Leadership team• Focused on building and maintaining practice culture of trust and ownershipSales• Delivery sales lead for all analytics projects• Opened 4 new strategic accounts• Responsible for $2.2M in sales• Designed and built all analytics proposal collateralDelivery• Led the highest risk, most technically challenging technology projects• Provided QA on high risk projects• Focused on strategy, providing subject matter expertise, and architecture support for new BI programs in education and healthcareTechnical Project Manager & Data Engineer at Global Health Foundation:• Solution Manager for custom 3-tier open source intervention evaluation tool • Solution included a custom web app to input complex data, modeling, and a custom visualization layer to drive decision making for future intervention investments.• Provided QA, project management, and client management for a 13-person team implementing a highly complex solution with evolving requirements.• Coordinated dev, analyst and UI/UX teams in an agile environment to consistently deliver value-added releases and identify risks early.• Worked with stakeholders in defining solution and ensuring valuable analytics.Analytics SME for nationally ranked medical school:• Enabled a holistic view of student, educator and program performance via a new, robust reporting data warehouse • Responsible for architecture design and development of data model, database, and coaching client’s team on BI best Practices

Seattle, Wa

Data Platform Lead Consultant at Fortune 100 software company:• Successfully combined finance and marketing data to provide data insights on SSaS consumption via Excel data pack reports.• Lead consultant on data warehouse automation platform that enabled meta-data based ETL framework and dynamic star schema creation after processing billions of records nightly• Data platform separated engineering and data modeling process with deep business integration via dynamic data modeling • Designed engineering features and managed engineering team. • Created statistical checkpoints for data loading to ensure high integrity and confidence in the data load each day. • Provided final code reviews of all engineering changes and supported coding of new features. • Owned all new data source onboarding and data modeling. Successfully onboarded 9 datasets (SQL Server databases and OLAP cubes) to meet a critical client milestone date. • Defined tasks for TFS and performed task estimates.• Created script and email template for daily status of the load. Data Platform Lead Manager at Fortune 100 software company:• Technical Lead for new data platform to support urgent business need to analyze finance and marketing operations. • Architected ETL system to allow for easy restartability with a focus on high quality data via automated quality testing and stopgaps. • System allowed for easy onboarding and the ability to scale the work across a large number of developers. • Managed team of 3 developers, 1 analyst, and 1 PM. • Created custom logging to track reliability of loads that synced with a staging system’s logs. • Responsible for code quality across all stored procedures and ETL. • System efficiently onboarded 15+ data sources with conformed dimensions. • Managed two additional team members on in same client business group but different project.

Greater Seattle Area

BI Deep Triage at regional insurance brokerage• Supported BI team by troubleshooting SSIS (2000, 2005) ETL packages, stored procedures, Access databases and Crystal Reports. • Managed and owned the core solution. • Successfully balanced internal politics, limited internal resources, and vague problem descriptions in a complex software system. • Implemented reporting data quality fixes: reconciled revenue and commissions to repair confidence, enhanced and repaired Access database, led testing efforts on several source system migrations, and created Excel tools for testing. • After 4 months of an internal stalemate, successfully migrated new subsidiaries’ data and reports in less than a month. • Created requirements for ETL logic to support migrations and business changes. Developed business scenarios for reports and solution definition after migrations. Performance Analytics at Fortune 100 software company• Created a prototype BI reporting solution combining engineering and operations data from source code repositories, code review tools and HR data sets. • Prototype OLAP cubes answered the Top 30 Questions from engineering managers. • Created a Developer Productivity Dashboard utilizing statistical charts to compare an individual’s relative performance for annual calibrations. • Turned high level guidelines into technical requirements and a gap analysis. • Designed, architected, and implemented data warehouse, multi-tenant data store, analytic views, and complex OLAP cubes. • Evolved role into a consultative BI SME offering design advice to all workstreams of the team (DW, SSIS, SSAS, and metrics). • Worked in an agile environment (daily sprint meetings, post mortems, backlog planning, burndown reports, resource allocation, code reviews and midpoint checks). • Transitioned responsibilities to new FTE team via 8 deep dive, technical video brownbag sessions and hands on training / design sessions covering SSIS, SSAS, and data modeling.

Seattle, Wa

Marketing Analytics at Fortune 100 Software company: • Created BI solution to analyze effect of customer contact touches on revenue for the global marketing group.• Gathered requirements and wrote business scenarios around calculations and dashboards. • Designed and maintained nine SQL Server OLAP cubes and fifteen Excel dashboards. • Streamlined previous solution’s SSIS ETL and SSAS cube architecture to perform more efficiently and accurately. ETL was optimized to work with complex and large enterprise data systems. Monthly data refresh time decreased by 50%. • Led the successful transition to a new SharePoint reporting portal and new vendor.Analytics & Reporting at healthcare analytics company: • Created a BI solution to monitor and compare home health agency’s hospitalization and emergent care data. • Gathered requirements for the data warehouse and report. • Designed and built the ETL package and stored procedures for initial population of the data warehouse. • Designed and created SQL Server SSAS OLAP solution including advanced MDX for repeatable statistical calculations. • Created an SSRS report deployed on a SharePoint portal. • Coached and trained client staff on OLAP databases and BI Best Practices.• Dev team utilized agile methodologies (sprint planning, resource allocation, daily sprint meetings, dedicated UAT team) to successfully manage risk and meet deadline. IT Migration at Fortune 100 software company:• Performed an infrastructure assessment for financing group. Assessment included hardware upgrade recommendations and a migration plan to upgrade to Windows Server 2008 R2 and SQL Server 2008. • Gap analysis of current hardware and SQL code led to heat map upgrade plans. Entire data flow and application dependency was mapped to guide “to be” infrastructure and migration plan. Gathered requirements for new infrastructure plan. • Re-purposed existing servers following Business Intelligence data warehouse best practices.

Michael worked on 4 projects analyzing data to support class action litigation for a global telecom company. During these projects he used his SQL Server 2005 and Oracle 9.i knowledge to perform analysis and reporting. Michael’s innovative ideas have helped save his client millions of dollars. His relationship management skills were vital in expediting the data collection process and ensuring success. Michael’s hard work and diligence led to the team exceeding client expectations for every deadline. Michael was part of a team that developed Business Intelligence Solutions with a global fortune 100 software company. Michael showcased his diverse knowledge and skills in the Microsoft BI stack. Michael developed enhancements for his client’s cube and ETL process. He was also the lead report developer for a MOSS Reporting Portal solution.

• Performed management decision analysis on equipment upgrades based on effect on production, flow, and economic feasibility in the sawmill and planar.• Analyzed operation times and arrival rates of goods in the sawmill and planar.