Judicial Alternatives of GeorgiaSoftware Developer
Jul. 2022 - Nov. 2024Columbus, Georgia, United StatesDesigned, tested, optimized, and implemented new stored procedures, functions, triggers, data pipelines, and cursors, resulting in a significant reduction in processing time and overall cost savings of 8% of overall budget expenses.
Fostered and supported strong relationships with software clients, SMEs, and product owners, ensuring exceptional levels of client satisfaction and loyalty, ultimately retaining monthly revenues of 35 private and government clients over four states.
Created comprehensive technical, system design, quality control and SOP/ Knowledge base documents, As well as SSRS and GrapeCity Active Reports.
Responsible for importing, cleaning and implementing data streams (ETL via SSIS) of external vendors, including legacy government systems, ensuring seamless data integration with SQL.
Published an electronic reporting system based on .NET Framework and C#, hosted on an azure web app that increased the total number of cases any one officer could handle by 20-50 Cases, resulting in a 25% increase in officer productivity.
Established and executed complex queries and ad hoc reports independently by translating business requests into actionable data insights.
Research and implement new frameworks, tools, and third-party applications to improve overall efficiency. Developed API endpoints for easy access to internal data by vender's and software clients.
Team Lead responsible for modernizing legacy Jag Probation systems, developed as early as 2000, using SQL, JavaScript, ASP.Net, and C# resulting in 70% fewer trouble tickets.