Summary
Overview
Work History
Education
Skills
Timeline
Generic

Kusuma Rayala

Hyderabad

Summary

As a Power BI Developer, I have hands-on experience in creating insightful reports and dashboards by connecting directly to databases such as SQL Server Management Studio (SSMS) and Oracle SQL Developer. I am proficient in leveraging DAX queries to calculate complex metrics and Key Performance Indicators (KPIs), and skilled in using Power Query for data transformation and manipulation within Power BI, ensuring data quality and consistency across reports. My expertise includes setting up and managing Dataflows to ingest, transform, and integrate data from various sources for centralized reporting. Additionally, I have experience configuring and managing Gateways to establish secure connections between on-premises data sources and Power BI Service, implementing Incremental Refresh strategies to efficiently load and refresh large datasets, and optimizing report performance. I am knowledgeable in Power BI Service features such as dashboard creation, scheduling data refreshes, and managing user access and permissions.

Overview

2
2
years of professional experience

Work History

Associate Engineer

Cambridge Technology Enterprises
12.2023 - 07.2024
  • Developed and optimized Power BI reports and dashboards, including configuring dataflows and managing gateways for secure data connectivity and incremental refreshes, while ensuring compliance with business requirements and performance tuning for enhanced responsiveness.
  • Collaborated with business stakeholders to gather and refine requirements, translating them into actionable visualizations and insights, and integrating Power BI reports into business applications for seamless user access.
  • Implemented and documented data security measures in Power BI, including row-level security and security configurations, to enforce data access controls and maintain comprehensive documentation of report specifications and dataflows.
  • Stayed updated with the latest Power BI features, capabilities, and best practices to drive continuous improvement in report design and development, ensuring adoption of new functionalities and optimization techniques.
  • Assisted in the integration of Power BI reports and dashboards into business applications and portals, facilitating seamless user access and ensuring the reports meet the evolving needs of the business.

Software Engineer

MiddlewareTalents Limited
07.2022 - 07.2023
  • Created and implemented interactive Power BI dashboards and reports that provided actionable insights, improved decision-making processes, and enhanced report performance through optimized data models, relationships, hierarchies, and custom DAX measures.
  • Integrated diverse data sources such as SQL databases, APIs, and Excel files into Power BI, utilizing Power Query for efficient data transformation and cleansing, ensuring accurate and timely data retrieval.
  • Applied complex DAX calculations to develop advanced metrics, KPIs, and aggregations, which improved data analysis capabilities and reporting accuracy, while adhering to best practices in data visualization for clarity and engagement.
  • Published and shared reports via the Power BI Service, effectively managing user access, configuring data refresh schedules, and ensuring that reports remained up-to-date and accessible to stakeholders.
  • Worked closely with business users to gather requirements, refine features, and provide training on Power BI usage. Addressed and resolved issues related to reports and data connections, participated in performance tuning activities to optimize load times and enhance user experience.

Education

MBA - General Management MBA

University Of East London
London, United Kingdom
08.2021

Skills

    Programming Languages: SQL, Python

    Business Intelligence Tools: Power BI

    Databases: Oracle, PostgreSQL, SQL Server Management Studio (SSMS)

    Data Modelling & ETL Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS)

    Web Technologies: HTML, CSS

    Manual Testing: Experience with manual testing methodologies and practices

Timeline

Associate Engineer

Cambridge Technology Enterprises
12.2023 - 07.2024

Software Engineer

MiddlewareTalents Limited
07.2022 - 07.2023

MBA - General Management MBA

University Of East London
Kusuma Rayala