My Experience in SSIS, SSRS, SSAS and SQL
1. I have designed and implemented SSAS Cubes - Dimension modelling, Calculated metrics, merging two cubes, partitions etc.
2. Also implemented SSIS packages to ETL data from various types of sources (flat files, Excel, MySQL, PostgreSQL into MS-SQL). Have written custom C# programs within an SSIS package to automate the ETL flow.
3. Experienced in developing complex SQL queries and optimisation using efficient joins, indexing, partitioning etc.
4. Develop SSIS packages to ETL the data from live sources. Here we will be using Custom C# Scripting, variables, Email alerts (for reporting success/failure), staging tables etc. Publish the SSIS packages to the SSIS Catalog Manager and schedule them using SQL Server Agent
5. Design and implement the OLAP cube(s). Use partitioning if the data is huge
6. Develop SSRS report that connect to the Cubes using MDX queries that run inside a Stored Procedure and generate the required data set for the reports
7. Schedule the periodical processing of SSAS Cubes (Dims and Facts) using SSIS packages
I have over 5 years experience in BI and data visualisation. I understand the intricacies of implementing full-stack BI solutions with the underlying ETL, OLAP, data warehousing, and visualisations layers.
I have worked with the following types of data:
1. Clickstream and web log data
2. Financial stock market data
3. Telecom data: CRM, Billing, Marketing, VAS etc.
4. B2B Leads data
5. Sales operation