Summary
Overview
Work History
Education
Skills
Certificates Courses
Timeline
Generic
Özge Ocar

Özge Ocar

Senior Business Analyst
İstanbul

Summary

Experienced Senior Business Analyst with data analytics and business analysis background who has worked in Agile environments. Worked as an Agile Product Owner in business development projects. Proficient knowledge in advanced SQL queries. Excellent understanding of business operations, a team member with problem-solving skills and ability to work with both technical and non-technical teams.

Overview

16
16
years of professional experience
4
4
years of post-secondary education

Work History

Senior Business Analyst, Scrum Master

FORD OTOSAN
12.2023 - Current
  • Contributing to the development of the company’s material planning and logistics systems.
  • Projects: Ford Otosan Transport Portal (Freight Payment Systems), Smart Supply Chain Management (Material Planning calculation system)
  • Collaborating closely with stakeholders to define both functional and non-functional requirements for system enhancements.
  • Designing process flows, created mock-up pages, and conducted comprehensive testing to ensure system functionality.
  • Leading training sessions and developed user manuals to ensure smooth system adoption.
  • Supporting User Acceptance Testing (UAT) and tracked project progress to ensure timely delivery and quality outcomes.

Business Intelligence Senior Supervisor

GARANTI BBVA Mortgage
10.2019 - 11.2023
  • Managed ETL processes using Microsoft SSIS to load data into local mortgage database
  • Wrote advanced SQL queries for data retrieval (T-SQL on MS SQL Server and PL/SQL on Oracle SQL Developer)
  • Developed Qliksense dashboards for enhanced data visualization and analysis
  • Led ETL maintenance projects, adapting to source table changes and ensuring data integrity
  • Extracted and analyzing customer, sales, and loan data, presenting reports to management
  • Designed SSRS reports in Visual Studio for informed decision-making
  • Expert in allocating sales targets based on business trends and KPIs, continually improving targeting models

Customer Experience Research - Supervisor & Product Owner

GARANTI BBVA
09.2018 - 09.2019
  • Worked as an Agile Product Owner for Customer Experience team projects:
  • Project for creating a database for Customer Satisfaction Surveys
  • Projects for improving Survey Score screens
  • Worked on improvements for customer survey database which is crucial in customer researches
  • Analyzed survey results: Net Promoter Score and Customer Experience Score analysis and visualization

Business Intelligence Supervisor

GARANTI BBVA Mortgage
04.2011 - 09.2018
  • Led the Information Systems team, overseeing the development of 2 junior team members
  • Managed a dynamic dashboard project for a year
  • Extracted, summarized, and reported on customer data, sales, and loan applications using SQL queries for business units and top management
  • Created SSRS reports using Visual Studio for various business units
  • Established and maintained ETL transformations on SSIS to load data into the mortgage database

Business Development Projects Specialist

ALLIANZ LIFE AND PENSION (YAPI KREDI LIFE AND PENSION)
05.2009 - 04.2011
  • Executed SQL coding and pre-testing and post-measurement of customer campaigns and loyalty programs to increase retention rates
  • As part of Projects Team of the CR Department; responsible for forming necessity analysis to find inefficiencies in processes upon changing regulations and assisting other units’ reporting needs
  • Prepared operational activity reports, call center performance reports and customer data for new campaigns (Retrieving data by SQL queries)
  • Successfully completed the 'Customer Persistency Project,' which identified the root causes of early customer churn in pension contracts and presented findings to top management

Education

Bachelor's - Management Engineering

Istanbul Technical University
01.2004 - 01.2008

Skills

MS Visio, Postman, SQL, Azure, Mega Hopex, Balsamiq

Agile Scrum, Stakeholder management, Business process mapping, Analytical thinking, Facilitation

Certificates Courses

  • IIBA CBAP International Business Analyst Training, 05/2024
  • Scrum Team Member, 2024
  • Qliksense Custom Course, 2021
  • Advanced PL/SQL Test (90/100), 2019
  • IELTS Score 7.0, 2017

Timeline

Senior Business Analyst, Scrum Master

FORD OTOSAN
12.2023 - Current

Business Intelligence Senior Supervisor

GARANTI BBVA Mortgage
10.2019 - 11.2023

Customer Experience Research - Supervisor & Product Owner

GARANTI BBVA
09.2018 - 09.2019

Business Intelligence Supervisor

GARANTI BBVA Mortgage
04.2011 - 09.2018

Business Development Projects Specialist

ALLIANZ LIFE AND PENSION (YAPI KREDI LIFE AND PENSION)
05.2009 - 04.2011

Bachelor's - Management Engineering

Istanbul Technical University
01.2004 - 01.2008
Özge OcarSenior Business Analyst