Resume

Sign in

Sales Financial Analyst

Location:
Peekskill, New York, United States
Posted:
August 31, 2017

Contact this candidate

Michael Fichera Jr., MBA

Peekskill, New York

Cell (914) ***-****, E-mail: ac13q9@r.postjobfree.com

Summary

Well – disciplined, pro-active and results oriented financial professional with extensive diversified corporate experience in all aspects of Financial Planning & Analysis. Proficient in problem solving and the construction of analytical models that enable the assessment of the big picture for the decision-making process. Excellent PC skills with an aptitude for interfacing with IT in the various matters that arise in the handling of large amounts of data necessary for analysis. Also possess good communication skills and diplomacy necessary in dealing with various departments within an organization. Always seeking to build in efficiencies that result in cost reductions. Team player also sees projects through completion.

Strategic Financial Planning

Financial Reporting Package

Sales Analysis & Forecasting

Forecasting & Budgeting

Access & Excel Modeling

Essbase/Smartview/Ad hoc

Margin Analysis

Variance & Trend Analysis

Liaison with IT

Graphical Analysis & Presentation

Profit & Loss

Efficiency enhancements

Technical Acumen

Courses: Intermediate and Advanced Microsoft Excel, Intermediate and Advanced Microsoft Access Database

Windows, Microsoft Office, Lotus, Excel & Excel Macros, Access, CA-DataQuery, Hyperion Enterprise, Hyperion Smartview and Essbase, SQL Financials, Brio-Query, Oracle Financial Analyzer, SAP

Education

MBA, concentration in Finance, Iona College, New Rochelle, NY.

BBA, concentration in Marketing with minor in MIS, Iona College, New Rochelle, NY.

Professional Experience

CHARTER COMMUNICATIONS, Stamford, CT

Sr. Financial Analyst 03/2017 - 07/2017

As a consultant, assisted telecomm firm Capital Dept. in creating reports in Essbase and creating ad hoc queries to facilitate decision making and reporting function.

DAYMON WORLDWIDE, Stamford, CT.

Sr. Financial Analyst 2/2017 - 03/2017

As a consultant, assisted International Division of Retail Services firm in creating reports in Essbase and creating ad hoc queries to facilitate the reporting function.

KFORCE/WORLDQUANT, Old Greenwich Ct., New York 12/2015 - 06/2016

Financial Analyst

As a consultant, assisted Investment firm in transitioning historical general ledger data from old legacy systems into new ERP Workday software utilizing excel models.

CHARTWELLS INC., Rye Brook, New York 11/2006 - 10/2015

Sr. Financial Reporting Analyst

For a food service company responsible for expense and revenue budgeting, financial analysis, analytical support, and monthly reporting.

Responsible for centralizing data and creating monthly reports utilizing SAP, Hyperion Essbase, Excel pivot tables, recorded macros, lookups, IF statements as well as Access databases to create complex financial models.

Reports include Presidents Report, Inventory Trend Report, DSO, Overtime, Gross Product Cost, KPI Report.

Initiated and designed first consolidated account historical P/L report consisting of 13 yrs. of account history.

Maintained and updated DSO report leading to the overall reduction of A/R times.

Initiated the use of Hyperion Essbase in the regional finance office and served as reference point for future users.

CITIZENS COMMUNICATIONS, Stamford, Connecticut 04/2003 - 10/2006

Sr. Financial Systems Analyst

For a local telecomm company responsible for the development and consolidation of the Capital and Labor Budget.

Utilized data file downloads, complex database and spreadsheet models, graphical analysis, as well as Hyperion Essbase to create monthly project based reporting distributed to top management.

Monthly reports include: indirect and direct overhead analysis, construction work in progress, plant in service, access lines, cost code analysis, projects overspend and expired, project ranking.

RESOURCES CONNECTION, New York, New York 11/1999 - 03/2003

Sr. Financial Analyst/Consultant

As a Consultant, performed financial analysis functions for various clients on project basis.

For Weight-Watchers Inc. developed quarterly G&A, budget, and FX variance models.

For Clairol Inc. a $1 billion division of Proctor & Gamble, performed SAP downloads and Hyperion uploads for input of monthly financials. Also consolidated financials in Hyperion, ad hoc reporting and analysis as requested by top management, budget, sales, P&L, variance, and headcount analysis.

Performed ad hoc analysis and budget consolidations for IT division of Deutsche Bank utilizing Hyperion Essbase.

Consolidated and set up sales data for analysis for heavy equipment division of AGFA Inc.

Consolidated financials, revenue & expense budgets as well as Balance Sheet, Cash Flow Statement and gross margin analysis for IPO for investment economic research firm.

Designed Capital Project invoice tracking database in Access for Bank Paribas expansion build-out.

Designed operating and capital budget model for Internet advertising company enabling them to acquire working capital funding of $25 million.

ACCUBANC MORTGAGE CORPORATION, Dallas, Texas 01/1998 - 05/1999

Sr. Financial Analyst, Financial Reporting Department

Supervised three analysts in the performance of daily financial analysis necessary to produce monthly corporate Financial Reporting Package.

Utilized databases and spreadsheets to create financial models to supply top management with ad-hoc financial and budget reports.

Enhanced spreadsheet processes to create efficiencies.

DAL-TILE INTERNATIONAL, Dallas, Texas 12/1995 - 01/1998

Financial Analyst, Finance Department

For a ceramic tile manufacturer, responsible for business unit financial analysis and planning.

Performed the compilation, consolidation, and analysis of budgets and Profit & Loss Statements, utilizing Oracle Financial Analyzer.

Created and maintained sales forecast database for major customers including inventory and stock levels.

Utilized spreadsheets, databases, and SQL to perform PC downloads used in various ad-hoc analysis including margin, cost, trend, and variance analysis.

CONSULTING ASSIGNMENTS 1994 - 1995

BOLLINGER INDUSTRIES, INC., Irving, Texas (02/1995 - 11/1995)

Forecast Analyst

For manufacturing firm, utilizing Excel initiated first corporate product sales forecasting system.

Created ad hoc sales analysis and graphical product profiles to be utilized in trend analysis by various departments.

Utilized Wal Mart Retail Link to track sales and product demand.

BANK OF AMERICA, Dallas, Texas, Trust Manager (08/1994 - 02/1995)

LIBERTY SPORTS, Dallas, Texas, Financial Analyst (07/1994 - 08/1994)

PHASE II, INC., Plano, Texas

Analyst 03/1993 - 07/1994

For a manufacturing representative in sales to JC Penney, responsible for the tracking of product sales, contracts, product estimates, shipping and various product development issues.

Automated quarterly and yearly product projections and forecasted yearly commission and monthly production levels.

Designed reports to perform variance analysis of estimated units shipped per month incorporating product contracts to enable a better view of contract position.

CITY OF DALLAS, Dallas, Texas

Budget Analyst, Department of Budget and Research 02/1991 - 02/1993

Responsible for the administration of operating budgets for various municipal departments and interfaced with them.

Utilized projection methods to perform variance, and trend analysis of revenues and expenditures.

Created spreadsheet models and graphics to compile various reports for the City.

MANUFACTURERS HANOVER TRUST COMPANY, New York, New York

Assistant Manager/ Operations Officer, Energy Division 10/1982 - 04/1990

Performed bank syndication, which included tracking outstanding loan balances, interest and fee calculations, distributing funds, and verifying loan compliance.



Contact this candidate