NADEEM AZEEZ

Snowflake Migration

Technology Stack: Snowflake, Informatica IICS

• Led the end-to-end migration of enterprise data to Snowflake, leveraging Informatica Mass Ingestion Services (IICS) and Data Integration Services.

• Implemented Slowly Changing Dimensions (SCD) Type 2 using Streams, Tasks, and Stored Procedures for historical data tracking and reporting.

• Designed and built Snowflake Warehouses, optimizing query performance and cost efficiency.

• Utilized Dynamic Tables for data science dataset preparation, enhancing analytical workflows.

Data load from Various source system to Snowflake to build dashboard

• Load data from files ,Web,sql server to Sql server and perform transformation using SSIS

• Process the data and create final data set for Tableau dashboard using sql jobs and procedure

PostgreSQL Data Warehouse

Technology Stack: PostgreSQL, AWS DMS

• Designed and implemented a PostgreSQL-based

Data Warehouse, ensuring scalability and high availability.

• Architected and developed a Medallion-based data warehouse model, leveraging Data Wrappers and SQL Procedures for efficient ETL processing

Building Snowflake Data warehouse

• Collecting Data from different sources and load into Snowflake Datawarehouse
• Created procedures and other database objects in Snowflake to streamline data processing .
• Create Matillion jobs for data Movement and transformation
• Transforming semi structured data into structured form using snowflake and Matillion
• Supported data warehousing initiatives by designing dimensional models, star schemas, and snowflake schemas for optimal storage and retrieval of information.
• Developing reports using Power BI involves transforming raw data into insightful, interactive visualizations that effectively communicate key metrics and trends to support informed decision-making
• Configuring refresh for power BI Datasets in power Bi service

SQL Data warehouse and reporting

• Created SSIS packages for efficient data loading and transformation, ensuring smooth data integration.
• Created tables, procedures, views, functions, and indexes in SQL warehouse to improve data organization, enhance performance, and streamline query execution
• Optimized database performance through careful monitoring, tuning, and troubleshooting.
• Delivered actionable insights by automating data extraction, transformation, and loading processes.
• Developed interactive dashboards and reports using Power BI to provide actionable insights and support data-driven decision-making

• Conducted system study and requirement gathering to analyze business needs, ensure alignment with project goals, and develop effective solutions for successful implementation
• Performed data migrationfrom various platforms to the application’s database, ensuring seamless transfer, data integrity, and minimal disruption to operations
• Facilitated seamless migration of databases across platforms, adhering to industry best practices throughout the process.
• Created stored procedures, triggers, functions, indexes, views, joins, and T-SQL code to enhance application performance, streamline data processing, and support business logic
• Performed debugging of queries and stored procedures to identify and resolve issues, optimize performance, and ensure accurate data processing