Erik Levy Email & Phone Number

United States

Denver

At Quiznos, I was tasked to recreate and professionalize the company’s budgeting and planning process globally, from scratch. Collaborated with business leaders and divisional Vice Presidents to determine budgets, set targets and create and present all financial statements company-wide (income statements, cash –flow, balance sheet). • Created and led a new budgeting, planning process across 40 divisions and business units globally and reported monthly variances to budget.• Created detailed 500+ line budget for 50 company divisions using IBM Cognos which pulls data into and out of Excel (sample reports available upon request. Created and distribute monthly budget vs actual reporting to division managers and senior management and analyze variances. • Programmed Excel Models from scratch to report budget vs. actual by month, across 500 general ledger codes and upload data into the company’s accounting software.• Financial Planning and Analysis (FP&A) – Focusing on analyzing actual vs budget variances and ways to plan more accurately going forward. • Cash Flow Analysis – Responsible for daily and monthly monitoring and reporting on US and International cash flows.• Foreign Exchange - Monitored, reported, and acted on foreign currency fluctuations and used the change in rates to our advantage.• Redesigned Statements - Created detailed and clear monthly reports (Income Statements, Cash Flow, G&A, and Balance Sheet) that that were benchmarked to prior periods for Actuals, Budget, and multiple Forecasts. Most dynamically linked through Excel to our accounting software through live DDE links.• Automated the production of many parts of the monthly board presentations which made the reporting easier to produce and more accurate.• FX Cut Savings - Saved Quiznos $275,000 per year on foreign exchange banking fees (Reduction of 90%) by spotting flawed fee schedule and negotiating with banks to bring fees in-line or below market.

Englewood Colorado

Analyze the efficiency of product distribution between warehouse facilities and their service contractors. This work entailed manipulating large quantities of data in Excel and preparing reports for senior management.

Denver, Co

• Compliance – Manage the firm’s compliance responsibilities pertaining to the Securities and Exchange Commission and all other regulators. This involves filing paperwork, writing and maintaining internal documents, and conducting internal audits.• Data Integrity and Reporting – This business is very data intensive so it was important that all systems be maintained including the portfolio management system, daily transaction reconciliation, and all internal access databases. Additionally, major projects included preparing the quarterly performance reports, quarter end billing statements, tax statements, and maintaining the integrity of all internal systems.• Office Management – Handle the day to day internal operations of the company. Tasks include company bookkeeping, maintaining the corporate books, monitoring computer systems and coordinating maintenance and upgrades, and be the internal escalation point for any operational issue.

Responsible for project management of process and procedure development, and collaboration with global team to ensure consistency of procedures affecting all areas of Operations. Final documentation to be in consistent format and to meet the approval of users, heads of department, operations control and European regulators.• Organize meetings with managers of various departments as per plan and timeline laid down by Operations Control Management • Rewrite existing processes and procedures to adopt new format and comply with European regulators.• Coordinate with counterparts in other regions to ensure global harmonization.

Mergers & Acquisitions • Created revenue and expense forecasts on newly acquired universities. • Performed in depth Due Diligence on potential acquisition that included auditing and reporting on 120 aspects of the target including: evaluating financial statements, quality of receivables, IP, tax, cash flow, receivables, PP&E, bad debt, property, and many others resulting in decision not to purchase. Endowment Fund Investment Analysis and Reporting • Prepared month-end and quarterly investment reports for the investment committee. • Researched and implemented software to track performance of separate investment accounts and consolidate reporting. • Reconciled all historical investment transactions, verified the accuracy of the transactions, and then imported all the transaction into the new system.Real Estate • Managed projects to lease and construct new campuses in 4 separate geographical areas of the county. • Presented monthly cost estimates and actual expenses to the CFO. • Analyzed student and staffing forecasts to determine expansion requirements.

• Confirmed executed trades with brokers and provide allocations and account information.• Assisted operations with front-end trade-settlement problems.• Assisted Trade Manager and Compliance on various trade issues.• Acted as a liaison for trading between Operations, Client Service, Compliance, and Counterparties. • Reconciled daily trading activity between internal accounting and trading systems.• Entered trades into trading and accounting systems (Portia and Bloomberg).

• For 6½ years I traded ETFs (Exchange Traded Funds) as a Specialist on the floor of the Chicago Stock Exchange in a high paced environment where I made between 600-2400 trades per day. To help me effectively trade ETFs, I developed models in Excel (feed with data through DDE links from Reuters/Bridge) to signal buy and sell opportunities based on a comparison between index cash values and current stock prices. I hedged similar indexes together to mitigate risk as well as traded baskets of stocks against specific indexes. Most importantly, trading in this environment has taught me how to manage risk, minimize losses, plan exit strategies, and most importantly to trade sensibly.

• For 6½ years I traded ETFs (Exchange Traded Funds) as a Specialist on the floor of the Chicago Stock Exchange in a high paced environment where I made between 600-2400 trades per day. To help me effectively trade ETFs, I developed models in Excel (feed with data through DDE links from Reuters/Bridge) to signal buy and sell opportunities based on a comparison between index cash values and current stock prices. I hedged similar indexes together to mitigate risk as well as traded baskets of stocks against specific indexes. Most importantly, trading in this environment has taught me how to manage risk, minimize losses, plan exit strategies, and most importantly to trade sensibly.

• For 6½ years I traded ETFs (Exchange Traded Funds) as a Specialist on the floor of the Chicago Stock Exchange in a high paced environment where I made between 600-2400 trades per day. To help me effectively trade ETFs, I developed models in Excel (feed with data through DDE links from Reuters/Bridge) to signal buy and sell opportunities based on a comparison between index cash values and current stock prices. I hedged similar indexes together to mitigate risk as well as traded baskets of stocks against specific indexes. Most importantly, trading in this environment has taught me how to manage risk, minimize losses, plan exit strategies, and most importantly to trade sensibly.

• Provided clients with detailed information about their investments assisting them in evaluating their portfolios.• Responded to client-specific consultant questionnaires pertaining to performance and asset allocation.• Prepared presentations on investment performance for quarterly institutional client reviews.• Provided aggregate company, separate account and commingled fund financial data for Requests for Proposals.• Researched Eastern European economies for future company investments.

• Created and institutionalized a macro intensive modeling application automating the calculation of benefits, reducing cycle time by 70% and reducing actuarial costs by $125,000 per year. • Calculated detailed retirement annuities based upon numerous factors relating to each client’s employment history. • Advised clients on the options available to them concerning the distribution of their pension at retirement.• Trained and counseled nine coworkers in calculating retirement and disability benefits.• Wrote articles for and assisted in the designing and editing of a newsletter entitled, “For Your Benefit.”

Mba, Finance

Bsba, International Business And Economics

International Business And Culture

http://www.semesteratsea.org/

Certificate, Spanish Language

Activities and Societies: Intensive 3 month Spanish language studies in Almunecar, Spain.

Diploma

Series 7, 63, 55 (Expired 2008)