Aggarwal, who is a financial analyst, was charged last year by the US authorities for spilling confidential information about the deal between Microsoft and Yahoo to a portfolio manager at a hedge fund advisory firm.
The Securities and Exchange Commission order, issued on January 8, follows Aggarwal's submitting an offer of settlement which has been accepted by the SEC.
Aggarwal has been barred from association with any broker, dealer, investment adviser, municipal securities dealer, municipal advisor, transfer agent, or nationally recognised statistical rating organisation.
Passing the order, SEC said it deems appropriate and in the public interest to impose the sanctions agreed to in Aggarwal's offer.
More From This Section
The regulator had charged Aggarwal for tipping secret information to a S A C Capital portfolio manager who had earlier been charged with insider trading.
Later, the information was passed on to a portfolio manager who subsequently traded securities based on the tip.
"Aggarwal knew, recklessly disregarded, or should have known, that the material non-public information he received and tipped was disclosed or misappropriated in breach of a fiduciary duty, or similar relationship of trust and confidence," the complaint had said.
In November last year, Aggarwal pleaded guilty to one count of securities fraud and one count of conspiracy to commit securities fraud.