Greater Minneapolis-St. Paul Area
Creative data-driven analyst discovering actionable insights in big data Mike is a resourceful data analyst adept at communicating with geographically dispersed cross-functional teams. Develops collaborative relationships and facilitates decision making with business partners, customers, technology teams, senior management and vendors by mining insight in complex data. Known for creative problem solving, keen analytical thinking, strong organization skills, curiosity, comfort with change, and staying calm in tough situations with tight deadlines Specialties: • Business Intelligence (BI) and Data Analytics • Customer first focus • Data Visualization and presentation • Project Management methodology and tools • Judicious use of resources • Issue resolution and progress tracking • Agile and Waterfall development processes • Statistical analysis and trends • Business Intelligence applications (Alteryx, Tableau, Power BI, GCP/Big Query, Looker, SAP) • Project Management applications (MS Project, Open Plan, JIRA) • Microsoft Office applications (Excel, PowerPoint, Word, SharePoint, Teams, VBA/Macros)
Public Sector: Supported a state government initiative to optimize the deployment of Contact Center AI (CCAI). - Developed custom reporting metrics and built a monitoring dashboard to provide actionable insights into CCAI performance and usage. Health Care: Contributed to the development team designing a new inventory management tool for a major healthcare provider. - Built a robust data pipeline validation tool and infrastructure for continuous monitoring and data quality assurance. - Developed a comprehensive QA program, including detailed documentation and test cases, to ensure consistent system performance. Health Care: Development team creating new inventory management tool for major healthcare provider. - Built data pipeline validation tool and monitoring infrastructure. - Developed QA program, including all documentation and test cases Health Insurance: Partnered with the Medicaid Operations team to fulfill ad hoc reporting requests, troubleshoot data issues, and automate manual data and reporting processes, while mentoring team members. - Built and validated a local semantic data source to streamline data queries and reduce retrieval costs in Snowflake. Developed a new semantic model from a legacy algorithm, customized via an automated Alteryx workflow to increase team capability and independence. - Designed and implemented an automated QA process to verify data consistency with daily state update files, reducing costly errors. - Created a multi-sheet dashboard for the Chief Medical Officer, providing insights into program effectiveness across demographics and geographies for internal and external stakeholders. Analytical Tools: Alteryx, Tableau, Looker, GCP, Snowflake, Oracle.
Work with business and technology partners to deliver custom and standardized analytical solutions and enterprise-wide data driven insight to simplify business decisions. • Partnered with technical team moving from Data Warehouse to AWS Data Lake. Collaborated to ensure business requirements were defined and end-user information expectations were designed in. Led business team through load testing and User Acceptance Testing in half scheduled time. • Consolidated validation workflows into an automated tool scanning millions of rows of data to identify non-compliance with business rules. Designed a dashboard for insight to prioritize troubleshooting and root cause investigation turning a day long task into a 10-minute process. • Saved 80 hrs/mo by challenging and automating contract deliverable financial workflows. • Guided new users through data migration to a common SAP platform and mentored with knowledge sharing, built new business analytics tools, and coached to self-service. • Delivered a data universe giving Enterprise-wide insight to Annual Contract Value by analyzing business rules/requirements, working with developers, testing, resolving technical defects and business issues, and training new users.
Developed and operationalized new centralized Disaster Response program • Established vendor management program for contract compliance, funding requests, vendor management, stakeholder communications, and financial oversight ($3.5M annual spend). • Built asset management database and metrics program decreasing monthly processing by 10 hrs/mo. • Saved over $1.0M first year by devising and implementing a new generator strategy. • Created new processes and tools enhancing group knowledge base and became common department desktop assets saving 30 hrs/mo.
Managed Compliance Risk process improvement and Operational Risk reporting system projects. • Analyzed business need, built, tested, and delivered compliance database and improved process decreasing monthly process time by 75%. • Organized business intelligence project to construct first ever Line of Business reporting dashboard, metrics, and Executive Team briefings by combining data from multiple operational systems. • Created new metric trending tool decreasing senior leadership review time from 1 hour to 5 minutes.
Managed project cost, schedule, and scope objectives; provided project direction of direct and matrixed staff ($48 million combined budget). • Assumed responsibility when it was evident a subcontractor was not able to manage a key milestone on schedule; led new subcontractor project plan and execution leading to completion by critical schedule date. • Planned, executed, and documented $1M full scale tests including over 100 test points. • Improved program purchasing process reduced rapid development lead times by 2 months. • Succeeded in improving program visibility into government subcontractor's cost and schedule reporting resulting in three Earned Value Management audits passed without action items. • Spearheaded a new test program allowing safe operation of advance cannons. Accomplished effort 30% under budget and created new procedures resulting in 15% greater performance.