Reporting
My professional work has included building reports with:
- SQL Server Reporting Services and Microsoft Report Viewer
- Excel PowerPivot and SQL Server Analysis Services tabular models
- EPPlus for generating and parsing Excel spreadsheets from .NET applications
- Tabular Editor 3 for building semantic models in Power BI/Fabric
Scripting
My personal and professional work has included scripting with Python, Typescript/JavaScript, and PowerShell for:
- searching, importing, and working with XML and JSON files
- automating build and deploy processes
- a Discord bot and Twitch webhook handler
- Examples:
- WordPress database importer: .NET library for writing posts directly to a WordPress database
- BeeHiiv CSV reader: .NET library for parsing a CSV export form BeeHiiv into distinct blocks
- “LinqPad Cookbook” panel scripts: Sample scripts that demonstrate things that are easier to prototype in an interactive environment, such as testing models, filtering XML files, exporting to Excel, and exporting XSDs to a more readable format.
- 5e SQL tools: LinqPad tools for parsing various fifth edition data sources (D&D and others) into SQL Server so I could write queries against it
- sudoku solver script