Data Analyst - Remote

Gary Whiteford

R / Shiny Developer - Remote

Greater Minneapolis-St. Paul Metropolitan Area

***********@***.***

https://www.linkedin.com/in/garywhiteford/

JOB OBJECTIVE

Developer of applications using R and Shiny with over five years of experience working with all aspects of scripting and manipulating data. WORK EXPERIENCE

CWT in Minnetonka, Minnesota - Senior Technical Consultant 2011 - PRESENT

● Develop applications in R for data analysis and data wrangling. Develop and support Shiny applications for use by internal business consultants and as external facing prototypes for use by clients. Developed apps including R packages such as dplyr, dbplyr, shiny

(with googleanalytics.js, shinytheme, shinydashboard, customHTML [for dashboard components], rpivotTable, etc.), DT, formattable, DBI, tidyr, data.table, highcharter, plotly, readr, lubridate, shinyjs, bit64, odbc, stringr.

● Worked on a team to develop the most used Shiny app in the company

(to help users find the best key for reporting their clients’ data).

● Use R and Linux Bash to script ETL processes for a data lake.

● Develop and implement tools for converting third-party data for loading. Involved applying industry TVL300 data standard, reverse engineering an MS Access database and macros, designing and implementing MS Excel workbooks with VBA to convert data and validate it and coding a Shiny application in R to further refine and automate the process for loading to Oracle enterprise database.

● Administer Linux servers using Red Hat Enterprise Linux 7.

● Install and administer an instance of Hortonworks Data Platform, including Hive LLAP tuning. Lead team migration to Cloudera.

● Develop Oozie scripts to migrate data using Impala and Postgres.

● Develop, troubleshoot and support automated Excel dashboards. Create macros to automatically push Excel objects to PowerPoint. Develop other automated tools for business users in Excel. Medtronic in Fridley, Minnesota - Associate HR Operations Analyst 2007 - 2011

● Provide Excel-based data analysis and management

● Perform analytical function in a call center environment CLA in Minneapolis, Minnesota - Client Service Assistant 2002 - 2006

● Provide administrative support

● Edit and proof proposals

EDUCATION

Bob Jones University in Greenville, South Carolina - BS in Music Ed. OTHER INTERESTS

Church musician – piano