BURCU ERSAN
adex17@r.postjobfree.com
https://www.linkedin.com/in/ersanburcu/
SUMMARY
Real-time experience in working with data importing, wrangling, and analyzing using R and Python.
Real-time experience in preparation of Dashboards using Tableau and R.
Good understanding and knowledge of several Big Data technologies like Hadoop, Sqoop, Hive, Oozie, Spark, Oozie.
Good understanding of machine learning,data mining, statistics concepts.
Good experience in using RDBMS concepts.
Good experience in business analysis and system analysis.
Experience in system design using Microsoft Visio.
Good understanding of Agile Software Development methodology.
Strong oral and written communication, initiation, interpersonal, learning and organizing skills matched with the ability to manage time and people effectively.
Technical Skills:
Big Data Technologies
Hadoop, HBase, Hive, Sqoop, Spark, Oozie, Zookeeper
Programming Languages
Python, VB.net
Operating System
Windows, Linux
Query Language
MySQL
Databases
Oracle
Operating System
Windows, Linux
Hadoop Distributions
Hortonworks, Cloudera
Data Analytical Tool
R
Data Visualization Tool
Tableau
EDUCATION
Central Michigan University
Master of Science in Information Systems, 2020 (3.95/4.00)
City University of New York
Academic Associate Program, 2018
Istanbul University
Business Administration
Industrial Engineering (minor), 2015 (3.73/4.00)
Certificates
Six Sigma Green Belt - Central Michigan University
Data Visualization with Tableau - University of California, Davis through Coursera
Graduate Teaching Assistant Development - Central Michigan University
EXPERIENCE
GRADUATE ASSISTANT – DATA ANALYST, CENTRAL MICHIGAN UNIVERSITY
AUGUST’18 – MAY’20
Supported the professor in teaching data analysis with Microsoft Excel and Access to students.
Gathered student’s data, analyzed, and interpreted the data using data analytics tool R.
Developed solutions using data science and visualizations tools including R, Tableau, SQL.
Cleaned and pruned data to discard irrelevant information with R.
Created new tables and student database in MySQL.
Provided concise data reports and clear data visualizations using Tableau and R.
PROJECTS
NIKE – TWITTER DATA
Analyzed Nike tweets based on specific hashtags using R.
Installed necessary libraries and understanding its use.
Performed data wrangling/cleansing operations.
Visualized the result with histogram, network diagram, and word cloud.
Analyzed Nike marketing strategy using sentiment analysis.
VIRTUAL SYSTEM DESKTOP
Analyzed log data from virtual system desktop of CMU using R.
Performed basic EDA to insights into the data.
Took care of missing values and datatype issues in the data. Imputed for the null values.
Cleaned and pruned data to discard irrelevant information.
Provided concise data reports and clear data visualizations.
Information Systems Capstone Project
Analyzed the business problem very well and designed an effective new system for the business. Provided documentation of all processes.
Met with the clients regularly to establish project scope, system goals, and requirements.
Developed, analyzed, prioritized, and organized requirement specifications, diagrams, and flowcharts using Microsoft Visio for developers and testers to follow.
Defined and coordinated the execution of testing procedures and develop test cases to serve the overall quality assurance process.
Gathered data and created a database for the system using SQL.
Created billing software for the business as a team using VB.Net.
CUSTOMER DEVELOPMENT INTERN, UNILEVER
JUN 13’– DECEMBER 13’
Contributed to increase sales in Distribution Channel by assisting the manager in managing, maintaining, and analyzing sales and marketing activities of distribution channel and customer SAP.
Analyzed a variety of data input and created reports effectively using Pivot Tables and VLOOKUP on Microsoft Excel.
Communicated frequently with customers and made customers more satisfied with having several business trips.
Created new sales strategies with the manager by exploring new opportunities within the marketplace.
Contributed successfully to complete the project from beginning to end, and presented the project to Unilever VB, directors and managers at the end of the internship program.