Coping with Technological Advancements in Databases

CNS Limited started its journey as a database software development house back in 1992. Serving several IT fields like software development, system solution consultant, system designer, data warehousing service provider and world famous brand hardware reseller and distributor successfully, CNS Limited recently has expanded its business in software development keeping an eye on increasing demand for software products and public awareness about software business in Bangladesh.

Having professionals conversant with various databases formats and demands for different databases CNS Limited planned to expand its database software development and go for the contemporary databases. In this regard two of the major databases used throughout the world was brought into CNS Limited. One of them was Oracle 9i ® Standard Edition with Partitioning Option and the other was Microsoft SQL Server 7 ®.

CNS Limited has gained substantial expertise and experience in database software development using Oracle ® RDBMS as the back end database. It should be mentioned here that CNS Limited is the reseller of Oracle Products in Bangladesh.

For web databases, CNS Limited uses Oracle WEBDB ® that is the integral part of Oracle 9i ®, the latest release of Oracle. With extended capabilities for web database connectivity this database serves the need for strong and reliable back end for web applications. Besides, from its inception, CNS Limited has used Microsoft Access ® database for few local projects and the professionals are also familiar with its front-end capabilities.

Front End Tools Used

Front end is equally important in database software development. Correct choice of front-end tool eliminates the risk of incompatibility and lack of control. CNS Limited has used various front-end tools for database software development. Few of them are:

Also, other Oracle front-end tools such as Oracle JDeveloper ®. Apart from these, CNS Limited uses PL/SQL, C, C++, Java, HTML, ASP, Java scripts, VB Scripts, DHTML, XML, ActiveX & DCOM technology for development of Software.

Computer Aided Software Engineering (CASE) Tools Used

CNS Limited uses the following tools for Computer Aided Software Engineering:

Among these the Rational Rose is used for designing object oriented software in UML (Unified Modeling Language) methodology. CNS Limited also uses Rose as a software modeling tool. But one of the tools CNS Limited uses frequently is the Oracle Designer ®. It consists of the state of the art database design and technology. This tool is very important while designing complex systems for banks and other financial institutes.

Methodologies Used by CNS Limited for Database Software Development

CNS Limited uses the following methodologies for database software development:

OS Platforms Worked on So Far

CNS Limited has already developed and successfully implemented software for these platforms:

Software Developers Group

At Present, there are 24 software developers at various level of skills and expertise under CNS Limited payroll. This number is expected to increase to 40 within next 6 months as per the new recruitment plans undertaken by the company. The developers of CNS Limited are distributed into 4 major Levels:

At present there are 8 Analyst Programmers working as senior most developers. As per the rules and regulations of the company, each of them have a computer science graduation along with at least 3 years working experience in a reputed software development house. Analyst Programmers are responsible for assisting the system analysts in designing and documenting the design documents as well as developing crucial portions of the software and writing complex routines.

Senior Programmers and Programmers are responsible for writing codes and implementation of the software with the help of programmers and Refreshers. Each of them have their own team allocated specific to a project and report to the Software Development Managers or Systems Analysts responsible for management of the Project.

Along with this, CNS Limited has a team of 4 professionals responsible for quality control and documentation of the software. They act as program beta testers and are responsible for producing system and user manuals for a project.

System Requirement Analysis and System Designing

CNS Limited has 3 Senior System Analysts dedicated for the purpose of system analysis and design. Each of them have at least 5 years job experience in various levels of software development. They have visions and ability to design the software for CNS Limited clients.

Management of Software Development

The software division and data entry and processing division is headed by the Executive Director himself who is appointed by the CNS Limited authority. He is one of the Renowned software developer in the country and is reputed to be an outstanding Oracle products expert. The Software Development Manager is responsible for coordinating and follow ups of on-going projects. He is responsible of total project management along with project scheduling and job assignments.

Working Environment in Software Division

The software Division occupies three separate labs accommodating not more than 9 developers per room. The rooms are all air conditioned and well lumen for providing better working condition. There is a cafeteria at the lounge to serve the snacks to the developers. There are power backups and file backup facilities for every body. The database software and Internet based software are developed in the software division and enjoy better working environment.