Associate Director, Front Office Development
Current• Responsible for the Restricted Issuer application, a web application used to match Bloomberg issuers and upload them to the compliance restricted trading issuer list. Developed stored procedures to load No-SQL data (CSV, JSON, XML) files into Microsoft SQL Server.• Created nightly ETL jobs to load our Trade Order Management system, S&P thinkFolio. • Created a new SQL reporting database used to simplify queries and improve data accuracy. A data load process was created to run rule-based queries and notify business teams of data exceptions.• Developed an Excel Addin in VBA to call ASP.NET C# RESTful web services using JSON for the Credit desk. • Implemented BlackRock Aladdin Explore project by creating 36 nightly and monthly Tidal jobs to extract our security, trade, position, and account data and SFTP to BlackRock.• Collaborated with the Project Management Office and Data Office teams to provide an on-schedule delivery of BlackRock Aladdin Explorer project.• Built a new data model for our Power BI platform and improved loading performance by implementing SDLC pipeline and automate Gateway data refresh.