Profileimage by Ersoy Ozcan BI & CPM Consultant, BI & CPM Consultant, BI Consultant from Istanbul

Ersoy Ozcan

available
Contact

Last update: 12.05.2022

BI & CPM Consultant, BI & CPM Consultant, BI Consultant

Company: Infology Bilisim
Graduation: Industrial Engineering, Bogazici University
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

en_ersoy_ozcan.pdf

Skills

Studio, WebIntelligence, SAP, SAP NetWeaver 7.0, SAP Certified Application Associate, SAP HANA, data transfer, data structure, data structures, MS SQL, ABAP, DB, ERP, CRM, SAP BW, FI, web services, coding, Telecommunication, POSDM, Analytics, NLS, Sybase IQ, HANA, SAP NetWeaver

Project history

05/2020 - 05/2022
Lead BI Consultant
ÇEKOK Gıda A.Ş.
Industry Farm Products
Project Description BW Project
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for ECC Logistics (MM,SD,PUR)
Deliverables LSA BW Model Development for ECC FI Modules
BEx Reporting
Process chain definitions

01/2020 - 05/2022
Lead BI Consultant
Customer ADEL Kalemcilik
Industry Consumer Goods
Project Description BW Project
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for ECC Logistics (MM,SD,PUR)
Deliverables LSA BW Model Development for ECC FI Modules
BEx Reporting
Process chain definitions

10/2018 - 05/2022
Lead BI Consultant
Lila Kağıt A.Ş.
Industry Tissue
Project Description BW Project - Maintenance - Support
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for ECC Logistics (MM,SD,PUR)
Deliverables LSA BW Model Development for ECC FI Modules
BEx Reporting
Process chain definitions

10/2016 - 05/2022
Business Analytics Consultant - Managing Director
Infology Bilişim

01/2016 - 05/2022
Lead BI Consultant
Şen Piliç
Industry Chicken Meat




Project Description BW Project
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for ECC Logistics (MM,SD,PUR)
Deliverables LSA BW Model Development for ECC FI Modules
Non-SAP BW Modelling
CDS Modelling
Hana Modeling
BEx Reporting
Process chain definitions

02/2015 - 05/2022
Senior BI Consultant
CarrefourSA
Industry Retail
Project Description BW (POSDM) Project - Maintenance - Support
Role Senior BI Consultant
Responsibilities/ LSA BW on HANA Model Development
Deliverables Reporting
Process chain monitoring

10/2011 - 05/2022
Senior BI Consultant
Industry Beverage
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ Source System Definition / Control
Deliverables SAP System copy post-actions
Data Loading

10/2011 - 05/2022
Senior BI Consultant
Customer Oger Telecom
Industry Telecommunication




Project Description Support
Role Senior BI Consultant
Responsibilities/ BI Statistics
Deliverables

04/2011 - 05/2022
Senior BI Consultant
Brisa Bridgestone Sabancı Lastik Sanayi ve Ticaret A.Ş.
Industry Tire Manufacturing




Project Description BW Project
Role Senior BI Consultant
Responsibilities/ Logistic module modeling
Deliverables

02/2011 - 05/2022
Senior BI Consultant
Yıldızlar Holding
Industry Forestry Products
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ Broadcasting
Deliverables

08/2010 - 05/2022
Senior BI Consultant
Dogan Media Holding
Industry Media
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ Modeling info-providers via web services
Deliverables ABAP coding related to modeling

11/2020 - 05/2022
BI QA Consultant
Customer UNO (1000-5000 employees)
Consumer goods and retail
Industry Consumer Goods
Project Description BW Project
Role BI QA Consultant
Responsibilities/ BW model Analysis
Deliverables

04/2019 - 12/2020
Lead BI Consultant
A101
Industry Retail
Project Description BW (POSDM) Project - HEC Platform
Role Lead BI Consultant
Responsibilities/ LSA BW Data Model Development for IS-Retail (POS Analytics)
Deliverables HANA Modelling
Non-SAP Modelling
CDS Modelling
Data Loading, monitoring
APD
BEX reporting
Process chain definitions

10/2016 - 11/2020
Lead BI Consultant
Ziylan Mağazacılık ve Pazarlama A.Ş. (FLO)
Industry Retail
Project Description BW (POSDM) Project - Maintenance - Support
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for IS-Retail (POS Analytics)
Deliverables LSA BW Model Development for ECC Logistics (MM,SD,PUR)
LSA BW Model Development for ECC FI Modules
BEx & BO Reporting
Process chain definitions

08/2015 - 09/2016
Business Analytics Consultant - Managing Director
Analytica Bilişim A.Ş.

02/2015 - 08/2015
Business Analytics Consultant - Managing Partner
Advis Consulting

