Pravalika Reddy

Data Analyst                                                                                              Hounslow, UK | May2023 – Present

·        Collaborated closely with cross-functional teams, including business stakeholders, to understand their requirements and provide star schema data models that that precisely aligned with their needs and yielded a 30% increase in data-driven decision-making capabilities.

·        Developed and maintained star schema-based data models to support efficient data analysis and reporting processes.Utilized analytical techniques and data exploration to uncover valuable insights and trends within the data, enabling informed decision-making and driving business growth in Power BI.

·        Contributed to the optimisation of data models by using various data modelling techniques for improved query performance in Power BI, resulting in increased report performance and faster data retrieval by adopting techniques such as summarization, indexing, and partitioning.

Data Analyst                                                                                               Hyderabad, India | Feb2022 – Feb2023

·        Created interactive and highly informative Power BI reports using advanced DAX features.

·        Responsible for creating Power BI Apps and connecting them with live datasets for real time analytics.

·        Proficient in extracting data from various data sources such as SQL Server, datasets, data flows, Oracle database, Txt, Microsoft Dynamics365, Web, Excel, CSV,and cloud data sources (Azure Data Lake, Snowflake, Redshift, Big Query, AWS S3) for Power BI projects.

·        Conducted data transformations and cleansing using Power Query Editor, ensuring data quality and consistency within the star schema data model.

·        Implemented calculated columns, calculated tables, and calculated measures using DAX for complex calculations.