Deep expertise in Transact-SQL, SSIS, SSRS, SSAS, and database administration across enterprise environments at Ecolab, Cenex Harvest States, Bluestem Brands, Marketing Architects, and RBC Dain.
Architect and developer of a datamart referred to as Commitment Engine. This application calculates technician scheduled customer visits based on a number of sophisticated factors. The process is driven via an MS 2012 SSIS package for which I worked as the architect, business analyst, developer and production support resource. Customer Value Dashboard reports customer interaction developed in SSRS.
Creation of SmartPower reporting as part of the Executive Business Reports (EBR) dashboard. The reports are developed in SSRS and are formatted in such a way that the reports can be elegantly exported to MS PowerPoint and used for client presentations. The reports developed for EBR are related to washer performance metric reporting.
Developer of SSRS reports used to show distributor reselling of Ecolab products in both the US and Canada. The hierarchical reports show multiple performance graphs, rolling 24 over months and can be drilled for detail data.
Development of SSRS reports replacing Access Database VBA applications. The new SSRS reports are capable of exporting to MS Excel the same as the Access VBA output.
Cenex Harvest States, Inc.2014–2016
Architect and developer of Terminal Position Automation Datamart providing a reporting environment for propane shipment and consumption for the entire midwest. Datamart is 100% automated to provide business representatives with a clear propane inventory view and calculated future shipment and lift.
Development of ETL to pull vendor agriculture data into the enterprise data warehouse. SSIS packages developed to populate 8 dimension tables and 4 fact tables.
Development of an SSAS cube reflecting daily agriculture commodity position reporting. SSIS packages populate the dimension and fact tables daily, along with cube processing each night.
Development of SSIS ETL as well as SSRS reports with the credit processing group. Maintenance MVC coding for business and client credit card processing applications.
Bluestem Brands, Inc.2011–2014
Architect / Developer in the design and development of multiple collections applications. Conversion from CoreIssue to First Data credit platform. Applications developed in SQL Server SSIS 2008, primarily delivering XML messages across MSMQ connections. Applications for Sold Accounts, Payment Processing, Welcome Call, Remove from Dialer, Promise To Pay were developed for the First Data integration.
Architect of a SOX Compliance audit solution. Designed an application, data modeled a solution for auditors to review batch processes in relation to SOX compliance standards. The solution pulls all batch process results to a central audit database via SSIS packages. Batch processes which fail, abort are disabled or rescheduled log data and open HP Service Management incident tickets.
Developer converting numerous DTS packages to SSIS during migration from SQL Server 2005 to 2008.
Marketing Architects, Inc.2008–2011
Lead developer in the MediaGuide spot detection application. This SQL Server SSIS solution processes radio airings provided each day by MediaGuide and matches those airings to customer calls and orders, creating records directly in Marketing Architects CRM solution.
Developer of Transact-SQL for Planning and Performance application, joining CRM and station airing data into a daily refreshed aggregated view of data for media planning.
Developer of numerous reports in both SSRS 2005 and 2008, supported by Transact-SQL stored procedures. Created reports for Station Pricing, Credit Card Reprocessing, Order Drop Off, Spot Download and Creative/Network/Script/Offer Intersection reports.
RBC Dain, Inc.2007
Architect and Development lead commissioned to re-architect a highly visible executive level datamart within the RBC Dain Market Research group. The Data Mart supports 7 subject areas, centered around a client account, branching out to household and financial consultant. Each subject area supports aggregation, slowly changing dimensions, support of history in metric tables and full surrogate key structure.
Developer working on a Firstlogic (now owned by Business Objects) household application performing address correction and account consolidation based on name, address, phone and social security number.