Manage and develop data warehouse integration solutions using TSQL, SSIS, Azure Data Factory in a hybrid on prem/cloud database environment. Integrations include CRM Dynamics 365, client/vendor order and product data, and building/maintaining an operational data store with master data management. Data warehousing for ODS consists of building type 2 history tables with repeatable dynamic patterns for easy build and quick turnaround times on any needed data.

Build and maintain extensive data warehouse consisting of ODS, MDM, and BRL layers.

• Write/Update/Maintain T-SQL scripts used for marking campaigns.• Build reports for marketing analysis.• Schedule data extraction and delivery through SSIS packages.• Build SSIS packages to load data from various external sources.• Automate marketing campaigns using T-SQL and SSIS.• Build reports for daily delivery to marketing department.• Write stored procedures to automate redundant marketing tasks and allow for easier data management.

• Database development for all Brandwise Websites/ Web Applications• Manage databases for all Brandwise clients. • Develop custom reports for customer and internal needs. Includes development of stored procedures and well as building the reports in SSRS from Data Warehouses.• Build data integration/transformation stored procedures for client data.• Create custom order extraction procedures to accommodate a variety of formats, including fixed width, EDI, and XML.• Member of the PDT team for Agile Process. Identify and fix bugs in code for any high priority items, as well as, creating rubrics for Product Owners on non-emergency issues.• Manage and develop SQL Server Jobs, Maintain Server Performance, Create Roles and other DBA tasks.• Develop new code to help automate redundant tasks and improve efficiency.

Work with clients to implement software solutions based upon their business needs.Perform SQL based data conversions to integrate with Brandwise software.Responsible for performing detailed audits of converted client data and software functionality. Perform project management duties to adhere to strict implementation deadlines.Conduct remote and on-site client training, including travel to trade shows for on-site software support.Document and report software bugs for new products. Work with QA, development, and data departments to resolve issues.Act as a mediary between clients and the company for client needs outside of contract scope.Work with clients and development team on future software enhancements.

Extensive load balance and production server monitoring.Provided support for customers, engineers, and geospatial analysts.Extensive data management, including encoding different file types, metadata creation, and data backups.QA/QC of both products and imagery.Troubleshooting of hardware and software issues. Identified solutions independently in the moment, avoiding production delays.Technical writing, including creation of training, SOP, and ITAR documents.Responsible for comprehensive training of new hires.