Samyukhta Rani
Samyukhta Rani

Senior BI & Data Analyst

Open to offers · Member since 5 Oct 2026
Location
Mississauga, Canada
Desired salary
Unspecified
Work preference
Remote Only
Experience level
Senior

About

Professional summary

I am a results-driven BI and Data Analyst with more than eight years of experience turning complex datasets into actionable business insights. I specialize in translating business requirements into scalable reporting, analytics, and data-modeling solutions.

I build interactive Power BI dashboards, executive KPI reports, and self-service analytics experiences using DAX, Power Query, SQL, SSRS, SSAS, IBM Cognos Analytics, and Tableau. My work emphasizes clear visualization, reliable data, and practical decision support.

I have strong experience with dimensional modeling, star schemas, OLAP and OLTP systems, fact and dimension tables, slowly changing dimensions, data profiling, and data lineage. I optimize queries, reporting models, and data pipelines to improve performance and usability.

I work extensively across the Microsoft Azure analytics ecosystem, including Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Data Lake, Azure Purview, Azure Sentinel, and SSIS. I also use Python, Pandas, and NumPy for statistical analysis, anomaly detection, and data mining.

I bring experience in retail, financial services, and technology environments, partnering closely with technical and business stakeholders. I am committed to data governance, security, privacy, and delivering trusted reporting solutions that enable confident, data-driven decisions.

Skills

39 capabilities

Tech stack & tools

Working toolkit

Collaboration

Development

Languages & Frameworks

Libraries

Experience

Career history

BI & Data Analyst Walmart

Designed interactive Power BI dashboards and IBM Cognos Analytics reports for retail sales, inventory, and supply-chain reporting. Partnered with stakeholders to define KPIs, gather requirements, validate outputs, and deliver executive-ready insights.

Built star-schema dimensional models in Power BI and Azure Synapse, optimized T-SQL queries, and implemented DAX measures, drill-through, drill-down, row-level security, and real-time streaming datasets. Used Python, Pandas, NumPy, Power Query, Excel, SSRS, SSIS, Azure Purview, and Azure Sentinel to support analysis, governance, security, data anonymization, and incremental data loading.

MSBI & Data Analyst Manulife

Developed KPIs, calculated measures, MDX models, SSAS Tabular and Multidimensional cubes, and Power BI reports for finance and actuarial teams. Delivered dynamic visuals, conditional formatting, cascading parameters, drill-through functionality, and self-service analytics capabilities.

Performed data profiling, quality assessments, transformation, and cleansing with Azure Purview, Power Query, and Azure Databricks. Implemented ETL audit trails, transactional replication, real-time ingestion pipelines using Azure Data Lake and Event Hubs, RBAC, column-level security, and SSIS package documentation.

BI & Azure Analyst OpenText

Developed Power BI dashboards with custom filter panes, slicers, and visualization best practices to improve data comprehension and user experience. Created advanced SSRS reports using data bars, sparklines, indicators, and drill-down features for operational and analytical stakeholders.

Optimized SSAS cubes through aggregation, partition, and hierarchy tuning, and improved Power BI and SQL Server reporting performance through testing and query optimization. Built SSAS data-mining models, automated report delivery with Azure Data Factory, and maintained real-time data pipelines across product lines.

Power BI / BI Developer Roots

Designed and maintained Power BI reports and dashboards for retail sales and inventory analytics, using dynamic visuals, conditional formatting, row-level security, and optimized Power Query transformations. Modeled source data and collaborated with ETL developers to ensure reliable flows into SSAS cubes.

Implemented data masking, anonymization, deduplication, and SSIS package performance tuning to protect privacy and improve warehouse load throughput. Created SSRS report layouts, data sources, and subscriptions, and collaborated with data scientists to incorporate predictive analytics and machine-learning outputs into dashboards.

Education

Learning history

RMK Engineering College

Bachelor's Degree

Bachelor's degree completed at RMK Engineering College in Tamil Nadu, India.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent AI Tools Salaries
Menu