Summary
Overview
Work History
Skills
TECHNICAL SKILLS
Education
Timeline
Generic

Hadar Dekel

Senior BI Specialist
Raanana

Summary

Experienced Senior BI Developer with a strong background in business intelligence. Skilled in creating data models and dashboards that enhance decision-making. Proficient in SQL and data visualization tools for extracting valuable insights that lead to actionable results.

Overview

18
18
years of professional experience

Work History

Senior BI Specialist

Takeda Pharmaceuticals
11.2019 - Current
  • Optimized query performance through careful database indexing and tuning, reducing response times significantly.
  • Spearheaded the migration of legacy systems to modern BI platforms, ensuring seamless integration with minimal downtime.
  • Managed multiple projects simultaneously while adhering to strict deadlines and maintaining high quality standards throughout implementation phases.
  • Enabled insightful trend analysis by designing historical views of critical KPIs in regular reports and dashboards.
  • Enhanced report generation efficiency by developing and implementing advanced Cognos BI solutions.
  • Optimized complex SQL queries for faster report execution times and reduced server load.
  • Skilled in designing, developing, and optimizing TM1 models for business intelligence and performance management.

Senior Cognos Developer

LiBi Software Technologies
01.2011 - 01.2019
  • Designing & Implementing BI Solutions– Developing end-to-end business intelligence solutions based on customer requirements, including OLAP and relational models, Cognos cubes, and dashboards.
  • Advanced Reporting & Data Visualization – Creating complex financial reports, dashboards, and dimensional reports using IBM Cognos tools (Report Studio, Active Report, Transformer, Dashboards).
  • Performance Optimization & System Configuration – Installing, configuring, and optimizing BI environments following IBM best practices, improving system performance, and integrating diverse data sources.
  • TM1 Development & Automation – Designing and developing complex TM1 models, reports, and queries, hierarchy databases, and relational data structures.
  • End-User Training & Business Collaboration – Training users on IBM Cognos tools, aligning with teams to achieve business goals, and ensuring smooth adoption of BI solutions.
  • BI Project Management & Stakeholder Collaboration – Leading BI and TM1 implementation projects, managing timelines, coordinating with stakeholders, and ensuring successful delivery aligned with business objectives.

IDF
01.2007 - 01.2011
  • Intelligence's Special Unit
  • Developing management and KPI methodologist
  • Designing databases architecture
  • Leading and designing the BI solution
  • Commanding technical and intelligence teams – responsible for developing new technological solutions

Skills

    Python programming

    SQL expertise

    Data quality management

    Data modeling

TECHNICAL SKILLS


  • Programming Languages: Python, Java, C, C++, MDX, SQL, JavaScript
  • Databases: SQL Server, MSAS, TM1, PowerCubes, Tabular, Oracle, MySQL, PostgreSQL
  • Software Development: Object-Oriented Programming (OOP), Algorithm Development

Education

UX computer engineering  - Tel Aviv university 2017-2018

Timeline

Senior BI Specialist

Takeda Pharmaceuticals
11.2019 - Current

Senior Cognos Developer

LiBi Software Technologies
01.2011 - 01.2019

IDF
01.2007 - 01.2011

Similar Profiles

CREATE PROFILE
Hadar DekelSenior BI Specialist