Data | Business | Financial Analyst

Michael John

About Me

michael@trailblazeanalytics.com

Experienced analyst, data visualization specialist, and strategic problem solver.

I’m passionate about transforming raw data into clear and actionable insights that deliver real-world business value.

I am a resourceful, inquisitive, and driven problem-solver, specializing in using tools like Excel, MySQL, Power BI, and Python to help businesses unlock the power of their data.

Work Experience

FEB 2023 - Present

DATA ANALYST, NOORVIDA (Formerly known as workspacebooster), VIRGINIA, CHESAPAKE

Financial Data Analysis

  • Utilized Excel and Power BI to analyze financial data.
  • Track key performance indicators (KPIs).
  • Generate actionable insights that supported business decisions.

Marketing Campaign Analysis

  • Employed SQL to analyze the financial performance of marketing campaigns, leading to a 30% improvement in return on investment.

Sales Data Analysis

  • Conducted in-depth sales data analysis using SQL, Excel, and Power BI to identify trends and opportunities.
  • Developed actionable insights that informed marketing strategies.
  • Implemented recommendations, resulting in a 50% increase in sales.

Website Optimization

  • Managed website measurement, reporting, and optimization for workspaceboosters.com, enhancing user experience and engagement.

JAN 2024 - Present

Student Business Intelligence Path Maven Analytics

Data Analysis & Visualization

  • Analyzed datasets to uncover patterns and trends using Excel, Python (Pandas), and R.
  • Created compelling visualizations with Tableau, Power BI, and Excel to present data insights.

Technical Skills Development

  • Executed SQL queries for data extraction and manipulation using MySQL.
  • Applied programming skills in Python for advanced data analysis and machine learning.

Project Management

  • Led and collaborated on capstone projects, simulating real-world data analytics tasks.
  • Utilized MavenAnalytics for version control and project collaboration.

Data Collection & Cleaning

  • Sourced data from APIs and databases, and performed data cleaning using Power Query in Excel and Power BI.

Business Intelligence

  • Tracked and analyzed KPIs to support business decisions; created interactive dashboards with Tableau and Power BI.

Ethics & Compliance

  • Studied data ethics and compliance standards, ensuring responsible data usage and adherence to regulations like GDPR.

Continuous Learning & Networking

  • Attended workshops and webinars to stay updated on industry trends.
  • Built a professional network through LinkedIn and industry events.

Soft Skills Development

  • Enhanced communication skills by presenting data insights to non-technical stakeholders.
  • Developed critical thinking through analytical exercises and case studies.

Feedback & Improvement

    • Participated in peer review sessions to provide and receive constructive feedback.
    • Regularly assessed personal progress and set goals for continuous improvement.

JAN 2020 - SEPT 2022

Web Designer, VIV DIGITAL MEDIA LLC

Web Design

  • Designed and built corporate, business, e-commerce websites, and blogs using data analysis to inform design decisions and improve user experience.

Technical Data Integration

  • Utilized HTML, CSS, and JavaScript to integrate and manage data-driven features on websites, ensuring seamless data flow and functionality.

Data Visualization

  • Created graphics and visual assets using Adobe Photoshop and built websites using Divi Builder to effectively communicate data insights and enhance website aesthetics.

Email Marketing Analytics

  • Developed and analyzed email marketing campaigns, sales funnels, and landing pages to track performance metrics and optimize conversion rates.

Comprehensive Data Services

  • Provided clients with initial website setup services, including domain registration, hosting setup, business emails, and site security (SSL), ensuring all systems were optimized for data integrity and security.

Ongoing Data Maintenance

  • Offered website troubleshooting and maintenance services, using data monitoring tools to identify and resolve issues, ensuring continuous performance and reliability.

Certifications

Excel Specialist

Power BI Specialist

MYSQL Data Analysis

Advanced Excel Dashboard Excel

Power Query, Power Pivot & DAX

Statistics for Data Analysis

Projects

Adventure Works Dashboard

Explore Adventure Works’ global performance

The Evolution of the Music Industry

Visualizing the impact of the iTunes launch in 2003 on digital music sales

Maven Toys Store

Harnessing Insights to Propel Growth and Optimize Inventory

Hotel Booking Optimization

Turning a $1million loss from cancellations into additional revenue

Skills

Analytical Skills

    • Statistical Analysis
    • Data Cleaning
    • Data Visualization
    • Predictive Modelling
    • Hypothesis Testing

Software Proficiency

  • Excel: Advanced functions, pivot tables, data analysis toolpak
  • SQL: Database querying, data manipulation
  • Tableau: Data visualization, dashboard creation
  • Power BI: Data visualization, interactive reports

    Communication

    • Report Writing
    • Presentation Skills
    • Data Storytelling
    • Stakeholder Management
    • Collaboration

    Products I’ve Worked With

    canva
    ChatGpt

    Education

    2010 - 2015

    Bachelor of Technology (B.Tech) - Orthotist/Prosthetist

    Federal University of Technology Owerri Nigeria

    Graduated Top 5% with Second Class Honours, upper division (3.8 CGPA out of 5.0)

    Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
    Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
    Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.

    Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.
    Your content goes here. Edit or remove this text inline or in the module Content settings. You can also style every aspect of this content in the module Design settings and even apply custom CSS to this text in the module Advanced settings.