Samed Ertugrul Email & Phone Number

Istanbul, Turkey

Istanbul, Turkey

Principal BI Analyst for very large scale analytics, stream processing, data visualization and data mining projects. Mainly responsible for creating and managing functional specifications DWH creations and/or data migration projects. Creating and managing test scenarios for data migrations and/or data quality. Configuring data models for BI Tools (Tableau, SAP BO etc.)• Istanbul Stock Exchange Big Data Project – Project Lead• Istanbul Grand Airport Data Driven Airport Assessment Project – Project Lead• Istegelsin DWH Project (Pusula) – Project Lead• Sahibinden.com DWH Re-engineering – Project Lead• Belbim DWH Project – Project Lead• Istanbul Metropolitan Municipality Project – DWH Engineer• Turkish Telecom Land Line Data Migration Project – Reporting Lead• Turkish Telecom Broadband Data Migration Project – Reporting Lead

Istanbul, Turkey

Sr. Product Definition Analyst for Loyalty Management System of Amadeus. Mainly responsible of product definition analysis and documentation standards of Amadeus Loyalty Management System data integration tools. Creating product specifications, testing scenarios, handover documents and user guides for all data integration products of Amadeus. Provides trainings to technical and business groups. Assists with the MS Sharepoint management portal of Istanbul office. Works in collaboration with related teams at Nice/France which is headquarter of R&D division. Hands on experience with SOAP UI, Jira, Confluence, MS Sharepoint and Winapproach.

Istanbul, Turkey

Worked as BI analyst for Turkcell. Mainly responsible DWH design and business analyst at different projects of Turkcell such as near real time Network Monitoring Dashboards projects, 4,5G readiness and Network Management Systems reporting projects. Configured ETL development procedures for Oracle ODI, designed dashboards and reports via IBM Cognos and Microstrategy tools, designed mobile dashboard for Iphone Ipad and Android platforms, data modelling and testing scenarios.Hands on experience with IBM Cognos, Microstrategy, Oracle ODI, Oracle OWB, Sybase IQ, Teradata, IBM Maximo and Sybase Power Designer.

Istanbul, Turkey

Worked as outsource BI analyst/developer for Turkcell. Worked in Network Control Center Dashboard and Mobile Dashboard projects of Turkcell. Configured ETL development procedures for Oracle ODI, designed dashboards via IBM Cognos, designed mobile dashboard for Iphone, Ipad and Android platforms, data modelling scenarios. Hands on experience with IBM Cognos, IBM Maximo, Oracle ODI and Oracle OWB.

Izmir, Turkey

Lead System Administrator for the User Multiplication Project where the number of users has been increased by 10% through international collaboration with Germany, India and US teams. User set up of all four factories in Turkey on the new servers re-located in Spain by HP due to Force Majeure issues and capacity issues. Improved productivity and enabled coordination between US and Turkey through precise maintenance and re-structuring of local settings for approximately 100 users. Provided 7/24 online support for SAP hand held terminals scanner renewal project and managed to keep the factory daily production live through prompt resolution of issues Coordinated the roadmap for completion and alignment of network processes between CSC and HP USA teams during the Domain Controller Server replacement project. Completed set up of the Domain Controller Server and enabled the system to work with 40% improvement in productivity. Completed the implementation of new VPN User Policy for all relevant teams. Coordinated the Network Security Restructuring project with HP Network Security Team in the US and have completed the relevant structural changes for related applications in Turkey. Have successfully completed the environment set up and SAP user account management for the newly built TRW production line. Working directly with Heads of Departments and Factory Manager, achieved the established Six Sigma Cost Lowering targets via detailed data maintenance and DW house keeping and the removal of data prone to create unnecessary back up costs to another environment Have completed the set up of necessary infrastructure and network settings, which enabled remote access for India and Spain teams during the project that achieved India and Turkey Finance department goals of working online for Financial Accounting. For this particular project, worked in shifts in Pacific time zone as the project required direct collaboration with US network team.

Izmir, Turkey

Within the scope of GPS project, have built the street level details for Izmir digital map on SQL server thus enabling the application to calculate the optimum route by reading the address details on SQL database. Enabled GPS driven automated order reception functionality for 32 sale points in Izmir and coordinated the project which has achieved identification of accurate pin-points for customer locations on SQL database. Have acted as the Project Manager during the Piloting of GPS driven order reception system in Izmir and managed an on site team of ten. Have worked on VoIP improvement project which has increased the daily response rate of the Customer Line. Worked as the Business Analyst for the MGSM Ordering Project, Worked as the Project Lead in CRM 3.0 transition, worked on business analysis and application development. As part of the helpdesk establishment project, I have completed recruitment of the helpdesk agents, defined the roles and responsibilities for the helpdesk team and managed the team operations on a daily basis. Have successfully completed the transition of network processes during the Nestle Erikli Merger period. The activities included setting up of 300+ user exchange accounts, VPN accounts assignments and merging all Aegean and Mediterranean Region user accounts and networks under one domain. Have been promoted to Mediterranean Region Lead as well as Aegean Region Lead after the Erikli Nestle Merger. Within this new role, I have managed similar GPS/Network projects within the new region. Have successfully completed the system GHSDSL Point to Point project which has improved efficiency of the Customer Services Line via localised VoIP centrals and mitigated the load on Head Office system Have worked on the upgrading of CRM 1.0 to CRM 3.0 that resulted in providing the CRM team the capability of development for additional CRM applications and marketing applications.

Ankara, Turkey

Network set up and security establishment of all UCTEA Chamber of Chemical Engineers branches throughout Turkey. Also managed the set up, maintenance and security configurations of all workstations within the network.