Data Analyst Social Media

Pravalika Konyala

*****************@*****.*** / 989-***-****

Professional Summary:

Results-oriented Marketing Data Analyst with 5 years of experience in providing data-driven insights to optimize marketing campaigns, improve customer engagement, and maximize ROI. Adept at leveraging analytical tools like Power BI, Tableau, and SQL to track and analyze campaign performance, tier-based customer insights, and competitive activity. Skilled in collaborating with cross-functional teams, preparing big data, and delivering strategic recommendations. Strong communicator with a passion for continuous learning and improvement.

Professional Experience:

Phoenix Data Systems, USA, MI Jan 2024 - Current

Marketing Data Analyst

Responsibilities

Developed and executed multi-channel marketing campaigns like email, social media, digital, and print to enhance brand awareness and promote broadband services.

Conducted market analysis, trend forecasting, and competitive research to inform marketing strategies.

Provided detailed reports on campaign performance, including benchmarks and recommendations to optimize engagement and conversion.

Presented analytical findings and insights to senior management for strategic decision-making.

Coordinated with local media outlets to manage advertisements and promotional content, ensuring brand consistency.

Assisted in writing product proposals and developing sales collateral for targeted campaigns.

Managed internal newsletters, news releases, and updates to facilitate company-wide communication.

Organized community engagement initiatives to promote brand presence and build local relationships.

Conducted customer surveys to gather feedback and improve marketing strategies.

Ensured timely and budget-conscious execution of promotional activities and advertising schedules.

Analyzed large datasets to derive actionable insights and support data-driven marketing strategies.

Utilized data visualization tools to present campaign performance metrics to stakeholders.

Developed a data-driven attribution model to optimize campaign effectiveness and ROI.

Supported customer tiering initiatives, providing insights that informed targeted marketing strategies.

Built and maintained dashboards to analyze marketing performance and identify high-ROI channels.

Conducted competitive analysis to guide marketing strategy and improve campaign positioning.

Collaborated with sales and marketing to define target audiences, boosting engagement by 15%.

Managed and cleansed audience lists for campaigns and communications.

Ford Motor Company, MI, USA May 2023 - Jan 2024

Marketing Coordinator Intern

Responsibilities

Assisted in the execution of marketing strategies for new product launches.

Utilized Adobe Analytics and Google Analytics for digital performance tracking.

Conducted market research and competitor analysis to support campaign development.

Collaborated with design teams to create engaging promotional materials and social media content.

Assisted in coordinating marketing events and tracked their impact on brand awareness.

Supported the digital marketing team in optimizing content for SEO and online engagement.

Prepared performance reports for leadership, offering actionable insights for campaign improvements.

Engaged in brainstorming sessions to develop innovative marketing concepts and strategies.

Assisted in data reporting and analysis, contributing to insights for marketing and operational strategies.

Worked with marketing teams to streamline data collection processes and improve reporting accuracy.

HSBC, Hyderabad, India, Mar 2019 - Aug 2022

Marketing Data Coordinator

Responsibilities

Developed and implemented targeted marketing campaigns, enhancing brand engagement and customer outreach.

Analyzed market trends and competitive landscapes to inform strategic marketing decisions.

Collaborated with cross-functional teams to develop sales collateral and promotional materials.

Managed internal communication initiatives, including newsletters and corporate announcements.

Conducted post-campaign analyses to measure effectiveness and optimize future initiatives.

Spearheaded digital marketing initiatives, resulting in a 20% increase in online engagement.

Coordinated cross-departmental meetings to align marketing goals with business objectives.

Oversaw the development of customer-focused campaigns, enhancing client retention by 15%.

Analyzed campaign performance to drive optimization and improve targeting accuracy.

Created reports and dashboards using Tableau and Power BI to monitor key marketing metrics.

Contributed to customer segmentation efforts, enhancing campaign personalization.

Conducted competitive research to refine digital marketing strategies.

Utilized CRM tools to segment and analyze customer data, creating personalized marketing strategies.

Managed external vendor relationships to ensure brand consistency across all marketing channels.

Assisted in preparing and segmenting data for marketing campaigns.

Analyzed competitor marketing strategies and provided insights for future campaigns.

Supported the creation of performance reports and dashboards for marketing teams

Professional Skills:

Marketing Channels: social media, Digital Marketing, Print Advertising, Email Campaigns, Event Coordination

Tools & Software: Adobe Creative Cloud, Python, ERP Systems, SAP, Pandas, R, Java, Advanced Excel VB, Web Design, Development, Azure DevOps, Snowflakes, HTML, CRM Systems (Salesforce, Pardot)

Analytical Skills: Market Analysis, Trend Forecasting, Competitive Research, Data-Driven Decision Making, Cost/Benefit Analysis, Impact Analysis, Risk Analysis, SWOT Analysis, GAP Analysis

Communication: Strong written and verbal communication, Interpersonal Skills, Stakeholder Engagement

Project Management: Deadline-driven, Budget Management, Cross-functional Collaboration, Strategic Planning, MS Project, MS Office, MS SharePoint, Lucid Chart, PowerShell, Agile Methodologies, Jira

Digital Analytics Tools: Adobe Analytics, Google Analytics, Tag Managers

Content Creation: Copywriting, Visual Storytelling, Content Strategy Development

Brand Management: Brand Strategy, Positioning, and Consistency

Advertising: PPC Campaigns, Social Media Advertising, Google Ads Management

Customer Insights: Survey Development, Data Interpretation, Customer Segmentation

Stakeholder Management: C-Suite Presentations, Cross-Functional Collaboration

Problem-Solving & Communication: Creative Solutions, Process Automation, Prototyping, Data

Storytelling, Technical Writing, Presentation Skills

Education:

M.Sc. in Information Systems 2024 -Central Michigan University

B. Tech in Electronics & Communication Engineering 2020- Tirumala Engineering College

Certificate:

Lean Six Sigma Green Belt

Google Data Analytics Professional Certificate

Tableau Desktop Specialist

SQL for Data Science (Coursera)

Salesforce Marketing Cloud (Certification)

Six Sigma Black Belt

Agile methodologies

Adobe Creative Cloud Certification

Contact this candidate