Scott Reis
Software Developer Consultant
Software Development
Since 1980, I have been a developer of application software for many different clients,
and in a number of industries. I currently specialize in application development
in both web client and Windows desktop environments. Please see my resume, my skill set summary,
or browse the summary of various
projects I've done for more details on my background.
Programming languages, databases, and technologies in which I am experienced include:
- C# ("C-sharp")
- VB.NET
- ASP.NET
- Visual Basic 6.0
- JavaScript
- Microsoft SQL Server
-
SQL Server Reporting Services (SSRS)
- SQL Server Integration Services (SSIS)
- Data Transformation Services (DTS)
- Microsoft BizTalk Server
- Microsoft
Access
- Crystal
Reports
- Crystal Enterprise
- Microsoft Dynamics CRM
- Microsoft Dynamics GP
(Great Plains Accounting)
C# (CSharp)
I have been working with
C# since it was first released in 2002 as part of the first version of Visual
Studio .NET software (later known as Visual Studio .NET 2002). The current version
is C# 4.0, also known as C# 2010, a part of Visual Studio 2010. C# is a powerful
object oriented programming language using the .NET framework. A C# developer can
use this product to create ASP.NET web applications, Windows desktop applications,
and much more.
Microsoft Access
Microsoft
Access is a versatile database product that I have been working with since
version 2.0 was released in 1993. The current version is Access 2010, and is part
of the Microsoft Office family of products. The many templates and wizards that
Microsoft Access contains often enable users to create a database application without
the assistance of an Access programmer. For a Microsoft Access programmer , Access
can be used to create applications ranging in complexity from simple custom data
maintenance and reporting tasks to polished application packages.
If you have outgrown your Access database, and are now in need of a more powerful
database program, the next step to consider might be that of simply moving the data
from Access to a platform such as Microsoft SQL Server, while preserving your existing
forms and reports in Microsoft Access. A Microsoft Access developer who is also
experienced in Microsoft SQL Server (I have been working with Microsoft SQL Server
since 1993 with version 4.21) can "upsize" the database to SQL Server and replace
your current tables with linked tables that "point" to SQL Server.
In addition, an MS Access
programmer may be able to spot areas where design changes in your current
database may make it run more efficiently. Are tables (whether local Access tables
or linked SQL Server tables) indexed properly? Could queries be redesigned in a
way that improves performance? If you have "upsized" the database to SQL Server,
might there be a benefit to now moving some of the processing into stored procedures?
An
MS Access developer can examine these and other factors affecting performance.
SQL Server Reporting Services or SSRS
I began working with
SQL Server Reporting Services or SSRS during 2004
while the product was still in beta. I was working through a consulting company
on a reporting project for a restaurant chain. Both we at the consulting company
as well as our client were so impressed with the product that we stopped the work
we had just started on the project, which had been based on a different approach,
and immediately switched to SQL Server Reporting Services as the platform we would
use to complete the project. (We did so even though Reporting Services was still
in beta at the time and not yet released for general availability.) The first version
of Reporting Services was released as an add-on to SQL Server 2000. Since the release
of SQL Server 2005, Reporting Services comes included with SQL Server (the current
generally available version of which is SQL Server 2008 R2). I continue to be impressed
by SQL Server Reporting Services (SSRS) as many new features have been added since
its initial release, including support for Multidimensional Expression (MDX) queries
for Cube structured OLAP databases.
Crystal Reports
I first worked with
Crystal Reports in 1996 using version 4.0. Crystal Reports has a long history
as a leading report design tool, and as such, has been incorporated into many off-the-shelf
software packages. A Crystal Reports consultant can use this product to produce
standard reports, cross-tabs, subreports, and graphs, as well as interactive reports.
Why do you need a consultant?
You may be looking for an
application developer consultant for a number of reasons. You may be in
need of
custom software development for purposes of increasing sales, improving
customer service, or managing your business more effectively. You may want to have
improved reporting and analysis for better sales tracking, or to help you spot areas
where you can decrease costs and increase profitability. Maybe you are in need of
a programmer to create a web site to give your business an internet presence, to
sell products or services online, or to better serve your customers with online
access to information. Or it may be that your current systems already provide the
functionality you need, but simply run too slowly. You would like someone to look
at ways to speed up your database and make it run more efficiently.
If you are interested in having a software engineer custom design software for your
business for purposes such as sales / order / data entry, billing, inventory control,
scheduling, or some other purpose, send me an email
and let me know what you have in mind. What are you currently using to address these
needs? Are you interested in some kind of internet / intranet / browser-based solution?
Would a Windows desktop solution be a better fit? Software developed using C# or VB.NET may meet these needs. On the
other hand, there are many situations where Microsoft Access may be used to develop
a very economical and cost effective solution.
Do you currently have software developed in
C#, VB.NET, or
Access that now needs modification or additional functionality, but
the original C#,
VB.NET or
Microsoft Access consultant who developed the application is no longer available?
Do you need additional reports created using reporting tools such as Crystal Reports, SQL Server Reporting Services
(SSRS), or
MS Access? Do you need additional customizations in Microsoft CRM?
Do you need to extract information from your Microsoft Dynamics GP accounting system
or some other system for reporting purposes or for import, export, or integration
with other application software?
Please feel free to send an email to scott@scottreis.com
to discuss your needs further, or with any questions or comments you may have. If
it should happen that your particular reason for seeking a consultant would be better
served by someone else, I may be able to refer you to another consultant.
Not located in San Diego?
If you are not located in San Diego, this should not really present a problem to
our working together. I have developed applications remotely for companies located
in many other areas. If there is a need for me to access your system remotely, there
are a number of ways this can be accomplished. If remote access is not needed or
not desired, completed software or updates can be delivered to you via secure download
or other means. Click Remote Support
for more information on available remote access and file transfer options, including
information on product versions available for free.
What type of payment is acceptable?
Payment can be made by check or through PayPal, which accepts payment by credit
card, debit card, or bank transfer. Click Payment
for more information.