·
Handling
more than 50 terminals.
·
Consulting
with administrative and technical staff.
·
Determining
system definations.
·
Software
requirement specification, collection and analysis.
·
Daily
database backup (SQL).
·
Controling
system access and security.
·
Providing
voice and text transmition.
·
Coordinating
protocols for operation.
·
Monitoring
and optimising system performance.
·
System
failures.
·
Data
backup.
·
Testing
new equipments and systems.
·
Validating
error solving in ERP.
·
Managing
Report Generation with Crystal 8.5.
·
Software
installation such as Windows Server 2003, SQL Server 2000, Windows XP,
Windows NT.
·
Hardware
installation such as printer, modem, scanner, network card.
·
Interacting
with the end user for continuous improvement in the project of ERP.
·
Collecting
software requirement specification (SRS).
·
Database
handling, give user rights on system.
·
Systems
Maintenance.
·
Purchasing
raw materials like carbon seamless tubes and pipes from overseas countries
such as Germany and China.
·
Prepararing
invoice to customers.
·
Interfacing with external
implementation resources for all planning and implementation efforts.
·
Interfacing with Software Project Supplier
regarding improvement of the project and coordinating the result of the
progress in progress report.
·
Coordinating with the software engineers from the
project supplier.
·
Handling Database – DBA (Database Administrator).
·
Considering to risk factor, we take daily
database backup in evening on writable CD. So, that in case of failure we can
recover our database. The database is written in .ldf and .mdf form.
Sometimes it also needed to restore other database.
·
Following all the operation to maintain database:
o
Table generation.
o
Granting and revoking the permission.
o
Running SQL query analyzer to obtain defined
result.
o
Managing relationship.
o
Add-remove constraint
o
Prepare foreign key relationship.
o
Create new database user.
o
Maintain lease line of 64 Kbps to transfer the
online data from marketing office.
·
Working with the functional leaders to define the
implementation processes and milestone:
o
The milestone gives the clear idea for project
stage and when it will complete. This milestone is represented to management
for clear view of project. The Format we are using for Project milestone is
as below.
·
Leading the effort in support of management to
define and create report using Crystal
8.5:
o
Periodic reporting requirements
o
Metrics measurement
o
Alerts to transactions falling outside of
expected results
o
Field Exporter
o
Sections of report header, detail and footer
·
Administrate user rights (granting and revoking
permissions)
·
We are using purchase, production, FAS (Financial
Accounting System), inventory, human resources, Sales.
·
Responsible in granting the right to user and at
the same time to maintain company’s information securely.
·
Responding to questions regarding the system and
capabilities of the current technology and systems in use.
·
Training end-user on computers and ERP:
o
Weekly: weekly training is given to all users for
continuous improvement in their field. The end-user comes with the problem at
the entry time, suggestion, complain.
o
When amendment comes: after getting any amendment
in project i.e. updated EXE then it becomes necessary to train the end-user.
o
When new employee joins: the new user requires
the training to understand the whole system and work efficiently.
·
Setting up, troubleshooting and monitoring
current and new computer networks both internal and in remote location (lease
line)
·
Currently using Realtek RTL8139D, Intel RC8254DEM
network card and installing the network cards in new system as well as in old
when where replacement needed.
·
Communicating with Network engineer in
installation and troubleshooting.
·
Using D-Link cable for networking, the network is
connected through 16 Bit Switch or D-Link.
·
Lease line is maintained daily, currently using
routers and modem for connectivity of lease line. The router of Tec route
2000 and CYGNUS 606SS Base band modem for connectivity. The router is put up
at four premises: BSNL (Bharat Sanchar Nigam Ltd), Mehnana to Ahmedabad
BSNL’s and the company. All this four modem for connectivity has to be
well-maintained. If connectivity breaks up then we have to set the status of
LOCAL, REMOTE, DIG AND PATTERN to continue lease line.
·
Preparing project
guidelines for end user’s troubleshooting and give remote access.
·
Projecting guidelines
help to end user regarding defination of the function, its description, and
guidelines of that module in ERP and giving the remote access to users
|
