Sr. Capital Planning Analyst
CurrentAssist in the completion of capital stress testing, including accessing, retrieving, and uploading economic data from sources (Moody’s,the Federal Reserve)Preparation of analysis and forecasts utilizing BancWare and other analytic tools, and working with SMEs across various lines of business to review and challenge assumptions and resultsAssist with enhanced FTP and profitability reporting development, monthly runs, and documentation, as well as economic capital developmentGenerate and prepare reports for ALCO which include Treasury modeling results and other reports deemed necessary by management. Document and report all assumptions and create variance reports from expected resultsPrepare and review monthly consolidated and subsidiary Basel III capital calculations with managementCollect and maintain large data sets to use within modeling or other data mining initiatives. Create, recommend, and implement new data sources and efficiency improvements to existing data sources. Troubleshoot any data issues or transformation problems using SQL, Visual Basic, Visual Studio, etc.Provide reporting and analysis through SQL and other analytical data aggregation toolsAssist with long term projects from planning to implementation as requested. Perform special projects and other duties as assigned
