Zeeshan M Email & Phone Number

SKILLSSQL (DBMS: SSMS, PostgreSQL, Oracle), Snowflake, Power Bi, Tableau, Advanced Excel, Data Modelling, Data Mapping, Data Profiling, ETL/ELT.Azure: (Azure Data Factory, Azure Data Lake, Azure SQL, Azure Blob Storage) PROFESSIONAL EXPERIENCE:• Experience in Working with Advanced Excel Functions and Formulas.• Designed a Power BI Dashboard to track employee data for the HR Department, Including Working Hours, attendance,Performances, Leaves, No. of Projects Etc.• The Dashboard Can Save 4-5 Hours of Work for HR Daily.• Attending Sprint planning, and daily stand-up meetings to understand the requirements and for sprint refinement• Experience in Writing SQL queries and optimizing the queries based on guidelines.• Creating and Managing SQL Database, Tables, Joins, Views, Index.• Good knowledge of Azure Tools: Azure Data Factory, Azure Data Lake, Azure Blob Storage, Azure SQL• Developed data pipelines using Azure data factory to load data from source to target• Good Understanding of Cloud Snowflake Architecture and Data Migration from on-premise SQL Server to OLAP Snowflake• Experience in working on Snowflake Snow SQL and Snow pipe.• Created snowflake Database, Tables i.e. Internal, External, Temporary Tables, Views i.e. Secure View, Materialized View. • Implemented Slowly Changing Dimensions (SCD) in dimension tables as per the requirements. Developed SCD Type pipelines to manage Change Data Capture (CDC) and historical data in the warehouse• Strong understanding of the principles of Data Warehousing using fact tables, and dimension tables• Created Source to Target Mapping sheet document and built SQL query based on transformation logic• Performed Analysis and Data Profiling using SQL on various Systems• Created Reports and a Dashboards in Power Bi with different KPIs, Pie chart, Area chart, Maps, Slicers / Filters Etc.• Experience in Advanced Excel Functions i.e. VLOOKUP, HLOOKUP, Pivot Tables, INDEX, MATCH, SUMIF, COUNT, Average and other Advanced Functions and Formulas.• Writing SQL queries and subqueries to retrieve Data from Database• Developed Reports and dashboards using Excel, Tableau to provide Insights and support decision-making• Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.

• 

  Visvesvaraya Technological University

  Computer Science