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

One of the all time technology world buzz word - "Lean"

I decided to find it little more about it. A new term has been coined, Lean software development. Well the work and definition below is from various sites and sources on internet. I would like to thank them and not claim this is my work. This is to insitgate discussion and blog the very purpose of having this site.


Lot of you may know about Sixsigma, this is kind of an extension, here is what I found. Looking forward to get some feedback.


Lean software development is a translation of lean manufacturing principles and practices to the software development domain. Adapted from the Toyota Production System, a pro-lean subculture is emerging from within the agile community.


Eliminate waste

  • unnecessary code and functionality

  • delay in the software development process

  • unclear requirements

  • bureaucracy

  • slow internal communication

Amplify learning

Software development is a continuous learning process with the additional challenge of development teams and end product sizes. The best approach for improving a software development environment is to amplify learning. The accumulation of defects should be prevented by running tests as soon as the code is written. Instead of adding more documentation or detailed planning, different ideas could be tried by writing code and building. The process of user requirements gathering could be simplified by presenting screens to the end-users and getting their input.

The learning process is sped up by usage of short iteration cycles – each one coupled with refactoring and integration testing. Increasing feedback via short feedback sessions with Customers helps when determining the current phase of development and adjusting efforts for future improvements. During those short sessions both Customer representatives and the development team learn more about the domain problem and figure out possible solutions for further development


Decide as late as possible

As software development is always associated with some uncertainty, better results should be achieved with an options-based approach, delaying decisions as much as possible until they can be made based on facts and not on uncertain assumptions and predictions. The more complex a system is, the more capacity for change should be built into it, thus enabling the delay of important and crucial commitments.

An agile software development approach can move the building of options earlier for customers, thus delaying certain crucial decisions until Customers have realized their needs better. This also allows later adaptation to changes and the prevention of costly earlier technology-bounded decisions. This does not mean that no planning should be involved – on the contrary, planning activities should be concentrated on the different options and adapting to the current situation, as well as clarifying confusing situations by establishing patterns for rapid action.


Deliver as fast as possible

In the era of rapid technology evolution, it is not the biggest that survives, but the fastest. The sooner the end product is delivered without considerable defect, the sooner feedback can be received, and incorporated into the next iteration. The shorter the iterations, the better the learning and communication within the team. Without speed, decisions cannot be delayed. Speed assures the fulfilling of the Customer’s present needs and not what they required yesterday. This gives them the opportunity to delay making up their minds about what they really require until they gain better knowledge. Customers value rapid delivery of a quality product.

The Just-in-Time production ideology could be applied to software development, recognizing its specific requirements and environment. This is achieved by presenting the needed result and letting the team organize itself and divide the tasks for accomplishing the needed result for a specific iteration. At the beginning, the Customer provides the needed input. This could be simply presented in small cards or stories – the developers estimate the time needed for the implementation of each card.


Empower the team

There has been a traditional belief in most businesses about the decision-making in the organization – the managers tell the workers how to do their own job. In a Work-Out technique, the roles are turned – the managers are taught how to listen to the developers, so they can explain better what actions might be taken, as well as provide suggestions for improvements. Most experienced project managershave simply stated the key for a successful project – “Find good people and let them do their own job.”

Another mistaken belief has been the consideration of people as resources. People might be resources from the point of view of a statistical data sheet, but in software development, as well as any organizational business, people do need something more than just the list of tasks and the assurance that they will not be disturbed during the completion of the tasks. People need motivation and a higher purpose to work for – purpose within the reachable reality, with the assurance that the team might choose its own commitments. The developers should be given access to Customer; the team leader should provide support and help in difficult situations, as well as make sure that skepticism does not ruin the team’s spirit.


Build integrity in

The Customer needs to have an overall experience of the System – this is the so called perceived integrity: how it is being advertised, delivered, deployed, accessed, how intuitive its use is, price and how well it solves problems.

Conceptual integrity means that the system’s separate components work well together as a whole with balance between flexibility, maintainability, efficiency, and responsiveness. This could be achieved by understanding the problem domain and solving it at the same time, not sequentially. The needed information is received in small batch pieces – not in one vast chunk with preferable face-to-face communication and not any written documentation. The information flow should be constant in both directions – from Customer to developers and back, thus avoiding the large stressful amount of information after long development in isolation.

Automated tests are also considered part of the production process, and therefore if they do not add value they should be considered waste. Automated testing should not be a goal, but rather a means to an end, specifically the reduction of defects.


See the whole

Software systems nowadays are not simply the sum of their parts, but also the product of their interactions. Defects in software tend to accumulate during the development process – by decomposing the big tasks into smaller tasks, and by standardizing different stages of development, the root causes of defects should be found and eliminated. The larger the system, the more organizations that are involved in its development and the more parts are developed by different teams, the greater the importance of having well defined relationships between different vendors, in order to produce a system with smoothly interacting components. During a longer period of development, a stronger sub- contractor network is far more beneficial than short-term profit optimizing, which does not enable win-win relationships.

Lean thinking has to be understood well by all members of a project, before implementing in a concrete, real-life situation. “Think big, act small, fail fast; learn rapidly” – these slogans summarize the importance of understanding the field and the suitability of implementing lean principles along the whole software development process.


One of the all time technology world buzz word - "Lean"

Thursday, September 5, 2013

Another Brain Teaser - Coins puzzle - probability

Flip the coin…

I always loved those coin tricks and wondered how it happened. While making the coin magically disappear is definitely a mind trick (will talk about that too) but the coin flipping is mathematical. Here is an easy one, I flipped two quarter-coins and immediately announced that one came out as head. What is the chance that the second coin will also be a head?

If you were in Las Vegas would you bet on head or tail for the second coin? Have fun :)



Another Brain Teaser - Coins puzzle - probability

Monday, September 2, 2013

Jargons used at work place that need to go away.....what do you think

Jargons commonly used at workplace that seem to provide no value and may be repetitive and frustrating for others….


What do you think?


  1. Low hanging fruit

  2. Touch base

  3. No Brainer

  4. Think outside the box

  5. End of day or close of business

  6. When rubber hits the road

  7. Win-win

  8. Touch points

  9. Below the radar

  10. Drill down


Jargons used at work place that need to go away.....what do you think

Sunday, September 1, 2013

Puzzle: Run for your life...

Mr. Joy enjoys some risk and likes to explore the nearby area. In the beautiful surrounding there is a train track that goes through a mysterious tunnel. One fine morning Mr. Joy decided to take a walk through the tunnel. While Mr. Joy was 1/4 way on the tunnel, he hears the train whistle. A quick thinker Mr. Joy calculates that if he runs back he would just make it out of the tunnel before train gets in the tunnel and if he runs forward he will just make it out of the tunnel before train hits him. While Mr. Joy saved his life, he left you with a problem, how fast was this train travelling compare to Mr. Joy?


This is old school physics problem with all basic assumptions for this kind of puzzle. Assume Mr. Joy can run with same speed in both direction. He can accelerate to his top speed right away. Train barely misses him if he would run in either direction


Looking forward to see some solution(s)



Puzzle: Run for your life...