Shikha Shah

About Shikha Shah

Proficient in Power-BI, SQL, Microsoft Azure, Azure Data Factory (ADF), DatabricksExperience in Power BI -1)Crafted DAX queries for creating Calculated Columns and Measures to derive Key performance Indicators (KPIs).2)Used advanced Power BI features like Bookmarks, Buttons, and Drill-throughs for a seamless user experience, enhancing navigation and facilitating intuitive data exploration across report pages.3)Efficiently imported data from Databricks, Azure Data Lake Storage Gen2 into Power BI, leveraging parquet file format, enhancing data processing speed and storage optimization.4)Utilized Power Query Editor to shape and cleanse raw data, implementing transformations that harmonized disparate sources, fostering a cohesive dataset for meaningful insights.5)Constructed visually appealing Power BI dashboard with a mix of different visualizations, ensuring a holistic representation of data that empowers stakeholders to make informed decisions efficiently.6)Leveraged the Write-Back feature in Power BI using Microsoft Power App allowing the internal auditing team to provide real-time comments in reports connected to SQL and Excel while reviewing.7)Successfully converted PL-SQL scripts into Power BI reports, translating intricate database logic into dynamic visualizations. Experience in SQL - Proficient in writing SQL queries using various Window Functions, Joins, CTEs, Views, Stored Procedures, Complex Sub Queries along with a good hang on DBMS concepts.Experience in Databricks (Databricks Certified Data Engineer Associate)- 1)Hands-on experience in PySpark for working with Delta tables.2)Proficient in setting up pipelines using Delta Live tables to enable real-time data ingestion and querying.3)Utilized the Auto-loader feature in PySpark to efficiently load data into Delta tables from various sources, ensuring automatic detection and ingestion of new data files as they arrive.Experience in Azure Data Factory (ADF)- Utilized ADF to implement robust ETL processes, ensuring seamless data movement, transformation and contributing to efficient and scalable data pipelines.Experience in Python - Basic Data Structures in Python, Files i/o handling, NumPy, Pandas.

Experience

1. Consultant

   EY

   Jan 2025 — Present

Education

• St. Francis Institute Of Technology

  Bachelor of Engineering - BE, Information Technology

  2018 — 2022

• St. Anne's High School

  Secondary and Primary School

  2007 — 2016

• Prakash College of Commerce and Science

  Higher Secondary School, (HSC) - Science (PCM)

  2016 — 2018