A
PROJECT SYNOPSIS ON
Implementation of ERP
Submitted to
Inderprastha Engineering Collage Ghaziabad
Under The Guidance Submitted By
Mr. Amarjeet Singh Sushil Kumar Mishra
Project Manager MCA 6th SEM.
Ramco System Roll No:
0703014103
Table of Contents 1. Title of the Project
2. Introduction and Objectives of the Project 3. Project/Category
4. Tools/Platform, Hardware & Software requirement specification 5. Complete Structure of the Program
a. Analysis (DFDs)
b. Modules and their brief description c. Data Structure (Tables)
d. Process Logic of Each Module e. ER Diagram
f. Security Mechanism
Title
Implementation of ERP
Modules1.
HRM(Human Resource Module),2.
GL(General Ledgers), 3. DLLIntroduction
Ramco is dedicated to meet the complex needs of your enterprises by providing agile, global-class enterprise solutions aligned to your IT needs and business goals. Ramco solutions help you redefine business management and operational
excellence through innovation and refined business processes, while driving competitive differentiation.
This is possible because of extensive experience in delivering comprehensive solutions and services to empower every aspect of business operations. By deploying ramco solutions you can effectively streamline and integrate your business processes, optimize entire supply chain and quickly identify customer needs, eventually contributing to an improved bottom line.
Ramco Virtual Works forms the foundation on which all our enterprise solutions products and services are built and delivered. Based on SOA standards, our solutions enable stability and rapid change within your business and can give your organization greater agility than ever before.
Our span of enterprise solutions include packaged products, custom built applications and OnDemand applications.
Objective
Objectives are the major high-level characteristics that can have a great impact upon the success of an ERP project. The objectives include characteristics such as:
Speed
Scope
Resources
Risk
Complexity
Benefits
Speed
The speed of a project is directly related to the amount of time that a company has before the completion of the ERP implementation or the amount of time that it would like to take for the implementation. The speed of the project in the context of this chapter is how much time the company would like to take in implementing the system. The amount of time that the company actually takes may be dramatically different. The amount of time that the company would like to take should be figure used when developing a project plan.
Scope
The scope of the project includes all of the functional and technical
characteristics that the company wants to implement. A company installing a full-fledged ERP system would have a much greater scope than a company installing a few modules.
Resources
Resources are everything that is needed to support the project. This
includes people, hardware, software systems, technical support and consultants. All the different resources of an implementation have one thing in common-money.
Risk
The risk of a project is a factor that impacts the overall success of the ERP implementation. Success is measured by factors such as overall user acceptance, return on investment (ROI), time to implement etc. High-risk situations are less likely to possess these characteristics.
Complexity
Complexity is the degree of difficulty of implementing, operating and maintaining the ERP system. Companies of different sizes, business environments and organizational cultures have different levels of complexity. A multinational corporation that has production facilities and team spread across different parts of the world and working in different time zones is generally much more complex than a company with 50 employees occupying one geographical location.
Benefits
Benefits are the extent to which the company will utilize functionality of the ERP system for software development, maintenance and other support activities. ERP tools automate almost all aspects of organization’s activities; they make the job of the employees, managers and other stakeholders easy and improve the development and productivity. Better integration of the ERP system with the product design, development and production will result in high quality products, reduction in number of defects, faster problem resolution, quicker incorporation of enhancements, better customer service, etc. which leads to improved brand image, which will lead to an increase in market share and profits.
Tools/Platform, Hardware & Software requirement
specification
Operating System
:
Windows Server 2003, XPRDBMS
:
SQL Server 2000, 2005, 2008Server
:
HP DL380 G6 Server2 QC Processor / 32 GB Memory / 1.5 TB RAW Space ProLiant DL380G6 Base Model
(1) Quad‐Core Intel Xeon E 5530 Processor
(2.4GHz)/8MB (1 x 8MB) Level 3 cache/6GB (3 x 2 GB) PC3‐10600R (DDR3‐1333)
Registered DIMMs /Two HP NC382i Dual Port Multifunction Gigabit Server
HDD :
HP 300GB 3G SAS 10K 2.5in DP ENT HDD 5 HP Slim 12.7mm SATA DVD Optical Kit 1 HP 512MB P‐Series BBWC Upgrade 1HP 460W HE 12V Hotplg AC Pwr Supply Kit 1
CONTEXT LEVEL DFD
Applicant Tracking
Hire Process
Rehire Process
Personal Details
Organization
Human
Resource
Management(
HRM)
Level1 DFD For PERSONAL Module Customer PERDB 1.0 Personal Details 3.0 Employme ntCompsen sation 2.0 Applicant Tracking 4.0 Fund 5.0 Grievance Administration 6.0 PERDB PERDB 6.0 Grievanc e Entry Response 8.0 Man Power 10.0 Succession Planning 11.0 Appraisal 12.0 Loan 3.0 Time Managemen t 1.0 Log In Existing User
Modules and Their Brief Description
Organizational planning
To help you plan for the future, Ramco HRMS is packed with four planning tools to cater to the enterprise-wide planning needs of salary, manpower, succession and career. All planning activity is facilitated with a planning chart and a planning period. You have the option to generate unlimited plans before arriving at the final figures.
Manpower planning. Ramco HRMS captures data pertaining to existing and planned staffing; using which you can project future manpower demand and plan
appropriately. It has been made easy with a tree-like representation of the manpower planning needs at each level of the organization. It also facilitates enterprise wide manpower planning by taking inputs from functions and line
managers regarding manpower requirements of their departments or sections. The system then collates all such requests through the export / import facility. Any changes in the planned manpower at the lowest level is aggregated and reflected at all the levels above it through roll-up. Highlights the planned manpower, actual manpower and variance. Due to change in manpower, budgeted changes in salary outflow is highlighted in the manpower chart.
Succession planning
Succession planning is crucial to ensure the continued growth of your operations. Ramco HRMS takes into consideration all the potential replacements and ensures that the chosen successor has the required skill-set to assume responsibilities of the new job. The succession planning feature in Ramco HRMS ensures that suitable managers are available to fill vacancies created by promotions, transfers or
employee exit. It also ensures a personnel pool to fill in new positions likely to be created in the future. For an effective and comprehensive succession planning process, the system fetches information from the career plans, skills required for position and employee skills to aid in the succession planning process.
Career planning
Career planning charts out the evolution of employee in the organization with respect to the functions and position the employee is capable of handling. It
monitors employee career movement and is linked to succession planning. This can also be the outcome of the appraisal process. It is an effective tool to harness the potential of your employees.
Salary planning
Takes into consideration the organization structure, appraisal and compensation details. Option to link salary planning with manpower planning to get a complete picture of the compensation requirements during planning.
Easy, tree-like representation of the salary planning needs at each level in the Organization. Any change in the planned salary is reflected at all the levels above it through roll up. Define salary budgets at each planning level. Build in rules for apportionment of increase of salary. Display external equity process to compare salaries with another organization or the industry standards.
Internal equity process to compare salary given to employee within the organization
Time management
Time management in Ramco HRMS facilitates creation of an employee-specific calendar which specifies the availability of an employee by taking into account current employee assignment(s),current shift, weekly off, and holidays.
Maintains details in terms of change of shifts owing to personal reasons or other contingencies, leave of absence, late arrivals and so on
Flexible time management that allows detailed scheduling with multiple shift patterns. Employee leave is linked to the calendar due to which one can view the employee availability at any time. Using this one can effectively assess ability and even plan for substitution based on skill match
Leave or vacation management is workflow enabled and provides quick and easy Application, authorization, and maintenance of balance. Supports attendance entry from various sources such as direct entry, rule-based and
Recruitment
HR managers need to identify employee skills needed currently, and more
importantly, skills needed in the future. Subsequently, they must decide on how to acquire those competencies for the organization. To aid this, Ramco HRMS provides a comprehensive applicant tracking system covering resume entry, interview
scheduling, applicant rating, and selection. This combination of
Features enables HR managers recruit the right person for a job and can
significantly reduce employee attrition due to a poor fit between the job and the person. Provides maintenance of unlimited resumes, selection based on user-defined objectives
and evaluation criteria, reference checks and pre-employment tests Takes into consideration the vacancies in the organization. Handles the necessary
documentation work through interfaces with Microsoft Word.
Hire process that 'inducts' employee into the system. All the information gathered during the recruitment process is taken as the employee record on hiring of the personnel. Eliminates duplicate data entry and reduces human error.
Database Structure
In Ramco e.Application every Modules have related databases.
The PERDB (Personal Database) and FMS (Financial Management System) contains more than 50 tables. These tables are created during the Development of ERP. The Technical team creates temporary tables against the base tables.
The SQL Script is run during the installation of SQL Server for the compatibility of the Ramco e.Application.
The main tables that I have used in Customization and in EDK are: 1. pur_gi_header
2. pur_gi_details 3. pur_po_header 4. pur_gi_header
5. a04_appraisal_header
In Ramco e.Application two types of tables are used: 1. Default tables
2. SQL Tables
The Default tables contain the base tables or master tables, while the SQL Tables are created during the development of EDK.
The SQL Tables have 3 modes:
1. 0-> for Add Mode 2. 1-> for Modification 3. 2-> for Delete Mode. SQL Tables have three common modes:
1. company_code varchar(256), 2. location_code varchar(256),
3.
Key_value varchar (256).Every customization or Report contains the Stored Procedures. In Ramco e.Application Procedures contains 7 numbers of parameters, these are the following.
2. screen_id varchar(256), 3. company_code varchar(256), 4. location_code varchar(256), 5. language_id smallint, 6. mode smallint, 7. key_value varchar(256)
EDK (Extensible Development Kit)
The EDK is used to customize the screen against base screen. In Ramco e.Application the base screen contains all application screens. The EDK is two types:
1. Independent EDK 2. Dependent EDK
The Dependent EDK is used against the base screen, where we can customize the base screen according to the user.
In dependent EDK, there are three flows: 1. Inflow
2. Outflow 3. InOutFlow
Inflow: The inflow is used to transfer the data from the base screen to EDK screen.
Outflow: The outflow is used to transfer the data from EDK to Base Screen. InOutFlow: The InOutFlow is used to transfer data from EDL to base screen as well as Base Screen to EDK Screen.
The Independent EDK is used through SQL tables.
Introduction of EDK
Business Process Modeling Specify User Interface Layout Generate Deliverables
Base Screen Extension
EDK Screens to Launch Reports Requirement Script
Code Generation Using EDK Stub Generator Deployment
Extensible Development Kit is a tool used for developing Business Process
Components Activity
User Interface.
To extend the screen functionality of already existing Base screen
This tool can be used by
Customer Users at customers site Implementation team. Pre-Sales team
Develop user defined Components Extend the functionality of Base Screens Transfer data
From Base Screens to User Interface. Design Reports for the User Interface.
Uses a model based approach to capture the specification corresponding to life cycle phases
Information stored is captured in the Model Database. EDK Model Database – Development time
Application Database – Application Component information Deployment Database – Context and Security Information
A Business Process is modeled as a set of Business functions It could be a specific process followed in a particular industry.
Example HRM Purchase Finance
Process Driven
Human Resources
Management
Payroll
Leave Management
Training
Appraisal
Recruitment
The technical implementation of a business function is a component Examples
Leave Management
Leave Master Setup Leave Maintenance Leave Encashment
An activity is implemented as one or more User Interfaces
The flow across User Interfaces establishes traversal and Information Assistance.
Each User interface is provided with the unique UI name, UI type and a description, which is used as the screen title.
User Interface Layout Specification Define UI Configuration
Define Pages (Optional) Define Sections
Define Controls Define Control Layout
Define Grid Contents (Optional) Define Radio Buttons (Optional)
Actions (Tasks)
Actions are steps performed by a user on a User Interface to complete the activity.
User Action
We can extend the functionality of already existing screen through Base Screen. Base Screens are generally taken from RVW 2.0 Model database,
To Get the Base Screen, we need to run the Requirement Script exe
We need to provide the RVW 2.0 model database information in order to get the component deployed.
The exe will generate the SQL Scripts. Run the Scripts in Model Database.
Base Screen Extension
EDK Screens to Launch Reports
Once the Service is generated, Report definition should be done.
Specify the Report name and specify the fields required to be visible
ER Diagram
User ID
Name
Registratio
n
Company/Location
Sql
Login
Registrat
ion
Sub
ID
No. of
Office
Number
of
Sub
Office
user
Admin
Works –in relationship set
Checks
Sub ID
name
No of
Branches
Admin
Works
for
HRMS
IMPLEMENTATION OF SECURITY MECHANISM DLL MODULE
The DLL module contains MC32 Screen that is used to give the rights for the Application as well as for User and assign the role for particular Company and Location.
To Login the mc32 we used sql server username: sa and password: sa
1: Create User Data Source Name (DSN): User DSN will be required named as “REALESTATE”. The type of this DSN is Microsoft ODBC for Oracle. One can create DSN through ODBC Manager. The ODBC manager can be activated by running “Microsoft ODBC 32 bit Manager” from control panel.
2: Create separate user for this application: A user named as ramco with the password ramco is to be created for storing the data in a separate place. Storing data under separate user will protect the data. SQL Server Navigator can be used for creating the said username and password.
3: Create required tables: The structure of tables required for this project (Detail given in the data base design section) is to be created in the said user. The SQL statement CREATE can be used for creating such tables.
4: Create Distributable set of files: An installation package of the software is to be built for implementation of the project at desired location.
Future Scope of ERP
India is a well known player in the ERP market. India occupies a promising position in the whole of IT market .The governments, educational institutions and
companies are constantly working towards promoting and expanding the IT market. In this context ERP holds lot of promises both in terms of supply and demand. There are some issues to worry about and some others which deserve appreciation.
Role in Project
Designation : Technical trainee
Role : To Customize the Base Screen and to develop the EDK according the user Requirement with the help of sql server stored procedures and functions etc.
Sushil Kumar Mishra Technical Trainee Ramco System Ltd.
