Samyuktha Rani

Results-driven BI & Data Analyst with 8+ years of experience transforming complex datasets into clear, actionable business insights. Proficient in Power BI, DAX, T-SQL, Python, and the Microsoft Azure analytics ecosystem. Skilled at building interactive dashboards, dimensional data models, and end-to-end reporting solutions that empower stakeholders to make confident, data-driven decisions.

Strong communicator who bridges the gap between technical data and business needs, with proven experience across retail, financial services, and technology sectors.

BI & Data Analyst - Walmart - Mississauga, ON

(2024-03)

• Designed and developed interactive Power BI dashboards and IBM Cognos Analytics reports, translating complex retail datasets into clear KPIs and executive-level insights in sales data.
• Collaborated with business stakeholders and cross-functional teams to gather reporting requirements, define KPIs, validate analytical outputs, and translate business needs into Power BI and reporting solutions.
• Built optimized Star Schema dimensional models in Power BI and Azure Synapse with well-defined fact and dimension tables, significantly improving report performance and query efficiency.
• Implemented advanced Power BI features, including DAX calculated measures, drill-through, drill-down, row-level security, and real-time streaming datasets for live inventory and supply chain monitoring.
• Conducted deep-dive statistical analysis and data mining using Python (Pandas, NumPy) in Jupyter Notebooks, surfacing trends and anomalies to guide business decisions.
• Authored and optimized complex T-SQL queries against Azure Synapse data warehouses to extract, aggregate, and validate large datasets for reporting accuracy.
• Performed extensive data wrangling and transformation in Power Query Editor and Excel, validating data quality and preparing clean models ready for analysis.
• Developed SSRS reports with multi-language localization support, enabling consistent reporting experiences for a global user base.
• Contributed to data governance and security compliance by leveraging Azure Purview for data cataloguing and lineage tracking, and Azure Sentinel for threat monitoring.
• Built and maintained SQL scripts for data anonymization and pseudonymization to meet data privacy and regulatory requirements.
• Implemented incremental data loading strategies in SSIS to ensure seamless, up-to-date data flow into BI reporting environments.

MSBI & Data Analyst - Manulife - Toronto, ON

(2022-02 - 2024-03)

• Designed and developed KPIs, calculated measures, and MDX-based models in SSAS Tabular and Multidimensional cubes to support performance measurement across finance and actuarial teams.
• Built Power BI reports with dynamic visuals, conditional formatting, cascading report parameters, and drill-through links, enabling self-service analytics for business stakeholders.
• Conducted data profiling and data quality assessments using Azure Purview to identify and remediate anomalies in OLAP and OLTP data sources before surfacing in reports.
• Performed data transformation and cleansing in Power Query Editor and Azure Databricks, ensuring consistency and accuracy across Power BI and MSBI reporting solutions.
• Designed and implemented SSRS report drill-through features, parameter cascading, and links to external resources, improving navigation and usability for end users.
• Developed and maintained ETL audit trails and data change history logs to support compliance, auditability, and data lineage tracking requirements.
• Implemented SQL Server transactional replication for near-real-time data synchronization, ensuring reporting environments always reflect current source system data.
• Orchestrated real-time data ingestion pipelines integrating Azure Data Lake with Azure Event Hubs, supporting timely analytical reporting on streaming data events.
• Enforced data governance policies and security controls within SSAS cubes and Azure Synapse, including RBAC and column-level security for sensitive financial data.
• Maintained thorough SSIS package documentation, including design specifications and data mappings, supporting team knowledge transfer and package upkeep.

BI & Azure Analyst - OpenText - Waterloo, ON

(2019-01 - 2022-02)

• Developed Power BI dashboards with custom filter panes, slicers, and data visualization best practices (colour schemes, labelling, interactivity) to enhance user experience and data comprehension.
• Optimized SSAS cube performance through fine-tuning of aggregations, partitions, and hierarchies, delivering faster query response times and a more responsive analytics experience.
• Leveraged advanced SSRS features, including data bars, sparklines, indicators, and drill-down to create engaging, information-rich reports for operational and analytical stakeholders.
• Conducted performance testing and tuning exercises on Power BI and SQL Server reporting solutions, improving responsiveness and scalability under high user load.
• Collaborated with software developers to optimize SQL database queries and indexing strategies, improving application response times and report generation speed.
• Implemented SSAS data mining models (clustering, association, regression) to uncover patterns and trends in large enterprise datasets.
• Automated report scheduling and delivery in Azure Data Factory, reducing manual effort and ensuring stakeholders receive timely, consistent reporting.
• Created and maintained reliable data pipelines for real-time data processing, enabling up-to-date analytics across multiple product lines.

Power BI / BI Developer - Roots - Toronto, ON

(2017-11 - 2019-01)

• Designed and maintained Power BI reports and dashboards with dynamic visuals, conditional formatting, and row-level security, supporting retail sales and inventory analytics for business teams.
• Analyzed and modelled source data to create efficient Power BI data models, applying transformation techniques in Power Query to clean, filter, and shape data for optimal visualization.
• Collaborated with ETL developers to ensure seamless data flow from source systems into SSAS cubes, verifying data quality and consistency throughout the ETL process.
• Implemented data masking, anonymization, and deduplication processes within SSIS to protect data privacy and maintain data integrity in the warehouse.
• Used SSRS Report Builder to design and fine-tune professional report layouts, data sources, and subscriptions for scheduled report distribution.
• Partnered with data scientists to integrate predictive analytics models and machine learning outputs into Power BI dashboards, enriching analytical storytelling.
• Applied SSIS package performance tuning methodologies to optimize nightly batch load windows and improve overall ETL throughput.

Bachelor’s Degree - RMK Engineering College