Summary
Overview
Work History
Education
Skills
Certification
Awards
Timeline
Generic
Sathish Kumar Boda

Sathish Kumar Boda

Charlotte,North Carolina

Summary

Microsoft Power BI Certified professional with 12+ years of experience in Business Intelligence & Analytics, Data Warehousing, and Data Visualization. Adept at leading end-to-end data solutions, leveraging cutting-edge tools like Power BI, Tableau, and Azure. Skilled in Data Analysis, ETL Processes, and Business Requirement Gathering, with extensive exposure to Healthcare, Insurance, and Financial Services domains.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Senior Power BI Developer

CRC Insurance Services [Truist]
08.2024 - Current
  • Analyze property and casualty insurance data, including claims, policies, premiums to identify trends and key performance metrics.
  • Working with Power BI Desktop workbooks and data models that are created using Data Analysis Expressions (DAX).
  • Ensure data representation aligns with insurance regulations, including compliance with industry standards like ISO, NAIC guidelines, and GDPR.
  • Designed and developed analytical reports to show metrics related to Visits, SOV Uploads, Success Percentage Locations, Quotes, etc.
  • Communicated with other departments and external vendors to finalize transactions, cash disbursements, and collections.
  • Built multiple data visualizations using Power BI in the form of interactive reports and dashboards Interacting with client on the requirements and
  • Delivered different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps etc.
  • Worked on various Visualization types; also mapped data structures into compatible Visualization formats as per user preferences.
  • Extract, transform, and load (ETL) data from various sources such as SQL Server into Power BI for reporting purposes.
  • Overseeing the Power BI projects, from requirements gathering to deployment and post-implementation support on-site.
  • Provide training and support to end-users, enabling them to effectively use Power BI reports and dashboards.
  • Leverage extensive experience in semantic layer development to model complex datasets, ensuring data accuracy and consistency.
  • Collaborate with clients to gather feedback, provide training, and ensure the successful adoption of Power BI solutions.
  • Gather, analyze, and interpret complex datasets to identify trends, patterns, and actionable insights for business decision-making.
  • Used advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table) Gathered functional and non-functional client requirements to optimize the design of BI deliverables (reports, dashboards, alerts, visualizations).
  • Project is managed using Azure DevOps tool, following Agile Methodology where sprint lasts for 2 weeks.
  • Collaborated with Subject Matter Experts and Product Owners to define data requirements and source-to-target mapping necessary to support advanced analytics initiatives.
  • Used SQL queries to create interactive Dashboard, used Azure Data Studio to write SQL queries.
  • Created Views based on the requirements for the new Power BI report and interact with Data Admin team to get the deployments.
  • Tools and Technologies used: Microsoft Power BI Desktop, Power Builder, SQL, ER Studio, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Power BI Service, Azure DevOps, DAX, Azure Data Factory, Measure Killer, ALM Toolkit, DAX Studio, SSMS.

Sr. Power BI Developer

FedEx
08.2023 - 08.2024
  • Creating new data models and making changes in the Fact/dimension table to update the data.
  • Made logical changes to the partitions using Tabular Editor to load the last 14 months' data in the semantic layer.
  • Working on logical and physical Dimensional Modeling, ER Modeling using ER Studio, Snowflake Schema, Fact and Dimensional tables and Operational Data Store (ODS).
  • Working on building an Outbound Call Centre (OCC) Dashboard to explain the metrics pertinent to Call data, AHT, No. of cases, Connect Rate, etc.
  • Adding Global Problem Resolution Metrics to Semantic Layer.
  • Maintain and monitor azure analysis services metrics.
  • Writing DAX queries for creating measures and calculated columns needed for Power BI Visuals.
  • Used Logical, Informational and Date & Time functions for quick conversion of data from source.
  • Validate the Tables and Views in Dev and load the prod data when requested.
  • Building notebooks using python script for processing large data.
  • Implement report generation among Power BI, SSRS and Python reports.
  • Created paginated reports using PowerBuilder.
  • Optimize the performance of Power BI reports by optimizing the data model using tools like Measure Killer.
  • Deployed Power BI Dashboard to Power BI Services and scheduled the data refresh.
  • Working on migrating the existing Power BI reports to ‘pbi’ model with Databricks as data source.
  • Collaborating with Microsoft resources to increase the performance of existing reports.
  • Optimizing the Power BI reports by validating the user log and creating log analytics workspace.
  • Creating Databricks notebooks in Azure cloud using Hive and Databricks DB.
  • Tools and Technologies used: Microsoft Power BI Desktop, Power Builder, SQL, ER Studio, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Power BI Service, Azure DevOps, DAX, Azure Data Factory, Measure Killer, ALM Toolkit, DAX Studio, SSMS.

