$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Data Warehouse Consultant
ilkay senturk
,
Epsom, United Kingdom
Experience
Other titles
Skills
I'm offering
Data Warehouse Developer
Markets
United Kingdom
Language
English
Fluently
My experience
2014 - ?
freelance
Senior DWH Consultant
THOMSON REUTERS.
(Contract)
Thomson Reuters is a Canadian multinational mass media and information firm in Finance, Tax, Law and Intellectual property. We are currently working on EDW project (Enterprise data warehouse) here in London which is open to companies report developers across the world like Europa, US, Canada and Australia etc.
• Data analysis to improve overall efficiency to support BI reporting model.
• Technical Pre-planning and documentation.
• Acquisitions of new data sources of SAP, Salesforce, Eloqua and Corporate applications from US data center.
• Working with BI to shape the physical model of Datamarts.
• Hands on experience with dimensional and relational data modeling.
• Designing robust, maintainable and reusable Enterprise level DWH and Datamart solutions.
• Hands on ETL development with Informatica, Oracle PL/SQL and Linux Bash Scripting.
• ETL and OLAP reporting performance tuning.
• Release management on Git and SVN.
• Worked on Agile Methodology
Thomson Reuters is a Canadian multinational mass media and information firm in Finance, Tax, Law and Intellectual property. We are currently working on EDW project (Enterprise data warehouse) here in London which is open to companies report developers across the world like Europa, US, Canada and Australia etc.
• Data analysis to improve overall efficiency to support BI reporting model.
• Technical Pre-planning and documentation.
• Acquisitions of new data sources of SAP, Salesforce, Eloqua and Corporate applications from US data center.
• Working with BI to shape the physical model of Datamarts.
• Hands on experience with dimensional and relational data modeling.
• Designing robust, maintainable and reusable Enterprise level DWH and Datamart solutions.
• Hands on ETL development with Informatica, Oracle PL/SQL and Linux Bash Scripting.
• ETL and OLAP reporting performance tuning.
• Release management on Git and SVN.
• Worked on Agile Methodology
Pl/sql, Tuning, OLAP, Enterprise, SVN, BEE, Oracle PL/SQL, Development, Support, Bash, Finance, Management, Sql, Data Modeling, Salesforce, Data Warehouse, ETL, Scripting, Agile, SAP, Oracle, Linux, Git, Data Analysis
2013 - 2014
job
Senior Analyst/Developer
SONY PLAYSTATION.
A global network of highly successful and accomplished game development studios producing high quality games and consoles for various platforms.
ETL Developer (Financial Lifetime Profit & Loss Data warehouse, PARIS (Planning Application Tool), Player Activity Datamarts, MDM Portal)
Integral member of the WWS Business Planning team involved in the implementation of various projects including the Lifetime Profit and Loss data warehouse which involved collating data from various regions (using Informatica 9.1, Shell Scripts and Oracle) to build financial reports for various game platforms (PS4, PS3) with Cognos. In addition, also implemented the loading of data from the MDM Portal (BigMap Application Tool) to populate the warehouse fact and conformed dimension tables.
• Built a complex Financial Data warehouse that tracked the profitability of al PlayStation Games and products across various regions (SCEA, SCEE, SCEJ) using Informatica and Oracle.
• Successfully implemented reports for Tracking Player Activity on various Title Platforms and different timeframes using Informatica, Oracle, Materialized Views and PLSQL.
• Built the PSN (PlayStation Network) datamart with input data from various feeds to track the user behavioral patterns and download costs.
• Management and training of junior developers in using Informatica and various SONY
• Metadata Management systems.
ETL Developer (Financial Lifetime Profit & Loss Data warehouse, PARIS (Planning Application Tool), Player Activity Datamarts, MDM Portal)
Integral member of the WWS Business Planning team involved in the implementation of various projects including the Lifetime Profit and Loss data warehouse which involved collating data from various regions (using Informatica 9.1, Shell Scripts and Oracle) to build financial reports for various game platforms (PS4, PS3) with Cognos. In addition, also implemented the loading of data from the MDM Portal (BigMap Application Tool) to populate the warehouse fact and conformed dimension tables.
• Built a complex Financial Data warehouse that tracked the profitability of al PlayStation Games and products across various regions (SCEA, SCEE, SCEJ) using Informatica and Oracle.
• Successfully implemented reports for Tracking Player Activity on various Title Platforms and different timeframes using Informatica, Oracle, Materialized Views and PLSQL.
• Built the PSN (PlayStation Network) datamart with input data from various feeds to track the user behavioral patterns and download costs.
• Management and training of junior developers in using Informatica and various SONY
• Metadata Management systems.
Oracle, Training, ETL, Data Warehouse, Management, Game development, Network, Developer, Implementation, Analyst, Development, Patterns, Portal
2010 - 2013
job
ETL Team Lead
Toyota Financial Services UK.
This is a Data Warehouse project which is gathering 3 different existing Data Warehouse structures to a new single Data Warehouse solution with Change Data Capture functionality and new dimensional data model. Database: Oracle 11g, SQL Server 2005 Environment: UNIX
• Project co-ordinate internal team, Client & internal stakeholders (BI business groups)
• Manage workloads of ETL side of the Project as required. Team size: 4 ETL & 2 Cognos resources.
• Work with business analysts and technology personnel to specify technical solutions (application architecture) of BI business requirements & specify technical specifications for the team.
• Facilitate regular meetings and liaison within the group, client departments.
• Facilitate Configuration management and deployment of Informatica 8.6, PL/SQL and UNIX codes.
• Analyzed 3 different source CMS, POS and external feeds.
• Created data dictionary of source systems.
• Designed physical dimensional data model consist of Finance, Customer Collection and Sales and Marketing.
• Designed the overall ETL Flow - Standardization, Batch Management, Data Quality, Auditing and Error Handling framework.
• Created detailed ETL mappings.
• Developed Informatica 9.1 ETL mappings and workflows.
• Spear-headed the performance optimization drive to bring down the processing batch by a factor of 500% - well within the client's anticipated levels. Demonstrated superior SQL performance tuning skills.
• Developed Cognos 8.4 Reports.
• Worked with the client to improve Cognos 8.4 Reports capabilities.
• Support the Business Systems manager and the team in day-to-day BI activities.
• Project co-ordinate internal team, Client & internal stakeholders (BI business groups)
• Manage workloads of ETL side of the Project as required. Team size: 4 ETL & 2 Cognos resources.
• Work with business analysts and technology personnel to specify technical solutions (application architecture) of BI business requirements & specify technical specifications for the team.
• Facilitate regular meetings and liaison within the group, client departments.
• Facilitate Configuration management and deployment of Informatica 8.6, PL/SQL and UNIX codes.
• Analyzed 3 different source CMS, POS and external feeds.
• Created data dictionary of source systems.
• Designed physical dimensional data model consist of Finance, Customer Collection and Sales and Marketing.
• Designed the overall ETL Flow - Standardization, Batch Management, Data Quality, Auditing and Error Handling framework.
• Created detailed ETL mappings.
• Developed Informatica 9.1 ETL mappings and workflows.
• Spear-headed the performance optimization drive to bring down the processing batch by a factor of 500% - well within the client's anticipated levels. Demonstrated superior SQL performance tuning skills.
• Developed Cognos 8.4 Reports.
• Worked with the client to improve Cognos 8.4 Reports capabilities.
• Support the Business Systems manager and the team in day-to-day BI activities.
Technology, SQL Server 2005, Manager, Processing, Framework, Tuning, Server, BEE, Performance optimization, Configuration Management, Support, Pos, Data quality, Architecture, Marketing, Sales, Finance, Management, Pl/sql, Data Warehouse, ETL, Database, Unix, Deployment, CMS, Oracle, SQL Server, Sql
2009 - 2010
job
Senior Data Integration Developer
Talk Talk.
TalkTalk group bought the AOL UK and started planning to integrate AOL's data from their Legacy systems to TalkTalk's application databases. Database: Oracle 11g, SQL Server 2005 Environment: UNIX
• Developed and designed ETL solutions for the data migration using common data model approach.
• I was in a position to make some analyses regarding quality of data which needs to be integrated from one application to other by facing to business as well as technical people.
• Technologies used in this project are Informatica 8.4 and Oracle PL/SQL.
• Analyzed the process flow of business for update plans.
• Reviewed the source and target systems.
• Built end to end solution design of update plans.
• Performed creating prototype concept of data mappings.
• Developed PL/SQL packages and Informatica mappings for de-normalization of the data.
• Developed and designed ETL solutions for the data migration using common data model approach.
• I was in a position to make some analyses regarding quality of data which needs to be integrated from one application to other by facing to business as well as technical people.
• Technologies used in this project are Informatica 8.4 and Oracle PL/SQL.
• Analyzed the process flow of business for update plans.
• Reviewed the source and target systems.
• Built end to end solution design of update plans.
• Performed creating prototype concept of data mappings.
• Developed PL/SQL packages and Informatica mappings for de-normalization of the data.
Design, Sql, SQL Server, Oracle, Unix, ETL, Database, SoMe, Pl/sql, Integration, Developer, Oracle PL/SQL, Server, SQL Server 2005
2009 - 2009
freelance
Data Warehouse and BI Consultant
Akbank.
Akbank is the Turkey's one of the biggest banks. Project called ARGUS is designed for Decision Support and Performance Managment System. ARGUS aims to present users with comprehensive data enabling them to conduct analyses regarding the performance of the Bank utilizing the most important criteria. Daily,weekly and monthly data depending on the nature of the records can be accessed via ARGUS. Database: Oracle 10g, SQL Server 2008 Environment: UNIX
• Facilitated Business Developers sessions to gather the data warehouse requirements from the users.
• Created the Multi Dimensional data model (STAR Schema) and enhanced it to meet the OLAP needs.
• Created Informatica 8.1 ETLs
• Built Cognos 8.2 Framework Model.
• Developed Cognos 8.2 Report Studio reports.
• Helped to client with developing Oracle PL/SQL procedures.
• Facilitated Business Developers sessions to gather the data warehouse requirements from the users.
• Created the Multi Dimensional data model (STAR Schema) and enhanced it to meet the OLAP needs.
• Created Informatica 8.1 ETLs
• Built Cognos 8.2 Framework Model.
• Developed Cognos 8.2 Report Studio reports.
• Helped to client with developing Oracle PL/SQL procedures.
Sql, SQL Server, Oracle, Unix, Database, Data Warehouse, Pl/sql, It, Support, Oracle PL/SQL, BEE, Server, OLAP, Managment, Framework, Sql server 2008
2007 - 2009
freelance
Data Warehouse and BI Consultant
Obase.
DANONE Data Integration Project (2 Months)
DANONE is a worldwide known dairy products producer. Aim of this project is to keep SAP Logistics systems in synch with Raw Materials systems. Database: IBM DB2 Environment: UNIX
• Re-engineered the Danone SAP Logistics system process. Responsibility involved interaction with users to consolidate the requirements and perform extensive Data and Process analysis.
• Proposed and implemented effective System design. This included extensive data analysis, designed and developed online batch algorithm.
• Built Informatica 8.2 Workflow and Mappings for data Integration sourced from SAP Idocs to application called Ceva WMS in Unix environment.
Standard Profil (2 Months)
Standard Profil is an automotive spare part producer company. They were having ETL performance and Cube creation issues on their BI systems. Database: SQL Server 2005. Environment: Windows Server
• Re-architected data flow for efficiency.
• Changed Informatica 8.2 mappings as needed to improve performance.
• Improved cube designs for ease of loading using Cognos 8.3 Transformer.
Tekzen Yapi Market DWH Project (Duration: 2 Months)
Tekzen is a well-known retail company in Turkey. I participated as a project additional resource. Database: Oracle 10g Environment: Windows Server
• Developed Cognos 8.1 Report Studio Reports.
• Built Informatica 8.1 ETL Code.
• Perform Oracle10g performance Tunings.
Makro Retail DWH Project (Duration: 2 Months)
Makro is a Turkish Grocery retail company. Database: Oracle10g Environment: Windows Server
• Took part in developing various ETL mappings in Informatica 8.1 and PL/SQL.
• Designing summary and atomic level DWH tables following Kimball.
Garanti Bank POC (Duration: 1 Months)
POC was aiming to prove that Informatica ETLs performance much better than previously developed DB2 procedures. Database: IBM DB2 Environment: UNIX
• Developed Informatica 8.1 ETLs to replicate DB2 procedures.
Isbank Core Banking DWH Project (Duration: 2 Months)
Isbank is the Turkey's biggest bank and Isbank Core Banking DWH Project was the Turkey's biggest DWH projects ever done. I was hired by IBM Turkey. Database: IMS Environment: UNIX
• Participated in designing Informatica 8.1 ETL solution by leading to developers.
• Found solutions to development problems.
• Created detailed mapping documents.
• Created ETL standards and QA of the code.
Istanbul Buyuk Sehir Belediyesi DWH Project (Duration: 8 Months)
This was a very high budget government project for Istanbul Metropolitan municipality. Database: Oracle 10g RAC, SQL Server 2005 Environment: UNIX, Windows Server
• Developed Informatica 8 and PL/SQL ETL code.
• Performed Cognos 8.2 Report Studio development.
• Implemented the Oracle Streams Replication to the project
DANONE is a worldwide known dairy products producer. Aim of this project is to keep SAP Logistics systems in synch with Raw Materials systems. Database: IBM DB2 Environment: UNIX
• Re-engineered the Danone SAP Logistics system process. Responsibility involved interaction with users to consolidate the requirements and perform extensive Data and Process analysis.
• Proposed and implemented effective System design. This included extensive data analysis, designed and developed online batch algorithm.
• Built Informatica 8.2 Workflow and Mappings for data Integration sourced from SAP Idocs to application called Ceva WMS in Unix environment.
Standard Profil (2 Months)
Standard Profil is an automotive spare part producer company. They were having ETL performance and Cube creation issues on their BI systems. Database: SQL Server 2005. Environment: Windows Server
• Re-architected data flow for efficiency.
• Changed Informatica 8.2 mappings as needed to improve performance.
• Improved cube designs for ease of loading using Cognos 8.3 Transformer.
Tekzen Yapi Market DWH Project (Duration: 2 Months)
Tekzen is a well-known retail company in Turkey. I participated as a project additional resource. Database: Oracle 10g Environment: Windows Server
• Developed Cognos 8.1 Report Studio Reports.
• Built Informatica 8.1 ETL Code.
• Perform Oracle10g performance Tunings.
Makro Retail DWH Project (Duration: 2 Months)
Makro is a Turkish Grocery retail company. Database: Oracle10g Environment: Windows Server
• Took part in developing various ETL mappings in Informatica 8.1 and PL/SQL.
• Designing summary and atomic level DWH tables following Kimball.
Garanti Bank POC (Duration: 1 Months)
POC was aiming to prove that Informatica ETLs performance much better than previously developed DB2 procedures. Database: IBM DB2 Environment: UNIX
• Developed Informatica 8.1 ETLs to replicate DB2 procedures.
Isbank Core Banking DWH Project (Duration: 2 Months)
Isbank is the Turkey's biggest bank and Isbank Core Banking DWH Project was the Turkey's biggest DWH projects ever done. I was hired by IBM Turkey. Database: IMS Environment: UNIX
• Participated in designing Informatica 8.1 ETL solution by leading to developers.
• Found solutions to development problems.
• Created detailed mapping documents.
• Created ETL standards and QA of the code.
Istanbul Buyuk Sehir Belediyesi DWH Project (Duration: 8 Months)
This was a very high budget government project for Istanbul Metropolitan municipality. Database: Oracle 10g RAC, SQL Server 2005 Environment: UNIX, Windows Server
• Developed Informatica 8 and PL/SQL ETL code.
• Performed Cognos 8.2 Report Studio development.
• Implemented the Oracle Streams Replication to the project
Integration, SQL Server 2005, Kimball, IMS, Online, Server, Wms, BEE, Development, System Design, Workflow, Banking, Windows, QA, Windows server, Design, Producer, DB2, Pl/sql, Data Warehouse, Database, ETL, Unix, SAP, Budget, Oracle, Retail, SQL Server, Data Analysis, Sql
2005 - 2007
job
Data Warehouse Developer
DB Teknoloji.
Carrefour HR Data Migration Project (Duration: 4 Months)
Retail Company Carrefour was changing HR application to Oracle HR.
• Creating optimized Informatica 7.1 ETL mappings and incorporating complex logic into them.
• Strong emphasis on accurate and consistent data.
• Creating Control Mechanism jobs to schedule workflows.
• Creation and modification of Cognos Reports
Retail Company Carrefour was changing HR application to Oracle HR.
• Creating optimized Informatica 7.1 ETL mappings and incorporating complex logic into them.
• Strong emphasis on accurate and consistent data.
• Creating Control Mechanism jobs to schedule workflows.
• Creation and modification of Cognos Reports
Retail, Oracle, ETL, Data Warehouse, Developer, Logic
2004 - 2005
job
BI Specialist
Bromcom.
This is a company which develops software solutions for Schools in the UK.
• Develop PL/SQL procedures
• Create and maintain daily running batches.
• Exposure to Cognos Report development.
• Develop PL/SQL procedures
• Create and maintain daily running batches.
• Exposure to Cognos Report development.
Sql, Pl/sql, Development, Software, BEE
My education
?
-
2000
n/a
BSc, Geophysics Engineering Istanbul-Turkey
BSc, Geophysics Engineering Istanbul-Turkey
ilkay's reviews
ilkay has not received any reviews on Worksome.
Contact ilkay senturk
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to ilkay directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark