Home > References
Food & Baverage
Finance Data Lake Project
- Provided Cloud Migration advisory
- Created Data Lake structure and pipelines
- Integrated data from Tagetik and SAP
- Enabled Financial KPI analysis via new data platform
- Created dashboards and reports via PowerBI
- Used Snowflake Database and Informatica Cloud platforms
Pharmaceutical
Data Foundation Project
- Provided Cloud Migration advisory
- Created Data Foundation structure and implemented pipelines
- Modelled Datawarehouse and designed ETL framework
- Integrated data from Salesforce and SAP
- Created dashboards and reports via Power BI
- Used Snowflake Database and Informatica Cloud platforms
Baverage
Common Data Layer Project
- Provided Data Migration advisory
- Created Common Data Layer to be used for strategic data missions
- Modelled CDL and designed ETL framework
- Integrated data from SAP and several other sources
- Created dashboards and reports via SAP Business Objects
- Used Teradata Database and SAP Data Services platforms
Automotive
Data Catalog Project
- Provided Data Governance advisory
- Created Corporate Data Catalog structure via Alation DQ platform
- Implemented a Data Quality validation mechanism
- Analysed customer Data Quality by identifying data quality criteria and KPI metrics
- Created dasboards and reports via PowerBI
Airlines
CRM Transformation Project
- End-to-end CRM transformation advisory
- Datawarehouse modelling and implementation
- Real-time Campaign Implementation
- CRM and Analytic Datamart Development
- Enabling customer segmentation and churn models
- Used Teradata and IBM data platforms including Datastage and SPSS
Telecommunication
Incentive Management Project
- Provided Incentive Management advisory
- Created Dealer Incentive Management structure
- Enabled dealer transparent incentive management
- Optimized KPI-based premium calculation system
- Created dashboards and reports via SAP BO
- Used Oracle Database and Informatica Power Center platforms
Telecommunication
Data Warehouse Conversion Project
- Provided Datawarehouse Migration advisory
- Converted legacy Microsoft-based Data Warehouse to Teradata
- Migrated ETL jobs from SSIS to Informatica platform
- Implemented impact analysis of datawarehouse conversion
- Created dasboards and reports via Power BI
- Used Teradata and IBM data platforms including Datastage and SPS
Telecommunication
Data Mart and Analytic Projects
- Worked with Turkcell and Superonline as a data solutions partner.
- With financial segmentation projects, customers were grouped according to their income and expenditure levels.
- By analysing the profitability of customers, the value that each customer adds to Turkcell and Superonline was determined.
- Data marts were developed to support campaign management. Better definitions were made by segmenting customers according to their behaviours.
- Strategic marketing activities were prioritised according to customer segments.
Telecommunication
Data Mining Project
- Provided analytical data mart solutions to form the basis for customer segmentation and churn & retention initiatives.
- Contributed to customer segmentation for Du Telecom to better understand and categorise its customers.
- Developed strategies to prevent customer churn and provided insights to increase customer loyalty.
Finance
Big Data and Data Science Projects
- Provided Big Data and Data Science advisory
- Implemented end to end pyspark pipelines on Cloudera
- Implemented ODI based pipelines for legal reports
- Created dashboards and reports via OBIEE
- Used Cloudera, Python, Spark and Oracle Data Integrator
Finance
Data Governance, Quality and Dashboard Projects
- Defining data ownership and quality processes by improving data governance infrastructure.
- Creating a scoring system for regular monitoring and improvement of data quality in different categories.
- Developing a special website for Albaraka employees using React.
- Designing 12 different screens for 8 different roles; customised screens for different user needs from portfolio manager to sales manager.
- Use of technologies such as data integration with Informatica and reporting with PowerBI.
Finance
DWH Extension Projects
- Provided data solutions to Akbank within the scope of several DWH projects.
- Profitability and branch performance datamarts were implemented for providing an overall view of the financial KPIs.
- Real-time decisioning datamart was developed for enabling realtime campaign activities on Chordiant.
- A better understanding of customer profiles was achieved by unifying customer data.
- Data quality processes were implemented to ensure the integrity and quality of customer data.
- All ETL processes were developed using Informatica standarts.
Finance
DWH Projects
- Provided enterprise level data warehouse projects to better manage business initiatives and support business reporting activities.
- Data on the mainframe was extracted using Informatica.
- Data Warehouse modelling activities were carried out.
- Additional ETL processes were developed in accordance with the Data Warehouse implementation plan
Automotive Industry
BI and Data Analytics Project
- A data warehouse was created for reporting sales, CRM, and operational processes.
- Senior management dashboard and end-user reports were prepared.
- The project aimed to improve data analytics and reporting processes within the company.
- Classification of advertisement descriptions as searchable/unsearchable using NLP.
- With the classification of the tools, the advertisement search processes of the call center were optimized.
Finance
Risk Analytics Project
- Using business knowledge, we created a dataset by collecting the necessary data to predict the bouncing of cheques
- The created dataset was subjected to data pre-processing steps and we developed a model that predicts whether cheques bounce or not and calculated the risk scores of customers.
- Since there are more than 300 variables, the importance of the features was measured. The non-contributing variables were removed to improve the model's performance, and then the model was retrained.
- We focused on increasing the success of the final model by hyperparameter optimization and the model was tested.
- The model has been made live on Docker and is regularly maintained in certain periods.
Automotive
Data Analytics Assessment and Consultancy
- As-Is Analysis was done for identifying current picture on Data Analytics.
- To-Be Analysis concluded for preparing Data Strategy and Analytics roadmap.
- Data Analytics consultancy given for segmentation of customers.
Finance
Data Analytics Projects
- We conducted a customer segmentation study using RFM analysis to classify BTCTurk customers based on data-driven behavioral patterns.
- The analysis considered customers' past trading habits, the frequency of transactions, and the amount spent to determine potential trading tendencies.
- We worked on a churn model and provided insights for customer retention
Insurance
AML and ABS Upgrade Project
- Implementation of Data Layer for Allianz AML Project
- Fixing data issues happening during data validation
- Developing data pipelines using Informatica ETL tool
- Optimizing data loads and overall performance
- Analyzing impacts of ABS core product update and propogating changes to the Informatica pipelines
- Reviewing Informatica pipelines for performance optimization
Chemicals
NPL Project
- Integration of different data sources for supply chain planning application.
- Designing and implementing a standart data layer in the cloud
- Fetching data from SAP and EDL using Azure Data Factory and Databricks
- Enabling forward and backward integrations using middleware applications like Kafka and Web Services
- Applying optimizations in case there are bottlenecks
Human Resources
Recommendation Engine Project
- Developed recommendation engine solutions for increasing member engagement through similar job contents.
- Personalised job recommendations were provided for Kariyer.Net members to increase their engagement on the platform.
- Similar job adverts were suggested based on users' past searches and interactions.
E-Commerce
CRM Data Mart Project
- CRM-based data solutions were provided to facilitate Morhipo's CRM (Customer Relationship Management) activities.
- Helped to manage e-commerce processes more effectively.
- Strategies were developed to increase customer interactions through CRM data solutions.
