Utkarsh Jajodia

Business Operations Intern @Sirona

Gurugram, IN

Automation & Dashboards- Worked on automating the Purchase Order (PO) process using Power Automate and Make.com after mapping workflows across teams, improving turnaround time by reducing manual effort- Built interactive dashboards on Looker Studio to track KPIs and enhance data visibility across e-commerce marketplacesConsumer Insights & Feedback- Devised an SOP and implemented qualitative + quantitative data analysis of consumer reviews using tools like Excel and Google Forms, identifying top USPs and improvement areas in product, delivery, and after-sales- Conceptualized a Consumer Excellence Plan grounded in user feedback and behavioral data insights- Performed sentiment analysis on consumer queries to drive insights and work on the product quality and positioningMarketing & Communication- Tired executing an influencer marketing campaign by liaising with agencies and micro-influencers to boost visibility- Used consumer psychology and marketplace review data to craft performance-driven ad copies for Amazon and other platforms- Conducted a comparative marketing study to structure implementation strategy across brandsMarket Research & Strategy- Wrote VBA macros in Excel to scrape competitor pricing data and enable real-time updates for pricing strategy- Carried out detailed U.S. market analysis —mapped competitors, NPD trends, and pricing benchmarks using secondary data and product scansCommunity & Program Management- Strategized a nationwide Campus Ambassador Program aimed at engaging students across India; defined selection criteria, outreach channels, and execution roadmap to drive brand presence through student-led initiatives

St. Xavier's College (Autonomous), Kolkata

Bachelor's degree

The Assam Valley School

Commerce

Indian Institute of Management Rohtak

Integrated Programme in Management (IPM)