profile-img

Zayan Zaky Rezkallah Makar

Software Developer

Haram, Giza, Egypt

Work Experience

AAW Consulting Engineers

  • Software Developer Full Time

    Oct 2008 - Present -16 yrs, 8 months

    Egypt , Giza

    • Job Details:Software Development • Developing new software applications in partnership with business analysts and technical architects • Upgrading existing software as the user organization's needs change • Localizing software products for different international markets • Testing software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the program until it produces the correct results • Working with trainers and technical writers to develop user support materials. • Design & Develop Project to manage active Directory (Add, Edit, Delete, Enable And Disable user and integrate with HR System ) using C#.Net & SQL Server . SQL Administration • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO) • Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO) • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends • Configure SQL Server monitoring utilities to minimize false alarms • As new systems are brought in-house • Install and configure new SQL Servers • Deploy database change scripts provided by third party vendors • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes • Configure SQL Reporting service. Sharepoint Administration • Installing, configuring, maintaining, upgrading and managing a Sharepoint Server or a Farm. • Configuring all service applications like Search, Metadata, User Profile Synchronization. • Creation of a Content DB and maintaining it. • Assignment of proper permission levels for all users of the site as well as configuring anonymous access if required. • Configuring timer jobs depending on business requirements. to backup the sites. • Configuration of Business Connectivity Services for connecting to a SQL database. ERP System Administration(GP) • System Administration for Microsoft Dynamics Great Plains ERP. • Provide daily support to end users including: password resets, transaction issues, maintenance routines and general application modifications. • Manage User access and security; ensure proper segregation of duties . • Troubleshoot and resolve operational . • Connect company finance branches to the main office and consulate all finance data . • Implement GP For Company Branches (Include Creating new Company, users and security) . • Establish Terminal Service For Company Branches to Connect to GP . • Design Financial Reports Using MS Frx Reporting (BS, IS and cash flow) . Other • System Administration for Hits DNA Human Resource program(Profile, Payroll , change of status, Vacation, Appraisal, Time keeping ) . • System Administration for Blackberry Express Edition(Sync Email Between Exchange and Blackberry). • System Administration for Blackberry Enterprise Edition(Sync Email Between Exchange and Android phone& Smart Black Berry ). • Activate blackberry and smart Phone to read Company Mails Using Blackberry Enterprise Service.
  • Software Developer Full Time

    Oct 2008 - Present -16 yrs, 8 months

    Egypt , Giza

    • Job Details: Software Development • Developing new software applications in partnership with business analysts and technical architects • Upgrading existing software as the user organization's needs change • Localizing software products for different international markets • Testing software to ensure the code is correct, fixing ('debugging') errors where they occur, and rerunning and rechecking the program until it produces the correct results • Working with trainers and technical writers to develop user support materials. • Design & Develop Project to manage active Directory (Add, Edit, Delete, Enable and Disable user and integrate with HR System) using C#.Net & SQL Server. SQL Administration • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives. • Test backups to ensure we can meet the business’ Recovery Time Objectives. • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends • Configure SQL Server monitoring utilities to minimize false alarms. • As new systems are brought in-house. • Install and configure new SQL Servers. • Deploy database change scripts provided by third party vendors. • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes. • Configure SQL Reporting service. • Database Engine tuning Advisor. SharePoint Administration • Installing, configuring, maintaining, upgrading and managing a SharePoint Server or a Farm. • Configuring all service applications like Search, Metadata, User Profile Synchronization. • Creation of a Content DB and maintaining it. • Assignment of proper permission levels for all users of the site as well as configuring anonymous access if required. • Configuring timer jobs depending on business requirements. to back up the sites. • Configuration of Business Connectivity Services for connecting to a SQL database. • Using SharePoint Designer & Info path to design Customized list. • Using HTML & CSS for Building Company Portal. • Using C# for Design & Develop web part for Company portal. ERP System Administration (GP) • System Administration for Microsoft Dynamics Great Plains ERP. • Provide daily support to end users including: password resets, transaction issues, maintenance routines and general application modifications. • Manage User access and security; ensure proper segregation of duties. • Troubleshoot and resolve operational. • Connect company finance branches to the main office and consulate all finance data. • Implement GP For Company Branches (Include Creating new Company, users and security). • Establish Terminal Service For Company Braches to Connect to GP. • Design Financial Reports Using MS FRX Reporting (BS, IS and cash flow). Other • System Administration for Hits DNA Human Resource program (Profile, Payroll, change of status, Vacation, Appraisal, Time keeping). • Good knowledge in IIS and the architecture of it
  • Database AdministrationFull Time

    Gargour technologies Company

    Mar 2008 - Oct 2008 -7 months

    Egypt , Cairo

    • Job Details:1-Develop and maintain Database 2-Manage back and restore Database plan as Company policy 3-Access / SQL Server 4-Manage Stores , Employees, Customers Accounts And Salesman Bonus 5- Application Development
  • Maintenance Engineer Full Time

    Egypt & Middle East Company

    Feb 2004 - May 2008 -4 yrs, 3 months

    Egypt , Giza

    • Job Details:Connecting Photocopier to Network For Customers. Network Maintenance & Computer Maintenance. install and configure in network field either LAN or WAN network by assigning IP address and mask by both static or dynamic (by DHCP) also Configure print server Database Administration
  • Developer and Maintenance Engineer Full Time

    Arabian Company for Computer Service

    Mar 2002 - Mar 2004 -2 yrs

    Egypt , Cairo

    • Job Details:Technical Support (Computer Maintenance) Network Installation Developer Database Implementing and troubleshoot LAN solution. Maintain company workstations (XP, 2000, 98) Troubleshooting company product (LAN Switches, ADSL Router, SCSI Cards, USB Devices, wireless devices… )
  • Education

    • BSc in Computer Science & Engineering

      Menoufia University

      Jan 1995 - Jan 2001 - 6 yr

    • High School - Thanaweya Amma

      El-Quosia El thanawyia

      Jan 1995 

    Skills

    • Progressive Web Apps (PWA)
    • Dynamics
    • VB
    • Database
    • Microsoft SQL Server
    • Crystal Report
    • Microsoft SQL Server
    • crystal reports
    • Microsoft report Builder
    • SQL Reporting Service
    View More

    Languages

    • Arabic

      Fluent
    • English

      Advanced
    • French

      Beginner

    Training & Certifications

    • Developing Microsoft SharePoint Server 2013 Core Solutions

      New Horizon·2017
    • MCSA:Administering Microsoft SQL Server 2012/2014 Databases

      2016
    • HR System (Hits)

      Hits·2015
    • Configure & Troubleshooting Window Server 2008 R 2 Active Directory

      ITE Corp·2015
    • Developing Microsoft SharePoint® Server 2013 Advanced Solutions

      New Horizon·2015
    • TS:Microsoft SharePoint Server 2010, Configuring

      2014
    • Microsoft Dynamics Great Plains10.0(Accounts Payable , Accounts Receivable , Cash and banks ,Financial and Fixed Assets Module)

      AAW·2013
    • PRO:Microsoft SharePoint 2010, Administrator

      2013
    • SharePoint Designer 2010

      ITE Corp·2013
    • Microsoft SharePoint 2010, Administrator

      ITE Corp·2012
    • Microsoft SharePoint Server 2010, Configuring

      ITE Corp·2012
    • Oracle Developer 10g (PL/SQL-SQL)

      Geo Tech·2012
    • Asp.net

      Geo Tech·2008
    • Visual basic.net 2005

      Geo Tech·2008
    • SQL Server 2005 Administration.

      Geo Tech·2007
    Share this Profile