I know how that feels. In fact, I once played a game where I wiped out half of my opponent's board, then dropped my queen to a revealed attack! (How embarrassing.) Fortunately, I had more than enough pieces left over to gain an easy victory anyway. That was before I paid attention to chess strategies.
Back to the point. When making moves, always ask yourself: what does this move achieve? Pieces should move with a purpose--extra material counts as no material at all if not used, hence the idea of gambits. If you have even the slightest bit of extra material, try to convert it into an attacking advantage. Extra material typically means a better position, because each extra piece means more possibilities! (In fact, I think I summarized the idea quite well in this forum post.)
The problem with tactics practice alone (I used to spend literally hours a day on chesstempo.com) is that it teaches how to win pieces in a given situation, and not what to do with the extra pieces afterwards. Once extra material is obtained, the simplest thing to do is simply to trade it off. The even better solution is to harness everything you have in an attack on the enemy king, making sure to use your extra material to aid you.
To get you started on attacking strategy, I strongly recommend watching this video. Afterwards, look up "Kingscrusher" (CM Tryfon Gavriel) on youtube, and take a look at some of his chess games. He smoothly explains his strategy and thought processes as he plays, and has upwards of a hundred videos online, and counting.
I am roughly a 950 rated player right now. My tactics trainer rating right now is 1400. I find that in almost all of my games I always acquire some sort of material advantage pretty easily in the openings and middle-game, usually a couple of pawns or a minor piece or maybe more. However, once we get to the end of the middle-game and into the endgame, I find I begin to deteriorate in my play. I often end up in a considerable positional weakness, and sometimes I even lose despite my matierial advantage.
This has happened for the past dozen or so games (both on chess.com and real). It is so frustrating to see what seems like a relatively won position degenerate into a lose, and I frankly don't see why.
Can anybody help me here? How can I improve my endgame and help convert advantages into wins?