Kumar Sanu

Associate Data Analyst @The Knot Worldwide

Gurugram, IN

As a versatile Data Analyst, I specialize in utilizing advanced tools such as Excel, VBA, Selenium, SQL, Python, and OpenAI to optimize workflows, reduce costs, and enhance data accuracy. With a strong focus on automation and process improvement, my work spans from developing custom solutions to managing large-scale data validation and deduplication efforts. Key achievements include- Cost Reduction: Developed a Python script for phone and email validation, saving and ensuring precise contact details for business outreach- Process Optimization: Leveraged advanced Excel and VBA to create dynamic queries and reports for Bi-Bot account searches, reducing Average Handling Time (AHT) for the Enrichment team by one minute- Advanced Data Queries: Built efficient SQL and Metabase queries to improve data analysis across teams, including the \"All Vendor\" and \"No Login\" queries, alongside custom solutions for the Ireland team- Web Scraping & Automation: Utilized Selenium and Python to automate web scraping, extracting data from UK and international websites for vendor ID creation, significantly streamlining data processing workflows- Contact Validation: Developed a Python-based system for validating 200K contacts, including 63K emails for \"The BASH\" process, while managing semi-annual validation for US vendors to ensure accuracy- AI Integration: Applied OpenAI in Python to extract vendor websites from social media accounts, delivering innovative solutions to enhance data completeness and enrichment- Deduplication Tools: Created and implemented a deduplication tool that reduced duplicate vendor entries from 42% to 14% in just four months, greatly improving international vendor management efficiency- Custom In-House Tools: Developed in-house tools for web scraping using Python to extract critical vendor information from Google Maps, enabling informed decision-making and process automation.

DIT UNIVERSITY

Master of Business Administration - MBA, Business Analytics

Sant Longowal Institute of Engineering and Technology

Bachelor of Engineering - BE, Chemical Engineering

Sant Longowal Institute of Engineering and Technology

B.Tech in Chemical Engg.

DIT UNIVERSITY

MBA in Data Analytics & Finance

Sant Longowal Institute of Engineering and Technology

Diploma of Education, Chemical Engineering Technology/Technician

DAV Public School, Cantt. Road, Khagaul, Patna

Matriculation