Power Bi Business Intelligence

Rakshak Adikesavan

Summary

• Having around *+ years of experience in Power BI /MSBI DEVELOPER with multiple skill set and extensive working experience in data warehousing and Business Intelligence Technologies with expertise in SQL Server development, MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BI for building, deploying, managing applications and services through a global network of Microsoft - managed Data Centers

• Interacted and involved with Business users to gather requirements, functional analysis, design, development, implementation, testing, debugging and support them with Business Intelligence solutions and products

• Strong experience in synthesizing the Business requirements, Data models and determining Key performance indicators to evaluate key factors crucial to success of the organization

• Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation using Waterfall and Agile methodologies.

• Ability in dealing with RDBMS including E/R Diagrams, Normalization, Constraints, Data Import and Export.

• Working with DAX formulae for creating variables like Previous Month, Previous Quarter, etc. and creating interactive visuals using geographic data.

• Expertise in Power BI Desktop, Power BI Service, Power BI Pro, Power BI Mobile.

• Experience in Power BI Desktop, Report Service, Gateway Connectors, Data Models, Relationships, Publishing / Updates to Apps Work spaces, Data On-Demand Refreshes, Scheduling, Testing and Deployment.

• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports.

• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, and Excellent knowledge in RDBMS concepts and Data Warehouse Concepts.

• Skilled in creating and developing BI Dashboards into rich look for better understanding

• Imported data using Azure Data Link (ADL) to SQL Server in Power BI to generate reports

• Involved in publishing Power BI Desktop reports to the Power BI service

• Designed reports in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cubes, SQL Server Integration Services (SSIS), and Power BI.

• To generate underlying data for the reports and to export cleaned data from an Excel Spreadsheet, Flat file and CSV files to the data warehouse.

• Implemented Power Apps for real-time data updates within Power BI dashboards, allowing stakeholders to view and act on the latest information without delays

• Database development for both OLTP and OLAP systems using MS SQL Server.

• Involved in creating Data visualizations like Clustered Column Chart, Bar Chart, Donut Chart, Line Chart, Scatter Plot, Tree Map, Slicer, Gauge Visualization etc. with Power BI

• Knowledge working with Map Reports and Stacked Reports

• Created the Calculated columns and measures with the use of DAX Expressions like Aggregate, Time

& Date Functions, Writing DAX, Power Query formulas and creating KPI’s based on client requirements

• Expertise in Publishing Power BI Reports of Dashboards in Power BI Server and Scheduling the dataset to refresh for live data in Power BI Server

• Worked with both Direct query and Import data in to Power BI for creating Reports.

• Providing security by using Row Level Security (RLS) implementation.

• Developed Power BI Reports, Paginated Reports, Custom Visuals, Group Creation and Effective Dashboards after gathering and translating End-User Requirements. Skills

Visualization Tools Tableau, Power BI, SSRS

ETL Tools Alteryx, Azure Data Factory, Informatica & SSIS Programming

Languages

C, C++, Python, SQL, PLSQL

Databases Presto, SQL Server, Oracle, DBeaver

Operating Systems Windows, Linux

Education

Bachelor of Technology in Computer Science

JNTUH, Hyderabad, India August 2014

Professional Summary:

Client: Captive Software Solutions, OMAHA, NE

July 2023 – Present

Power BI Admin

Project Synopsis: The company is a leading provider of innovative technology solutions, specializing in enterprise and web development services. It serves businesses of all sizes across diverse industries globally, delivering tailored solutions to meet specific needs. Responsibilities:

• Administered Power BI platform including user access, workspace management, and role-based security.

• Installed, configured, and managed on-premises data gateways to ensure secure data transfer between on-premises systems and cloud services.

• Migrating the existing reports from the legacy systems to the Power BI app.

• Replicating reports to Power BI and validating the data.

• Create and maintain custom dashboards, models, canvas apps, power app components, and integration with third-party services and external APIs.

• Modified multiple Model Driven Apps in Power Apps and synced with Power Automate

• Created multiple power Pages, themes and applied customizations.

• Good Experience on complex ETL processes and scheduled event-driven workflows using Azure Data Factory.

• Proctored both online and in-person technical training courses on Power Apps, supporting client scales ranging from individuals to groups of 20.

• Experience in developing, troubleshooting and maintaining Microsoft Dynamics 365 CRM Plugins, Power Automate.

• Developed and deployed multiple interactive Qlik Sense dashboards and reports, providing actionable insights from various data sources.

• Improved overall decision-making 25% by designing and developing Power BI reports and providing insights. Led migration of legacy reports to the Power BI platform, ensuring data consistency, performance optimization, and improved user experience.

• Replicated and validated complex reports in Power BI to align with business requirements and ensure accuracy.

• Designed and maintained custom dashboards, data models, Power Apps (canvas and model-driven), and integrated them with third-party services and external APIs.

• Skilled in Paginated Reports development within Power BI Report Builder.

• Proficient in SQL: Complex queries, joins, stored procedures, indexes, and functions for enterprise- level reporting.

• Reduced client report creation time by 30% by creating reusable Power BI report templates

• Collaborate with team members to manage the Microsoft cloud environment including Azure, Microsoft 365, and the Power Platform.

• In depth knowledge and experiences on stages of software development life cycle (SDLC) based on Agile methodology scrum process

