Ulas Oncul - Freelance Business Intelligence Architect and Data Modeler

Istanbul, Turkey

Experience

Jan 2020 - Present

4 years 6 months

Tirana, Albania

Migration Team Lead, Data Modeler

Vodafone Albania / Vodafone Spain

Worked for the design of the Fixed Line Business Systems
Introduced the application data model to clients
Carried out modeling sessions
Supported data migration activities
In Vodafone Spain, adapted the application and data model to a green-field business

Jan 2020 - Present

4 years 6 months

İstanbul, Turkey

Freelance Business Intelligence Data Modeler

Vodafone Turkey

Develop an in-depth understanding of the business processes and data in the corporation
Assist in maintaining the Corporate Data

Jan 2020 - Dec 2021

2 years

İstanbul, Turkey

Freelance Business Intelligence Consultant and Data Modeler

Fibabanka

Product Owner of Data Analytics and Data Transformation Project in a Turkish Bank

Jan 2018 - Present

7 years 6 months

Part-Time Lecturer

Bahçeşehir University

Part-time lecturer of "Business Intelligence for Managers" and "Data Analytics and Decision Making" lessons to MBA students

Jan 2015 - Dec 2020

5 years

İstanbul, Turkey

Data Modeler and Business Intelligence Consultant

Intellica

Business Analysis Team Lead and Data Modeler of restructuring data warehouse systems of MCI, largest Telco operator in the Middle East (100 M Subs.)
Participated in restructuring Enterprise Data Warehouse of Zain Jordan, Bahrain, and Kuwait as a data modeler
Collaborated with business stakeholders and gathered business requirements to create a data model design accordingly

Jan 2014 - Dec 2015

2 years

İstanbul, Turkey

BI Manager

Allianz SE

Responsible for life and pension BI systems
Designed a data warehouse from scratch to cover the reporting and analytic needs of Allianz Life and Pensions
Built the system using Oracle Exadata, Informatica, and Cognos

Jan 2009 - Dec 2015

6 years

İstanbul, Turkey

Decision Support System Manager

Yapı Kredi Sigorta

Worked as a project manager for the core system migration from AS/400 to a new platform on Oracle
Managed a BI team responsible for decision support systems, including operational and legal reporting
Built the BI system using Oracle Exadata, Oracle Data Integrator, and Oracle Business Intelligence Suite
Responsible for a team that developed SharePoint applications
Took an active role in several analytic projects, like Churn Analysis and Insurance Rate Making in Property and Casualty Insurance
Managed and coached team members

Jan 2003 - Dec 2009

7 years

İstanbul, Turkey

Business Intelligence Manager

Yapı Kredi Emeklilik

Implemented full-cycle BI project for the company, from product selection to execution
Designed and built the data warehouse on MS SQL Server technologies
Created management decision support models and reports for sales and marketing departments like segmentation and churn analysis

Jan 2001 - Dec 2004

3 years

İstanbul, Turkey

Business Analyst

Yapı Kredi Emeklilik, Yapı Kredi Yaşam

Gathered business requirements and delivered them to the IT teams
The primary task was related to the newly built Pension Systems

Jan 1998 - Dec 2000

2 years

İstanbul, Turkey

Management Trainee

Yapı Kredi Yaşam

Performed research and analysis for the rating of personal insurance lines and managed group products
Prepared and presented reports outlining the optimum life insurance rates and risk management of the lines
Created quantitative and statistical business models by using data analysis programs

Jan 1998 - Dec 1999

2 years

İstanbul, Turkey