WASEEM SAIFI

Dedicated professional with history of meeting company goals utilizing consistent and organized practices. Highly skilled with an industry experience of 3+ years in the areas of Data warehousing, Data Analytics, Cloud products and services. Talented individual offering dynamic skills and passion for working on successful technical teams.

Project 1 FST Data Mart
Client Danske Bank, Denmark
Duration Apr-2021 to Sep-2022
Role Snowflake Developer
Tools & Environment: Snowflake Cloud Data Warehouse, Informatica, SQL Server, AWS S3, Data warehouse, PowerBI
Project Description:
Danske Bank is the largest bank in Denmark and a leading player in the Scandinavian financial markets. Recently acquiring Sampo
bank, Sampo Bank serves customers from 125 branches in Finland and 33 branches in the Baltic States, Is the major achievement of
Danske. The IT department of Danske has started with migration of Sampo bank technology to Danske bank technology, as a part of
project, I was involved in the process of migration of Sampo bank data to Danske bank.
Roles and Responsibilities:

• Created various stages like internal/external stages to load data from various sources like S3 and on premise
  systems.
• Bulk loading from external stage (AWS S3) to internal stage (snowflake) using COPY command.
• Loading data into Snowflake tables from internal stage and on local machine.
• Used import and export from internal stage (Snowflake) vs external stage (S3 Bucket).
• Creating views and materialized views in Snowflake cloud data warehouse to Business Analysis and reporting.
• Create task flows to automate the data loading/unloading to/from Snowflake data warehouse and AWS S3
  Project 2 FDW (Financial Data Warehouse)
  Client BNP Paribas
  Duration Oct -2019 to Mar-2021
  Role SQL Developer
  Project Description:
  BNP Paribas is a French bank and financial services company. born in 2000 from the merger between Banque Nationale de Paris and
  Paribas. It is organized into 3 major business areas: Commercial, Personal Banking & Services (CPBS), Investment & Protection
  Services (IPS) and Corporate & Institutional Banking (CIB)
  Roles and Responsibilities:
• Created Snowflake objects like databases, schemas, tables, stages, sequences, views, Procedures and
  FILE_FORMAT using snowflake UI
• Loading data from files that have been staged in external (Amazon S3) then Copy Data into the Target Table and Query the DW Data.
• Experience in writing Complex Sub Queries, writing Complex JOINs, Views.
• Cloning of database schemas, tables, procedures from QA to Prod environment.
• Experience on Snowflake functions Time travel, Data Sharing, Data Cloning, Secure views and clustering.
• Hands-on experience with Snowflake utilities, SnowPipe, snowflake stream to implement SCD.
• Documenting all the deliverables for smooth handover to production team.