Murat Genç
İstanbul,Turkey
Summary
15+ years of experience in Data. The areas that I've focused are DB Administration, ETL ,ELT, Data Integration, SQL, Advance SQL, Performance Tuning ,Business Intelligence & Reporting, Data Modeling, Data Lineage, Data Quality, Legal Reporting (BSBS) , Data Governance, Metadata Management, Data Discovery ,CRM, MIS, DMBoK (DAMA Book of Knowledge) ,DataOps
Overview
20
20
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work history
Manager / Data Warehouse
Garanti BBVA Technology
İstanbul, Turkey
01.2018 - Current
- Technical Lead and Manager of the team Data Warehouse
- Leading new Data Warehouse (PRISMA) Reengineering Global Projects
- Service Resillience Manager of Data Warehouse
- Local Product Owner (LPO ) of Garanti BBVA Data in Global BBVA One Project
- Trainer’s Trainer in Oracle Data Integrator(ODI), Business Intelligence ( SAP BO, OBIEE ),Data Lineage ( ODI Data Lineage, Abinitio Metadata Management)
- Define and Develop Data Development Principles and Procedures
- Define and Develop Data warehouse Data Modeling Principles and Procedures
- Define and Develop Data warehouse Data Dictionary and its principles, procedures
- Define and Develop Metadata Management Principles and Procedures
- Reporting & Scoring & Trend Analysis of Data Modeling, Metadata Management, Data Governance , Old DWH Retirement , New DWH Prisma Usage , DWH Full Path Life Cycle
- Facilator of DataOps Teams
- Being SME of Data Governance, develop and deploy related processes and procedures, and establish a common understanding and visibility of data assets
- Being SME on the transformation of data/information from one format or medium to Another
- Being SME on Metadata Management workflows integrated with Change Management, SDLC
- Being SME of Test Data Management
- Vendor Management
- Enhanced picking and packing output through targeted team coaching and feedback.
- Minimised accidents and near misses with rigorous health and safety training.
- Enforced safety measures and proper use of PPE.
- Exceeded warehouse productivity targets with consistent operational oversight
Architecture / Dwh & BI and Legal Reporting
Garanti BBVA Technology
İstanbul, Turkey
01.2016 - 12.2017
- Define architecture of DWH , BI , Big Data and Legal Reporting projects
- Located deviations from standard operating procedures, understanding causes and preventing reoccurrence
- Control the quality and performance of the work done within the group and to inform about the solution method when necessary
- Drafted procedure manuals, work definitions and standard operating procedures by job title or work area
- Providing training to employees both within the group and for the company in ETL, Performance Tuning , Data Model, Business Intelligence Tools
- Product owner of Legal Reporting
- Helped organizations improve customer satisfaction and achieve measurable results
- Interviewed staff to obtain personal observations and insights into existing procedural strengths and weaknesses
- Mentoring new members of the team
- Incident/Problem/Change Management
Specialist / Dwh and Business Intelligence
Garanti BBVA Technology
İstanbul, Turkey
11.2007 - 12.2015
- Improved data access for stakeholders by designing and building data models.
- Develop projects in Db2 DWH and Oracle DWH
- Analyze the performance of jobs
- Prepare report or self servis BI platforms to end users as needed in SAP BO 5.1, 6.1 , XI or Oracle Business Intelligence ( OBIEE )
- Completed impact assessments to outline and implement necessary changes to drive business-wide improvements.
- Transformed raw data into actionable reports and recommendations, leading to measurable changes.
Mandatory, Military
Turkish Land Forces
İstanbul, Turkey
01.2007 - 11.2007
Software Developer
LBA Management Consulting
İstanbul, Turkey
04.2004 - 06.2006
- Prepare the necessary infrastructure at database level to deliver information to the end user in the fastest way possible, to make business intelligence tool integration on this structure on Microsoft Technology
- Wrote clean, clear and well-tested code for various projects
- Adopted various programming languages to best meet project demands
- Confirmed existing and new code met industry best practices and coding standards for maintainability
Education
Bachelor of Science - Computer Engineering
Istanbul Technical University
İstanbul / Turkey 09.2001 - 06.2006
Skills
- Data Warehouse
- Data Integration ( Oracle Data Integrator , Microsoft SSIS , Informatica, PL /SQL)
- ETL , ELT
- SQL , Advanced SQL
- Performance Tuning
- Data Modeling ( Kimball , Inmon and Data Vault )
- Business Intelligence & Reporting ( SAP BO , Oracle Business Intelligence , Qlik )
- Data Lineage ( ODI Lineage , Informatica Metadata Management)
- Data Quality
- Data Governance
- Metadata Management
- Data Discovery
- MIS
- DMBoK (DAMA Book of Knowledge)
- Database ( Db2 , Microsoft SQL Server, Oracle , Exadata )
- DataOps
- Agile / Scrum
- Incident / Problem Management
- Automation
- Legal Reporting (Turkey and BCBS239)
- Change Management
Languages
Turkish
Native
English
Fluent
Certification
- ITIL V4 Foundation Certificate in IT Service Management / PeopleCert
- Oracle Database 11g : Administration Workshop 1
- Oracle Database : Program with PL/SQL
- Oracle Database 11g : Performance Tuning
- Oracle BI Publisher 10g R3: Fundamentals
- Oracle BI Suite EE 10g R3: Build Repository
- Oracle BI Suite EE 10g R3: Create Reports and Dashboards
Big Projects
Prisma : Garanti BBVA Data Warehouse Reengineering
The name of our new data warehouse is PRISMA and I am leading this transformation in Global.
The achievements obtained with this study are fast and easy access to data, singularity of information, accessibility, historical depth, consistency, faster development and the model is made available to everyone, making information accessible and eliminating individual dependency.
Legal Reporting : Garanti BBVA Legal Reporting Infrastructure
Legal Reporting is service of all reports sent to government institutions from the system without touching.
I took part in this project as an expert developer and we designed the infrastructure that will automatically generate reports when a request is entered from the system during the day or at the end of the day . . This automation is using to prepare Turkey Legal Report and BCBS239 report.
Sample ; Trial balance , balance sheet formation infrastructure .
Oracle Data Inteagrator - ODI 10 to 12c Uprgade
Leading of Upgrading ETL Tool ODI 10G to 12c
Real Time C Level Monitoring Dasboard
It is a project to reconstruct the Bank's MIS screens, written in Collgen and opened to the upper management, with Business Intelligence Tools (OBIEE). In this way, the development speed has increased significantly, the demands of the bank's upper management can be met quickly and efficiency has been gained.
Data Lake : Garanti BBVA Data lake
It is a project where log, sensor, real time and DWH data from all systems are accumulated in the Big Data Environment.
Garanti Data Warehouse Migration Db2 to Oracle Exadata
In 2009, Garanti bought the first Oracle's Exadata machine in Turkey.
With this purchase, the project of moving the data warehouse in DB2 to Oracle started.
We were a team of 4 people, 2 developers 2 dba. At the end of 3 months, all tables in the mainframe were moved to Oracle Exadata as is
and all reports were made to be received from SAB BO 5.1.
Garanti Business Intelligence Migration Business Objects to OBIEE
All universes and reports in SAP BO 5.1 version, which is Garanti's Business Intelligence platform, have been migrated to OBIEE 10G infrastructure.
In-company OBIEE training was provided and new BI developers were recruited.
Garanti BBVA Credit Card Modelling
Data Modeling of DB2 credit card tables, by using IBM Banking Datawarehouse model.
ETL design was built on Data Capture.
Using Technology is Db2 ,Oracle Exadata ,Oracle Data Integrator ( ODI ) and Oracle Business Intelligence (OBIEE )
Intelligence (OBI) is used.
Additional Information
Oracle Open World 2015 - Participant
Oracle Event in Hungary 2013- Speaker: Garanti DWH Migration to Oracle Exadata
Oracle Event in Greece 2011- Speaker: Garanti DWH Migration to Oracle Exadata
Timeline
Manager / Data Warehouse
Garanti BBVA Technology
01.2018 - Current
Architecture / Dwh & BI and Legal Reporting
Garanti BBVA Technology
01.2016 - 12.2017
Specialist / Dwh and Business Intelligence
Garanti BBVA Technology
11.2007 - 12.2015
Mandatory, Military
Turkish Land Forces
01.2007 - 11.2007
Software Developer
LBA Management Consulting
04.2004 - 06.2006
Bachelor of Science - Computer Engineering
Istanbul Technical University
09.2001 - 06.2006