Developed and altered stored procedures, tables, views, and other database objects for various project teams using SSMS and Azure StudioTuned queries for better performance (IO, CPU, Mem) using Sentry One Plan Explorer (and execution plans)Advised project teams on industry standard best practices for performance, scalability and reliabilityMentored more junior developers to help them learn and grow within the organizationProvided on-call service as neededDeveloping web applications tailored to the Database Team in C#/Blazer using TSQL backendDeveloping internal applications with Python and Streamlit

Mentoring and leading a team of about 12-13 BI Developers including Co-Ops and InternsManaged a cross functional team of BI Developers as well as Database Developers Mentoring in the usage of SQL, Power BI and SSRS and branching into Azure and AI/MLProviding guidance on career path and development of skillsWorking with the business to guide decisions and improve profit and growth of sales and revenueCoordinating with key business players to make sure they have the information they need, when they need it and in ways that makes the most sense to themAssisted operationally as needed for special projects - writing and editing code, approving changes, and ensuring a smooth go-live transition

Mentored and leading a team of about 8-9 BI Developers including Interns and Co-OpsMentored Mid level to become SR level and further developed several more junior developersMentored in the usage of SQL, Power BI and SSRS and branching into Azure and AI/MLMentored and involved in creation of stored procedures, tables, views, models and development of SSRS and Power BI reportsProvided guidance on career path and development of skillsWorked with the business to guide decisions and improve profit and growth of sales and revenueCoordinated with key business players to make sure they have the information they need, when they need it

Led and mentored a team of 8 - 10 SQL developers Hired 2 JRs that mentored to Mid level DB Developer and 2 Mid level to become SR levelMentored 4 developers to get promoted - 2 to leadership and 2 to more senior positionsResponsible for the database resources on 7 project/scrum teams and provided guidance to Product OwnersTrained SQL developers on our processes and tools including on performance and scalabilityDeveloped a cross trained and durable team of developersWorked with .Net development teams to ensure data was correct and following standards

Developed and altered stored procedures, tables, views, and other database objects for various project teams using SSMS and Azure StudioProvided help and training with Git, ADO, Visual Studio and SourceTree to the Development TeamWritten a number of wiki articles and how-to guides for documentation and training purposesTuned queries for better performance (IO, CPU, Mem) using Sentry One Plan Explorer (and execution plans)Advised project teams on industry standard best practices for performance, scalability and reliabilityMentored more junior developers to help them learn and grow within the organizationPerformed Code Reviews, and managed and coordinated production deploysParticipated and led the Senior Development Team and provided support to make decisions on Best Practices and ProceduresProvided on-call service as needed

Developed SSRS reports for varying business unit including Sales and AccountingDeveloped dimensions in SSAS and maintain cubesDeveloped SSIS packages to sync data between different platformsTuned SQL Queries and indexes using SentryOne Plan Explorer and Solar WindsCreated and altered Stored Procedures, Views, Indexes, Tables and other Database objectsMonitored database systems w/ Solar Winds and ensure systems are available and working wellPerformed Data Analysis to assist other teams to make better decisionsProvided On-Call Support as neededActed as a Code Reviewer and deployed production code

Responsible for a team of about 6-8 developers in building and maintaining client-facing projects. Made Architectural decisions for projects based on Best Practices and the needs of the business and attempting to reduce Technical Debt.Optimized C# and TSQL code for efficiencyDeveloped a distributed server service to allow the usage of multiple idle computers to generate reports and track their progress for report processingDesigned a database to handle the processing of a new report generation systemStreamlined accounting process of accepting payment via credit card through invoiced billing, and automated the invoicing processPerformed Code Reviews to ensure code matches our standards and best practices

Temporarily assigned to a different team that was behind schedule, and managed the project to get resources and expertise needed and led that team to complete the project only slightly behind schedule, while also building their trust as a leader.Integrated an innovative query engine to the report engine using C# and using Object Oriented Programming that allowed reports that would take hours to run to finish in drastically reduced time. In some cases, results that took 2+ hours to complete took less than 20 minutes, and used less than 20% of the RAM and CPU resources they originally did.Providing Technical Documentation to other developers to allow them to understand the project requirements as part of the Tech Lead role. This documentation included tips on how to accomplish requirements, as well as ideas on how best to organize code using Best Practices.Led other developers offering support, technical guidance, and experience to issues they were having in C#, SQL, general networking issues, and in advanced topics such as security, data optimization, and threading.Implemented various threading techniques in C# code to allow processing of data to be faster, and to reduce TCO by reducing the time needed for the Output Team to monitor reports.Implemented Best Practices in C# development, and via Code Reviews, encouraged others to write fast, efficient, and well documented code.Used tools such as Jet Brains Resharper, UltraEdit/UltraCompare, Excel Writer and various other tools to make development faster and easier.Updated and maintained a Portal application using a mix of ASP.Net and MVC, making heavy usage of javascript, Knockout and jQuery under the covers.

Developed a workflow process using Mulesoft Anypoint Studio with a little Java code to accept financial data files and import into Salesforce. The Salesforce used the Bulk Data Loading tools behind the scenes to integrate this data.Developed a Customer Service Dashboard to monitor, track and change progress notes on various projects using MVC 3, C#, Kendo controls, and jQuery.Maintained a primary Line of Business application using .Net 4.0, C#, Ajax Control Toolkit, Telerik Controls, and jQuery used by the Medical Community. This system interacted with numerous other systems via Web Services, FTP, and a custom built API to the CMS.Coordinated changes to critical applications with Business Analysts, Developers, Testers and Customers.Executed plans to push code from Development through Production, assisting the QA, DBAs and Process Engineers with deployment via TFS and deployment packages and documentation.Developed code with the principles of Security Development Life-Cycle in mind using Input Validation, Output Sanitation, and other techniques to prevent SQL Injection Attacks, Cross Site Scripting, and Brute Force Attacks.Utilized various encryption and hashing techniques such as PKI and Sha256/Sha512Developed code to allow Customer Service Representatives to fax documents from an internal application using iTextSharp.

Redesigned an existing website using ASP.NET/C# w/ Ajax and jQuery to help promote a well-known motivational speaker’s book. The site used a MS SQL 2005 backend.Developed a new site using ASP.NET/C# w/ Ajax and jQuery. Allof the data was stored in a MS SQL2008 backend for all content using a Content Management System delivery method.Developed several Stored Procedures and revised several existing ones to make them more efficient.Created and manipulated graphic files for the inclusion in various websites using GiMP (Photoshop files)Modified applications for manufacturing using Power Builder and Microsoft SQL and Oracle 9.2

Started as a JR Developer and a year or so later go promoted to Mid Developer. A year or so later got promoted to Lead Programmer/Analyst.Led the implementation of Security Best Practices and Role Based Security in client’s site, integrating Active Directory and PeopleSoft.Developed a Windows Service to integrate and synchronize PeopleSoft and Active Directory.Trained and mentored Junior Programmers in C#, VB.Net, Visual Studio and other Development Tools.Developed a Task Process Scheduler that could call Windows Applications, Batch Processes, and Web Pages to automate nightly/weekly processes using XML and an Oracle backend.Developed Connectors integrating various ERP and Main Frame Systems to transfer data between systems.Developed the new web site for a local Utility company, and provided the necessary optimizations to allow the site to work efficiently. Developed various applications using Microsoft SQL and Oracle as a backend.Created and executed Test Plans to ensure defect free applications and processes.Created and manipulated graphic files for the inclusion in various websites using GiMP (Photoshop files and other various formats)