Jackson Brown Email & Phone Number

Newton, New Jersey, Us

Architected a star schema for the warehousing of ecommerce, ERP and web traffic related data within Azure Synapse Analytics.Developed ADF pipelines and Logic Apps to bring financial, product, ecommerce and Google Analytics data together within Azure Synapse Data Warehouse.Maintained, supported and enhanced existing data pipelines from on-premises systems to Azure Data Lake to the financial\operations Data Warehouse.Created, maintained and enhanced Power BI datasets for end use report creation.Created outbound data integrations from Azure Data Lake to third party software vendors with Azure Data Bricks

Greenville, South Carolina, Us

Developed\Implemented a star schema data warehouse for operational reporting and analytical data models with data ingestion pipelines for MES related data. Created Power BI Dashboards\Reports for managerial and executive level members of the organization.

Spartanburg, Sc, Us

Architect (logical and physical) data warehouse models within SQL Server 2016 and SQL AzureDeveloped ETL packages (SSIS and ADF) to populate POS data into data warehouseCreated scripts (Python, TSQL and PowerShell) to facilitate the ingestion of data from various sources.Developed Python scripts to produce data visualizations for QA and validation purposes.Provided technical documentation pertaining to ETL packages, data flows and data integration and warehouse design.

Asheville, Nc, Us

Responsible for designing and implementing business intelligence solutions to enable the analysis of data to support strategic initiatives and ongoing business requirementsPreform needs analysis and architect integrated end-to-end solutions, design, configuration and implementation of data warehouses, business intelligence applications, and underlying relational databases.Develop data warehouse and business intelligence solutions using MS Business Intelligence tools and underlying technologiesParticipate in identification, development and implementation of enterprise master data management strategies and processesCreated data analytic models using Python and T-SQL

Piedmont, South Carolina, Us

Designed and developed back-end database solutions (MS SQL Server 2005\2008R2\2012) using stored procedures, views, UDFs, CTEs and triggers to provide data access to internally developed front end software solutions.Architected and designed Business Intelligence solution using SSAS (2008R2), SSRS (Report Builder 2.0/3.0, Business Intelligence Studio 2008/2012), MDX and MS Excel.Responsible for the development of SSIS (2008R2\2012) packages to facilitate ETL between data systems\ applications within the organization and with vendors. Also created web based APIs for data delivery (GET) and data intake (PUT) using .NET Web Services.Responsible for the management of all 3rd party and in house databases (SQL Server, Oracle and MS Access) this includes backups, restores, disaster recovery solution, data replication, data integration (SSIS, .NET Windows Services) and performance tuning.Lead a small team of developers to create front end applications (SharePoint 2010/13 custom Web Parts, ASP.Net, WPF, JavaScript\JQuery, HTML) using the .NET Framework (C# 3.0 – 4.0) to facilitate the collection, distribution, recruitment and retention of blood donorsConducted code reviews and created\maintained SDDs (Software Design Documents).

Piedmont, South Carolina, Us

Designed\Developed back-end database solutions using SQL Server 2005\2008\2008R2 (tables, views, stored procedures, triggers, UDFs and DB Mail) with the T-SQL language.Created Business Intelligence solutions\dashboards using SSAS (2008R2), SSRS (Report Builder 2.0 and Business Intelligence Studio 2008), MS Excel, SharePoint 2010 Performance Point and SharePoint 2010. Integrated multiple Database typologies (MS SQL Server, Oracle, MS Access, XML and Flat Files) using SSIS.Designed\Developed front-end applications using the .NET(C#) framework (ASP.Net, WIN Forms, SharePoint 2007\2010) and HTML.Developed application layer (business logic) using Web Services (.NET, C#).

Mortsel, Be

Developed the FDA recall EDM system and electronic notification system using .NET(C#) Win forms, Web Services and Windows Services to facilitate the processing, retrieval and updating of data pertaining to healthcare equipment recalls mandated by the FDA.Created interactive dashboards with ASP.NET\C# 2.0 (Visual Studio 2005) to provide management with timely and accurate information pertaining to equipment recalls.Developed Web Services (C# Visual Studio 2005) to facilitate the integration of data to and from the recall EDM\notification system with 3rd party database back-ends.