Skip to content
View sycstitch's full-sized avatar

Block or report sycstitch

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
sycstitch/README.md

Hi there, I'm Lauren 👋

LinkedIn Email

I started out as a Linguistics major, mostly because I'm a fan of the wonderfully messy ways people communicate - pidgins, creoles, all the 'dirty' languages that break the rules.

Turns out, that love for finding patterns in chaos is perfect for the tech world. Deconstructing a creole language isn't all that different from parsing unstructured web data or cleaning a chaotic dataset. Both have their own weird syntax, and both are incredibly satisfying to figure out. I’m a data person at heart, but with a healthy dose of cybersecurity paranoia.

  • 🔭 What I'm focused on: Finding a full-time role in Data Analysis or Data Engineering where I can tackle complex, messy data. I'm also interested in security analytics roles that merge both of my passions.
  • 💬 Ask me about: Why data cleaning is 80% of the work and 100% of the fun, how to build a web scraper from a simple debugging session, or my latest database project.

🧰 My Tech Toolbox

Here's a look at the tech I work with regularly.

Category Technologies
Data & Analytics Python (Pandas, NumPy) SQL (MySQL, PostgreSQL) Excel Tableau Web Scraping (BeautifulSoup) ETL
Cybersecurity Splunk Wireshark SIEM Threat Intelligence (MISP) Digital Forensics (Autopsy, Volatility) Incident Response
Languages & Systems Bash PowerShell Linux (Debian) Windows Server Active Directory VMware Git
Web & APIs PHP JavaScript HTML5/CSS3 RESTful APIs PDO

⭐ Featured Projects

These are a few of my favorite projects. They're pinned below, but here's the story behind them.

  1. TrueCar Web Scraper: It all started when my mom asked for help with a text extract error. That simple debugging session somehow spiraled into this - a full-blown web scraper to pull market data. It was the first time I tackled a problem I knew nothing about from start to finish and won. Made me think, "damn, maybe I am more capable than I thought."
  2. La Liga Management System: A high-stakes clash of titans, not just on the pitch, but in the database. This project involved building a secure management system from the ground up while running dramatic salary analytics - pitting Real Madrid's entire payroll against Barcelona's average in a battle of nested SQL subqueries.
  3. Fleet SQL Analytics: My deep-dive into a simulated taxi company's database to figure out why things were so inefficient. I used everything from basic queries to advanced window functions to discover that only 45% of certified drivers were actually driving. An operational nightmare, but a fantastic data puzzle.
  4. (Comin Soon) BTL1 Incident Response Write-Up: I'm under an NDA, so I can't share the gory details of the incident. This write-up instead focuses on the emotional rollercoaster that was the exam: the 14 hours I spent fighting the mental roadblocks, the immense pressure I put myself under, and how letting go of perfectionism helped me problem solve and ultimately earn the Gold certification.

🏆 Certifications

Take a look at my Credly!

Certification Issuing Organization Notable Achievement
Blue Team Level 1 (BTL1) Gold Security Blue Team Achieved 95% score on the 24-hour practical examination, demonstrating advanced skills in incident data analysis and correlation.

💡 Core Competencies

This is a summary of what I bring to the table, based on my project experience and training.

  • Data Analysis & Business Intelligence

    • Developing advanced SQL queries (Window Functions, CTEs, complex JOINs) for data analysis and business intelligence reporting.
    • Building automated ETL pipelines for web scraping, data cleaning, and validation using Python, Pandas, and BeautifulSoup.
    • Performing statistical analysis to identify trends, optimize processes, and deliver actionable recommendations.
  • Security Analytics & Incident Response

    • Correlating security logs and detecting anomalies with SIEM tools like Splunk.
    • Conducting digital forensics by analyzing disk and memory images to reconstruct incident timelines.
    • Applying threat intelligence frameworks like MITRE ATT&CK for comprehensive threat analysis.
  • Systems & Infrastructure

    • Administering Linux (Debian) and Windows Server environments, including Active Directory and Group Policy management.
    • Automating system tasks and file organization using advanced Bash scripting.
    • Designing and implementing normalized relational database schemas for complex applications.

Popular repositories Loading

  1. taxi-fleet-sql-analytics taxi-fleet-sql-analytics Public

    SQL analytics project simulating taxi fleet operations—from schema design to business insights. Beginner to advanced queries with real conclusions.

  2. truecar-webscraper truecar-webscraper Public

    Web scraper that collects and analyzes car listings from TrueCar. School assignment turned market analysis tool with data cleaning & visualization for car shopping research.

    Jupyter Notebook

  3. la-liga-management-system la-liga-management-system Public

    A comprehensive database-driven web application for managing Spanish football league operations, featuring advanced SQL queries, secure PHP architecture, and La Liga data. Collaborative, cross-cult…

    PHP

  4. bike-sales-excel-dashboard bike-sales-excel-dashboard Public

    Excel Dashboard - pivot tables, slicers, graphs

  5. sycstitch sycstitch Public

  6. Threat-Intelligence-Reports Threat-Intelligence-Reports Public

    Threat Intelligence Reports written by me.