David Stevenson Email & Phone Number

Henrietta, Ny, Us

• Enhanced and Supported a Design for Remanufacturing Process system for companies desiring to optimize parts for remanufacturability and reduction of carbon dioxide emissions. The system supports and guides project managers, subject matter experts, engineers through the process of design for remanufacturing.• Enhanced and supported Remanufacturing Impact Estimator (RIE) wizard and editor used by project management, for importing Bill of Materials from Excel spreadsheet or CSV file, material matching, categorizing parts as high, low and medium impact, supporting the editing of high impact parts, and assigning responsibility for part design to engineers.• Developed, enhanced and supported MySQL queries, views and stored procedures, and integrated with ASP.NET Core 8 Web API and Entity Framework.• ReactJS, React-Bootstrap, Bootstrap5, CSS, JavaScript, Promises, AJAX, ASP.NET Core 8 Web API and C#, MySQL with JSON, Entity Framework and LINQ, Git, Visual Studio 2022, Visual Studio Code, Agile, Jira, Sprints.

Rochester, Ny, Us

• As a contractor to Center of Employee Wellness (CEW) team for the School of Nursing, supported, maintained and enhanced reports developed using SSRS, maintained data transformation and loading of employee organization population data using SSIS, elaborate T-SQL queries and stored procedures. Visual Studio 2022, SQL Server 2016.• Developed Clinic Editor prototype for CEW Staff application for clinicians to configure clinics for biometric screenings. AngularJS, C#, ASP.NET MVC – WebAPI, T-SQL, SQL Server 2016. Visual Studio 2022.

Allentown, Pennsylvania, Us

• As sub-contractor to Trillium Health Resources of North Carolina, developed Microservice for creating outbound fixed width file to NC Analytics containing behavioral and medical authorizations.• Developed Microservice for ingesting inbound fixed width files from PerformRx containing pharmacy prior authorizations into SQL Server database. • Used Visual Studio 2019 to modify SQL Server Database Projects to create new tables and stored procedures and publish them to deploy local test database instances.• Used Azure Dev Ops to manage tasks on Sprint Board, issue pull requests, view Git changes, and invoke build pipelines and releases.• Used Balsamiq to mock user interface screens and dynamically update for button clicks.• Skills included Azure Dev Ops, Git, C#, .NET, Entity Framework, SQL Server 2016, SQL Scripts, LINQ, Visual Studio 2019, Qvera orchestration software, Agile sprints, and Balsamiq.

Allentown, Pennsylvania, Us

Mid-Level .NET Developer (100% Remote) (Kepro) August 2021 to December 2022• As a sub-contractor to Kepro, maintained Medical Case Management software (Atrezzo), primarily used by state agencies for managing Medicare and Medicaid cases. Web page support changes for pages for Appeals, Task Center, Requests, Providers, Case Searches, Add Medicaid ID and Completed Date to Case Searches, Contacts, Contact Types, Provider Searches, Questionnaires, Clinical Procedures, Attachments, Documents, Letters, Members, Contacts, Dental, Manage Provider Groups, Manage Users, Fax History, Favorite Groups, Deactivate buttons, management portal for application configuration, and Extensions.• Skills included C#, .NET, ASP.NET MVC5, ASP.NET, Entity Framework, Bootstrap, jQuery, SQL Server 2016, SQL Scripts, JavaScript, Promises, ECMAScript 6, AJAX, LINQ, LINQ to XML, CSS, HTML, Visual Studio 2019, Team Foundation Server, and Agile sprints.

Williamsville, New York, Us

