Database Application Design and Development
With on-going advancements in
information technology every
organization’s mission-critical
products and services are supported
by software applications, often relying
on extensive database resources.
These software assets commonly rely
on Microsoft-based technology such
as Visual Studio .NET, Visual FoxPro,
and SQL Server. J.C.N. Associates
provides a full range of services
related to every aspect of database
application development from initial
business requirements gathering and
analysis to full database and
application design and development.
Once live, we offer full on-going
application management,
maintenance and user support.
Our extensive project management
and application analysis and
design experience are
available to help you
in your next mission-
critical project. So too
are our technical
expertise in database
application development using
technologies such as Microsoft Visual
Studio .Net, MicroFour’s StrataFrame
application framework, Microsoft SQL
Server, Microsoft Visual FoxPro and
F1 Technologies’ Visual FoxExpress.
Our wide-ranging experience in many
diverse industries and projects, and
ability to work on both large and small
projects can help provide valuable
insight and leadership during all
stages of the application design and
development life cycle. Contact us to discuss your specific needs
and you will quickly be impressed.
Project Management
Late delivery of projects can severely hamper an
organization’s ability to meet customer and
regulatory demands. We not only provide focused
application development resources, but also keep an eye on the
“bigger picture” for you. We help you initiate and establish more
effective project planning, project execution, and project risk
management while introducing “best practices” to the entire
project life cycle. We are fluent
in all of the Knowledge and
Process areas as defined by
the Project Management
Institute (PMI.org) and have
Project Management
Professionals (PMPs) ready to
help you with your critical
software and technology
projects.
Let us help you in these
and other critical project
stages.
•
Project management
•
Systems requirements analysis
•
Development project planning
•
Systems design
•
Implementation management
•
Post-implementation retrospectives (aka, “Lessons
Learned”)
Business System Analysis
Implementing business applications and systems
without proper design is a recipe for disaster. Our
prime objective in this critical phase is to fully
define all business requirements and use this
knowledge to model complete and reliable
technical solutions. Proper data definitions and
logical data and class (program) designs help produce reliable,
maintainable business solutions that can grow as the business
expands.
Starting from a complete business requirements definition, we
use various techniques (e.g., Entity-Relationship (ER) models,
UML data flow diagrams and others) to architect a complete
solution that application development staff (your or ours) can rely
on to build successful software solutions. These “blueprints” then
serve as the foundation for developing feature-rich
Microsoft Visual Studio .NET and Visual
FoxPro applications that meet your every
business need.
J.C.N.'s approach to designing and developing
database-centric software solutions ensures that
your
applications will provide high levels of data integrity and security
while our open approach facilitates efficient and reliable
integration with any existing enterprise applications. All of this
delivered using a development methodology that provides our
clients with clarity and predictability at all stages of the project.
Using ubiquitous
development technologies
such as Microsoft Visual
FoxPro, Visual Studio .NET
and SQL Server further
ensure ease of integration
and extensive support
options. Detailed design,
database and user
documentation, along with a
methodical, structured approach to management of all aspects of
the project, help make even complex application projects
manageable and successful.
J.C.N.'s expertise in database applications has already been
applied to high-profile clients in various industries such as:
- Banking
- Brokerage
- Financial Services
- Healthcare services
- Insurance
- Publishing
We provide database applications for most major platforms and
operating systems using MySQL, ORACLE and Microsoft SQL
Server, and we support all major Microsoft technologies. Read
more about our technologies and tools elsewhere on this website.
Maintenance and Application Management
Once your database applications are up-and-running it is crucial
to have reliable and responsible application maintenance
resources. Although on-going application maintenance includes
"bug" fixes, the majority of
maintenance requests
involve new or enhanced
functionality. Often this is a
result of changes in the
organization’s business
environment or offerings
and meeting these
changing needs is crucial
to
long-term success.
Systems evolve over time, and maintenance is really evolutionary
development and as important as new application design and
development. With the additional complexity and concern related
to updating of production applications and system, management
and communication skills are often just as important as technical
expertise at this state in the System Development Life Cycle
(SDLC).
Reverse Engineering and Legacy Application
Analysis
In addition to our extensive experience creating
new Microsoft Visual FoxPro and Visual Studio
.NET database applications, J.C.N. has a wide
range of experience in reverse engineering and
analysis of legacy applications. This is especially
valuable in scenarios where companies have large,
mission-critical Visual FoxPro applications and in-house technical
expertise is limited or not available.
Using various techniques and tools such as UML modeling
diagrams, technical documentation utilities, forensic tools, Sybase
PowerDesigner, Microsoft
Visio, Serena Prototype
Composer, docSCX/VCX
and others, we quickly
unlock the business, data
and processing flows of
the target application.
Our ability to extract and
communicate the
essence of an application
to both technical and
business staff helps make
management and redesigning of legacy applications very efficient
and productive.
Website Design and
Maintenance
Although we won’t compete with the web
development teams at Google and Yahoo, we
can help you achieve an on-line presence that helps you grow
your business and provide services and features to your clients
they really need and want. Inspect our site or visit the New Jersey
Amateur racquetball Association (NJAR) website, which
showcase just two of many styles of websites possible. Then
contact us to discuss your specific needs and how we can help.
We will not only help you determine the most appropriate website
design and content for your business, but will develop and host
your site (shared or dedicated servers) and create a process by
which you will be able to update and maintain most site content
on your own for ultimate control and efficiency.
Image courtesy of Ambro / FreeDigitalPhotos.net and Photostock.com
© J.C.N. Associates, L.L.C. 1991 - 2017
Voice: 646/583.2989 | Fax: 732/595.9125
Microsoft Visual FoxPro
IT Software Project Management
The PMI Logo is a registered mark of Project Management Institute, Inc.
Unified Modeling Language (UML)
UML is a standardized general-purpose modeling language in the field of object-oriented
software engineering. The standard is managed, and was created, by the Object
Management Group. It was first added to the list of OMG adopted technologies in 1997, and
has since become the industry standard for modeling software-intensive systems.
UML includes a set of graphic notation techniques to create visual models of object-oriented
software-intensive systems.
UML is used to specify, visualize, modify, construct and document the artifacts of an object-
oriented software-intensive system under development. UML offers a standard way to
visualize a system's architectural blueprints, including elements such as:
•
activities
•
actors
•
business processes
•
database schemas
•
(logical) components
•
programming language statements
•
reusable software components.