Data Analyst & SEO Specialist

Bhavesh Bellara

Washington DC. (Open to relocation) **************@*****.*** 202-***-**** in/bhavesh-bellara/ SUMMARY

Experienced Data Analyst and SEO Specialist with a strong understanding of both quantitative and qualitative data analysis techniques along with a deep understanding of search engine optimization techniques. Experience in data cleaning, manipulation and visualization using Python, SQL, Tableau, & Power BI. Proven expertise in SEO auditing, keyword research and link building. Proficient in using tools such as Google Analytics, Adobe Analytics, SEMrush and Ahrefs to track website metrics and measure the success of SEO campaigns. Possess extensive knowledge of social media platforms, including Facebook, TikTok, Instagram, Twitter, and LinkedIn. EXPERIENCE

Data Analyst & SEO Specialist

Barefoot Proximity August 2021 – February 2023, Cincinnati, OH

• Devised content strategy for brands by analyzing competitors, identifying opportunities, and creating a social media plan.

• Built interactive dashboards using Tableau and Google Data Studio to present insights and actionable recommendations to clients, resulting in a 25% improvement in operational efficiency.

• Used Python to create a content scoring algorithm that determined the effectiveness of the content by analyzing various factors such as keywords, reading level, scroll-depth, social shares, etc.

• Conducted audience analytics using various analytics tools and techniques such as Google Analytics, Infegy, Adobe Analytics, and SEMrush to uncover user behavioral insights and trends, enhancing the user experience & improving audience engagement.

• Led a team of analysts to streamline reporting processes, resulting in a 40% reduction in report generation time.

• Performed data analysis for clients using SQL and Python to extract, clean, and transform data from various sources to identify trends and patterns, resulting in actionable insights for business stakeholders.

• Developed a comprehensive SEO strategy with comprehensive keyword research, link-building campaigns, & content optimization techniques to boost organic search traffic across website resulting in increase of organic search traffic by 50%.

• Part of '2022 Team of the Year', recognizing exceptional teamwork and contributions to agency and client success. Data Analyst & Social Media Strategist

Credit Swag Ventures – Credit & Debt April 2021 – August 2021, Phoenix, AZ

• Designed & managed social media budgets, resulting in 10% reduction in ad spending while maintaining/exceeding campaign goals.

• Implemented analytics tracking within websites using Google Tag Manager and Google Analytics to measure, track, and report on user engagement within the website, and monitor key performance indicators and user interactions resulting in an improvement of website performance by 30%.

• Collaborated with cross-functional teams including content creators, designers, and community managers to ensure brand consistency and high-quality content.

• Performed competitive analysis to stay up-to-date with industry trends to plan social media strategy and tactics. Data Analyst Summer Intern

Nonprofit PG County July 2020 – August 2020, College Park, MD

• Conducted data analysis using R and created visualizations using Excel and Tableau to identify trends and patterns.

• Assisted in the design and execution of A/B tests to optimize website and marketing campaigns.

• Conducted research for industry trends to continually optimize social media strategies and tactics resulting in an increase in user-engagement by 400%

Teaching Assistant

University of Maryland August 2018 – December 2020, College Park, MD

• Contributed to the design and delivery of technical course materials in Database Modeling, Data & Statistical Analysis, and Data Science at the Master's level.

• Co-led lectures & facilitated group discussions on technical topics of SQL, data science, & machine learning algorithms.

• Collaborated with a team of 7 professors to support the academic success of 500+ students across multiple courses. Demonstrated a strong ability to collaborate and manage a large volume of students in a fast-paced academic environment. Data Analyst

Greencode Technologies July 2017 – July 2018, Mumbai, IN

• Conducted data analysis to identify trends and patterns in sales data, leading to improved forecasting accuracy and increased sales revenue.

• Developed and maintained data pipelines using Python and SQL, ensuring accuracy and completeness of data.

• Created reports and dashboard using Tableau to communicate findings and recommendations to senior leadership.

• Trained and mentored junior analysts on data analysis and visualization tools and techniques, including SQL, Excel, Tableau, and Power BI

Business Analyst

Wonderbiz Technologies June 2016 – July 2017, Mumbai, IN

• Created custom reports using Excel and scripts in Python to automate data cleaning and analysis processes, resulting in a 20% reduction in manual effort.

• Conducted analysis of sales and marketing data using SQL to identify opportunities for revenue growth.

• Developed and maintained dashboards using Power BI to track KPIs and communicate insights to senior leadership PROJECTS

Content Creator & Marketer – YouTube

• Created content for the social media channels which has recorded over 100K views.

• Plan, storyboard, and script videos to ensure a cohesive and compelling narrative.

• Trained and mentored new team members in the use of Adobe Creative Cloud, resulting in overall team productivity.

• SEO – Optimizing content for YouTube using extensive keyword research, analytics, back links, etc.

• Utilized editing software, including Adobe Premiere Pro and After Effects, to edit and refine videos for maximum impact.

• Use Adobe Photoshop and Illustrator to create custom graphics and visuals for videos and social media. Data Analysis and Visualization Expert (Capstone Project) WSSC Water • August 2020 – December 2020

• Performed comprehensive data analysis and utilized Power BI to develop multiple dynamic dashboards for a client, providing them with valuable insights for efficient resource planning and allocation.

• Collected and compiled data from various databases, conducting data cleansing and logical calculations to ensure accuracy and reliability. Developed customized fields to cater to the specific business requirements of the client.

• Implemented live data updating feature to ensure the dashboards remained current and adaptive to new incoming data from the client's data servers.

• Through these efforts, enabled the client to gain a deeper understanding of their data and make informed decisions in their resource planning, resulting in more effective resource allocation and higher ROI. Visual Analysis of Anime Industry

University of Maryland • August 2019 – December 2019

• Conducted thorough data analysis on a comprehensive dataset of 150,000+ records pertaining to the anime industry.

• Leveraged advanced data visualization techniques to identify trends and patterns among the studios producing anime.

• Designed and developed customized visualizations that provided valuable insights into the production trends and patterns of the anime industry, enabling strategists to make data-driven decisions. EDUCATION

Master of Science (MS) in Information Management (MIM) University of Maryland • College Park, MD • 2020

Bachelor of Engineering (BE) in Information Technology (IT) University of Mumbai • Mumbai, India • 2016

CERTIFICATIONS

Google Analytics Certification Data Engineering Essential Power BI Essential Training Google • 2023 LinkedIn Learning • 2023 LinkedIn Learning • 2020 Tableau Essential Training Enterprise Design Thinking Digital Marketing LinkedIn • 2019 IBM • 2019 NIESBUD, India • 2017

SKILLS

Technical: Python, R, Java, MySQL, NoSQL, HTML5, CSS, Spark, Hive, Azure, Shell Scripting, GIS Analytics: Google Analytics, Adobe Analytics, Google Search Console, Hootsuite, YouTube Studio SEO Tools: SEMrush, Ahrefs, Infegy, Screaming Frog, Yoast SEO BI Tools: Tableau, Power BI, Google Data Studio, Looker Other: Excel, MS Office, WordPress, Drupal, Photoshop, Premier Pro, Trello, Adobe Creative Cloud

Contact this candidate