Erik Pfingsten Email & Phone Number

Louisville, Kentucky, United States

Orchestrate migration of SQL databases to Azure SQL, developing multi-step T-SQL scripts and SSIS packages to ensure seamless transition to multi-homed environments. Enhance database scalability and performance, applying extensive SQL knowledge and analytical skills. Lead technical initiatives, demonstrating problem-solving acumen and meticulous attention to detail.● Successfully migrated multiple databases to Azure SQL, optimizing system performance and scalability.● Demonstrated leadership as Technical Lead across various projects, improving system efficiency and user experience.● Leveraged programming expertise to streamline database management processes, ensuring high levels of data integrity.

Cincinnati, Ohio, United States

Engineered and deployed a messaging system within Azure for a mortgage lender, integrating Azure SQL, Azure Service Bus, and Azure Functions using C#.Net Core. Developed and enhanced features for an online notary application, including updating LexisNexis ID verification for SMS text and optimizing legacy code for improved performance. Designed API endpoints, enabling partner connectivity to the notary system. Conducted comprehensive analysis of database systems to ensure efficiency and reliability. Spearheaded the transition to modern development practices, ensuring scalability and maintainability of applications.● Successfully built a framework that streamlined client communications, significantly enhancing customer service capabilities.● Optimized a financial services company's online notary application, leading to a more robust and secure user experience.● Modernized LexisNexis ID verification process, resulting in a more efficient and user-friendly system for SMS text verification.● Conducted in-depth performance analysis of legacy code, leading to system enhancements and improved database functionality.● Designed and implemented API endpoints, facilitating seamless partner integration and expanding system accessibility.

Cincinnati, Ohio, United States

Led technical initiatives spanning system migrations, modernization processes, and database scalability projects, utilizing expertise in C#.NET, .NET Framework, Windows Services, SQL Integration Services, and Microsoft Azure. Designed system architectures, coded Proof of Concepts (POCs), conducted code reviews, and provided mentorship to offshore development teams. Served as the Technical Lead on projects such as the migration of tax form generation processes, modernization of Quarterly Tax Filing Applications, printing projects for Affordable Care Act forms, and consolidation of multiple databases into a single master database. Spearheaded the total system rewrite of an HR system, implementing custom security layers using WCF services.● Successfully migrated tax form generation processes to a Microsoft Azure solution, reducing processing time and enhancing system validation.● Achieved a significant reduction in the generation time for Tax Agency Electronic files from weeks to hours, resulting in fewer errors.● Led the development of SQL Integration Services Packages to optimize data transfer processes between databases, improving overall efficiency.● Translated data in Microsoft Azure Cloud storage into PDFs for efficient printing on non-cloud printers, enhancing project productivity.● Consolidated multiple disparate databases into a single multi-tenant master database, improving scalability and data management.

Cincinnati, Ohio, United States

Develop Web Applications and Reports in .NET 1.1 and 2.0 for diverse clientele including:• Added functionality to existing web based Corporate Credit Card Management Suite• Proposal Creation and Estimation System for Concrete Paving Company• Actuarial System for Group Workers Compensation Company• Time Tracking/Invoicing System for Consumer Product Testing Company• License Management Tool for a Software Packaging firm• Created a Web Interface to an existing VB Healthcare application using .NET and Interop

Cincinnati, Ohio, United States

• Develop Web Application for Property Management for the Real Estate Industry• Responsible for Source Code Management• Implemented Daily Source Code Compilation Process• Created Web Reporting Infrastructure using Crystal Reports Enterprise 10 and C#.NET

Cincinnati, Ohio, United States

• Developed Workflow Management system (User Interface and Backend Processing Components and Infrastructure using Microsoft Message Queue Server and Windows .NET Web Services) for Operations Support, Billing and Customer Care Software for the Telecommunication Industry• Gathered and wrote requirements and design documents• Responsible for Unit Testing Individual programs• Supervised individual developers • Used Visual Basic.NET, C#, Visual Basic 6, SQL Server 2000, and Microsoft Message Queuing • Updated back-end processing from VB6 components to .NET Web and Windows Services• Participated on a 3-person team responsible for converting entire code base from RDO to MS ADO technology• Created Workflow Status tracking reports using Crystal Reports 8.5

Cincinnati, Ohio, United States

• Developed Request for Proposal Automation Software (RFPMaster) using Visual Basic 5 and 6 in the Windows Environments• Converted standalone version of RFPMaster using Microsoft Access databases to a Client/Server version using Microsoft SQL Server 6.5• Acted as Lead Developer on Service Release 1 of RFPMaster• Worked on Internet version of RFPMaster using ASP and ActiveX Controls

Cincinnati, Ohio, United States

• Managed University-wide client/server Internet email system (Bearcat Online) with 36,000 users running on Sun Solaris 2.6• Presented Bearcat Online at Educom98 in Orlando, Florida• Migrated the entire Bearcat Online email system from the previous HP-UX platform to the Sun Platform• Participated on Classware Development Team• Recoded the Classware system from Active Server Pages to Visual Basic and Visual C++

Cincinnati, Ohio, United States

• Set up and managed UNIX and Windows NT 4.0 Web servers• Created and implemented a university-wide Web-based virtual classroom system (Classware) using Microsoft ASP 3.0• Wrote technical support documents for new University-wide client/server Internet email system (Bearcat Online)• Aided users in resolving problems with Digital VAX and Alpha servers running OpenVMS and Digital UNIX• Assisted users to resolve problems with Dial-up Internet access• Assisted with network hookups and configuration of on-campus network

Education record

Bachelor Of Science - Bs, Information Engineering Technology