Lakshmi S

BI Analyst - First Recruit

(2023-11)

Developed interactive Power BI dashboards and reports to deliver actionable insights and support data-driven decision-making.
Collaborated with business stakeholders to gather reporting requirements and deliver KPI-focused dashboards and analytics solutions.
Integrated data from Dataverse, Data Lake, and Azure SQL Database to support reporting, dashboarding, and business analytics.
Designed and maintained star and snowflake data models in BigQuery to support analytical reporting and dashboard performance.
Built scalable Spark-based transformation workflows to process and prepare data for real-time reporting and dashboarding.
Developed batch and streaming data solutions using Azure Data Factory, Microsoft Fabric, Databricks, and Synapse Analytics to support reporting and analytics.
Integrated data from multiple cloud and database sources using Azure Synapse to support analytics and reporting solutions.
Implemented monitoring and logging solutions within Azure Logic Apps to troubleshoot issues and improve reliability of data integration workflows.
Developed Power Apps solutions to streamline internal business processes and improve operational efficiency.

BI Developer - Tata Consultancy Services - India

(2021-01 - 2021-11)

Collaborated with business analysts and stakeholders to gather reporting and analytics requirements.
Orchestrated data pipelines to integrate and interact with services such as Azure Fabric, Azure Data Factory, Azure Data Lake Storage, One Lake, and Azure Synapse Analytics.
Implemented Delta Lake within Microsoft Fabric to improve data reliability and support scalable analytics reporting.
Utilized Databricks and Spark for large-scale data transformation, cleansing, and analytics processing.
Supported migration of large datasets to Microsoft Fabric and configured data pipelines for analytics and reporting workflows.
Developed data transformation workflows using PySpark and Spark SQL to prepare data for reporting and business insights.
Performed ETL operations including data cleansing, transformation, and standardisation across cloud and on-premises data sources.
Created calculated columns, Measures, Variables queries in Power BI, Tableau desktop for effective data analysis techniques to provide actionable insights to the users.
Published Power BI reports to Power BI Service and collaborated through workspaces and apps to support business reporting.
Contributed to end-to-end BI and reporting projects from requirements gathering through deployment and ongoing support.

BI Analyst - Tata Consultancy Services - India

(2020-07 - 2020-12)

Developed streaming and ETL pipelines using Azure Event Hubs, Stream Analytics, Azure Data Factory, SSIS, and Alteryx to support reporting and analytics.
Designed and maintained SSIS packages to extract, transform, and load data from multiple data sources into reporting systems.
Developed dashboards and analytical reports using Power BI, DAX, and MDX to support business reporting and data analysis.
Optimised SQL queries and indexing strategies to improve reporting performance and database efficiency.
Developed SQL procedures, functions, and queries to support reporting and data processing requirements.
Designed and deployed Power BI dashboards and reports using data modelling, DAX, and Power Query to deliver business insights.
Worked with cross-functional teams to understand data requirements and deliver reporting solutions that supported business decisions.
Published Power BI and Tableau reports to reporting servers and managed scheduled dataset refreshes.

BI Analyst - Tata Consultancy Services - India

(2020-01 - 2020-06)

Gathered and analysed business and reporting requirements for BI and data warehouse solutions.
Performed SSIS performance tuning and troubleshooting to improve ETL workflow efficiency.
Developed ETL workflows for data cleansing, validation, and transformation before loading data into the data warehouse.
Created and maintained SSIS packages to load and process data within the data warehouse environment.
Created stored procedures to build the Fact tables in the data mart for multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
Implemented logging and error handling mechanisms to improve ETL reliability and troubleshooting.
Automated the ETL process by scheduling SSIS package execution by creating jobs.
Optimised T-SQL queries and database structures to improve reporting performance and data quality.
Published Power BI reports to Power BI Service and implemented Row-Level Security (RLS) to manage secure report access.

About