01/2014 - 02/2015
Senior BI Consultant
CarrefourSA
Industry Retail
Project Description BW (POSDM) Project
Role Senior BI Consultant
Responsibilities/ LSA BW on HANA Model Development for IS-Retail (POS Analytics)
Deliverables LSA BW on HANA Model Development for ECC Logistics
(MM,SD,PUR)
LSA BW on HANA Model Development for FI modules
Reporting

10/2012 - 02/2015
Senior BI Consultant
A101
Industry Retail
Project Description BW (POSDM) Project
Role Senior BI Consultant




Responsibilities/ LSA BW Data Model Development for IS-Retail (POS Analytics)
Deliverables Data Loading, monitoring
NLS - Near Line Storage (Sybase IQ)
Data Archiving (NLS)
APD
BEX reporting
Process chain definitions

10/2012 - 02/2015
Senior BI Consultant
Customer Tuborg
Industry Beverage
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ nonSAP Modeling
Deliverables Development of data structures
BEX Reporting
Process chain definitions

02/2014 - 02/2015
Business Intelligence, Logistics Reporting Unit Manager
Acron Consulting

10/2014 - 01/2015
Lead BI Consultant
Ziylan Mağazacılık ve Pazarlama A.Ş. (FLO)
Industry Retail
Project Description BW (POSDM) Project
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for IS-Retail (POS Analytics)
Deliverables LSA BW Model Development for ECC Logistics (MM,SD,PUR)
LSA BW Model Development for ECC FI Modules
BEx & BO Reporting
Process chain definitions

04/2014 - 09/2014
Lead BI Consultant
Beğendik Mağaza İşletmeleri
Industry Retail
Project Description BW (POSDM) Project
Role Lead BI Consultant
Responsibilities/ LSA BW Model Development for IS-Retail (POS Analytics)
Deliverables LSA BW Model Development for ECC Logistics (MM,SD,PUR)
LSA BW Model Development for ECC FI Modules
BEx & BO Reporting
Process chain definitions

05/2013 - 04/2014
Senior BI Consultant
Customer
Industry Beverage
Project Description BI-IP Project - Contract Simulation
Role Senior BI Consultant




Responsibilities/ nonSAP Modeling
Deliverables BEX Reporting

01/2013 - 03/2014
BI Lead Consultant
Terzioğlu Holding
Customer Terzioğlu Holding, Istanbul
(APS, International Carpet Investment Industry)
Duration Jan 2013 - Mar 2014
Industry Packaging / Carpet Manufacturing
Project Description BW Project
Role BI Lead Consultant
Responsibilities/ FI-CO modules modeling
Deliverables Logistics modules modeling(SD,MM,PP)
BEX reporting
Process chain definitions
Trainings (SAP BW Modeling, BEx Reporting)

12/2013 - 02/2014
Senior Business Intelligence Applications Consultant
Acron Consulting

10/2013 - 01/2014
Senior BI Consultant
Türk Traktör ve Ziraat Makinaları A.Ş.
Industry Machinery Marketing
Project Description CS Reporting Project
Role Senior BI Consultant
Responsibilities/ CS Modeling
Deliverables Development of data structures(cubes, multiproviders)
Reporting

05/2013 - 12/2013
Senior BI Consultant
Borcelik
Industry Steel
Project Description BW Enhancement Project
Role Senior BI Consultant
Responsibilities/ Migration of the 3.x structures to 7.x structures
Deliverables Transforming data flow (transfer ruses, update rules to
transformations)
Changing process chains accordingly
Data control

08/2010 - 12/2013
Senior Business Intelligence Applications Consultant
Bizcon Consulting

09/2012 - 04/2013
Senior BI Consultant
Customer Çimsa
Industry Cement Industry
Project Description BW Project
Role Senior BI Consultant
Responsibilities/ HR Modeling
Deliverables BEX Reporting
Process chain definitions

01/2007 - 01/2013
Senior BI Consultant
Borusan Holding
Industry Holding
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ System monitoring
Deliverables Authorization
Support

11/2011 - 12/2012
BI Lead Consultant
Kerim Celik
Industry Steel
Project Description BW / BO Project
Role BI Lead Consultant
Responsibilities/ FI & Logistics modules modeling
Deliverables BEX reporting
Process chain definitions
WebIntelligence Reporting
Dashboard Design

08/2010 - 12/2012
Senior BI Consultant
Enka Marketing
Industry Machinery Marketing
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ Logistic module modeling
Deliverables Preparing BEx reports
Monitoring data transfer processes
Support

