Data Analyst Power Bi

Srivani Samula

Email ID: *********************@*****.***

Contact: 326-***-****

Data Analyst

Professional Summary:

Analytical and results-oriented Data Analyst with 4 years of experience in transforming raw data into strategic insights to support business growth and operational efficiency.

Expert in Power BI dashboard development, including custom visuals, drill-downs, bookmarks, and KPI tracking for business stakeholders.

Strong proficiency in SQL, including writing and optimizing stored procedures, joins, views, CTEs, and complex queries across relational databases.

Experienced in working with diverse data sources such as data warehouses, data marts, APIs, Excel, and cloud databases (Azure, AWS, GCP).

Skilled in data modelling, creating star/snowflake schemas, and designing data models to support BI reporting with optimal performance.

Proficient in DAX for authoring calculated columns, measures, and time intelligence functions to support interactive Power BI reports.

Designed and deployed 30+ interactive Power BI dashboards with drilldowns, KPI tracking, and custom visuals, improving decision-making speed for cross-functional teams.

Developed complex SQL queries, stored procedures, and views for data extraction, transformation, and analysis, reducing report generation time by 40%.

Optimized SQL performance through indexing, query tuning, and data model improvements, increasing dashboard refresh speed by 25%.

Integrated diverse data sources (data warehouses, APIs, cloud databases) into unified Power BI models, ensuring high data accuracy and consistency.

Demonstrated ability to manage the end-to-end BI lifecycle—from gathering requirements and data analysis to report development and stakeholder training.

Adept at building automated reporting systems using Power BI Service, Power Query, and scheduled data refresh pipelines.

Experience in developing and validating financial reports, risk models, and performance dashboards across domains like credit risk and healthcare.

Strong command of Python (Pandas, NumPy, Matplotlib) for ad-hoc analysis, automation, and data manipulation outside of BI platforms.

Worked extensively on SSRS to build paginated reports, sub-reports, and drill-through reports for enterprise- level financial reporting.

Migrated legacy dashboards and manual reports to modern BI platforms (Power BI), improving usability, scalability, and data governance.

Experienced in data cleaning, transformation, and feature engineering, ensuring high data quality and consistency across reporting layers.

Education Details:

Master’s in information technology from Indiana Wesleyan University. 09/01/2022-04/28/2024 Technical Skills:

Skill Description

Power BI Creating interactive dashboards, custom visuals, DAX calculations, and KPI tracking.

SQL Writing complex queries, joins, stored procedures, and query optimization for performance.

Python Data cleaning, transformation, and visualization using Pandas, NumPy, and Matplotlib.

Data Modeling Designing star and snowflake schemas to support efficient BI reporting. ETL Processes Extracting, transforming, and loading data from diverse sources using SSIS and Power Query.

Statistical

Analysis

Performing hypothesis testing, regression, and descriptive statistics for insights.

Data

Visualization

Storytelling with data through charts, reports, and executive dashboards. Professional Experience:

Responsibilities:

Developed and maintained ETL processes using SQL Server Integration Services (SSIS) to extract, transform, and load data from various sources including legacy systems.

Migrated legacy DTS packages to SSIS, leveraging advanced SSIS features to enhance performance and maintainability.

Designed and implemented database schemas, physical data models, and data warehouse models using Erwin and SQL scripts.

Created and optimized stored procedures, triggers, views, user-defined functions, and T-SQL scripts for high-performance data operations.

Applied SQL performance tuning techniques to reduce ETL run-time and improve query execution efficiency.

Created optimized stored procedures, triggers, and functions, reducing ETL runtimes by up to 20%.

Delivered more than 100 SSRS reports, including executive dashboards, compliance reports, and operational summaries, enabling faster data-driven decision-making.

Built complex SSIS packages with control/data flow, error handling, logging, configuration files, and scheduling for automated execution.

Designed and delivered a variety of SSRS reports, including Tablix, matrix, tabular, and dashboard- style reports for key business metrics.

Involved in the entire SSRS report lifecycle including report creation, deployment, and scheduled delivery.

Developed custom .NET components and VB scripts for specialized SSIS transformations and extended integration functionality.

