Social Media Marketing Analyst

Prithish R Katipelli

Marketing Analyst

MI (Relocation: Anywhere in US) 616-***-**** ********@*******.*** LinkedIn SUMMARY

Marketing Analyst with 3+ years of experience in healthcare, insurance, and IT services, specializing in data-driven campaign optimization and customer insights. Proficient in SQL, Python, Excel, Tableau, Power BI, and Google Analytics to deliver actionable marketing dashboards and performance analysis. Skilled in SEO/SEM, PPC, social media, email marketing, and A/B testing, driving measurable growth in customer acquisition and retention. Experienced in CRM platforms (Salesforce, HubSpot, Marketo) and marketing automation, enabling targeted campaigns and improved ROI. Known for combining analytical expertise with digital marketing strategies to achieve business growth.

SKILLS

Methodology: SDLC, Agile, Waterfall

Data Analysis: Google Analytics, Adobe Analytics, SQL, Excel (PivotTables, VLOOKUP), Python (Pandas) Visualization Tools: Tableau, Power BI, Google Data Studio Digital Marketing: SEO/SEM, PPC, Social Media Analytics (Meta, LinkedIn), Email Marketing (Mailchimp) Market Research: Competitive Analysis, Customer Segmentation, A/B Testing, Surveys (SurveyMonkey) CRM & Automation: Salesforce, HubSpot, Marketo

Marketing Analytics Tools: Google Tag Manager, R Studio, Snowflake, Microsoft Clarity, Shopify, Sprinklr Other Tools: Figma, Microsoft Clarity, Adobe Creative Studio, Canva, Microsoft Office Suite EDUCATION

Master of Science in Information Systems Management May 2025 Union Commonwealth University, Bourbville, Kentucky Bachelor of Business Administration May 2022

Osmania University, Hyderabad, Telangana

EXPERIENCE

Cigna, MI Nov 2024 - Current Marketing Analyst

• Led customer segmentation analysis using SQL, Python (Pandas), and Tableau to identify high-value policyholders, resulting in a 12% increase in targeted campaign conversion rates.

• Optimized multi-channel marketing campaigns (email, PPC, social) by integrating insights from Google Analytics, Adobe Analytics, and Salesforce, improving ROI by 18%.

• Conducted A/B testing and predictive modeling on digital campaigns, leveraging R Studio and Snowflake to forecast engagement, reducing customer acquisition cost (CAC) by 10%.

• Automated marketing performance dashboards in Power BI and Google Data Studio, providing leadership with real-time visibility into campaign metrics and healthcare customer behaviors.

• Collaborated with cross-functional teams to implement Google Tag Manager and Microsoft Clarity tracking, uncovering key drop- off points in the policy purchase funnel, driving a 15% uplift in conversions.

• Supported compliance-driven campaigns by analyzing HIPAA-sensitive patient engagement data, ensuring data security and regulatory adherence while optimizing outreach strategies. Virtual Infotech Solution, India Jan 2021 - July 2023 Marketing Coordinator

• Developed and executed SEO/SEM strategies that improved website ranking, increasing organic traffic by 40% and boosting lead generation.

• Designed and optimized social media campaigns across LinkedIn and Meta using Sprinklr and Google Analytics, achieving a 35% increase in engagement and stronger brand presence.

• Implemented email marketing automation workflows with HubSpot and Mailchimp, driving a 20% uplift in customer retention through personalized campaign journeys.

• Built Power BI dashboards integrating CRM (Salesforce, HubSpot) and campaign data, enabling leadership to track KPIs like CTR, CAC, and ROI in real time.

• Conducted competitive analysis and customer behavior research using SurveyMonkey and SQL-based data insights, shaping pricing and positioning strategies.

• Coordinated with design teams using Figma, Adobe Creative Studio, and Canva to deliver visually compelling campaign creatives aligned with branding.

• Managed Google Tag Manager and Shopify analytics integration to optimize e-commerce funnel tracking, increasing checkout completion rates by 15%.

CERTIFICATION

Data Analytics Certificate – Union Commonwealth University, USA (2024) SQL for Data Analysis – LinkedIn

Data Cleaning in Python Essential Training - LinkedIn

Contact this candidate