Management Financial

HILDA MWANGI

***** ********** *** **********, ** 20874 301-***-**** *****.******@*****.***

CAREER HIGHLIGHTS

Achievement-oriented professional with diversified experience in financial planning & analysis, accounting,

cash flow management, performance reporting, and forecasting. Excellent analytical skills and ability to

understand risks related to complex project issues and quantify results. Effective communicator and problem

solver

SKILLS SUMMARY

Pro-forma Analysis Domestic & International Cash Flow Financial

Accounting

Database Management Analysis/Management Monthly

Forecasting

Budget Administration Forecasting/Trend Projection Performance

Reporting

SOFTWARE SYSTEMS

Proficient in Microsoft Excel, Access - including basis SQL, PowerPoint, Word, PeopleSoft and Hyperion

PROFESSIONAL EXPERIENCE:

Neustar Inc, Sterling, VA

Sr. Financial Analyst January 2009 –

Present

• Work closely, on a monthly basis, with members of the senior leadership team in the Corporate functional area to

understand critical business drivers behind financial forecasts and actual performance

• Involved in all aspects of compiling annual budgets and 5-10 year plans Manage the budgeting, execution

and reporting of annual financial plans and forecasts in Excel models for business units.

• Review actual operational costs by budget category and examine variances from budget to ensure

that they are explained and accurate. This function involves in-depth review and analysis of all

budget related transactions in GL accounts, including A/P detail, unpaid invoices and carry forward

of accruals.

• Perform monthly financial close activities including month end journal entries, accruals, reclassifications and

capital expenses

• Provide thorough analysis and commentary on variances between actual results and forecasts to be used for

reporting as well as the monthly close and management review meetings.

• Provide ongoing maintenance to the forecasting model.

• Develop and maintain other financial models that are used in helping our business partners in the Corporate

function area drive value added decisions

• Participate in special projects, as required, by providing financial support to various ongoing and ad hoc

initiatives across the company

• Consolidate and develop presentations on a monthly basis for the Executive Team and the Board

• Assist in the enhancement of the Hyperion reporting tool

Fannie Mae Corporation, Washington, DC

Business Analyst January 2007 –

January 2009

• Responsible for the development and support the Lender Channel department to provide high impact

analysis for issues critical to national profitability, market penetration, goal attainment, and delivery

of customer value.

• Responsible for collaborating with constituents across the organization (including Capital Markets,

Corporate Strategy, Product Development and Investor Channel) to produce an all around analysis of

the flow business.

• Create and maintain the fee forecast for the Single Family business on a monthly basis.

• Design, implement, manage and report on national profitability and market share metrics. This

includes recommending new methodologies for measuring acquisitions and metrics related to

profitability, and the profile of loan delivered.

• Manage projects against defined timelines by leveraging project management methodologies with a

focus on performance metrics and efficiencies.

• Cultivate and promulgate knowledge of the corporation’s execution analysis and competitive

position to proactively identify and initiate discussion of strategic issues and what meeting the

market would look like in a forecast.

• Identify trends in data and investigate root causes and draw management attention to the issue while

offering solutions when appropriate.

• Lead forecast and budget discussions and presentations with Directors and VPs.

Varsity Group Inc. Washington, DC

Corporate Financial Analyst June 2005 – December

2006

• Analyzed financial information; detailing assets, liabilities, preparing balance sheets, profit and loss

statements and other reports to summarize and interpret current and projected company financial

position for department heads.

• Led in the financial planning and budget process by modeling financial initiatives. This included

forming a new annual budget by providing drafts of budget proposals, reviewed prior budget and

coordinating with the Controller’s new budget reviews.

• Researched, analyzed and forecast products to identify risks and controls related to operations.

Established internal controls with various operational business units.

• Developed strategies to maximize corporate liquidity, minimize cost to departments, and managed

financial risk.

• Managed daily financial analysis and other operational ad hoc research requests from senior

management.

• Made recommendations for process improvements and financial action plans based on financial

information gathered.

• Performed variance analysis on monthly results and escalated identified issues to senior management

• Ensured approved initiatives were captured in the budget and were analyzed monthly.

• Provided analysis of financial compliance, projected financial results, new deal analysis and

assessment of potential acquisitions.

Airfare Planet, Oregon. Portland, OR

Sr. Financial Analyst June 2003 to

June 2005

• Directed the budgeting process by establishing planning guidelines and processes.

• Assisted with preparing quarterly forecasts and program-level analysis incorporating revenues,

expenses, capital requirements, cash flow and bank covenants for the fiscal year.

• Prepared and presented consolidated financial statements and outlooks to executive management.

• Developed reports that identified and interpreted current business developments and trends and their

impact on the company's financial results through monthly variance analysis and P&L reports.

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

alternatives.

• Provided information to senior management by assembling and summarizing data; preparing reports;

and presenting findings /analysis.

• Researched financial and budget problems that were identified and provided solutions and recommendations.

• Analyzed budget vs. actual data to determine financial status and monitored variances from plan.

• Improved financial status by analyzing results, identified trends, and recommended actions.

• Coordinated efforts of cross-functional teams in the budgeting, design, development and

implementation of automated solutions to the evolving needs of the customer.

• Devised control processes for continuous monitoring and improvement

EDUCATION:

• MBA, Willamette University, Atkinson Graduate School of Management ( 2005)

• B.S., Business Administration in Accounting, Eastern Oregon University (2003)

Contact this candidate