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. Ou r extensive project management and application analysis and design experience are available to help you in your next mission-critical project. So too is our technical proficiency 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

Imp lementing 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 flo w 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 com plex application projects manageable and successful. J.C.N. 's proficiency 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 f o r 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" fix es, 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 e v o l u t i o n a r y 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 proficiency at this stage 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 proficiency 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.