Scott Reis

Senior Software Developer with more than 25 years of experience in software development seeking additional remote consulting opportunities.

Position: Independent Consultant / Application Developer. Consulting assignments for various clients, including the following:

Creation of and / or enhancements to many different Microsoft Access databases for multiple clients and industries, including Workers Compensation Medical Billing, Financial Asset Management, Prisoner Rehabilitation, and Construction.

Technologies: Microsoft Access.

Creation of a web portal for a company providing support services in the energy sector. The portal assists with the work of the company’s worldwide network of inspectors that see that standards are met in the industries of oil and gas, mining, etc. Through this portal, inspectors receive assignments, submit inspection reports, timesheet and expense data, and maintain their profile of certifications / education / experience.

Technologies: VB.NET, ASP.NET, SQL Server, jQuery, JavaScript, Bootstrap / Responsive Design, Microsoft Azure.

Creation of an Access Database Application client connected to a cloud-hosted Azure SQL Server database for a contract research organization in the Health / Medical / Pharmaceutical sector. The application allowed multiple users to share call data. The Access client allowed users to enter, maintain, and report on that data.

Technologies: MS Access, Microsoft Azure SQL Server.

Creation of an automated system to assist with making a large volume of offers on real estate properties for a company in the business of purchasing, repairing, and reselling such properties for a quick turnaround and quick profit. The company maintained an inventory of hundreds of properties at any given time in various stages of reconstruction. An unattended program was written (in C#) to monitor incoming emails so that the company owner could initiate an offer by simply emailing the system from his smartphone with the details of the offer. The program would then generate 20-50 pages or more of contracts and related documents appropriate to the type of property. These documents were produced already filled in and signed and ready to be emailed out to the seller.

Technologies: C#, MS Access, MS Outlook.

Migration of eight different Access databases to SQL Server. On two of these, also migrated from Access replication to SQL Server replication using SQLExpress on a laptop used in the field which then synchronizes with the main SQL Server when brought back into the office.

Technologies: MS SQL Server, SQLExpress, Microsoft Access, SQL Server Replication.

Enhancements to an application for producing presorted postal mail, used to send thousands of pieces of postal mail daily. The application involved generating batches of presorted PDF documents (mail pieces) which were then selected for printing.

Technologies: VB.NET, MS SQL Server.

Position: Senior Application Development Consultant. Company: SCG - Solutions Consulting Group. Consulting assignments for various clients including the following:

Developed a highly customized Microsoft Dynamics CRM solution as part of a team of developers using the Microsoft .NET development platform. The application was for the purpose of order entry, fulfillment, and customer service for residential home system integration products and services.

Technologies: Microsoft Dynamics CRM, Microsoft Dynamics GP (Great Plains accounting), C#, ASP.NET, JavaScript, MS SQL Server Reporting Services, BizTalk Server, MS SQL Server, Windows Server, VMWare Virtualization Software.

Developed an ASP.NET browser-based thin-client application as part of a team of developers using the Microsoft .NET development platform. The application was for the purpose of entering, pricing, and maintaining construction insurance bonds. The system was integrated to a mainframe accounting system through BizTalk Server.

Technologies: C#, ASP.NET, JavaScript, MS SQL Server Reporting Services, BizTalk Server, MS SQL Server, Windows Server.

Developed a handheld Pocket PC / WinCE application for a genetics lab for recording mouse litter birth and wean data. In this way, handheld data capture functionality was added to an existing third-party application that previously lacked this capability.

Technologies employed included C#, Microsoft .NET Compact Framework, MS SQL Server.

Developed a Windows .NET desktop ETL (Extract, Transform, & Load) application for importing, validating, and maintaining a data mart of medical billing data. The application included the ability to control a number of back-end DTS packages through ''user-friendly" user interfaces.

Technologies employed included VB.NET, DTS, Crystal Reports.NET, and MS SQL Server.

Developed a CRM Mortgage browser-based thin-client solution as part of a team of developers using the Microsoft .NET development platform. This involved both custom C# ASP.NET development and Microsoft CRM integration.

Technologies employed included MS CRM, C#, JavaScript, ASP.NET, and MS SQL Server.

Position: Software Engineer / Application Developer. Company: Successful Software (Independent Consultant). Consulting assignments for various clients, including the following:

Developed a system for processing medical claims. The system had screens for entering medical claims, pre-authorizing medical services to be rendered, maintaining data on facilities, physicians, health plans, plan members, diagnosis and procedure codes, and procedure fee schedules. It included a seamlessly integrated table-driven reporting system (using Crystal Reports automation objects). Created a separate data mart database as well as ETL (Extract, Transform, & Load) processes. The data mart enabled large amounts of data to be queried for decision support purposes in seconds.

Technologies employed included Visual Basic 6.0, ADO, Crystal Reports, MS SQL Server, Windows Server, and MTS.

Position: Software Engineer / Application Developer. Company: SCG - Solutions Consulting Group. Consulting assignments for various clients, including the following:

Developed a compensation system for physicians. This involved mechanisms for pooling, allocating, weighting, and adjusting charge and payment transaction information to calculate current compensation amounts. This was a 3-tier DCOM application employing the following technologies: Visual Basic 6.0, ADO, Crystal Reports, MS SQL Server, Windows NT, and Microsoft Transaction Server.

Position: Programmer / Analyst. Company: Stellcom. Consulting assignment. Created MS Access user interfaces for a Sybase database. The interfaces enabled stock traders for a large brokerage firm to see up-to-the minute status of brokerage accounts to support trading decisions.

Position: Programmer / Analyst. Company: Successful Software (Independent Consultant). Client: National Health Laboratories. Consulting assignment from 11/92 - 10/93. Hired as employee of National Health Laboratories / LabCorp from 10/93 - 5/96. Created / modified applications in areas of Human Resources and Payroll.