Itay Kadim

חגורה שחורה באקסל, Power BI ו- VBA

תל אביב, Israel

Freelancer

Contact

-->

ABOUT

o Both technical and business oriented.
o Proactive, initiate, analytical, process implementer, problems solver, Task type.
o Have Passion for Data, Data handler, Retrieve insights from multiple sources.
Using SQL, Excel, DAX, Power BI and VBA
o Good verbal and presentation skills in both Hebrew and English.
o Experience in global companies and metrical management.

LANGUAGES

Hebrew

Native or bilingual proficiency

English

Native or bilingual proficiency

SKILL DETAILS

Engineering

Industrial Engineering

תואר מאוניברסיטת בן גוריון

Finance

Analysts

Sales & Marketing

Market Research

Research & Surveys

Marketing Analytics

Writing & Editing

Technical Writing

Technology

Information Systems Management

System Analysis

Knowledge Management

Informatics

Software & Programming

150 ₪ / hr

DB - MSSQL, SQL Server

רמה גבוהה בSQL

VBA, Office, Excel Programming

* מתכנת VBA באקסל, MS Project ו- Outlook.
* מפתח כלים תומכי החלטה תוך ניתוח ואפיון צרכי מנהלים בכל הדרגות.
* יוצר Graphical Dynamic Dashboards להצגה נוחה ומובנת של תמונת הארגון: ניצול המשאבים, הצדקה של גיוסי עובדים, ,Capacity Plan ,P&L וניתוחים פיננסיים.

* הקמה ותחזוקה של מערכת לבקרת דיווחי שעות הכוללת הנפקה אוטומטית של Alerts ודו"חות שבועיים וחודשיים והצפתם באגפים.
* פיתוח ותחזוק כלי Pricing Tool לתמחור פרויקטים והוצאת הצעות מחיר המשמש את אנשי המכירות ברחבי העולם ואת מנהלי הפרויקטים בארגון.
* פיתוח ותחזוק כלי המציג את הסטטוסים של הפרויקטים השונים והצפתם בארגון.
* טפסי משתמש (Windows User Forms) להזנת נתונים בצורה איכותית ב- MS Project ובאקסלים המכילים כמות גדולה של נתונים.

* מתכנת Reports Generators
* אוטומציה ומחשוב לתהליכים ידניים מסורבלים.
* מתכנת כלים אקסלים לשימושים וצרכים שונים.

BI, Data Science, Big Data

Technical Requirement Specifications

EMPLOYMENT HISTORY

2017 - 2023

Data Analyst

Meuhedet health medical services

• Working with large data bases (Medical files and treatments of 1.3 million clients), Combining data from various sources and analyze to create full effective pictures, decision making support tools, data explorers and action items.
Using: SQL Server, Excel, Power BI (DAX) and VBA.
• Extract data and information for multiple functions in the organization:
- Analysis of medical services consumption at the Clinics and country hospitals, Monitoring Doctors treatments,
- Capacity and Utilization of medical workers,
- Covid-19 Control Center,
- Prioritizing treatments and vaccines based on patients’ profiles,
- Creating and maintaining graphical dynamic dashboards, visualization tools and ad-hoc reports in various fields for doctors, nurses, pharmacists, finance, marketing and more.
• Develop and maintain tools for doctors regarding drugs and prescriptions monitoring and control: assisting in finding failures, collisions and over prescribed drugs and treatments.
• Extract data for statisticians, identify control groups for A/B Testing comparing efficiency of new drugs and treatments.
• Working with marketing department for tracking telemarketing, digital marketing, customers digital services use, analyzing and finding opportunities regarding new joins.

2016 - 2017

BI Analyst

Start Up Company

• Analysis on retailers’ net revenues such as ‘Shufersal’ and ‘Victory’.
• Generate recommendations for Products which are potential to be high on sales.
• Dealing with high volume databases creating ETLs using SQL, VBA and SSIS.
• Create Customer Success dashboards for company management and investors.

March 2011 - March 2016

Project Analyst

Fundtech, הרצליה

 Innovate, design, develop and implement tools to support the creation of new business processes and improve the exist processes in the organization.
 Create and Maintain Graphical dynamic dashboards and Support decision tools for higher management and for better understanding of organization pictures and needs: Profitability, Revenues, Capacity and support new hires justifications.
 Issuing weekly and monthly management Business analysis reports regarding projects statuses & employees tasks reporting and spread it through all the departments.
 Support to QA and Dev departments regarding: Defects analysis, WIP and KPI’s.
 Create and maintain Automation tools to replace manual processes.
 MS Project Administrator.

September 2009 - December 2010