Onur Ulas, Developer in London, United Kingdom
Onur is available for hire
Hire Onur

Onur Ulas

Verified Expert  in Engineering

Bio

Onur is a data specialist with 15 years of in-depth industry experience, knowledge of business intelligence processes and architectures, data warehousing, and data analytics, combined with interpersonal and organizational skills. He's proud to have assisted in developing successful data products and services while being recognized by colleagues and managers for outstanding work and support. Onur enjoys contributing to innovative and agile, data projects.

Portfolio

Wartsila
Business Intelligence Development, Data Modeling, Database, Data Visualization...
Mitie Group, PLC.
SQL Server, SSIS, Team Management, Business Analysis Consulting...
Genus Plc
SQL, Business Intelligence Development, Azure Analysis Services, T-SQL, ETL...

Experience

Availability

Part-time

Preferred Environment

Business Intelligence (BI), Data Warehouse Design, Data Warehousing, Data Architecture, Microsoft Power BI, SQL

The most amazing...

...data solution I've built was an enterprise-scale data warehouse that became the single source of truth for all analytical requirements of the bank.

Work Experience

Power BI Expert

2021 - 2021
Wartsila
  • Developed the product management dashboard module to help manage and simplify the product portfolio of the company.
  • Built a master data structure to integrate the product office data into various systems such as ERP, finance, R&D, etc.
  • Consolidated and simplified the product portfolio of five different business entities to improve the organization's governance and standardization.
Technologies: Business Intelligence Development, Data Modeling, Database, Data Visualization, Dashboard, ETL Tools

BI Team Lead

2018 - 2021
Mitie Group, PLC.
  • Migrated four different DWH environments onto Azure SQL; consolidated and simplified data marts, reverse-engineered hundreds of stored procedures and ETL jobs, and reduced the BI resource requirement by 70%.
  • Introduced MS Power BI to the organization, administrated reporting ecosystems and set the standards by identifying best practices. Trained end-users and built design templates.
  • Built an award-winning reporting portal. (Real IT Awards 2020 – ‘Turning Data into Insights’).
  • Built and maintained the financial reporting system using SSIS and SSAS.
Technologies: SQL Server, SSIS, Team Management, Business Analysis Consulting, Business Intelligence Development, SQL, Data Quality Management, Data Science, Data Science, ETL, Data Visualization, Dashboard, Database Migration, SQL Server, ETL Tools, Database

Senior BI Developer

2020 - 2020
Genus Plc
  • Developed the new sales and inventory reporting data model on Azure Analysis Services.
  • Migrated the legacy report to the new data environment using Power BI.
  • Reverse engineered the SQL strored procedures and re-developed them using DAX.
Technologies: SQL, Business Intelligence Development, Azure Analysis Services, T-SQL, ETL, Data Visualization, Dashboard, Database Migration, SQL Server, ETL Tools, Database

Data Architect

2017 - 2018
NTT Data
  • Built Qliksense applications for finance, service delivery, queue management and NPS teams.
  • Trained offshore teams on QlikSense scripting and visualization best practices.
  • Delivered five different deployment-ready MVPs with one-week sprints.
  • Migrated data models and reports from legacy sources to the new ecosystem.
Technologies: Data Modeling, SAP BusinessObjects (BO), Netezza, Data Science, Database Migration, ETL Tools

BI Team Lead

2007 - 2017
IS Bank
  • Serviced to 18 different business units of the bank for all data related needs; translated requirements into technical designs and delivered many successful data solutions ranging from KPI dashboards to data warehouses and finance applications.
  • Contributed to technology selection, design, implementation, testing, and maintenance of BI software and DW systems, including integration between databases, data warehouses, and big data platforms.
  • Supported data governance by preparing data profile reports, checking data quality among systems, collecting metadata from BI systems, building the conceptual, logical, and physical data models and managing data lineage among systems.
  • Delivered the following: CRM reporting, customer segmentation, IFRS9 risk reporting, a personal finance management application, credit card KPI dashboards, performance scorecards, and an MI reporting platform.
  • Migrated the legacy DB2 data warehouse environment to Oracle. Converted Bash scripts into Datastage jobs, simplified the data models, re-directed 100+ reports to the new data source, and decommissioned the old solution.
Technologies: Oracle Development, Product Owners, Stakeholder Management, SQL, Team Management, Data Modeling, Solution Architecture, Data Warehouse, Data Warehouse, ETL, Business Intelligence Development, Dashboard, Database Migration, ETL Tools, Database

