Power Bi Business Intelligence
Resume:
Jyothi Akula
Contact: +1-508-***-****
EmailId: **********@*****.*** www.linkedin.com/in/jyothi4362
PROFESSIONAL SUMMARY:
Results-driven Business Intelligence Developer with 8+ years of experience in data analytics, dashboard/report development, and business process automation. Highly skilled in Power BI (Desktop, Service, and Report Server), DAX, M Code, and SQL Server, with practical expertise in Azure, Power Apps, Power Automate, Tableau, and MSBI (SSIS). Proven ability to convert complex data into clear, actionable insights that support strategic business decisions.
●Proficient in Power Query, Power Pivot, and Power View for developing dynamic, interactive reports and dashboards.
●Hands-on experience with Power BI versions 2.5x/2.7x, creating innovative and scalable reports in both on-prem and Azure cloud environments.
●Expertise in building efficient data models, defining fact/dimension tables, and establishing data relationships to support advanced analytics.
●Skilled in managing Power BI workspaces, datasets, gateways, and schedule refresh configurations, including failure notifications.
●Designed and published numerous custom and standard visualizations, using bar, waterfall, donut, line, scatter, histogram, tree maps, tabular, and KPI visuals.
●Implemented Row-Level Security (RLS) and created content packs for role-based report access and reuse across teams.
●Strong background in data analysis, data cleansing, data integration, and data migration using complex SQL queries, T-SQL, and Excel.
●Utilized DAX functions extensively, including aggregation, logical, text, date, and table functions like FILTER, ALL, VALUES, RELATEDTABLE, and DISTINCT.
●Applied visual interactions and filters (visual, page, and report-level) to create intuitive, interactive dashboards.
●Experience developing SSIS packages to extract, transform, and load (ETL) data into SQL Server databases.
●Built and published enterprise-grade Power BI dashboards accessible via web clients and organizational portals.
●Worked extensively with SQL Server database objects including temporary tables, CTEs, views, stored procedures, user-defined functions, and joins.
●Involved in end-to-end testing phases including UAT, system testing, and defect tracking using tools like ClearQuest.
●Proactive team player with strong analytical and problem-solving skills, able to work independently or collaboratively while documenting functional and process flows.
EDUCATION:
Bachelor of Technology in Computer Science, from ANU, A.P, India (2012).
TECHNICAL SKILLS:
Business Intelligence : Power BI Desktop, Power BI Service, Power BI Report Server, Tableau
Data Modeling & Querying : DAX, M Language (Power Query), T-SQL
Databases : SQL Server, Azure SQL Database
Cloud Platforms : Microsoft Azure
Automation & App Development: Power Apps, Power Automate
Other Tools : Excel, SharePoint, Git, REST APIs
PROFESSIONAL EXPERIENCE:
Collain Health, NY Aug 2022 - Till Date
Power BI Developer
Responsibilities:
●Collaborated with the project team to define project requirements and deliverables.
●Operated within an Agile framework as an individual contributor, actively participating in story grooming and reviewing user stories and acceptance criteria with business stakeholders.
●Connected to various data sources to import, shape, and transform data for business intelligence (BI) reporting using Power BI Desktop.
●Designed and developed clinical and administrative dashboards, including:
Clinical Pressure Ulcer, Clinical Infection Control, Clinical Safety, Clinical Nutrition, State QIP Program, Clinical Rehospitalization, Administrative Resource KPI and Resident-level Reports
●Collaborated with the database team to build necessary SQL views; imported these into Power BI and performed data transformation using Power Query (M code)
●Developed data models by creating appropriate relationships between fact and dimension tables
●Implemented complex DAX measures and calculations for KPIs such as ADC, Patient Days, Pressure Ulcer prevalence/incidence, Infection Rate, Fall Rate, and weight change percentages
●Built rich visualizations using Gauge Charts, Line & Clustered Column Charts, Slicers, and Tabular Views to enhance report interactivity and insights
●Managed Power BI workspaces across DEV, UAT, and Production environments, including user access and report version control
●Published reports from Power BI Desktop to the Power BI Service for all environments
●Configured and managed Power BI Data Gateway for scheduled data refreshes and implemented alerting for refresh failures
●Performed Power BI administrative tasks including access control at workspace, report, and app levels
●Created and published Power BI Apps to distribute report content and manage user access Utilized SharePoint for version control and report lifecycle management
●Engaged directly with external users and stakeholders to gather feedback and make on-demand updates to reports
●Reviewed and published .pbix files from SharePoint to Power BI Workspaces
●Proactively monitored refresh failures and took immediate corrective actions to ensure report availability
●Collaborated with fellow Power BI developers, sharing datasets and .pbix files to streamline development and ensure consistency across reports
Franciscan Health, IN Apr 2021 - June 2022
Power BI Developer
Responsibilities:
●Collaborated with business users to gather and analyze reporting requirements, providing accurate time and effort estimates for report development.
●Migrated legacy Cognos reports to modern, interactive Power BI reports, improving usability and performance.
●Led the design and development of key business reports including: Finance Reports, Physician Metrics, FSI Metrics, Care Variation, Case Management, Executive Summary, ICCR, Patient Placement, Readmission Management
●Participated in peer review processes for report quality assurance and ensured proper publishing to Power BI Workspaces.
●Managed BISReports workspace, including Power BI Gateway configuration, scheduled refresh setup, and monitoring refresh failures with proactive resolution.
●Developed SQL Server views and imported them into Power BI, building robust data models with relationships between fact and dimension tables.
●Created complex DAX measures and calculations for KPIs such as: Actual vs. Target wRVU, Average and Total OP Office Visits (12-month view) by Department, Group, and Provider, Custom Date-based functions to support dynamic analysis
●Imported .pbix files from SharePoint, reviewed content, and published finalized reports to the appropriate workspace.
●Delivered over 12 multi-page Power BI reports, leveraging various advanced visualizations and interactions.
●Optimized high-volume Finance Report to address memory usage issues, improving performance when handling large datasets.
●Monitored scheduled report refreshes and resolved failures promptly to ensure uninterrupted access for business users.
●Worked collaboratively with Power BI team members by sharing datasets and .pbix files to promote consistency and reuse.
●Designed report front pages using custom canvas backgrounds and integrated Program Numbers as Report IDs for easy identification.
●Implemented interactive features using:Slicers, Line and Clustered Column Charts, Stacked Column Charts, Navigation buttons, Matrix and Table visuals, Conditional formatting to visualize % of wRVU Target with color cues
●Built reports with drill-down, drill-through, and sync slicer functionalities to enhance user navigation and insight discovery.
●Performed volume testing on Curator Analytics Hub to validate report performance under large data loads.
AT&T, TX Feb 2019 - Mar 2021
Power BI Developer
Responsibilities:
●Collaborated with project teams to define and refine business intelligence (BI) requirements for reporting solutions.
●Connected to various data sources, imported, shaped, and transformed data to build reliable BI models in Power BI.
●Developed robust SQL queries for data reconciliation and validation during data migration projects.
●Designed and implemented DAX expressions for creating calculated columns and custom measures, including time-based columns (e.g., Year, Quarter).
●Built and managed Tabular Models with partitions to improve Power BI performance and scalability.
●Leveraged Power BI’s self-service BI capabilities to empower users with on-demand analytics.
●Used advanced Power BI features such as data blending, hierarchies, actions, and filters to create interactive and insightful reports.
●Applied statistical analysis within Power BI to support trend analysis and forecasting initiatives.
●Managed report and dashboard permissions to control user access based on roles and security levels.
●Used Quick Insights to automatically generate relevant visualizations for rapid prototyping.
●Established and managed relationships between fact and dimension tables using the relationship view.
●Applied visual-level, page-level, and report-level filters to enhance data exploration.
●Designed and published engaging reports and dashboards to the Power BI Service for business users.
●Created user roles and distributed dashboards to clients and stakeholders through secure access.
●Built a Content Pack Library to enable team members to reuse dashboards and reports efficiently.
●Established best practices for database design and Power BI development processes.
●Successfully integrated custom visuals into reports to meet specific business visualization needs.
●Configured and maintained on-premises Power BI Gateway for scheduled dataset refresh and seamless integration.
●Designed complex SSRS reports, including:Parameter-driven reports, Graphical reports, Excel exports, Drill-down charts and Tabular reports
●Used Power BI to create diverse visualizations such as Line Charts, Pie Charts, Histograms, Maps, Scatter Plots, and Bullet Charts.
●Managed and scheduled data-driven subscriptions on SSRS Reporting Server to deliver automated reports to stakeholders.
●Generated and delivered on-demand reports for strategic decision-making using SSRS capabilities.
Philip Morris International, NY Jun 2018 - Dec 2019
Power BI Developer
Responsibilities:
●Collaborated with business users to gather, analyze, and estimate reporting requirements for BI solutions.
●Designed and developed Power BI reports and dashboards using data from SQL Server and Tabular SSAS sources.
●Developed Power BI scripts and queries to import and transform data from various sources using Power Query (M) and DAX.
●Built diverse and interactive visualizations including:Drill-down and drill-through reports, Sync slicers, Time intelligence reports such as Year-to-Date (YTD), Month-to-Date (MTD), and Same Period Last Year
●Created customized dashboards with trend lines, reference lines, and interactive filters to support business decision-making.
●Built calculated columns, measures, views, and calculated tables to enhance data models and support analytical needs.
●Published reports and datasets to Power BI Service, configuring row-level security (RLS) and role-based access control to secure sensitive data.
●Managed On-Premises Data Gateways to schedule dataset refreshes and maintain up-to-date dashboards.
●Scheduled and monitored data refreshes for published datasets and ensured continuous data availability.
●Created reusable data models shared across multiple reports to maintain consistency and improve efficiency.
●Implemented report-level, page-level, and visual-level filters to enable flexible data slicing and analysis.
●Published Power BI dashboards and made them accessible via web clients and across organizational portals.
●Used Power BI Desktop and Power BI Service for full lifecycle report development—from data modeling and design to publishing and sharing.
●Applied row-level security (RLS) to restrict data visibility by user roles, enhancing compliance and data governance.
●Worked on optimizing report performance and aligning designs with Power BI best practices.
●Contributed to team collaboration by maintaining report assets, sharing datasets, and adhering to version control protocols.
Intuitive Surgical, CA Jun 2017 – May 2018
Tableau Developer
Responsibilities:
●Participated in requirement gathering sessions and design meetings to understand business needs and define report specifications.
●Led Post-Market Analytics efforts, delivering actionable insights to the manufacturing team by identifying product defects and uncovering opportunities for quality improvement.
●Developed interactive Tableau dashboards by connecting to Microsoft SQL Server and writing complex SQL queries for data extraction and transformation.
●Performed comprehensive data analysis and integration from multiple source systems to create unified and meaningful datasets.
●Utilized advanced Tableau features such as data blending, joins, calculated fields, parameters, sets, and date functions to create clean, user-friendly dashboards for both technical and non-technical stakeholders.
●Designed and built a Customer 360 Dashboard and associated KPIs to provide a holistic view of customer interactions and issues.
●Analyzed Robotic Surgery Equipment complaints and return patterns based on factors such as material type, system model, and diagnosis category.
●Developed and maintained Crystal Reports for audit purposes, capturing comprehensive complaint records for compliance and quality review.
●Rationalized and enhanced fragmented quality workbooks in Tableau by consolidating data from disparate sources and standardizing metrics.
●Used Tableau Data Parser to generate structured report columns and streamline report development.
●Served as onsite lead, successfully managing critical deadlines and stakeholder expectations in a high-pressure environment.
●Built visually impactful dashboards highlighting Key Performance Indicators (KPIs) and sparklines to meet evolving business requirements and support executive decision-making.
Contact this candidate