Power Bi Data Analyst

LAKSHMI SARANYA

+1-469-***-**** *************@*****.***

PROFESSIONAL SUMMARY

Data Analyst skilled in designing and maintaining scalable data solutions that support business intelligence and drive informed decision-making. Proficient in SQL for data extraction and transformation, with hands-on expertise in creating interactive dashboards and reports using Power BI and Tableau. Strong foundation in ETL processes (SSIS), data modeling techniques (star and snowflake schemas), and query optimization. Adept at working with the MS SQL Server stack, Power BI Service, SharePoint, Power Apps, and implementing role-based security (RLS). Hands-on experience across the BI lifecycle and growing expertise in the modern data stack, including Snowflake, BigQuery, Python scripting, and ETL tools like Fivetran and Stitch.

TECHNICAL SKILLS

Tools & Frameworks: SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), Team Foundation Server, Power BI (Power Query, DAX, Power BI Service, Report Builder), Power BI Data models, Tableau, Trello, Click App, Team Foundation Server (TFS), Excel, CRM SharePoint 2010/2007,

Data Modeling Tools: Star Schema, Snowflake Schema, Azure, SSAS Cubes (Calculated Measures, KPIs), Power BI Data Models

WORK EXPERIENCE

Future Wave IT :

Data Analyst 04/2025 -Present

Responsibilities:

Developed KPI dashboards for ICU Sepsis & Diabetes patients using EXCEL, Tableau, and Power BI, incorporating calculated fields, Data Analysis Expressions (DAX), and Level of Detail (LoD) expressions (include, exclude, fixed), along with filters, parameters, and sets.

Published reports in Power BI Service, and these dashboards improved ICU operational efficiency by 30%.

Worked on Power Query and SQL for data cleansing, data wrangling, and handling missing data, ensuring accuracy and

consistency in clinical datasets.

Analyzed inventory data using Excel and SQL to optimize stock levels and reduce overstock by identifying slow-moving items.

Utilized data visualization tools (e.g., Power BI/Qlik) to monitor warehouse KPIs such as order accuracy, throughput, and downtime.

Power BI and Tableau visualization features to perform exploratory data analysis, uncovering actionable insights.

Prepared and optimized data from relational databases using complex SQL queries in SSMS for reporting and analytics.

Deployed BI solutions and reports to web platforms using Power BI Service, ensuring data accessibility for key stakeholders.

Worked on Scrum-based Agile methodologies, utilizing Trello to track tasks and collaborating with cross- functional teams

Environment: Power BI (Power Query, DAX), Power BI Report Builder, Tableau, SQL Server Management Studio (SSMS), Microsoft Visual Studio, Agile (Scrum), Click app, Excel.

Opera Technologies,Exton, PA : 06/2024– 04/2025

Data Analyst

Involved in creating stored procedures and SQL queries to import data from SQL server to the Tableau.

Explored dataset using various diagrams such as Histograms, boxplots, skewness in R studio.

Analyzed the customer data and business rules to maintain data quality and integrity.

Mentored junior analysts on dashboard development best practices in Power BI and Tableau, promoting reusable data models and optimized DAX expressions.

Participated in evaluating and exploring modern ETL tools like Fivetran and Stitch to enhance pipeline automation and reduce manual dependencies.

Explored and validated data flows using Snowflake and BigQuery environments for scalable analytics and BI integration.

Developed interactive dashboards and data visualizations using Power BI, Tableau, or Qlik to present key performance indicators.

Built pivot tables, VLOOKUPs, INDEX-MATCH, and advanced formulas to manipulate and analyze datasets efficiently.

Automated repetitive tasks using Excel Macros to improve reporting efficiency.

Extensively created excel charts, pivot tables, functions in Microsoft Excel to analyze the data.

Environment: Power BI (Power Query, DAX, Service), Tableau, SSMS, SQL Server, Trello, Scrum/Agile Methodology, SQL (complex queries, data optimization), data visualization tools, and relational databases,ETL.

University of North Texas, Denton, Texas :

Data Specialist/Analyst 05/2023 – 05/2024

Responsibilities:

Strong communication and interpersonal skills for managing inquiries and handling guest interactions.

Demonstrated organizational abilities to coordinate schedules, documents, and resources efficiently.

Proficiency in office tools such as Microsoft Office (Word, Excel, Outlook, Teams, SharePoint) and scheduling software.

Excellent time management and multitasking capabilities to prioritize tasks in a fast-paced environment.

Developed problem-solving skills to address and resolve issues quickly and professionally.

Used tools like Excel, Google Sheets, and internal platforms (e.g., Slate CRM, SharePoint) for organizing and analyzing data.

Assisted in generating academic reports and performance dashboards for administrative staff and academic advisors.

Neeman’s:

SQL BI Developer 11/2021-12/2022

Responsibilities

installed, configured, and maintained Enterprise and Personal Gateways for Power BI Services, ensuring secure and scalable data access across business units.

Collaborated cross-functionally to test proof-of-concept dashboards on Looker, gaining familiarity with LookML and visualization logic.

Applied Python scripting to automate recurring data preprocessing tasks and statistical validation for report accuracy.

Developed complex SQL queries, stored procedures, triggers, and user-defined functions to support enterprise data needs.

Developed and published Power BI dashboards displaying KPIs, which improved real-time visibility of business performance, aiding faster decision-making.

Designed and deployed SSAS cubes with calculated measures and KPIs to facilitate multi-dimensional data analysis, resulting in improved operational insights.

Implemented role-based security for reports, ensuring compliance with organizational data governance policies.

Environment: MS SQL Server 2016/2014, Micro Soft Visual Studio, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), Microsoft Office Share Point.

EDUCATION

Master In Business Analytics, University of North Texas 01/2023 – 05/2024

Contact this candidate