Monday, August 15, 2011

Advancing India

Well today is 15th August, Independence Day of India, so just thought of posting this note.

I’m around 36 years old & out of those, nearly 31 years I’ve stayed in India & I’ve closely watched & been involved in socio economic political religious technological etc. developments & changes happening in this country.

The beauty of this country is that it has delivered great thinkers in different domains whether it is spiritual, economic, social, businesses, technological or any other fronts. India has always been blessed with few good set of people in each sector who contributed a lot.

India is very vast & people are coming from so many different cultures & backgrounds that it is very difficult to understand the individual psychology & overall sociology. There are so many goodies each culture & tradition offers which can be adopted provided our eyes & minds are open to it.

So many great thinkers have written n no. of good books in past, present & in future also it will keep coming from India. In last decade, we’ve seen phenomenal growth in knowledge of common Indians that has changed their thoughts & life styles drastically.

I still remember those days when resources were scarce in most of the houses in India. Between 80s & 90s there were no T.V.s in any one’s flat in our building & hardly couple of cars. One of the reasons why people were so excited to see projected films during Ganpati festival… People were not having fan in all rooms & bulbs were there instead of tube lights in most of the rooms. Social issues were different at that time….. In news papers, news of “Sati”, dowry, child kidnappers, dacoits were common…. No one has heard of Cell phone term… Computers were available to see only in photos…. We all have come a long way indeed with lots of hard work & efforts…. We’ve created so many resources now that our youth has no reason to complain on that front… It will be a good idea if youth also joins hands with set of advancing mentalities & helps in moving this nation & its people forward…. At the end of the day, how you capitalize your skill strengths & build more on it in benefits of all with positive attitude in your center of focus & area of interest that’s what will eventually raise this nation towards excellence…. So it is very essential that you work towards building the excellence in your area of activities if you truly want to build excellent country on world’s map…

Reminds me this quote of some leader…

“Woods are dark & deep but I’ve promises to keep
& miles to go before I sleep & miles to go before I sleep”

God Bless India!!! Happy Independence Day!!!

Wednesday, August 3, 2011

Interview Questions on niche technologies: Silverlight-WCF-WPF-WF






Interview Questions

Project management

Define project?

A project, by definition, is a temporary activity with a starting date, specific goals and conditions, defined responsibilities, a budget, a planning, a fixed end date and multiple parties involved.

Who is a stakeholder?
Can you explain Scope triangle?
Can you explain what’s a vision and a goal?
What is ROI?
Can you explain project life cycle?
You have people in your team who do not meet there deadlines or do not perform what
are the actions you will take?
Are risk constant through out the project?
Explain SDLC (Software development Life Cycle) in detail?
Can you explain waterfall model?
Can you explain big-bang waterfall model?
Can you explain phased waterfall model?
Explain Iterative model, Incremental model, Spiral model, Evolutionary model and VModel?
Explain Unit testing, Integration tests, System testing and Acceptance testing?
what’s the difference between system and acceptance testing?
Which is the best model?
What is CAR (Causal Analysis and Resolution)?
What is DAR (Decision Analysis and Resolution)?
Can you explain the concept of baseline in software development?
What is the software you have used for project management?
What does a project plan consist?
When do you say the project has finished?
Can you explain what a PMO office is?
How many members in your team you have handled?
Is GANTT chart a project plan?
Two resources are having issues how do you handle the same?
What is a change request?
How did you manage change request in your project?
Can you explain traceability matrix?
what is configuration management?
What is CI?
Define stakeholders?
Can you explain versioning?
Can you explain the concept of sign off?
How will you start a project?
what is an MOU?
What where the deliverables in your project?
Can you explain your project?
Do you also participate in technical activities?
How did you manage code reviews?
you have team member who does not meets his deadlines how do you handle it?
did you have project audits if yes how was it handled?
What is a non-conformance report (NCR)?
How did you estimate your project?
How did you motivate your team members?
did you create leaders in your team if yes how?
how did you confirm that your modules are resource independent?
Was your project show cased for CMMI or any other project process standardization?
what are the functions of the Quality Assurance Group (QAG)?
Can you explain milestone?
How did you do assessme nt of team members?
What does entry and exit criteria mean in a project?
How much are you as leader and how much are you as PM ?
How can he handle the conflicts between peers and subordinates?
In your team you have highly talented people how did you ha ndle their motivation ?
How can you balance between underperforming and outperforming people ?
You need to make choice between delivery and quality what’s your take ?

