Post Job Free

Resume

Sign in

Financial Analyst Oracle Hyperion

Location:
Columbus, OH
Salary:
negotiable
Posted:
February 10, 2023

Contact this candidate

Resume:

Mansor V. Fall

Columbus, Ohio ***** ç 614-***-**** - C ç adu9h4@r.postjobfree.com ç www.linkedin.com/in/MansorFallmailto:adu9h4@r.postjobfree.com

PROFESSIONAL SUMMARY

Accomplished professional with extensive experience and strength in financial management, financial reporting, internal auditing, management reporting, manufacturing, mergers and acquisitions, organizational development, quality assurance, system development, and implementation

Successful record of re-aligning organizations to achieve better economics of scale, including management of turnarounds and shutdowns

Skilled in creating strategic plans and in leading high-performance teams to exceed pre-set goals

Proven instincts to identify and solve unique business issues

Solid experience in all five modules of Clarity Project Management Tool

Extensive experience in coordinating projects with project managers, program managers, and portfolio managers

Proven advanced knowledge Structured Query Language (SQL)

Proven knowledge of sales analysis, data science, financial modeling, business analytics, business intelligence,

The University of Toledo, Toledo, Ohio. BBA: Corporate Finance, National Deans’ List

KEY ACCOMPLISHMENTS AND ADVANCED SKILL SETS

Directed the general finance functions and supported the execution of a division’s financial and strategic plans; division generated more than $2B in revenue each year during my tenure.

Improve the availability and value of information using data to enhance performance of the sales business unit and drive revenue & profit growth.

Uncovered and proved embezzlement by a former Regional Accounting Manager, company recovered $300K.

Redesigned Chart of Accounts and financial statements by preserving comparability to reflect the company’s financial picture more adequately.

Successfully managed international invoicing and leasing of equipment.

Strong Microsoft PowerPoint Proficiency, Advanced Microsoft Access and Excel Expertise

Strong SAP and Oracle Hyperion Essbase Experience, codes and scripts writing,

SAP, SAP Business Warehouse, AS/400, Citrix, JD Edwards, Great Plains, FRX

Experience SQL Coding; Clarity Project Management Tool, Cognos, SharePoint, Business Objects, bi360

Tableau, Alteryx, and Microsoft Power Bi

Developing SQL queries, importing, and exporting large data.

CAREER EXPERIENCE

Goodwill Industries – Columbus, Ohio APR2018 - JUL2022

Director, Financial Planning, Analysis & Reporting

Manage Annual Budget and quarterly forecasts for segments such as Retail Stores, Business Services, Mission Services, Marketing & Development, and Management & General.

Development, updating and reporting of key performance indicators and productivity measures.

Partner with business segment management teams to develop business/operational plans and assisting to drive their implementation.

ROI analysis and recommendation of capital expenditures, and lease/purchase decisions.

Develop and update rolling P&L and cash flow forecasts.

Develop and evaluate pricing options for commercial contracts, grants, and other funding opportunities.

Provide leadership to special projects as required by business needs.

Develop and maintain Agency Scorecard.

Provide due diligence support during M&A or business partnership related opportunities.

Provide analysis support for new business development initiatives.

Provide leadership during the annual operating budget cycle.

Provide insightful budget and prior period financial performance variance analysis.

Provide leadership with the annual three (3) year strategic plan update.

Provide scenario analysis and other financial modeling to the management team.

Hire, train, and develop staff.

Other duties as necessary

American Freight – Delaware, Ohio DEC2015 - NOV2017

Financial Analyst

Support Accounting and other various functional departments in daily month end close activities which includes profit and loss analysis, balance sheet review and cash flows reviews.

Manage the monthly reporting process and prepare the monthly deck for upper management and board of directors. Prepare the quarterly deck for the board directors meeting.

Design and produce analyses/reports/dashboards for department and/or management.

Database administrator for the company new ERP and new reports writer application, conduct large data analysis. Develop an in-depth understanding of company current processes, software, and information needs in order to assist in the recommendation and implementation of new solutions to create more efficient and enhanced financial reporting.

Support the planning and budgeting activities for operation which consists of more than two hundred stores nationwide and Capital resource allocation process: including long-range forecasts, detail budgets, re-projections and contingency plans. Prepare monthly/quarterly variance reports and provide meaningful analysis of drivers. Prepare ad-hoc reports as needed to support analysis. Support decisions affecting operation activities, capital investment, and profitability objectives. Engage in developing and improving standardized processes surrounding budgeting, forecasting. Perform special studies, analysis, investigations, and assignments as may be required. Provide assistance in regulatory proceedings related to financial matters including information for data requests, developing revenue requirements. Support financial model and resolve potential issues. Prepare various schedules for external audit.

JPMorgan Chase – Mortgage Banking Technology Finance, Columbus, Ohio Mar2012 - Dec2014

Associate, Financial Analysis

Assisted Senior Manager with monthly assessment of performance and execution against budget across Technology departments and provide insight and understanding of results to Management.

