Jeff Swanner Email & Phone Number

Keller, Tx, Us

Dallas-Fort Worth Metroplex

Team leader and Senior Data Engineer for the Audiences Value Stream at Simpli.fi

Dallas/Fort Worth Area

I was leader of the development team responsible for creating, enhancing, and supporting all internal & customer-facing reports and data sets for our enterprise data collection software product named "Cognistix".Developed complex integration solutions for our customers.Developed internal and customer-facing reporting solutions necessary for payroll processing.I also was a consultant to third-parties, repairing and enhancing their data warehouses, ETLs, and payroll systems.Part of my role at Systemsmith also utilized my background as an Enterprise Data Architect:- Successfully implemented a new dashboard platform into our product.- Was responsible for comparing available mapping technologies; creating proof-of-concept projects to identify which of the platforms met our use-case; then selected the most appropriate mapping technology to be developed into our product.

Irving, Tx - (Still At Mosaic Location)

I was working in the same location in the same office with the same team; but Mosaic was acquired by Acosta in June 2012 and I was promoted to Enterprise Data Architect.-- Define the strategy and principles for data management across the enterprise.-- Determine what technologies are most appropriate for most efficiently supporting existing and future data needs.-- This role is intended to provide standards for naming conventions and data-process governance as well as identify the best-practices for storing, moving, transforming and delivering all data across the enterprise.

Irving, Tx

-- Design, build, enhance and support BI data structures and processes for client-facing reports, financial reports, internal organizational management and performance monitoring of IT systems.-- Successfully launched, enhanced and supported Client Data Warehouse that currently supports over 100 Analysis Services cubes being updated every two hours.-- Launched an Enterprise Data Store that enables multiple source systems to contribute to the aforementioned Client Data Warehouse as well as our Operations Data Warehouse that supports our internal reporting needs for complex analysis of store-visit execution. This Operations Data Warehouse also supports internal ad hoc reporting for the payroll data of tens-of-thousands of field reps across the US and Canada.-- Successfully integrated multiple source systems to uniformly populate the Enterprise Data Store in a manner that would seamlessly flow into existing custom and ad hoc reports.

Irving, Tx

The role of the BI Technical Lead position is to create and maintain all sources that provide Mosaic's Business Intelligence Reports with data. This would include creation and support of :-- Numerous client-facing and internal management SSAS Cube solutions.-- BI-related ETL's using SSIS, C# and VB .Net and DTS (on legacy sources).-- Creation of Financial Data Warehouse reading directly from JD Edwards source data.-- Creation of custom SQL reporting solutions; simplifying the data contained within extremely complex structures into something easily analyzed by end users.

Advanced SQL engineer and online analytics tool programmer. I specialize in ETL optimization; implementing SQL data-warehousing strategies to increase process performance and create dynamic SQL tools which troubleshoot existing process performance and replace redundant code.My other areas of experience include (in order of experience):ASPMDXDSOC#.Netvarious scripting languages such as ruby, php and javascript.XML

-- In 2005 was part of the the team that designed, built and supported Mosaic's first Enterprise Data Warehouse solution that supported dozens of client-specific data marts. -- Built and supported a wide range of reporting solutions using SQL, classic ASP, Access, Excel.