►Project: Data warehouse Workflow Automation
Period: August 2015 - January 2016
Description:
▪️ Automated start of the day financial data loading into the data warehouse which is then used to calculate their holdings and generate reports on top of the data.
▪️ Developed Ad-hoc requests that required a minor change in calculation step. Debugging the issue when the application was unable to get security prices from Bloomberg.
Role: Offshore Developer
Responsibilities: Managing and improving an existing application implemented.
► Project: Polaris Data warehouse & Reporting Application, Risk Service
Period: January 2016 - February 2017
Description:
▪️ Polaris is an IVP product which generates reports and automates the loading of Start of Day and End of Day financial data into in-house data warehouse.
▪️ The application also allows an analyst to run a compliance check on the data received from Fund Admin (IFS, State Street), the result helps the analyst to generate insights and trade accordingly.
Role: Offshore Developer
Responsibilities:
▪️ Data analysis, development of ad-hoc requests, Report logic creation.
▪️ Development and testing of the end-to-end process.
⇨ Tech Stack: ASP .NET, SQL Server, SSRS, Java, Tomcat Apache, .NET 4.0
⇨ Database: SQL Server 2008 R2, MongoDB