Project Management Financial Analysis

MARCUS WASHINGTON

301-***-**** *************@*****.***

Achievement-oriented financial professional with diversified experience in accounting, funds/cash flow management, business support, performance reporting, and financial analysis. Expert Microsoft Office (Excel, Access, PowerPoint Visio, Project, and Word) skills, excellent project management, multi-tasking, organizational aptitudes, and proven ability to influence business partners. Extensive experience in cost improvement and capital expenditures (CAPEX) project analysis, annual business plan development, and multi-million-dollar budgeting.

Extensive careers in diversified corporate finance and public accounting, including asset and risk management with respected industry leaders. Strengths and management experience include the following:

Corporate Consolidations: Developed a database to convert SAP to Access, which was used to house confidential and proprietary information. Highly proficient in forecasting budgets for multiple segments with revenues totaling $36 billion. Report and Design Purchase Orders database to log all POs for Projects and complete Accruals.

Project Management: Designed and developed a database for a secondary mortgage company to track interest expenses on over 10,000 active-duty military loans. Created over 40 reports used by executive management and internal and external auditors. Developed project plans and measured project progress with Fannie Mae proprietary software – equivalent to Earned Value Management (EVM).

Capital Appropriations: Built an Access database and an Excel model used to amortize depreciation on capital assets valued at over $100 million.

Financial/Cash Flow Analysis: Designed a variety of financial statements that were used for financial modeling, utilizing advanced skills and experience in Microsoft Excel (Pivots, look-ups, graphs, formatting)

Staff Management: Led various teams of employees and contractors in public and private industries, building performance and leadership skills and providing coaching. Federal Budget Process, Planning, Programming, Budgeting, and Execution (PPBE)

SKILLS SUMMARY:

Pro-forma Analysis

Monthly Forecasting

Capital Expenditures (CAPEX) Analysis

Multi-million Dollar Budget Administration

Domestic & International Cash Flow

Variance Analysis

Forecasting/Trend Projection

Financial Accounting

Database Management

ROI Maximization

Investment Strategies

Project Management

Analysis/Management

Systems Implementation

Strategic Planning

Process Mapping & Improvement

SOFTWARE SYSTEMS:

Expert in Microsoft Excel (Pivots, look-ups, graphs, formatting), Access, PowerPoint, Word, Project, and Visio; highly proficient in CIS System, Oracle Database, Oracle Project Accounting, Oracle Financial software, BRIO (Government Accounting System/Query), Deltek System, PeopleSoft, LEXS 2000, SAP, SAS, Essbase, Services Now, Planview Forecast, Anaplan, Apptio, Power BI, Tableau and Hyperion

PROFESSIONAL EXPERIENCE:

Fannie Mae Corporation, Washington, DC

Senior Project Finance Manager August 2020 – Present

Oversee processing or analyzing large amounts of data efficiently using advanced financial engineering tools and techniques. Determine the customer's intended uses for financial analysis or model. By using Workday's Adaptive Planning for Scenario Planning, Collaboration with Teams, and Reporting of Dashboards.

Maintain a team responsible for Portfolio Manager on financial analysis or forecasting, which may include scenario or sensitivity analysis, stress testing, or attribution analysis.

Developed, designed, and executed financial models and/or interpreted model results. Translate the results from the analysis of models for the customer into understandable conclusions.

Provide monthly, quarterly, and annual financial reporting to Project/Portfolio leadership and/or Technology Services leadership ahead of deadlines for Actuals, Forecasting, and Variance analysis.

Strong Excel skills in pivot tables for lots of forecasting, reporting, and designing the mechanics of the dashboard for reporting. Creating various charts and graphs for PowerPoint and Excel presentations using data from Power BI, Tableau, Hyperion, Oracle, and SAP allocation budgets to brief agency senior leadership and external stakeholders on budget and financial management issues.

Various Budget expenses define the budget, variance not only in dollars but also in the resource (labor cost) capacity model. Used Plainview application to manage project budget, resource forecast, and vendor invoice processing through financials. Used the application to enter, track, and report on portfolio objectives, milestones, and planned metrics. When linked to JIRA, they tracked the status of epics and delivery project releases.

