Brian Erlich Email & Phone Number

Grand Rapids, Michigan, Us

West Palm Beach, Florida, Us

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

Mclean, Va, Us

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

Atlanta, Georgia, Us

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.

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

St Louis, Mo 63141, Mo, Us

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 Teach Microsoft Business Intelligence tools including Sql Server Integration Services, Sql Server Analysis Services, Sql Server Reporting services, Performance Point, and Sharepoint.Server.

St Louis, Missouri, Us

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

St Louis, Missouri, Us

• 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.

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.

Portage, Michigan, Us

Business Intelligence and database consulting services and design

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

The company provided Insurance medical exams and Occupation medical exams such as Drug and DNA testing.My role included IT responsibilitiesDesigning and managing the company websiteManaging the SQL Server 2000 DTS packages and databaseWriting and managing custom software applications for the companyManaged company network and exchange serverFinancial responsibilitiesManaged company books using Quick BooksMonitored payables and receivablesManaged company payrollAdministered company 401k planAdministered company health insurance planOther responsibilitiesTrained employeesPart of the hiring teamPart of the customer service team

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 AssociationTreasurer of the Michigan Pay Telephone Association

Bachelor, Information Technology

Education record

Finance And Marketing