ABHISHEK K.

• 20 years of extensive IT experience encompassing all phases of the Data Enablement lifecycle, including Data Engineering, Data Warehousing, Data Analytics, Data Modeling, and Data Architecture. • Strong expertise in developing data solutions utilizing the Microsoft Business Intelligence stack (SSIS, SSRS, and SSAS), Microsoft Azure services, and Snowflake Data Warehousing. • Proficient in Data Warehousing implementations, including the design and development of SSIS packages for EDW • Dimension and Fact loads, as well as SSAS tabular models for self-service analytics. • Experienced in building scalable data solutions using Dimensional Data Modeling and MPP architecture. • Experienced in Azure Fabric services. • Experienced in Python, Pyspark, Azure Databricks and Snowflake. • Experienced in working with IDE’s like PyCharm, IntelliJ • Expertise in Oracle Performance Tuning and Database migration activities • Experienced with OLTP and OLAP Data Modeling • Experience writing complex SQL queries, stored procedures, creating views and materialized views for data migration projects using Snowflake and SQL Server • Design, develop, and maintain data pipelines using Google Cloud Platform (GCP) services such as BigQuery, Dataflow, Dataproc • Implement ETL/ELT processes for data ingestion, transformation, and storage from diverse sources into GCP data warehouses. • Hands-on experience with diagramming skills on Visio for project implementation • Experience with DevOps, and CICD frameworks in enterprise data migration projects using Azure Devops, Cloud Build and Terraform • Created BI dashboards in PowerBI, SSRS to solve various business problems in HR, Finance, Operations, Procurement, Asset Management • Led 3 successful MVPs through complete SDLC and go-live • Experienced with IAM framework that enable healthcare organizations to manage digital identities across healthcare domains such as SCM, NGEMR, Active Directory, HRIS • Experienced with integration of MIS systems in banking and investment organizations. • Integrated 40+ sources to fact and dimension tables in data warehouse using Snowflake • Experienced on ETL Tool (Informatica, Datastage, ADF). • Experienced in Power BI, SAP Business objects and Cognos 8.4.1 • Proven experience to drive industry best practices and processes for building scalable Data Warehousing solution. • Have designed Semantic layer for BI reporting and analytics. • Experienced in phased, agile development methodology, handling multiple projects at any given time • Excellent Working Knowledge in Software Development Life Cycle