Post Job Free

Resume

Sign in

Data Analytics Analysis

Location:
North Bergen, NJ
Posted:
September 10, 2023

Contact this candidate

Resume:

Humeyra Ozturk

North Bergen, NJ ***** 917-***-**** adzlth@r.postjobfree.com linkedin.com/in/humeyra-ozturk- 2b4987236/

NYU Certified Data Analytics professional and Yeshiva University MS candidate with a strong background in data science, data analytics, and industrial engineering. Experience cleaning, analyzing, and visualizing data with tools such as Python, SQL, Excel, and Tableau. Ability to learn quickly, adapt to new things and form relationships with internal and external stakeholders. Key skills include: Python SQL (MySQL, PostgreSQL) MySQL Workbench C++ Tableau Google Sheets/MS Excel Dashboards Statistics Relational Databases Database Normalization Exploratory Data Analysis (EDA) Data Analytics AutoCAD Lindo Gams Entegra SAP ERP Microsoft Office SketchUp Arena Simulation System Visual Basic Logo Tiger 3 Minitab

EDUCATION

Master of Science, Data Analytics and Visualization - Yeshiva University Katz School of Science & Health 2023 Additional Coursework: Analytical Programming, Project Management, Product Design, Data Management Bachelor of Science, Economics - Anadolu University 2023 Bachelor of Science, Industrial Engineering - Cankaya University 2019 CERTIFICATIONS

Tableau Data Analytics Certificate - NYU Tandon School of Engineering 2022 Courses: Business Analytics Fundamentals, SQL for Analytics, Data Visualization with Tableau Engineering Case Camp - Anbean 2018

ERP Training - Bilisim Academy 2018

Convincing Communication in Human Relations - Ozgur Aksuna 2015 Relationship Management at Professional & Social Life - Serhan Yılmaz 2015 Compactness, Influence & Communication Art - Fatih Portakal 2015 RELEVANT EXPERIENCE

Tableau Data Analytics Certificate - NYU Tandon School of Engineering 2022

● Cleaned, manipulated, visualized, and analyzed raw data using spreadsheet software (i.e. Google Sheets), SQL

(i.e. MySQL), and BI data visualization tool (i.e. Tableau).

● Conducted an exploratory data analysis (EDA) to provide key stakeholders with data-based evidence of user success characteristics to make the business case for additional funding.

● Created DDL and DML SQL queries from formal and ad hoc data requests to draw insights and make data- driven recommendations to support company growth.

● Built a Tableau Story with interactive dashboards and dashboard objects to report insights from the comparative analysis completed in Tableau Desktop to technical and non-technical stakeholders. Founder - Mirada Home 2021 - Present

● Compile, manipulate, analyze data and provide financial insights used internally to make business decisions for inventory and operation.

● Analyze market trends using internal Amazon software to accurately set pricing structures and optimize for cost-effective methods.

E-Commerce Department Manager - Akduman Vitra Ltd 2021

● Implemented an SAP system for integration of different marketspaces to the company.

● Managed consistent cross-functional communication with warehouses and customers to confirm, track orders and verify price.

DATA ANALYTIC PROJECTS

End-to-End Statistical Analysis using Google Sheets, MySQL, and Python Ad Data

● Completed an end-to-end statistical analysis on online advertising data to determine the most successful ad launch. Built and ran an A/B test that identified a 7.9% increase in click-through rate in ads from current ad versus prospective ad using Google Sheets, MySQL, and Python. Communicated insights to upper management and business stakeholders using Tableau and Google Slides. Exploratory Data Analysis using Google Sheets Airbnb Data

● Performed an exploratory data analysis on Airbnb data. Discovered patterns, spotted anomalies, framed hypotheses, and checked assumptions in Google Sheets. Wrangled data by cleaning data, using pivot tables, VLOOKUP, and much more. Visualized data and calculated statistics to support exploratory data analysis findings.

DML and DDL Querying using MySQL Workbench Meetup Data

● Assessed the existing infrastructure, applied the appropriate changes to the relational database, and presented insights to business stakeholders. Wrote multiple DDL and DML MySQL queries (20+) ranging in complexity. Wrote reports that summarized insights and created an Entity-Relationship Diagram (ERD) of the updated database.

Data Storytelling using Tableau Desktop World Bank Data

● Created a Tableau story and incorporated interactive dashboards and visualizations that highlighted economic, social, and environmental trends within the United States. Cost Analysis using Excel VBA, Minitab, and Google Slides GEO 900 Drilling Machine Data

● Calculated an accurate cost of the GEO 900 drilling machine using cost analysis. Used Excel VBA for the cost analysis itself, including collecting the data. Macro and micro analysis were made. Used Minitab for cost optimization and to further the calculations. Used Google Slides to present findings.



Contact this candidate