Olga Romanova

Foster City, CA *****

Phone: 650-***-**** Email: adbs5w@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/olga-romanova-157126183/ Github: https://github.com/OlgaRomanova0709

Summary

Data professional with a 10-years background in Finance and skills in Excel, VBA, Python, SQL and JavaScript. MS in materials science degree from the top Russian University- Lomonosov MSU. Quick learner and analytical thinker with background in fundamental research. Relocated to the Bay area and focused on honing data analytics skills with UC Berkeley. Passionate about finding patterns through Data Analysis.

Technical Skills

Tools: Python (Pandas, matplotlib, stats, skiPy, gmaps, flask, beautifulSoup), R, JavaScript( d3,PlotLy,Leaflet), HTML, CSS, Advanced Excel, VBA Tableau, Web data (API requests)

Databases: MySQL(SQLAlchemy)/MongoDB (pyMongo)

Projects

1. “Futuristic_Airbnb” - Analyzed AirBNB and Yelp data to find a better accommodation based on customer satisfaction and to optimize Airbnb business in Berlin.

Utilized: Python (pandas, matplotlib, requests, json, gmaps, seaborn, math), Yelp API, AirBNB data sources.

https://github.com/OlgaRomanova0709/Futuristic_AirBNB_projectI

2. “Futuristic-AirBNB-ETL” - Extracted, transformed data from multiple data sources and loaded it into the target database (SQL)

Utilized: Python (pandas, requests, json, gmaps, sqlalchemy), Yelp API, AirBNB data sources.

https://github.com/OlgaRomanova0709/Futuristic-Airbnb-ETL

3. “Explore-Hawaii” - Created an interactive travel guide website to explore and plan vacation in Hawaii.

Utilized: HTML, CSS, Javascript (D3 Js, Plotly Js,Zing Chart, Leaflet Js), SQLite, Python (SQLAlchemy and Flask), Deploying Application : Heroku

https://explore-hawaii.herokuapp.com/ https://github.com/OlgaRomanova0709/Hawaii_project

Experience

Construction Companies 2006-2016

Finance Manager

• Calculation and verification of construction projects cost estimates (hours, materials, complexity et ct.)

• Exercising financial internal controls (including detection of supplier fraud)

• Financial data trend analysis to uncover anomalies

• Validated and justified to Clients and Government agencies about 10 projects each month

• Facilitated awards of $2M worth of bids for the company through online bidding

PROTEK Company (Pharmaceuticals) 2004-2006

Analytical Chemist

• Chemical composition analysis of various medications

Education

Certification: Data Analytics Boot Camp UC Berkeley Extension, 2019-2020

Major: Materials Science, MS Lomonosov Moscow State University

Other certifications: Udemy Online Academy

R Programming A-ZTM: R for Data Science, Python A-ZTM: Python for Data Science,

Data Science A-ZTM: Real-Life Data Science Exercises Included, Data Analysis with Excel Pivot Tables.

Contact this candidate