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.
-
Senior Financial AnalystFarmers Insurance 2022 - Aug 2023Woodland 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 -
Business Systems Specialist/Financial AnalystFarmers Insurance (21St Century Insurance) Oct 2004 - Dec 2021Woodland 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
-
Senior Financial AnalystSap Trading Co. Dec 2001 - Sep 2004Vernon, 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
-
Finance ManagerVirgin Entertainment Group Feb 2000 - Dec 2001Los 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
-
Manager Merchant Profitability & FinanceCardservice International Jun 1994 - Jan 2000Agoura 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
-
Master Of Business Administration - Mba -
Communication And Media Studies
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?
-
-
Yoel Bitton
Israel1nesstel.com -
-
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
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.
Start your free trial