ERP System/Databases Development and Administration
Drake & Scull International
Total years of experience :8 years, 11 Months
- Define the project scope in collaboration with senior management.
- Gathering the business requirements from different departments including (Stores, Purchase, Production, Finance and Human Resources).
- Analyze the business requirements.
- Convert the business requirements to the technical requirements by using process modeling tools such as MS Visio, Rational Rose.
- Review the project scope and the technical requirements (workflow).
- Estimate the cost for required IT-Equipments related to the project in coordination with network team.
- Place action plan for software implementation and development.
- Implement the software by using Visual Studio.Net, ASP.Net, VB.Net2008, VisualC#.Net2008, ADO.Net, C++, Visual C++, Microsoft.Net Framework, Crystal Report Tools, XML File, INI File, Windows Installer and Team Viewer Technologies.
* Trace the progress in software development life cycle and
ensure that not exceed the deadline in the action plan.
- Test and insure that all functional and non functional requirements in the software are properly working as per requested without any defect.
- Improve the ERP software according to renewable needs, insure that the new business requirements are properly integrated with the existing process.
- Define role, Give the users privileges on the client server software based on authority for every one (end user control).
- * Provide technical support and training for all end users on ERP
software, create technical documents for that.
* Provide training for all end users on MS Office 2003, 2007&2010
(The Full Package).
- Supervise the follow-up technical data entry in all departments.
- Analyze the technical data and process it (Data Analysis and Processing).
- Develop and customize reports for ERP software by using Report Builder Tools in the software.
- Design and develop tables by using (SQL server 2008R2, 2012& 2014) and MS Office Access 2007, 2010.
- Create views and stored procedures by using SQL server 2008R2, 2012& 2014.
- Write (Select, Inner Join, Insert, Update, Delete, Create, Drop and Alter) Query by using SQL, T-SQL.
- Import the big data from MS Office Excel to SQL server database.
- Write SQL server backups plan.
- Restore SQL server backups.
- Perform monitoring tasks with SQL Trace by using Transact-SQL stored procedures and SQL Server Profiler.
- Write DBCC commands in order to remove all the data from SQL Server’s data cache (buffer), create a new server log, reduce logical fragmentation, rebuild indexes, shrink the database, data file & log file of SQL server …etc.
- Configure SQL server database Mirroring and Replication.
- Upgrade the system databases from SQL server 2008R2 to SQL server2012 and from SQL server2012 to SQL server2014.
- Coordinate with network team to install Windows Server 2008 after evaluating the compatibility with the software and related database.
- Plan the network cabling design (Cat5, Cat6, etc, Fiber Optic) and install switches, access points and routers in coordination with network team.
- Implement network security, file permissions, backup and file system integrity in coordination with network team.
1- Document Management System.
Description: its management of a document including electronic storage, access, search, retrieval, archiving, deletion and control to an extent.
The main purpose of the system is converting paper based documents such as (incoming document, outgoing document, and transmittal document) into a digital/ electronic format.
My Role :
- Gathering, analyzing and understand the user requirements.
- Design and implement the software by using VisualC#.Net2003, C++,
Web Browser Reports Tools, CSS, HTML and Config File.
- Design and implement the system database by using Microsoft Office
Access2003.
- Testing the software and fault finding (debugging).
- Configure the setup files.
- Install the software.
2- Machine Shut Down and Maintenance System.
Description: It is history of documentation for all breakdowns are affecting on the machines, upload/download images represent that nature of breakdowns to/from the server. It contains all maintenance requirements for the machines and the equipments in the factory.
My Role :
- Gathering, analyzing and understand the business requirements.
- Evaluate the existing operating systems and hardware, ensure that
will be compatible with the software technology and related database.
- Design and implement the software by using ASP.Net,
VisualC#.Net2005, C++, PHP, Crystal Reports Tools, Web Browser
Reports Tools, CSS, HTML and Config File.
- Design and implement the system database by using Microsoft Office
Access2007.
- Develop and modify the software based on the new requirements.
- Testing the software and fault finding (debugging).
- Configure the setup files and manage it.
- Install and manage the software.
- Training for all end users.
3- Employees Training System.
Description: it's information system about the training and education for the employees, All training/educational courses that the company give it for the employees and calculation of training and education expenses for every employee in more than 12 division.
It contains expenses cover system from the divisions profits and from labor ministry regarding the reimbursing about all certificates already submitted from the company.
My Role :
- Gathering, analyzing and understand the business requirements.
- Evaluate the existing operating systems and hardware, ensure that
will be compatible with the software technology and related database.
- Design and implement the software by using VB.Net2005, Crystal Reports Tools
and Config File.
- Design and implement the system database by using SQL Server2005.
- Develop and modify the software based on the new requirements.
- Testing the software and fault finding (debugging).
- Configure the setup files and manage it.
- Install and manage the software.
- Training for all end users and new staff.
4- SAP / ERP System.
My Role :
- Analysis in software implementation for all system modules and
functions including Estimation, Design (Engineering), Inventory, Procurement,
Production, Sales, Finance, HR and Payroll.
- Coordinate with departments heads to gather the new business
requirements (renewable needs) that they want in software.
- Analyze and understand the new business requirements.
- Convert the new business requirements to the technical requirements.
- Review and edit the software documentation to reduce potential cost according
to the submitted new technical requirements to the software vendor.
- Coordinate and plan with the software vendor to improve
the software based on the new technical requirements.
- Perform manual testing for the software after modification and
development.
- Technical Support for all unhandled exceptions (software issues).
- Install and manage the system.
- Training for all end users and new staff.
- Local Area Network Project.
My Role :
- Creating LAN between more than 60 user.
- Configuration and define domain and IP's addresses (Static, Dynamic)
for users PC's connected with LAN.
- Using switches, cabling (Cat6) and installing printers connected with LAN.
- Implementing and managing the network security.
- Installing windows server 2003.
In addition to that, I worked for the following points:
- Administer network workstations, utilizing one or more TCP/IP networking protocols and/or one or more WINDOWS-based operating systems.
- Evaluate and/or recommend purchases of computers, network hardware, peripheral equipment, and software.
- Investigate user problems, identify their source, determine possible solutions, test and implement solutions.
- Install, define, configure and maintain Personal Computers, Microsoft Networks, Windows Workstations, File Servers, Ethernet Networks, Network Cabling, and other related equipment, devices, and systems; Disk Drives, CD ROM Units, Printers, and related equipment.
- Plan and implement network security, managing host security, file permissions, backup, file system integrity, and (adding and deleting user account in the server).
- Troubleshoot networks, systems, and applications to identify and correct malfunctions and other operational difficulties.
- Develop and conduct various instructions for system users on operating systems, applications; assist users in maximizing use of networks and computing systems.
- Perform and oversee software installation, and upgrades.
- Maintain site licenses for department/organization.
- Identify utilization patterns and their effect on operation/system availability and performance expectations.
- Anticipate communication and networking problems and implement preventive measures.
- Establish and perform maintenance programs following company and vendor standards.
- Ensure timely user notification of maintenance requirements and effects on system availability.
- Maintain confidentiality with regard to the information being processed, stored or accessed by the network.
- Document network problems and resolutions for future reference.
- Support and maintain Servers (Dell, etc), Phones (Analog, Digitals), Fax Machines, UPS (Uninterruptible Power Supply), Switches, Access Points, Hips (Wimax, Wifi) and Routers.
- Install operating systems such as (Windows XP, Windows Vista, Windows Server 2003, Exchange Server, etc) and maintain it.
1) Content Management System:
My Role :
- Analyze the project requirements.
- Design and implement the software by using ASP.Net VisualC#.Net2003, Web Browser Reports Tools, CSS, HTML and Java Script.
- Design and implement the system database by using SQL server2000.
- Test the software and fault finding (debugging).
- Configure the setup files.
2) Educational Web Site Project: by using HTML and Java Script.