Managed month-end accounting close and reclassification processes for Mortgage Banking Technology (MBT) Finance; created and maintained procedures and documentation for accounting and financial reporting functions (including monthly Outlook, Walk-forwards, Cash Taxonomy, Investment Analysis, Variance Analysis, Risks). Coordinated MBT Monthly Forecast process and Annual Budget which were reviewed and signed off by Technology Directors, in line with goals. Managed monthly Expense Reporting and Analysis, prepared Executive Management Reporting decks. Managed the weekly contract approval process to ensure timeliness and relevancy of categories of expenses; coordinated the creation of Business Cases and Spending Requests. Managed third-party Vendor details – Actual Spend vs. Budget / Forecast. Participated in Mid-Year Forecast, ICAAP, CCAR. Relied heavily on Clarity Project Management Tool for headcount tracking, budgeting, forecasting, capitalized projects, and ad hoc analysis in supporting various portfolio and program managers.

Designed and implemented a custom contract approval process and contract tracking system that resulted in the Department’s first ever Payment and Authorization process which standardized forms and included Matrix Pricing, Authorization for Special Terms and strict Approval Standards.

Recognized critical needs and developed a model to track fixed assets which had increased from $300MM to $850MM.

Conducted or participated in Technology projects where analysis requires an in-depth evaluation of factors.

Supported and drove process improvements.

Developed and maintained productive working relationship with Technology and other stakeholders.

Served as a corporate liaison and financial "mentor" to internal customers.

Maintained superior working knowledge of data and information resources.

Identify opportunities to control costs and reduce expenses.

Designed and implemented new financial data infrastructure and tools that optimized financial planning and analysis processes. Revamped internal procedures, processes and controls resulting in favorable audit scores compared to prior unfavorable scores.

Huntington National Bank Home lending, Columbus, Ohio SEP2009 -MAR2012

Senior Financial Analyst

Managed month-end accounting closing process and supported the annual budget for multiples departments: Servicing, Secondary Marketing, Shared Support, Mortgage Production, and Consumer Lending. Performed detailed analysis through the use of Access/SQL Databases. Coordinated monthly forecasting of Home Lending revenue and expense; responsible for the forecast of segments including Servicing, Shared Support, Mortgage Production and Consumer Lending. Prepared month-end reporting decks for upper Management review. Compiled monthly mortgage data for the purpose of MSR (mortgage servicing rights) modeling and prepare summary analysis of the MSR results. Calculated and prepared monthly accounting entries related to the MSR asset. Maintain documentation of MSR related controls and processes.

Enhanced forecasting tools and processes to improve loss forecasting accuracy, which added transparency to processes and reduced absolute loss forecasting variance under the corporate benchmark.

Implemented and developed new forecasting tools and processes, which improved financial reporting and forecasting accuracy; enhanced portfolio transparency; and reduced revenue forecast variance to under 50bp - compared to 9.0%+ under prior process.

Met with individual department heads to understand how they wanted to receive their budget to actual information and defined reports that met their needs. Resulted in increased use of reports and quicker decision maker attention to variances.

SP Plus Corporation, Columbus, Ohio NOV2004 - MAR2009

Financial Analyst

Managed Central Division month end accounting closing process and collaborated with Regional Accounting Managers to streamline the process. Reviewed locations P&L transactions for accuracy and completeness and prepared any correcting journal entries. Reviewed Financial Statements, New Business and Activity Reports, and other performance data to measure productivity and goal achievement and determine areas for cost reduction and improvement. Managed the evaluation, due diligence and integration processes for potential acquisitions. Participated in regulatory reporting while supporting GAAP research and SEC reporting; coordinated activities associated with the D&T audit. Directed and coordinated divisional annual budget and quarterly forecasts activities, maximize investments, and increase efficiency. Provided ad hoc analytical support to all groups Senior Vice Presidents, COO and CFO. Prepared financial scorecard variance comments for steering committee and quarterly review meetings. Reviewed the accuracy and completion of pro forma, return on investments (ROI), and memorandum of awareness (MOA) for new locations, existing location renewals, capital investments and acquisitions. Responsible for evaluation, reporting and control of Capital Expenditure projects. Coordinated and input the selection of locations for the quarterly Control Self-Assessment program (internal Audit) within the Division. Reported to COO.

Coordinated the preparation of the annual information package for the Board of Directors.

Improved the A/R procedures and reduced the Over 90-day A/R from $1.5MM to $400K in the first six months as Manager.

Cut A/R write –offs 440 annually by developing credit policies, instituting aggressive collection strategies and establishing constructive dialogue with delinquent accounts.

Saved company $500K in 2 years by researching, identifying cost saving alternatives on technology, equipment, travel, office supplies, etc.

Created and analyzed new business financial reports to make information more accessible and user friendly leading to an average increase of 15 percent in new business volume.

Championed the development and implementation of a Balanced Scorecard Business Performance reporting tool to evaluate Monthly Results against Key Measures.

Built local databases from scratch for forecasting and reporting, reducing lead time and errors.

Improved the accuracy of the annual budget resulting in significant cost savings of $1.6MM.

ADDITIONAL CAREER EXPERIENCE ç PROFESSIONAL DEVELOPMENT

Coopers & Lybrand Europe, now PWC (Public Accounting), Paris, France, External Audit

American Management Association Course on Financial Analysis

KPMG IFRS International Financial Reporting Standards Seminar

ADP Payroll Certification



Contact this candidate