Software Developer Consultant, San Diego, California

Scott Reis

Download resume in: Microsoft Word format  PDF format
San Diego, California

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

  • Experienced in the following languages, databases, and technologies: C#, VB.NET, ASP.NET, jQuery, JavaScript, Bootstrap / Responsive Design, MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), MS Access, and Crystal Reports, Experienced in both Web and Windows Desktop software development.
  • Business application development experience includes the areas of construction insurance bonds, healthcare / medical billing / claims, home mortgage finance, publishing, insurance carrier / broker / sales, wholesale distribution, retail sales, rental, property management, construction estimating, commercial nursery grower, municipality accounting / utility billing, mail order, event ticket sales, travel agency.
  • Comprehensive experience in all phases of application development from initial
    requirements gathering, systems design, specification, and project planning through
    construction, documentation, deployment, and training.

PROJECT EXPERIENCE

December 2008 - Present

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

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 2013, ASP.NET, SQL Server 2012, jQuery, JavaScript, Bootstrap / Responsive Design, Windows Azure.

Creation of an Access Web App for a contract research organization in the Health / Medical / Pharmaceutical sector. The application allowed multiple users to enter, maintain, and share call data using a web browser. A separate desktop MS Access that remotely connected to this web hosted database was used for generating reports.

Technologies: MS Access 2013, Office 365 (SharePoint / SQL Server / Azure)

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# 2010, MS Access 2010, 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 2008 R2, 2008, SQLExpress, Microsoft Access 2010 through 2000, SQL Replication, Access 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 2005.

March 2003 - November 2008

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 3.0, Microsoft Dynamics GP (Great Plains accounting), C#, ASP.NET, JavaScript, MS Reporting Services 2005, BizTalk Server 2004, MS SQL Server 2005, Windows Server 2003, 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 2004.

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

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: C#, Microsoft .NET Compact Framework, MS SQL Server 2000.

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: VB.NET, DTS, Crystal Reports.NET, MS SQL Server 2000, Windows 2000.

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: MS CRM, C#, JavaScript, ASP.NET, MS SQL Server 2000, Windows 2000.

April 1999 - February 2003

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 Seagate Crystal Reports automation objects). The entire system, including reporting, was designed in a 3-tier DCOM architecture for maximum scalability. 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: Visual Basic 6.0, ADO 2.5, Crystal Reports 8.0, MS SQL Server 2000, Windows 2000 Server, MTS 2.0, Windows 98/95

July 1996 - March 1999

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 2.0, Crystal Reports 6.0, MS SQL Server 7.0, Windows NT 4.0, Microsoft Transaction Server 2.0, Windows 95.

May 1996 - June 1996

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.

Nov. 1992 - May 1996

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, Payroll, and others.