About Me

Let me first thank you for visiting my blog, even if you have stumbled upon it by mistake.

My name is Sathya Prakash, and I have more than 15 years of experience in the IT industry. I started my career as a developer in 2004, programming in Delphi, Dotnet and SQL server. I am now a Solutions Architect in Retail domain. Apart from my initial four years of my career in Petroleum domain, my entire experience revolves around Retail Domain, to be specific in retail planning.

I have experience in working and integrating both COTS (Commercial Off the Shelf System) and bespoke systems. 
My key focus and Key competencies are:
  • Solutions design and Architecture
  • Functional and Systems analysis
  • Data migration, implementation and rollout management
 Please visit my LinkedIn page for more information about my professional life

Comments

Post a Comment

Popular posts from this blog

Displaying alert message from server side(ASP.NET1.1)

Public Sub ShowMessage(ByVal MessageText As String) MessageText = Replace(MessageText, """", "") Dim strScript As String = " " If (Not Page.IsStartupScriptRegistered("clientScript")) Then Page.RegisterStartupScript("clientScript", strScript) End If End Sub Technorati Tags: ASP.NET , ASP.NET1.1 , asp.net serverside message box
Read more

Implementing a tactical system

Anyone who worked in large scale implementation would have come across the issue of implementing a tactical system, which is either hard or never replaced. Below are my views of the potential reason. Most of the below points are apparent but often overlooked. What is a tactical system? A solution to temporarily bridge a significant technical or a business gap. Characteristics of a tactical system. 1. Cheaper to implement. 2. Easy to train. 3. Quicker to roll out. 4. The life span of a tactical system is not higher than six months. 5. Has less business benefit compared to an end state system. When a tactical system becomes an end-state system? 1. When it delivers beyond MVP.  2. When it is more flexible compared to a strategic system. 3. When its life span is more than a year. 4. When its user base is high. 5. When there is no road map and a secured business case and funding for a strategic system. 6. When deeply embedded within the business process
Read more

Row_Number()

  Yesterday I when I was looking into the enhancements in SQL server 2005 I discovered the below cool features and thought of sharing with your all. This new features will reduce the amount of coding and drastically improve the performance of complex SQL queries.  Conventionally we generate sequence numbers using complex logic or by using temp tables or table variable with identity columns, but with this new feature “ROW_NUMBER()” will allow developers to generate sequence numbers in a single line of code. Below I have attached an example. ROW_NUMBER()returns the sequence number of a row within a partition of a result set, starting at 1 for the first row in each partition. Syntax: ROW_NUMBER ( ) OVER ( [ <partition_by_clause> ] <order_by_clause> ) Example usage: CREATE TABLE RowNumTest (Name VARCHAR(50), DOB DATETIME, Age AS (DATEDIFF(YEAR,DOB,GETDATE()))) INSERT INTO RowNumTest (Name, DOB) VALUES('Sathya', '1983-11-02') INSERT INTO RowNumTes
Read more