11/2011 - 09/2012
BI Lead Consultant
Enka Marketing
Industry Machinery Marketing
Project Description BI Reporting / BO Reporting
Role BI Lead Consultant
Responsibilities/ FI & Logistics modules modeling
Deliverables nonSAP modeling
BEx reporting
Process chain definitions
WebIntelligence Reporting

06/2012 - 07/2012
Senior BI Consultant
Customer Ipragaz
Industry Gas/Energy
Project Description PM/CS Project
Role Senior BI Consultant
Responsibilities/ PM/CS Modelling
Deliverables BEX reporting
Process chain definition
Loading data to structures

07/2011 - 05/2012
Senior BI Consultant
Türk Traktör ve Ziraat Makinaları A.Ş.
Industry Machinery Marketing
Project Description BW Project
Role Senior BI Consultant
Responsibilities/ Modeling
Deliverables Reporting

01/2007 - 01/2012
Senior BI Consultant
Borcelik
Industry Steel
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ System monitoring
Deliverables ABAP development
Authorization
nonSAP system integration(UDConnect, DB Connect)
Support
BW & ECC Migration / Post Migration Processes

08/2011 - 12/2011
Senior BI Consultant
D-Smart
Industry Digital Platform
Project Description CRM Project
Role Senior BI Consultant
Responsibilities/ Analysis of the used CRM systems
Deliverables

03/2011 - 11/2011
Senior BI Consultant & BO Cunsultant
Borusan Makina Servis ve Ticaret A.Ş.
Industry Machinery Marketing
Project Description BW / BO Dashboard Project
Role Senior BI Consultant & BO Cunsultant
Responsibilities/ Modeling (SAP, nonSAP)
Deliverables BEx Reporting
Xcelsius Dashboard Design

09/2010 - 08/2011
Senior BI Consultant
Arcelik
Industry White Goods and Electronics
Project Description Maintenance - Support
Role Senior BI Consultant
Responsibilities/ FI & logistics modules modeling
Deliverables nonSAP system modeling & reporting
Broadcasting
Monitoring data transfer processes
Reporting
Support

08/2010 - 07/2011
Senior BI Consultant
Industry Distribution
Project Description ERP, CRM, TM Project
Role Senior BI Consultant
Responsibilities/ ECC, CRM reporting
Deliverables Logistic module modeling on SAP BW

01/2006 - 12/2010
Business Intelligence Applications System Analyst
Borcelik
SAP Certification (2011) SAP Certified Application Associate - Business Intelligence
with SAP NetWeaver 7.0 - (C_TBW45_70)
SAP Certification (2014) SAP Certified Application Associate (Edition 2014) - SAP
HANA (C_HANAIMP141)

01/2007 - 07/2010
BI Consultant
Borcelik
Industry Steel
Project Description BW Project




Role BI Consultant
Responsibilities/ Modeling of data structures in BW
Deliverables nonSAP system(MS SQL) integration via UDConnect
Development of source system data sources (MS SQL)
Reporting of Production and Quality departments
Support

08/2009 - 05/2010
BI Consultant
Borcelik
Industry Steel
Project Description Financial Affairs - Executive Reporting
Role BI Consultant
Responsibilities/ Modeling of data structures in BW
Deliverables Designing actual and target comparison reports
Support

10/2008 - 06/2009
BI Consultant
Borcelik
Industry Steel
Project Description Funds Flow
Role BI Consultant
Responsibilities/ Preparing BEx reports
Deliverables Monitoring data transfer processes
Performance improvement
Support

07/2007 - 02/2008
BI & CPM Consultant
Customer Borcelik
Industry Steel
Project Description SEM-CPM / Management Cockpit
Role BI & CPM Consultant
Responsibilities/ Development of Management cockpits for different departments
Deliverables (General Manager, Production, Supply Chain Management, Sales and
Marketing, Financial Affairs and Human Resource)
Modeling of data structure(Cube, DSO, Multiprovider)
Preparation of necessary BEx reports for KPIs

02/2007 - 02/2008
BI Consultant
Customer Borcelik
Industry Steel
Project Description Budget
Role BI Consultant
Responsibilities/ Preparation of BEx reports
Deliverables Process chain definitions
Definition of source systems
Data transfer processes monitoring
Support

01/2007 - 05/2007
BI & CPM Consultant
Borcelik
Industry Steel
Project Description SEM-CPM / Balanced Scorecard
Role BI & CPM Consultant




Responsibilities/ Development of Balanced Scorecards for different departments
Deliverables (General Manager, Production, Supply Chain Management, Sales and
Marketing, Financial Affairs and Human Resource)
Modeling of data structure(Cube, DSO, Multiprovider)
Preparation of necessary BEx reports for KPIs
Design of BPS manual input layouts for target values

Contact form

Contact details