Onur Ulas
Verified Expert in Engineering
Data Warehousing Developer
London, United Kingdom
Toptal member since October 22, 2020
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
Experience
Availability
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
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.
BI Team Lead
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.
Senior BI Developer
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.
Data Architect
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.
BI Team Lead
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.
Experience
Mozaic Reporting Portal
Customer Segmentation Project
Credit Risk and Capital Adequacy calculations
Enterprise Data Warehouse Project
Customer Performance Scorecards
MI Reporting Platform
Development of the Enterprise Data Lake
Regulatory Reporting Platform Development
Waste Management Dashboard
Healthcare Reporting Project
Education
Master's Degree in Management Information Systems
Boshphorus University - Istanbul, Turkey
Bachelor's Degree in Computer Engineering
Izmir Instıtute of Technology - Izmır, Turkey
Certifications
Certified Scrum Master
Scrum.org
Skills
Tools
Microsoft Power BI, SQL Server BI, Qlik Sense, Impala, Kafka Streams, Oracle Exadata, Erwin
Languages
SQL, Bash Script, T-SQL (Transact-SQL)
Paradigms
Business Intelligence (BI), ETL, ETL Implementation & Design, Requirements Analysis
Storage
Databases, Database Migration, Microsoft SQL Server, Database Lifecycle Management (DLM), Data Integration, SQL Server Integration Services (SSIS), SQL Server 2016, SQL Server Analysis Services (SSAS), Netezza, IBM Db2, Database Modeling, Datastage, PL/SQL, SQL Server 2012, SQL Server Reporting Services (SSRS), Data Lake Design, HBase, Data Lakes, Azure SQL, Master Data Management (MDM)
Platforms
Oracle, Azure
Industry Expertise
Project Management
Other
Data Warehousing, Data Modeling, ETL Tools, Data Architecture, Data Engineering, SAP BusinessObjects (BO), Stakeholder Management, Data Visualization, Data Migration, ETL Development, Dashboards, Software Development, Data Management, IT Management, Data Analytics, Business Analysis, Scrum Master, Big Data, Team Management, Solution Architecture, Product Owner, Reverse Engineering, Customer Segmentation, Stakeholder Engagement, Credit Risk, Relational Data Mapping, Reporting System Design, Data Warehouse Design, Data Analysis, Azure Analysis Services, Data Quality Management, Data Cleansing, Data Governance
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring