Software Consultant Reporting Analyst

Bruce H. Kutnick

*** **** ********* ****

Mount Prospect, IL 60056

Cell: 224-***-****

E-mail: *********@*****.***

Summary of Experience

SQL Server development experience

Business intelligence and analytics development

Additional experience in application development on Microsoft platforms

Synopsis of Technical Skills

Reporting

Databases

Development

Analytics

Other

SSRS

Crystal Reports

Tableau

SQL

Power BI

SQL Server 2012

SQL Server 2008

SQL Server 2016

T-SQL

DTS/SSIS

VB.NET

XML

OLAP/MDX

SSAS-Dimensional

Multivariate Statistics

R

SPC

SQL Data Mining

Project Management

APICS Certification

Solomon Software

Agile/Scrum

TFS Source Control

Data Quality Service

Syteline Infor

Employment History

Sasser Family Companies Database Reporting Consultant November 2019 to current

Working for multiple vehicle and equipment leasing business units within Sasser, built out SQL data marts and developed management dashboards using Power BI. Provided data management support to two business units within the organization.

MultiPack Solutions SQL Developer/Reporting Analyst February 2018 to October 2019

Developed Sr. Management Scorecards (SSRS), designed and built data marts, created customized application forms/reports and provided assistance in the area of query performance tuning.

BridgeNet Solutions Senior SQL Developer October 2017 to February 2018

Led product selection project for data visualization tool.

Vela Insurance Service Business Intelligence Developer June 2015 to August 2017

Managed the product selection and implementation of a visual analytics platform (Tableau), developing initial key data visualizations (Production Forecast, Broker Scorecards) and serving as initial systems administrator. Converted complex SQL queries/reports as part of a data warehouse conversion project.

Insurance Auto Auctions ETL/SQL Analyst October 2013 to June 2015

Provided SQL database development and support (including a major data warehouse merge), implemented Data Quality Systems (DQS), maintained and developed SSIS packages, modified Analysis Services OLAP cubes and developed SSRS reports on SharePoint 2010 platform.

Restaurant.com Database Reporting Analyst May 2011 to August 2013

Maintained legacy reporting systems (Reporting and Analysis Services) while concurrently creating new reports for the Analytics, Finance, Affiliate Partner and Email teams, focused on process automation and data quality. Created and maintained several ETL packages involving data exchange with vendor partners.

Provided full development and maintenance of SQL Server code (stored procedures, views, query plans and optimization).

AccuQuote Database Reporting Analyst October 2007 to May 2011

Provided database reporting, OLAP, business process automation as well as data mining and high level analytics for the nation’s third largest web based insurance brokerage. Tools utilized include T-SQL, SSRS, MDX\Crystal Analysis, xCelsius, DTS, xlMiner (data mining), Statistica, Omniture (web site analytics) and SSIS.

Gerber Auto Collision & Glass Business Analyst/Developer August 2000 to October 2007

Responsible for the development and maintenance of all operational and financial reporting systems, database applications and business intelligence services, helping the business grow from nine Chicago area locations to the nation’s second largest collision and glass business, with nearly 80 locations nationwide. Key technologies used included T-SQL, Crystal Reports, XML, Analysis Services, Crystal Analysis, VB6 and VB/ASP.NET. Applications developed include a 20 user call center application, a database maintenance application, system integration applets and a glass sales quotation system. Major reporting and analytics initiatives included the creation of company wide KPI reporting metrics, balanced scorecards/dashboards, customized income statements (with transactional drill through) and over one dozen OLAP cubes.

Omnios Consulting Software Consultant September 1999 to June 2000

Provided financial software consulting services to a diversified range of clients in the insurance, manufacturing and service industries. Primary focus of work involved software customization utilizing VBScript, VB and Crystal Reports.

BPS Consulting Software Consultant December 1997 to September 1999

Consultant for Solomon Software (now Microsoft Business Systems) product line, involved in systems implementations, software creation and customization and database report development.

Solomon Software Customization Solutions Support April 1995 to December 1997

Served as technical support analyst in the custom software development group, providing programming support to over 500 VARs and 100 independent software developers on a product that is now part of Microsoft Business Solutions.

Education and Professional Development

Bachelors Degree in Business Administration, Kent State University

Graduate coursework in Economics/Statistics/Econometrics, The Ohio State University

SQL Server Business Intelligence Certification, DePaul University

APICS Certification in Production Management

Additional coursework taken at various community colleges and online learning resources (Lynda.com, Coursera, Statistics.com and Udemy):

ASP.NET

VB.NET

XML

Data Mining

Regression Analysis (Logistic and Linear)

R (Best Fit Analytics class)

Alteryx

Power BI Desktop

DAX and M Code

Contact this candidate