Data Software Engineer

Mustafa Ozgur Akduran www.linkedin.com/in/ozgurakduran

** **** ***** ****** *** 2329 South Orange, NJ 07079 ************@*****.*** 860-***-****

SUMMARY

Working experience on whole data life cycle; extracting data from source, creating dimensional models, inserting data into data warehouse, creating predictive models for synthesizing data into recommendations and actions

WORK EXPERIENCE

NYU Medical Center, New York, NY 02/2016 – 07/2017

Data Analytics-DWH Developer

Migrated data warehouse from MySQL to Oracle database

Modelled star and snowflake data schemas and implemented ETL processes using Pentaho

Managed Tableau Server, created visualizations and set up row-level security structure for dashboards

Scheduled ETL jobs over Linux server

Worked on cloud infrastructure, AWS technologies like EC2, S3, DynamoDB, EMR, Redshift, IAM etc.

Developed predictive models and sentiment analysis using R and Python

Worked on distributed data storage/MPP systems like Hadoop, Spark, Impala, Presto, Hive, Pig and real-time streaming like Kinesis, Kafka, Storm and NoSQL databases

Avis Budget Group, Parsippany, NJ 05/2015 - 08/2015

Data Analyst Intern

Created value predictions on sell-out car pricing and customer segmentation using Python Scikit-learn package

Automated actions like data extraction, merging, pivot table creation and reporting using VBA and Java

Turkland Bank, Istanbul, Turkey 08/2012 - 08/2014

Associate Manager

Designed a new Data Warehouse for Bank’s decision making needs that can provide automated reporting and ad-hoc access on large datasets, and developed 200 ETL packages/functions in creation of data marts

Achieved to build more than 100 financial reports in 6 months

Created customized data marts for budgeting, forecasting and financial reporting needs

Developed BASEL II reporting according to the risk and capital management requirements of the Bank

Managed outsource employees, analysts and international vendor teams for various projects

Intellica, Business Intelligence Consultancy, Istanbul, Turkey 03/2012 - 08/2012

BI & DWH Consultant

Composed data mappings, reports, scorecards, KPIs and dashboards for Telecom Companies

Performed financial forecasting, fraud detection, churn and customer loyalty analysis

Navy, Istanbul, Turkey 08/2002 - 07/2011

Software Engineer & Head Electronics Officer

Developed a new GUI API for Combat Management System using Java Spring

Managed 16 personnel including payroll, training, performance management, work-flow assignment

EDUCATION

University of Connecticut School of Business, Hartford, CT 12/2015

MS, Business Analytics and Project Management (GPA: 3.73/4)

Bogazici University, Istanbul, Turkey 06/2009

MS, Computer Engineering (GPA: 3.50/4)

Naval Academy, Istanbul, Turkey 08/2002

BS, Computer Engineering (GPA: 3.26/4)

TECHNICAL SKILLS

Analytics Tools: R, SAS (Base, EMiner, Guide, JMP), Alteryx, Microsoft Azure ML, Advanced MS Excel

Reporting & ETL Tools: Tableau, Pentaho, OBIEE, ODI, BI Publisher, Hyperion Brio, Jaspersoft

DBMS: Oracle, MySQL, Microsoft SQL Server, HBase

Languages & Platforms: Python (Pandas, Scikit-learn), Java, SQL, Spark, Pig, Hive, XML, VBA, MATLAB, Unix

Contact this candidate