* Maintained and developed SQL-driven solutions for student health and wellness benefits data. Created tables to model student data, wrote stored procedures and views to extract, transform, and load data (ETL). Developed logic for features to maintain accurate information on student benefits enrollments according to school requirements and synchronize updates with third party vendors. Optimized slow-running queries to improve performance significantly.* Worked with .NET Core to push and pull JSON data from third party RESTful apis, using C# and Visual Studio development tools.* Engaged in debugging and analytic tasks to support internal customers relying on IT applications. Wrote backend stored procedures to support SSRS reporting for internal customers.* Assisted as needed with maintenance of legacy applications to support staff and students at JHU.* Created documentation for projects in Jira confluence.* Participated in daily agile scrum standups and used Jira and Bitbucket to track features and implement Git source control. Familiar with advanced git concepts and branching strategies.

Senior developer working on application development using C#/NET, Blazor, ASP.Net, and SQL Server.* Full stack developer working on Blazor web and traditional desktop application for Manufacturing Execution System software. Developed new features working on all aspects of software development from database layer to business logic and UI.* Responsible for implementation of features such as background services to process document storage queues and email tasks, adding retry functionality and templating to existing email queue application code, automating creation of dose documentation on processed products, allowing customers to enter inbound shipment data for faster receiving and more accurate scheduling, and search features for customer facing document retrieval.* Refactored stored procedures to solve timeout and lag issues, in many cases improving stored procedures dramatically with 10x or 100x better performance. Used SQL Server query plans and monitoring tools to find, analyze and refactor slow queries.* Assisted in upgrading code from .Net 4.5 to .Net 4.8 and from .Net Framework to .Net Core. Organized shared code into .Net Standard libraries to promote reuse and better maintainability.* Added language localization for Blazor web applications utilizing a database backend for maintaining translations as a LocalizationManager that works seamlessly with the built-in .Net IStringLocalizer functionality in the front end.* Added unit testing and integration testing projects to our core application codebase, and created a testing process specifically for our stored procedure refactors to ensure changes made to stored procedures to improve efficiency had no impact on query output when called with all possible combinations of inputs.* Worked effectively with tools and technologies as required, utilizing C#, SQL, Entity Framework, JSON, Restful APIs, Azure DevOps, Git. Able to work with javascript, python, shell scripting, and linux environments as needed

Tutoring bootcamp students in python, javascript, html, web apis, data visualization, and machine learning

* Full stack web developer assisting in all aspects of application development including creating SQL Server database structures, writing stored procedures, transaction management, creating business logic classes in C#, front end UI web pages, and deployment at customer facility.* Lead developer for small team of three developers, responsible for sprint planning, code review, versioning and git administration. Used agile development methods including sprint planning, Kanban, testing, and regular releases of functional components.* Assisted in converting legacy Webforms code as a completely rewritten Blazor application running on .NET Core.* Used NUnit testing frameworks to create unit tests as well as integration tests to evaluate program performance in complex workflows involving multiple core components working together in real life scenarios.* Developed repository classes with Dapper to implement a reliable and efficient persistence layer with appropriate interfaces to facilitate testing and clean code practices.* Worked with SSIS to create an ETL layer to sweep external data from a remote database to the local database connected to the primary web application.* Built automated browser testing library with python + selenium for end-to-end regression tests of code releases.

* Designed and developed application for automating policy endorsements utilizing C#, RESTful API conventions, and SQL Server backend. Implemented asynchronous and parallel coding patterns to improve performance for operations with high disk latency. * Participated in agile development methods. Created work items for Kanban board and participated in sprint planning.* Used MSTest V2 and NUnit testing frameworks to create unit tests. Implemented SOLID design principles to refactor code for improved testability and reduced external dependencies.* Designed and implemented a templating engine to serve as the basis for a complex parameterized reporting wizard to support on demand reporting requirements for non-technical end users.* Used advanced SQL to write complex SQL queries, stored procedures, functions and create new tables and views in SQL Server. Assisted in mapping data from external XML files to SQL server data tables using SSIS and XQuery with particular attention to flagging missing data or invalid values to ensure clean data. * Participated in debugging, code refactoring, code review and root cause analysis of production problems as a member of a 10 person team. Mentored less experienced programmers.

* Responsible for Financial Statements, Accruals and Deferrals, Fixed Asset Ledger, Budget, Data Warehousing, KPI Dashboards, Internal Auditing.* Reduced financial statement preparation time from hours to minutes with the use of advanced techniques in Excel and Access* Designed and published performance metrics dashboards using Epicor ERP query tools and Coldfusion web development utilities.* Created numerous on demand and periodic reports in Excel, Access, and as HTML reports.

* Responsible for Accruals and Deferrals, Account Reconciliations, Fixed Asset Ledger, Calculate Commissions, Expense Allocations.* Improved labor intensive processes using advanced MS Excel, MS Access, and SQL Server to automate data collection and data entry* Developed procedures to calculate and report commissions to business partners* Setup company division and other administrative tasks in Great Plains accounting software* Oversee 2 staff accounts in A/R area