Laszlo K.

Mapped and documented a complex SQL Server environment of nearly 200 SQL Agent jobs, SSIS packages and over 3,000 views, procedures and functions across 25 databases, making dependencies searchable ahead of planned migrations.

Prepared the switch to a new ERP data warehouse by tracing the 196 database objects and 16 jobs that still named the old one, then retiring obsolete processes and building verified replacements to keep data loads and reporting running through the cutover.

Laid the groundwork for a safe upgrade from SQL Server 2016 to 2019 with a register of over 180 upgrade and migration risks, covering deprecated drivers, legacy SSIS tasks, server settings and outdated T-SQL, so that each can be fixed before the move.

Created interactive websites and web-based data entry systems using Classic ASP, ASP.NET, VB Script, MS SQL, and MySQL to enable dynamic content management and support various data entry requirements;

Developed interactive websites leveraging Classic ASP (VB Script) with MS Access and MS SQL databases to facilitate diverse article and data entry workflows;

Implemented JavaScript functions to enhance data entry and query interfaces, ensuring they were fast, intuitive, and error-free;

Designed and deployed complex relational databases to manage and query large-scale information efficiently, improving workflows and data accessibility;

Developed web-based systems to manage and query information on classical music audio recordings, providing effective solutions for data organization and retrieval.