Hello Sir,
We do it all.
I'm Vinay Pugalia, Head BI & Data Analysis at Inkey having an overall 16 yrs. of exp. in the IT industry.
· SQL
I've been working with SQL for the last 16 yrs. now and have completed numerous projects for SQL involving DB Designing, Performance Optimization, DB Restructuring, and TSQL creation/optimization.
· SSRS
And coming on to SSRS reports, I have designed reports ranging from the simplest to the most complex report and I am well aware of every aspect of SSRS report designing. To name a few – Using Tablix, Matrix, Row/Column groupings, Drill Down or Drill through reports, use of sub-reports, Dynamic sorting or grouping of data, Lists, or Rectangles, Pagination, expressions, report parameters, and many more things.
. SSIS/ADF
I have a very strong experience in SSIS and have been developing SSIS packages for our clients for 13+years now. There are various packages and types of work I've been doing to date.
For the last 3yrs, I have also started orchestrating ADF Pipelines for ETL/ELT purposes performing almost all the operations done in SSIS using the different Activities.
· Power BI
I have been working with Power BI since Nov'2015 and have advanced knowledge of working with M, DAX, Power Query, Power BI Rest API, and Power BI Embedded and in-depth experience of working with live connection, direct connection using various databases like SSAS Tabular and Cube, Azure Platform.
Thanks & Regards,
Vinay Pugalia