Senior Financial Analyst Resume
Washington D, C
TECHNICAL SKILLS:
SKILLS: MS Excel, PowerPoint & Access; Oracle Business Intelligence Systems (Oracle Hyperion Essbase & Oracle Hyperion Smart View), Redwood Analytics, SAS - Gretl, Minitab, Eviews & Crystal Ball; the Street workshops in Financial Modeling, Corporate Valuation, & Leveraged Buyouts (LBOs) and Mergers and Acquisitions; Salesforce; MicrosStrategy
PROFESSIONAL EXPERIENCE:
Confidential, Washington, D.C
Senior Financial Analyst
Responsibilities:
- Created SmartView enabled dynamic exhibits within the 2016 President’s Budget using Oracle software that streamlined the reporting process by reducing input error probability
Confidential, Washington, D.C
Financial Manager
Responsibilities:
- Unified “Data & Voice”, “Service Management”, & “Office 365” business cases by constructing dynamic MS Excel dashboard leveraging VLOOKUP functionality graphically depicting budget vs actual financial data for Confidential thus providing a consolidated view and more efficient monitoring of key performance indicators
- Reviewed ten business cases submitted for capital funding requests of $19.5M+ for fiscal year 2016 by creating & verifying forecasting assumptions resulting in the approval of full funding for key business initiatives
- Performed lease rental analysis of Confidential ’s Atlanta service delivery center based on forecasting assumptions from Jones Lang LaSalle providing IT Finance group with key insight to their P&L management
Confidential, Washington, D.C
Financial Analyst
Responsibilities:
- Established a technique of reallocating state meeting funds amongst Confidential states resulting in cost savings of $150,000
- Constructed a detailed financial analysis memo in favor of a price increase for the online course showing an additional $900,000 in revenue to aid the ADS Driver Safety program in remaining competitive and financially viable for FY2015
- Provided budget variance analysis through the creation of forecast assumptions and data reconciliation from PeopleSoft financial systems resulting in never before realized clear monthly snapshots of revenue and costs
- Works in tandem with program finance manager to provide internal control & accuracy of all financial reports
Confidential, Washington, D.C
Senior Financial Analyst
Responsibilities:
- Provided accurate quantitative analysis of firm’s overhead costs in its 10 domestic and international offices resulting in cost savings surrounding spend around firm compensation/benefits, insurance, taxes, & practice/client development
- Championed a financial analysis of firm’s timekeepers on a cost per hour basis based on data reconciliation from ELITE billing systems enabling the CFO to make decisions conducive to helping the firm more efficiently manage its costs per matter
- Assisted with month end close process by preparing and processing month-end journal entries and general ledger work
Confidential, Washington, D.C
Financial Analyst
Responsibilities:
- Provided robust MS Excel financial analysis presentation to Brussels team providing them a multifaceted blueprint allowing them to structure their business policies for competitive pricing in their geographic market
- Chaperoned the utilization of competitor rate database, Valeo Attorney Rates (VAR), to supplement the attorney fee setting process resulting in effectively pricing our firm’s services amongst the Am Law 100
Confidential, Washington, D.C
Financial Analyst
Responsibilities:
- Spearheaded trend analysis of individual lawyer profitability, profitability results analysis between practice groups, and lawyer time usage efficiency resulting in reduced firm expenses and better allocation of human capital
- Assisted with month-end close process by generating accurate reports
Confidential, Berlin, CT
Competitive Strategy Intern
Responsibilities:
- Utilized financial modeling and trend analysis to propose recommendations for problematic geographic areas within company footprint to reduce and reverse forecasted $788,000 net revenue deficit
Confidential, Westwood, MA
Pricing Analyst
Responsibilities:
- Challenged to deliver Hyperion Essbase generated quantitative data to the Pricing Manager for use in pricing bank’s s of Deposit, Money Market Accounts, and Saving Accounts; solo financial analyst that supported a team of four other managers responsible for accurate and timely execution of ad-hoc financial reporting requests.