Yoel Bitton

Yoel Bitton Email and Phone Number

Finance Specialist with advanced software skills, including Excel and SQL.
Yoel Bitton's Location
Simi Valley, California, United States, United States
About Yoel Bitton

Experienced business and financial analyst with expertise in retrieving data and creating Excel models that improve the performance of the team, especially in the areas of staffing, forecasting and variance analysis.

Yoel Bitton's Current Company Details

Finance Specialist with advanced software skills, including Excel and SQL.
Yoel Bitton Work Experience Details
  • Farmers Insurance
    Senior Financial Analyst
    Farmers Insurance 2022 - Aug 2023
    Woodland Hills, Ca
    • Reported to Finance Manager and supported New Ventures President and the senior leadership team• Analyzed financial results and collaborated with Marketing, IT and Product managers to develop and present forecasts and budgets to the senior leadership team• Managed the sales bonus program. Contacted contributors on an ongoing basis to ensure that necessary data components would be available on time to meet payout deadlines. Built and modified models and calculations regularly to comply with updates to the payout structure and the requirements of the incentives plan. Led the monthly incentives committee meetings to present my plan recommendations and defend my analyses with the senior leadership team.• Presented variance analysis and submitted recommendations to senior leadership for managing costs and remaining on target• Developed automated processes to efficiently load and evaluate financial projections and provide for the timely tracking and reporting of financial KPIs and Operations metrics• Built financial models to track and manage revenue, expenses and profitability ratios for a $500M unit P&L• Performed impact analysis and followed technical requirements to provide solutions to team data issues• Designed schedules to track relationships with major vendors to monitor costs and ensure compliance with SLAs• Submitted journal entries where necessary and provided guidance throughout the business on all matters related to the proper management of books• Crafted queries using SQL to extract operational data and create KPI scorecards that helped leaders evaluate the performance of their teams. Used COGNOS to schedule timely delivery of metrics to all levels of the organization to ensure prompt attention to areas of concern
  • Farmers Insurance (21St Century Insurance)
    Business Systems Specialist/Financial Analyst
    Farmers Insurance (21St Century Insurance) Oct 2004 - Dec 2021
    Woodland Hills, Ca
    • Developed performance scorecards for Sales and Service cost center representatives and supervisors to track and assess the productivity and contact center performance of teams and individuals. Maintained frequent contact with internal and external contributors to ensure the accuracy and timeliness of data. Composed SQL script to query and validate data from multiple platforms, join the data and either fix or rule out system generated errors. Took advantage of new tools to constantly improve and scale the quality and volume of data available to quickly adjust to new or changing requirements. The scorecards were the primary source of support used by contact center managers to conduct performance evaluations• Played the lead role in a project to develop a suite of analytical tools for the Underwriting department. Conducted meetings with IT and Underwriting to draft requirements and crafted SQL code to extract performance data. Used COGNOS to schedule timely delivery of reports to leaders• Built models to forecast staff requirements for multiple call centers, accounting for occupancy, adherence, handle times, service level, and other relevant metrics• Prepared Budget, Forecast, and Variance analysis for the sales and customer care call centers• Conducted financial and profitability analysis on multiple projects by tracking labor, COGS, and overhead• Prepared and reviewed monthly financials, bank account reconciliations, flash reports, supplemental schedules, accruals, and journal entries for all matters related to the company's internal sales Agency• Provided management with working models to assist in scenario analyses• Conducted CBA and NPV evaluation for proposed capital projects• Established and led a committee that assessed employee survey results and presented statistics and recommendations to the senior leadership team for addressing areas of concern or dissatisfaction
  • Sap Trading Co.
    Senior Financial Analyst
    Sap Trading Co. Dec 2001 - Sep 2004
    Vernon, California, United States
    • Managed accounting/finance department, including bank reconciliation, journal entries, accruals, A/R, A/P, depreciation, inventory, and collections• Prepared monthly and quarterly financial reports including PL, Balance Sheet, and Statement of Cash Flow• Prepared and analyzed annual and interim capital and operational budgets and forecasts for all business units• Prepared ad hoc reports as necessary to aid in pricing decisions• Negotiated contracts with freight companies to secure low rates for shipping product domestically and overseas• Worked with overseas customers and banks to establish letters of credit• Implemented policies and procedures to streamline operations in all areas of the company• Primary point of contact for all matters involving the acquisition and use of technology, including website development, email, software, hardware, and networking
  • Virgin Entertainment Group
    Finance Manager
    Virgin Entertainment Group Feb 2000 - Dec 2001
    Los Angeles, California, United States
    • Prepared quarterly forecasts and yearly budget along with corresponding schedules and commentary for presentation to executive team• Consolidated financials for U.S. and Great Britain, accounting for currency conversion and other reporting requirements• In charge of month end close, financial statements, variance analyses, accruals, journal entries, and the reconciliation of cash accounts and other balance sheet items• Monitored revenue and expense balances to determine weekly and long-term funding needs• Performed daily and weekly financial analysis of company sales performance to recommend strategies for raising profitability and reducing COGS and overhead• Drafted and reviewed marketing contracts from affiliates to ensure favorable terms
  • Cardservice International
    Manager Merchant Profitability & Finance
    Cardservice International Jun 1994 - Jan 2000
    Agoura Hills, California, United States
    • Prepared monthly, quarterly, and annual bankcard processing financial reports• Approved pricing for all Internet and “brick-and-mortar” sales programs. Negotiated, recommended, and authorized pricing for E-commerce and traditional sales programs submitted by regional managers and sales agents• Designed and programmed pro-forma analysis tools for corporate officers, corporate managers, and regional managers to examine pricing proposals. The tools reduced labor hours in the corporate office by almost 50%• Prepared reports and generated figures to assist in lease vs. buy decisions, establish commission rates, and set prices for sales promotions and special programs• Implemented rate adjustments and pricing structure changes to segments of the portfolio and increased profitability regularly without negatively affecting the attrition rate• Participated in the Due Diligence process that led to partial acquisition of the company• Managed and trained a supervisor and 8 employees, establishing for them parameters and a framework for proper account analysis• Automated auditing and profitability review procedures increasing productivity and reducing labor costs• Examined revenue and expense balances to reconcile with banks, processors, and merchant accounts• Audited monthly financials and large vendor invoices to ensure compliance with contracted rates, recovering hundreds of thousands of dollars in overcharges in one year alone• Implemented the use of MS Access to standardize and accelerate the budget data collection process• Created the company’s budget and forecast process including quarterly functional analyses• Analyzed and adjusted the pricing structure of individual merchant accounts to increase the overall profitability of the company’s portfolio

Yoel Bitton Education Details

Frequently Asked Questions about Yoel Bitton

What is Yoel Bitton's role at the current company?

Yoel Bitton's current role is Finance Specialist with advanced software skills, including Excel and SQL..

What schools did Yoel Bitton attend?

Yoel Bitton attended University Of Phoenix, Uc Santa Barbara.

Not the Yoel Bitton you were looking for?

Free Chrome Extension

Find emails, phones & company data instantly

Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Get Chrome Extension - Free

Aero Online

Your AI prospecting assistant

Download 750 million emails and 100 million phone numbers

Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.