Application planning, building, implementation and execution. Resource and budget management.


Marketing, Advertising, Logo and Graphic Design. Brand Identify and awareness.


I'm ESL/EFL certified with 3 years experience and also a TOEFL Administrator.



Experience in PC, Mac, Unix and exposure Android and iOS. Open source development technologies, PHP, mySQL, Java.


Business consulting, process mapping and design, SDLC, application development and quality control.



My name is Ahmed Varachia. I was born on March the 17th 1982 in Johannesburg, South Africa. My Motto - Dream > Direction > Dedication > Determination > Destination ...



    As you’ve probably noticed, I’m an IT geek. I have a BSc in Computer Science (IT). I’ve also completed a diploma in TEFL. Check-out my online CV here or download my latest creative CV here and my timeline here.



    I’ve worked on a range of technologies, from Lotus Notes, Mainframe, Oracle to PHP (Web development). My vast exposure to different technologies has empowered me to adapt and evolve quickly. Currently I enjoy working on cloud and mobile application development.



    I love teaching – its a new found passion for me since 2010. It’s an amazing profession and one of the most rewarding I’ve ever experienced. I’ve been teaching full-time/part-time since 2010 at Berlitz Al Ahsa. I’ve taught English to kids from ages 6 to an adult in his 60s – truly an amazing journey that has really defined my character.



    As a human, I like to question everything. I like to understand how things work, why they are how they are, and how it affects what I do. I love working with my hands and converting my crazy ideas into art. From wooden art, painting, and general DIY around the home/office I love to play. Still a very junior photographer with a Nikon 3100 I’ve recently been clicking galore.

Skills // Senior Business Analyst with a passion for technology. With over 15 years experience in IT, and 4 years instructional experience (ESL). I have a creative mind comfortable with working with graphics and web technologies and the ability to adapt and learn quickly are my strengths.

  • 19 on Cochrane

  • Accenture

  • African Feather

  • AIA Vitality

  • Ambushed

  • AMC-Projects

  • Autostyle

  • bakeityourself.co.za

  • Berlitz Al Ahsa

  • Charlie Electric

  • Chompalot

  • Dar al-Khibra

  • Discovery (Vitality)

  • Edcon

  • EFL

  • Eqos Sourcing

  • Generali Vitality

  • Get Paid Ent

  • Goodes & Seedat Inc. Attorneys

  • Headquarters

  • Idarah Dawatul Haq

  • KKM

  • KM-Motivation

  • KnowledgeTree (myKT)

  • Learn Deen

  • Legend Safaris

  • Limesurvey

  • Logo Design

  • Mainframe

  • Marketing

  • Online Testing – myQuiz

  • Oracle Financial

  • PhD Research Assistance

  • Process Management

  • Rahmaniyyah

  • Refrimate


  • Scheduling Management System

  • Shaik’s Foods

  • SmartBoard

  • Social Booking Calendar

  • Social Media

  • Social Media

  • Speechperfect

  • Sumitomo Vitality

  • Team Building

  • Theba Realtors

  • Ticketing Support System

  • Vabro

  • Varachia Family

