HARVEY SMITH

DATA ENGINEERING AND ANALYSIS

CONTACT

aduoyt@r.postjobfree.com

479-***-****

Austin, TX

linkedin.com/in/harveybsmith/

github.com/mixtek

kaggle.com/mixtek

tableau.com/public/harvey.smith

PROFILE

Lead data analyst specialized in exploratory

analysis, data engineering and building data

models and ETL pipelines

EDUCATION

2013 - UNIVERSITY OF ARKANSAS

Master of Anthropology

2008 - UNIVERSITY OF CENTRAL

ARKANSAS

Bachelor of Science in Geography

TECHNICAL SKILLS

Machine Learning: Decision Trees, Time

Series, NLP

Databases: SQL Server, MySQL,

MongoDB, Oracle, Teradata

Data Visualization: Tableau, Power BI,

Seaborn, Plotly

Workflows: SSIS

Statistics: Hypothesis testing.

Distributions, Confidence intervals

Cloud Computing: AWS, Google Colab

Notebooks

Programming Languages: Python, SQL

Distributed Computing: Spark

Geospatial Analysis

CERTIFICATIONS

Data Analytics and Visualizations:

University of Texas

Machine Learning: Stanford Online

Hadoop Hands-on: Udemy

Scrum Fundamentals Certified, Scrum

WORK EXPERIENCE

2019 - PRESENT

Data Analyst III Centene – Superior Health Plan

Develop data flow pipelines, analytics reports and dashboards using Power BI, SQL, Python, and data processing software such as SSIS, Toad.

Created a key corporate process of assigning members in Texas to a preferential primary care provider using Python counters, random selection to optimally assign members to a list of preferred providers given provider’s panel sizes.

Created full-stack SharePoint app using SSIS, C#

Combine data from NoSQL MongoDB and SQL databases using Python APIs to perform validation checks across different databases.

Redesigned existing file ETL processes using object-oriented programming in Python for greater reliability and ease of use

Provide in depth quantitative analysis of member enrollment populations over time and space.

Migrate data from Access Databases to Enterprise Data Warehouse 2019

Business Analyst Conduent

Produced daily and ad hoc reports of toll road transaction data, checking for backlogs and abnormalities in volume using rolling averages and counts with SQL queries and Tableau Server.

Weekly meetings with stakeholders, TxDOT, to discuss progress with JIRA ticket resolutions, impediments & backlogs, and release planning. 2018 - 2019

IT Geospatial Analyst Austin Energy.

Updated and improved data quality and accuracy of the geodatabase of the electrical distribution system of the City of Austin. 2017 - 2018

Geographic Information Systems Technician Apple Inc.

Improved data quality and piloted new in-house back-end GIS software ultimately seen on the new and improved Apple Maps Navigation app. Resolved user-reported tickets using research of valid sources such as municipal, state, or national level online Geographic Information Systems for verifying addresses, street, and territories data.

HARVEY SMITH

DATA SCIENCE AND ENGINEERING

Contact this candidate