Data Analyst Power BI SQL Python Azure Spark

Daniel Wetta Ph: 775-***-****

*******@*****.*** US Citizen Willing to Relocate Dallas, TX 75252

PROJECTS

Tactical Archery Systems: Python, Matlab, Matplotlib Gathered theoretical and experimental data for Tactical Archery Systems in order to test a new prototype crossbow design. The theoretical data was calculated using Hooke’s Law in Python and Matlab. Stress and Strain Graphs for the different materials were created using Matplotlib to show the Linear relationship between them. Dielectrophoresis Analysis: Python, Pandas, Matlab Gathered scientific data for research regarding high frequency dielectrophoresis and its effects on a particle through an electric field.The dielectric-force along with the Clausius-Mossotti Factor was calculated using Matlab and Python. Pandas was used to perform analysis on the data to determine at what frequency changes the particle’s behavior. Apple Cash Flow Analysis: Python, Pandas, Power BI Gathered financial data of Apple for the last ten years and stored the data as a CSV file. Python was used for Data Wrangling and for Predictive Modeling in order to calculate future horizon values. The data was then analyzed using Pandas,and graphs, charts, and slicers were produced using MS Power BI.

CRM Opportunity Analysis: BI and ETL (in prog)

Built operational reports for the Sales Management team to track the sales funnel and identify opportunities and gaps in the current Sales process. Performed ETL using T-SQL on SQL Server. Built Data Model and executive dashboards in Power BI using DAX and Power Query.

Power BI Dashboard Link YouTube Video Github link

Heart Disease Analysis: Python, Sklearn, Azure ML, Power BI (in prog) Aggregated and Analyzed Heart Disease Data for Switzerland and determined what factors had the greatest correlation to the presence of Heart Disease. Python used for Data Wrangling and ETL. Analyzed performance across Logistic Regression, Hyperparameter Tuning, and Random Forests to provide the model with the best precision. Power BI Dashboard Link YouTube Video Github link

EDUCATION

Data Science Immersive - Divergence Academy, March 2020 Master of Science - Southern Methodist University, May 2018 Engineering Management, GPA: 3.42

Bachelor of Science - Oklahoma State University, May 2013 Mechanical Engineering and Technology, GPA: 3.64

PUBLICATION

H.Hadady G, C. Montiel, E. J. Geiger “Liposomes as a model for the study of high frequency dielectrophoresis”, Electrophoresis, Volume 36, Issue 13, pages 1423-1428, July 2015. EXPERIENCE

Graduate Engineer I – Jordan & Skala Engineers Inc. (Nov 2018 – Oct 2019) Python used to calculate the velocities, pressures, flow rates, and head loss through a pipe. CAPABILITIES

CERTIFICATIONS

70-778:Analyzing and

Visualizing Data with

Microsoft Power BI,

DP-100:Designing

and Implementing a

Data Science Solution

on Azure (in prog),

FE: Fundamental

Engineering Exam, EIT

certified,

DATA STORES

SQL Server

HDFS, AWS S3

Azure Blob

BI / Visualization

Power BI

(Power Query, DAX)

Matplotlib

Tableau

FEA

SCRIPTING/

PROGRAMMING

Python

T-SQL

Matlab

LIBRARIES/

FRAMEWORKS

Sk-learn

Pandas, PySpark

Databricks Spark

Azure Data Factory

SSIS

SSAS

Flask (in prog)

Machine Learning

Linear/Logistic

Regression

Decision Trees

Random Forests

Clustering/KMeans

Contact this candidate