Created data integration pipelines to support OLTP, ODS, and data warehouse layers, handling daily/weekly/monthly file transfers and ingestion processes.

Managed data integrity through implementation of constraints, complex joins, and referential checks in SQL.

Conducted database capacity planning, created and managed databases, tables, and indexes for scalable data management.

Wells Fargo May 2024- Present

Data Analyst

Enhanced and deployed SSIS packages to production environments and configured SQL Server Agent Jobs for automation.

Exported and imported databases between local and remote servers using SSIS for backup, migration, and deployment purposes.

Built TIBCO Spotfire dashboards for visualizing KPIs and operational metrics, enabling better executive oversight.

Collaborated with cross-functional teams to ensure ETL workflows aligned with business needs and regulatory requirements.

Automated report scheduling and data refresh processes through SQL Server Agent jobs.

Collaborated with cross-functional teams to resolve performance issues and provide support for UI and external data interface teams.

Created dashboards using TIBCO Spotfire and maintained reporting components across Red Hat Linux, SharePoint, and .NET platforms.

Environment: MS SQL Server 2016/2014, SSIS, SSRS, SSAS, T-SQL, Erwin Data Modeler 9.2, MS Office, MS Visio, .NET Framework, Java, XML, Red Hat Linux, Putty, SharePoint, Tibco Spotfire. HealthifyMe, India April 2019- July 2022

Data Analyst

Responsibilities:

Based on your provided responsibilities—which clearly show experience with Power BI, SQL, SSRS, credit risk modelling, and enterprise-level BI solutioning—here’s a tailored version of a Data Analyst responsibility statement for a company like HealthifyMe, which operates in health, nutrition, fitness, and wellness data analytics.

HealthifyMe – Data Analyst Role: Tailored Responsibility Statement

Acted as a key Data Analyst contributing to HealthifyMe’s mission by delivering actionable insights across user health journeys—enabling data-driven decision-making in fitness, nutrition, and user engagement strategies.

Designed, developed, and deployed over 30 interactive Power BI dashboards tracking key business KPIs such as user retention, calorie tracking accuracy, subscription conversions, and workout adherence, resulting in an 18% improvement in user engagement.

Integrated and transformed datasets from multiple sources—mobile app telemetry, nutrition logs, wearable devices, and CRM data—into a unified data warehouse, reducing data preparation time by 40%.

Developed advanced DAX calculations and custom visuals for segmenting and comparing user health trends across demographics and app features, enabling personalized recommendations.

Designed, developed, and maintained interactive dashboards using Power BI to track KPIs such as user retention, calorie tracking accuracy, subscription conversions, and workout adherence.

Integrated and transformed large datasets from various sources including mobile app telemetry, nutrition logs, wearables, and CRM databases, creating unified data models to drive business intelligence.

Developed DAX measures and custom visuals to segment and compare user health trends across cohorts, regions, and app features—supporting personalized health recommendations.

Collaborated with product managers, fitness experts, and marketing teams to identify key metrics, enhance reporting capabilities, and enable real-time performance monitoring of A/B tests and user experiments.

Optimized SQL queries and data pipelines feeding dashboards and reports to ensure consistent, high-quality data for decision-making in areas like diet planning and engagement optimization.

Automated recurring health analytics reports to support nutritionist teams, leadership reviews, and wellness product design through Power BI Service, Power Query, and scheduled refreshes.

Supported user behaviour analysis by creating ad-hoc reports and visualization tools to uncover patterns in user goals, weight-loss journeys, and engagement with AI-based coaching (e.g., Ria).

Created SQL queries and stored procedures to feed dashboards, optimizing query execution and improving refresh speeds by 25%.

Contributed to wellness scoring and engagement prediction models by collaborating with Data Science teams— aligning analytics workflows to support proactive health interventions and habit formation. Environment: SQL Server 2019/2017/2016, SSIS, SSRS, Power BI, SQL Server, Power Query, Python, SSRS, Azure for cloud data, Jira, pandas, RESTAPI, Excel, Jupyter notebook, Google analytics.

Contact this candidate