Ö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