Tejas Shah

Management Proficiencies:
~ A determined & passionate Tech Lead having hands-on experience to drive the development of data-driven services while utilizing best practices in software development and reporting services.
~ Leading teams to success in the creation, testing, and deployment of cutting-edge enterprise level applications, distributed systems, middleware, databases, and APIs.
~ Utilize a thorough grasp of the demands of the business to develop solutions that are well regarded by the clientele.
~ Helping enterprises achieve success via technical proficiency, leading by example, and collaboration amongst varied teams.

Technical Proficiencies:
Microsoft Certified Professional in Microsoft SQL Server.
I have 18+ years of hands-on experience in working with multiple enterprises, where my role was:
1. Design and develop Data Warehouse to support aggregate data from various data sources.
2. Data modeling for the Health Care Portal. Also, worked on Reporting for the same.
3. Develop Performance improvement with the de-normalizing tables.
4. Develop Data Warehouse in SSIS.
5. Develop Reports in SSRS.
6. Maintained all the codes in Version control.

Also, having good experience in Query Optimization, Performance Tuning, T-SQL, Cloud (Microsoft Azure, AWS, GCP), creating & optimizing SQL queries and stored procedures.
  • Interests: SSIS | SSRS | Power BI | Power Apps | .Net Core | C# | MVC | Angular
  • Skills: SSIS | SSRS | Power BI | Power Apps | .Net Core | C# | MVC | Angular

Blogs

T-SQL Tuesday #180: Good enough is perfect Roundup

By

This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...

Using SQL Compare with Read-only Access

By

Recently a customer asked if SQL Compare and SQL Data Compare can be used...

Off to Live 360

By

I am off to Live 360 today, on my last trip of the year....

Read the latest Blogs

Forums

how can i tell if our db2 driver is ms or ibm or other?

By stan

i see this in the definition of a linked server on our wh sql...

normal role member to be able to view list of other role members in his DB

By Senad

Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...

Stairway to Snowflake Level 5 - Using Snowflake with SnowSQL and Visual Studio Code

By Mike McQuillan

Comments posted to this topic are about the item Stairway to Snowflake Level 5...

Visit the forum

Question of the Day

A Strange Result

What does this code return in SSMS 20 from SQL Server 2019?

select '|' + CHAR(0)+'abc' + '|';

See possible answers