Search This Blog

Monday, September 30, 2013

My PMI 2013 conference experience – Healthcare in India

I recently attended the PMI 2013 National Conference hosted at “The Leela” Gurgaon. It was indeed a grand event that I enjoyed thoroughly. I was particularly intrigued by the presentation in the field of Healthcare in India from the Fortis group CEO Vishal Bali. Having the background in the field and experienced in the international market at the USA, I am really excited about the opportunities in this Sector in India.


Healthcare is directly or indirectly linked with the economic growth of the country, while it directly produces opportunity for healthcare professionals, it indirectly creates lot of opportunity in other fields like management, IT etc. Not only that, it helps in increasing the life expectancy thereby the overall working task force in the economy. While that is for the global vision, I am concerned about specifics in the healthcare industry in India. There is a lot to be done and opportunity to learn from the systems in other countries – what was done right and what can be done better.


I am particularly interested in hearing from the industry experts about topics like – Preventive care, Diagnosis standardization, Patient centric approach with information sharing and the most talked about topic for all insurance companies – fraud prevention.


These are some of the burning topics especially in healthcare in India.  I have had some experience of working in these areas and seen both the good and the bad of systems.


Looking forward to hear from some of the experts….



My PMI 2013 conference experience – Healthcare in India

Wednesday, September 25, 2013

Brain teaser series....Candy Jar

Find the right candy jar…


Who does not love candy? I always loved those colorful candies but I liked that one colored candy. Now I got red candy and blue candy but I like to get the red one, here is my trouble. There are 3 jars (not transparent) that are mislabeled, one jar has red candy, one has blue candy and one has a mix. Now the mix is not necessarily 50-50, it could be any ratio. I have to blindly pick candy from the jars and find out which jar has which type of candy in the minimal possible turns. How many turns are needed to find out which Jar has what candy?


Did you know that red jelly beans are kid’s favorite. Have fun :)


Brain teaser series....Candy Jar

Tuesday, September 24, 2013

Saloon... Not to Visit!!!!

We had a wedding in the family and had to visit the saloon for touch up’s! :) My regular saloon was closed that day so I ended up going to another one nearby! And I should mention that I went along with my MIL(mother-in-Law),  who is pretty easy going lady I must say!


Anyways, so we went to this saloon and here are the reasons I wouldn’t recommend ANYONE going there


- Hygiene Levels are POOR and


- Value for Money is ZERO!!


The saloon is narrow vertical shape and space is to cramped that it will be difficult not to rub yourself against the other person while moving from the entrance to the chair where I had to sit down for the services! I had to get myself arm waxing and pedicure to get some relief to my usual aching swollen feet due to pregnancy! The saloon ladies were trying to upsell all their services by suggesting better quality products, which I would say is a part of their job so I really don’t mind that. However, the point from where the bad experience started was the hygiene levels were pretty bad. Instead of using a warm wet towel to clean the arms after waxing they used a cloth and it seemed that that cloth was already used on someone!! Eww!!! Further,  I had asked them to apply astringent on my arms after waxing to close the open pores and they had never heard of this concept!! Not sure which place they were trained from!


Now let us come to value for Money! My MIL was getting a facial and pedicure done and as expected they were successful in upselling the facial with some add on’s for better results. The Add on’s  as they suggested did not really make much of the difference in the results as they had said, moreover the standards to do the pedicure for me and my MIL(we opted for same pedicure) were totally different in terms of the products they used! They also claimed that the pedicure we opted included message for 40 mins. Mine was done in 40 mins however; my MIL’s was completed in 15 mins flat! Not worth the value of ur money and time!


 


The saloon is based in Dwarka Sector -11 and goes by the name of “Elegant Looks Ladies Beauty Parlor”!


 


Share your views if anyone else had similar experience!!


 


 



Saloon... Not to Visit!!!!

Business Intelligence (BI)

What is business Intelligence

