Prerana Singh

Business Intelligence with 10+ years of experience delivering enterprise reporting, KPI dashboards, semantic data models, and business insight solutions across banking, healthcare, insurance, and retail domains. Extensive experience developing Power BI dashboards, regulatory reports, executive scorecards, and self-service analytics solutions supporting operational, compliance, and strategic decision-making. Strong expertise in SQL, dimensional modeling, data validation, reporting automation, KPI development, and translating business requirements into actionable insights.

Experienced delivering scalable analytics platforms supporting business intelligence, predictive analytics, forecasting, and AI/ML-ready data solutions across banking, healthcare, insurance, retail, and energy domains. Proven experience supporting banking, AML, compliance, and regulatory reporting initiatives while ensuring data quality, governance, and stakeholder alignment.

Business Intelligence Developer- Enterprise BI & Capital Markets Reporting - Freepoint Commodities/ Everestdx - Toronto, ON

(2025-12)

• Developed Power BI semantic models, KPI dashboards, and self-service analytics solutions supporting executive and operational reporting.
• Led end-to-end delivery and ongoing support of enterprise reporting solutions, ensuring stability, data quality, and continuous enhancement of BAU reporting processes.
• Coordinated with business stakeholders, analysts, and support teams to prioritize reporting enhancements, resolve production issues, and improve reporting efficiency.
• Reduced Power BI dashboard load times by 40% through optimized semantic models, reusable datasets, DAX tuning, and performance optimization techniques.
• Designed scalable Lakehouse and dimensional data models (star/snowflake schema) for enterprise BI reporting and analytics workloads.
• Built scalable analytics platforms processing 100M+ records supporting enterprise reporting and business intelligence initiatives.
• Collaborated with business stakeholders, product teams, and engineering teams to define KPIs, gather requirements, and deliver analytics-driven reporting solutions.
• Developed business requirement documents, reporting specifications, and workflow analysis artifacts supporting enterprise BI initiatives.
• Owned end-to-end enterprise analytics platform architecture spanning data ingestion, transformation, semantic modeling, and BI consumption using Azure Databricks, ADF, Microsoft Fabric, and Power BI.
• Built and managed Fabric Data Factory pipelines (Medallion Architecture) integrating APIs, Synapse, SQL systems, Snowflake and file-based sources into OneLake for centralized analytics.
• Improved pipeline and query performance by 75% (120 → 30 mins) through Spark optimization, partitioning strategies, and SQL tuning.
• Implemented data governance, validation, and access control frameworks across Microsoft Fabric environments.
• Developed and maintained enterprise BI dashboards, regulatory reports, and KPI scorecards while supporting the transition of reporting processes and metrics from project delivery to BAU operations.
• Developed Python and PySpark-based transformation workflows supporting Fabric Lakehouse ingestion and analytics processing.
• Delivered audit-ready BI solutions with strong adherence to data governance, role-based security (RLS), and enterprise compliance standards.
• Managed BI deployment lifecycle using Azure DevOps, Git, and structured release processes including version control, testing, and production promotion.
• Automated data validation, reconciliation, and reporting workflows using Python scripts, improving operational efficiency and reporting reliability.

Business Intelligence Developer| Capital Markets Reporting & Risk Analytics - TD Bank/ (TCS) - Toronto, ON

(2025-02 - 2025-12)

• Developed enterprise analytics pipelines using Microsoft Fabric, and Azure technologies supporting banking, AML, compliance, and regulatory reporting initiatives.
• Designed scalable Lakehouse and dimensional data architectures (star/snowflake schema) enabling centralized enterprise reporting and analytics.
• Built Power BI dashboards, semantic models, KPI scorecards,DAX, measures and regulatory reporting solutions for business, compliance, AML, and risk stakeholders.
• Improved Power BI report performance through semantic model optimization, star schema design, Performance Analyzer tuning, and optimized Import/DirectQuery/Composite models.
• Implemented data quality validation, governance, monitoring, and automation frameworks using Python-based utilities and QA tools.
• Performed data analysis, data reconciliation, trend validation, and reporting quality checks to support regulatory reporting and business insight initiatives.
• Created reporting documentation, data dictionaries, KPI definitions, and knowledge transfer materials to support production operations and BAU reporting teams
• Experienced supporting banking, AML, compliance, risk, and regulatory reporting initiatives through Power BI, SQL analytics, data validation, reconciliation, and KPI reporting.
• Performed root-cause analysis on complex production issues involving Power BI, Azure Data Factory, Databricks, and Synapse, implementing permanent corrective solutions.
• Supported migration of on-prem reporting and analytics solutions to Azure and Microsoft Fabric platforms.
• Prepared technical documentation, architecture diagrams, operational runbooks, deployment guides, and conducted knowledge-transfer sessions for production support teams.

Business Intelligence Developer | Insurance Analytics & Reporting - NTT Data (Client: Humana) - Toronto, ON

(2023-09 - 2025-01)

• Designed semantic dimensional models (star/snowflake schema) supporting Power BI dashboards and KPI reporting solutions.
• Built enterprise-grade Power BI dashboards with complex DAX measures, optimized data models, and performance tuning for large-scale datasets.
• Improved Power BI performance by 40% through data model optimization, query tuning, and report enhancements.
• Developed and maintained SSRS and Power BI paginated reports supporting operational, financial, and regulatory reporting requirements.
• Collaborated with healthcare business stakeholders and analytics teams to translate requirements into curated datasets, dashboards, and KPI-driven insights.
• Supported Agile delivery processes within cross-functional analytics teams.
• Developed Azure Data Factory pipelines supporting healthcare analytics, Azure Synapse and enterprise reporting solutions.
• Designed and maintained Azure Data Lake Gen2 storage structures following Bronze, Silver, and Gold medallion architecture to support scalable analytics workloads.
• Built curated reporting datasets from structured and semi-structured healthcare data using medallion architecture.
• Managed Power BI Service operations including workspace management, scheduled refresh, and Row-Level Security (RLS).
• Partnered with business, compliance, and reporting teams to validate reporting requirements, resolve data discrepancies, and ensure successful adoption of reporting solutions into BAU support models.
• Implemented monitoring and troubleshooting frameworks for Power BI refresh failures, gateway issues, and data discrepancies.
• Delivered healthcare analytics supporting operational reporting, forecasting, trend analysis, and population-level performance metrics.
• Ensured query folding in Power Query and validated transformations using "View Native Query" for performance efficiency.
• Evaluated business and technical requirements, analyzed multiple implementation approaches, and recommended scalable Azure analytics architectures.

B.Tech - Electronics & Communication Engineering - Noida Institute of Engineering & Technology (NIET), Uttar Pradesh Technical University