Matthew Lutz

732-***-****

aczesc@r.postjobfree.com

OBJECTIVE

Through the use of programming languages, workflow and visualization tools, create dynamic analytic information to be used to improve the organization

EXPERIENCE

Data Analyst, CVS Specialty Pharmacy

Denver, CO – March 2016 – November 2016

Wrote Analytic and ETL, R programming scripts that contributed to a $6 million conversion of unbillable revenue, in 3 months, advanced from MS Access SQL queries using SELECT, SELECT DISTINCT, JOINS, & case statements

Preprocessed Environmental Control data using RegEx to identify sample locations; producing 8% for manual entry

Produced highly interactive Tableau maps & dashboards for environmental control data to assist in dissecting branch cleanliness to avoid shutdowns and product recall

Developed Alteryx workflow to dynamically connect data to Tableau dashboard for live data connection

Analyst - Contract, Innocor

Eatontown, NJ – March 2015 – April 2015

Created a VBA macro that automated & formatted trial balances; condensing a week long procedure during close to a few minute process, including variance analysis

Analyzed data with regression in Excel to forecast for coming month, quarter, and fiscal year; preprocessing data with VLOOKUP, SUMIF, INDEXMATCH, and more advanced functions with Excel

Project Accountant / Analyst, Hunter Boot

New York, NY – August 2014 – December 2014

Reconciled $1 million in monthly Ecommerce sales, on 5000 orders, improving from a month long process to a few minutes using VBA script inside Excel auto-filling functions down to the number of rows and for a certain number of columns

Compiled month end gross margin for US & Canada and numerous balance sheet reconciliations

Staff Accountant, CommVault Systems, Inc.

Oceanport, NJ November 2011 – November 2013

Reviewed and recorded business expense reports in Concur Solutions for worldwide employees

Adjusted GBP and Euro cash accounts to USD and recorded foreign exchange gain or loss

Created time and expense accrual on a monthly basis using Pivot Tables & Pivot Charts with Excel

PROFESSIONAL DEVELOPMENT

Johns Hopkins Bloomberg School of Public Health, January 2015

Data Science Specialization

o Regression Modeling - standardized datasets, performed graphical analysis to spot trends, trained model using linear and logistic regression

o Machine Learning – developed models from training sets, using many different algorithms, including,

Random Forest, Boosting, and Nearest Neighbor

o Capstone – Created a word predictor API for the company, Swift, using Natural Language Processing and a Stupid Backoff algorithm on a 5,000,000 word corpus from news, twitter, and blog sources

EDUCATION

Manhattan College, 2010

BS: Business Administration

Major: Accounting / Minor: Finance

TECHNOLOGICAL SKILLS

Programming Languages

Professional R programmer

Python, SQL & VBA developer

Analytical Tools

Astute Alteryx workflow designer

Informative, interactive Tableau dashboard creator

Financial Systems

Experienced Softrax Financials, Concur, JD Edwards, Netsuite, Peachtree, RetailPro back end user

Contact this candidate