Rahul Bhardwaj

Support commercial marketing analytics for a biopharmaceutical client, consolidating campaign, customer, and channel data into standardized datasets for recurring performance analysis.

• Built and maintained Excel-based data workflows to clean, reconcile, and validate campaign data — reducing manual reporting effort by roughly 25% and improving consistency across weekly and monthly cycles.
• Developed Power BI dashboards tracking reach, engagement, conversion, and channel performance, cutting stakeholder review time on recurring reports by about 30%.
• Run audience and campaign segmentation on engagement and response data to surface higher- and lower-performing segments for sharper targeting.
• Automated portions of recurring Excel and SQL reporting, shortening turnaround on selected deliverables by around 20%.
• Perform quality checks with reconciliation and exception rules, improving reporting accuracy and reducing recurring data discrepancies.

Delivered a summer analytics project on the competitive positioning and pricing of selected technology products to identify opportunities to strengthen product positioning.

• Built a structured comparison framework of competitor specifications, configurations, pricing, promotions, and value propositions across key technology brands.
• Analyzed pricing differences across comparable configurations and how features, warranty, and promotions shaped perceived value.
• Created an Excel-based pricing and competitive-analysis model to compare products across attributes and pinpoint pricing advantage or disadvantage.
• Used Tableau to visualize competitive pricing ranges and positioning, translating a large set of observations into a clear view for marketing discussions.

Supported marketing initiatives for a pharmaceutical client, managing day-to-day digital, email, and CRM campaign activities and execution across multiple channels.

• Managed audience lists, content, creative coordination, and multi-channel launch execution, contributing to a 20–25% increase in overall engagement.
• Built an Excel campaign tracker unifying CTR, CPC, conversion, and channel performance, helping improve campaign ROI by 15%.
• Analyzed lead and conversion drop-off with the analytics team and adjusted targeting, contributing to a 22% lift in lead-to-conversion rates.
• Refined SEO and SEM based on keyword, traffic, and ad-relevance trends, helping grow organic traffic by 30%.
• Ran A/B tests on subject lines, content, and landing pages — increasing CTR by 18% and email open rates by 12%.
• Maintained ~99% accuracy across key metrics by cross-checking external agency paid-media reports against internal data.

Gained hands-on exposure to data-driven marketing within a healthcare-focused business environment, supporting campaign reporting and research.

• Prepared weekly campaign reports summarizing performance trends, audience response, and follow-up opportunities.
• Researched healthcare market trends, competitor activity, and customer preferences to refine messaging, contributing to a 15% increase in engagement.
• Tracked reach, clicks, engagement, and conversion in Excel, helping shorten campaign optimization cycles by 20%.