Maintain financial controls and systems for recording, monitoring, forecasting, and budgeting all project expenditures. Analyze project actuals versus forecasts. Prepare monthly accruals and analyze them against payments. Report and Design Purchase Orders database to log all POs for Projects and complete Accruals.

Developed monthly financial analysis using Power BI and Tableau to help facilitate in-depth financial analysis by allowing slice and dice data based on various dimensions such as time, product, region, or department.

Prepare monthly software capitalization (CAPEX) reporting and quarterly software impairment reviews. Analyze all data and project forecasting to ensure adherence to all timeframe requirements.

Developed and Maintained policies and procedures. Coaches, mentors, or training others were needed on financial topics related to their role. Communicate with senior leadership in the language and information they request, enabling them to act as needed.

Work with Program and Project Managers, or within a PMO, to ensure financial information (resource forecasts and direct costs) is accurate and completed as per deadlines for the enterprise.

Knowledge of working in an Agile environment. I have various knowledge of SAFe (Scaled Agile Framework) practices and the use of JIRA.

Cleveland Clinic Health Care, Washington, DC

Senior Project Finance Manager January 2022 – February 2023

(Part-Time)

Solid Financial Project Management skills and understanding of cash flow management and overall financial principles. Ensures timely and accurate cash flow projections of medium and large-scale sized IT capital projects.

Conducts regular touchpoint reviews with project owners and end users to ensure projects are on schedule and are meeting timelines. Helps to maintain portfolio roadmap based on spending projections and timelines.

Developed monthly financial reporting by means of experience leveraging complex models using data analysis software in Oracle General Ledger Reporting, Excel-based financial models, and Power BI dashboards to conduct Cost of Care Analytics

Makes perpetual updates as needed based on project timeline revisions. Design and maintain project tracker workbooks, logging payments in an accurate and timely manner.

Manages lifecycle flow of capital requisitions to invoice payments, helping to inform cash flow. Enter capital requisitions as needed. Potentially it would help to conduct RFPs for contractors that are being sourced for capital projects.

Responsible for developing, interpreting, and implementing financial concepts for financial planning and control. Also, perform technical analysis to determine present and future financial performance, gather and analyze financial data, and prepare and summarize recommendations for financial plans, acquisition activity, trended future requirements, and operating forecasts.

Exelon Corporation, Baltimore, MD

Senior Project Finance Manager June 2019 - August 2020

Utilize business intelligence reporting system, use Hyperion for reports and projections, Oracle Accounting System/Query to collect and process data to produce financial reports, and ensure all divisions disbursed funds in accordance with regulatory guidelines. Also, use Supply Chain Finance Reporting to track project statuses.

Develop and conduct short-term and long-range business planning. Conduct complex modeling, forecasting, trending, variance analysis, business case development, and other financial and operational analyses (e.g., operational effectiveness, budget, resource, workload, workforce and capacity utilization, competitors, etc.).

Provide statistical information to ensure the most effective utilization of personnel, equipment, and/or materials for business operations. Track, maintain, analyze, and provide current information on the operations business scorecard or key performance indicators (KPIs) using and utilizing Power BI.

Develop, organize, and present detailed performance reports for both internal and external use. Develop, implement, evaluate, and lead projects/initiatives (e.g. business plans or process improvement initiatives). Provide broad analytical and operational support to the business units.

Notable Accomplishments:

Provide financial analysis and reporting for management on major capital expenditure (CAPEX) and O&M cost drivers. Work with personnel to control and manage costs. Forecast performance against goals, plans, and budgets. Bring a financial perspective to daily operations. Prepared and reviewed month-end, quarterly, and full-year forecast/reports, including executive reporting packages, monthly financial close packages, and quarterly management meeting presentations.

Prepare and present periodic performance and financial reports to senior executive management including monthly standard reporting packages, quarterly review presentations, and operating review summaries. Leverage expertise in management with functional leadership on projects and ad hoc requests promoting knowledge transfer and financial accountability across the organization.

United States Department of Agriculture (USDA), Washington, DC

Food Safety and Inspection Service (FSIS)

Senior Finance Project Controller Manager/Consultant August 2009 – June 2019

