SSISPower BI Hadoop EcosystemMS-SQLSSRSBar Charts Donut Charts Waterfall Charts Tree Maps Stacked Bars
Having over 3 years of professional experience in IT industry, involved in MSBI projects with extensive usage of ETL & Reporting tools SQL Server Integration Services (SSIS), Talend , SQL Server Reporting Service (SSRS), Power BI Reports , Java and Hadoop Ecosystem Experience in development of Reports and Dashboards in Power BI and SSRS.
Experience on developing the Star and Snowflake Schema (Data Integrity, Granularity, SCD type 1 and Type 2, Normalization, Denormalizations, Staging Area, Source Layer, Extraction Layer).
Having work experience on Publishing and Providing the Role Base Security.
Experience in creating aggregates, hierarchies, charts, filters,trendlines, calculated measures in SSRS, SSAS and Power BI.
Experience with Bar Charts, Donut Charts, Waterfall Charts, Tree Maps, Stacked Bars, Filled Maps, Highlight Tables, Heat Maps, Cross tab, Scatter Plots, Geographic Map, Pie Charts, and several custom conditional formatting reports in Power BI.
Developed What-If analysis reports for business requirements in Power BI.
Created Customized and interactive dashboards using multiple data sources.
Experience in developing the Dashboards with Drill down, Interactive filters, Report filters in Power BI.
Experience with Bar Charts, Donut Charts, Waterfall Charts, Tree Maps, Stacked Bars, Filled Maps, Geographic symbol Maps, Tables, Cross tab, Scatter Plots, Pie Charts, Cards, KPI’s in Power BI.
Experience in report writing using SQL, Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, and Chart Report, Web Reporting by customizing URL Access.
Developed Drill Down, Drill Through, Parameterized, Cascaded and Sub- Reports using SSRS.
Good experience in Tuning SQL queries.
Experience in design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
Scheduling the Reports Weekly and Monthly basis as per the Client Requirements and providing security for reports.
Proven proficiency at Data Transformations like Lookup, Derived Column, Conditional Split, and sort, Data Conversion, Union All, Merge Join, SCD and OLEDB command to load data into SQL Server destination.
Used Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, Send mail Task ,File System Task , FTP Task and Data Flow Task in Designing packages.
Used Checkpoints in packages to enable the package to run from the point of Failure.