Why LED works but BC547 is not Working ?

be80be:
Its not going to work the OP doesn't have the gnd tied on the arduino

Good catch!