Responsible for the Execution and Formulation phases of the budget process with specific emphasis on the Formulation Estimate Phase, guided by the Office of Management and Budget (OMB) Circular A-11 as well as the Agency’s strategic plan, associated goals, and annual performance plans. Budget Formulation was based on executability, program content, pricing, cost-benefit, and statistical analyses for programs, projects, activities, and personnel.

Performed ongoing reconciliations, analyses, and reviews of Agency financial and budget data from PeopleSoft database utilizing the USDA Financial Management Modernization Initiative (FMMI) accounting system and other feeder support databases. Developed applicable queries in PeopleSoft for FMMI for recurring reconciliation processes and analyses.

Assisted FSIS in developing methods and procedures for evaluating financial data integrity issues and recommended appropriate corrective actions and solutions. Conducted data validation and reconciliation of budget and financial accounts. Recommended functionality enhancement opportunities.

Developed trend analysis methodologies, status reports, and charts using Agency program performance indicators leading to operational effectiveness, fiscal responsibility, and financial management.

Evaluated the progress and cost-effectiveness of accomplishing Agency program plans, goals, and objectives using specifically devised criteria.

Developed monthly Budgeting and Forecasting using Power Bi or Tableau to create interactive reports that show actuals, budgets, and forecasts side by side. This enables you to monitor financial performance, compare actuals against targets, and identify areas that require attention.

Assisted in both support and leadership as requested on ad hoc projects related to the OCFO budget, financial management, and management decision-making.

Applied financial management and federal budgeting principles to serve as an analytical reviewing authority for studies, and other products of research conducted toward program requirements.

Developed life cycle cost analyses of projects or performed cost-benefit or economic evaluations of current or projected programs.

Conducted organizational efficiency and productivity studies and recommended changes or improvements in organization, staffing, work methods, and procedures.

Analyzed management information requirements to develop program or administrative reporting systems including specifications, data gathering, analytical techniques, and systems evaluation methodology.

Analyzed Financial Operations Managers for the overall Finance execution across the organization. This includes but is not limited to Budget and Cost Management, Accounting Changes, Estimates at Complete (EACs), Financial Forecasting including the Long-Range Business Plan (LRBP), and associated variance analysis.

Examined costs and estimates and developed alternative or new cost methodologies to produce independent cost estimates.

Investigated new cost methods and approaches, developed complex financial models, proposed new cost strategies, and developed cost-estimating policies using a wide range of analytical and statistical techniques.

Interpreted and assessed the impact of new and revised legislation on the formulation and execution of the organization's budget.

Notable Accomplishments:

Created a Salaries and Benefits Model Template for all divisions in the FSIS Department to track 10,038 employees and 313 vacancies totaling over $785 Million in Salaries and Benefits. The model maintains job titles, pay increases, actual data, and forecast data across all 12 divisions by pay period and monthly totals. A robust database was embedded in this model for effortless and timely reporting, including graphs and charts to reflect annual trends across all 12 divisions.

Designed a program Spending Scorecard for FSIS that was used to assign tangible metrics to measure the effectiveness of spending categories. The Scorecard allowed management to assess trends, track progress and assign monthly scores to each financial category based on performance against the plan. The Scorecard can track over $1.1 billion of spending by tracking obligations and outlays for Salaries and Benefits, Awards, Travel, and Operating Expenses.

Utilized project planning skills to drive new projects, tool development, and analyst training on long-term FSIS Financial initiatives and changes such as activity-based cost budgeting and new allocation processes.

Designed the Annual Baseline Planning Template for the Formulation and Execution Branch of FSIS to capture the FY 2019 plan and forecast the needs for FY 2019, 2020, and 2021. Implemented uniquely designed features, such as drop-down menus, fund code details, and pivot tables which improved overall branch efficiency and analysis. Supported and developed guidance, advice, and recommendations on the budget process and the assigned budget area to the program and other managers. Developed, recommended, and Implemented Agency budgetary policy and provided procedural guidance.

Assisted in improving the reporting on the monthly status of all open obligations by designing an FSIS open obligation report/database for the 12 Program Areas within FSIS to track key financial information including vendor name, aging, obligation amount, outstanding balance, spending inactivity timeframes and date to de-obligate funding.

