/projects/eventparser
| Stack | Windows Forms · C# · SQL Server · CSVHelper |
| Source | github.com/iscmt/event-parser |
background
I developed EventParser during a five-week internship at Guyana's Ministry of Finance. Before this tool, it was a manual spreadsheet-driven process where Excel would hang for days processing thousands of records organization-wide.
I learned C# and SQL on the job to build a CLI utility that processes Windows Event Logs for security events, parses them, and imports them into an MS SQL database. Also authored technical documentation and an SOP manual.
Achieved a reduction in processing time from approximately 10 minutes to 15 seconds. Proactively developed a GUI version for analysts to improve usability.
what i learned
- First exposure to Git and version control
- Pre-LLM days — spent hours going through 2005-era forums on wrong approaches
- The art of Googling
- Bootcamp on macOS is surprisingly performant
technical details
- AddMissingHeader — Fixes missing column headers in exported CSV files using regex
- ParseLog — Uses CSVHelper to read and extract values from log files
- ImportToMSSQL — Bulk inserts parsed data via stored procedure