Okay ÇAKIR
Senior BI Applications Consultant
BIZCON Consulting
Kat 18 - 34758
Atasehir-Istanbul/Turkey
Mb. : +90-533-***-**-**
E : ****.*****@******.***.**
www.bizcon.com.tr
Profile
Okay Çakır, has started his career as a SAP-ERP module consultant in 2002 and has been
working on SAP Technologies since them. He is an expert of SAP Netweaver BI/BW
Platform including BI Business Content, BW Administrator Workbench, BW Query
Designer and Web Application Designer. He has experience in every phase of BI
Development Projects namely, business requirements analysis, BW data modeling &
development, BW reports design & deployment, BW system go-live activities and data
initialization, BW data load process chain design and deployment, BI analysis user
authorizations, data migration from legacy systems, training of report users. He has mainly
experience on BI analytics for SAP-ERP Logistics and Financial modules.
SAP Experience – Summary
- Worked extensively in BW/BI Development
- Worked on large scale SAP ERP&BI Projects
- Worked also as a SAP-ERP module consultant and ABAP development designer
- Worked in legacy to BW data migration projects
- Designed and developed data modelling for SAP BI/BW
- Designed and developed BW objects for SAP ERP Logistics and Financial modules.
- Designed and developed extensive BW Reports for Logistics and Financial business
processes
- Designed and developed KPI reports for Sales&Distribution business processes
- Designed and developed BI user analysis authorization model
- Participated in BI/BW system performance enhancement activities
- Participated in end-user BI training and support activities
Professional Experience & Certifications – Summary
- C_TBW45_70 SAP CERTIFIED APPLICATION ASSOCIATE-BUSINESS
INTELLIGENCE WITH SAP NETWEAVER 7.0 (17.11.2009)
- SAP BI/BW Senior Consultant in Infobiz / BIZCON Consulting Co.
- SAP BI/BW Senior Specialist in AVEA Telecom A.Ş.
- SAP BI/BW Specialist in B/S/H/ A.Ş.
- SAP ERP HR & Training Module Senior Consultant in HAVELSAN A.Ş.
- Software Engineer at NORTEL Networks A.Ş.
- Research Assistant at Boğazici University - E&E Department
- Graduated from Boğazici Universiy Electrical & Electronics Engineering (B.S.)
SAP Projects
Customer THY, Istanbul, TR (http://www.thy.com.tr)
Duration 07.2013 – ongoing
Sector Airlines
Project Definition ERPlane BPB (Business Planning and Budgeting) Project
Role in Project SAP BI / BW Senior Consultant (HR, CO-PA and BPC modules)
-
Responsibility Analysis of Budget Department Reports
- Analysis of CO-PA, BPC, HR-PA,PY and HR-PCP data
model in BW
- BBP Documentation for BPB Reports
- Design of Infoproviders for Budget&Actual Reports
- Development of Infoproviders for BPB Reports
- Development of Queries for BPB Reports
Customer EnerjiSA, Istanbul, TR (http://www.enerjisa.com.tr)
Duration 11.2013 – ongoing
Sector Energy Utilities
Project Definition Profitability Project
Role in Project SAP BI / BW Senior Consultant (IS-U module)
-
Responsibility Support for BW modelling and development in IS-U PA
Project
Customer THY, Istanbul, TR (http://www.thy.com.tr)
Duration 10.2012 – 07.2013
Sector Airlines
Project Definition ERPlane Project
Role in Project SAP BI / BW Senior Consultant (FI-TRM/FM/IM/Bank modules)
-
Responsibility Analysis of FM/IM/Bank Report’s Requirements - BBP
- Activation & Development of BW FI-FM/IM/Bank Data
Model
- Development of FM/IM/Bank BW queries & reports
Customer A101, Istanbul, TR (http://www.a101.com.tr)
Duration 02.2012 – 08.2013
Sector Retail Sale
Project Definition BW LSA Data Model Enhancement Project
Role in Project SAP BI / BW Senior Consultant (IS-R & Logistics MM, SD, PUR modules)
-
Responsibility Analysis of IS-R Reports Requirements
- Development of BW IS-R LSA Data Model
- Re-Development of IS-R BW Reports on LSA Data
Model
Customer EFES, Istanbul, TR (http://www.efespilsen.com.tr/)
Duration 11.2012 – 01.2013
Sector Beverage
Project Definition BW QM Report’s Project
Role in Project SAP BI / BW Senior Consultant (ECC QM module)
-
Responsibility Analysis of QM Notifications Report Requirements
- Activation & Development of BW QM Notifications Data
Model
- Development of BW QM Notifications queries & reports
Customer EFES, Istanbul, TR (http://www.efespilsen.com.tr/)
Duration 02.2012 – 08.2012
Sector Beverage
Project Definition “Extract Loss Calculation Tool” Workbook Project
Role in Project SAP BI / BW Senior Consultant (Logistics MM, QM, PP modules)
-
Responsibility Analysis of “Extract Loss Calculation Tool”
- Development of BW Logistics MM, Batch Management,
QM, PP Data Models
- Development of “Extract Loss Calculation Tool”
Workbook
Customer YEDAŞ, Samsun, TR (http://www.calikyedas.com)
Duration 11.2011 – 04.2012
Sector Utilities – Electricity Distribution
Project Definition SAP IS-Utilities Project
Role in Project SAP BI / BW Lead Consultant (IS-U)
-
Responsibility Analysis of IS-U Report Requirements
- BW IS-U Conceptual Design & BBP Documentation
- BW IS-U LSA Data Modelling & Development
- DM, B&INV, FI-CA module reports design &
development
Customer Başkent Elektirik, Ankara, TR (http://www.enerjisa.com.tr)
Duration 04.2010 – 10.2011
Sector Utilities – Electricity Distribution
Project Definition SAP IS-Utilities Project
Role in Project SAP BI / BW Lead Consultant (IS-U)
-
Responsibility Analysis of IS-U Report Requirements
- BW IS-U Conceptual Design & BBP Documentation
- BW IS-U LSA Data Modelling & Development
- DM, B&INV, FI-CA module reports design &
development
- Go-live support
Customer T.E.K.B., İstanbul, TR (http://www.tekb.org.tr/)
Duration 03.2010 – 11.2011
Sector Pharmaceuticals (Wholesale)
Project Definition ECC Project
Role in Project SAP BI / BW Lead Consultant (Logistics SD, MM, PUR, LO & Finance
Modules)
-
Responsibility Analysis of Reports Requirements
- BW Conceptual Design & Documentation
- BW Logistics & Finance LSA Data Modelling &
Development
- Logistics & Finance Modules: Reports Design &
Development
Customer IATCO, Jeddah, KSA (http://www.iatcom.com/)
Duration 11.2009 – 04.2010
Sector Transportation
Project Definition ECC & TM Project
Role in Project SAP BI / BW Consultant (Logistics TM & SCEM)
-
Responsibility Analysis of TM & SCEM KPIs
- BW TM & SCEM Data Modelling
- KPI Reports Design & Development
- TM BW Upload Customisations
Customer Ipragaz, İstanbul, TR (http://www.ipragaz.com.tr/)
Duration 09.2009 – 12.2010
Sector Oil & Gas
Project Definition “General Sales Reports” Workbook - Revision
Role in Project SAP BI / BW Consultant (Logistics SD)
-
Responsibility Revision of BW SD Reports
- Revision of BW SD Data Modelling
- “General Sales Reports” Workbook Design &
Development
Customer DEVA, İstanbul, TR (http://www.deva.com.tr)
Duration 08.2009 – 11.2009
Sector Pharmaceuticals (Production)
Project Definition DevasaProject
Role in Project SAP BI / BW Consultant (Finance Modules)
-
Responsibility BW FI-CO EhP3 & EhP4(FI-GL, FI-AR, FI-AP, CO-PC,
CO-CCA) Implementation
- BW CO-PA Implementation
- BW FI-CO Reports design & development
Customer DYH, İstanbul, TR (http://www.doganegmont.com.tr/)
Duration 04.2009 – 02.2010
Sector Media & Publishing
Project Definition Doğan Egmont BW Project
Role in Project SAP BI / BW Consultant (Logistics & FI)
-
Responsibility BW Purchasing, Stock and Sales report requirements
analysis
- BW Purchasing, Stock and Sales data modelling and
developments
- BW Report design & development
Customer ABank, İstanbul, TR (http://www.abank.com.tr/)
Duration 01.2009 – 09.2009
Sector Finance
Project Definition Budget Planning Project
Role in Project SAP BI / BW Lead Consultant
-
Responsibility BW plan and actual data modelling
- BW update structure developments of plan and actual data
- BW plan/actual masterdata modelling and update
- BW development of plan/actual comparison reports
Customer Tofaş, Bursa, TR (http://www.tofas.com.tr)
Duration 11.2008 – 12.2008
Sector Automative
Project Definition TOFAS Management Cockpit
Role in Project SAP BI / BW Consultant (FI)
-
Responsibility KPI analysis and cockpit modelling
- BW business content activation
- KPI data modelling and developments
- Development of KPI queries and reports
Customer ERDEMİR, Ereğli, TR (http://www.erdemir.com.tr/)
Duration 08.2008 – 12.2008
Sector Steel & Iron Works
Project Definition KKPP – Enterprise Resource Planning Project
Role in Project SAP BI / BW Lead Consultant (All Modules)
-
Responsibility Analysis of Report Requirements for Erdemir Business
Processes
- BW - Business Content Activation
- BW - Data Modeling and Development
- BW - Reports Design & Development
Customer ÜLKER, İstanbul, TR (http://www.ulker.com.tr)
Duration 07.2008 – 06.2009
Sector Fast Consuming Goods (Food)
Project Definition SAP BI Project
Role in Project SAP BI / BW Consultant (Logistics)
-
Responsibility Analysis of Report Requirements for Ulker SD&CO&PP
Processes
- Data Modelling and Development in BW
- Multi-Provider Design&Development in BW
- CO-PC Reports Design & Development in BW
- PP Reports Design & Development in BW
- SD Reports Design & Development in BW
-
Customer AVEA, İstanbul, TR (http://www.avea.com.tr/)
Duration 03.2008 – 07.2008
Sector Mobile Telecom
Project Definition Purchase Project
Role in Project SAP BI / BW Specialist (SRM)
-
Responsibility KPI Analysis of AVEA Puchasing Process
- Analysis of Report Requirements for AVEA SRM Process
- BW - SRM&PUR Module: Activation of Business
Content
- BW - SRM&PUR Module: Modifications of Business
Content
- BW - SRM&PUR Development of New BI Objects
- Data Sources Design&Development in SAP SRM & ERP
- SRM&PUR Reports Design & Development in BW
- SRM&PUR Reports Analysis Authorisations in BW
- BW - SRM&PUR Initial Data Updates
- BW - SRM&PUR Periodic Data Update Process Chains
- Key Users Training&Support
-
Customer AVEA, İstanbul, TR (http://www.avea.com.tr/)
Duration 07.2007 – 03.2008
Sector Mobile Telecom
Project Definition BI – FICO & RMCA Project
Role in Project SAP BI / BW Specialist (FICO-FICA-RMCA)
-
Responsibility Analysis of Report Requirements for AVEA FICO &
RMCA Process
- BW - FICO & RMCA Module: Activation of Business
Content
- BW - FICO & RMCA Module: Modifications of Business
Content
- BW - FI Module: Development of New Objects for IFRS
Reporting
- BW - FI: Development of New Objects for Special Ledger
Reporting
- Data Sources Design&Development in SAP ERP FICO &
RMCA Module
- FICO & RMCA Reports Design & Development in BW
- FICO & RMCA Reports Analysis Authorisations in BW
- BW - FICO & RMCA Initial Data Updates
- BW - FICO & RMCA Periodic Data Update Process
Chains
- Key Users Training&Support
-
Customer AVEA, İstanbul, TR (http://www.avea.com.tr/)
Duration 07.2007 – 12.2007
Sector Mobile Telecom
Project Definition OGER Consolidation Project
Role in Project SAP BI / BW Specialist (FI)
-
Responsibility Analysis of OGER Financial Consolidation Requirements
- Design & Development of Avea BW – FI Consolidation
Structure
- Revision and Modifications of AVEA BW - FI Structure
- Design & Development of Consolidation Control Reports
- Data Sources Development for SEM-BCS Consolidation
System
- Data Migration of Previous Year’s Data for OGER
Consolidation
-
Customer B/S/H/, Istanbul/Munich, TR/DE (http://www.bsh-group.com.tr/)
Duration 01.2006 – 07.2007
Sector Electrical Home Appliances
Project Definition weBSH.net Project Turkey Roll-out
Role in Project SAP BI / BW Specialist (SD)
Responsibility KPI Analysis and Report Requirements of BSH Sales Process
BW - SD Module: Activation and Modifications of Business Content
BW - SD Module: Design & Development of New Objects
SD Reports Design & Development
Authorization Developments of SD Reports
Data Migration of Previous SD Data into BW
Developments for Integration to non-SAP CRM System
Integration of Sales Data to QPR(Sales Performance System)
BW - SD Initial Data Updates
BW - SD Periodic Data Update Process Chains
End-Users Training&Support
-
Customer Turkish AIR-FORCE, Ankara, TR (http://www.hvkk.tsk.tr)
Duration 11.2002 – 12.2005
Sector Aerospace & Defense
Project Definition HvBS – ERP Project
Role in Project SAP HR - PD Consultant
Responsibility AS-IS and TO-BE Analysis of TuAF HR &Training Processes
SAP HR Module Customization
Gap-Analysis and Design of HR-PD Module Developments
Documentation of Development Spec Sheets
Test and Change Requests for Module Developments
Design & Development of Integration to 3rd Party Planning Tools
BPM & BPO Acceptances Tests
Development of HR Module Authorizations
Correction and Data Migration of Previous HR Data into SAP R/3
Key User Training & Support
Professional Experience & Certificates – Detail
Bizcon Consultancy Co. Feb 2012 - now SAP BI / BW Lead
Consultant
IBM Global Services Nov 2011 – Feb 2012 SAP BI / BW Lead
Consultant
Bizcon Consultancy Co. Feb 2009 – Nov 2011 SAP BI / BW Senior
Consultant
SAP BI / BW Senior Consultant
Infobiz Consultancy Co. July 2008 – Feb 2009
SAP BI / BW Senior Specialist
AVEA Telecom A.Ş. April 2007 – July 2008
SAP BI / BW Specialist
B/S/H/ A.Ş. October 2005 – April 2007
SAP HR Senior Consultant
HAVELSAN A.Ş. November 2002 – October
2005
Software Engineer
NORTEL Networks A.Ş. January 2000 – November
2001
Boğaziçi University Research Assistant
July 1997 – January 2000
Personal Information
- B.S. Degree
Education
- Boğaziçi University Electrical &
Electronics Engineering Department –
Telecommunications Option
- Lycee: H.A.S. Uskudar Anatolian
School – Math option
Marial Status Married
Nationality Turkish
Date of Birth 04.05.1974
Languages Turkish (Native)
English (Fluent)
German (Basic)