Michael Klotz Email & Phone Number

Prescott, Wi, Us

San Francisco, California, Us

Hinge Health is pioneering the world's most patient-centered Digital Musculoskeletal (MSK) Clinic. We reduce MSK pain, opioid use, and surgeries by pairing advanced wearable technology with a comprehensive clinical care team, including doctors of physical therapy, physicians, board-certified health coaches, and more. Available to millions of members, Hinge Health is the #1 Digital MSK Clinic for health plans and employers, including Boeing, Salesforce, and US Foods. Hinge Health has raised $436M to date with offices across San Francisco, Austin, Chicago, Denver, Minneapolis, Portland, Seattle and more. We’re hiring! Join us at hingehealth.com/careers

New York, Ny, Us

- Built, administered, and developed custom solutions for multi-terabyte Administrative Data Warehouse using the Microsoft BI/DW stack - Led project to implement standardization and best practices in 200+ data integration processes across multiple ETL tools (Microsoft SSIS, IBM DataStage, and SAP Business Objects) - Established test-driven development practices in the data warehouse via dynamic BIML, PowerShell, and T-SQL solutions to ensure consistency and accuracy - Worked with colleagues from Data Modeling, Enterprise Analytics, HR, and Finance departments to satisfy new requirements during EMR conversion project (Epic) - Provided SSIS packages and Analysis Services processes for heavily custom OLAP solutions - Performed server maintenance, backup and restore services, and disaster recovery activities - Audited database permissions and tuned performance of databases across environments - Created team knowledgebase and contributed documentation for on-call support and development - Developed ETL using SAP Business Objects - Built and installed SQL Server database instances for data warehouse - Audited database permissions and curated optimal database settings across environments

- Provided end-to-end solutions from data discovery to logical data mapping to dimensional modeling and data visualization - Developed custom data extraction scripts to pull data from non-traditional data sources (web services, SharePoint, Active Directory) - Built customer-facing “Ask Mayo Clinic” dashboards and reports using PowerBI - Transformed source data into DataMart structure (Fact/Dimension) for simplified reporting - Consumed data from a variety of sources (Oracle, Active Directory, SQL Server, SharePoint) - Performed in-depth database index analysis and adjusted indexes for better performance - Wrote dynamic, parameterized T-SQL MERGE procedure and other dynamic procedures to reduce code redundancy - Worked with DataMart stakeholders to ensure reports met requirements - Implemented delta/incremental load using Change Data Capture (CDC) and Change Tracking - Developed advanced PowerShell scripts for stored procedure unit testing - Improved logging and auditing of SQL Agent jobs - Created and managed stories, tasks, and estimates for agile project based on end user requirements - Supported data warehouse by writing documentation and participating in 24x7 on-call rotation - Improved logging and auditing of automated processes and SQL Agent jobs

- Reverse-engineered flat files into a nightly-updating relational database to house property information - Wrote C# application to parse, encrypt, and email pay stubs - Vetted and advised selection of 3rd party document management and asset management systems

Toronto, On, Ca

- Built data-access layer for enterprise “artifiact service” platform - Developed and unit tested features and web services for multi-tiered J2EE applications - Executed transition, redesign, and delivery of a Java-based Hierarchy Management application based on Resource Description Framework (RDF) - Created and managed tasks and estimates for user stories and defects during two-week iterations using agile project management software (Version One) - Delivered tech-talks on implementing Git, MongoDB, Gradle, and Sonar - Led migration efforts from TFS VC to Git

Eau Claire, Wi, Us

- Worked closely with DBA team to maintain and support several database platforms including SQL Server (MSSQL), MySQL, Oracle, and Progress (OpenEdge RDBMS) - Created ETL processes using SQL Server’s Integration Services (SSIS) and PowerShell to gather database usage and performance metrics from 6 different database platforms - Designed a MySQL database and wrote an application for the logging of database tasks - Used SQL Server’s Integration Services to run ETL processes that update a Central Reporting Server between 6 different database platforms - Wrote SSRS reports and integrated them into PHP database logging application - Used ER-Win to model changes and additions to database structure

- Sustained and organized company-wide user maintenance requests in over 20 pieces of software (including Active Directory and security rights for all programs) - Worked with software suppliers to troubleshoot configuration and core processing issues - Created documentation and reference material for computer operating procedures and software maintenance routines for AS/400 mainframe

- Learned to run an AS/400 program with minimum prior experience - Utilized Microsoft Server 2007 to operate server tasks - Learned tech support to help people with computer problems over the phone - Helped tellers solve computer-related problems remotely using Symantec PC Anywhere as an aid - Gained financial knowledge and skills in crunching numbers - Learned how to troubleshoot by contacting the software supplier (ITI) and following their instructions to solve problems on our end of the system

Masters Of Science In Data Science, Data Science

Bachelor'S Degree, Business Administration; Information Systems With A Systems Development