Data Analyst Resume Bridgewater, NJ - Hire IT People

UMMARY:

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

PROFESSIONAL EXPERIENCE:

Data Analyst

Confidential, Bridgewater, NJ

Removing hundreds of thousands of duplicate profiles that cause customers to not see all insurance products available to them on their website profile; Utilizing DB2 data & mainframe computing data to be processed with Access, Excel, and R

Data Analyst

Confidential, Engelwood, CO

Programming with R and using an ODBC connection to MS SQL databases, developed regression model to predict bad performing upstream signals for to target nodes for repair; approx: 0.82
Designed Tableau univariate analysis tool to assist management in forecasting costs at specified goal level for metrics used for evaluation and compensation of network support team

Data Analyst

Confidential, Denver, CO

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

Confidential, Eatontown, NJ

Created a VBA macro that automated & formatted trial balances; condensing a week long procedure during close to a few minute process, including variance analysis
Preprocessed data with VLOOKUP, SUMIF, INDEXMATCH, and more with Excel

Staff Accountant

Confidential, Oceanport, NJ

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