Umut Gülac-Freelancer

Managed end-to-end full renovation (budgeting, permitting, contractors, timeline), rented out and achieved 10%+ rental yield upon completion.

• Germany Market Leader Telco: Deutsche Telekom – BI Framework: As Data Modeler & Designer modelled DMs using Innovator by analyzing various data sources and Kafka topics as well, and then transferred design to development team.
• Global Pharma: MSD – DWH Re-engineering on AWS Redshift w/ Matillion: AWS Data Architect integrating with IQVIA, implemented required PostgreSQL scripts and Matillion jobs.
• Global Pharma: Merck KGaA – Batch DB Re-engineering on MS SQLDB w/ SSIS: As MS Data Architect reconfigured the MS SQL Server DB Landscape to re-engineer integration of MS SQL Server based Badge DB with SAP clients Materials (PIM) module over MS SSIS.
• Global Tire Manufacturer: Continental – IT Operations AI Engine on AWS w/Knime: As AI Solution Architect engineered an AI based Recommendation Engine on top of AWS S3 Buckets.
• Global Telco: Telefonica – Splunk Governance: As Solution Architect & Project Manager re-engineered the Splunk transform.
• Global Energy Retailer: EON – E-Commerce AI Assessment: As Azure Data Architect designed the migration of ERP data on to SQL Server Service on Azure.

• Retail Distributor of Procter & Gamble: Aykanlar Group – Enterprise DWH and Reporting w/ ADF: Design and implemented DWH on Azure SQL DB by Azure Data Factory. Migration of legacy ERP Data on SQL Server On-Premises to Azure. Sales, Stock, and Financial Reporting by PowerBI.
• Leading Airlines: Turkish Airlines – Data Governance Reporting: Installation and configuration of Cognos Analytics RedHat environments, and integration of THY CRM and Campaign Management systems based on IBM MDM & PIM and Unica. Customization of Cognos package and reports compliant to THY Master Data Model. Training given for Cognos Connection, Report Studio, and Framework Manager.
• Start-Up E-Commerce: Vivense – Open Source DWH: Designed and implemented an enterprise DWH over on-premises MySQL DB built on data unification and integration solutions by open-source tools (Talend DI) by enterprise reporting over Cloud (PowerBI). Designed a Digital E-Commerce DataMart over Google Analytics, Facebook, RTBHouse, Criteo, Ligatus Analytics. Training given for MS Power BI and Query Editor.
• Textile: Lufian – Power BI Training: Training given for MS Power BI, SSRS, SSAS. Re-designed MS SQL Server landscape to integrate with MS SSAS. Configured MS SQL Server for HA & DR.
• Leading Manufacturing: Pladis (Godiva – United Biscuits) – Master Data Management: MDM Architect & Data Modeler on Informatica MDM and PIM for Customer, Material, Product Planning, Vendor and Chart of Accounts domains w/ HCL UK. I designed master data migration with DQ and DI from 10 sources (5 SAPs, 2 Oracle based App, AS400, 2 file sys). Application Integration Architect guiding design of IBM IIB web service interfaces consuming MDM. Reconfigured MS SQL Server landscape and DB instances for HA & DR of MDM systems.
• Leading E-Commerce: n11.com – DWH BI Reengineering Roadmap: BI (Data Integration, Warehousing, Reporting) Architect & Enterprise Architect.
• American Emerging Telco: Smart Telecom – Enterprise DWH (Uganda): Lead Architect & Data Warehouse Modeler as IBM TDW SME.
• Internal BA Technology Products: Built a Company Registration Check Web Service on Cloud based on C# and JS. Built a low-cost Retail DWH (SQL Server, MySQL) as a Service on Cloud (Azure).

• Global Telco: Vodafone – Ceylan (Genesys) Program: Led DWH Integration & Reporting Stream. Data Integration Architect for design and offshore development of DWH Integration. Training of designed innovative data integration solution with a discard-resend queue mechanism. Scope included Siebel CRM, Kenan Billing, Data Model, Billing/Account, Asset & Contact Services, Payment System, Service Requests Mediation System, CDRs, Order Management, and Dunning System.
• Market Leading Bank: Yapi Kredi Bank – Open World: Analyses and design of merchant operations for credit card system. Data Architect for analysis and design of Conceptual and Logical data model of a normalized operational DB. Data Integration with DWH and data migration of legacy system sequential files to operational DB.
• Emerging Telco: Avea – Campaign Management Analytics: Customization of OoB ETL processes extracting from Oracle CRM Marketing to OBAW by Informatica. Training given for Reporting by OBIEE.
• Emerging Telco: Wind Infostrada – Phoenix Analytics (Rome, Italy): Implementation of fully custom ETLs creating OBAW by Informatica and DAC. Design and implementation of Oracle BI Repository, Answers & Dashboards for the new operational reporting system from legacy CRM platform.
• Emerging Telco: Vodafone – Integrated Desktop Solution for Call Centre: Analysis of legacy call center applications; and comparison of candidate products: Jacada & MS CCF.
• Market Leader Telco: Turk Telekom – IPTV Solution: Preparation of the solution covering SDP, Content Management & Protection, Broadcast Streaming, STB, Home Gateway, Network Management Platform, SPE Management, IPTV Probes QoS, and DSL Lines.
• Emerging Telco: Avea – 3G Transition Organizational Assessment: Assessment methodology to measure skills required for 3G operations and headcount sizing for 3G transition.
• Market Leader Telco: Turkcell – SDP: Design and implementation of synchronous BPEL processes with extensive usage of PL/SQL, XML and required technologies for SDP including SO. Training of company and client team on development.

• Managed and executed 2 research projects in Automobile and FMCG market by 4 interviewers employed.