Michael Gore

Cloud Data Engineer for State of Idaho Controller's Office

TEKsystems•  September 2023 - August 2024•  Boise, ID

Client has migrated to an Infor Cloudsuite ERP solution with WFM, FSM, and HR modules from which they replicate data to an Ion Datalake. Replication payload is copied to an S3 bucket, followed by a 2-stage warehousing procedure, and finally integrated into Cognos Reporting solution. Responsible for end-to-end pipeline builds, SQL Server stored procedure, python, and powershell script writing, Cognos FM (Function Manager) administration. Revised existing operational workflows to conform to vendor guidelines. Refactored ETL framework code for optimization, observability and fault tolerance.

Cloud Data Engineer for POWER Engineers

TEKsystems•  January 2023 - August 2023•  Coeur Du Lane, ID

Facilitated client’s data-driven success by providing expert guidance in migrating and optimizing data integration pipeline workflows to Azure Data Factory. Leveraged Azure Data and Analytics services, Azure DevOps, and CI/CD architecture principles to streamline operations and enhance efficiency. Demonstrated the feasibility of Microsoft Fabric as the client’s future Data and Analytics solution by replicating an existing production data integration workflow that utilizes Azure Data Factory pipelines, Dataverse Synapse Link, ADLS storage, Dynamics Data Management Framework to import data from Dynamics F&O/HR, and Power Apps CE entities into an Azure SQL Database.

Senior Data Engineer

ASGN (Apex Systems)•  December 2019 - September 2021

A member of the Professional Services Data and Analytics Team, responsible for advising clients interested in leveraging Azure cloud products to improve data driven decision making: from erecting new state-of-the-art data capture strategies with visualizations to modernizing existing solutions. • Data Quality: Profile inbound data for value duplication, record completeness, format adherence, and schema compliance. Enforce data integrity through control processes and transformation logic i.e. phone number and date format validation, pipeline run watermarking, creation and modification time stamps.

Senior Data Integration Engineer

Medisolv, Inc•  November 2018 - October 2019

A member of the Data Integration team, whose task it is to develop automated, reliable and scalable means for collecting client data; and to convert existing customer pipelines to the new, platform and format-agnostic, ETL solution. Interact with customers and management to deliver progress appraisals, to acquire mission-critical information and to present findings. • Data Integration: Employ tools like Azure SQL, Azure Data Factory and Spark/DataBricks to create end-to-end data pipelines, within an Agile environment, for the purpose collecting, cleansing and processing client data prior to being archived in Medisolv’s cloud based datawarhousing solution for use in its catalog of web-based SaaS offerings geared towards quality management for small and midsized healthcare providers. • DevOps: Develop Python and SQL based software tools, or snippets, to more effectively monitor process outcomes and enable procedure status tracking. For use within the Data Integration Team.

Senior IT Engineer

New York Presbyterian Hospital•  April 2014 - November 2018

Member of the Technical Operations team and principal technologist in business planning initiatives. Leveraged software engineering and project management expertise towards supporting NYP’s clinical and administrative application ecosystem. Interfaced with stakeholders to present findings and recommend resolutions. Identified and rectified deviations in technical operations and resource usage as established by accepted enterprise standards and Federal regulatory standards. Designed innovative solutions to automate tasks like ETL processes, administrative system routines, and reporting. Software engineering and SQL query design.

Revenue Cycle Systems Analyst

New York Presbyterian Hospital•  February 2012 - April 2014

Principal strategist, technologist and steward for all applications with any impact on the clinical revenue cycle and associated data artifacts. Provided 24hr, end to end, on-call support for all pre-, peri- and post-administrative system offerings. Conceptualized and implemented project use and support documentation. Guided internal stakeholders and vendors in the integration and operation of new and complex technologies. SQL query writing, data analysis and management.

Arizona State University, Tempe

Electrical Engineering, BS•  September 1999 - May 2003

Specializations in Signal Processing and Control Systems