Jan 2024 - Present

Tech Mahindra Services, Hyderabad – Data Analyst – Data Analyst

·         Evaluated marketing campaign performance by analyzing customer engagement metrics and calculating ROI to inform strategic decisions.

·         Collected and unified data from CRM and email marketing platforms, ensuring accuracy and consistency for in-depth analysis.

·         Processed and transformed raw data from multiple sources using SQL and Power Query, preparing it for actionable insights.

·         Designed and implemented a Power BI dashboard to visualize key metrics, including click-through rates, conversion rates, and cost per lead, with data segmented by campaign, demographics, and time.

·         Applied advanced DAX calculations to derive engagement metrics, uncovering patterns in customer behavior and campaign effectiveness.

·         Provided data-driven insights to marketing teams, optimizing budget allocation strategies and achieving a 20% increase in ROI.

 

 

Jun 2022 – Jan 2024

Innominds SW Pvt. Ltd., Hyderabad - Data Analyst

·         Developed a predictive churn model and interactive dashboard, enabling proactive identification and mitigation of subscriber attrition.

·         Integrated and cleaned multi-source datasets (CRM, billing, and usage) to uncover churn drivers, including usage patterns, payment habits, and service complaints, using tools like SQL and Power Query.

·         Engineered advanced DAX measures to calculate churn probability scores, segmenting customers into high, medium, and low-risk categories for targeted interventions.

·         Designed and delivered a dynamic dashboard with actionable insights, showcasing churn trends, customer demographics, and usage behaviors to support data-driven decision-making.

·         Achieved a 10% reduction in churn rate by driving retention strategies tailored to at-risk customer segments, enhancing overall customer satisfaction and loyalty.