Hello, I'm
Zohar Mamut

Project Management, BI Development and Analysis

About

About

I am a project manager and data expert with 8+ years of experience building and optimizing data warehouses and business intelligence solutions. Helping clients gain insights into diverse data in one glimpse. Throughout my career, I have been working with end-users to translate their business needs into tangible data and reporting solutions using different BI tools, implementing BI concepts to design innovative and incitive dashboards for internal and external consumers.
People say I am creative, eager to learn new tricks and technologies to sustain growth. I have emotional intelligence; I can listen to clients and teammates’, slice through the noise, and provide creative pathways and solutions as required. I am flexible and can reorganize priorities as new tasks keep flowing in. The connecting string between all my BI projects is based on aspiring to provide one single truth to the different echelons of the company making process simple and elegant.
On top of my IT skills, I have MIS M.SC and strong financial and accounting background.

My goal is to learn as much as I can on new BI technologies and how they can be executed on the cloud with secured features.
Skills

Skills

Personal Skills

• Excellent interpersonal skills, always polite and patient
• Great business data needs’ analyst and insights source in any organization
• Fast learner, independent, and self-motivated
• Able to undertake multiple projects from start to finish, prioritizing work effectively
• Strong organizational skills, including time and project management
• I can communicate with business users and technical people understanding business and technical constraints
• Excellent analytical skills, ability to analyze information, and identifying the heart of issues

Professional Skills

• Front-end BI tools: Power BI, SSRS, QlikView
• Back-end BI tools: SQL, T-SQL, MDX, SSIS, SSAS, knowledge of Python
• Database and BI architecture: DFD, ERD, KPI implementation, Kimball BI methodology, denormalization, star schemas, and dimensional modeling
• Additional Knowledge: Excel expert, VBA macros, SQL server 2012/ 2014/ 2016

Education

Education

Tel Aviv University  

Mar 2014 – May 2014

M.Sc. Management Sciences, Technology and Information Systems (MIS)

Thesis: Best Practices of Business Intelligence Systems in the Israeli Business Market

McGill University

Aug 2004 – Jun 2008

Com, majoring in Accounting and Management Information Systems(MIS), graduation with Distinction

Experis Academy

Aug 1999 – Jun 2004

Professional training in Business Intelligence methodologies (760 hours) 

CISA

Aug 1999 – Jun 2004

Certified Information System Auditor

Experience

Experience

Project Manager | Senior Business Intelligence Developer and Analyst                                2012-2022
  • AIG – liaison between the data science team and the organization. Locating discrepancies and fixing them. Creating and planning the DB to house the data science team activity.
  • AIG – optimizing night queries that take long time to process. shorted a process that took more than 8 hours to 1.5 hours.
  • AIG – recreating the customer dimension to funnel all data related to him/her in one record. The process found inserted 100,000 emails, 24,000 phones, 10,000 addresses, and 4,500 birthdays that were lost in the system.
  • Whirlpool Corporate  – managed, designed and built a comprehensive BI, encompassing their marketing, sales, promotions, supply chain activities, demand , and exception detection.  
    The BI included dashboards and big data analysis from the company’s perspective down to Material/Trade Partner/Location/Week level (around 10 million combinations.)
  • The biggest HMO provider in Israel – Managed the creation of supply chain BI module, providing full supply chain information for pharmacies starting from high-level KPI reports drilling down to a specific item in a single pharmacy.  
  • Israel Post – worked together with Strategy and IS VP of created monthly goals and incentive plans for 700 post office branches based on management’s targets.
  • Israel Post – analysis of sales managers and customer sales applied different sales drill-downs, creating KPI, and comparing them to previous years assisting the management in managing customers and reimbursing top  sales managers wisely.
  • Ministry of Health – led 3 people in a VBA, and  project that checked 60 KPIs sent weekly from 10 hospitals.
  • Experis Academy,  Ministry of Health – Taught Excel, BI methodologies, SQL and SSIS
  • Intel – led the redesign of the ETL process and the DWH using SSIS. Solved data quality issues, fine-tuned complicated SQL procedures, and performance optimization for the IT department.
  • Intel – created a process of slowly changing dimensions with history tracking capacity.
  • Bank Leumi – developed inventory control reports based on multiple databases using scheduled store procedures, cursors, and Dynamic SQL.
  • SQL Champion
Information Systems Auditor                                                                                                        2005-2012
  • Ernst & Young – supervised a local information system’s conversion to global ERP in India for an international infrastructure company.
  • Information systems auditor – insurance department.
Recomondations

Recommendations

Ehud Avrahami
Chief Information Security Officer at Afcon Control and Automation.Ltd
January 12, 2015, Zohar worked with Ehud in the same group

I've known Zohar for several years. He is a highly skilled and detail oriented individual. During our work together, Zohar demonstrated an exceptional understanding of information flow processes. He was able to analyze and sometimes reconstruct complicated financial DB processes and identify major financial issues that arouse. I enjoyed working with him, and would not hesitate to work with him again

Ron Levkovitz
CTO at Ogentech
November 5, 2020, Ron managed Zohar directly

‘Data expert’ is the term that comes to mind when I think about Zohar. As a CTO, I’ve had the pleasure of working closely with Zohar for more than two years, during which we launched multiple BI projects of which Zohar was in charge. From this close co-operation I can testify that Zohar is a brilliant BI analyst, architect, and designer. Zohar has excellent analytical abilities, a deep understanding of business processes, and the talent to translate those processes into technical design. He is, moreover, a good team player, open to suggesting and comments, sharing his knowledge and experience with his co-workers, a go-to guy regarding data-related issues. He also have high service attitude, excellent interpersonal skills and humor. I believe Zohar would be a real asset for any company requiring BI development and data management and I strongly recommend him for such position.

Portfolio
01

Dashboards

Portfolio
02

ETL

Portfolio
03

Plan

Portfolio
04

SnapLogic

Portfolio
05

Architecture

Portfolio
06

Dax

Portfolio
07

SQL

Portfolio
Tips
Contact