SQL server query expert

Looking for someone with extensive experience in SQL server querying. Experience in creating SQL calculations and persistent table using the WITH clause and on the fly calculations and pivots in SQL. Experience in optimizing query performance. Extensive experience with MS Visual Studio, MS Server Management Studio and MS Power BI.