Full Stack Software Engineer

• Oracle PL/SQL development

• Microsoft SQL Server T-SQL stored procedure development

• Database performance optimization

• ASP.NET web application and web service development

Designed database tables, views, indexes, and other structures in Oracle and SQL Server databases used for complex, high scale web applications, mobile applications, and decision support systems.

Developed Oracle PL/SQL stored procedures and SQL Server T-SQL stored procedures.

Performed database optimizations necessary to deal with rapidly increasing data size and user count.

Developed ASP.NET web applications and web services using C# and VB.NET.

Developed packages in Oracle PL/SQL for secure handling and scrubbing of Personally Identifiable Information (PII) information for data management systems. The packages were designed under stringent constraints for scalability and concurrency and were used to load data into and pull data from business intelligence systems and real time OLTP systems. The system used advanced Oracle security features, such as Transparent Data Encryption.

Developed a system that provided scheduling, monitoring, and alerting using Oracle PL/SQL procedures and .NET windows services written in C#. Used ODP.NET to access the Oracle databases from the .NET services.

Designed custom queries using SQL Server 2008 T-SQL for reporting applications. Embedded complex SQL queries in Microsoft Excel spreadsheets for custom reporting. Tuned many reporting queries to improve performance using tools in SQL Server Management Studio.

Designed and implemented an automated email delivery system. The email system was a Microsoft Windows service, written in Microsoft .NET using C#, and accessing an Oracle database using ODP.NET.

Converted a resource management and accounting batch processing system from legacy Visual Basic 6 to C# and T-SQL stored procedures. The new system improved performance by over 800%, mainly by converting procedural logic to set-based logic using SQL.