Experience

• 

  Wells Fargo

  • Columbia, MD

  • Securities Analyst IV

    • Dec 2013 - Present
    • Columbia, MD

    • Developed software that parses large data files and automates routine processes for analysts resulting in at least fifty hours of workload reduction per month• Created and maintained data dictionaries and an index of databases used for efficiently locating the correct database to query• Built queries to assist analysts in quickly locating relevant information for various requests• Reconciled collateral data provided by servicers to Wells Fargo calculated remittance totals

• 

  Johns Hopkins School of Medicine

  • Baltimore, Maryland Area

  • Budget Analyst

    • Aug 2012 - Dec 2013
    • Baltimore, Maryland Area

    • Developed and maintained a $1.7 billion annual budget and projections for 35 departments• Created a MS SharePoint website to improve communications throughout the School of Medicine• Prepared and consolidated financial statements and reports using SAP and Business Warehouse• Provided ad hoc presentations and analysis to Executive team, Directors of Finance and Department Administrators• Revised budget models and financial reports prepared in MS Excel to be cleaner and more efficient

• 

  Snyder Kearney LLC

  • Columbia, Maryland

  • Financial Analyst

    • Aug 2010 - Jul 2012
    • Columbia, Maryland

    • Built and analyzed financial models and reported on assumptions and feasibility• Prepared due diligence reports for 40+ public REITS, BDCs, and DSTs• Prepared daily newsletter summarizing industry news and SEC filings of clients’ investment products• Built MS Excel templates to improve report quality and formatting efficiency• Designed and implemented an RSS feed and Google alert email distribution system• Integrated SNL Financial software into company’s MS Excel templates

• 

  ACS Healthcare Provider Solutions

  • Germantown, MD

  • Accountant (Temporary)

    • Dec 2009 - Feb 2010
    • Germantown, MD

    • Coded macros and vlookup templates in MS Excel to improve efficiency• Maintained fixed assets in Deltek Costpoint• Reconciled asset, revenue, and expense accounts• Posted recurring, adjusting, and reversing journal entries