Having timely and reliable information is a critical success factor in the management of any municipality. In this sense, all efforts must be made in pursuit of this task. This document is the effort made in this sense by a group of professionals from the Institutional Management Management of the Provincial Municipality of Ica (MPI) and the Team in charge of the Human Development Report of the United Nations Program for the Development (UNDP). The document basically proposes to guide the MPI in the establishment of an integrated, timely and reliable information system. The document seeks to answer the following key questions: What do we have in equipment and programs? What do we want to do to better communicate internally and externally?How do we do it? and how much can we do? And when will we do it? In simple terms, it is intended to determine the way to solve the information problem, using accessible technology for an integrated information system at the municipal level. Therefore, the considerations and suggestions outlined in this document may be practical references for other Provincial Municipalities that, in general, face this type of issue.face these kinds of issues.face these kinds of issues.
Based on the project "Implementation of the Municipal Investment System", and the progress of its execution to date, a Systems Solution Model has been conceptualized, which has been reconciled and validated with the management documents prepared by MUNICA: Project of an Investment System, Strategic Plans for Concerted Development and Institutional Plans. Likewise, the implementation strategies, the hardware and database technology platform, as well as the system maintenance plan are established.
The work has implied an awareness of the current situation and the solution model has been defined in working meetings both with MUNICA officials, in the city of Ica, and with the UNDP Human Development Report Team (INDH / UNDP). In this regard, my appreciation to the NHRI / UNDP Regional Development Specialist, Raúl Lizárraga; as well as the Manager and the technicians of the MUNICA Institutional Development Management, Wilfredo Zeña (manager), Luis Valencia Sánchez, Luis Vásquez Cornejo, Jose Jhong Fuentes and Guillermo Rebaza Llaury.
I. GENERAL
1.1 General Objective of the Report
Establish guidelines for the integrated and orderly development of information systems and databases that respond to the functional needs of the Provincial Municipality of Ica (MPI).
1.2 Specific Objectives of the Report
i. Formulate a proposal for a comprehensive adjustment of the Administrative system and the treatment of investment projects. ii. Develop a systemic analysis of the proposed system and the technological support platform. iii. Propose strategies for the implementation of the system.
1.3 Scope of the Report
It shows a general coverage with basic information to be taken into account for the implementation of the System. It has been subject to time restrictions in its preparation. The Report constitutes a consultation document for the implementation of the Information System that supports the Management of the Provincial Municipality of Ica. It constitutes a substantive approach to the design and implementation of the System.
1.4 Background
The Third Letter of Execution of the Technical Cooperation Agreement between the UNDP and the Provincial Municipality of Ica (MPI), establishes the advice on setting up an Information System for the administration and treatment of Investments. The Agreement between UNDP and Oxfam GB indicates a joint effort to promote the development of useful instruments in the management of local development. The UNDP, through the Team in charge of the Human Development Report, has regularly collected and analyzed the preliminary initiatives that, in this sense, the MPI has been formulating, mainly through its Institutional Management Department. The Report has been produced in three phases: i.Review and discussion of the Terms of Reference of the Consultancy established by the UNDP and of the existing documentation in the MPI regarding the system. ii. Direct full-time work for three days in Ica, to learn about the IT situation and the MPI processes on this subject, mainly with the Institutional Management Management team. The main reference is the document "Implementation of the Municipal Investment System" that proposes, in a preliminary way, a model of modulated and scalable execution systems that can be gradually built according to institutional priorities. This work allowed modeling the System, defining its elements down to the level of products by subsystem. The product in this phase is a Draft Proposal,for the consideration of the Human Development Team of the UNDP (NHRI / UNDP) and the Management of Institutional Management (GGI) of the MPI. iii. Review or adjustment of the Draft based on the substantive and formal observations of the MPI / GGI and the NHRI / UNDP. The product of this phase is this Report
II.INFORMATION SYSTEM FOR MUNICIPAL MANAGEMENT (SIM-ICA)
2.1 General Objective of the System
Have, in the medium term, an integrated, timely and reliable information system, with internal and external interaction, according to the availability of resources.
2.2 The specific objectives are:
i.To constitute an effective instrument to reinforce municipal management, in all its organic levels. ii. Achieve compatibility with the georeferenced information system being designed by the MPI. iii. be comprehensive, based on a single database architecture iv. develop the support of a communications platform, with total connectivity within and between the premises, with optimal response times. v. Consider different levels of security in different contexts, such as data, application, network, database and access to web pages. vi. Possess the ability to expand (scalability) according to internal and external demand. vii. Harmonize the development of the system (modularity) based on the actual availability of financial, logistical and personnel resources.
2.3 Scope
The Information System is delimited by the scope of municipal management, whose regulatory framework regulates its field of action.
2.4. Legal Basis and Institutional Documentary Support
2.4.1 Legal Basis
i. Law 776 - Municipal Taxation ii. Law 26300 - Citizen Participation iii. Law 27444 - General Administrative Procedure iv. Law 27806 - Transparency v. Law 27972 - Organic Law of Municipalities vi. Law 28032 - On Elimination of Bureaucratic Barriers vii. Resolution Comptroller's Office No. 072-98-CG - Rule 500 viii. Law of the National Public Investment System (SNIP)
2.4.2 Institutional Documentary Support
i.Project Implementation of the Municipal Investment System, October 2003. ii.Institutional Strategic Plan of the Provincial Municipality of Ica 2004-2006 iii.Concerted Local Development Plan of the Province of Ica 2004 - 2006. iv. Strategic Development Plan of the Province of Ica 2004-2008 v. Organization and Functions Manual vi. Personnel Assignment Chart
2.5. System Features
- Support the automation of the organization's operational and management processes Provide information that is used for decision-making to middle managers and senior management Provide better services to the community in general and the citizen in particular Organize, Control and interrelate the institution's computer subsystems, modules and applications at an operational and strategic level Control and maintain the communications platform through the data network Manage the use of the organization's databases Establish security mechanisms for access to information at different levels, applications, network, database and the system in general. Establish automated mechanisms to back up information.Allow the coupling of other applications according to needs. Establish interactive and friendly management, with high standards of graphic and visual design.
2.6 Current Institutional Functional Model
2.6.1 Determination of Macro-processes and Processes
In accordance with the current Organization and Functions Regulation, and in accordance with the provisions of Article 73 of the Organic Law of Municipalities, the Provincial Municipality of Ica is competent in the following macro-processes and processes:
P01.1 Perform Zoning
P01.2 Determine the urban and rural Cadastre
P01.3 Carry out urban habilitation
P01.4 Carry out the legal physical Sanitation of human settlements
P01.5 Carry out the territorial conditioning
P01.6 Basic urban or rural infrastructure
P01.8 Road
P01.9 Preserve the historical, cultural and landscape heritage
P02.1 Environmental sanitation, sanitation and health
P02.2 Transit, circulation and public transport
P02.3 Education, culture, sports and recreation
P02.4 Generate social programs, defense and promotion of citizen rights
P02.5 Citizen security
P02.6 Supply and marketing of products and services
P02.7 Civil registers
P02.8 Parks and gardens and others
P03.1 Manage Plans and Policies
P03.2 Environmental Management
P03.3 Promote environmental education and research
P04.1 Plan and provide infrastructure for local development.
P04.2 Encourage private investment in projects of local interest.
P04.3 Promote the generation of employment and the development of urban and rural micro and small enterprises.
P04.4 Encourage crafts.
P04.5 Promote sustainable local tourism.
P04.6 Promote rural development programs.
P05.1 Promote, support and regulate neighborhood participation in local development.
P05.2 Establish inspection instruments and procedures.
P05.3 Organize the registries of social and neighborhood organizations in its jurisdiction.
P06.1 Organize, administer and execute local programs for social development and the fight against poverty.
P06.2 Manage, organize and execute local assistance, protection and support programs for the population at risk and others that contribute to the development and well-being of the population.
P06.3 Establish channels of agreement between neighbors and social programs.
P06.4 Disseminate and promote the rights of children, adolescents, women, the elderly and people with disabilities.
P07.1 Promote prevention and rehabilitation programs in cases of drug use and alcoholism
P07.2 Promote international cooperation agreements for the implementation of programs for the eradication of illegal drug use.
P08.1 Direct the Institution
P08.2 Manage Information and Communication
P08.3 Manage Human Resources
P08.4 Manage Goods and Services
P08.5 Manage Financial Resources
From these processes we can see that from P01 to P07 are processes that support services, infrastructure and promotion of opportunities, and P08 directly supports the administration and direction of the municipality. The municipal Information System must have as functional support these 8 operational categories. You should not avoid any if you intend to be comprehensive.
This comprehensive coverage is outlined in Figure 1 below.
There is an interaction between all the macro-processes, mainly with “Administer the Municipality”, which provides the human, logistical and financial resources to support the performance of the other processes.
To handle these prioritization assessments, it is important to take into account the following strategic information, according to the Organization and Functions Regulation (Municipal Ordinances No. 021-2003-MPI, and No. 040-2003-MPI):
The INSTITUTIONAL STRATEGIC PLAN 2004-2006, which establishes the following definitions:
"MISSION
Promote economic development and the provision of services, with opportunity and efficiency. "
"INSTITUTIONAL VISION
The Provincial Municipality of Ica is a democratic organ of the local government. Leading institution that promotes the sustainable development of the province through strategic productive activities to satisfy and improve the quality of life of the population, with the committed participation of those involved and with competitive human capital. "
"STRATEGIC ROLE OF THE INSTITUTION
Promote a safe and balanced habitat for life, conduct a rational and efficient territorial occupation; and generate operational facilities that support the social and economic achievement of the population, within the framework of a promoter management. "
DEVELOPMENT MANAGEMENT
Promote efficient and effective public management in promoting the development and administration of public services. Its partial strategic objectives by subprogram are:
- URBAN MANAGEMENT ORDER.- Generate updated legal planning instruments that allow promoting a planned, rational and efficient territorial occupation of the province of Ica, based on the needs of its urban and productive development, within a framework of respect for human development MANAGEMENT SYSTEMIC STRUCTURING.- Systematize provincial strategic planning INSTITUTIONAL MANAGEMENT.- Optimize the organizational behavior of the MPI, and improve its equipment for a better service to the city PROMOTION OF HUMAN DEVELOPMENT.- Promote cultural integration, the development of regional identity, and the cultivation of cultural manifestations, in a framework that allows better communication between Local Government and Population.
The ACTIVITIES AND PROJECTS of the “Development Management” Program that are directly related to this plan are the following:
- Cadastre Environmental evaluation (urban area).
- Operational Micro Zoning Study
- Data management system Creation and implementation of the Municipal Investment System
Based on this information, the Municipal Information System is defined.
III. BASIC ANALYSIS AND PROPOSALS
3.1 Identification and description of existing Systems
According to the Information Requirements document (annex 1), and the work meetings with the Institutional Management Management team, we found the following situation:
3.1.1 Computer Equipment
Tables 1 and 2 show a ratio of 7.7 people per computer (701/91). This is mitigated when the blue-collar staff is not considered for carrying out operational field operations to 4.3 people per computer, which means that there is theoretically a high rate of people who must wait to use this tool: on average two to three people in each area.
There is a Ground Well that is not linked to the general electrical system. There is only one earth well connection that starts from the IT area, to connect the MEF SIAF. The IT Network, as shown in Table 3, has 56 points installed, 38 used and 18 free, connected with 3 D-Link switch, at 10/100 speed. It runs smoothly.
The Internet connection is in charge of the Internet Provider, such as Telefónica del Perú, through Speddy 600 services, for 10 computers in various offices. It does not have Racks or Match Cords.
3.1.2 Software
- He is currently working on an application for Payroll Management, prepared by the IT Submanagement, developed in Visual Fox Pro 6. An application for Documentary Procedures, developed in visual Basic 6, is in process for the entry, exit, registration and monitoring of The documentation that is processed in the Only Pentium IV equipment, recently acquired, have OEM licenses, of the professional XP operating system. The remaining ones do not have it, so it is violating Legislative Decree No. 822, Copyright Law, effective as of May 1996. (See Annex 2). This situation must be corrected. There is a Microsoft Office 2000 license and a Microsoft Office 97 license, for electronic work of Word and Excel. This means that only two computers can work with this software.The rest are not, therefore, legislative decree No. 822, the Copyright Law, in force as of May 1996, is being violated. (See Annex 2) For the Cadastral Project, the following software licenses are available: 01 Red Hat Linux Version 308 License Oracle 9i Edition One01 Licenses Autocad Map License 200501 Arc View License
According to the report on the Inventory of Computer Equipment (Annex 6), 16 Pentium IV computers have been assigned to the project, which means that several computers in this project do not have an operating system license, and other computer programs. Therefore, legislative decree No. 822, the Copyright Law, effective as of May 1996, is being violated (See Annex 2).
3.2. Adjustment to the current Organizational StructureThe Provincial Municipality of Ica, according to its recently modified organic structure (see Figure 1), has a Computer Support Sub-management, whose functions are supportive and depend directly on the Administration Management. The Organization and Functions Regulation is in the process of being updated. However, provisionally, through Mayor's Office Resolution No. 0162 - 2005 - AMPI, the administrative support aspects have been separated (maintenance of networks, equipment, software, use of licenses, execution of security policies, etc.), of those that correspond to the field of advice (policy design, rulemaking, advice, etc.). Likewise, the current functions of the Institutional Development and Statistics Submanagement,dependency to which the functional field of the former Systems Sub-Management has been incorporated. (First Article, numeral 2. of Mayor's Resolution No. 0162 - 2005 - AMPI), has as functional objectives:
- Ensure that the information flows of the organizational processes are supported by information systems developed, implemented, integrated and maintained. Provide technical advice in the computer field. Provide security to the information produced by the institutional information system. Propose standards that regulate the provision, management and improvement of computer equipment, software, networks, by the Provincial Municipality of Ica.
From this situation we find the following aspects to be considered in the process of implantation and maintenance of the systems: i. The objective function of the systems area is distributed in two separate units, which implies a lack of direct coordination and organic coherence in the performance of the development and maintenance functions of the information systems and the technological platform. This lack of unicity of command does not favor the implantation process because there may be divergent criteria. ii. There is no systems area with leadership, coordination at the highest level, which does not help the process of implementation and monitoring of the Municipal Information System. iii.The implementation process implies having a human team that, even when it has two functions,is organically integrated permanently. One that implants the system and one that maintains it. As of its implementation, the system will have new technological functions: database administration, web page development, network security, among others.
Figure 2 Current Organic Structure
The current Organic Structure comprises:
High direction
Mayor's Office
General management
Consultative and Coordination Bodies
Provincial Local Coordination Council
Community Committees
Citizen Security Committees
Glass of Milk Committee
Civil Defense Committee
Control Body
Internal Control Management
Organ of Judicial Defense
Public Prosecutor's Office
Advisory Bodies
Institutional Management Management
Legal Advisory Management
Support Bodies
General Secretary
Administration management
Line Bodies
Economic and Social Development Management
City Services Management
Urban Development Management
Decentralized institutions of the MPI
Municipal Box
Festival Company
Municipal Drinking Water Company (EMAPICA)
Tax Administration Service (SAT)
Faced with this situation, two alternatives are proposed for the organic location of the unit in charge of the system, with an integrative vision:
The first alternative consists of creating a Systems Management, with a direct coordination line with the Municipal Management (see figure 2). This will make it possible to overcome the aforementioned problems, such as the lack of sole command, leadership and functional coherence or for the development of the activities and tasks that are necessary for a smooth implementation of the Municipal Information System.
This Management would have two Deputy Managements:
- Systems Development Deputy Management; Technological Support Deputy Management
The Systems Management would have the following functions:
- Support the implementation of the Municipal Information System Prepare and propose systems plans and projects for the development of the Institution Design, develop and maintain the information systems of the Municipality Propose, supervise and coordinate integrated solutions based on information systems as responses to the data processing needs of the user areas Evaluate new technological tools related to hardware, software and communications (their applicability and standards), to increase productivity and quality of the Recommend the ideal platform for each project developed or advised by The management.Support the Supply Sub-management in the steps prior to the acquisition of software licenses and maintenance of the updated inventory of computer and communication equipment. Maintain the Municipality's technological platform operational, in order to guarantee the continuity of its operations. Monitoring and evaluation of external computer services in coordination with the user area. Prepare and monitor standards for System Development and production indicators for own and external services.Prepare and monitor the System Development standards and production indicators for own and external services.Prepare and monitor the System Development standards and production indicators for own and external services.
The Systems Development Deputy Manager would have the following relevant functions:
- Supervise the development of software applications to optimize the management of the different user areas Formulate directives and standards for the Development of Systems and Databases Evaluate computer procedures and methods that optimize the Systems Supervise the development and updating of standards for the Development and Documentation of Systems, in accordance with the standards of the National Control System, auditing and approved methodologies Direct and control the execution of Systems Development projects and the activities inherent to user support provided to all areas Directing, coordinating and supervising the maintenance of the Institution's Internet Portal in the technical aspect of systems in coordination with the Systems Manager and the Managements involved.Ensure compliance with the legal regulations and procedures applicable to the operation of the Deputy Management under his charge.
The Technological Support Sub-management would have as relevant functions:
- Design, propose and implement policies and actions for preventive maintenance and support of the equipment and programs available to the entity, in order to ensure their optimal performance Manage the communications network, prepare update plans and performance measures Design and manage Controls to safeguard the source data of process operations and preserve their integrity Establish security mechanisms in the programs and data of the systems, as well as protect information processed in the entity, guaranteeing its integrity in accordance with current regulations Prepare a plan risk and computer contingency, establishing the procedures to be used to avoid interruptions in the functioning of the systems. Permanently update the Municipality's Electronic Portal.Develop and implement intranet techniques in the Institution, in order to strengthen the coordination, control and efficiency of internal communications Manage the inventory of computer equipment and software licenses Provide computer support services to the other organic units of the city Hall.
Figure 3
Profile of the Systems Manager Position Holder
- Professional in Systems engineering or other related profession or specialization. Solid knowledge on conducting computer projects and implementation of information systems. Knowledge and experience in municipal management, no less than 3 years. Capacity for leadership and team work management. Ability to work intense hours and under pressure.
Position Profile Assistant Manager of Systems Development
- Professional with a degree in Systems Engineering with experience and knowledge in information technology or similar functions. Knowledge and experience in municipal management, not less than two years. Extensive knowledge about current regulations and technical processes of the Administrative Systems of the Public Sector. leadership and teamwork management Ability to work intense hours and under pressure.
Profile of the Technological Support Position Holder
- Professional graduated in Electronic Engineering, Computer Science or other profession related to the position Studies and / or experience in suitable subjects for the functions of the position, not less than 2 years Knowledge in Networks, Contingency Plan and management of software tools Knowledge and Experience in municipal management Ability to lead and manage team work Ability to work intense hours and under pressure.
The second alternative is established as an immediate possibility, as long as the situation of the institution in terms of resources does not allow the first alternative to be made viable. In this sense, we consider that a Systems Deputy Management should be established, depending on the Institutional Management Management, because this management has initial responsibility for the implementation of the system implementation.
Through this alternative, the development functions of the System and Technological Support are concentrated in a single area. This transitory formula would make it possible to better define and articulate the responsibilities inherent to each of these elements.
With the implementation of the system, the functions of this area will increase over time, which implies providing it, at least progressively, with the minimum necessary conditions for its future growth, such as:
- Adequate spaces that allow to contain the equipment and personnel assigned to the functions of the System; including spaces for equipment maintenance, server room, meeting and training room Security of the facilities for the entry and exit of people Security at the level of electrical and data installations, through energy protection. temperature environmental conditions for servers.
3.3 Central vision of the System
Based on the information obtained through a systemic approach, a Municipal Information System has been conceptualized (see Figure 4) that is modularly assembled with subsystems that will allow satisfying the information and communication requirements with families, institutions, companies and the world in general. This responds, in general, to the proposed institutional business model.
The Municipal Information System is therefore composed of the following subsystems:
- Administrative Management SubsystemFunctional Management SubsystemInvestment Management SubsystemStrategic Management SubsystemDecentralized Management SubsystemGeo-referenced Management SubsystemVirtual Management Subsystem Institutional Management Subsystem
The Municipal Information System is defined as a set of modular design subsystems, on an internal and external network platform, scalable with open architecture and with database support.
According to the requirements, the following solution is proposed:
- To improve municipal management: Build the Administrative Management Subsystem To improve local functional information: Build the Functional Management Subsystem General information: Build the Institutional Management Subsystem For the preparation of public decisions:
- Build Management Subsystem Investment build Subsystem Decentralized Management Build Management Subsystem Strategic
- To provide Advanced Services
- Build the Georeferenced Management Subsystem Build the Virtual Management Subsystem
Through the following Figure 5, the relationship that exists between the business model that the Municipality considers normatively and strategically can be established; with the Municipal Information System raised in this Report.
Through the relationship of the macro-processes and the subsystems, we can establish the level of adjustment that the Solution System shows with respect to the business model.
3.4 Content of the Subsystems
According to Figure 6, the Municipal Information System must include the following Subsystems, hierarchical functionally: the first 2 constitute the major support. The 5 central subsystems have a fundamentally operational character. The one that appears at the base is fundamentally communicative (internally and externally).
3.4.1 SUBSYSTEM OF ADMINISTRATIVE MANAGEMENT
It consists of the construction of modules that allow relating the processes of the Administrative Systems. It contains the following modules:
- Budget Personnel Logistics (Includes Warehouse) Treasury Documentary Administration Income
The detail of each module (according to Figure 7), is made at the application and product level. Also, the most important products proposed are shown.
This subsystem allows satisfying the information requirements of the following macro-process, its processes and sub-processes that it involves:
P08.1 Direct the Institution
- Manage legal issues Formulate and execute strategy Establish policies and regulations Formulate and control the Operational Plan Prepare the Budget Develop and promote the institutional image
P08.2 Manage Information and Communication
- Evaluate the satisfaction of residents and users Develop the information technology architecture Develop information systems Implement information technology Provide information services
P08.3 Manage Human Resources
- Selecting and hiring staff Registering staff Assigning and posting staff Assessing, controlling and promoting staff Training staff Manage compensation Manage workers rights Provide social welfare
P08.4 Manage Goods and Services
- Manage fixed assets Store spare parts and materials Purchase goods Hire services Receive donations Make donations
P08.5 Manage Financial Resources
- Manage the Budget Control accounts receivable Manage accounts payable Manage funds Assign costs of services Prepare Financial Statements
These processes are complemented by other subsystems, such as the Strategic Management Subsystem, Institutional Management, Decentralized Management and Virtual Management.
3.4.2 FUNCTIONAL MANAGEMENT SUBSYSTEM
It consists of the construction of modules that allow relating the administrative processes of an operational nature related to the line bodies of the institution. This subsystem contains the following modules:
- Urban DevelopmentTransportHealthPublic CleaningParks and GardensCitizen SecurityCivil RegistryCivil DefenseLibrarySportsCommercializationSocial AssistanceCitizen Participation
The detail of each module (according to Figure 8), is made at the application and product level. Also, the most important products are displayed.
This subsystem allows satisfying the information requirements of the following macro-processes, their processes and sub-processes that it involves:
P01.1 Perform Zoning
P01.3 Carry out urban habilitation
P01.4 Carry out the legal physical Sanitation of human settlements
P01.5 Carry out the territorial conditioning
P01.6 Basic urban or rural infrastructure
P01.8 Road
P01.9 Preserve the historical, cultural and landscape heritage
P02.1 Environmental sanitation, sanitation and health
P02.2 Transit, circulation and public transport
P02.3 Education, culture, sports and recreation
P02.4 Generate social programs, defense and promotion of citizen rights
P02.5 Citizen security
P02.6 Supply and marketing of products and services
P02.7 Civil registers
P02.8 Parks and gardens and others
P05.1 Promote, support and regulate neighborhood participation in local development.
P05.2 Establish inspection instruments and procedures.
P05.3 Organize the registries of social and neighborhood organizations in its jurisdiction.
P06.1 Organize, administer and execute local programs for social development and the fight against poverty.
P06.2 Manage, organize and execute local assistance, protection and support programs for the population at risk and others that contribute to the development and well-being of the population.
P06.3 Establish channels of agreement between neighbors and social programs.
P06.4 Disseminate and promote the rights of children, adolescents, women, the elderly and people with disabilities.
P07.1 Promote prevention and rehabilitation programs in cases of drug use and alcoholism
P07.2 Promote international cooperation agreements for the implementation of programs for the eradication of illegal drug use.
These processes are complemented by other subsystems, such as the Strategic Management Subsystem, Georeferenced Management and Investment Management.
3.4.3 STRATEGIC MANAGEMENT SUBSYSTEM
It consists of the construction of modules that allow to relate the strategic processes and their operational implementation, this subsystem contains the following modules:
- Planning Results Measurement Legal Regulations Processes Statistics Market Analysis Financial Planning
The detail of each module (according to Fig. 9) is done at the application and product level. Also, the most important products are displayed.
This subsystem allows satisfying the information requirements of the following macro-processes, their processes and sub-processes:
P04.2 Encourage private investment in projects of local interest.
P04.3 Promote the generation of employment and the development of urban and rural micro and small enterprises.
P04.4 Encourage crafts.
P04.5 Promote sustainable local tourism.
P04.6 Promote rural development programs.
P05.1 Promote, support and regulate neighborhood participation in local development.
P06.3 Establish channels of agreement between neighbors and social programs.
P08.1 Direct the Institution
- Manage legal issues Formulate and execute strategy
- Establish policies and standards
- Formulate and control the Operational and Strategic Plan Develop and promote the institutional image
P08.5 Manage Financial Resources
- Manage accounts payable Manage funds
- Assign costs of services
- Prepare the Financial Statements
3.4.4 DECENTRALIZED MANAGEMENT SUBSYSTEM
It consists of the construction of modules that allow the relationship between municipal companies and decentralized bodies subjected to the treatment of business treatment entities, this subsystem contains the following modules:
- SATEMAPICACAJA MUNICIPALSHOW AND FESTIVAL COMPANYFUNDACION ICA
The detail of each module (Figure 10) shows the level of application and products.
This subsystem allows satisfying the information requirements of the following macro-processes, its processes that preferably involve:
P04.2 Encourage private investment in projects of local interest.
P04.3 Promote the generation of employment and the development of urban and rural micro and small enterprises.
P04.4 Encourage crafts.
P04.5 Promote sustainable local tourism.
P04.6 Promote rural development programs.
P08.1 Direct the Institution
P08.2 Manage Information and Communication
P08.5 Manage Financial Resources
3.4.5 INVESTMENT MANAGEMENT SUBSYSTEM
It organizes the construction of modules that allow to relate the information required for the monitoring of the factors that affect environmental sustainability, economic - productive activity and the development of projects for public and private investment. It contains the following modules:
- Economic - Productive Natural Resources and Environment Project Formulation and Evaluation
The detail of each module (Figure 11) shows its applications and products.
This subsystem allows satisfying the information requirements of the following macro-processes; preferably:
P03.1 Manage Plans and Policies
P03.2 Environmental Management
P03.3 Promote environmental education and research
P04.1 Plan and provide infrastructure for local development.
P04.2 Encourage private investment in projects of local interest.
P04.3 Promote the generation of employment and the development of urban and rural micro and small enterprises.
P04.4 Encourage crafts.
P04.5 Promote sustainable local tourism.
P04.6 Promote rural development programs.
P05.1 Promote, support and regulate neighborhood participation in local development.
P06.1 Organize, administer and execute local programs for social development and the fight against poverty.
P06.2 Manage, organize and execute local assistance, protection and support programs for the population at risk and others that contribute to the development and well-being of the population.
P08.1 Direct the Institution
P08.5 Manage Financial Resources
3.4.6 GEOREFERENCED MANAGEMENT SUBSYSTEM
It contains modules that allow to relate the economic-social activity of the province, to a geophysical reference:
- Cartography Microzoning
The detail of each module (according to Figure 12), is made at the application and product level. Also, the most important products are displayed.
This subsystem allows satisfying the information requirements of the following macro-processes, their processes; preferably:
P01.1 Perform Zoning
P01.2 Determine the urban and rural Cadastre
P01.3 Carry out urban habilitation
P01.4 Carry out the legal physical Sanitation of human settlements
P01.5 Carry out the territorial conditioning
P01.6 Basic urban or rural infrastructure
P01.8 Road
P01.9 Preserve the historical, cultural and landscape heritage
P03.1 Manage Plans and Policies
P03.2 Environmental Management
P03.3 Promote environmental education and research
3.4.7 INSTITUTIONAL MANAGEMENT SUBSYSTEM
It contains modules of strategic utility for decision making:
- On Line Consultations Institutional Competitiveness
- Impacts
- Institutional Image
The detail of each functional module appears in Figure 13.
This subsystem allows satisfying the information requirements of the following macro-processes, its processes that preferably involve:
P08.1 Direct the Institution
- Formulate and execute strategy Establish policies and standards
- Develop and promote the institutional image
3.4.8 VIRTUAL MANAGEMENT SUBSYSTEM
Defines modules that allow user interaction with SIM information. The Web technology interfaces are located in this subsystem:
- Web PortalIntranet
- Extranet
The application detail of each module appears in Figure 14.
This subsystem allows satisfying the information requirements of the following macro-processes, their processes and sub-processes that it preferably involves:
P08.1 Direct the Institution
- Manage legal issues Formulate and control the Operational Plan
- Develop and promote the institutional image
P08.2 Manage Information and Communication
- Evaluate the satisfaction of neighbors and users Provide information services
P08.4 Manage Goods and Services
- Acquire goods Contract services
P08.5 Manage Financial Resources
- Manage the Budget Control Accounts Receivable
- Manage accounts payable
- Manage funds
3.5 THE VALUE ADDED OF THE SYSTEM
The proposal has an added value in the following aspects:
OF PROCESSES
- It establishes a complete and perfectible model according to the requirements. Systematize all institutional processes.
DECISION MAKING
- Being recursive in information feedback, it manages a Strategic Management subsystem that will allow modeling and simulation of possible scenarios for the determination of decisions, supported by a statistical module for the collection and processing of information, with the ability to process censuses and surveys. Georeferenced It has a Financial Planning module, for predictive simulations in the administration of public and investment funds.Through the Institutional Management Subsystem, it has interactive consultations at a tactical and strategic level for decision making
OF TECHNOLOGY
- The technological platform will be based on connectivity between and within municipal premises, The information is supported by the administration of a single database The modules will be developed with the latest generation language through web development The internal management of the Information is supported through an intranet and external information through the extranet with citizens, central and regional governments and companies.
3.6 SYSTEM IMPLEMENTATION
Considering Figure 6, where the Municipal Information System is shown by modules, with which the unmet or poorly attended requirements will be covered, Table 4 defines the Implementation Schedule, 44 modules of automation of the business processes of the institution. The proposal shows a chain of subsystems and corresponding modules: current situation, future projection, implementation period, software cost and implementation monitoring.
A prioritization was made (+ high = 1, + low = 6) according to the coordination made with the technical team of the modules; according to the estimated organizational needs, and its execution was scheduled for a period of 36 months, from May 2005 to April 2008. At the end of the period, the Provincial Municipality of Ica will have an integrated system that provides information support required for operations in its different processes: service to the neighbor, decision making and management monitoring.
The characteristic of being comprehensive, of being obtained through the modular implementation of the information systems architecture and of having a parallel development of databases following the data architecture, ensures the efficiency of the system and the consistency of the information.
The deadlines for the development of the computer modules and the schedule were defined based on an estimate of the software resources and monitoring of the development of each module, for which the average supervision hours that will be devoted to monitoring the implementation of the module by one person. Likewise, in estimating software creation through outsourcing, it allows a program in language for the web, tailored to the institution's requirements. Average costs have been estimated according to the complexity of the tasks and products.
The estimated cost of the implementation of the modules for the acquisition of the software is S /.277,100 and for its follow-up and monitoring is S /. 146,132 nuevos soles; making a total of S /. 423,232 over a 36-month horizon. For the first semester of the year1, the implementation of the Administrative Management Subsystem, with respect to the Software Cost is zero, due to the fact that, according to the coordination carried out with the Ministry of Economy and Finance, they are already advanced, for the delivery and training of your computer programs.
|
3.8 NETWORK PLATFORM (HARDWARE)
- It has been proven that the various premises of the Provincial Municipality of Ica are not completely connected. This hinders the Institution's own operations, as well as increases the costs of communication between the personnel of the various areas. This deficiency does not allow the integration of the personnel of the areas not connected to the internal mail and internet system of the Municipality, as well as to the Network modules that will be implemented. There are no electrical plans. They must be made. In the minimum proposal, all current communications equipment has been reused, redistributing them and adding some others that will improve the current capacity of the NETWORK. The solution proposed for the interconnection of the premises is based mainly on wireless technology by Radio frequency,which is being used more and more and has the advantage of being more economical for greater bandwidths.Total integration of the premises of the Municipality is very important since only in this way can the following elements be properly exploited: InternetIntranetInternal MailCentral Digital TelephoneServersBases Centralized and Distributed Data WEBE page computer equipment, among others.
3.9 STRATEGIES
3.9.1 For Management
- Train management level users in the use of information technology.
- Create a Systems Committee at the highest level, which enables the adequate development and implementation of the Systems modules for the benefit of the Institution and the neighbors. Implement the redesign of the organizational structure of the IT area.
3.9.2 For the Administration
- Keep staff permanently updated with training courses that serve to apply them in the best development of the institution. Improve access to information, especially those that allow the interconnection of systems with SAT, RENIEC, Local Municipalities, SUNARP, MEF, among others.
- Keep the licenses of the commercial software, operating system, databases, office automation among others updated.
- Evaluate the true need for computer equipment by analyzing each process in terms of organization and work methods and applying Reengineering techniques to later redefine the number of positions, shifts and computational resources actually required to meet the operational needs of the company. institution. This activity must be carried out by the team in charge of the implementation of the System, with the advice of UNDP, which must establish the characteristics of the hardware required based on the requirements posed by the implementation progress.
- Streamline bureaucratic processes that allow you to quickly remove disused equipment.
- Seek outsourcing of software development and maintenance processes.
3.9.3 For Hardware Platform
- Standardize computer equipment in computers and printers. Regarding computers, use the latest generation computers, which improves the performance of the network in response times. Likewise, with respect to printers, it is suggested to use laser printers for work groups (areas), this allows saving materials.
- Renew and / or expand computer equipment (Computers, Printers, Servers, communication equipment) to respond to the operational requirements of the MPI.
- Outsource the computer equipment maintenance service Perform the interconnection of all institution premises to improve information flows in its delivery, control and dissemination Use available servers for the first stage of implementation, considering that one is used for The bone network is the Production Server, and the other must be available as the Development and / or Testing Server of the new modules to be carried out. With the advancement of the System implementation stages, the number of Institution servers, according to their function, as follows: Intranet Server Database Server (Alternative for ORACLE Database) Backup Server
The technical specifications of the servers are based on the provision of the service to be provided, information load, type of database that will be used, and number of users. It is suggested that these teams be of recognized brand, and with technical support 365 days a year.
- Make a survey of the electrical installations of the premises of the Municipality and the LAN Network, to evaluate the current intensity loads and better distribute its fluid.
3.9.4 For the Software Platform
- Standardize the programming of the Municipal Information System modules, through a programming language for the web, which will facilitate the access and availability of information according to the current trends. Due to the fact that they have Oracle Database licenses, the development platform can be kept standardized with Oracle as the database engine and Visual Basic Net as developer. Generate an Institution Intranet in order to incorporate all the modules to be developed. There is an alternative to take into account Regarding software development, such as the use of free software, taking LINUX as the operating system and programming software such as PHP, Flash or Dreamweaver. The direct advantage is the licensing cost which is minimal.
3.9.5 For data security
- Seek to outsource the backup custody service to ensure the integrity of all the historical and current information of the Municipality. Provide hardware and software tools to restrict elements that damage the provision of computer network services, such as viruses and hackers. and others. Especially be careful when accessing the Internet. Prepare access levels in the different network instances, databases, modules, applications, queries and others.
3.10 INTERNAL LIMITATIONS TO EXPIRE
- Existence of resistance to change. This must be overcome by seeking to create solidarity awareness, new motivations and support at different levels of the organization. Lack of budget availability. It can be overcome through inter-institutional agreements with Universities, for example, to provide human resources with graduates of Systems Engineering Faculties interested in developing professional practices. Lack of training in the new technology by users. This implies creating a massive training of personnel in these tools, for which the knowledge of existing professional personnel can be used.
