What I made is EXACTLY SAME as the tutorial. This is NOT my design.
Link to the Tutorial: https://scribblemesh.artstation.com/store/d5rq/weapon-creation-tutorial-for-video-games
Tools used:
Zbrush for sculpting high poly mesh
Maya for low poly modeling, retopo, uv
Substance Painter for baking and texture
Marmoset Toolbag for render
Total poly count: 6608