Power BI Developer

Thryve Digital Health LLP
09.2021 - 07.2023
  • Coordinated with Stakeholders, Business Analysts for defining the project scope and discussing the Power BI Solutions.
  • Gather and Imported Daily & Historical data related to Insurance payment files using SQL tool SSMS.
  • Created paginated reports using report builder indicating the Loss Ratio, Policy Retention Rate, Policy Turnover Rate, CLV, CSAT parameters.
  • Examined claim requests status and financial statements, generate summary reports, monitor rate changes, develop financial models, and complete forecast reports.
  • Created Power BI visualization of dashboards and scoreboards (KPI) for claim processing department.
  • Analyzed business requirements, created business/process flow charts, database flowcharts.
  • Design and create innovative and valuable visualizations to identify patterns, trends and expectations which enable the business executives and senior leaders to make data driven decisions.
  • Generated ad-hoc reports in Excel Power Pivot and shared them using Power BI to the decision-makers for strategic planning.
  • Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
  • Designed, developed, and implemented end-to-end data processing pipelines using Databricks, leading to a 30% reduction in processing time and improved data accuracy.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Implemented Role-Based Security as part of security in Power BI.
  • Created notifications and alerts, subscriptions to reports in the Power BI service.
  • Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards collaborate using workspaces, apps, and get quick insights into datasets.
  • Participating in Daily stand-up Agile/Scrum meetings to discuss the enhancements to be made for the existing requirements.
  • Used Service Now ticketing tool for any procurements or any dependencies from the business side.
  • Presented the tickets status along with project development status in Weekly status calls to the stakeholders and managers.
  • Worked in CI/CD ways of working using tools like Azure DevOps.
  • Tools and Technologies used: Microsoft Power BI Desktop, SQL, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Power BI Service, Azure DevOps, DAX.

Power BI Developer

