Charles John

Charles John

Followers of Charles John990 followers
location of Charles JohnBrisbane City, Queensland, Australia

Connect with Charles John to Send Message

Connect

Connect with Charles John to Send Message

Connect
  • Timeline

  • About me

    Data & Insights Analyst | Digital Marketing | eCommerce | Campaign Optimisation | SEO | SQL | Power BI | Tableau | I help companies improve Marketing ROI through data-driven strategies

  • Education

    • Mahatma Gandhi University

      2004 - 2008
      B.Tech Mechanical Engineering
  • Experience

    • Webnesters Online Solutions Pvt.Ltd

      Jan 2011 - Jul 2018

      - Conducted website auditing and competitor analysis for SEO campaigns.- Developed and implemented SEO strategies. Key Responsibilities:-Set budget, scope & timeline of web development projects.-Assign tasks & deadlines for team members.-Conduct weekly team review meetings.-Technical liaison with clients & relationship building.-Manage domain purchases, website transfers, renewals & client payments.Achievements:-Delivered all web development projects on time.-Effectively solved many complex client challenges.

      • Search Engine Optimization Executive

        Jan 2016 - Jul 2018
      • Project Manager/Co-Founder

        Jan 2011 - Dec 2015
    • ECommerce Dropshipping

      Apr 2018 - Jun 2020
      Digital Marketer/Co-Founder

      This was an ecommerce business selling pet products in the UK market.๐€๐œ๐ก๐ข๐ž๐ฏ๐ž๐ฆ๐ž๐ง๐ญ๐ฌ:โ— Scaled the eCommerce business from 0 ๐ญ๐จ ๐†๐๐9,000 ๐ข๐ง ๐ฆ๐จ๐ง๐ญ๐ก๐ฅ๐ฒ ๐ซ๐ž๐ฏ๐ž๐ง๐ฎ๐ž ๐ข๐ง ๐ญ๐ฐ๐จ ๐ฒ๐ž๐š๐ซ๐ฌ by leveraging data-driven SEO strategies and targeted Facebook ad campaigns.โ— Identified 8 high-converting products through performance analysis and built focused ad campaigns, resulting in increased conversions and more efficient ad spending.โ— Conducted conversion rate optimisation by testing various UX layouts, analysing results, and implementing changes to enhance user experience and ๐๐ซ๐ข๐ฏ๐ž 5% ๐ฆ๐จ๐ซ๐ž ๐ฌ๐š๐ฅ๐ž๐ฌ. Show less

    • Intellyze Labs

      Aug 2020 - Apr 2023
      Digital Marketing Specialist

      Intellyze labs is a digital marketing agency that focuses on promoting small and medium business online. ๐€๐œ๐ก๐ข๐ž๐ฏ๐ž๐ฆ๐ž๐ง๐ญ๐ฌ: โ— Conducted A/B testing analysis on Facebook ads for an eCommerce company, identifying the most effective ad types for driving sales. Optimised campaigns based on these insights. This resulted in improving ๐จ๐ง๐ฅ๐ข๐ง๐ž ๐ฌ๐š๐ฅ๐ž๐ฌ ๐›๐ฒ 14% ๐ฐ๐ข๐ญ๐ก๐ข๐ง 3-๐ฆ๐จ๐ง๐ญ๐ก๐ฌ.โ— Modified the target audience of a Facebook marketing campaign, backed by data analysis of audience demographics, resulting in a 27% ๐ข๐ง๐œ๐ซ๐ž๐š๐ฌ๐ž ๐ข๐ง '๐‹๐ข๐ค๐ž๐ฌ' ๐จ๐ฏ๐ž๐ซ ๐š 3-๐ฆ๐จ๐ง๐ญ๐ก ๐ฉ๐ž๐ซ๐ข๐จ๐.โ— Created dashboards in Google Looker Studio to visualize data from Digital Marketing campaigns improving transparency and tactical decision making.โ— Held meetings with stakeholders to discuss insights, gathered feedback, and continuously refined marketing campaigns for better performance based on data-driven recommendations. Show less

    • The Data Analytics Institute

      Sept 2024 - Jan 2025
      Jr. Growth Analyst

      ๐‘๐ž๐ฌ๐ฉ๐จ๐ง๐ฌ๐ข๐›๐ข๐ฅ๐ข๐ญ๐ข๐ž๐ฌ:โ— Collect, clean, transform, integrate, and validate data from various social media platforms and analytic tools to ensure accuracy and consistency for insightful analysis.โ— Analyse social media data to uncover the type of content that works better, the audience demographic to target, and the time and day to publish posts thus identifying opportunities to increase reach and followers๐€๐œ๐ก๐ข๐ž๐ฏ๐ž๐ฆ๐ž๐ง๐ญ๐ฌ:โ— ๐ƒ๐ž๐ฏ๐ž๐ฅ๐จ๐ฉ๐ž๐ ๐š ๐๐จ๐ฐ๐ž๐ซ ๐๐ˆ ๐๐š๐ฌ๐ก๐›๐จ๐š๐ซ๐ that pinpointed the most effective content types, optimal post timings, and target audience based on data from the companyโ€™s social media channels. These insights are projected to boost ๐ฉ๐š๐ ๐ž ๐ข๐ฆ๐ฉ๐ซ๐ž๐ฌ๐ฌ๐ข๐จ๐ง๐ฌ ๐›๐ฒ ๐จ๐ฏ๐ž๐ซ 20%.โ— ๐”๐ง๐œ๐จ๐ฏ๐ž๐ซ๐ž๐ ๐ญ๐ก๐ž ๐๐ž๐ฆ๐จ๐ ๐ซ๐š๐ฉ๐ก๐ข๐œ๐ฌ ๐จ๐Ÿ ๐š๐ฎ๐๐ข๐ž๐ง๐œ๐ž๐ฌ with the highest likelihood of conversion to customers.โ— Led meetings with stakeholders and senior data analysts to present insights and recommendations, gathered feedback, and refined the analysis based on their input to ensure alignment with business goals and improve decision-making.๐“๐จ๐จ๐ฅ๐ฌ:โ— Power BI, DAX, Power Query, SQL, BigQuery, MS Excel Show less

    • Foot Locker

      Jan 2025 - now
      Digital Insights Analyst
  • Licenses & Certifications

    • Certified Data Analyst

      The Data Analytics Institute
      Sept 2024
    • Google Data Analytics

      Google
      Dec 2023
      View certificate certificate
    • Google Analytics Certification (GA4)

      Google Digital Academy (Skillshop)
      Aug 2023
      View certificate certificate