Investment Portfolio Specialist Ii
CurrentInvestment Portfolio Specialist II>Provide back office support for $13 billion mortgage back and municipal bond portfolio.>Manage collateral for $600 million sweep repo balances.>Develop VBA code to automate system reconciliations, user input and reporting.Risk Control Officer>Created VBA code object/framework to accelerate coding projects. A project that would take 6 hours now takes 8 minutes.>Developed automated self-serve stress test model for Credit relationship managers to calculate line of credit exposure.>Supported/Developed group’s Microsoft SQL Server Integration Services (SSIS packages) ETL tool.RPS Operations Specialist II>Received Ops &Tech award for automating audit document generation, gathering and packaging for 456 institutional retirement plans.>Received 2nd Ops &Tech award for automating end of year name and address verification processes.>Developed automation for the fee disclosure process saving the company 240 to 320 man-hours a year.>Designed and executed automated regression and load performance tests that prevented shoddy vendor software being accepted.>TSQL, SQL, Visual Basic For Applications (VBA), Sungard, OmniScript, Performance Testing, Quality Assurance, QA, Application Support, Testing, Test Plan, Javascript