Nikhil Chandra

About Nikhil Chandra

Generative AI and Machine Learning Engineer with 5+ years of experience building…

Experience

1. Sr Data Engineer

   Fidelity Investments

   Jun 2023 — Present · Boston, MA, US

   Designed and developed interactive Power BI dashboards with advanced DAX calculations, role-level security, and optimized visualizations to deliver actionable insights for capital markets datasets, including trade, risk, and portfolio analytics.• Built and maintained Power Platform solutions, including creating and integrating data sources, applying transformations, and ensuring scalability for business users across multiple departments.• Implemented Microsoft Fabric and Power BI service features for enterprise-scale reporting, ensuring data refresh automation and integration with Azure Data Lake and Synapse Analytics.• Developed ETL pipelines in Azure Data Factory (ADF) and Databricks using PySpark, Delta Lake, and SQL to extract, transform, and load high-volume datasets from AWS S3, Athena, SQL Server, and third-party APIs (REST).• Designed and optimized star and snowflake schemas for OLAP analytics, ensuring compatibility with Power BI data models and reducing report refresh times.• Collaborated with business stakeholders to gather requirements and translate them into data models, KPIs, and measures for intuitive Power BI dashboards.• Leveraged Databricks for large-scale data transformation, machine learning workflows, and integration with Power BI for predictive and prescriptive analytics.• Applied data security best practices by implementing role-based access control (RBAC), dynamic data masking, and secure data governance policies across the BI environment.• Utilized SQL and T-SQL for performance tuning, creating stored procedures, materialized views, and aggregation tables to enhance dashboard responsiveness.• Automated reporting processes using CI/CD pipelines in Azure DevOps, ensuring consistent deployment of Power BI datasets, reports, and Azure data pipelines.