Thryve Digital Health LLP
01.2021 - 08.2021
  • The Scope of the project is developing Complex reports using Microsoft Power BI connecting with SAP HANA, Snowflake and creating Paginated reports with Teradata, oracle, MS-SQL as source.
  • Extracted data for reporting from multiple data sources like SQL Server, SQL Server Analysis, Service, Azure SQL Database, Azure SQL Data Warehouse, Salesforce, etc.
  • Interacted with the Stakeholders, Business Users, System Architects, Developers to understand data models and structural data hierarchy.
  • Used Data Analysis Expressions DAX to create custom calculations in PowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
  • Created PowerPivot models and PowerPivot reports, publish reports onto SharePoint, and deploy models into SQL Server SSAS instance.
  • Assisted in creating SQL database maintenance logs and presenting any issues to the database architects.
  • Worked on Power BI reports using multiple types of visualizations including line charts, doughnut charts, tables, matrix, KPI, scatter plots, box plots, etc.
  • Made Power BI reports more interact and activate by using storytelling features such as bookmarks, selection panes, drill through filters, etc. Manage customer relationships and expectations by developing communication process to keep others up-to date on project results.
  • Adopt in analyzing bugs, interacting with team members in fixing errors and UAT and assisted in Postproduction support.
  • Managed the Requirements clarification or pending items from business end using the ticketing tool “Service Now.”
  • Conducted RCA to the missed SLA tickets and presented them to management for further communication to clear up the dependencies.
  • Uses Azure DevOps / Team Foundation Server (TFS) to respond to organizational requests, document, and track progress, and maintain version control of reports and code.
  • Conduct
  • Awarded BRAVO for the successful and quality delivery of project.
  • Tools and Technologies used: Microsoft Power BI Desktop, SQL, MS Smart sheet, Azure Boards, Azure Cloud, EXCEL, Power BI Service, Azure DevOps, DAX.

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
02.2020 - 01.2021
  • Develop the Dashboards using the data from Customer Communication Management tool, where age, category filters and apply Display rules for individual paragraphs.
  • Designed and developed SSIS Packages to import and export data from MS Excel, and Flat files to SQL Server.
  • Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.
  • I am proficient in performing data analysis, querying data bases, and utilizing SQL query tools.
  • Created stored procedures, functions, indexes, views based on data processing and data cleansing.
  • Involved in creating DAX and tabular models using SQL Analysis Services (SSAS). Used diverse types of visualizations (Stacked bar chart, Clustered bar chart, Scattered chart, Pie chart, Donut chart, Line & Clustered column chart, Decomposition tree, Card, Map, Slicer etc.) in Power BI according to the requirements.
  • Used Power BI to collaborate with different users and stakeholders to work on live data sources.
  • Understand, own, and support operational dashboards, business performance dashboards, interpret the results, summarize opportunities for improvement, and make recommendations.
  • Create reports in Power BI desktop and publish reports to respective workspaces, apps and automated the process to show the latest data.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Conduct training sessions with business users on Power BI reports and Dashboards.
  • Performed user acceptance testing to ensure system integrity before release to production.
  • Tools and Technologies used: SQL Server 2012, Visual Studio, SSIS, MS Office 365, Power BI Desktop, DAX, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum).

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
08.2019 - 09.2020
  • HEDIS RateMax 430 Processing Team processes claims based on the determination made by the clinical investigation department. Developed and embedded the dashboards using Power Bi into the application.
  • Worked with different team's clients, analytics, data sources, QA and visualization.
  • Worked in agile process having expertise in life cycle of a project from start to end.
  • Created data warehouse and data marts from scratch based on data structures and reporting needs.
  • Worked on writing ad hoc SQL scripts which are required for reporting purposes. Worked on creating basic dashboards in tableau connected to Azure SQL database for client reporting.
  • Worked on user management for power bi. Sharing the dashboard access for power bi online.
  • Worked on Power BI dashboards and ad hoc DAX queries for power bi.
  • Extensive back-end support for many various reports on Tableau and Power BI.
  • Created store procedures, functions, triggers, indexes, views based on data processing and data cleansing.
  • Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.
  • Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
  • Hands on experience in working with Applications Migration and App Development in AZURE.
  • Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
  • Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.
  • Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
  • Extensive knowledge in developing PL/SQL codes using Oracle 11g.
  • Create and review SSAS tabular cubes for consuming as a data source for reports, Dashboards, Pivot table.
  • Worked on creating multiple databases from scratch.
  • Worked on Azure SQL data warehouse and database development. Experienced user of PL/SQL for development of server-end program units as well as reusable codes using Procedures, functions and worked on ad hoc change tickets.
  • Tools and Technologies used: Microsoft Visual Studio2016, SQL Server, Azure, Power BI, Power Pivot, SAS EG, Teradata SQL assistant, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum).

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
06.2019 - 08.2019
  • EMR Audit is the project to Audit the Medical Records attended by the Associates. It includes validating the fields (Parameters) addressed by the associates and consolidating the user wise day to day reports. Includes refreshing the data, formatting report, developing the Dashboards, saving the file to the desired location, and emailing to DL list. Code and provide an implementation for new enhancements.
  • Created various SSIS packages for data movements and transformations. Worked on Python code to load data from Google buckets to big query tables, used data flow for ELT (Extract Load Transform) in Big Query.
  • Worked on creating POC for data movement in NiFi (Hortonworks), C# programming used in script task for SSIS and in Azure functions to create retrievers for data pull from API.
  • Hands on experience in working with Applications Migration and App Development in AZURE.
  • Worked on Web jobs, AZURE data factory, Logic Apps for application and project development in Azure.
  • Worked on Web Applications in Azure and Azure functions to pull data from API to blob Storage and SQL.
  • Worked on deploying web sites in Azure and used MVC framework on backend. Experienced in Developing PL/SQL - Procedures, Functions, SQL Scripts and Database Triggers to populate the data applying business logic.
  • Extracted data from data warehouse server by developing complex SQL statements using stored procedures and common table expressions (CTEs) to support report building.
  • Tools and Technologies used: Windows XP, AWS, Mainframe, Java, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, UiPath, UiPath Studio, Orchestrator.

