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

All authors

All authors

Blogs

Using Prompt AI for a Travel Data Analysis

By

I was looking back at my year and decided to see if SQL Prompt...

FinOps for Kubernetes: Leveraging OpenCost, KubeGreen, and Kubecost for Cost Efficiency

By

In the era of cloud-native applications, Kubernetes has become the default standard platform for...

2025 Wrapped for Steve

By

I’ve often done some analysis of my year in different ways. Last year I...

Read the latest Blogs

Forums

The North Star for the Year

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The North Star for the...

Multiple Escape Characters

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Escape Characters

reaching ftp thru winscp but erroring in ssis ftp task connection

By stan

Hi, below i show various results trying to reach our ftp site (a globalscape...

Visit the forum

Question of the Day

Multiple Escape Characters

In SQL Server 2025, I run this code (in a database with the appropriate collation): 

SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned?

See possible answers