Alex Kastigar — Project Portfolio

Alex Kastigar — Project Portfolio

A mix of professional and personal builds – from data and SQL to web and AI projects.

SNHU coursework preview

SNHU BSCS Projects

Selected coursework in SQL, data structures, OpenGL, and security. Clean code, short writeups, and runnable snippets.

SQLC++/OpenGLSecurity View PDF
Data project preview

Substack Data Analysis

Turned raw data into clear visuals for a publishing workflow. Includes cleaned CSVs and charts (NDA-safe sample).

PandasChartsETL View Sample
Traduzyr website preview

Traduzyr.com

Built and optimized a bilingual site for a translation business. Focused on speed, clarity, and lead capture.

WebSEOPerformance Visit Site
Text adventure preview

Haunted Mansion (Text Adventure)

Python game with rooms, items, and simple combat. Emphasis on structure, readability, and testing.

PythonCLITesting GitHub
SQL & BI toolkit preview

SQL & BI Toolkit — Hands-On Familiarity

NDA-safe overview. In past roles I made small SQL queries, minor script edits, and ad-hoc report tweaks to support teams. Comfortable inside SSMS and Tableau for basic tasks, documentation, and validating data.

SSMSTableauAd-hoc SQL Ask for overview
AI notes preview

AI Notes & Light Automations

Dipped my toes into practical AI: drafting docs, summarizing tickets, and brainstorming troubleshooting steps. No proprietary work shown here – happy to talk through general approaches and what I learned.

AIDocsSummaries Ask for overview

Experience Highlights (details on request)

  • Verizon – SQL reporting support, UAT, customer experience (award-winning)
  • Focus LCDs – SAP B1, vendor coordination, documentation
  • Sales – Verizon, Vivint
  • Security & Hospitality – Alpine Academy (overnight), evo Hotel
  • Retail & Food — Safeway, In-N-Out, Subway

Learning in Progress

  • BS, Computer Science — Southern New Hampshire University (in progress)
  • Continuing to add SNHU course projects and public samples here

Toolbox (selected)

Operating Systems
Windows XP/Vista/7/10/11 macOS Ventura/Sonoma Ubuntu iOS Android
Office & Collaboration
WordExcelPowerPoint OneNoteOutlookAccess Google DocsSheetsSlides DriveAdmin Console GmailExchange OnlineApple Mail SlackTeamsZoom MeetDiscordWebexJabber EvernoteAnyDeskTeamViewer 15RustDesk
Development
PythonJavaScriptJava C++CSwift PowerShellBash GitGitHubGitLab Visual StudioPyCharm Android StudioXcode FileZillaNotepad++Eclipse
Data • SQL • BI
SQL Server (SSMS)MySQL SQLiteMongoDBSAP HANA Tableau Desktop/ServerPower BIQlik Sense
ERP • Finance • Business
SAP Business OneSAP S/4HANA QuickBooks OnlineStripe ZendeskMailchimp
Web & Sites
WordPressShopify WixSquarespaceGoogle Sites CloudflareAWS
Creative & Media
PhotoshopGIMP DaVinci ResolveFinal Cut Pro AudacityOBS StudioHandBrake LucidchartVLCNVIDIA BroadcastiTunes
Browsers & Utilities
ChromeEdgeFirefox SafariBraveOperaChromium LastPass7-ZipApple Shortcuts Google Earth