Data Analyst Customer Service

Yamrot Negusu

Data Analyst

New York, NY

********@*****.*** 646-***-****

github.com/ynegusu, linkedin.com/in/yamrot-negusu

PROFESSIONAL SKILLS:

SQL, Advanced Excel, Python, Tableau, Statistics, Marketing Analytics, Data Interpretation, Data Analysis Techniques, Interpreting Trends, Data Filtering, ad-hoc reports, mining & segmentation PROJECTS:

Home Credit - Default Risk

● The dataset contains information about 307k loan applications.

● Utilized historical loan application data to perform exploratory analysis to identify relationships, trends, or anomalies and build a predictive model capable of predicting whether or not an applicant will be able to repay a loan.

● The strategy used involves data exploration, data processing, and model building

● Results included model output to identify if a new client shows a high risk for loan default Technology:Python, Excel, Tableau, SQL

Airbnb - Queens vs. Staten Island price difference

● The dataset used for this analysis is a sample of Airbnb listings in NYC (2019), with 50k listings, has 16 columns with a mix between categorical and numeric values.

● Used hypothesis testing to determine if there is a significant price difference between a room/apt in Queens and Staten Island

● Using hypothesis testing, we reject the null hypothesis and conclude that there is enough evidence to support the claim that there is a significant price difference between Queens

($147) and Staten Island ($173.8).

Technology:Excel, Tableau

OLIST - Brazilian E-Commerce

● The dataset contains 100k orders made from 2016 to 2018 at multiple marketplaces in Brazil including customers, orders, payment, products, review, sellers, and geolocation

● Performed linear regression to predict how much new customers will spend 161 in their first six months

● Results included most customers ordered just one product, credit cards are used by the majority of customers, (number of payments 73.9% and total payment value 78.3%), and lastly most orders placed have an order total of ~60

Technology:SQL, Python, Excel, Tableau

EDUCATION:

DATA (Data Analyst Training Accelerator) at Galvanize, Inc, sponsored by NYC Tech Talent Pipeline

● Awarded a full scholarship for an 18-week DATA training immersive Business Administration and Information Systems (BA) Addis Ababa University CERTIFICATES:

Advanced Google Analytics, Google Analytics Academy, Advanced Excel (Lynda.com), Python for Marketing (Lynda.com), Marketing Foundations: Competitive Market Analysis (Lynda.com) PROFESSIONAL EXPERIENCE

Whole Foods Market, NYC, NY May 2017

Team Member

Contact this candidate