Power Bi Data Analyst
Resume:
Sai Ram V
Louisville, KY
www.linkedin.com/in/sai-raam
Summary
Results-driven Data Analyst and Power BI Developer with extensive experience in
designing interactive dashboards, optimizing SQL queries, and transforming raw data
into actionable insights. Proficient in Power BI, SQL, Python, and ETL processes, with a strong ability to collaborate with stakeholders to deliver data-driven solutions.
Technical Skills
Power BI: Dashboard development, DAX, Power Query (M), Dataflows, Row-Level Security (RLS), Power BI Service
SQL: T-SQL, Query Optimization, Stored Procedures, CTEs, Indexing, ETL Processes
Python: Pandas, NumPy, Matplotlib, Seaborn for Data Analysis and Automation Data Modeling: Star Schema, Normalization/Denormalization, Relational Databases
Tools: SSIS, AWS Redshift, SAP, Agile/Scrum
Education
BACHELOR IN INFORMATION TECHNOLOGY, SRM UNIVERSITY JULY 2019
MASTERS IN BUSINESS ANALYTICCS UNIVERSITY OF LOUISVILLE July 2024
Experience
Client: First Citizens Bank, Louisville, KY May2024 –Present
Sr. Power BI Developer/Data Analyst
Goal: Translated business needs into data analysis, BI solutions, and reporting for diverse stakeholders by designing interactive Power BI dashboards. Enabled real-time tracking of banking transactions, customer profitability, and regional performance to drive data-driven decisions.
Responsibilities
Requirement Gathering: Collaborated with business users to define KPIs (revenue channels, loan performance, NPLs) and align dashboards with executive/operational needs.
Data Modelling & Cleansing: Utilized Power Query to unpivot/pivot, filter, sort, and
reshape raw data from SQL Server, Excel, and APIs.Transformed tables via M language
to optimize data structures for reporting.
DAX & Advanced Analytics: Developed 20+ complex DAX measures (e.g., YTD growth,
risk scores) and implemented dynamic filtering based on user roles. Created calculated columns, KPIs, and partitions for time-series analysis (MTD/QoQ trends).
Power BI Deployment: Configured Enterprise + Personal gateways for secure, real-time data refreshes. Centralized ETL logic via Dataflows, reducing redundancy by 30%.Managed workspaces, apps, and content packs for cross-departmental access.
Security & Compliance: Enforced Row-Level Security (RLS) to restrict data access by role (e.g., branch managers, executives). Disabled export/print functions to meet
FDIC/SOX compliance.
Visualization & UX: Designed interactive dashboards with Stacked/Clustered Bar Charts, Scatter Plots, Maps, and Time Slicers for intuitive exploration. Enabled
drill-through from regional summaries to granular transaction details.
SQL & Performance Optimization: Wrote optimized SQL queries (CTEs, window functions) to extract/aggregate transactional data, cutting query time by 40%.Designed indexing strategies and stored procedures to accelerate monthly financial close processes.
Client: IDB Bank, Elizabeth town, KY Dec 2023 - May2024
Sr. Power BI Developer/Data Analyst
Goal: Developed and deployed interactive Power BI dashboards to transform multi-source data into real-time insights while ensuring compliance with data privacy and security standards. Enhanced decision-making through advanced DAX, row-level security (RLS), and intuitive visualizations.
Responsibilities:
Data Modelling & Transformation: Performed Power BI Desktop data modeling, cleaning and transforming data from SQL Server, Excel, and APIs using Power Query (M). Utilized unpivot/pivot, merge/append queries, conditional columns, and M formulas to reshape raw data into analysis-ready structures.
Transposed, filtered, and sorted tables to optimize performance and usability.
Stakeholder Collaboration & Requirements:
Worked closely with business users to translate needs into technical specifications for dashboards and reports. Designed tailored reporting solutions for executives, analysts, and operational teams.
Advanced DAX & Data Governance: Developed 15+ complex DAX measures (e.g., time intelligence, dynamic KPIs) to enable interactive filtering and user-driven insights.
Implemented Row-Level Security (RLS) to restrict data access by role, ensuring compliance with GDPR/internal policies. Restricted export/print functions and managed workspace/content pack access for audit readiness.
Power BI Deployment & Automation: Configured Enterprise + Personal gateways for seamless data refreshes from on-premises sources. Created Power BI Dataflows to centralize ETL logic, reducing redundancy by 25%. Published reports to Power BI
Service and enabled access via web/mobile apps.
Visualization & User Experience: Designed interactive dashboards with
Stacked/Clustered Bar Charts, Scatter Plots, Donut Charts, and Maps. Implemented page-level, report-level, and visual-level filters for dynamic data exploration.Enabled drill-through capabilities for granular analysis.
Testing & Compliance: Led Integration, Functional, and UAT testing to ensure accuracy before deployment. Adhered to industry and organizational data governance standards (e.g., data privacy, security policies).
SQL & Performance Optimization: Wrote optimized T-SQL queries for backend data
extraction, reducing load times by 30%. Used SQL Profiler and XMLA for performance tuning and debugging.
Client: Apik InfoTech IN Oct 2021 – Aug2023
Role: Sr Data Analyst
Goal: Designed and implemented automated reporting solutions to transform raw business data into actionable insights through SQL optimization, Power BI dashboards, and dynamic Row-Level Security (RLS), enabling real-time decision-making across
diverse user groups.
Responsibilities:
Requirements Analysis & Technical Translation: Led JRD (Joint Requirements Development) sessions to interpret business needs into technical/functional
specifications. Converted business objectives into data models, ETL workflows, and KPI frameworks for reporting.
SQL Development & Database Optimization: Developed high-performance stored
procedures, triggers, and scripts to automate data pipelines, reducing manual effort by
40%. Designed clustered/non-clustered indexes and optimized complex joins
(inner/outer/cross) to slash query runtime by 35%. Created materialized views and indexed views to accelerate large-scale data aggregation. Resolved
database/server-level issues (deadlocks, query bottlenecks) proactively.
Power BI Dashboard Development: Built interactive dashboards aligned with organizational branding, using: Tables/Matrices with drill-down capabilities. DAX
measures for time-series analysis (YTD/QoQ trends). Visual/Page/Report-level filters
for dynamic user exploration. Implemented Static/Dynamic RLS to restrict data access by user roles via Power BI Service. Developed parameter-driven Power BI templates for reusable reporting across departments.
ETL & Data Pipeline Automation: Engineered SSIS packages to automate data ingestion from SQL Server, flat files, and APIs. Built Python/SQL validation scripts, improving data accuracy by 30% and reducing audit risks.
Deployment & User Enablement: Published dashboards to Power BI Service, enabling access via web/mobile apps. Configured automated subscriptions for scheduled report delivery to stakeholders. Conducted user training to promote self-service analytics
Client: Merck IN Jan 2020 – Sep 2021
Role: Power BI Developer
Goal: To leverage advanced data analytics and BI solutions to drive informed decision-making across pharmaceutical operations, including drug development, clinical trials, and market strategy. By integrating data from multiple sources, optimizing ETL processes, and utilizing tools like Power BI and AWS Redshift, the aim is to improve reporting efficiency, reduce costs, enhance data accuracy, and support market growth.
Responsibilities
Analysed large-scale pharmaceutical datasets using SQL and Power BI, delivering actionable insights on drug efficacy, patient outcomes, and financial KPIs, boosting reporting efficiency by 35%.
Led the end-to-end migration of on-premises data to AWS Redshift, improving query performance by 30% and reducing data storage costs by 40%, accelerating access to clinical and regulatory datasets.
Developed interactive Power BI dashboards to monitor real-time metrics related to clinical trial progress, drug pipeline stages, and regional sales, enabling 30% faster business decision-making.
Integrated and modeled data from multiple domains (clinical trial systems, regulatory platforms, sales databases) to build a centralized semantic model in Power BI, streamlining collaboration across departments.
Implemented advanced DAX calculations to perform trend, cohort, and time-series analyses, helping identify market patterns and treatment effectiveness, supporting targeted product positioning and growth.
Improved data quality and compliance by building automated validation scripts in Python and SQL, reducing manual errors by 25%, and enhancing the accuracy of reports submitted to regulatory bodies.
Customized Power BI reports and visuals based on cross-functional stakeholder inputs including clinical teams, regulatory affairs, and market analysts, enabling tailored insights for diverse use cases
Participated in Agile delivery cycles, including sprint planning, story grooming, and testing, ensuring all dashboards met regulatory standards, HIPAA compliance, and internal validation protocols.
Designed key visualizations such as stacked bar charts, trend lines, KPI cards, matrix tables, slicers, and conditional formatting to enhance usability and interpretation for non-technical users.
Collaborated closely with DevOps and Data Engineering teams to optimize ETL pipelines, define data refresh schedules, and maintain data lineage documentation.
Client: Karvy Financial IN June 2018 – Dec 2019
Role: Data Analyst
Goal: To develop and deploy interactive Power BI dashboards that provide real-time insights
Responsibilities
Assisted in designing Power BI dashboards for financial reporting and client lifecycle monitoring, enabling faster insights for business users.
Supported the automation of data extraction and reporting tasks, improving order tracking efficiency and enhancing visibility into revenue trends.
Conducted basic financial and inventory analysis using SQL queries and SAP, contributing to improved stock management and operational planning.
Collaborated with the analytics team to perform time-series analysis in Power BI, helping improve forecasting accuracy for inventory and sales.
Participated in data migration efforts to SAP, ensuring the accuracy and consistency of financial records across legacy and ERP systems.
Provided support during Power BI training sessions, helping users build self-service capabilities for ad-hoc reporting and financial analysis.
Aided in integrating SQL Server databases with Power BI, enabling real-time financial performance tracking through dynamic visualizations and metrics
Contact this candidate