ANANDKUMAR POWERBI DEVELOPER

Experienced Power BI Developer with a background in Mathematics & Business Administration, offering 11.6 years of overall working experience, including 5 years of dedicated expertise in Power BI development. Proficient in:

• Power Query Editor, Data Modeling, DAX Functions, and Power BI Service development.
• Creating comprehensive reports & Interactive Dashboards.
• Various visualizations: line, bar, table, pie, area, treemap, waterfall, funnel, and Custom Charts.
• Designing interactive Visualizations like slicers for data filtering.
• Data transformations: Pivot, Unpivot, Conditional Split, Aggregate, Union all, merge, and joins.
• Creating hierarchies for data drill-down and applying drill-through filters.
• Deploying and scheduling refreshes, and configuring gateway connectivity.
• Granting access to on-premises data gateway and implementing Row-Level Security (RLS) with Power BI Desktop.
• Integrating RLS with the Power BI Service Portal.
• Creating or utilizing various types of KPIs to interpret data.
• Designing and deploying reports with drill-up and drop-down menu functionality.
• Proficiency in SQL queries relevant to Power BI integration.

Project 1 

Client             : Johnson & Johnson Pharmaceuticals

Duration        : Aug 2022 - Feb 2024

Project Title  : Sales

Role               : Power BI Developer

Environment : Power BI desktop, Oracle Server, Microsoft Excel.

Project Description:

                                 Johnson & Johnson Pharmaceuticals, a global leader in the healthcare industry, aims to enhance its sales effectiveness through data-driven strategies and innovative technologies. The Sales Optimization Project seeks to leverage advanced analytics and digital tools to optimize sales operations, improve customer engagement, and drive revenue growth.

Roles & Responsibilities:

• Developing reports from multiple data sources and performing data cleaning.
• Providing analysis to internal and external teams, explaining operational data's relevance to key performance indicators (KPIs).
• Supporting the business in understanding team productivity through data visualizations and dashboards.
• Understanding user requirements, functional specifications, and technical requirements.
• Collaborating with team members to estimate, plan, and schedule tasks to meet assigned target dates.
• Creating Hierarchies and establishing relationships between attributes to reduce processing time.
• Generating Calculated Columns and Measures using DAX.
• Designing visuals and reports in Power BI Desktop and publishing them to Power BI Service.
• Creating Reports and Dashboards in Power BI and implementing Static and Dynamic Row-Level Security (RLS) and Object-Level Security (OLS).

Project 2 

Client             : Tata AGS Insurance

Duration        : Jan 2021 - May 2022

Project Title  : Finance

Role               : Power BI Developer

Environment : Power BI desktop, Oracle Server, Microsoft Excel.

Project Description:

                                Tata AGS Insurance, a leading player in the insurance industry, is embarking on a Financial Transformation Project to enhance its operational efficiency, risk management capabilities, and financial performance. The project aims to leverage advanced financial technologies, process optimization, and strategic initiatives to drive growth, profitability, and sustainability.

Roles & Responsibilities:

• Developed Power BI reports from multiple data sources and effectively utilized Power Query and DAX for calculations.
• Created Power BI filters such as visual level and page level filters.
• Designed, created, and implemented database systems based on end user requirements.
• Created reports and dashboards in Power BI and worked on report performance optimization.
• Engaged in discussions with business users and provided technical guidance for Power BI Desktop and Power BI Service.
• Created filters and applied conditional formatting based on user requirements. Created Slicers, measures, and columns in Power BI Desktop.
• Developed different types of reports in Power BI Desktop and pinned reports to dashboards as per requirements.
• Scheduled and shared reports and dashboards using Data Gateway.
• Generated reports using DAX time intelligence functions and other DAX functions.
• Involved in creating Hierarchies and establishing relationships between attributes to decrease processing time.

Project 3 

Client             : Bright Health Care

Duration        : June 2019 - Oct 2020

Project Title  : Health Care

Role               : Power BI Developer

Environment : Power BI desktop, Oracle Server, Microsoft Excel.

Project Description:

                                Bright Health Care, a dynamic player in the healthcare industry, is initiating a Healthcare Transformation Project to improve patient outcomes, enhance operational efficiency, and drive innovation across its healthcare ecosystem. The project aims to leverage technology, data analytics, and collaborative partnerships to deliver high-quality, affordable care and improve the overall healthcare experience for patients and providers.

Roles & Responsibilities:

• Creating visuals and reports in Power BI Desktop and publishing them to Power BI Service.
• Working on report performance optimization.
• Creating filters and applying conditional formatting based on user requirements.
• Generating reports using DAX time intelligence and other DAX functions.
• Implementing row-level security on data and understanding security models in Power BI.
• Understanding design principles and fundamentals of architecture.
• Designing different types of reports like Drill Down, Drill Through, line charts, and bookmark buttons.
• Scheduling data refresh as per client requirements and setting up the time.
• Involving in admin activities like creating users, password changes, and tenant settings.
• Using Microsoft Power BI Power Query to extract data from external sources and modify data to a certain format as required in Excel.
• Working on setting up and configuring Power BI-related Gateways and data connections.
• Utilizing table/matrix/trend lines/bar/card/gauge/slicers as custom visualizations.
• Working on filters, calculated columns, measures, relationships, and transformations in the edit Query section.