Resume

Sign in

Sql Server Microsoft

Location:
Kings County, New York, United States
Salary:
90000
Posted:
February 01, 2018

Contact this candidate

Makram Shehata

**** ******* ***. ***# ***

Brooklyn, NY 11214

347-***-****

ac4awe@r.postjobfree.com

Skills:

• 20+ 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, Tables, Triggers, Queries, Stored procedures, Replications, Temporary Tables, SSRS, SSIS, SQL Profiler, Performance monitor All SQL Server tools using Query analyzer, Enterprise manager, Management Studio.

• 9+ years of working experience with SSIS, extract, transform and loading data (ETL)

• 6+ years of working experience with SQL Server Reporting Services (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 Microsoft SQL Server development, T-SQL, MS Access, Visual studio, Visual Basic, Excel, Pivot tables, Clipper 5, CA Clipper, FoxPro

• 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 Network, Microsoft office

Work Experience:

Dar Al-Handassah Consultant (www.dargroup.com) From: July 2014 - July 2017

Position Held: SQL Database programmer and developer

• During Three 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)

Dar Al-Handassah Consultant (www.dargroup.com) From: July 1997 – June 2014

Position Held: Database Administrator, Senior System Analyst

Duties and 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

• Convert all packages which used Microsoft Access to work under Microsoft 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)

Bishara Textile Manufacturing (BTM) (www.bishara.com.eg) From: July 1991 to June 1997

Position Held: Software Developer

Duties and 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 (Microsoft packages).

• Design and implementation of many software packages using clipper 5 as:

1. Inventory control system (A complete package to control and monitor stock movement and financial evaluation of the store).

2. 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).

3. Many financial packages (To monitor financial status of the company and produce financial statements (Balance sheets, income statement)).

Projects:

• Integrate many applications concerning to (Personnel information, Attendance, Payroll) to run under one system named OFOQ (with SQL database) using (SSIS)

• Converted many MS Access databases to run under MS SQL Server and use the MS Access only as user interface (Forms, Reports and Pass-Through queries)

• Design and develop an application as a cashier system including

1. Define a new items (Suppliers - Models - Materials - Colors - Sizes)

2. Create a barcode for the new items

3. Create a sales price for all items

4. Cashier system and Stock control system

• Design and develop many software programs (Client/Server Application Using MS Access and SQL Server)

1. Cashier system for multi branches.

2. Managing credit cards sales commission.

3. Managing final products needs from raw and semi product in store and the product lines.

• Design and develop many software programs using Clipper5

1. Payroll system

2. Stock control and monitoring the items transactions

Education and Certificats :

• Bachelor of Business Administration, Ain-Shams University, Cairo, Egypt. Class of May 1989

• Commercial software packages, Ain Shams University, (Computer center) – 1991

• Integrated training course in computer science, Ain Shams University, (Computer center)- 1992

• System Administration for Microsoft SQL Server 7.0 (League Technology) - 1999

• Querying Microsoft SQL Server 2000 with Transact-SQL (New Horizons) - 2004

• Programming a Microsoft SQL Server 2000 Database (New Horizons) – 2004

• Implementing a Microsoft SQL Server 2005 Database (Global knowledge) - 2006

• Maintaining a Microsoft SQL Server 2005 Database (Global knowledge) - 2006

• Designing Microsoft SQL Server 2005 Server-Side Solutions (Global knowledge) - 2006

• Designing Microsoft SQL Server 2005 Database (Global knowledge) - 2006

• Designing the data tier for Microsoft SQL Server 2005 (Global knowledge) - 2007

• Tuning and optimizing queries using Microsoft SQL Server 2005 (Global knowledge) - 2007

• Visual Basic.net programming with Microsoft.net (Global knowledge) - 2010

• Programming in visual Basic.net with Microsoft visual studio 2010 (New Horizons) - 2013

• Introduction to web development with Microsoft visual studio 2010 (New Horizons) - 2013

• Developing web applications with Microsoft visual studio 2010 (New Horizons) - 2013

• Maintaining a Microsoft SQL Server Database 2008 R2 (New Horizons) - 2013

• Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services (New Horizons) - 2013

References:

Available upon request.



Contact this candidate