Power Bi/Business Analyst

Rapra Software Technologies
03.2016 - 06.2019
  • Patient Access Management tool is developed and incorporated the new features where the associate will have access to patient’s previous visit data. Analyst will be provided with the Insurance information, to which the patient is subscribed to and looking at the bill details for the treatment, the analyst will be able to give basic payment information to the patient.
  • Requirements gathering, Analysis, design, coding, and unit testing, UAT.
  • Developed C# code for validating the data before giving input to BOT.
  • Interacting with clients to understand the business daily.
  • Preparing feasible study documents based on the requirement.
  • Visualization and Responsible for conducting scrum events.
  • Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of test scenarios and cases to ensure that the system being built is resilient.
  • Created BRD, FRS documents describing the end-to-end requirements for the project.
  • Involved in the design and development of HTML presentations using CSS & XSLT.
  • Create UML diagrams and maintain meeting notes and prototypes.
  • Develop wireframes using tools and create application mock-up designs.
  • Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.
  • Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, HTML 5.

Business Analyst

Rapra Software Technologies
02.2014 - 12.2016
  • RevAudit is an Audit application which runs as an extension to the medical coding application. RevAudit takes the input from RevCode by applying rules to the input data that is provided to the application. It is a Process/ Client independent platform acting as a centralized dashboard and reporting tool. RevAudit was designed as a one-stop shop for all the Business operations.
  • Requirements gathering, Analysis, design, coding, and unit testing, UAT.
  • Create and maintain project artifacts related to business requirements.
  • Interacting with clients to understand the business daily.
  • Preparing feasible study documents based on the requirement.
  • Visualization and Responsible for conducting scrum events.
  • Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of test scenarios and cases to ensure that the system being built is resilient.
  • Created BRD, FRS documents describing the end-to-end requirements for the project.
  • Involved in the design and development of HTML presentations using CSS & XSLT.
  • Create UML diagrams and maintain meeting notes and prototypes.
  • Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.
  • Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012, Angular JS, HTML 5, J Query.

Business Analyst

