Matthew Prosser

Software Development Engineer

Cicero, New York, United States

About

A highly experienced Senior Programmer Analyst and SQL Developer, recognized for designing and implementing data-driven solutions that optimize business operations and drive organizational success. With a proven track record in SQL development, database optimization, and process automation, I excel at transforming raw data into actionable insights that inform strategic decision-making and enhance workflow efficiency. Key achievements include leading large-scale database migration projects with zero downtime, optimizing SQL queries to improve performance, and collaborating with cross-functional teams to integrate advanced analytics into business solutions. Expertise spans SQL, C# .NET, Power Automate, SSRS, Power BI and Microsoft Fabric, supporting the development of robust systems that streamline processes and improve resource allocation. Passionate about leveraging data analytics to identify operational bottlenecks, enhance productivity, and deliver measurable results, this professional is dedicated to advancing operational excellence through innovative, data-driven strategies. Key Skills: SQL Development & Optimization Data Analytics & Business Intelligence Process Automation (Power Automate) Microsoft Fabric C# .NET Cross-Functional Collaboration AI Integration Workflow Streamlining Database Migration & Management

Experience

  • Sr Programmer Analyst at Carrols Corporation
    Aug 2018 - Present · 8 yrs

    As a seasoned Senior Programmer Analyst and SQL Developer at Carrols, I specialize in designing and optimizing data-driven solutions that enhance business operations in the fast-paced food service industry. With deep expertise in SQL, C# .NET, Power Automate, and Microsoft Fabric, I develop robust systems to streamline processes, improve decision-making, and boost efficiency. Key contributions include leading a high-impact POS software vendor transition, collaborating across departments to ensure seamless integration, reduce transaction errors by 25%, and enhance customer experience. Leveraging Power Automate, I’ve automated workflows, such as task approval reminders, saving hours of manual effort weekly. My proficiency in C# and SQL supports custom application development, while my exploration of AI-driven analytics has informed strategies for menu optimization and sales forecasting.Passionate about translating complex data into actionable insights, I thrive in dynamic environments where technology meets business needs. Recognized for leadership, technical acumen, and delivering measurable results, I’m dedicated to advancing operational excellence through innovative solutions.

  • Application/Integration Developer at Bond, Schoeneck & King
    Apr 2007 - Aug 2018 · 11 yrs 5 mos

    Recent Project Accomplishments Currently developing our own custom private cloud. The web application is similar to Dropbox and allows the attorneys to upload and store client information (encrypted) and share out the data for collaboration. Developed a completely custom Staff Review and Associate Review system for the company's internal use. This is a fully dynamic system that allows HR to maintain and create new review questions each year. A Bankruptcy Docketing system that integrates with the attorneys and secretaries Exchange mailboxes to create calendar appointments. Developed our own custom HelpDesk system for the IT department using Windows Forms. The department can look up users PC information and type in tickets as well as VNC into their computers as the support calls come in. Senior .NET developer using Visual Studio 2013 and Microsoft SQL Server Management Studio 2013 Design and implement web applications and Windows applications within the .NET Framework for the benefit of the attorneys and staff of Bond, Schoeneck & King. Work extensively with Visual Studio, Microsoft SQL Server, MYSQL, Microsoft .NET, Microsoft Silverlight, Windows SharePoint Foundation, Windows Communication Foundation, Windows Search Server, SharePoint, SQL Server Reporting Services, CSS, XML, AJAX, ASP.NET 4.5, JavaScript and HTML. Develop and maintain the company's Intranet using Microsoft Windows SharePoint 2013 Maintain and administer the Intranet. Create custom SharePoint webparts (built in .NET). Create and apply virtual machines when necessary. Always looking to better the company by making applications and methods easier and more user friendly Set up new user accounts in Active Directory, DM Hummingbird (Document Management System), and InterAction. Set up computers, monitors, keyboards and install software for users. Create reports using SQL Server Reporting Services Upgrade Microsoft Access projects into .NET Implementing the Telerik user controls for .NET

  • Web Database Engineer at Advanced Care Solutions
    May 2005 - May 2007 · 2 yrs 1 mo

    April 2007 Engineer, develop, and implement databases for clients using HTML/OS, HTML, CSS, JavaScript, and PERL. Work at service desk and answer calls for updates and emergencies for 115 clients. Design and create web pages, forms, and back-ends for administrative use. Meet with clients and discuss necessities for their website and database. Design product managers to manage online stores. Release Policy Construct detailed SLA's (Service Level Agreements) for clients that plan out tentative schedules of when projects will be completed, what services the clients will be receiving, a tentative launch date, who the host provider will be, what type of server, and where the server will be located. Release Planning Collaborate with clients the plans for the release date. Develop a test plan by giving users a demo of the website to troubleshoot. Create a DSL (Definitive Software Library) of previous website (if available) in case of emergency. Assume full responsibility pertaining to the development of the database and administrative forms. Design, Build and Configure Release Purchase HTML/OS Professional and any other software accessories from our software providers. Discuss contracts with clients and update as necessary. Engineer and design software, websites and databases. Assist clients with technical problems or questions through service desk functions. Fit for Purpose Testing Thoroughly test the system before the final rollout. Release Acceptance Document and fix all incidents and errors found while testing. Roll-Out Planning Oversee the roll-out of the website as established in the SLA.

  • Database Engineer at Advanced Care Solutions, Inc.
    Apr 2005 - Apr 2007 · 2 yrs 1 mo

    Create and design web interfaces and sql databases

  • Teaching Assistant at State University of New York at Oswego
    Sep 2004 - Apr 2005 · 8 mos

    Oversaw Students as they completed lab assignments using Microsoft Word, Excel, Access, and PowerPoint. Answered any questions students had regarding these programs and assisted in their completion. Evaluated student work and reported grades to the supervising professor.