F. Ozge Ozturk
- Role
- Data Analyst Ii at Cox Communications
- Location
- Atlanta, GA, US
- LinkedIn followers
- 500 followers
About F. Ozge Ozturk
My background includes experience in data analysis mainly using SQL, R, and Tableau…
Experience
Data Analyst Ii
Jan 2019 — Present
Connecting to athena database via R, querying spot data. Analyzing and graphing revenue and impressions by station, zone and daypart. Used DBI, odbc,tidyverse,dplyr,ggplot2, PerformanceAnalytics,RSQLite, fuzzyjoin,reshape2 packages- Mentoring others in SQL (teaching advanced querying techniques) and Excel - Writing an R script that loops over verification files, calculates Aired vs Failed Spot count and percentage per file. Used dplyr - Coding an R script pipeline that manipulates XML, inserting a node in multiple files allowing the orders to go through- Coding an R script pipeline that pulls Nielsen RSS feed in zip files, expands the flat files, separates various tables within each file and creates dataframes that combine relevant data from each table, tidies up the data, pushes the tables to SQL server, and moves the monthly files to an archive folder. Used plyr, splitstackshape,dplyr, RODBC. Automated it with taskscheduleR- Coding an R script pipeline that takes the outputs from multiple systems in zip format, expands the excel and csv files, reshapes the data and compares impressions and clicks data to find discrepancies. Used dplyr, sqldf, plyr, rJava, and XLConnect- Coding an R script that takes two dataframes and creates a nested JSON file for ad spots using tidyverse and jsonlite- Coding an R script that detects when a jump occurs in a SQL db ID column and sends an outlook email to alert the tech support. Used RDCOMClient, RODBC- Ad hoc data exploration with SQL queries - Making old SQL queries dynamic and creating scheduled reports on SSRS, and other internal systems, batch file plus Task scheduler. Used several techniques like cross apply, dynamic querying, reading json files on sql etc- Creating dynamic reports in Tableau - Data mapping
Skills
- Html
- Management
- Sipoc
- Leadership
- Research
- Microsoft Office
- Css
- Pestel Analysis
- Power Bi
- English
- Six Sigma
- Sharepoint
- Project Planning
- Data Analysis
- Tableau
- Minitab
- Microsoft Access
- Ms Project
- Matlab
- Team Foundation Server (Tfs)
- Swot Analysis
- Access
- Quick Basic
- Microsoft Word
- Business Process Improvement
- Analysis
- Process Improvement
- Ismodeler
- Microsoft Excel
- Engineering
- Value Stream Mapping
- Autocad
- Smartdraw
- Visio
- Ariba
- Agile
- Teamwork
- Sql
- Project Management
- Statistics
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.