Skip to main content

Posts

India: How to Install missing Amazon Prime Video App on Samsung Smart TV

Amazon Prime Video service, launched in India a year back, offers unlimited, ad-free Hollywood and Bollywood entertainment for just Rs.499 per year! We would say this is the best entertainment package currently available in India.
Apart from latest movies and TV shows, Amazon started offering exclusive local content made for Indian audience. You can watch them on your PC, Android and iPhone devices. Amazon Prime mobile app is powered with offline viewing as well as low bandwidth consumption, which is a great feature considering the average internet speed in India.
Generally people doesn't like watching movies and TV shows on smaller screens. People prefer bigger screens and Hi-Fi audio systems to get real theater effect. Unfortunately Amazon Prime Video is not available in most of the smart TVs available in India. One option is to useAmazon Fire TV Stick or similar casting device to watch the content on TV. But you would have already paid a premium amount to buy a smart TV, you won…
Recent posts

Paying High Interest Rate for your LICHFL Home Loan? Reduce it NOW!

Many people who have taken loan from LIC Housing Finance Ltd. (LICHFL) are complaining that they are being cheated by LICHFL by charging a high interest rate for the home loan they have taken few years back. When most of the public and private banks are charging only 8%-9% interest, existing borrowers of LICHFL are being charged 10% to 12% interest!

People are transferring there loan to most popular SBI Maxgain and other private sector banks, but the process involves time and money.
Why such a huge difference in interest rate?We checked the sanction letter of few and found that they have taken a floating loan which had a 'n' years fixed rate, for example, fixed rate for 5 years @ 10.15% p.a. and then at floating rate linked to LHPLR.



Fixed rate for 5 years @ 10.15% p.a. or as prevailing at the time of disbursement for the period of interest for the loan. After 5 years, the rate of interest will be reset with reference to the then prevailing floating rate of interest linked to LI…

How to fill FATCA Self-Certification of Declaration Form for your PRAN

Worried about the email received from NPS Trust(National Pension Scheme) asking you to submit self certification of declaration form for your PRAN (Permanent Retirement Account Number)? The email even says your account will get blocked temporarily from 1st of May 2017 if the declaration is not submitted by 30th of April 2017.

Don't get panic, financial institutions in India have to obtain self-certification from all bank, mutual fund and pension scheme account holders whose accounts were opened on or after July 1, 2014 and have to do a due diligence as part of Income Tax Rules. You are advised to submit the declaration form at the earliest so that your account is compliance with the local laws.


If you don't have NPS account, you can open one online, read Opening NPS account online - Step by step guide.
* Do you have a home loan? Learn how to reduce interest on your existing home loan (opens in new tab)
What is FATCA?FATCA stands for Foreign Account Tax Compliance Act, under Rule…

Top attractions in Singapore - 5 days Singapore Itinerary for December

This itinerary is based on the recent trip I made to Singapore. You may add/remove attractions based on your interests but make sure to spend enough time at each attraction so that you can absorb maximum out of your trip.

Itinerary
Day 1: Reach hotel in the morning, freshen up and then go for a Half Day City tour. Make sure to visit Merlion Park, Marina Bay, Chinatown, Mount Faber, Jewellery factory, Sri Mariamman Temple and Little India.


Once you are done with City Tour, head for Night Safari, it starts at 6PM, spend the evening there. Some shows might get cancelled due to rain. Day 2: Today  you will visit Sentosa Island, start early so that you will get enough time to enjoy the attractions. Start with Cable Car ride, then enjoy the SEA Aquarium. 


SEA Aquarium is huge, you will spend half day there. Enjoy other activities in this island such as Skyline Luge, Sky Ride, Eco Ride etc. Also you can try Tiger Sky Tower, Butterfly Park, Madam Tussauds, 4D Adventure Land etc. Day 3:Sentosa Islan…

Opening an NPS account online - Step by step guide

With the recent announcement of additional income tax benefits, government pension scheme named National Pension Scheme(NPS) is getting more popularity. Since it is linked to equity, chances of getting returns higher than that of Public Provident Fund(PPF) is high, past years performance proves this theory.
If you are looking for income tax benefits, Rs.1,50,000 deduction is allowed under section 80CCD(1) and Rs.50,000 as per section 80CCD(1b).

Interested? Just follow the steps given below, you can open an NPS account in just 10 minutes!

Step#1: Navigate to https://enps.nsdl.com/eNPS/ and click on "REGISTRATION" link. 

Step#2: Select "New Registration" then "Individual Subscriber". You can register with "Aadhaar" or "PAN", let's do it with Aadhaar which is the easiest option as your photo and contact details will get populated from Aadhaar database.

Select Account Type as "Tier I & Tier II". Tier II is like a savings…

PAN Number of SBI, LICHFL, HDFC, Axis Bank, Punjab National Bank etc. for Income Tax Filing

From 2016 onwards PAN number of the bank/financial institution is mandatory to avail income tax benefits from loss of house property(let out as well as self occupied).
Here you can find the PAN number of all popular lenders which you can put in your form 12BB.
The data provided is for your information only. We request you to validate this data with your bank/financial institution before filing tax returns.
Bank / Financial Institution
Permanent Account Number (PAN)
Allahabad Bank
AACCA8464F
Andhra Bank
AABCA7375C
Andhra Pradesh Grameena Vikas Bank (APGVB)
AAAJA1351N
Andhra Pragathi Grameena Bank (APGP)
AAMFA8921A
Axis Bank Limited
AAACU2414K
Bank of Baroda (BoB)
AAACB1534F
Bank of India (BoI)
AAACB0472C
Bank of Maharashtra (BoM)
AACCB0774B
BMW India Financial Services Private Limited
AADCB8986G
Canara Bank
AAACC6106G
Canfin Homes Limited
AAACC7241A
Central Bank of India
AAACC2498P
City Union Bank Limited
AAACC1287E
Corporation Bank
AAACC7245E
DCB Bank Limited
AAACD1461F
DECCAN GRAMEENA BANK / TELANGANA GRAMEENA BANK
AA…

Why you should avoid PayTM - Pros and Cons of Digital Wallets

With recent demonetization drive by the Modi government, wallet services like PayTM, MobiKwik, Freecharge etc. are becoming popular even among common people. Earlier wallet services were popular only with online shoppers but now even street vendors started accepting payment via wallets.
With these wallets, payment is just a button click for most of the services like bill payments, movie tickets and even money transfer to your friends and relatives. Some providers even allow you to use their services offline and also without a smart phone. So the possibilities are unimaginable, wait and watch for India being transformed to a "Cashless" and "Digital" India!
Till now I was talking about the advantages of wallet services, no doubt all of you will agree that this is the first step towards a cashless economy. Now the question is, how good our rules and regulations are around these wallet services? Does the law enforce a dispute resolution mechanism to resolve issues of com…

[Solved] java.sql.SQLException - Zero date value prohibited

Recently while working on a Java + Spring + Hibernate + MySQL project I encountered a weird exception "java.sql.SQLException: Zero date value prohibited"!

As usual I did a quick search on Google but to my surprise Google did not return any result!
First I was scared, thought troubleshooting would be difficult. Upon closed analysis of the issue, this came out to be a silly data issue!

org.springframework.dao.TransientDataAccessResourceException: Hibernate operation: could not execute query; SQL [select field1, field2, field3 from table1]; Zero date value prohibited; nested exception is java.sql.SQLException: Zero date value prohibited.

I had a date column where the entries were '0000-00-00', just nullified the entries and the error went away!

Failed to retrieve account attributes error with new aws account

Getting the error "Failed to retrieve account attributes, certain console functions may be impaired" while trying to create a new RDS instance or while rolling up a new EC2 instance?

Don't worry, you are not alone. There are various reasons for this error to occur, sometimes due to missing permissions, sometimes due to account setup issues.

If you are getting this error on a new aws account, just wait for 2 to 8 hours, your account setup is not yet complete. And the reason could be the $1 auth on your credit card is not yet done. Just wait and re-try, you would be able to use your account without any issues.
If you are getting the error with an existing account, the error could be due to lack of permissions in access policies to the actions invoked by the the console. To fix this error, the IAM admin should provide necessary roles to the IAM user. Say for example you are getting error while setting up ElastiCache, add ec2:DescribeAccountAttributes and ec2:DescribeSecurityGr…

India - How to download and install "Pokemon Go" on Android devices

Pokemon or Pokémon Go, a trending game from Nintendo is not yet launched in India, still you can install and play the game on your Android phone. Want to know how?
Since Pokemon Go is not launched in India, you will not be able to see it in the Google Play Store. You can download the apk from third party sites but it is not advised to do so as those would contain malware which would steal your data and even corrupt your phone. We strongly recommend to use a VPN tunnel and download the game from Google Play Store itself.

First you need to install a VPN client such as 'TunnelBear' on your device. It is freely downloadable from Google Play. Once installed, open the application and select "United States" as target location from the drop-down and then activate VPN. This will change the location of your phone to US.
Now go to Google Play Store and search for "Pokemon Go". If the game is not listed, go to Settings->Apps->Google Play Store and clear the data and…