Senior Data Architect and Cloud Data Engineer

MAJD DAYEH

https://www.linkedin.com/in/majddayeh/

******@*****.***

Professional Summary

Senior Data Architect / Data Engineer with 25+ years of experience designing enterprise data platforms, cloud migration solutions, data warehouses, and large-scale ETL ecosystems. Expertise in Azure Databricks, AWS, GCP, Snowflake, Redshift, SnapLogic, Matillion, Informatica, SQL, and PySpark. Proven success leading architecture, data modeling, cloud modernization, and data integration initiatives for Fortune 500 organizations including PwC, Deloitte, Hulu, Amerisure, Cedars-Sinai, and Western Digital.

EDUCATION

Central Michigan University

Mt. Pleasant, MI

Master of Science in Computer Science

Sep 1996 – Dec 1998

University of Aleppo

Aleppo, Syria

Bachelor of Science in Computer Engineering

Aug 1988 – Dec 1992

Technical Skills

Cloud & Big Data

• Azure Databricks

• AWS (S3, Redshift, Glue,

SQS)

• Google Cloud Platform

• Snowflake

• Data Profile

Data Engineering

• SQL

• PySpark

• SnapLogic

• Matillion

• Informatica

• ETL/ELT Design

Databases

• SQL Server

• Oracle

• PostgreSQL

• Teradata

• Redshift

Data Architecture

• Data Modeling (Star Schema,

Dimensional Modeling)

• Data Warehousing Architect

• Data Governance, Profile,

Quality

AREAS OF EXPERTISE

ETL Lead / Data Architect / Data Modeling/ Data Engineer / Cloud Development / Data Integration & Management / Dimensional & E-R Modeling / Quality Assurance / Team Leadership WORK EXPERIENCE

09/2025 – 04/2026 SQL Architect, Architect, Modeling, Engineer, Lead PWC Remote

• Team of two SQL Architect / Developers to design and develop an enterprise level database designed to support inventory and orchestration of migration processes. Data needs will carry through reporting via PowerBI.

• Gather requirements to document the steps needed to bring data from MS365 into csv files and load into database

• Architect the stage and the DW to load the csv files. Include Metadata Management, Data Lineage.

• Complete Physical and Logical Data Model

• Complete ETL to load the files into stage and DW

• Lead the MS team for all ETL code and processes

Technology Utilized: SQL, MICROSOFT AZURE, RELATIONAL DATABASES, DATABASE ADMINISTRATION 10/2023 – 3/2024 Sr. Integration Consultant / Lead Amerisure Insurance Remote

• Helping the Integration team with different projects depends on the need.

• Bring the data from Guidewire into the Salesforce environment using Snaplogic. The data extracted into ASW message Queuing, then load the data from the Queue into Salesforce.

• The data from Guidewire included Quote/Policy/Agency data into Salesforce

• Worked on system to allow users to enter policies in the AI environment and execute to bring the associated Policy attribute back

• Worked to log error and success logs into Datadog

• Lead the team with ETL processes and profile

Technology Utilized: SQL, Snaplogic, Salesforce, DataDog, AWS Queue. 03/2022 – 05/2023 Data Modeler / Data Engineer Lead Deloitte Remote

• Transform detailed requirements into a complete, detailed systems design

• Design long-term, reliable, and adaptive multitiered system architectures and sophisticated geospatial solutions

• Provided Leadership for the Data Engineer team and Reporting Team

• Serve as a technical gateway between the project manager and the developers

• Work closely with project teams to develop new data workflows, automation scripts, tools, data management

• Perform and support analysis of various geospatial and demographic datasets, from multiple sources, at multiple scales, and across many spatiotemporal resolutions to meet the needs of the project

• Develop tools and scripts to support geospatial-based analysis, providing sandbox views to users to enable them to run queries against data

• Test multiple Cloud Platforms, AWS, Azure/DataBrick, and Google. Then Decided to use Google Clouds Technology Utilized: AWS, Redshift, PostreSQL, SQL and scripting, GCP, Microsoft Power BI, Star Schema, DataBrick 12/2021 – 01/2022 Data Analyst PWCP Remote

• perform documentation on key design decisions and data architecture decisions and help create an implementation project plan. The resource will be expected to:

• Participate in user sessions and document data architecture decisions

• Develop roadmap, resource requirements and cost estimates

• Document data upload requirements as per standard template, review with PwC and client personnel

• Develop data quality rules based on requirements developed Technology Utilized: Oracle

10/2021 – 11/2021 Data Migration / Lead PWC Remote

• Perform development activities using Snaplogic and PwC's Data Migration framework.

• Create library and baseline pipelines for data migration using the data migration framework that PwC has created.

• Provide support and training to client service personnel on how to use the pipelines.

• Develop a front end in PowerApps to connect PwC's project management framework to the data migration toolset.

04/2021 – 09/2021 Sr Data Engineer / Lead PWC Remote

• Migrate Snaplogic code to load into Azure/DataBrick, using free hand SQL and PySpark

