About  

Header
My name is Zeyad I am IT professional. I have bachelor’s degree in computer science and statistics. While I have been in this field, I have had the opportunity to work in multiple different industries such as Insurance, Customer Service and Banking. I master time management to work on number of different tasks throughout the day, by setting goals which can be broken down into a project, an action plan, or a simple task list. Started career path as since 2001 as a computer programmer, building databases systems using Microsoft Access and Visual basic to manage databases.
Sub - Header
Currently, I am working for Colaberry Inc as Data Engineer/ETL developer. I have had the opportunity to work on several projects and tickets. Recently I completed Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various files and into servers using SQL server integration services (SSIS). The SSIS package will transfer data from CSV and JSON files to the staging database and I build the data model for operational database reporting (ODS) to supports current or near real-time reporting and for data warehouse using Star schema and Snowflake modeling for fact and Dimension tables then automate the process using SQL agent.
SQL Experience
I have good experience in writing T-SQL queries commands in DDL, DML, and DCL that include creating tables, views, stored procedures, temp tables, and functions. Alter tables add columns, constraints, and relationships between the primary key in the parent table and the foreign key in the child table. Writing queries using merge statements to migrate the data to the data warehouse using slow changing dimension type 2. Add trigger when an event occurs in the database server INSERT, UPDATE, or DELETE statements on a table. use transactions to commit or rollback the insert or update on table. use different types of join to fetch the data from two or more tables. Removing duplicate rows using the CTE statement and Row_Number function.

SSRS Reporting
I have the experience to created different types of SSRS reports like charts, tables, matrices, drill down, drill through, and parameterized reports and worked on cascading parameters, and created complete dashboard reports and sub reports, these reports are scheduled daily, and weekly and monthly reports to different users under different security accesses.
Closing
I understand that for this position of Data Warehouse Engineer that you're hiring for, you're looking for someone with a strong understanding of Data Modeling and SQL skills Overall, due to my strong background and achievements in successfully identifying gaps and creating efficiencies, I am confident I'll be able to succeed in this role, you're hiring for.
I understand how data turns into information and knowledge and how that knowledge supports and enables key business processes, I have an in-depth understanding of the business environment and an interest in going beyond the obvious, delving into the source, the definition, philosophy, and foundational roots of a data element to create information.

Hybrid (On-site and Remote)

Looking for Full-Time