Custom analyzer to handle the aliases so that string can be searched

[vinayak]

{
          "type" : "File",
          "scope" : "Business",
          "item" : "NAV",
          "object1" : "VCS_FA_NAV",
          "object2" : "VCS_TRADE_TRANSCATION",
          "query" : "LEFT OUTER JOIN VCS_TRADE_TRANSCATION mod1 ON mod1.ACT_ACCOUNT_CD = core.ACT_ACCOUNT_CD AND mod1.ACT_BRANCH_CD = core.ACT_BRANCH_CD AND mod1.ACT_BUS_CD = core.ACT_BUS_CD AND core.SEC_CUST_REF_NUM = mod1.ALLOC_ORIG_ALLOC_REF_DERV"
        }

Need to create a custom analyzer which will able to search on “ACT_BRANCH_CD” and it should be able to ignore all the alias prefixes when searching and returning the full query node text. Our main task is to handle the aliases, try to ‘get rid’ of them so the string can be searched. I have pasted sample data also, any guidance or help will be appreciable. Thank you in advance.