Mozaic Reporting Portal

A portal to serve more than 150 clients of Mitie to respond all MI, operational, and IOT related reporting requirements. I built the visuals using Power BI and developed the data models on Cassandra, Impala and SQL Server. This project won the Real IT awards for ‘Turning Data into Insights.’

Customer Segmentation Project

A customer segmentation and value proposition datamart running for a large banking client. I developed the logic for calculating the value segments, behavioral segments, and micro-segments for retail customers. Results have been integrated with the Pega marketing platform.

Credit Risk and Capital Adequacy calculations

A data mart to consolidate all the products and services of the bank alongside the customer data. Conducted the analysis with the risk management department, determined the data mappings, and developed the credit risk datamart on Oracle Exadata. Further developed regulatory risk reports for the government agencies using SAP Business Objects.

Enterprise Data Warehouse Project

A new data warehouse solution to run on Oracle and replace the legacy DB2 environment. I worked as a data architect and modeled a new enterprise DW with the IBM BDW model on ERwin. I also led the development team who converted AIX Bash scripts into IBM Datastage jobs. We have decommissioned the legacy data warehouse system having 5,000+ tables and 1,000+ reports.

Customer Performance Scorecards

A customer-based KPI datamart. I collaborated with Deloitte consultants and the risk department of the bank to determine the most critical customer-related KPI’s. I developed the datamart on Oracle Exadata with PL/SQL. The core banking system has consumed the results.

MI Reporting Platform

A cube solution used for MI reporting. I reversed-engineered the existing MI reports, built a star-schema data model on SQL Server, and developed a cube solution on SSAS. The legacy reports have then been repointed to the new data source.

Development of the Enterprise Data Lake

A big data solution to store both structured and unstructured data for analytical purposes. I determined the data pipelines and architectures for the new data lake solution. We ingested transaction, event, log, and core banking data into HDFS while off-loading the existing Datastage ETL jobs. Hive and HBase have been positioned as the new staging layer for the data warehouse and ODS.

Regulatory Reporting Platform Development

A single platform to serve all regulatory reporting requirements of the bank. I have standardized and re-developed 150+ regulatory reports with T-SQL and SSIS. I also developed a monitoring and alerting mechanism to ensure the SLAs and deadlines are met.

Waste Management Dashboard

A dashboard solution to report both high-level and detailed information about the business. I consolidated 100+ reports into one single dashboard using Power BI. Also re-modeled and migrated the data source to Impala.

Healthcare Reporting Project

A dashboard solution to used in the day-to-day operations of NHS Trusts. I conducted workshops with the business users to identify their reporting requirements, ingested the third-party data sources into the enterprise data warehouse, and built the reporting solution using PowerBI.
2009 - 2011

Master's Degree in Management Information Systems

Boshphorus University - Istanbul, Turkey

2003 - 2007

Bachelor's Degree in Computer Engineering

Izmir Instıtute of Technology - Izmır, Turkey

MAY 2017 - PRESENT

Certified Scrum Master

Scrum.org

Tools

Business Intelligence Development, SQL Server, Data Science, Apache, Apache, Oracle Development, Erwin

Languages

SQL, Bash Script, T-SQL

Paradigms

Business Intelligence Development, ETL, ETL Implementation & Design, Requirements Analysis

Storage

Database, Database Migration, SQL Server, Database, Data Integration, SSIS, SQL Server, SQL Server, Netezza, DB2, Database Modeling, Datastage, PL/SQL, SQL Server, SQL Server, Data Lake Design, HBase, Data Lakes, SQL, Database

Platforms

Oracle Development, Azure Design

Industry Expertise

Virtual Coaching

Other

Data Warehouse, Data Modeling, ETL Tools, Data Architecture, Data Engineering, SAP BusinessObjects (BO), Stakeholder Management, Data Visualization, Data Migration, ETL Development, Dashboard, Software Development, Data Management, IT Management, Data Science, Business Analysis Consulting, Scrum Master Consulting, Big Data Architecture, Team Management, Solution Architecture, Product Owners, Reverse Engineering, Customer Segmentation, Stakeholder Engagement, Credit Risk, Relational Data Mapping, Reporting System Design, Data Warehouse, Data Analysis, Azure Analysis Services, Data Quality Management, Data Science, Data Science

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring