Hi Anand,
I think you had advised by an unexpirienced astrologer. For scorpio or as per your horoscope is not at all yoga karaka.
For your job you can do following remedies.
Chant OM DRAAM DREEM DROUM SHA SHUKRAYA NAMAHA!!! for min 6 times facing east in evening after 6.30pm sitting on wooden platform and non of your body parts should touch the ground. Every day.
Every friday try to visit lakshmi devi temple near your place and provide 6 pradakshina praying her.
GOD BLESS!!!
Srinivasa Temkar