Designed the FY 2019 and FY 2020 Allocation Budget ($1.1B) model across 12 divisions, with varying programs, 9 categories of expenses, and 6 sources of funds as well as a database to house the Allocation Budget with pivot-table-style reporting by the source of funds and programs. Plans to organize, coordinate, and carry out annual and multi-year budgeting in support of assigned appropriations, bureau(s), or major bureau components or programs. Analyzed, consolidated, and revised budget execution plans as needed. Made recommendations from prior funding levels as Input to initial budget execution plans.

Created the monthly Cash Flow Model, supported by Revenue, Amount Billed, Amount Collected, Write-Offs, Expenses, Direct Labor, Direct Non-Labor, and Indirect Overhead.

Designed various charts and graphs for PowerPoint and Excel presentations using data from FY 2019, 2020, and 2021 Allocation Budgets to brief Agency senior leadership and external stakeholders on budget and financial management issues.

Developed and designed a robust real-time Status of Funding report to enable the department to ensure all divisions are disbursing funds within regulatory guidelines. Planned, coordinated, organized, and executed the annual and multi-year budgeting in support of assigned appropriations, bureau(s), or major bureau components or programs.

Utilized the Business Intelligence Reporting Accounting system (BRIO) and SAP Accounting System/Query for processing, modifying, and creating financial reports for the U.S. Dept of Agriculture (USDA), Food Safety, and Inspection Services (FSIS) division.

DC Commission on the Arts and Humanities (DCCAH), Washington, DC

Acting Finance Director January 2009 – August 2009

Researched and analyzed DC Grants to identify risks and controls related to operations.

Developed financial procedures on the disbursement of funds for grants and use/completion of tasks in the financial system with end-to-end implementation for accurate financial records.

Prepared monthly and annual budget tracking using the existing system for the Arts and Humanities department as well as monthly variance analysis and ad-hoc management reporting.

Notable Accomplishments:

Established internal controls with various operational business units and developed tracking and key performance indicator (KPI) reports.

Strengthened the organization’s credit card account reconciliation process and minimized losses due to operational control issues. Increased the depth of reconciliation analyses through database utilization, using Microsoft Access and Excel, allowing a wider window to resolve accounting exceptions.

Designed and developed a robust database to track FTEs and Consultants.

Fannie Mae Corporation, Washington, DC

Senior Finance Manager March 2001 – January 2009

Developed the annual budget by providing drafts of budget proposals from various operational business units, reviewing the prior budget, and coordinating with the Controller’s new budget. Comparison of actual to budget data including in-depth review and analysis of all budget-related transactions in GL accounts (A/P detail, unpaid invoices and carry forward of accruals). Presented results to senior management monthly. Prepared various ad-hoc management reports.

Prepared detailed monthly rolling forecast allocating departmental expenses. Managed and communicated cash flow. Provided oversight into revenue and expenses while ensuring accurate reporting.

Developed and implemented measures to improve financial control mechanisms, reporting, and accounting systems. Prepared and facilitated annual audits, individual program audits, and annual financial reports.

Facilitated training and development of finance staff and personnel in the field of financial management, IT, and risk management, as required. Mapped out Finance and Accounting team goals that were fully aligned with the foundation’s goals, mission, vision, and values.

Performed financial and operational analysis on key performance indicators including flow profitability and market share. Prepared monthly management reports including variance analysis and industry benchmarking. Monitored corporate, market, and industry trends to develop and propose profitable customer solutions to staff and management. Worked with Operations and Marketing to proactively mitigate impacts resulting from new product launches.

Notable Accomplishments:

Strengthened the account reconciliation process and minimized losses due to operational control issues. Increased the depth of reconciliation analyses through database utilization using Microsoft Access and Excel, allowing for a wider window to resolve accounting exceptions.

Developed and tested numerous new theoretical and financial models designed to synthesize large amounts of complex data to forecast business activity. Determined the need to execute internal management reports.

Recommended several new methodologies for measuring acquisitions, including metrics related to profitability, profile, product, and lender. Assumed leadership responsibility for mobilization regarding housing goals and exploring opportunities for achieving greater goal attainment through flow business.