• Apply integration to bring different data sources and load into one target (SQL Server/Azure)

• Apply fixes to existing code to be sure match the requirements.

• Create code to alter existing tables and add new columns.

• Optimize XDM project and FPI record item to simplify the code and combine mappers into less mappers and improve performance (2-3 hours to 45 Min to an hour)

• Helped the offshore team with all their ETL processes and Data Issues Technology Utilized: Snaplogic, SQL Server, AWS, Azure Cloud/Databricks, SQL, PySpark 12/2020 – 03/2021 Sr Data Engineer / Lead WWT/Discount Tire Remote

• This role will be responsible for data engineering work required to bring in new data sources into client’s existing EDW. Design physical database models

• Model new data with existing data lake and enterprise data warehouse (EDW). Enterprise Architecture

• Develop data transform code to enable EDW ingestion process using Matillion.

• Perform mapping/ETL of data into the EDW, including error handling and alerting, including unit testig and QA. Provide all needed documents with the process using Matillion

• Provided Leadership to other team members in ETL and Data Analysis Technology Utilized: Redshift, S3, Matillion, Glue, Star Schema 04/2019 – 10/2020 Sr Data Engineer Hulu Santa Monica, CA (Remote)

• I am working as a Senior Data Engineer. Some of the tasks I am working on are Data Quality issues. fact source updated subscriber and subscription data. these changes will be migrated to Snowflake and Hive databases.

• Campaign 360 project: Phase I: bring customer data who is targeted by emails, this data includes customer behavior, watched, profile, activities

• Campaign 360 project: helped in the QA, Data profiling and UAT issues

• Helped Subscription team when needed

Technology Utilized: Hadoop, Snowflake, talend (data profile), SQL server EDW, PySpark, Star Schema 12/2014 to 1/2019 Sr Data engineer / Lead HGST a Western Digital company San Jose, CA Remote Work on Big data project. Load data from hadoop Redshift using Redshift commands and SnapLogic ETL tool

• Files extracted from Hadoop and dropped on daily hourly basis into S3

• Write code or ETL processes using SnapLogic to load data into redShift tables

• Create code to bulk load or Upsert (Insert/Update) using Redshift and SnapLogic

• Build the data model to load the flat files (Stage)

• QDN project. Build the data model and ETL to move the data from DB2 (DW) to redshift. Include initial load and incremental. implement logic to check RD and load any new records or update

• Move data from MySQL to RS, include built the data model and ETL

• Work on creating prod Data Warehouse in Redshift to load QDN data

• Work on HICAP to bring data directly from source instead of S3 Technology Utilized: AWS (Amazon Web Service), S3, SnapLogic, RedShift, Linux, Star Schema, Tableau 6/2012 To 12/2014 Senior Data Warehouse/ETL Lead CEDARS-SINAI HEALTH SYSTEM LOS ANGELES, CA

• EPIC project (Upgrade and Enhancements). B2B and clinical DW

• DW projects to enhance the existing DW

• EPIC 2010, apply all the changes needed in Stage and DW to comply with EPIC 2010 upgrade

• Work on EDW data load, involved in the Architect and work on ETL

• Upgrade CSMG data mart to reflect EPIC 2010 changes and apply service area merger

• EDW phase II, Operation data feed

• Work on Various data quality issues

• Work on Optimize Weekly load, runs for 6-10 hours, now 1-1.5 hours. Orders used to run for 45 minutes, optimized and running for 6-7 minutes

• EPIC 2012 Upgrade, apply all EPIC 2012 changes to stage, DW, EDW Technology Utilized: Informatica, Oracle 11g. Modeling tool (Oracle Designer) 3/2012 To 5/2012 Senior Data Warehouse/ETL Consultant Habitat For Humanity International Working Park time with Habitat

Technology Utilized: Informatica, Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (ERwin) 11/2011 To 1/2012 Senior Data Warehouse/ETL Consultant CATASYS Health

• Built Datawarehouse / Star Schema from Scratch

• Built SSIS packages to load the data from files into the DW Technology Utilized: SSIS and SQL server DB (2005 and 2008). Modeling tool (MS Visio) 4/2011 To 10/2011 Senior Data Warehouse/ETL Consultant Habitat for Humanity International

• Implemented DW and Informatica best practices

• Analyze and create ETL Design Document for EDW Release 1.2

• Provided feedback on the DQC process from the DW standpoint and ETL

• Support other ETL developers

• QA and set up automated processes to provide DW load quality check Technology Utilized: Informatica,Teradata (13, 13.10), SQL Server 2008, Oracle 11g. Modeling tool (Erwin) 1/2010 To 7/2011 Senior Data Warehouse/ETL Lead CEDARS-SINAI HEALTH SYSTEM LOS ANGELES, CA

• Provided support for Architect or Modeling for new projects

• Analyze and upgrade Census Data Mart project (Daily Admissions, Daily Patient Movement and Daily Discharge).

• Created automated scripts to test the targets after loading the data

