Summary
Overview
Work History
Education
Skills
Languages
Timeline
Generic

Ben Mandelbauim

Business Intelligence Analyst & Developer

Summary

Adaptable and fast learner thriving in high-stress environments, demonstrating expertise as a BI professional with a proven track record of delivering impactful, data-driven business solutions

Overview

8
8
years of professional experience
8
8
years of post-secondary education

Work History

Business Intelligence Developer

Elad Data (Formerly Excelando Ltd)
1 2022 - Current
  • Experience in dynamic work environments, handling multiple projects simultaneously across diverse industries including real estate, insurance, healthcare and etc., while effectively aligning business goals with actionable insights.
  • Proven project management expertise leading cross-functional teams to deliver complex initiatives. Successfully collaborated with diverse stakeholders across departments and organizational levels to translate business objectives into actionable strategies. Adept at project scoping, team management, and technical documentation. Possess a strong foundation in ETL process design and optimization.
  • Played a pivotal role in BI projects across all phases- from initial business strategy and building comprehensive task timelines to drive successful project execution and achieve organizational goals
  • Proficient in building DWH using SSMS, SSIS, Azure and etc., including connecting diverse applications to databases (like writing functions, stored procedures, and triggers)
  • Developing complex reports and interactive dashboards with Power BI, utilizing powerful visual methods to enhance data visualization and analysis


Busniess Intellegence Analyst

Thinkwise Consulting
11.2020 - 11.2021
  • Creating reports, dashboard, and ad-hoc analysis using BI/Analytical tools like Excel, Tableau, Power BI etc
  • DWH project end to end including Talned ETL , snowflake and Power BI
  • Building and analyzing dashboards for different departments in several companies and display relevant KPI's, like P&L, Customer attrition. Customer retention ARR, MRR and etc

Portfolio Manager

Exitvalley Ltd.
06.2018 - 11.2020
  • Venture investing platform optimizing investments in Pre-seed to Round A startups
  • Full lifecycle management of Investment - from the legal and financial documentation to the marketing and enlistment of investors
  • Effectively tutored new portfolio managers, providing expert guidance in areas such as investment agreements, investor conversions, while overseeing the creation of comprehensive Gantt charts from the initiation of funding to the legal closing stage
  • Management of investor relations from first contact to closing to maximize the investor's KPI - successful enlistment of over 9M USD

Intern

Goldfarb Seligman&Co.Law Office
09.2016 - 09.2017
  • Specialization in the corporate litigation department, Represented global clients in high-stakes disputes involved business- commercial aspects

Education

B.A Business Administration - Concentration in International Business

Interdisciplinary Center Herzliya (IDC)
08.2012 - 08.2016

L.L.B., Law Degree -

Interdisciplinary Center Herzliya (IDC)
08.2012 - 08.2016

Skills

    SQL (Microsoft SQL Server, Oracle, PostgreSQL)

    Power BI

    Tableau

    Azure Data Factory

    Azure Databricks

    Azure Synapse SQL

    Excel

    Power Apps

    Power Automate

Languages

Hebrew
English

Timeline

Busniess Intellegence Analyst

Thinkwise Consulting
11.2020 - 11.2021

Portfolio Manager

Exitvalley Ltd.
06.2018 - 11.2020

Intern

Goldfarb Seligman&Co.Law Office
09.2016 - 09.2017

B.A Business Administration - Concentration in International Business

Interdisciplinary Center Herzliya (IDC)
08.2012 - 08.2016

L.L.B., Law Degree -

Interdisciplinary Center Herzliya (IDC)
08.2012 - 08.2016

Business Intelligence Developer

Elad Data (Formerly Excelando Ltd)
1 2022 - Current
Ben MandelbauimBusiness Intelligence Analyst & Developer