About this Blog // Welcome to my Blog - read about my interests and what's on my mind etc. I hope you find my educational bits helpful and useful. If you need any help post a comment or send me a message


    AUTHOR: // CATEGORY: ESL, Saudi Arabia

    No Comments


    Got to love them if you’ve ever taught ESL .. found a cool image list on the net some time ago. Not my work and I can’t remember the authors blog – so full credit to anon.

    149 item(s) « 5 of 5 »

    AUTHOR: // CATEGORY: Uncategorized

    No Comments

    How to merge or combine multiple files

    Updated: 11/13/2018 by Computer Hope

    If you would like to merge multiple Word, Excel or text files together, it can be done with relative ease and at no extra cost. Follow the steps below for the type of file you’re trying to merge.

    Tip: For many users, it is easier to copy and paste the contents of multiple files into a new file as a form of merging or combining files.

    Merging Microsoft Word documents

    To merge Word documents, you can merge those documents within Microsoft Word itself. To do this, open the first file in Microsoft Word, and follow the steps for your version of Word. The steps are different because of the changes between the file menu and the Office ribbon.

    Microsoft Word 2007 or later (ribbon)

    In the Word ribbon, click the Insert tab, click the down arrow next to Object, and select the Text from File option, as shown below.

    Word 2010 file merge

    Select the file you want to merge into the current document and click Insert. Once completed, the text and other information from the document will be merged into the current document. These steps can be completed as many times as you want if you want to merge multiple files.

    Tip: If there are multiple files you want to merge at the same time, you can select multiple files by holding down the Ctrl key and selecting each file you want to merge.

    Microsoft Word 2003 or earlier (file menu)

    In Word, click on Tools in the top menu and select the Compare and Merge Documents option, as shown below.

    Merge Microsoft Word document

    Find the document you want to merge. You have the option of merging the selected document into the currently open document or merging the two documents into a new document. To choose the merge option, click the arrow next to the Merge button and select the desired merge option. The files will then be merged.

    Compare and Merge files

    Tip: If there are multiple files you want to merge at once, you can select multiple files by holding down the Ctrl key and selecting each file you want to merge.

    Merging Microsoft Excel files

    To merge Microsoft Excel files together, it is best to save them as CSV files first. Open the Excel files and in the menu bar, click File, then Save As. In the Save as type drop-down list, select CSV (comma delimited) (*.csv) from the list.

    Do this for each Excel file you want to merge, then place all the CSV files in the same folder. For ease, place them in a folder in the root of the C: drive (e.g., c:\csvfiles).

    Open the Windows command prompt and navigate to the folder containing the CSV files. Type dir to view the files in the folder and ensure all the files are there.

    Type in the following command to merge all CSV files in the folder into a new CSV file titled “newfile.csv” (any name could be used).

    copy *.csv newfile.csv

    After the new file has been created, open the new CSV file in Microsoft Excel and save it as an Excel file.

    Merge a text (.txt) file in the Windows command line

    Place each of the text files you want to merge in the same folder. For ease, place them in a folder in the root of the C: drive (e.g., c:\textfiles) and make sure the folder only contains text files you want to merge.

    Tip: Before merging text files, you may want to make sure there is a blank line or at least one carriage return (pressing the Enter key) to help separate each file.

    Open the Windows command prompt and navigate to the folder containing the text files. Type dir to view the files in the folder and ensure all the files are there.

    Type in the following command to merge all TXT files in the current directory into the file named newfile.txt (any name could be used).

    copy *.txt newfile.txt

    Now you can open the text file and see everything merged together as one file.

    Merge a file in the Linux command line

    Linux users can merge two or more files into one file using the merge command or lines of files using the paste command.

    Merge PDF files


    PDF documents can also be merged. You can use a full version of Adobe Acrobat to do this, but this program is a bit pricy (several hundred dollars).

    Another option is to find a free utility on the Internet to merge your PDF files. One of the better free utilities is PDF Split and Merge. It is an online tool that lets you merge two or more PDF files into one PDF file with a few clicks of your mouse button. You can also download and install a version of the Batch PDF Merger program, which costs about $30.

    There are other free utilities online that offer this service. However, if there is any confidential information contained in the PDF files, use caution when merging them online. It is recommended that you use a utility on your computer for these types of PDF file mergers, to ensure the confidential data is kept confidential.

    • MergePDF – Online utility to merge PDF files up to 30 MB.
    • PDFMerge – Another great free utility to merge PDF documents.
    • Sej-da – An additional utility to merge PDF files up to 50 MB.

    Credits: https://www.computerhope.com/issues/ch001376.htm#merge-text


    AUTHOR: // CATEGORY: Development, IT, PC, Windows

    No Comments


    To fully retain the characters while saving it on a CSV format and to somehow be able to import/re-use the data in the future.

    You can follow these steps.

    1. In Microsoft Excel, open the *.xlsx file.
    2. Select Menu | Save As.
    3. Enter any name for your file.
    4. Under “Save as type,” select Unicode Text.
    5. Click Save.
    6. Open your saved file in Microsoft Notepad.
    7. Replace all tab characters with commas (“,”).
    • Select a tab character (select and copy the space between two column headers)
    • Open the “Find and Replace” window (Press Ctrl+H) and replace all tab characters with comma .

    Replace Tabs with commas in Notepad

    1. Click Save As.
    2. Name the file, and change the Encoding: to UTF-8.
    3. Change the file extension from .txt to .csv.
    4. Click Save.
    5. Open the .csv file in Excel to view your data.


    https://stackoverflow.com/questions/24087432  /excel-xlsx-file-saving-as-csv-file-korean-and-japanese-cracking-badly


    AUTHOR: // CATEGORY: Careers

    No Comments

    1. The “How Many [Things] Are There in [Location]?” Question

    On the slight chance that your brain doubles as Google:

    2. The “How Many [Things] Could Fit in [Container]?” Question

    File these under: “How and why would anyone ever know this?”

    3. The “Do Some Quick Math” Question

    In case your brain needed a really fast workout:

    4. The “Why Is [Common Item] [the Way Common Item Is]” Question

    These are also known as questions a four-year-old might ask that would also stump you:

    5. The “Explain [Concept] to a [Difficult-to-Explain-Concept Person]?” Question

    Otherwise known as, “explain your startup job to your grandmother at Thanksgiving” questions.

    6. The “Solve This Mystery” Question

    Oh, occasionally you’ll be asked to go detective and solve a mystery:

    • “A windowless room has three light bulbs. You are outside the room with three switches, each controlling one of the light bulbs. If you can only enter the room one time, how can you determine which switch controls which light bulb?” (source)

    Too easy? Here’s another:

    • “Four investment bankers need to cross a bridge at night to get to a meeting. They have only one flashlight and 17 minutes to get there. The bridge must be crossed with the flashlight and can only support two bankers at a time. The Analyst can cross in one minute, the Associate can cross in two minutes, the VP can cross in five minutes, and the MD takes 10 minutes to cross. How can they all make it to the meeting in time?” (source)

    7. The “How Would You Do Something Ridiculous” Question

    And this last category is all about putting your creativity (and I guess, sometimes violence?) to the test:

    Stumped on where to even begin? Fair enough. Muse writer Jeremy Schifeling has advice on actually solving these impossible brain teasers.




    AUTHOR: // CATEGORY: Careers

    No Comments

    Facebook Brain Teaser Interview Questions and Answers:

    Question 1:

    A Russian gangster kidnaps you. He puts two bullets in consecutive order in an empty six-round revolver, spins it, points it at your head and shoots. *click* You’re still alive. He then asks you, “do you want me to spin it again and fire or pull the trigger again right away?” For each option, what is the probability that you’ll be shot?


    The key hint here is that the bullets were loaded adjacent to each other.

    There are 4 ways to arrange the revolver with consecutive bullets so that the first shot is blank. These are the possible scenarios:

    1. (xBBxxx)
    2. (xxBBxx)
    3. (xxxBBx)
    4. (xxxxBB)

    The other two scenarios would have meant you got shot on the first attempt. (BBxxxx) or (BxxxxB)

    Now look at the second slot in those 4 possible scenarios above. Your odds of getting shot are 1/4 or 25%. (Only #1 would get you shot)

    But if you respin… there are 2 bullets remaining and 6 total slots. 2/6 or 33%.

    Question 2:

    You’re about to get on a plane to Seattle. You want to know if it’s raining. You call 3 random friends who live there and ask each if it’s raining. Each friend has a 2/3 chance of telling you the truth and a 1/3 chance of messing with you by lying. All 3 friends tell you that “Yes” it is raining. What is the probability that it’s actually raining in Seattle? 


    You only need 1 of your friends to be telling the truth for it to be raining in Seattle.

    It’s fastest just to calculate the odds that all 3 are lying, and it’s not raining.

    Each friend has a 1/3 chance of lying. Multiply the odds together… you get 1/27 (1/3 * 1/3 * 1/3).

    We’re not done yet though… 1/27 is the probability that all 3 friends lied at the same time.

    The probability that at least 1 told you the truth? 26/27 or around a 96% that it’s raining in Seattle.

    Google Brain Teaser Interview Questions and Answers:

    Question 3:

    You have a 3 gallon jug and 5 gallon jug, how do you measure out exactly 4 gallons? 


    We know we can’t get the final result in the 3 gallon jug. It’ll overflow. We need to end up with 4 gallons in the 5 gallon jug.

    First fill the 3 gallon jug.

    Then pour the 3 gallons into the 5 gallon jug.

    Now the 3 gallon jug is empty, and the 5 gallon jug has 3 gallons in it.

    Fill the 3 gallon jug again. Slowly pour into the 5 gallon jug. Only 2 gallons will fit because it already has 3. Now it’s full.

    Exactly 1 gallon is left in the 3 gallon jug.

    Dump out the 5 gallon jug.

    Pour your 1 gallon into the 5 gallon jug.

    Fill up the 3 gallon jug one more time and pour it into the 5 gallon jug! You have exactly 4 gallons (and possibly a job at Google)

    Question 4:

    Why are manhole covers round?


    Good news: If you’re tired of math questions this one will give you a break.

    Manhole covers are round because it’s the only shape that cannot fall through itself. The cover can never accidentally fall down the hole.

    Microsoft has been known to ask this question and according to Glassdoor.com, Google is asking this too now.

    Apple Brain Teaser Interview Questions and Answers:

    Question 5: 

    There are three boxes, one contains only apples, one contains only oranges, and one contains both apples and oranges. The boxes have been incorrectly labeled such that no label identifies the actual contents of its box. Opening just one box, and without looking in the box, you take out one piece of fruit. By looking at the fruit, how can you immediately label all of the boxes correctly? 


    So, you know all 3 boxes are incorrectly labeled.

    Go to the box labeled “Apples + Oranges.” Since the label is wrong, it must have one or the other.

    This is the box to take one piece of fruit from. Whichever comes out is what that box contains. If you took out an apple, the box has only apples. If you took out an orange, vice versa.

    Here’s where it gets tricky a bit tricky. But we’re almost done…

    Let’s say you grabbed an apple. Move the “Apples” label over to that box. Now it’s correctly labeled.

    You know the “Oranges” box is still labeled wrong (because all 3 were labeled wrong to start and you haven’t touched it). And you know it’s not “Apples”.

    So it has to be “Apples + Oranges”.

    The last box is “Oranges”.

    The same process above would work if you had pulled out an orange at the start.

    Question 6: 

    You have a 100 coins laying flat on a table, each with a head side and a tail side. 10 of them are heads up, 90 are tails up. You can’t feel, see or in any other way find out which 10 are heads up. Your goal: split the coins into two piles so there are the same number of heads-up coins in each pile. 


    By pure coincidence… this is a trick my friend Mike showed me last summer. It blew my mind back then but hopefully it’ll make sense as I write it out.

    You want equal number of heads in each pile. There are currently 10 of them. You don’t know which but it doesn’t matter. All you have to do… take any 10 coins out of the 100, put them into a separate pile, and flip those 10 over.

    That’s pile #1.

    Pile #2 is the remaining 90 coins, unflipped. Just leave them.

    You’re done. Seriously.

    You can do this with any number of coins. If you had 20 coins, and 18 were heads, you’d need to take 18 of them (it doesn’t matter which) into a separate pile and flip those 18. That’s pile #1.

    If you had 10 coins and 3 were heads, you’d take 3 random coins into a new pile and flip those 3 for your first pile, and the rest are your second pile.

    Crazy right?

    If you don’t believe me just grab some pennies and try it.

    There are no exceptions and it doesn’t need to be an even amount of “heads” to begin with either. It can also be zero. Or all.

    LinkedIn Brain Teaser Interview Questions and Answers:

    Question 7: 

    You’re in a room with three light switches, each of which controls one of three light bulbs in the next room. You need to determine which switch controls which bulb. All lights are off to begin, and you can’t see into one room from the other. You can inspect the other room only once. How can you find out which switches are connected to which bulbs? 


    Let’s call the switches 1, 2, and 3.

    Leave switch 1 off.

    Turn switch 2 on for ten minutes.

    Now turn it off and quickly turn on switch 3.

    Go into the room and inspect…

    The bulb that is still warm but not lit up is controlled by switch 2. The one that’s currently lit up is switch 3. The last one is switch 1.

    Question 8: 

    How many golf balls would fit into a Boeing 747?


    This last one is tough, but they don’t expect you to get an accurate answer. If you get a question like this (and there are a ton of variations- basketballs in a room, cellphones in Manhattan, etc.) they want to see your thought process.

    The hiring manager is going to look at how you work your way through it and attempt to figure it out.

    If you can break a problem down into smaller pieces, stay calm, and get an answer that’s not perfect but reasonably close, you’ve done great.

    They might not even know the answer. They just want to see how you approach something that’s very difficult.

    Question 8 above highlights a pretty good point to remember in your interviews…

    There are a lot of questions in an interview where the hiring manager values your thought process. Sometimes more than a correct answer.

    If you’re stumped, talk out loud a bit and explain what you’re thinking. Ask a question if you need to. Try to break it down into smaller pieces.

    Specific knowledge can be taught but they can’t teach you problem-solving. Show them this and you have a great shot at getting hired!


    The hiring manager liked my approach to breaking down a problem that I didn’t immediately know how to solve. That’s why being transparent and showing your thought process is one of the tips for interviews that you’ll see me say over and over.

    You can learn to do the same and get far more job offers.

    The big takeaway: Don’t panic when you get a question you don’t know… use it as an opportunity to show exactly how you work through things. Be confident with it, relax, smile. Remember… you’re giving the hiring manager what they want!





    AUTHOR: // CATEGORY: Development, Wordpress

    No Comments

    By default when your web server does not find an index file (i.e. a file like index.php or index.html), it automatically displays an index page showing the contents of the directory. This could make your site vulnerable to hack attacks by revealing important information needed to exploit a vulnerability in a WordPress plugin, theme, or your server in general. In this article, we will show you how to disable directory browsing in WordPress.

    An example of directory index browsing in WordPress

    Why You Need to Disable Directory Browsing in WordPress

    Directory browsing can be used by hackers to find out if you have any files with known vulnerabilities, so they can take advantage of these files to gain access. For the comprehensive security of our sites, we use Sucuri for WordPress security. They have a simple dashboard which allows us to do this and perform many other WordPress security strengthening steps with in few clicks.

    Directory browsing can also be used by other people to look into your files, copy images, find out your directory structure, and other information. This is why it is highly recommended that you turn off directory indexing and browsing.

    Video Tutorial

    If you don’t like the video or need more instructions, then continue reading.

    To disable directory browsing in WordPress all you need to do is add a single line of code in your WordPress site’s .htaccess file located in the root directory of your website. To edit the .htaccess file you need to connect to your website using an FTP client.

    Once connected to your website, you will find a .htaccess file in your site’s root directory. .htaccess is a hidden file, and if you can not find it on your server, you need to make sure that you have enabled your FTP client to show hidden files.

    You can edit your .htaccess file by downloading it to your desktop and opening it in a text editor like Notepad. Now at the end of your WordPress generated code in the .htaccess file simply add this line at the bottom:

    1 Options -Indexes

    Now save your .htaccess file and upload it back to your server using your FTP client. That’s all you need to do. Directory browsing is now disabled on your WordPress site and people trying to locate a directory index on your website will be redirected to WordPress 404 page.


Address // SwartGoud Street
Ridgeway, Johannesburg, Gauteng, South Africa

Mobile nr. // +27822644880

Please, write your name. Please, insert your e-mail address. Please, leave a message.