**** ******** **. #*** ● San Francisco, CA *****
MAHARY KIDANE 415-***-**** ● ********@*****.***
EXPERIENCED SENIOR FINANCIAL ANALYST: Analytical and detail-oriented financial professional adept in budgeting, forecasting & modeling seeks a position as a Finance Manager. Proven track record of process improvement and exceptional ability to communicate across different layers of the organization as well as cross-functional teams.
PROFESSIONAL EXPERIENCE
CORE-MARK INTL., SOUTH SAN FRANCISCO, CA – MAY 2007 - PRESENT
Senior Financial Analyst: Manage & coordinate the entire budgeting process of a $7 billion revenue corporation. Improved the planning process which cut weeks from the planning calendar. Designed & led a sales planning project that encompassed cross-functional team members & resulted in a more accurate, detail & efficient sales plan.
Manage two financial analysts and provide them guidance and support when needed.
Managed a project that reconciled financial data from Cognos and AS400 program (the General ledger system).
Participated in a Merger and Acquisition process that lead to the acquisition of a new division.
Prepare weekly Snapshot report that summarizes & consolidates the P&L of 25 divisions for upper management.
Prepare monthly management and operational reports published for senior executives.
Converted the Excel planning tool to the new Hyperion version with limited training, guidance & a narrow deadline.
Developed training manual as well as trained division controllers and corporate accountants with Hyperion.
XOMA LTD, BERKELEY, CA - JAN2006 – MAY 2007
Financial Analyst: Led a one million dollar replacement cost project involving consultants, insurance company & inter-departmental personnel that concluded in a $500,000 settlement. Created and managed a project cost report for the Project Alliance Management group that resulted in visibility of project costs and comparison to project plans.
Prepared Executive Summary Reports that included a P&L statement that was presented in the Executive Staff Meeting.
Prepared the quarterly P&L statement for the board package.
Prepared the monthly Utilization report for the Preclinical and Cell & Analytical Development divisions.
Prepared the Collaborative Cash Flow report for the monthly executive staff meeting.
Audited all invoices and excel models that the Finance Department prepares.
Prepared the quarterly R&D expenses report that was used by the controller for tax purposes.
UNITEDHEALTH GROUP, SAN FRANCISCO, CA – JUN 2004 – JAN 2006
Financial Analyst: Built an allocation model for the Marketing & Account Management departments that led to a $300,000 savings in printing costs. Streamlined the Sales Pipeline report that allowed us to publish the report bi-weekly versus monthly.
Responsible for the annual budget and quarterly forecast for nine divisions.
Managed the modeling, design and consolidation of the budget & forecast Excel templates.
Prepared the Monthly Operating Results report to executives that allowed them to assess the pulse of the business.
Provided monthly SG&A variances versus budget as well as forecast to nine divisions & their sub-departments.
Prepared and distributed the Per Member Per Month and the temp report on a monthly basis.
VERIZON WIRELESS, WALNUT CREEK, CA – JAN 2004 – JUN 2004
Financial Analyst: Developed store equipment auditing tool that reduced excessive discounting, increased revenue and improved store performance. The tool lowered the number of stores in the Bottom 25 Stores with highest subsidies from ten to three ahead of schedule and beating our goal of seven stores.
Responsible for operating expenses variance analysis to determine the primary drivers in the P&L statement.
Analyzed the monthly expenses of commissions, purchase cards, temp employees’ pay and overtime pay.
Prepared monthly financial summary to associate director and the regional president for their staff meetings.
Determined under-performing stores and issued recommendations to the Associate Director and District Managers.
Improved stores in the lower revenue level from ten to one and improved the handset subsidy per unit by ten percent.
UNIVERSITY OF SAN FRANCISCO, SAN FRANCISCO, CA – MAY 2001 – JUL 2002
Financial Analyst: Performed a financial review of the College of Professional Studies to determine the financial & non- financial factors that affected its programs.
Analyzed and issued recommendations on a multi-million dollar interdepartmental billing process.
Trained & supervised new interns in maintaining budget office website and generating reports using Excel spreadsheets.
Completed financial forecasting & modeling to aid the Budget Director and the Board of Trustees.
Analyzed financial statements and evaluated the financial impact of different departments in the university.
Conducted an efficiency study of the Bursar’s Office to study the effectiveness of personnel in the department.
EDUCATION
MBA (Finance Emphasis) – University of San Francisco, San Francisco, CA - 2002
BS, Genetics – University of California, Davis, CA – 1997
TECHNICAL SKILLS
Excel, Access, Word, PowerPoint, Oracle, Cognos and Hyperion Financial Management (HFM) & Essbase.