SQL Database programmer and developer Resume

SUMMARY:

18+ years of the responsibility and administrate for all versions used of SQL Server started with SQL Server 7 Till SQL Server 2008 R2 (Installing, Backup and Restore, Creating Databases, Security, Define users and logins, Design structure of databases, Scheduled Jobs, Triggers, Queries, Stored procedures, Replications, SSRS, SSIS, SQL Profiler, Performance monitor....) All SQL Server tools using Query analyzer, Enterprise manager, Management Studio.
Visual Studio, Visual Basic, ASP.NET
9+ years of working experience with SSIS extract, transform and loading data (ETL)
6+ years of working experience with SSRS
20+ Years of experiences with MS Access database programming, Security, Developing, Tables, Queries, Forms, Macros, Reports, Modules code and functions use all versions
Advanced Confidential SQL Server Architecture development, T - SQL, MS Access, Visual studio, Visual Basic, Asp.Net, Clipper 5, CA Clipper, FoxPro, Dbase
Good command with All MS Office (all versions)
Experienced with most common software packages as Windows 95, Windows NT, Windows XP, Windows 7, Windows 8, Windows 10, Novell, Confidential office, System analysis and Design

WORK EXPERIENCE:

Confidential

SQL Database programmer and developer

Responsibilities:

During two years, Worked as SQL Database programmer and developer remotely, Write Codes, Views, Triggers, Stored procedures and send it to the client
Create stored procedures and views to calculate annual vacation balance for all employees and transfer its values to their personal bank accounts
Migrate some of access database to SQL database and use MS Access only as user interface Including forms, Reports, Pass-Through queries
Create new reports using (SSRS - MS Access - Excel pivot table)

Confidential

Database Administrator, Senior System Analyst

Responsibilities:

Review and follow up the SQL server to maintain all databases and all Scheduled jobs
Administrate SQL server (Backup and Restore - Stored procedure - Trigger - User defined function - Views - Server roles - Database roles - Security (Users and Logins)).
Review and follow up many Programs using the SQL Server as end database
Implementing all packages which used Confidential Access to work under Confidential SQL Server
Design and implement all software packages needed.
Follow up the SQL Database Server, track error till resolving.
Follow up and support the security and attendance system (Win-Pak Pro (SE-PE)) Generated by Honeywell Company
Transfer daily attendance data from (Win-Pak Pro) to Human resources systems using (SSIS)
Design and implementation of many software packages using Access as user interface and SQL server as end database.
Design and implementation many reports for Human Resources department related to personnel information and their salaries using (SSRS - MS Access - Excel pivot table)

Confidential

Software Developer

Responsibilities:

Network support for Novell 2.2, Novell 3.11 - Administrate, provide Security and all network facilities for users.
Develop new programs in Clipper5 and Ms-Access concerning payroll, Stock control.
Training users on all kinds of software packages ( Confidential packages).
Inventory control system (A complete package to control and monitor stock movement and financial evaluation of the store).
Cashier system (A point of sale system in shops which enable cashier to read codes of stock purchased using bar-code reader and monitor all ins and outs of the shop).
Many financial packages (To monitor financial status of the company and produce financial statements (Balance sheets, income statement)).
Integrate many applications concerning to (Personnel information, Attendance, Payroll) to run under one system named Confidential (with SQL database) using (SSIS)
15 years ago, I converted many MS Access databases to run under MS SQL Server and use the MS Access only as user interface
Design and develop an application as a cashier system including
Create a barcode for the new items
Create a sales price for all items
Cashier system and Stock control system
Design and develop many software programs
Cashier system for multi branches.
Managing credit cards sales commission.
Managing final products needs from raw and semi product in store and the product lines.
Design and develop many software programs using Clipper5
Payroll system
Stock control and monitoring the items transactions