Skip to content
View MarkRobertson67's full-sized avatar
🎯
Focusing
🎯
Focusing

Block or report MarkRobertson67

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don't include any personal information such as legal names or email addresses. Markdown supported. This note will be visible to only you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
MarkRobertson67/README.md

πŸ‘‹ Hi, I'm Mark Robertson πŸ‡ΊπŸ‡ΈπŸ‡¬πŸ‡§

πŸ“Š Data Analyst with a finance background, focused on turning raw data into clear, actionable insights.

πŸ› οΈ I work primarily with SQL, Python, Excel, and Tableau to clean, validate, and analyze datasets, and to communicate results through dashboards and reports that support business decision-making.

πŸ“ˆ Former institutional trader, bringing a quantitative, results-driven approach to data analysis, financial metrics, and stakeholder communication.

🎯 Currently seeking Data Analyst or Business Analyst roles, and open to collaborating on analytics, business intelligence, and finance-focused data projects.


πŸ›  Data & Analytics Tools

β€’ SQL (PostgreSQL, MySQL)
β€’ Python (pandas, numpy, matplotlib, seaborn)
β€’ Tableau, PowerBi (Dashboards & Reporting)
β€’ Excel (PivotTables, VLOOKUP)
β€’ Data Cleaning & Validation

πŸ›  Development Tools

β€’ Jupyter Notebook, Docker
β€’ Git, GitHub, VSCode
β€’ React, Node.js, Express


🌐 My Sites

πŸ“ Portfolio

Mark Robertson Portfolio

Portfolio

Central hub for data analytics projects, dashboards, and full-stack web apps, with resume, contact information, and references available.

Live Site Β |Β  GitHub Repo

πŸ“Š Data Analytics Projects

Sales Lead Funnel Analysis Tableau Dashboard

Sales Lead Funnel Analysis

Analyzed a sales leads dataset to measure funnel conversion rates and identify drop-off points using SQL, validated results in Excel, and built an interactive Tableau dashboard to surface actionable sales insights.

SQL | Tableau | Excel | Data Cleaning | Funnel Analytics



Live Dashboard Β |Β  GitHub Repo
Customer Purchase Behavior Power BI Dashboard

Customer Purchase Behavior Analysis

Cleaned a retail customer dataset using Python (Pandas), analyzed purchasing behavior with SQL, and built a Power BI dashboard exploring revenue patterns, discount usage, and customer segmentation insights.

Python | Pandas | SQL | Power BI | Customer Analytics



Download Dashboard (.pbix) Β |Β  GitHub Repo

πŸ–₯️ Web Apps

Timecards Demo Web App

Timecards Demo β€” Production Web App

Modeled and aggregated payroll time-series data to generate biweekly KPIs and export clean CSV reports for downstream payroll systems.

SQL | PostgreSQL (Neon) | Data Modeling | Aggregations | Reporting



Live App Β |Β  GitHub Repo
City Whisperer Web App

City Whisperer

Ingested and transformed multi-source API data to generate personalized walking tours using AI-generated content and geospatial logic.

SQL | PostgreSQL | OpenAI API | Google Maps API | Data Pipelines



Live App Β |Β  GitHub Repo

πŸ“« How to reach me:

  • Linkedin Badge
  • Gmail Badge

Profiles:

  • Codewars: Codewars Badge
  • Leetcode: Leetcode Badge

πŸŽ“ Education & Awards

  • Advanced Software Engineering Immersive Program, Pursuit.org
    – JavaScript, SQL, APIs, full-stack application development, data-driven projects
  • The Wall Street Quants, Quantitative Finance & Machine Learning (In Progress)
    – Time-series analysis, factor models, backtesting, and statistical arbitrage
  • BS in Marketing, Rutgers, The State University of New Jersey – School of Business
  • BA in Applied Art, University of Hertfordshire, UK

πŸ† Awards

  • Award: Best Storytelling, Pursuit Hackathon (Class of 9.3 & 9.4) β€” accessandlearn.netlify.app

πŸ’Ό Professional Experience

  • Software Developer & Part-Time Driver, We Care Adult Care, Inc.
    June 2023 – Feb 2025

    • Developed and deployed a full-stack timecard application, improving data collection accuracy and operational efficiency.
    • Engineered SQL database and automated dashboards to analyze staff time, payroll, and productivity metrics.
    • Performed data cleaning and visualization to support management decision-making.
  • Founder & Principal, St. Albans Capital, LLC
    Mar 1996 – Dec 2022

    • Analyzed large financial datasets to identify market inefficiencies and optimize trading strategies.
    • Utilized Bloomberg Terminal to analyze market inefficiencies, price discrepancies, and liquidity trends, optimizing trading decisions.
    • Delivered transparent market reports to high-net-worth clients, ensuring trust through strategic insights and clear communication.
  • CEO, Phaz Music Corp. (Best of CES 2015 by Techlicious)
    Jun 2017 – Aug 2018

    • Raised $5 M in seed financing with a CPA-authored offering memorandum.
    • Oversaw product development, finalizing manufacturing in Shenzhen and lithium-battery configuration in Hong Kong.
    • Negotiated distribution and sales-team agreements, forging critical partnerships to bring P2 headphones to market.
  • Managing Member, Investment Club 101, LLC (β€œBlack Box Trading”)
    Feb 2006 – Jul 2012

    • Co-founded a team to build and fund a black-box equity-trading system with a core AI engine.
    • Secured $100 K in seed capital for live beta trading, hosted on Genesis Securities.
    • Launched and managed the beta system, driving early proof-of-concept success.

πŸ›  Languages and Tools :

Power BI

Icons by Icons8 and devicon


🏎️ Off the clock, I’m a Formula 1 fanatic, world traveler, foodie, and movie buff.


Pinned Loading

  1. wcac_timecards_demo_backend wcac_timecards_demo_backend Public

    JavaScript

  2. wcac_timecards_demo_frontend wcac_timecards_demo_frontend Public

    JavaScript

  3. 9-4-capstone-team-6-backend 9-4-capstone-team-6-backend Public

    JavaScript 1

  4. 9-4-capstone-team-6-my-version 9-4-capstone-team-6-my-version Public

    Forked from jRodriguezIV/9-4-capstone-team-6

    This is a forked version of the original capstone project

    JavaScript