Description
10+ years of professional experience in various sectors like Asset management Private Equity Banking Retail and Logistics. Have 5+ years of client site experience in Edinburgh UK for Standard life Investments and Ameriprise Auto and Home USA. * Extensive experience in developing and implementing projects using Microsoft Business intelligence 2005/2008/2012 (Microsoft SQL Server Integration Services (SSIS) SQL server Analysis Services (SSAS) SQL Server Reporting Services (SSRS) Power view power pivot Power BI Desktop Power pivot Power Query Power Map and Performance point dashboard (PPS) designer 2008/2012). * Have 2 + years of experience on creating Power BI dashboards using Power BI Desktop and Power Query. * Hands of experience on creating both multidimensional and tabular model analysis services cubes with complex DAX and MDX queries. * Individual contribution on delivering around 25 E2E short term MS-BI stack projects (less than 6 months) .And also worked as a lead developer and onsite co-ordinator with a team of 10 people in offshore for around 4 E2E long term BI stack projects (greater than 1 year). * Hands of experience on deploying and scheduling reports in SharePoint 2013 and access management. * Helped and trained business users to explore analysis services cube data using self servicing BI tools like power view power pivot Power BI and excel. Had great experience on working on Agile and water fall methodology. Involved in requirements gathering analysis design development testing implementation and maintenance of projects created by using SQL Server Business Intelligence tools 2005/2008/2012 BO Crystal Report XI Jasper i reports ASP.NET Silver light and C#.Net. * Very good T-SQL programming skills and experience in writing complex stored procedures triggers views cursors stored procedures functions CTE and User Defined Functions (UDF's). * Have strong experience in other BI tool Power BI Desktop Crystal reports 8/9/10/XI Business Objects Enterprise XI info view/CMC management Jasper I Reports MS-Access Reports and Cognos 7.4 Impromptu Reporting Tool. * Hands of experience on creating complex ETL logic using SSIS Data modelling and design OLAP cubes using SSAS (Multidimensional Tabular and power pivot) and created complex dashboards reports using SSRS for private equity finance derivative control sales and risk teams. Extensive business knowledge on third-party investment applications like CRM Apex Equitrak OTC Tools and Charles River IMS v8 and v9. * Hands of experience on migrating reports from BO Crystal and SAS to SSRS reports. * Created and supported Invoice reports for finance using Jasper I Reports and integrated in Revport. PROJECT SUMMARY
Accomplishments
Highlights:
Keywords
