To be honest, it wouldn't make much difference what skills or qualifications I had under my belt, with my state of mind I can only focus on the negatives. I am unable to work, and don't have much money left at all, and now am suffering physically. Not sure how many days it has been now because I can never sleep without alcohol, maybe 3-4? That is the most positive thing right now, I just hope I can get into a healthier pattern of thinking. If not, I will certainly be homeless before the end of the year, and then I will be screwed. Where I live homeless people are very stigmatised and there is very, very little help given to them - they almost always end up with severe substance abuse issues and many die in the winter months.
When you consider the negative impacts drinking has on sleep, getting 3-4 hours of sober sleep is probably just as effective if not better than 6-8 hrs of drunken sleep.
Here is a pretty cool podcast where Joe Rogan talks to a sleep expert, Matthew Walker. It's pretty informative, he talks about healthy sleep habits as well as habits that have negative impact on sleep.
With as long as you have been drinking, it will probably take at least a month before your sleep schedule starts to look "normal". It's difficult to push through the first few days and weeks when you feel exhausted and restless at the same time. Keep in mind that your body will adjust to whatever your current habits are, so if you have healthy habits your body will eventually adjust to them.
Try to use that fear of homelessness to motivate you into monetizing some of those skills you have. You mention you are both bi-lingual and a good writer. Those two skills alone should be enough skill to keep you from being homeless, even if it means you are working a register as a sales clerk. There are also manual labor jobs that don't require any skill if you are in desperate need of money. Apply at temp agencies and check with the local unemployment department for leads on work. Set goals for financial stability and take the steps to reach them.
Probably the biggest thing that will change your mindset is getting out of isolation, and getting involved in a group of supportive people. AA and other support groups has helped a lot of people accomplish this. There will always be people judging you for the decisions you make. Concern yourself with those that want to see you succeed, not those that want to watch you fail. Usually failures want others to fail, so what good is their opinion anyways. Don't get caught up in the negativity. Find positive people and get caught up in the positivity.
There are some steps you can take to change your mindset on your own, as well. Practicing mindfulness is something I think everyone should take the time to do. It's easy to let your thoughts and feelings sort of take off on their own, leaving you feeling off-centered or unbalanced emotionally. You'll catch yourself starting arguments you don't care to have and find it difficult to contribute anything positive. It's hard to have understanding while you are frustrated, and often the solution only becomes apparent once the mind has calmed. Daily journaling exercises and meditation can help make you more aware of your self-sabotaging thoughts, things like "it's hopeless" "it will never work" are very limiting lines of thought, and often become self-fulfilling. By becoming aware of where and when these types of thoughts occur for you, you can start to break out of this negative thought loop and accomplish things you once thought were impossible(like going without drinking and being happy about it).
Keep track of your feelings, and things that affect them. Your feelings are important, and it's ok to feel. One of the big change I noticed for myself is having to actually work through my emotions, rather than just swallowing a bunch of pills and moving on to the next thing. I remember thinking "damn, this is it. I've got nothing for the way I feel." a lot in rehab, especially in the mornings. But the more time I spend in recovery, the more I start to realize there are so many ways to change the way you feel, and drugs happen to be one of the most destructive ways of doing so.