Power Bi Business Intelligence
Resume:
Karthik Sompalli
: *****************@*****.*** : +1-972*******
SUMMARY
Dynamic and results-oriented Business Intelligence (BI) Specialist with over 11 years of proven expertise in data analytics, visualization, and strategy, including 5 years of specialization in Power BI. Recognized for transforming complex datasets into actionable insights that drive informed decision-making and support organizational growth.
Key strengths include:
Developed and Managed Power BI Dashboards and Reports:
oDesigned, implemented, and optimized data models for Power BI dashboards and reports.
oCreated visual interactive reports and dashboards using Power BI.
oConducted data transformation using Power Query and DAX, creating calculated columns, measures, and relationships for complex analytics.
oEnhanced data accuracy and report reliability by optimizing schema and relationships in Power BI.
oImported data from SQL Server and other sources into Power BI Desktop using the Get Data option.
Advanced Data Visualization:
oDeveloped various visualizations, including custom ones, charts, graphs, and drill-down reports.
oUsed filters, parameters, and calculated fields to enhance data understanding.
oImplemented visual-level, page-level, and report-level filters and pinning in dashboards.
Row-Level Security and DAX Functions:
oWorked extensively on Row-Level Security (RLS) and DAX functions/expressions to ensure data security and advanced calculations.
Power BI Gateways:
oInstalled and configured Power BI Gateways to keep dashboards and reports up to date by scheduling refreshes.
Business Requirements to Technical Specifications:
oConverted business requirements into technical specifications and determined timelines to accomplish tasks.
oCreated charts and documented data with algorithms, parameters, models, and relationships explanations.
Automation with Power Automate:
oDesigned and implemented automated workflows using Power Automate to streamline business processes.
oDeveloped and managed automated data synchronization and integration between various data sources and Power BI.
oCreated and maintained automated notifications and alerts based on data changes and business events.
oImplemented solutions to automate repetitive tasks, improving efficiency and reducing manual intervention.
Reporting and Documentation:
oDeveloped reports and enhanced existing solutions using Web Intelligence, Crystal Reports, and Power BI for visualization.
oRendered reports in PDF, Word, and Excel formats as per client requirements.
oScheduled and published reports to end-users, ensuring timely and accurate data delivery.
oCreated effective documentation for developed solutions, including user guides and technical specifications.
Technical Enhancements and Support:
oMade technical changes to existing BI systems to enhance their functioning.
oSupported users by understanding their analysis requirements and providing appropriate solutions.
oInvolved in the migration of content and reports using tools like the Upgrade Management Tool (UMT) and Report Conversion Tool (RCT).
Additional Skills and Knowledge:
oExtensive knowledge of development, migration, and support projects.
oProficient in cloud technologies (AWS, GitHub, Jenkins, Kubernetes) and Snowflake.
oStrong domain knowledge of banking and finance.
oExpertise in scheduling reports based on business requirements using BI Launch Pad for different destinations (email, shared location) and formats like PDF/Excel.
Technical skills:
BI Tools
Power BI, Power Automation, Tableau, Crystal Reports, WebI Reports, Metric Insights Email Burst tool
Databases
Oracle 19C, Teradata, MySQL, Sybase, Postgres, Snowflake, Google Big query
OS
Linux, Windows
Ticketing tools
Service Now, Jira, BMC Remedy, Tech Service
SAP BI Tools
SAP BOBJ, HANA Modelling, Data Federation Administration
Cloud Technology
AWS, Git Hub, Server monitoring tool Prometheus graphene, Jenkins. Knowledge of Git hub and Ansible.
Programming Languages
Knowledge on Python
Education:
Master of Business Administration (MBA) – S.V. University
Bachelor of Technology (B. Tech) in Computer Science – JNTU Anantapur
Professional Experience:
Client: Blue Cross Blue Shield of NC Duration: Mar 2022 – Jan 2025
Role: BI Lead
Environment: Cloud AWS servers, Reporting tools: Power BI Dash boards / Tableau, Crystal reports Data Sources: Oracle 19 C Enterprise version, Teradata, MySQL, Mango DB, Snowflake DB, Cloud ETL: Alteryx, Ticketing tool: Service Now/Tech/Alteryx Administration.
Responsibilities
Analysing Source data and understanding the business requirements.
As per the client requirements publish the reports in Power BI Web.
Creating a Query, the Query Editor Window in Power BI.
Creating Dashboards, Scorecards, KPI’s, Trending view by Time.
Involved in Error handling, Deploying, Scheduling of Packages.
Made Changes in the Dashboard Reports based on the client requirements.
Involved in the requirement analysis, documenting requirement specifications.
Involved in configuring gateways and performing schedule refresh for dashboards.
Implemented Row level security on Power BI reports as per the client requirements
Involved in importing data from SQL Server into power bi desktop using get data option.
Developing of Different Reports like Table, Matrix, Charts, List, Sub Reports in different levels.
Hands-on experience with snowflakes and paginated reports.
Published/shared the reports by creating a content pack in app.powerbi.com/sharing the PBIX file.
Client: Nokia, Finland Duration: Nov 2018 – Feb 2022
Role: Application Support Lead
Environment: Windows servers, Backend: Data bases: Oracle, Teradata, MySQL, Power BI Dash boards, Data Model view, Power Query for ETL, Crystal Reports, Ticketing tool: Service Now/ Jira.
Responsibilities
Adding the Reports into Power BI Dashboards.
Worked on Row-level security (RLS) and DAX functions/Expressions
Identify KPIs with clear objectives and monitor them consistently
Designed and implemented data models in power bi, optimizing performance for dashboards and reports.
Conducted data transformation using power query and Dax, creating calculated columns, measures, and relationships for complex analytics.
Enhanced data accuracy and report reliability by optimizing schema and relationships in power bi.
Used filters, parameters, and calculated fields on Power Bi reports.
Developed various visualizations include custom.
Create dashboards and visual interactive reports using Power BI.
Extensively worked on Power BI transformations like Split column, Group by column, Append queries, Merge queries, Pivot, Unpivot, and Custom column.
Installed and Configured Power BI Gateways to keep the dashboards and reports up to date by scheduling the Refresh.
Convert the Business requirements into technical specifications and decide the timeline to accomplish tasks.
Create charts and document data with algorithms, parameters, models, and relations explanations use filters and graphs for a better understanding of the data and make technical changes to existing BI systems to enhance their functioning.
Understanding the user’s analysis requirements.
Implemented Visual level, Page level, Report level filters and pinning in dashboards.
Involved in creating effective reports, dashboards, and publishing into Power BI Service.
Involved in importing data from SQL Server into power bi desktop using get data option.
As per the client requirements, rendering the Reports in the form PDF, Word and Excel formats.
Client: BAWAG PSK, Germany Duration: May 2018 – Nov 2018
Role: SME
Environment: Windows Servers, Oracle Data Base, Powe BI tool used in for data modelling, Reporting tools: Ticketing tool: Jira/ BMC Remedy.
Responsibilities
Expert in identifying the requirements and finding the system requirements.
Published Power BI Reports to the APP Workspace and create the APPs for the Users to consume the developed reports.
Worked on Row-level security (RLS) and DAX functions/Expressions.
Generating Reports and dashboards based on business requirements.
Involved in the development and support of the reporting application.
Involved in database design, creating tables, writing stored procedures.
Created visualization using the bookmark as per business requirements.
Involved in the requirement analysis, documenting requirement specifications.
Creating Content packs and enable permissions on reports.
Extensively worked on Power BI transformations like Split column, Group by column, Append queries, Merge queries, Pivot, Unpivot, and Custom column
Worked on Import and Direct Query Data Connectivity Modes in Power Bi
Implemented Visual level, Page level, Report level filters and pinning in dashboards.
Involved in creating effective reports, dashboards, and publishing into Power BI Service.
Client: West-Field Fountain Gate Duration: Nov 2016 –Mar 2018
Role: Senior Developer
Environment: Windows Servers, MySQL, Sybase, Ticketing tool: BMC Remedy.
Responsibilities
Responsible for understanding the business requirement, analysing and estimate the business requirement.
Validate the reports and Publish the Dashboards on respective servers
Installed and Configured Power BI Gateways to keep the dashboards and reports up to date by scheduling the Refresh.
Created various Power BI reports like Map reports, Water fall reports, Bar charts, Column chart, Line chart, Area chart
Involved in Grouping, Sorting and Formatting to a Basic Report.
Involved in configuring gateways and performing schedule refresh for dashboards.
Used different types of Filters in Power BI like Visual level Filter, Page level Filter, Report level Filter, Drill through filter and Slicer
Extensively worked on Power BI transformations like Split column, Group by column, Append queries, Merge queries, Pivot, Unpivot, and Custom column
Developed various visualizations include custom.
Worked on Import and Direct Query Data Connectivity Modes in Power Bi
Created / Manage relationship between two different Data Source is by using Joins.
Created and managed the roles in Power Bi
Worked on Edit interactions in power Bi
Worked on Row-level security (RLS) and DAX functions/Expressions
Used filters, parameters, and calculated fields on Power Bi reports.
Client: Hyundai Cars Duration: April 2015 – Oct 2016
Role: Senior Software Engineer
Environment:
Windows Servers, Database: Oracle, SAP BI Tool: BOBJ, Data Modelling: UDT/IDT, PMT, RCT, CMC, Reporting tool: Web Intelligence reports, Crystal Reports Ticketing tool: Jira, BMC Remedy.
Responsibilities
Developed interactive reports and dashboard in Power BI which enables customer to slice and dice the data.
Developed data modelling in Power BI for Reporting.
Published reports to app.powerbi.com and setting up the necessary connection details and scheduling
Created reports in Power BI for customer sign-off process on layout.
Worked on end-to-end testing on Power BI Reports.
Created calculated Columns and Measures according to the report requirements.
Implemented Schedule refresh and incremental refresh in Reports.
Implemented Sync Slicers for easy of usage for end users.
Created Bookmarks according to the requirements.
Created the DAX query in Power BI and DAX Studio.
Deployed the reports as well as create and manage the dataset, App, and Dashboard in Power BI service.
Create and manage the schedule of reports and Alerts in the dashboard.
Preparing documentation of service deliverables like server management and Backup management.
Worked with Unit Testing for Reports which I have developed for validation.
Client: State Bank of Mauritius Group Duration: Aug 2013 to Mar 2015
Role: Software Engineer
Environment: Windows Servers, SAP BI Tool: BIBO Data Modelling: UDT, Reporting Tool: WebI, OLAP (Analysis Edition for OLAP).
Responsibilities
Working for JIRA priority Stories.
Created calculated Columns and Measures according to the report requirements.
Developed OLAP and Web Intelligence reports for retail and corporate banking analytics.
Designed technical solutions using BEx and OLAP connections, ensuring reliable data delivery.
Analysing the Report Specifications and assisting in creation of the design document.
Prepared technical design specifications based on functional requirements documents.
Worked on creating public objects – reports, templates in Webi/OLAP for generating the reports.
Designed BEx and Webi/OLAP reports creation of OLAP connection.
Creating OLAP Connections in the CMC Central Management Console and grated permissions based on their usage levels
Involved in various support activities like Monitoring, Reports execution using BEx Analyzer.
Involved in object level validation in the reporting layer by using RSA1 T-code by pre-selection.
Prepared test cases, performed Unit testing, documented the test results, involved in Code reviews
Created Check lists, prepared the system for UAT and product implementation guide.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards using Xcelsius.
Implemented Visual Level, Page level, report level filters and pinning in dashboards.
Worked with RLS Enhanced & Changes.
Certifications:
Power BI PL-300
AWS Certified Solutions Architect – Professional SAP C02
Project Management Professional (PMP)®
Contact this candidate