Junior Data Scientist/Database Administrator
*** *** *** **., ***. 13, Los Gatos, CA 95032
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.
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
Languages: PHP, Java, Python
Frameworks: Foundation, Bootstrap
CMS: WordPress, Joomla, Drupal
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
Tableau Desktop Specialist November 2018
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.
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
Taught CS/IT classes: Computer Applications, Object-oriented Programming, Web Development, Desktop Publishing, Internship