Lohit Soreddy
Hyderabad
Summary
Dynamic Power BI Developer with experience at Capgemini, skilled in advanced DAX and data modeling. Successfully created impactful KPIs and robust data models, enhancing decision-making processes. Adept at stakeholder collaboration and performance tuning, delivering high-quality reports that drive insights and strategic initiatives. Passionate about transforming data into actionable intelligence.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Power BI Developer
Capgemini
Hyderabad
09.2022 - 01.2025
- Connecting Data Sources and performing necessary ETL operations so that the data is ready for Power Bi use
- Creating a Robust Data model using Snowflake and Stars Schema, Creating measures and conditional columns for visual creation
- Created impactful KPIs, tested them with source data to verify right implementation of the Logic Using DAX
- Creating Bookmarks with the help of selection pane to give a web like UI/UX experience
- Validating the results with the Source to improve the stage of deployment
- Created Row Level Security within the report for different level of access for the data
- Build BI reports and add multiple insights based on the given data for critical decision making
- Perform Predictive analysis and define the KPIs
- Published them in Power Bi Services, created applications based on the workspace reports and managed their access at the workspace level, app level and report level
- Created Alerts and Managed Subscriptions for the reports published
- Performed Sustaining Tasks for the reports that are already developed
Data Analyst
Addicor Technologies Pvt Ltd
Pune
06.2019 - 08.2021
- Extracting the data from the Azure SQL database into Power BI desktop and transforming the data in Power Query Editor
- Creating interactions of Highlight Action, Filter Action, add interactivity to the visualizations
- Building the Relationship between tables by using Power Pivot
- Developed analysis reports and visualization using DAX functions like Table function, aggregation function and Date and Time Intelligent functions
- Trouble shooting, Performance Tuning of reports & resolving issues within Power BI
- Experience in Creating Power BI Reports from Power BI Desktop.
- Creating Reports apply Visual Level, Page Level and Report Level Filters in Power BI
- Publishing reports to Power BI Services and setting up the necessary connection details and Scheduling
- Created reports like Drill-Down, Drill-Through, Chart, Sub Reports Bar charts, Line charts, Pie charts using Power BI
Education
Masters - Data Science & Analytics
Cardiff University
Cardiff, UK07.2022
Bachelors - Electrical & Electronics Engineering
Bhilai Institute of Technology
Chhattisgarh, India05.2019
Skills
- Power BI - Power BI Desktop, Power BI Report Services, Report Builder, Power Automate, Deployment Pipelines, Advanced DAX, Exposure to different types of licenses in Power BI
- MSBI (Basics) - Experience in MS SQL Server 2014/2012/2008 R2/2005 Business Intelligence, including MS SQL Server Integration Services (SSIS) and MS SQL Server Reporting Services (SSRS)
- Python - Anaconda Jupyter - Pandas, Numpy (Good to have knowledge)
- Data Warehouse - Data Warehousing, Dimensional Modelling, Snowflake, ETL processes
- AZURE - Azure Analysis Services, Azure SQL, ADF, ADL, ADLs, Databricks, Microsoft Fabric
- Databases - SQL Server, PL/SQL, Postgres SQL
- Methodologies - SDLC, Agile development in sprint cycles
- Agile Tools - JIRA
- Versioning Tools - SVN, Git, TFS
- Operating Systems - UNIX, Linux, Windows
- Data governance
- Stakeholder collaboration
- Data modeling
- Product development
Certification
- Microsoft Certified: Data Analyst Associate
- Azure Data Fundamentals
- Azure Fundamentals
- Prime classes: Advanced Machine Learning and Data Science course.
Timeline
Power BI Developer
Capgemini
09.2022 - 01.2025
Data Analyst
Addicor Technologies Pvt Ltd
06.2019 - 08.2021
Masters - Data Science & Analytics
Cardiff University
Bachelors - Electrical & Electronics Engineering
Bhilai Institute of Technology
Similar Profiles
Abdoul-rahim DombaAbdoul-rahim Domba
Ingénieur d'études et de recherche at CapgeminiIngénieur d'études et de recherche at Capgemini
Bélinda BONACINABélinda BONACINA
Document Management, quality and configuration at CAPGEMINIDocument Management, quality and configuration at CAPGEMINI
Namrata DwivediNamrata Dwivedi
Front End Developer at CapgeminiFront End Developer at Capgemini