Alokmani Tripathi

In my role as a Data Analyst at CollegeDekho.com, I utilize data-driven insights to support strategic business decisions and enhance operational efficiency. My key responsibilities include: Data Analysis and Reporting: Extract, analyze, and interpret large datasets using SQL and Advanced Excel to deliver actionable insights on business performance, user behavior, and website traffic. Dashboard Development: Create dynamic, visually appealing dashboards using tools like Google Analytics, Looker Studio, and Google Sheets to monitor key metrics, track progress, and share insights with stakeholders. Review Campaign Analysis : Dashboard to track the review campaign, Sentiments Analysis. Data Cleaning and Transformation: Ensure high data quality by cleaning and preprocessing raw data, enabling accurate analysis and decision-making. Process Automation: Streamline reporting processes by developing automated workflows, reducing manual effort and enhancing efficiency.

Key Contributions: Spearheaded the analysis and optimization of an Email Marketing Campaign to boost customer engagement and drive conversions. Responsibilities: Processed and cleaned raw data using SQL, ensuring data quality for precise insights and actionable recommendations. Analyzed email marketing platform data to monitor and evaluate key performance metrics, including open rates, click-through rates (CTR), bounce rates, and conversion rates. Conducted segmentation analysis to better understand student requirements based on educational background and prior performance. Achievements: Optimized email creatives, leading to a 15% increase in engagement rates. Reduced bounce rates by 8% by identifying and removing inactive or invalid email addresses from the mailing list. This impactful project enhanced campaign efficiency and contributed to better-targeted marketing efforts.

1 UPSC mains | 1 UPPCS mains | Economics | Business | Govt. Policies