Sr. Programmer Analyst
Center for Research in Security Prices, Booth School of Business, U. of Chicago
Lead a team supporting a full custom client deployed at customer sites.
Design and maintain data architecture on several projects dealing with ingestion and warehousing of data, and producing financial data products for clients.
Financial instruments covered included stocks, treasury securities, mutual funds, stock and treasury indexes, as well as economic indicators.
Data architecture: PowerDesigner 16.5, ERWin (7 & 9.5)
DBMS: MS SQL Server (embedded, local, and in Azure), Ingres
Languages & Packages: T-SQL, SSIS, SSRS, SAS, C#, C, PowerShell
Collaboration: Visual Studio Team Services, JIRA, Confluence, OpenText DM, HipChat
Deployment: InstallShield, MSBuild