***** ****** **** **** #****

Austin, TX *****

512-***-****

LinkedIn GitHub Portfolio

ada5ed@r.postjobfree.com

YARED SHEWARADE

OBJECTIVE

A data analyst position in a growing industry with growth opportunities in which I can put my education and talents to work

PROFESSIONAL SUMMARY

Multidisciplinary Data Analyst with 5 years’ experience in research, ETL, AWS, data processing, database administration, data analytics and visualization. Passionate and highly skilled in performing complex data analysis, data mining, predictive modeling, design and development of data warehouses. Excellent at solving complex problems and able to work under pressure

EDUCATION

DATA ANALYTICS AND VISUALIZATION CERTIFICATE

The University of Texas at Austin, Austin, TX May 2019

MASTER OF SCIENCE (MS) IN RESEARCH IN NUTRITION

The Hebrew University of Jerusalem, Jerusalem, Israel September 2016

BACHELOR OF SCIENCE IN PHARMACY

Jimma University, Jimma, Ethiopia October 2013

EXPERIENCE

BLUECROSS BLUESHIELD February 2017 – Present

Data Engineer

Created and maintained a large health care service database

Cleaned, managed and integrated data from different sources using Informatica PowerCenter for ETL

Wrote complex queries for aggregation, managing and analyzing data

Performed data mining, data modeling, and data provisioning for large data sets on AWS

Analyzed and modified data using Excel, Python, Pandas, Matplotlib, SPSS and STATA

Designed and created interactive data visualization dashboards

TUFTS UNIVERSITY – USAID/ENGINE RESEARCH PROJECT April 2012 – December 2016

Data Engineer

Created and maintained a large air pollution and health records database

Cleaned, managed and integrated data from different sources using Informatica PowerCenter for ETL

Analyzed and modified data using Excel, Python, Pandas, Matplotlib, SPSS and STATA

Designed and created interactive data visualization dashboards

ROJECTS

Data Analytics and Visualization Certificate Program (UT Austin)

Impact of News on Stock Prices

Role: Scrape the data, create database, and plot on Matplotlib and Pandas

Technologies: API, Vader Sentiment Analysis, Python, SQL, MySQL, Matplotlib, Pandas

Scraped news data from New York Times, Wall Street Journal, CNN and Alpha Vantage

Quantified sentiment by leveraging Vader Sentiment analysis

Created visualization plots for stock prices and volumes against Vader Scores

Where to work

Role: Create SQL database, Scrape data, Analyzing and Plotting data on Tableau, D3.js

Technologies: Python, SQL, MySQL, Beautiful Soup, Pandas, HTML, CSS, Bootstrap, JavaScript, Tableau

Scraped 8100 job descriptions from Glassdoor for 10 major cities

Created a database of job descriptions on MongoDB

Designed and created word frequency cloud for most required skills

Created data visualization plots

Rent Predictor

Role: Create SQL database, Machine training, Scrape data, Data analysis and visualization

Technologies: Machine Learning, (Linear Regression, Polynomial Regression, Random Forest, Neural Network, K-Nearest Neighbor), Python, SQL, MySQL, Beautiful Soup, Pandas, HTML, CSS, Bootstrap, JavaScript, Tableau, Flask, Matplotlib, NumPy, Jupiter notebook, Heroku

Collected data on 6000 properties from CoStar

Cleaned and loaded 98% of the data

Created SQL database on MySQL

Trained machine using Linear Regression and Random Forest

Analyzed and plotted data using Python, Tableau, D3.js, Plotly, Leaflet.js

TECHNICAL SKILLS

Database Management: SQL, NoSQL, MySQL Server, SQL Server, MongoDB, and PostgreSQL

Data Integration: ETL, Informatica PowerCenter

Cloud Platform: GCP and AWS (Amazon Web Service) including EC2, Lambda, EBS, S3, Snowball, CloudFront, RDS, DynamoDB, Redshift, VPC, CloudWatch, IAM, KMS, Code Pipeline, etc.

Language and Statistical Tools: Python, R, Hadoop, SPSS, STATA, Tableau, Apache Spark, Machine Learning.

Big Data Management: Data Mining, Data Entry, Data Cleaning, Data Quality and Validation.

Statistical Analysis: Descriptive Statistics, ANOVA, Regression, Time Series, Mixed Model, Bayesian Methods, Clustering, Student t-test, Experimental Design.

Database Visualization: Rest API, Flask, Plotly, D3.js, Leaflet.js, Tableau

Other Tools: Microsoft Word, Excel, Access, HTML, CSS, Bootstrap, JavaScript

PROFESSIONAL DEVELOPMENT

AWS architecture certification program

Informatica training program for ETL

Data Management, Analysis and Graphics using STATA, Kenya

SQL for Data Science by University of California, Davis

Data Scientist’s Toolbox by Johns Hopkins University

REFERENCES

To be provided upon request

Contact this candidate