Ishrath Khan

Design, develop, and support enterprise Power BI solutions serving HR, workforce planning, talent management, and business operations. Develop interactive dashboards, KPIs, scorecards, and self-service reporting solutions for business stakeholders and leadership teams. Build and maintain scalable semantic models using Power BI, DAX, Power Query, and SQL. Implement Row-Level Security (RLS) and data governance controls to ensure secure access to sensitive workforce data. Collaborate with business stakeholders to gather requirements and translate complex business needs into actionable analytics solutions. Optimize report performance, dataset refresh processes, and data models to improve reliability and user experience. Support cloud analytics initiatives and reporting platform enhancements across multiple business functions. Manage report deployment, workspace administration, testing, and production releases. Troubleshoot data, refresh, and security issues while providing ongoing support for critical reporting solutions. Deliver insights that support workforce management, talent programs, operational effectiveness, and strategic decision-making.

• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. • Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, Azure Databricks, Azure Synapse, Blob Storage and Azure Data Lake. • Creating Data Bricks notebooks using SQL, Python and automated notebooks using jobs. • Creating Spark clusters and configuring high concurrency clusters using Azure Databricks to speed up the preparation of high-quality data. • Write complex PL/SQL Package, Functions, procedures, batch processes using bulk processing, ref cursors and PL/SQL Tables. • Work with stakeholders to translate Technical & Business requirements to user stories for Power BI/Tableau reporting and develop them into acceptable criteria, create POC, Mockup’s and Prototype. • Led a cross-functional BI team of analysts and developers in designing, developing, and deploying advanced data analytics solutions, improving data-driven decision-making. • Built and published and customized interactive Tableau reports and dashboards along with data refresh scheduling using Tableau Desktop and Tableau Server • Aligned with Agile Software Development Methodologies, scrum stories, Scrum/Kanban and sprints in a Power BI based environment in association with data analytics. • Developed Tableau Data Visualization using cross tabs, Heat Maps, Box and Whisker Charts, Scatter plots, Geographic Map, Pie Charts, Bar Charts and Density Charts. • Setup Microsoft flow (Power Automate) to provide auto approval and status update features based on predefined criteria. • Develop data capture and navigation desktop and mobile apps in Microsoft Power Apps. • Utilized Tableau Server to Publish and Share reports with the Business users.

• Designed and developed interactive Power BI dashboards, utilizing complex data models and DAX calculations to deliver business insights and improve decision-making for cross-functional teams. • Integrated Snowflake as the primary data source, developing efficient data pipelines and optimizing performance by creating materialized views and using Snowflake’s caching capabilities. • Collaborated with data engineers to build and automate data ingestion processes into Snowflake, ensuring data accuracy, consistency, and timely availability for Power BI reporting. • Developed and maintained advanced data models in Power BI, leveraging data from Snowflake to support business KPIs, financial reporting, and operational insights. • Optimized query performance for large datasets in Snowflake by refining SQL queries, indexing, and partitioning data, resulting in faster dashboard loading times. • Led stakeholder meetings to gather reporting requirements, creating custom visuals in Power BI and ensuring reports aligned with business needs. • Trained business users on Power BI report creation and usage, empowering them to explore data independently while maintaining data governance and security standards. • Implemented row-level security (RLS) in Power BI to restrict data access, ensuring compliance with company data governance policies and regulations. • Managed Power BI workspace and content distribution across different business units, overseeing permissions and ensuring adherence to organizational data policies. • Designed, developed, and maintained SSIS packages to extract data from diverse sources and load it into a centralized Data warehouse and DataMart entities, resulting in improved data accuracy and reporting efficiency.

• Designed, developed, and maintained SSIS packages to extract data from diverse sources and load it into a centralized Data warehouse and DataMart entities, resulting in improved data accuracy and reporting efficiency. • Implement Azure Logic Apps to enhance application functionality and streamline workflows. • Worked with Hive and Impala for querying and managing large datasets within Hadoop ecosystems • Designed and implemented complex SQL and PL/SQL queries for data extraction, transformation, and loading. • Use Python scripts to automate ETL workflows, ensuring seamless data integration across diverse sources. • Developed Mappings involving SCD Type 1, Type 2, and Type 3 to manage changing data within data warehouses. • Collaborate with cross-functional teams to design, code, test, debug, and document applications. • Conduct Data Analysis, Data Mapping, Data cleansing, Data Validation and Data Extraction in support of daily Adhoc requests. • Gather requirements from multiple stakeholders and directors, analyze, and document, functional requirements and data specifications for BI dashboards/Reports. • Work with business partners to understand business objectives and develop value-added reporting and provide ad-hoc data extracts and analysis.

• Fixed issues of existing stored procedures and made changes to increase the performance. • Created various Tabular and Matrix Reports using SSRS. • Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and trigger • Developed several reports with consistent drill-down functionality including Drilldown reports and Sub-Reports. • Prepared AD HOC reports through report builders. • Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notifications using SSIS and SSRS.