Power Platform Architect
• Interagency Emergency Data Manager (IEDM) Project Architect – IEDM is a custom Dynamics app created to manage housing and support for migrants. As an Architect, I created the integrations platform for the Power Platform Automate, Azure Logic Apps, ( a couple Azure Functions), Power BI (including Power Query to combine Dataverse and Snowflake data) and the exports to Snowflake.• Power Platform usage Apps – created apps for Admin level functions for the Dynamics app. Automate – created supporting flow for the app and approval Azure Logic apps – Used mostly as an orchestration layer Power Pages – Expose functions in the Dynamics App for B2C consumption• Azure Data Factory for Snowflake Integration - Integration with Snowflake to write all data from the IEDM Product (Dataverse) into Snowflake (Data Bridge) Linked Services – Used Snowflake connector to create a service connection to Snowflake Azure Data Flows – Dataflows are used to for the ETL actions then writes into Azure Blob storage as a Parquet as that is the only supported format to create a table in in Snowflake from Azure Azure Blob Storage – Temp Storage of data Azure Pipelines – Used to run actions on a schedule Runs the Data Flow Runs a script that does the create tables/update tables/Update Schemas from the Azure Blob Storage• Snowflake Built Warehouse Built Tables with relationships Built security and roles Built Interfaces• Dynamics 365 Built custom tables Built Tables with relationships Built security and roles including row and column level security Built Business Rules Built Interfaces• Power Pages Built portal site for Dynamics 365 Built portal site for Knowledge Base