Working with clients using Dynamics 365 (D365) Finance and Operations ERP to consolidate data with their old system. Using Fabric and Azure Synapse as a Data Warehouse, data is collated and made available as a data cube for sourcing by PowerBI. Where needed, the Power Platform is utilized to automate and/or make data available for use and updating via apps.Data integration and migration to D365 through Data Management Frame or Azure Data Factory.

Created Azure Synapse Data Warehouse to host Data Platform Solution. Import from Dynamix 365 (D365) data entities on Azure Data Lake to Azure Synapse DW.Import data via Azure Data Factory from an Azure SQL DB that is hosting legacy data. Created Dimension & Fact tables to utilize in Tabular model cube in Azure Analysis Services. Created reports in Power BI with direct data connection and goal of real-time streaming (15 to 30 minute delay after cube refreshes). Using the Power Platform (Power Apps & Power Automate) customer solutions allowing business stakeholders to manage and utilize data.Set up automated data quality checks with email alerts.Created and maintain documentation for data governance.

Created a solution for the data science team to create models for Business Planning and Forecasting.Manage the design, build and maintenance of data for Feature Performance, Market Science and Forecasting teams instrumenting Azure Data Factory pipelines from Azure Data Lake storage (COSMOS) and Analysis Services to Azure SQL DB and Azure SQL DW.Helped set up Databricks environment for Data Science teams. Worked in Python, mostly reading scripts created for quality control.Work with Engineering team to provide technical requirements for data not available in current streams.Administer Azure Virtual Machines, Tabular Cubes, PowerBI Reports and SQL Server Databases.Manage offshore suppliers by providing technical requirements to enable changes to the data pipelines for business requirements provided by the stakeholders.Create App Solutions of tools & automation using Power Apps, Power Automate and Power BI on the Azure Data Platform.

Took a troubled Data Platform with 24-hour daily refreshes & developed it into a World-Class Data Platform Solution with a Marketing Webby award.Led a team of 3 onshore and 10 offshore BI Developers to provide data for marketing operations activities.Successfully managed a variety of migrations including Subscription, Purchase, Xflow and DatagridImproved data architecture cutting refresh times from 24 hours to 3 hours and operational queries in half.Manage on-boarding data for Xbox, Hololens, Windows, Surface, Bing and MSN, Phones from cloud storage (COSMOS) to SQL ServerGrew team from managing 1 data pipline to 4 pipelines without an increase in head count. 3 pipelines were created from scratch.Reduced time spent on maintenance activities of data from 80% to 15% while increasing quality of data dramatically.Met with a variety of stakeholders such as Marketing, Reporting and Operations to understand business needs and gather requirements. And with variety of data sources, Data Sciences and Tools to ensure proper integration.Created a full suite of metrics and alerts to improve data quality and performance.Provided data for online marketing operations, reporting and data science.

Understanding clients needs and utilizing the Microsoft BI stack to deliver upon them.Created custom reports for client in SSRS.Automated complex recurring tasks through SSIS to perform ETL on large sets of data.Performed ad hoc custom analysis to ensure data quality on metrics being provided and data being used for targeting.

On-shore lead for database marketing activities at Xbox.Led a team of 6 offshore database marketing production analysts to produce lists and provide analysis for marketing activities.Drove data quality initiatives and was responsible for finding a variety of show-stopping data issues. Improved processes to better communicate to customers, increase data quality in campaigns and increase speed at which campaigns were built.

Created SSIS packages, OLAP cubes and SSRS/Powerpivot reports for various projects.Created and maintained a daily process measuring marketing and sales of DPE Tools.Pulled data from multiple disparate data sources tracking marketing activities, leads, opportunities, sales and license expirations and renewals.Created an OLAP cube to enable marketing and sales teams to quickly and easily create and refresh reports.Worked in COSMOS/Scope to gather data and provide reports.

Created SSIS packages, OLAP cubes and SSRS/Powerpivot reports for various projects.Created and maintained a daily process measuring marketing and sales of DPE Tools.Pulled data from multiple disparate data sources tracking marketing activities, leads, opportunities, sales and license expirations and renewals.Created an OLAP cube to enable marketing and sales teams to quickly and easily create and refresh reports.Worked in COSMOS/Scope to gather data and provide reports.