I am an expert in Microsoft BI suite,PowerBI and Qlik along with it's components in SQL Server Integration Services, SQl Server Analytic Services,SQL server reporting server and Business Intelligence Data tools. My experience includes:
- Expert in data extraction,migration, transformations and loading (ETL) between complex system using SSIS.
- Extensively used data flow, aggregation, data merging, multicasting, conditional split, lookup and sorting.
- Developed and extended the data into cubes, dimensions, measures, processed and deployed using SSAS.
- Involved snow flake, star schema, regular/reference/many-to-many relationships, calculations on data.
- Strong experience in creating drill down, dashboard, matrix , tablix , sub, tabular reports using SSRS.
- Associated the data on more visulaisation tools using PowerBI, Tableau and Qlikview.
- Worked on creating sub reports, dynamic sorting, defining data source, and subtotals for the report.
Area of Expertise :
1) Solid experience in Marketing ,Telecommunication and Healthcare industry.
2) Designing and deploying ETL/ELT Datawarehouse tools.
3) Data analysis: data mining , machine learning.
4) Business Process: Workflow/BPM and BAM.
5) PowerBi-Report visualisation with dimensions.
6) Qlik view to associate the data and concatenate tables.
Data Integration: Sql server data tools(SSDT),Business Intelligence Development Studio(BIDS),Packages.
Data Analysis: SQL Tabular Tools, Multidimensional tools, DAX, MDX, VBA and Powerpivot Macros.
Data Reporting: Microsoft PowerBI, Tableau,Power view,Report designer Report builder, Charts, graphs, Qlikview and Qliksense.
Databases: Data warehouse, SQL, Oracle 11g, Mysql, Nosql.
Methodologies: Scrum, Agile.
I am also highly integrated with danish society and I learn danish each day. More information is in www.sambidata.com as well.