Resume

Technical Skills

RDBMS / DW:                   SQL Server, Oracle, MySQL, PostgreSQL+PostGIS, Snowflake, Redshift
ETL Tools:                         Python, SSIS, PowerShell, Batch, Bash, SQL, SAP Data Services, Denodo
Systems:                           Linux (Debian/Ubuntu, RHEL/CentOS), Windows
Business Intelligence:  Microsoft SSRS, PowerBI, Tableau, Crystal, Pentaho, QGIS, RRDTool
Hadoop / Big Data:        Cloudera, Sqoop, HIVE
Statistics (Python):        Jupyter/IPython, Pandas, NumPy, scikit-learn
Business Process:          ITIL, Agile

Experience

Consultant – Pandata Group
Feb 2016 – March 2017

• EDW – ETL design, development, test, and deployment
  • Oversee code migration between environments (Dev, Test, Prod)
  • Expand existing QA and UAT working with SMEs and Data Stewards
• Develop and test POC for SAP Web Services (SOAP API – tested with SoapUI)

SQL Data Analyst – Perblue
August 2015 – Feb 2016

• Free-to-play gaming, B2C, User Interaction and Retention KPIs
  • DAU, MAU, LTV, ARPDAU, churn and cohort analysis
  • Worked with Chief Product Officer to ensure balanced/fair in-game economy and effective game events
• TV and Digital Marketing Campaigns
  • Designed TV Ad Attribution model to support marketing team for global TV ad campaigns in excess of $1M/month
  • Created ROAS, CpA, and LTV models for marketing consumption
  • Utilized third party tools and combined with in-house data

• BI Infrastructure and cloud migration
  • Forecasted growth by User Acquisition plan, assessed BI infrastructure and
    Migrated DB from on premise MySQL to cloud based Snowflake
  • Consolidated ~10 autonomous MySQL DBs (>20B Records)
  • Decreased Tableau extract run-time 10X
  • Decreased average SAN latency 2X

Consultant / DBA – 5NINES
April 2013 – August 2015

• Speedtest.net ETL & Reporting; ~30M records; Python, PostgreSQL+PostGIS, SSRS
• Oracle upgrade/migration from Solaris box and Oracle 10c to CentOS VM and 11g
• Pentaho reporting platform and cube design with Oracle 12g backend
• EMC VNX Series benchmarking and implementation

Side Projects

• NFL Statistics – PostgreSQL, dimensional modeling, PowerBI
• Home Automation + IoT – Raspberry Pi, Arduino, AWS IoT button
• Continued work with 5NINES on Speedtest.net
• ESXi Infrastructure – Linux+Windows VMs, pfSense, PostgreSQL, nginx