Ran Shemesh Email & Phone Number

Ramat Hasharon Area, Israel

- Designed and improved internal workflows and procedures and reduced man-hours - Analyze enterprise business performance and customer behavior to identify trends and red flags - Responsible for various reports- Risk, Billing, Performance. Analysis of the data, conclusions and presentation to the management - Creating, updating, and maintaining financial models and detailed forecasts of the company’s future operations - Determining which of the company’s products or product lines generate the largest portion of its net profit - Working with individual departments to prepare budgets and consolidate them into one overall corporate budget - Comparing historical results against budgets and forecasts, and performing variance analysis to explain differences in performance and make improvements going forward - Setting monthly and annual goals for the leasing field - Performing calculations to check the profitability for each deal - Building Risk portfolio for company’s entire leasing field

Ramat Gan Area, Israel

• Building a financing model using Excel software for the sales department• Budget control• Monitoring the company's expenses and income• Preparing an annual plan to meet the company's goals• Building Risk portfolio for the loan field• Providing consulting services for sales department on customer loan specifications• Analyzing customer financial data of both employees and large and small businesses and determining risk factors for loans

• Analysis of store reports and sales performance using extensive Priority software and Excel software• Managing the branch staff• Monitoring and supervising store inventory

Bachelor’S Degree, Economics

Specializing in Entrepreneurship

Excel And Vba Course For Analysts And Finance Professionals

Sql Course

Tableau Course