Resume

Sign in

Data Analyst

Location:
Los Gatos, California, United States
Posted:
November 30, 2018

Contact this candidate

Resume:

TATIANA BAEVA

Junior Data Scientist/Database Administrator

*** *** *** **., ***. 13, Los Gatos, CA 95032

ac7t98@r.postjobfree.com

229-***-****

tatianabaeva.com

Profile

Junior Data Scientist/Database Administrator with background in Computer Science and experience in developing and implementing database projects. Fundamental knowledge of MySQL, Oracle, SQL Server, and MongoDB databases. Familiar with procedural SQL programming including but not limited to queries, triggers, functions and procedures (PL/SQL and TSQL). Basic skills of designing databases and datamarts, cleaning, extracting, transforming, and loading data into a database. Experienced with basic concepts of database optimization, normalization, performance tuning as well as with principals of data visualizations and analysis.

Technical Skills

Database and analytics

Hands-on experience with the following database management systems: MySQL, Oracle, SQL Server, MongoDB

Practice writing procedures, triggers, functions in TSQL, PL/SQL

Experience with extracting, transforming, filtering data from multiple resources using tools like SSIS and OLAP

Practice writing queries to extract data and analyze it

Qualification in creating visualizations to demonstrate the result and interpret trends by utilizing Tableau, PowerBI, Excel

Programming

Languages: PHP, Java, Python

Web skills

Web basics: HTML, CSS, JavaScript, jQuery

Frameworks: Foundation, Bootstrap

CMS: WordPress, Joomla, Drupal

Education

Kennesaw State University, Atlanta, GA expected December 2018

Graduate Certificate in Data Management and Analytics

Georgia Southwestern State University, Americus, GA May 2015

M.S. in Computer Science

South Ural State University, Chelyabinsk, Russia June 2007

M.S. in Fine Arts

Certificates

Tableau Desktop Specialist November 2018

Projects

Education and freelance

Competed individual datamart project “Air Pollution around the World” for Database Administration class at KSU. Used 4 open data sources to extract, clean and transform data into the warehouse which was specifically developed for this class. After that developed set of queries to extract and gather data for reports. Project was developed using Excel, SSIS and Oracle database.

“Graduate Enrollment at KSU” data visualization project for Data Visualization class at KSU developed by the request of Professor from Business Department. Used real data provided by a professor for the last 5 years of graduate enrollment to see what majors are more successful and decide which majors should be eliminated in future. Data was given in Excel format. Performed cleaning, filtering, data transformation and applied additional operations for better analytics. This project was developed using Excel and Tableau.

“Graduate Enrollment of CSE college at KSU” data analysis project for Business Intelligence class at KSU. Individual project was developed to analyze undergraduate and graduate enrollment of CSE college ant KSU for the last 5 years. The main goal was to catch current trends and see what majors are more popular so more effort can be dedicated toward those which aren’t. This project was developed using OLAP, Excel and PowerBI.

Master Thesis at GSW “Clustering Uncertain Data and its Applications“. Developed a web application based on PTSD story bank to suggest similar stories depending on user’s input. User could provide his own rating for a set of specific keywords and the application would evaluate it to recommend him to read a story which has a rating close enough of what he specified. Data was analyzed by using k-means function in octave, web interface was build using jQuery.

Work Experience

Department of University Relations,

Georgia Southwestern State University August 2016 – October 2018

Web Developer/Database administrator

Maintained GSW University website (gsw.edu): Joomla CMS system upgrade; developed and supported web forms with reporting and payment functionality; supported, maintained and enhanced existing applications for various departments; integrated third party solutions (Ellucian mobile, Dynamic Forms)

School of Computing and Mathematics,

Georgia Southwestern State University August 2014 – October 2018

Part-time Instructor

Taught CS/IT classes: Computer Applications, Object-oriented Programming, Web Development, Desktop Publishing, Internship



Contact this candidate