• Created back-end Windows Service for processing Excel spreadsheet domestic wire payment files and creating new payment files using information from Treasury Center payment templates for processing by Bottomline Technologies application. Utilized Oracle Managed Data Access to query Treasury Center domestic wire templates. Encrypted user id and password using WinForms application, and stored encrypted value in system environment variable using AES or Data Protection Encryption. Used log4net and Event Logger to report diagnostic information. Documented deployment and upgrade procedures with Microsoft Word. Created unit tests using xUnit. Application sent emails to customer notifying of status of processing file. Developed web server application to allow developers and customer support to investigate and trouble-shot problems, using ASP.NET MVC5, Bootstrap 3.0, jQuery 3.4, JavaScript. Design patterns used: Dependency Injection / Inversion of Control, Repository. (C#, Visual Studio 2019, SQL Server, Oracle, Open XML for Excel API for .xlsx files, ADO.NET, LINQ To Objects, Task Parallel Library – TPL, Git, GitLab, ServiceNow).• Enhanced PowerShell application (CCF Swift Reports) for redirecting files to folders for processing and archiving files and notifying developers and customer support by email if files did not arrive. Encrypted database password using PowerShell.• Developed SQL Server Bulk Copy data load into SQL Server database staging table using XML format file and SQL / SQL stored procedures for loading data from staging table into destination table, along with PowerShell for managing processing and archiving of files.

Pittsford, Ny, Us

Supported and enhanced UniteU eCommerce solution for small and medium sized companies.Implemented systems integration between Channel Advisor, Big Commerce, Microsoft Dynamics NAV 2016 and BazaarVoice SEO.Visual Studio 2015/2017, C#, Team Foundation Server 2018/2013 (TFS), SQL Server 2014, T-SQL, stored procedures, MSTest, MOQ, MSBuild, PowerShell, AutoMapper.

Performed software development, enhancements and maintenance work for multiple clients, working in the Microsoft area, ranging from Classic ASP/ADO to Visual Studio 2008, C#, VB.NET, SQL, ASP.NET & Web Services, to Visual Studio 2015, ASP.NET MVC 4 / 5, jQuery, Bootstrap, Entity Framework 5. Supported SQL Server 2000 to SQL Server 2014.For a retirement planning company, I supported and enhanced the My Plan Loans web application, reports in SQL Server Reporting Services and Client Side Reporting. I have used SalesForce Data Loader command line tool to export data from SalesForce for subsequent import into SQL Server database. I wrote and optimized the performance of T-SQL stored procedures, and export database data using LINQ To SQL and LINQ To XML. I also created reports with SQL Server Reporting Services and client side reporting with WinForms as well. I loaded data to the database using CSV and Excel file formats using Visual Studio Tools for Office API and SQL/ODBC.For a law firm, I have developed a Client Intake System, which popped up a web page (ASP.NET MVC, Bootstrap) when an incoming / external phone call arrives, using the ShoreTel Telephone Application Programming Interface (TAPI). For a transparent packaging company, I developed a new inventory system using ASP.NET MVC 4 and Entity Framework - Code First.For a retirement home, I supported data transmissions to Mercer and New York State, using Excel for Provider Network Data System, and support other data formats as well.For a container company, I supported an Unexcused Absences Time web application written in Classic ASP/VBScript/ADO, upgraded from Microsoft Access to SQL Server 2008 R2.For a services provider, I developed an application interfacing with database of phone call records produced from a Vertical Wave telephone system, and producing Phone Communication records in Clio to produce legal billing info.

• Maintained and enhanced ColdFusion 10/Oracle 10g applications for Corning’s glass Research and Development group using Cold Fusion Builder 2, jQuery, jQuery UI, jQuery Validation Engine, Oracle 10g SQL, Toad For Oracle 9.0 and Subversion. Applications include product test management for Gorilla glass, fiber optics, Corning System Change Requests, Research Melter and lost items.• Upgraded Lost Items application to Twitter Bootstrap 3.0, with Bootstrap add-ons for date picker, select picker and toggle buttons, bootbox add on for alert and confirmation dialogs, Twitter type ahead for auto-completion fields, jQuery and jQuery Validation Plugin with ColdFusion 10/ColdFusion Builder 2.

San Jose, California, Us

Migrated Mobile Device Management software plug-in solution to System Center Configuration Manager (SCCM) 2012. Supported SCCM 2007 plug-in solution. Worked with WMI, PowerShell, Microsoft Management Console (MMC) 3.0, ConfigurationManagement classes, C#.Developed Certificate Manager web pages for a Mobile Device Management solution written in Python, Django and jQuery.

Rochester, Ny, Us

Developed software for configuration of CNC Machines for making gears. Utilized Visual Studio 2008, Windows Presentation Foundation (WPF) and C#. Built and maintained a Software Build Server (Windows Server 2008 R2) using CruiseControl.NET, Visual Studio 2005-2008, Visual C++, and MSBuild.

Software development and maintenance using Visual Studio 2008, ASP.NET 3.5, ASP.NET AJAX, SQL Server 2008, SQL Server 2008 Integration Services (SSIS) and Reporting Services (SSRS), MSBuild (deployment of Reports via SSRS Web Services).

Rochester, New York, Us

Upgraded Visual Basic.NET, VB6, Excel VBA, SQL Server, Microsoft Access applications for Windows Server 2000 to 2003 upgrade. Upgraded Classic ASP web application to ASP.NET.

Bridgewater, Nj, Us

Provided internal customer support, administration and development for web-based Content Management Systems, including SharePoint, Documentum eRoom, and SilkWood EPrise.Supported and enhanced existing ASP.NET web pages.

• Designed and developed Mailing List Management software for standardizing and correcting bulk mailing addresses according to United States Postal Service (USPS) certification standards. Developed Import Mailing List Wizard in Windows Presentation Foundation (WPF, C#, ADO.NET, SQL-SMO, Platform Invoke - P/Invoke, LINQ To XML, LINQ To Objects, Visual C++ 6) for importing mailing lists from delimited files.• Developed postage barcode service for USPS, including support web pages, unit tests, test programs and performance tests having high performance and scalability (C#, ASP.NET, LINQ To XML, VB.NET, WinForms, P/Invoke, Log4Net, Unit Tests, Static Code Analysis, FxCop).• Developed module for printing Certified Mail forms, with bar codes (Interleaved 2 of 5) on Laser Substrates forms (CEL-43, LCD-811), USPS forms 109, 1357-S, 5051, and 5053, associated dialogs for selecting addresses and Certified Mail options. (Visual C++, MFC, STL, ADO, Microsoft Access, SQL Server 2008). Implemented software to build realistic looking mailing lists (domestic, international, Canadian) for testing (C#, ADO.NET).• Developed module, including dialogs, for printing International Mail forms using USPS XML over HTTPS (SSL) service (Visual C++, MFC, STL, Xerces/C++).• Developed address standardization and correction component to eSmartMail™ application (Visual C++, STL, MFC, USPS AMSAPI).

East Rochester, Ny, Us

Enhanced Trouble Ticketing System for Sirius Satellite Radio to track customer problems and improved data collection in SQL Server database to allow analysis of customer problems.Supported and maintained Portal Subscription Management Service and branding software for Sirius Satellite Radio. Maintained and enhanced Unix scripts using Korn shell and Perl. Utilized the C# language to maintain a Windows Service and ASP.NET applications.

Toronto, On, Ca

Developed and maintained web interface for legal content management system used to store analytical, regulations, and codes publications for the premiere legal publishing company. Used Java, Java Server Pages, Documentum content management system - Documentum Foundation Classes (DFC) and Web Development Kit (WDK), Oracle SQL and PL/SQL, and Versata Workflow System, along with various open source software technologies, such as Xerces (XML-SAX), Xalan (XSLT), and Log4j.Performed extensive optimizations for Java and Documentum Foundation Classes code, instrumenting performance measurements, and turning measurements into statistics displayed by web pages using Unix shell scripting.

Developed legal content editing tools using Java, Java Server Pages (JSP), iPlanet, Tomcat, Documentum Web Development Kit (WDK), Oracle.

Developed and maintained process control systems using real-time, Unix and Windows operating systems, using C/Unix/Oracle/Motif/TeleUse, and Visual C++ 6, Visual Basic 6, COM/DCOM.

Ms, Software Development And Management

Bs, Electrical & Computer Engineering