Ömer Faruk Özsakarya

Working as a senior data warehouse developer in the PWA Data Warehouse Project

- Worked as a data engineer in the cross-marketing big data project.
- Sony Japan cancelled the project and closed the related units in the UK, Japan and Turkey at the end of March 2018
- Developed the data lake by using Apache Spark and Scala
- Release/Deployment management by using Git and Bamboo
- Followed Scrum methodology via Confluence and Jira
- Technology Stack: Apache Spark, Scala, Git, Bamboo (7 months)

- Worked as a data warehouse modeller in the data warehouse reengineering project
- Developed data marts by using Oracle Data Integrator
- Solved performance problems of the legacy data warehouse flows (ETL runtime duration decreased two hours on average)
- Developed and maintained PL/SQL packages
- Technology Stack: Oracle Data Integrator, Oracle PL/SQL, Sap Business Objects (2 years)

- Parsed system monitoring logs via Python and load them to Postgres for the data science team
- Designed a data lake for the beIN Media Asian-Pacific countries by using Aws EMR (Apache Hive, Apache Sqoop, Aws S3, Aws Oracle RDS, Aws MySql RDS, DynamoDB)
- Designed Looker reports (LookML code and reports)
- Worked as a business analyst in the clickstream analytics project
- Designed Apache NiFi pipelines in order to decrease churn rates
- Technology Stack: Apache Hive and Sqoop (1 year), Python (3 months), Looker (3 months), Apache NiFi (3 months)

• Client: Vodafone

- Implemented data marts by using Oracle Data Integrator (ODI)
- Migrated OLTP systems’ log records into the data warehouse by using Oracle PL/SQL
- Technology Stack: Oracle Data Integrator, Oracle PL/SQL (1 year)

• Client: AvivaSA

- Designed data warehouse model and ETL life cycle
- Developed Oracle PL/SQL packages for hand shaking with the OLTP systems
- Technology Stack: Sap Data Services, Oracle PL/SQL (1 year 3 months)

- Gathered and analyzed business requirements
- Implemented business intelligence projects by using Sap Business Objects
- Technology Stack: Sap Business Objects, PL/SQL (1 year 7 months)

• Consultant in British American Tobacco

Designed and implemented CRM projects by using Oracle PL/SQL
Designed reports by using Sap Business Objects
- Technology Stack: Sap Business Objects, Oracle PL/SQL (2 years)

• C# Developer

Developed different modules of Vision Plus Sales Automation System
- Technology Stack: C#, ASP .Net, Oracle PL/SQL (1 year 7 months)