Wednesday, 28 September 2016

Why We need BPM tool, Can you describe any real world business process examples?

Here is the health Industry example, that will help you understand why we use BPM tools.

Business Problem
In an effort to provide health insurance coverage options across the country, a case management system was needed that could handle tasks including the intake, routing, review, and troubleshooting of applications submitted through the mail for enrollment.

Process players
Employees that determine eligibility of paper applications submitted

Process Steps
BPM allowed us to accept documents from an FTP folder and automatically create individual tasks from each document. Employees determining applicants’ eligibility then select the status of a new application which triggers the workflow – placing tasks into the appropriate user’s queue. When inconsistencies are detected in the data, employees are able to make ad hoc changes to the workflow based on their observations. Emails and paper documents are automatically created to notify applicants of additional clarifications required.

Process Benefits
By adopting BPM, we were able to create a case management solution that met all the requirements for managing up to 50,000 paper applications per day. Resolving inconsistencies found in individual applications has been completely automated. Built-in real-time analytics offers complete visibility into process performance, allowing for continuous optimization and improvement in cycle times.

Credit goes to : Appian

What are the advantages and disadvantages of using Pega?

Advantages of Pega:

Avoid  build the system from the scratch: Pega is a Business Process Management tool. The big advantage is we don't have to build the system from the scratch like any conventional programming. It is becoming popular because of that, though most conventional programmers would disagree.

Business friendly toolkit: Another advantage of Page is that it features a business friendly toolkit for defining applications. Unlike traditional BPM tools, there are much less complicated, technical syntax to handle in modeling processes and hardly any hard-coded programming.

Case Life cycle Management: The Pega's BPM suite here features what they call "Case Life cycle Management" - which allows any business user to capture and process the full scope of work in their operations, be it document handling, approvals, decision making, etc. These tasks can all be built into a process flow to automate as much as possible.

Design-once, deploy-anywhere: The other interesting thing about Pega's BPM solution is its design-once, deploy-anywhere user interface. You may not appreciate this until you realize how much effort it saves.

Very less Coding: We need to do very less coding, this is the big advantage of using Pega.


Disadvantages of Pega: 
Costly tool , small scale companies cannot go for Pega due to licence,development and maintenance cost

Sunday, 4 September 2016

How to split a comma-separated value to columns| SQL Server Interview Question

Q. How to split a comma-separated value to columns. Ex('First,Second,Third')
Output should be as below


Ans:
DECLARE @S NVARCHAR(100) = 'First,Second,Third'
SELECT SUBSTRING(@S,0,CHARINDEX(',',@S,0)) Column1,
SUBSTRING(@S,(CHARINDEX(',',@S,0))+1,(CHARINDEX(',',@S,(CHARINDEX(',',@S,0)+1)))-(CHARINDEX(',',@S,0))-1) Column2,

SUBSTRING(@S,(CHARINDEX(',',@S,(CHARINDEX(',',@S,0)+1)))+1,LEN(@S)) Column3