Rapra Software Technologies
05.2012 - 12.2014
  • RevCode is a medical coding application developed to capture the CPT and ICD codes. It is a Process/ Client independent platform acting as a centralized dashboard and reporting tool. RevCode was designed as a one stop-shop for all the Business operations. Associates right from the leadership team to entry-level associates use to track and conduct their work in compliance with regulations and strategic goals.
  • Involved in the design and development of Mockup screen presentation.
  • Collaborated with stakeholder groups across the organization to ensure business and technology alignment. Proposed solutions meeting defined specifications and needs.
  • Supported multiple projects including migration project, Vendor product project and legacy product Project.
  • Successfully resolved ad-hoc assignments on statement imbalances and adjustments quickly and accurately.
  • Involved in the Workshops with the clients and participated in the discussion for new requirements to be added to the current deliverable product to get the strategic solution and implement it.
  • Worked with the IT risk and regulatory teams to understand the enterprise-wide risk and regulatory reports by working closely with healthcare data providers, report preparers and report owners.
  • Used Agile SCRUM methodology for tracking defects and managing the project.
  • Defined and created Jira project, product backlog, iterations and scrum boards and provide artifact visualization and Responsible for conducting scrum events.
  • Used MS Office suite (Word, Excel, Access, Power Point) for project tracking, documentation, presentation and managing the document in developing a variety of test scenarios and cases to ensure that the system being built is resilient.
  • Created BRD, FRS documents describing the end-to-end requirements for the project.
  • Involved in the design and development of HTML presentations using CSS & XSLT.
  • Create UML diagrams and maintain meeting notes and prototypes.
  • Develop wireframes using tools and create application mock-up designs.
  • Formulated Use Cases for each business requirement and normalized the use cases to suit the requirements.
  • Tools and Technologies used: Windows XP, AWS, Mainframe, Java, Postman, SQL, Jira, Confluence, SharePoint, MS Excel, MS Microsoft word, Agile (Scrum), Kanban.Net, JavaScript, SQL Server 2012, Visual Studio 2012.

Education

Bachelor of Technology - Computer Science Engineering

St. Martins Engineering College
01.2012

Skills

  • Category: Tools and Technologies
  • Reporting Tools: Power BI Desktop, Power BI Service, Tableau, Axiom Software
  • Databases: MS SQL Server (2017, 2016, 2014, 2012, 2008 R2), Oracle (19c, 18c, 12c, 11g, 10g), TOAD, MS Access, Azure Synapse Analytics, SQL Server Management Studio (SSMS), SQL Server Data Tools (SSDT), BIDS, Visual Studio, SQL Profiler, Performance Monitor, DTS
  • BI Skills: Power BI Desktop, Data Visualization and Modeling, Data Warehousing and Analytics, Azure Synapse Analytics
  • Development Tools: Visual Studio (2017, 2015, 2013, 2012), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
  • Programming Languages: Python, R, SQL, HTML, T-SQL, PL/SQL, C/C, XML, CSS, Visual Basic 6, VBScript
  • Cloud Services: Microsoft Azure, Amazon Web Services (AWS), Oracle Cloud (Oracle Enterprise Manager Cloud)
  • Business Analyst Skills: Business Requirement Documentation (BRD), Impact Analysis, Process Flows, Use Case Diagrams, User Stories, Requirements Elicitation, As-Is & To-Be Process Documentation
  • Tools: Visual Studio, TFS, Git, Lucid chart
  • Database Developer Tools: SQL Server Profiler, FTP, MySQL Workbench, TOAD
  • Operating Systems: Windows, macOS, Unix, Linux (Ubuntu, Red Hat)
  • Methodologies: Agile (Scrum, Kanban), Waterfall
  • Other Software Tools: Microsoft Office Suite, Visio, Adobe Photoshop, HP ALM, JIRA
  • Project Management Tools: JIRA, Asana, Trello, Rally

Certification

Microsoft certified Power BI Data Analyst and Certified in “Business Analytics with Excel.”

Awards

“BRAVO” awarded for the successful delivery of quality output within the stipulated timelines.

Timeline

Senior Power BI Developer

CRC Insurance Services [Truist]
08.2024 - Current

Sr. Power BI Developer

FedEx
08.2023 - 08.2024

Power BI Developer

Thryve Digital Health LLP
09.2021 - 07.2023

Power BI Developer

Thryve Digital Health LLP
01.2021 - 08.2021

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
02.2020 - 01.2021

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
08.2019 - 09.2020

Associate Power BI Developer

Unify Technologies Pvt. Ltd.
06.2019 - 08.2019

Power Bi/Business Analyst

Rapra Software Technologies
03.2016 - 06.2019

Business Analyst

Rapra Software Technologies
02.2014 - 12.2016

Business Analyst

Rapra Software Technologies
05.2012 - 12.2014

Bachelor of Technology - Computer Science Engineering

St. Martins Engineering College

Similar Profiles

CREATE PROFILE