Thank you for all the replies.
Background info:
The wire/connector is a part of LED product we purchased.
From this photo
Lets call the wire from left a header cable (upper cable) - It is an open end for you to solder to anywhere
Lets call the wire from right a housing cable (lower cable) - It goes the LED light
Since we want to hook this LED to a circuit board, we will dump the header cable entirely and connect LED light to PCB. We are checking if there is a thru-hole or SMT version of similar header that we can use on the circuit board. Thus asking for anyone familiar with this connector for make and part number.
Team BTF