Kumar Sanu
Data Analyst | Process Automation Specialist | Expert in Python, VBA, SQL, Selenium, and OpenAI | Driving Cost-Efficiency and Data Accuracy
- Role
- Associate Data Analyst at The Knot Worldwide
- Location
- Gurugram, HR, IN
- LinkedIn followers
- 500 followers
About Kumar Sanu
I’m a Senior Data Analyst passionate about building automated, scalable, and…
Experience
Associate Data Analyst
Jul 2023 — Present · 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.
Education
DIT UNIVERSITY
Master of Business Administration - MBA, Business Analytics
2021 — 2023
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
2015 — 2018
DAV Public School, Cantt. Road, Khagaul, Patna
Matriculation
2011 — 2015
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.