MSeptembre 2014 - January 2015 |
Role: Database & BI Developer and architect (SSIS, SSAS, SSAS)
Company: PSP Invest
PSP Investments is one of Canada’s largest pension investment managers, with $93.7 billion of assets under management as at March 31, 2014. We invest funds for the pension plans of the Public Service, the Canadian Forces, the Royal Canadian Mounted Police and the Reserve Force.
PSP hired me to help them during the conversion from their old system to new system.
So I have participated to help to balance the data, by working on the raison of the difference.
I have created reports like:
Backed transaction Report
Portfolio Report and others
Beside that I :
• Created and updated the cubes about the portfolio of the company.
• Create new reports like the trial balance, Posting and transaction reports;
• Helped to find the problem with non-balance accounts.
• Monitoring the database to improve the performance;
• Created packages.
SQL 2012, SQL 2008, SSIS, SSRS, SSAS, OLAP, ROLAP, MOLAP, Transact/SQL, MDX, DAX, TSF, XML, TSQL, ETL, Stored Procedures, Microsoft Access, Power-Pivot, Pivot table,