Nirmal Arora

Experience

1. Senior Analyst

   Merkle

   Aug 2024 — Present · Gurugram, IN

   Built and deployed an LLM-integrated Slackbot using Google Gemini 2.0 Flash, enabling ~300 team members to instantly get answers to ad-hoc business queries. This automation significantly reduced manual effort and saved hours of analysis time weeklyLeveraged NLP (BERT) and clustering to identify semantically similar internal search terms that produced inconsistent website experiences. This insight led to targeted fixes and resulted in a 1.2% increase in conversion rate and improved customer experiencePerformed forecasting of conversion rate trends using SARIMAX and Facebook Prophet, enabling proactive decision-making and better planning for seasonal traffic spikesDesigned and maintained dashboards for Search Insights, enabling cross-functional teams to track performance and customer behavior across search touchpointsPerformed deep-dive analyses on internal search performance and new feature rollouts, uncovering optimization opportunities and influencing product decisionsOptimized SQL workflows and Analytical Base Layer procedures, reducing execution time by up to 50% and improving data availability for downstream teams

Education

• National Institute of Technology Surat

  Bachelor's degree, Mechanical Engineering

  2015 — 2019