• Good experience with Integration with Virtual agents, Power apps

• Good Experience on writing the SQL queries, Joins, Functions, Indexes, Stored Procedures Environment: Power BI, Power Apps, Power Automate, Power Pages, MS SQL Server, DBeaver Client: CBRE, Dallas, TX

May 2020 – July 2023

Sr. Power BI Developer

Project Synopsis: CBRE is a leading real estate management organization which is trying to automate the systems associated with the properties that are owned and managed by CBRE. Responsibilities:

• Worked through all phases of software Development life Cycle (SDLC) which includes gathering and analyzing business requirements, functional/Technical

• Implemented Power apps role-based security using SharePoint Group &Flows

• Automated contract expiration notification system using Microsoft Power automate

• Good experience on creating Power Portals and pages adjusted theme font, weight, size and color

• Created Model driven apps for adding components such as forms, views, charts and Dashboard.

• Created and implemented the Roles like Local, Basic, none by using the MS Dynamics 365

• Delivered full administration support for SharePoint online environment, Including creating managing sites, Managing Groups, and permissions

• Developing all the visualizations which are requested by the business users using Power BI.

• Design and developed the Power BI solution to create reports, visualizations, and dashboards as per the business requirements and published enterprise.

• While designing the Power Bi reports and dashboards, the measures are created using DAX programming language. Writing all the calculations using DAX formulas.

• Managed relationship between tables in Power BI using star schema.

• Used different type of slicers available in Power BI for creating reports.

• Managing end user’s account permissions and access right requirements

• Extracting data from different kinds of source systems into Power query and then cleansing the data by applying business rules and loading it into Power Pivot.

• Created new columns, new measures and conditional columns using DAX functions.

• Created and implemented the Roles like Local, Basic, none by using the MS Dynamics 365

• Created various visualizations like donut chart, Pie chart and Bar graph, Tree map and water fall charts and Card Visualizations.

• Designed and deployed reports with Drill Down, Drill Through and drop-down menu option and parameterized reports.

• Having Good experience with Paginated Reports

• Worked on all types of transformations that are available in Power BI query editor.

• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

• Implemented incremental refresh at Power BI Desktop level and scheduled the data refresh for dashboards and reports to show the updated data.

• Created Workspaces and Apps in Power BI Service and published the reports into it to share with the users.

• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.

Environment: Power BI, MS SQL Server, Power Apps, Presto Client: Molina Healthcare, Long Beach, CA

October 2017 – April 2020

Power BI Developer

Project Synopsis: Molina Healthcare provides health insurance to individuals through government programs such as Medicaid and Medicare. During my tenure at Molina, I worked in Star’s project where the aim is to increase the ratings of the several metrics associated with the plans and to close the gaps within the user groups.

Responsibilities:

• Involved in maintaining the server configurations and responsible for administration of the Power BI app in all the environments.

• Responsible for updating the DML scripts based on the changes made to the existing tables.

• Expertise in running SSIS packages to load the data from the configuration tables to the target tables.

• Incorporated the design changes for the existing tableau dashboards based on the business enhancements.

• Deployed the Power BI reports and maintained the user security and scheduling requirements as per business requirement.

• Optimized data retrieval and reporting processes using Power BI, reducing query response time by 15%, improving report delivery speed. Enhanced dashboard interactivity for 50+ users.

• Leveraged Power Automate to set up real-time alerts for detecting suspicious activities, triggering automated notifications to relevant teams, reducing response time by 25%.

• Managed data models in Qlik Sense, optimizing for performance and scalability.

• Integrated Qlik Sense with external data sources, including APIs and databases, ensuring smooth data flow and real-time updates.

• Effectively communicate key insights to business stakeholders and cross-functional teams, enabling informed decision-making and driving strategic initiatives. Environment: Power BI, MS SQL Server, Power Apps,TSQL Client: Anthem Inc., Richmond, VA

April 2015 – August 2017

Business Intelligence Developer

Project Synopsis: Anthem, Inc. is the one of the largest health benefits companies in terms of commercial membership in the United States with medical enrollment of 34.9 million members. Its mission is to improve the lives of the people it serves and the health of its communities. During my tenure, I worked in

“Modular Product” and “ORMB Application” which automates the process of generating the quotes for healthcare plans.

Responsibilities:

• Involved in analysis of the requirements.

• Replicated complex SQL queries from SSRS and developed the visualizations in Power BI and Business Objects (BO.)

• Created and replicated complex views from OLTP to OLAP systems which are part of BO universe.

• Created dashboards to analyze the claims data based on user demographics.

• Successfully deployed 50+ Tableau and Power BI reports and was responsible for production support of Power BI reports.

• Mapped the user’s enrollment data, claims data with legacy applications.

• Experienced in aggregating the complex data sets and creating extracts in Tableau to increase the performance.

• Hands on experience in latest versions of Power BI and best practices involved on hyper extracts.

• Solved data and ETL issues along with functional and technical analysis development

• Designed and validated Informatica ETL processes, for the source system in Claims and Enrollment Subject area.

• As per business requirement, created, optimized, reviewed, and executed Teradata SQL test queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.

• Performed data extraction and validation, applying rules transformation in the flow of data from source to target.

Environment: Power BI, Tableau, MySQL, Informatica, Oracle

Contact this candidate