Data Warehouse Power Bi

Michael Dalton

Portland, OR *****

Cell 612-***-****

********@*******.***

Experience:

Contract Senior BI/Analytics Engineer

Kinetic Group, Anoka, MN

***/** – Present

Analyze and refactor existing Azure Data Factory (pipelines, triggers, linked services, source to target mapping) and Databricks notebooks for manufacturing and consumer data projects. Fix permissions and database connectivity issues, variables, parameters, triggers, and actions. Correct errant Python code in Databricks notebooks. Diagram process flows and identify extraneous objects. Migrate refactored processes to a new environment and version (in GIT) final projects

Create a data governance catalog and document data lineage in Dataedo for the database serving as the enterprise data warehouse for primary organizational BI/analytics. Help to build and contribute to the Master Data Management plan for the BI/Analytics department

Research and refactor code for the existing enterprise data warehouse for final migration from on-site to a cloud-based solution. Utilize Azure DevOps for version control and CI/CD processes

Senior Principal Database Engineer

Virtual Radiologic, Eden Prairie, MN

04/12 – 6/24

Developed Client Analytics dashboard and application in Power BI utilizing Microsoft Fabric (derived from Azure Synapse Analytics, including Azure Data Factory and Databricks). Created notebooks leveraging PySpark (Python) and Spark SQL/DataFrames as well as Delta (Parquet) files extracted from the EDW (Enterprise Data Warehouse) with PowerShell. Created Medallion Architecture within Data Lake for data flow/processing. Accessed external data through connection to AWS/S3. Worked extensively with stakeholders as well as end users

Developed prototypes in Power BI showcasing (1) A heatmap created with Python and integrated with a semantic model created from the EDW and (2) Demonstrating AI visuals (decomposition tree and key influencers) to track events through the QA process based on a variety of factors (study priority, dictation tool usage and provider/facility identification)

Assisted in developing radiologist scheduling Power BI dashboard and application to help with assigning cases/studies to appropriate radiologists based on a variety of criteria

Evaluated ETL/ELT and data integration tools including building a prototype using Snowflake leveraging the EDW with data integration of statistical results from R as well as external data from AWS/S3

Created Enterprise Data Warehouse following a “star” schema with facts (of cases and studies) and dimensions (of radiologist, facility, patient, report type, etc.) with full and incremental loads as well as comprehensive logging of the load process. Met frequently with stakeholders to make sure priorities and needs were met

Created an operational data store from application OLTP databases including RIS, PACS and external systems such as Salesforce for standardized reporting in SSRS (SQL Server Reporting Services) and by the Data Science team for in-depth data analysis

Designed and developed numerous reports and dashboards using Power BI, Tableau, and SSRS, including the Telerad Metrics Report, Hospital Insight Report, rScriptor Usage Report, and Mammo Report

Loaded COVID-19 patient data in an on-premises database and incrementally loaded data to an Azure SQL Database

Integrated Power BI dashboards and reports into SharePoint for company-wide access

Partitioned data for EDW fact tables using a sliding window

Constructed stored procedures and optimized SQL code in SQL Server 2019 to ensure peak performance in a distributed environment by using tools such as Database Performance Analyzer, Query Store, Extended Events, DMVs (Dynamic Management Views), sp_whoisactive, and SQL execution plans

Set up and monitored SQL Server Availability Groups and Distributed Availability Groups

Managed access to SQL Server instances and databases across the organization

Utilized Agile methodology for the development process (using Jira)

Used Perforce and GIT for version control

Used Fisheye/Crucible for the code review process

Developed a multi-year “vRad Analytics Roadmap” for Analytics and Business Intelligence (BI)

Provided best practices and coding standards for database development and maintenance

Managed and mentored three database engineers and one business analyst

Provided coding assistance to less senior members of staff and other members of the engineering team

Submitted and managed Service Now change requests for rolling out production changes

Designed/planned migration to SQL Server 2022

Manager Database Administration / Data Architect

Boston Scientific, Arden Hills, MN

07/09 – 3/12

Managed/led primary Database Administration Team (15 DBAs)

Provided Data Architect assistance for SQL Server and Oracle (resolving database issues such as substandard performance for both OLTP and OLAP systems, broken replication synchronization, inaccurate storage allocation and database corruption)

Collaborated with application teams and project managers to provide architecture and design for both transactional and multidimensional database systems

Worked with SQL Server SSIS, SSRS, SSAS and replication as well as standard SQL Server 2005/2008 R2 database functionality

Mentored junior staff in database design and development techniques, project management, and managing relationships with application teams

Worked with application teams to guide database project execution, resolve any outstanding issues, and guarantee the meeting of the Service Level Agreement (SLA)

Provided project management for DBA activities, including resource allocation, task delineation, timelines, and cost calculation

Developed “Three Year Roadmap” for database support and development, including technology selection and service offerings

Created documentation as needed to support database administration, database standards, and best practices

Defined and executed strategic initiatives for the DBA Team including formalizing the project intake process, cost containment of vendor maintenance agreements and designing a model for centralization of DBA and database developer activities

Monitored and maintained metrics on DBA team performance (includes database uptime, processed Remedy tickets, database license growth, disk space management, etc.)

Senior Software Engineer

Boston Scientific, Maple Grove, MN

11/06 – 06/09

Provided design and programming for database management systems (transactional, reporting (SSRS), and multidimensional (SSAS)), including BSC’s Sterling, APEX, EPIC, and MDMS databases

Built prototype data mart and constructed and populated cubes in SSAS 2005 (primarily for “scrap” analysis). Designed reports with Microsoft Excel add-in for Analysis Services

Designed SSRS reports, including summaries of operational run data (Batch Summaries and Device History Records)

Wrote validation SQL Scripts for the updating and inserting of equipment application information, including ''recipes''

Created extensive documentation required by BSC’s Software Quality System, including software requirements, design, risk analysis, and testing documents

Developed a multi-system messaging infrastructure for Manufacturing Execution System (MES) to various control applications using WebSphere MQ

Wrote custom adapters in C# for MES to communicate directly with MQ message queues

Education:

University of Texas-Pan American, Bachelor of Business Administration (BBA)

Major - Computer Information Systems, Graduated Cum Laude

San Jose State University, Secondary Teaching Credential - Business and Computer Science

Additional Training:

Zero to Snowflake

Microsoft Azure Fundamentals

Microsoft Azure AI Fundamentals

Get Started with Lakehouses in Microsoft Fabric

Use Data Factory Pipelines in Microsoft Fabric

Designing a Semantic Model in Power BI

Microsoft BI Experience – Power BI Training

Mastering Data Warehousing – DecisionWorks (Ralph Kimball/Margy Ross)

Contact this candidate