Hafeez Syed

Over all 5 years of IT experience and 4 years with Snowflake and 1 year with DBT, working as a Snowflake DBT Developer/Snowflake Data Engineer with solid foundational skills and proven tracks of implementation in a variety of data platforms. Self-motivated with a strong adherence to personal accountability in both individual and team scenarios.

• Proficient in Design and Development of process required to Extract, Transform and Load data into the Data warehouse using Snowflake and AWS-S3

• Expertise in working with Snowflake Multi - Cluster Warehouses,

Snowpipe, Internal/External Stages, Clone, Tasks and Streams

• Involved in Zero Copy cloning – Cloning databases for Dev and QA environments.

• Employed DBT for data transformation and orchestration within the Snowflake environment.

• Created Internal and External stages and transformed data during load.

• Created Integration objects, file formats, stages, and used COPY INTO/Snowpipe to ingest CSV/TXT/JSON data continuously from AWS S3 bucket.

• Experienced in handling of semi structured & loads & unloads into the snowflake DW.

• Experienced in Continuous Data Protection Lifecycle, Time Travel, Fail-Safe zone.

• Queried Historical Results/Data based on Timestamp, Offset, Query ID

• Designed and implemented a real-time data pipeline using SnowSQL, Snowflake, and AWS S3.

• Extensive Experience in Data security and data modelling using snowflake.

• Worked on Streams, Secure Views and Materialized Views.

• English
• Telugu
• Hindi

I hereby declare that the above information and particulars are true and correct to my best of my personal knowledge and belief.

• Date of Birth: 07/05/92
• Nationality: Indian
• Marital Status: Single

Hyderabad, Telangana

Project-2: DPM

Role:Snowflake Developer (Snowflake, DBT, SQL, AWS S3)

Company/Client:TCS / Vanguard

Project Description:

The Vanguard Group, Inc. (commonly known as   simply Vanguard. It is the largest provider of mutual   funds and the second-largest provider of exchange-traded   funds (ETFs) in the world after Black rock's Shares. In   addition to mutual funds and ETFs, Vanguard offers brokerage services,   educational account services, financial planning, asset management, and trust   services. The project aimed to support the efficient handling of financial   data with a high-performance, scalable solution for fixed income and equity   data management.

Project-1 :Real-Time Data Pipeline Implementation

Role: Snowflake Developer (Snowflake ,SQL, AWS S3)

Company/Client: Tech Mahindra / EBRD

Project Description:

The European Bank for Reconstruction and Development   is an international financial institution founded in 1991. As a multilateral   developmental investment bank, the EBRD uses investment as a tool to build   market economies. Developed a real-time data pipeline to support a dynamic   reporting system, aimed at enhancing the timeliness of business insights by   reducing data processing latency.