Vidyashree Raju

CLIENT: NCC (January 2020 to 2024)

NCC is one of the leading construction companies in the Nordics. Operations include commercial property development, building and infrastructure project contracting, and asphalt and stone materials production.

Roles and Responsibilities Handled

• Started as a Microsoft BI Developer, extensively working with the MSBI suite (SSIS, SSRS, SSAS) to develop and manage robust data warehousing and reporting solutions.
• Designed and maintained SSIS packages for complex ETL workflows involving multiple data sources such as SQL Server, Excel, and flat files.
• Constructed comprehensive SQL stored procedures to handle complex business logic and data transformations.
• Created parameterized, drill-through SSRS reports to deliver actionable operational and financial insights to stakeholders.
• Developed SSAS cubes (multidimensional/Tabular) to support fast OLAP-based querying and performance-tuned reporting models.
• Played a key role in performance optimization, ensuring faster data refresh and improved query response times across SSAS cubes and reports.
• Led the strategic migration from on-premises MSBI to Azure cloud services, modernizing the data platform architecture.
• Post-migration, designed and implemented scalable, cloud-native ETL pipelines using Azure Data Factory for orchestrating data movement and transformations.
• Used Azure Databricks for advanced data transformations, aggregations, and PySpark-based business logic processing at scale.
• Built and published Power BI dashboards integrating with Azure Data Lake and Synapse Analytics, enabling real-time decision-making.
• Significantly improved data reliability by replacing legacy SSIS packages with ADF + Databricks pipelines.
• Implemented metadata-driven pipelines, parameterization, and modular ADF design patterns for better reusability and maintainability.

CLIENT : MICHELIN (2015 - 2019)
Michelin is a leading French Tyre Manufacturer based in Clermont-Ferrand. Michelin tyre data are stored in wide range of data warehouse and the tyre movements from warehouse to supply centre are managed with multiple applications as per the business requirement.

Test Engineer

• Worked as part of the Quality Assurance (QA) team, responsible for ensuring the reliability and functionality of enterprise data applications.
• Created detailed test design documents, test plans, and test cases based on functional and technical specifications.
• Conducted manual testing, including functional, regression, and integration testing, across various modules.
• Performed test case reviews and participated in peer reviews to ensure coverage and quality.
• Identified, reported, and tracked defects using standard bug tracking tools; collaborated closely with development teams for issue resolution.
• Validated bug fixes and supported User Acceptance Testing (UAT) by working closely with business users.
• Played a key role in enhancing testing documentation standards and ensuring traceability across testing cycles.

BI Data Analyst (MicroStrategy & SQL Server Data Tools)

• Part of the BI operations and support team, focused on maintaining and analyzing data environments powered by MicroStrategy and SQL Server Data Tools (SSDT).
• Involved in functional requirement analysis and supported the design and rollout of BI reporting solutions.
• Managed MicroStrategy user administration, including user provisioning, role assignments, and access control.
• Supported and monitored batch processing jobs, resolving failures and ensuring timely data loads for reporting.
• Handled incident management, including root cause analysis, issue resolution, and stakeholder communication.
• Created and maintained documentation for data workflows, data lineage, and BI report catalogs.
• Coordinated with cross-functional teams including developers, data engineers, and business users to ensure high availability and reliability of BI platforms.