Manager
CHEMAF SPRL
Total years of experience :14 years, 1 Months
Aligning and formulating IT policies in line with the overall business objectives of the organization.
Programming and database management / administration of relational databases (SQL Server 2005 & Oracle 10G).
Confirm changes in source system. Fulfill the requirements related to any kind of Reports.
Development and Maintenance of Reports.
Development includes the use of SQL Server 2005 & Crystal Reports.
Administration of Server 2003 for a 300 user LAN. At present handling 5 servers including 2 Database Servers, 1 Mail server on Linux Platform, 1 Camera Server and 1 Payroll Server on Windows Platform.
Managing the Tally server along with the support for Tally.
Role of a DBA including online backup procedure to recover and retrieve the Data to the last stage in SQL Server Database in case of system failure. LAN administrator responsibility, operations, backups.
Analyze and solve software and hardware problems related to network clients and associated Windows compatible applications. This included problems related to Netware Protocol IPX/SPX, NetBIOS and TCP/IP connectivity.
Designing, Installation and Implementation of Security Systems.
Plan, assign and review work of sub-ordinate(s), guide on methods and procedures suggest improvements in performance and handle complaints and grievances
Maintenance of WAN connectivity through VPN, Radio Links and Fiber Optics and handling the issues related to the same.
Managing and working on Mikrotik Routers and VSAT connectivity and online applications.
Work with vendors to ensure reliable supply of third-party products and services.
Set installation standards, training to installation teams.
Formulate departmental objectives, annual IT plan with budget and operational targets derived from the Overall Organizational objective, monitor and report deviations from the approved IT plans including an analytical submission of the deviation and necessary remedial corrective and preventive action
Aligning and formulating IT policies in line with the overall business objectives of the organization.
Programming and database management / administration of relational databases (SQL Server 2005 & Oracle 10G).
Confirm changes in source system. Fulfill the requirements related to any kind of Reports.
Development and Maintenance of Reports.
Development includes the use of SQL Server 2005 & Crystal Reports.
Administration of Server 2003 for a 150 user LAN. At present handling 3 servers including 3 Database Servers, 1 Mail server on Windows Platform.
Role of a DBA including online backup procedure to recover and retrieve the Data to the last stage in SQL Server Database in case of system failure. LAN administrator responsibility, operations, backups.
Analyze and solve software and hardware problems related to network clients and associated Windows compatible applications. This included problems related to Netware Protocol IPX/SPX, NetBIOS and TCP/IP connectivity.
Plan, assign and review work of sub-ordinate(s), guide on methods and procedures suggest improvements in performance and handle complaints and grievances
Maintenance of WAN connectivity through Radio Links and Fiber Optics and handling the issues related to the same.
Work with vendors to ensure reliable supply of third-party products and services
Set installation standards, training to installation teams.
Analysis and programming for IQMS ERP System (An US based ERP package developed by IQMS) in Delphi & Oracle 10. Performing Database maintenance, Applying patches and updates, customized database level programming (SQL / PLSQL) & creating customized reports in Crystal reports to meet user requirements. Also includes the installations at client nodes and training to the respective users.
Migration of system from ORION to IQMS ERP (Real Time ERP Package on Oracle 10) and implementation and reporting in Crystal Reports Version 9 and XI.
Analysis and programming for ORION ERP System (A package developed by 3i Infotech) in D2K & Oracle 9i. Performed maintenance programming to meet user requirements.
Single handed in-house development of Human Resource Management System and integrated the same with the ERP system.
Experience of working with PLSQL, SQL, Triggers, Procedures & Packages.
Programming and database management of relational database.
Fulfill the requirements related to any kind of Reports in D2K.
Development and Maintenance of Reports. The applications executed identified reports into MS Excel Spreadsheets, MS Word Documents & Adobe Acrobat Documents.
Administration of Server 2003 for a 130 user LAN. At present handling 3 servers including 3 Oracle Database Servers, 1 Document server on Windows Platform & 1 Linux Mail server.
Role of a DBA including online backup procedure to recover and retrieve the Data to the last stage in Oracle Database in case of system failure. LAN administrator responsibility, operations, backups.
Analyze and solve software and hardware problems related to network clients and associated Windows compatible applications. This included problems related to Netware Protocol IPX/SPX, NetBIOS and TCP/IP connectivity.
Plan, assign and review work of sub-ordinate(s), guide on methods and procedures suggest improvements in performance and handle complaints and grievances
Analysis and programming for a Hospital Management system. Performed development and maintenance programming to meet user requirements
Performed coding, and/or supervised coding. Experience of working with SQL, PLSQL, Triggers, Procedures & Packages.
Integrating Messaging software with Oracle Database to generate real time messages from databases through SMS.
Compiled system requirements for migration of product from Novell + Foxpro to Oracle 8i + D2K
Migration & Implementation of Hospital Management System from Oracle 8i + D2K to Oracle 9i + D2K.
Programming and database management of relational database.
Programmed bar coding system for Retail Pharmacy Stores & Central Drug Stores involving third party tool.
SMS system for the marketing services of the hospital and generate reminders as per the schedules via SMS to the patients catered by the hospital.
Implementation of automated system for generating Indents, Purchase Requisitions & Purchase orders with the facility to e-mail directly from the system.
Interfacing of Medical Equipments - Unidirectional (DADE AR, SYSMEX KX21 & MINI-VIDAS) with the Oracle Database for data exchange/transfer with the support of third party tools and oracle applications.
Development and Maintenance of D2K applications (Reports). The applications executed identified reports into MS Excel Spreadsheets, MS Word Documents & Adobe Acrobat Documents.
Development included the use of D2K, Excel 2000, ODBC for Oracle and Windows 2000 Professional.
LAN administrator responsibility, operations, backups, user IDs.
Administrated Windows Advanced Server 2000 / Server 2003 for a 109 user LAN. At present handling 4 servers including 1 Oracle Database Server, 1 Document server & 2 Development servers on Windows Platform.
Documentation of Quality Management System as per ISO 9001:2000 standard for system manual & quality manual which includes preparing processes & related formats as well as data.