• Worked on CS-Link, massive change to the DW source system (Data types and Size)

• Mentor other team members

Technology Utilized: Informatica, Oracle 11g, Modeling tool (Oracle Designer), Star Schema 10/2009 TO 1/2010 Senior IT Integration Specialist Advanced Sterilization Product (Johnson & Johnson)

• Worked on Sales revenue Integration Service project at ASP (Johnson&Johnson) company.

• After getting approval on the system architect, I worked on DW architect and modeling

• After getting the approval for the Logical and Physical data model, I worked on Detailed Design document

• Mentor Sr. ETL developer to take over the project

• Ensure SOX compliance by enforcing corporate CAV process. This included architect and design the CAV process and tables

Technology Utilized: Informatica PowerCenter, SQL Server 2008 as db. Ensure SOX Compliance. Modeling tool (MS Visio), Star Schema

6/2008 TO 9/2009 Senior Data Warehouse/ETL Lead CEDARS-SINAI HEALTH SYSTEM LOS ANGELES, CA

• Analyze and re-architect the existing DW to comply with EPIC project

• Verified all Epic ETL design documents and provide feedback when needed

• Developed and Unit test staging Technology Utilized (ECODESR, HBSR, Supervise the development of HBSR)

• Improved the performance of patient process, (was taking 3+ Hours for 500K records, to 20 minutes).

• Improved process (2-3 Hours to 18 Minutes)

• Developed UNIX shell scripts to perform various tasks (checks on the trigger files and archive data files.)

• Created migration documents, led the processes of migrating the code from DEV to TEST then PROD

• Recognized for completing tasks in a very timely manner and providing high quality code Technology Utilized: Informatica PowerCenter 8.1.1, Push Down optimizer, Oracle 11g, SQL, PL/SQL, XML, Toad 9.5, Business Objects XI, UNIX, Windows XP, Informatica Data Analyzer. 9/2007- 5/2008 Senior ETL Architect ITG (Investment Technology Group) Culver City, CA Technology Utilized: Informatica PowerCenter 8.1.1, Informatica Power center 8.5x, Sybase, SQL, Push Down optimizer 5/2007- 8/2007 Lead Informatica Specialist/Data Warehouse Architect 24 Hour Fitness Carlsbad, CA Responsibilities

• Build 24 Data Warehouse from Scratch this include Architect, Modeling, and ETL lead Environment: Informatica PowerCenter 7.X and 8.x and DataStage (7.x), Oracle 10G, SQL and PL/SQL, Push Down optimizer. Windows servers, people Soft DB

8/2006-5/2007 Senior Consultant Data Warehouse EXPERIAN/LowerMyBills Santa Monica, CA

• Convert the Data Warehouse from Relational model to Start Schema

• Develop and test all ETL and ELT processed using Sagent

• Data Qualities and day to day activities including new projects Technology Utilized: Sagent, Informatica PowerCenter 8.x, Oracle 11G, SQL Server and Teradata. Push Down optimizer. UNIX. Modeling tool (ERwin)

3/2006-8/2006 Sr. Data Warehouse Architect/ETL Lead HELIO CA

• Install Informatica 8.X and Oracle

• Build the DW, this includes Architect and Modeling and ETL

• Worked on setting up the infrastructure for the reporting tool (DA), provided technical tips and supervision for the reporting team Environment: Informatica PowerCenter 8.x, Oracle 11G, Data Analyzer, Push Down optimizer. UNIX

Technology Utilized: Informatica, Oracle, Star Schema Prior Work Experience

HealthNet, CA

05/2005-02/2006

Senior ETL Consultant

Joined HealthNet Pharmacy team in May 2005 to architect and develop the Medicare Part D project and other projects assigned to the team.

Technology Utilized: Informatica, Oracle, Star Schema LowerMyBills (LMB) Santa Monica, CA

03/2003-05/2005

ETL Engineer

Senior ETL Engineer, DW Architect Involved with other DW team members in: Architect and Develop the new Data Warehouse. Meanwhile Supportthe current system. Provide support to the DW team. Help in moving the current DW to the new Environment.

Technology Utilized: Sagent, Data Modeling, Informatica PowerCenter 8.1.1 and 8.6.1. SQL Server 2008 as db. Oracle Alliance Data Systems (ADS) Gahanna, OH

12/1998-07/2002

Application Programmer Analyst

• Application Programmer/Analyst from 2000-2002: Defined functional and detailed designs analyzed systems and developed solutions for highly complex problems that required extensive investigation.

• Systems Support Analyst from 1998 – 2000: Administered segmentation, aggregation and campaign management tools.

Training

Informatica (Power Center 7.x) Advanced Development 2005 Informatica (Power Center 7.x) Advanced Administrator 2005 Informatica (Power Center 7.1) 2004

Software Architect2002

QA Techniques 2002

E.Piphany (Real Personalization)2001

Software Engineer 2001

Visio 2000

Informix (Advanced SQL)1999

Contact this candidate