BBA

Well, executive MBA may increase your knowledge and add management perspective in your thinking but unless your organisation has a policy to give favorable increment and position for those with MBA, it is not going to add value. Yes, if you change your job and the new organisation need an MBA graduate then your executive MBA comes as a rescue. As far as full time MBA is concerned, you need to take care of the following:
If you do MBA from top 10 institutes in India, average package is 17 LPA, if you do it from top 11 to 20, you may expect a package around 13 LPA, if you do it from 21 to 30, the package will be around 10 LPA, if you do it from 31 to 40, the package will be around 7 LPA and if you do it from 41 to 50, then the package would be around around 4 LPA. I don't think considering as you are already working and earning around 3 LPA (I am assuming). There is no point of doing MBA from above 50 ranked institutes.

Dear Anup,
There are many employment opportunities in banking, insurance, marketing/sales, accountancy and financial management, etc.
For almost all positions, other than specialised jobs, most of the company will admit Any Graduates. For example, for executive / senior executive position in sales / marketing / HR graduation in any discipline is enough.
But when there is only one position, where a history / economic graduates and BBA graduate is shortlisted, the company management will prefer BBA graduate.
BBA / MBA graduates can start career as management trainee and can reach the top management position (Based on skill, hard work, communication / interpersonal skills, leadership quality etc.)
Lot of specialisations are available at MBA level. Apart from traditional specialisation (HR, finance, marketing & systems), a list of sectoral programs available such as:
1. Travel and Tourism Management
2. Educational Management
3. Shipping and Logistics Management
4. International Business Management
5. Foreign Trade
6. Banking and Insurance Management
7. Media & Entertainment Management
8. Corporate Secretaryship
9. Project Management
10. Petrolium Management
11. Airline and Airport Management
12. Hospital & Healthcare Management
13. Hospitality Management etc. and Many More.So career opportunity after MBA depends your specialisation.
But there are some specialised jobs / profession in corporate sector such as Business Advisor, Business Consultant, Business Analyst, Corporate trainer, etc.