I am sure a lot of people can define business intelligence but what we need to know is how it applies to us our business, our life and things we do. Over the last few decades, we have collected data and we probably have overwhelming data about a person, from financial records to personal email, phone records etc. While this information is useful for your own records it provides a vast scope for someone in the field of offering services or goods a great opportunity to find out what they can launch or produce.


While this is a short example and a survey could do that but have you ever thought of magic. While magical tricks (are tricks) and some are really sophisticated, business intelligence is the magic for this data. Data is any piece entered into a system but when we interpret it, it becomes information. When this goes beyond a regular interpretation, business intelligence comes into play.


Have you ever thought about this if the person entering next in the car dealership will buy the car or not? Well, if you are into sales there, you know the other brain tricks (that I will talk about in another topic) but you wish you knew so you could spend your time appropriately. Well based on the vast data that we have, a simple survey may be a tool that could give you the answer with pretty high confidence. For example, how many car this person already own, is he / she a house owner? how many children? etc.


Business intelligence is not about what we can see but what we cannot see. With that said, here is my introduction to BI.


Would love to get some feedback and comments…


Business Intelligence (BI)

Saturday, September 21, 2013

How to get Windows Folder sizes recursively

Ever need to know the folder sizes that has several sub-folders, windows explorer takes really long time and requires checking properties of each folder.


This script will do the job just need excel installed on your machine


Creates a clean excel sheet



‘ PLEASE NOTE THAT YOU WOULD NEED EXCEL INSTALLED ON YOUR MACHINE


Dim oFS, oFolder

Dim objexcel, r, lnameArray, lname, nameLength

set oFS = WScript.CreateObject(“Scripting.FileSystemObject”)

set oFolder = oFS.GetFolder(“D:\GE”)

Set objExcel = createobject(“Excel.application”)

objexcel.Workbooks.add

objexcel.Cells(1, 1).Value = “Folder Path”

objexcel.Cells(1, 2).Value = “Folder Name”

objexcel.Cells(1, 3).Value = “Size (MB)”

objexcel.Cells(1, 4).Value = “# Files”

objexcel.Cells(1, 5).Value = “# Sub Folders”

objexcel.Visible = True

Wscript.Sleep 300

r=2


ShowFolderDetails oFolder, r


‘    objexcel.ActiveWorkbook.SaveAs(“LogonReport.xls”)

‘    objexcel.Quit

MsgBox “Done”


Function ShowFolderDetails(oF,r)

Dim F

objexcel.Cells(r, 1).Value = oF.Path

objexcel.Cells(r, 2).Value = oF.Name

objexcel.Cells(r, 3).Value = oF.Size /1024\1024

objexcel.Cells(r, 4).Value =  oF.Files.Count

objexcel.Cells(r, 5).Value =  oF.Subfolders.count

r = r+1

for each F in oF.subfolders

ShowFolderDetails F, r

next

End Function




How to get Windows Folder sizes recursively

SQL Server FUN - Split received string using XML


Several time, we have a need to split the string based on a delimiter, for instance to handle multiple input filter parameters etc.


Most of the time we end up using a user defined function that accepts a string and a delimiter and returns a table of split values. Function may be in-efficient at times.


Here is an XML way to split the input string and get a result within a table



declare @xml as xml


,@str as varchar(100)


,@delimiter as varchar(10)


set @str=’A,B,C,D,E’


set @delimiter =’,’


set @xml = cast((‘<X>’ + replace(@str, @delimiter, ‘</X><X>’) + ‘</X>’) as xml)


select N.value(‘.’, ‘varchar(10)’) as value from @xml.nodes(‘X’) as T(N)





SQL Server FUN - Split received string using XML

SQL Server FUN - Identity insert

Insert in identity column for a table


Sometimes there is a need to insert data into a table that has identity column. Example when you would like to restore a table from a backup including the same IDs so integrity is maintained. Here is simple script

–set identity insert on

set identity_insert <table_name> on


–set identity insert off

set identity_insert <table_name> off

 



SQL Server FUN - Identity insert