Dynamics, Inc./Logion Corporation, Landover, MD

Finance Director June 2000 – March 2001

Provided in-depth financial analysis of strategic enterprise telecommunications alternatives for the IRS and Treasury in support of the Telecommunication Enterprise Strategic Plan (TESP).

Coordinated efforts of cross-functional teams in the budgeting, design, development, and implementation of automated solutions to the customer’s evolving needs.

Managed forecast, budget, and month-end closing procedures as well as provided management with monthly analysis and reporting. Managed monthly expenses for Cost Centers in the organization.

Supervised a staff of 10 by providing leadership and direction to a team of project managers, team leads, and developers in the delivery of financial solutions.

Directed a 3-person financial team within a multi-vendor environment, integrated projects in collecting and managing large amounts of financial information from several government organizations and large corporations.

Notable Accomplishments:

Led the development and expansion of a baseline financial model used to support the assessment of strategic alternatives.

Built net-present-value, cost/benefit, and full life cycle costing models that provided rapid and flexible alternative assessments.

Developed a strategic telecommunications business case and presented a summary of findings to an executive steering committee.

Piloted the development of appropriate funding methodologies for telecommunications internal to the IRS and Treasury.

MCI WorldCom, Corporate Planning and Budgeting, Washington, DC

Manager/Senior Financial Analyst July 1997 – June 2000

Managed staff that assisted in the preparation of short- and long-term forecasts of earnings and financial position including revenue, expense, and capital expenditures (CAPEX) forecasts in Excel and Oracle financial software.

Prepared and developed monthly consolidation reporting for cash flow, shares, other income/expenses, and goodwill financial models.

Reviewed and analyzed the monthly local service business operations report. Addressed the attainment of profit/loss goals, actual vs. plan, and department activity with senior management.

Prepared quarterly reporting detailing financial results for presentation to executive management using PowerPoint. Prepared external financial reporting for the Company in accordance with GAAP and SEC requirements.

Notable Accomplishments:

Developed and designed new models for local service lines and trunks (circuits) by city and state monthly. Designed switch utilization models to compare wired circuits vs. working circuits.

Prepared a financial model to show LCN/Switch Services on and off the network for special access, long-distance and local services showing the penetration of buildings with and without revenue.

Oracle Corporation, Oracle Government Division, Herndon, VA

Senior Financial Analyst December 1995 – July 1997

Created all project accounts, including additions of tasks to existing contracts as they related to project information, client profiles, and funding in Excel and Oracle financial software. Served as employee information administrator in the project accounting system. Established, maintained, and reviewed all internal consulting deals.

Produced timely and accurate invoices. Managed the ageing of all accounts receivable. Reconciled all project information accounts receivable, invoices, and other miscellaneous procedures as requested.

Managed all aspects of revenue, including revenue recognition for accruals and invoices, maintenance of balance sheet revenue accrual accounts, and revenue transfers.

Prepared monthly and quarterly ad-hoc predictions on Oracle data production using Oracle financial software.

Notable Accomplishments:

Designed a direct labor utilization model showing the direct labor ratio for all 9 units of the Oracle Data.

Lead analysis project to compare the difference between billable hours, budget direct labor ratio, actual direct labor ratio, and salary of a group of 72 employees managed.

Reviewed and controlled labor and non-labor expenses with project managers and group. Built a model to track interoffice billings for the Oracle Data Group.

Developed several complex financial models to make comparisons of the budget, actuals, and future projections of gross income, adjusted gross income, labor cost, planned and unplanned adjustments, acquisition costs, and direct labor ratio for the entire division.

EDUCATION: MBA concentrating in Finance/Accounting

University of Maryland University College, Adelphi, MD

B.S. in Finance/Accounting

University of Pittsburgh, Pittsburgh, PA

LICENSES: Financial Industry Regulatory Authority, Inc. (FINRA) Series 7, Series 63, Series 65.

MEMBERSHIPS: Chartered Financial Consultant, SEC Investment Advisory, and National Association of

Securities Dealers (NASD), New York Stock Exchange (NYSE), and Chicago Board Options Exchange (CBOE)

Contact this candidate