❖ Total 3 years and 10 months of experience in MSBI/SQL Developer analysing data, developing SQL Queries, Stored Procedures using MS SQL Server 2008/2012/2016 using T-SQL.
❖ Experience in creation of Multidimensional Cubes, Dimensions, Data Source, Data Source views and Dimension usage using SSAS.
❖ Understanding of ETL and SSIS and creating packages using SSIS tool.
❖ Also having experience in creating MDX Scripts using SSAS.
❖ Good Analytical and Communication Skills and having ability to think outside the box.
❖ Expert in designing reports using Pyramid BI 2018 reporting tool (in house tool) and Power BI.
❖ Adapt in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports.
❖ Experience in all aspects of requirement gathering, development, deployment, maintenance and enhancements.
❖ Experienced client interactions at different levels for requirement gathering and resolving Adhoc Queries.
❖ Experience of owning a product completely for data warehousing