Shantanu Razdan

Dashboard Development & Analytics for Upcoming Product Launch:

• Led the design and implementation of comprehensive mega and mini dashboards for a yet-to-be-launched product, ensuring robust monitoring and analytics frameworks from the ground up.
• Created headline metrics dashboards to track critical KPIs, including user acquisition, engagement, retention, and monetization, preparing for seamless product launch monitoring.
• Developed deep-driven metric dashboards to capture detailed insights into user behavior, feature performance, and overall product health.
• Collaborated with product, engineering, and business teams to align metrics with strategic objectives and optimize analytics infrastructure.
• Utilized tools such as SQL and visualization platforms to build interactive, insightful dashboards.

Event Instrumentation & Behavioral Analytics for Upcoming Product:

• Orchestrated a robust event tracking framework to comprehensively capture user interactions across the yet-to-be-launched product, ensuring seamless integration from day one.
• Defined and implemented precise event schemas, recording a wide range of user actions, along with contextual parameters and user attributes, to enable in-depth behavioral analysis.
• Instrumented events across all product features, capturing user journeys, engagement triggers, and interaction points, to facilitate accurate funnel mapping.
• Collaborated closely with product and engineering teams to align event instrumentation with business objectives and feature requirements.
• Built event-driven dashboards to visualize user paths, identify friction points, and enhance product usability through data-backed recommendations.

Database Structuring, Tool Integration & Product Testing:

• Played a key role in structuring databases to support seamless data ingestion, storage, and retrieval for the upcoming app product.
• Set up Metabase for intuitive, self-serve analytics, enabling teams to visualize, explore, and share insights from the structured data effectively.
• Conducted extensive testing of the app, identifying bugs, monitoring performance, and collaborating with engineering teams to refine the product from scratch.
• Continuously iterated on feedback from testing to enhance usability, feature performance, and overall product stability before launch.

• Automated Real-Time Insights: Developed and implemented robust data pipelines and frameworks, providing marketing teams with real-time insights to optimize campaigns, and drive strategic decision-making.
• Dynamic Pricing for Koo Coins: Led the creation of a comprehensive pricing strategy for the Koo Coins program, leveraging market research and user behavior analysis to enhance revenue and user engagement.
• Network Health & User Experience: Established proactive monitoring systems to ensure platform stability and reliability, maintaining a seamless user experience crucial for brand loyalty
• Enhanced Feed Performance: Implemented metrics to assess and improve feed effectiveness, directly contributing to higher user engagement and retention through targeted content strategies.
• Efficient Voucher Deployment: Streamlined the deployment and activation of vouchers, ensuring a smooth process that enhances user satisfaction and supports marketing promotions.
• Strategic Data Analysis: Conducted data scraping and analysis using Python and SQL to extract valuable user insights, informing marketing strategies, and growth initiatives.
• User Behavior Analytics: Monitored and analyzed user interactions, providing actionable insights for feature improvements and marketing campaign effectiveness.
• Undertook comprehensive project management duties, ensuring timely delivery of project objectives.
• Provided technical support for existing reports, dashboards or other tools.
• Created and designed business intelligence databases, spreadsheets or outputs.
• Developed reports using SQL queries to track progress against key performance indicators.
• Facilitated brainstorming sessions with cross-functional teams for problem solving activities.
• Gathered and organized data to analyze current industry trends.