Senior Data Analytics Consultant

• Jun 2021 - Present

Lead Software Engineer

• Aug 2019 - Jun 2021

Working with PowerBI and Tabular models to get healthcare data to pharma, so they can cure cancer. Working with PowerBI and Tabular models to get healthcare data to pharma, so they can cure cancer.

Lead Data Analytics Consultant

• Nov 2016 - Aug 2019

I provide end to end SQL Server BI solutions utilizing SSIS, SSAS, SSRS, and Power BI. I provide end to end SQL Server BI solutions utilizing SSIS, SSAS, SSRS, and Power BI.

Senior BI Engineer

• Nov 2015 - Nov 2016

Utilize my skills with TSQL, SSIS, data modeling, and DAX to both improve the performance and usability of the company’s existing SSAS tabular models as well as build new models to meet Kabbage’s growing needs. Utilize my skills with TSQL, SSIS, data modeling, and DAX to both improve the performance and usability of the company’s existing SSAS tabular models as well as build new models to meet Kabbage’s growing needs.

Data Quality Architect

• Feb 2015 - Nov 2015

I assist companies in identifying and monitoring potential data issues by analyzing their current data solutions and implementing data and metadata management best practices. I assist companies in identifying and monitoring potential data issues by analyzing their current data solutions and implementing data and metadata management best practices.

Sr. Solutions Architect

• Mar 2010 - Jan 2015

I provide end to end Business Intelligence services using the Microsoft BI stack. This includes customer service, requirements gathering, Data Warehouse Design, SSIS, SSAS, SSRS, Performance Point services, and user testing. I am currently working with SQL Server 2005 and SQL Server 2008. Perficient merged with Northridge Systems July 1, 2012 I provide end to end Business Intelligence services using the Microsoft BI stack. This includes customer service, requirements gathering, Data Warehouse Design, SSIS, SSAS, SSRS, Performance Point services, and user testing. I am currently working with SQL Server 2005 and SQL Server 2008. Perficient merged with Northridge Systems July 1, 2012

Trainer

• May 2009 - Nov 2012

I Teach Microsoft Business Intelligence tools including Sql Server Integration Services, Sql Server Analysis Services, Sql Server Reporting services, Performance Point, and Sharepoint.Server. I Teach Microsoft Business Intelligence tools including Sql Server Integration Services, Sql Server Analysis Services, Sql Server Reporting services, Performance Point, and Sharepoint.Server.

BI Consultant

• Apr 2010 - Apr 2010

Created SSIS packages to import battery testing data. Created battery testing data report. This is the 3rd time I have been invited back. Created SSIS packages to import battery testing data. Created battery testing data report. This is the 3rd time I have been invited back.

Microsoft BI Consultant

• Dec 2009 - Jan 2010

• Re-designed SSAS cube dimensions and facts • Improved cube performance by a factor of 100 from 7+ minutes to 3+ seconds • Created Named Sets • Trained staff in creation of named sets • Populated Data Mart • Trained staff in use of SSAS • Created DimDate script to meet client need for date dimension • Trained staff in basic use of MDX • Created MDX quality and testing query • Built matrix report around Quality and testing data • Created a C# assembly that when combined with a rowset action allowed drillthrough on calculated members. Concept taken from an article by Mosha Pasumansky • Created 2 calculated measures for standard deviation of defect data • Wrote statement of work for upcoming BI project for purchasing department.

Contract BI Consultant

• Oct 2009 - Dec 2009

Working with CCAC "Community Care Access Center" • Assist customer in OLAP cube design • Installed SQL Server 2008 • Installed SharePoint • Installed Performance Point Server 2007 with SQL Server 2008 • Added KPI’s and Named Sets in SSAS 2008 • Added dimensions and measures in SSAS 2008 • Built Performance Point Dashboard based on Healthcare cube • Trained IT department in use of Performance Point, MDX, SSAS 2008, SSIS 2008, and Dimensional Modeling • Assisted in designing dynamic cube security in SSAS 2008.

BI Consultant

• Oct 2008 - May 2009

Business Intelligence and database consulting services and design Business Intelligence and database consulting services and design

Business intelligence Consultant

• Aug 2008 - Oct 2008

Contract position: Developed reports in SSRS and ProClarity. Maintained SSAS Cube. Wrote stored Procedures in T-SQL Developed ETL process in SSIS to import testing data from CSV files Developed error handling procedures in existing SSIS project Contract position: Developed reports in SSRS and ProClarity. Maintained SSAS Cube. Wrote stored Procedures in T-SQL Developed ETL process in SSIS to import testing data from CSV files Developed error handling procedures in existing SSIS project

IT and Operations Manager

• Jan 1999 - Oct 2006

The company provided Insurance medical exams and Occupation medical exams such as Drug and DNA testing. My role included IT responsibilities Designing and managing the company website Managing the SQL Server 2000 DTS packages and database Writing and managing custom software applications for the company Managed company network and exchange server Financial responsibilities Managed company books using Quick Books Monitored payables and receivables Managed company payroll Administered company 401k plan Administered company health insurance plan Other responsibilities Trained employees Part of the hiring team Part of the customer service team

IT and Operations Manager

• Sep 1991 - Jan 1999

Managed the data that generated call pricing for a route of 1200 pay telephones. Managed the phone programming which determined the phones behavior and the routing of calls. Earned ownership through performance. Found buyer for the company selling it for over 3 million dollars and netting the investors over 1 million dollars. Founding member of the Michigan Pay Telephone Association Treasurer of the Michigan Pay Telephone Association Managed the data that generated call pricing for a route of 1200 pay telephones. Managed the phone programming which determined the phones behavior and the routing of calls. Earned ownership through performance. Found buyer for the company selling it for over 3 million dollars and netting the investors over 1 million dollars. Founding member of the Michigan Pay Telephone Association Treasurer of the Michigan Pay Telephone Association