•Gathered, collated, and analyzed customer data’s and needs to identify and present solutions and provided technical expertise and support on products to clients.•Conducted and collated SDI data’s (Silt Density Index Test- Pall) on manufacturing-based clients to test their water purification according to the OEM’s specification (PALL) and visualized the company’s results using MS Excel and Power BI.•Spearheaded various projects by utilizing data for determining project success using MS Excel.•Demonstrated in-depth technical knowledge about products, their functionality, and pros and cons and sent technical specification to potential buyers along with sales quotes.