Risk Management
Define risk?
What is risk break down structure?
How did you plan your risk?
what is DR, BCP and contingency planning?
Schedule Management
Can you explain WBS?
Can you explain WBS numbering?
How did you do resource allocation?
Can you explain the use of WBS?
Can you explain network diagram?
What are the different types of network diagram?
What is the advantage of using network diagrams?
Can you explain Arrow diagram and Precendence diagram?
What are the different types of Network diagrams?
Can you explain Critical path?
Can you define EST, LST, EFT, LFT?
Can you explain Float and Slack?
Can you explain PERT?
Can you explain GANTT chart?
What is the disadvantage of GANTT chart?
What is Monte-Carlo simulation?
Can you explain PV, AC and EV?
Can you explain BCWS, ACWS and BCWP?
What are the derived metrics from Earned Value?
Can you explain earned value with a sample?
Estimation, Metrics and Measure
What is meant by measure and metrics?
Which metrics have you used for tracking purpose?
What are the various common ways of estimation?
Can you explain LOC method of estimation?
How do we convert LOC in to effort?
Can you explain COCOMO?
Can you explain Intermediate COCOMO and COCOMO II?
How do you estimate using LOC?
Can you explain in brief Function points?
Can you explain the concept Application boundary?
Can you explain the concept of elementary process?
Can you explain the concept of static and dynamic elementary process?
Can you explain concept of FTR, ILF, EIF, EI, EO , EQ and GSC ?
How can you estimate number of acceptance test cases in a project?
Can you explain the concept of Use Case’s?
Can you explain the concept of Use case points?
What is a use case transaction?
How do we estimate using Use Case Points?
Can you explain on what basis does TPA actually work?
How did you do estimation for black box testing?
How did you estimate white box testing?
Is there a way to estimate acceptance test cases in a system?
Can you explain Number of defects measure?
Can you explain number of production defects measure?
Can you explain defect seeding?
Can you explain DRE?
Can you explain Unit and system test DRE?
How do you measure test effectiveness?
Can you explain Defect age and Defect spoilage?
Software process
What is a Software process?
what are the different cost eleme nt involved in implementing process in an organization?
What is a model?
What is maturity level?
Can you explain the concept of process area in CMMI?
Can you explain the concept of tailoring?
What is CMMI?
what’s the difference between implementation and Institutionalization?
what are different models in CMMI?
Can you explain staged and continuous models in CMMI?
Can you explain the different maturity levels in staged representation?
Can you explain capability levels in continuous representation?
which model should we use and under what scenarios?
How many process areas are present in CMMI and in what classification do they fall in?
What the difference between every level in CMMI?
what different sources are needed to verify authenticity for CMMI implementation?
Can you explain SCAMPI process?
How is appraisal done in CMMI?
which appraisal method class is the best?
Can you explain the importance of PII in SCAMPI?
Can you explain implementation of CMMI in one of the Key process areas?
Explanation of all process areas with goals and practices?
Can you explain the process areas?
Six Sigma
What is six sigma?
Can you explain the different methodology for execution and design process in SIX
What does executive leaders, champions, Master Black belt, green belts and black belts
What are the different kinds of variations used in six sigma?
Can you explain the concept of standard deviation?
Can you explain the concept of fish bone/ Ishikawa diagram?
What is Pareto principle?
Can you explain QFD?
Can you explain FMEA?
Can you explain X bar charts?
Can you explain Flow charting and brain storming?
Agile Development
What does Agile mean?
Can you explain Agile modelling?
What are core and supplementary principles in Agile modeling?
What is the main principle behind Agile documentation?
What are the different methodologies to implement Agile?
What is XP?
What are User Stories in XP and how different are they from requirement?
Who writes User stories?
When do we say a story is valid?
When are test plans written in XP?
Can you explain the XP development life cycle?
Can you explain how planning game works in Extreme Programming?
How do we estimate in Agile?
On What basis can stories be prioritized?
Can you point out simple differences between Agile and traditional SDLC?
Can you explain the concept of refactoring?
What is a feature in Feature Driven Development?
Can you explain the overall structure of FDD project?
Can you explain the concept of time boxing?
When to choose FDD and when to choose XP?
What is SCRUM?
What does product owner, product back log and sprint mean in SCRUM?
Can you explain how SCRUM flows?
Can you explain different roles in SCRUM?
Can you explain DSDM?
Can you explain different phases in DSDM?
Can you explain in detail project life cycle phase in DSDM?
Can you explain LSD?
Can you explain ASD?

Which index will get used to locate a record in this scenario?

Just came across this question in interview. If any one knows the answer then please let me know -->
In SQL server, if a table column has both indexes applied over it i.e. clustered as well as non clustered then which index will get used to locate a record?
I've given reply as clustered index because in clustered index leaf node refers to actual data & no further traversal needed. So optimizer will select clustered index in its execution plan. But that answer was just my guess. Later on I read that for count function over such indexed column, it uses non clustered index as it is faster... Can't find the answer over internet for question "which index will get used to locate a record?" Any one who knows the correct answer??

Monday, January 3, 2011

Cloud Computing related web sites

Check out cloud computing videos on: