Kalyan

Results driven Power BI Analyst and Data Analyst with 3+ years of experience transforming complex datasets into actionable insights to support strategic decision-making. Advanced proficiency in Power BI (DAX, Power Query), strong SQL expertise, and hands-on experience with ETL pipelines, data warehousing, and cloud data platforms. Skilled in data modelling, dashboard development, statistical analysis, and data pipeline automation.

Proven ability to collaborate with cross-functional teams, deliver business insights, and maintain high standards of data integrity, governance, and performance optimisation. Currently expanding skills in Python and cloud technologies to transition into data engineering.

POWER BI Analyst - My Care Meds Technologies Pvt Ltd

(2024-04)

• Collected, cleaned, and analysed large-scale datasets from multiple sources, ensuring high levels of data integrity and accuracy across all reporting systems.
• Developed advanced Power BI dashboards and interactive reports using DAX measures and Power Query, delivering clear and actionable insights to stakeholders.
• Designed, built, and maintained ETL pipelines for data extraction, transformation, and loading into structured data warehouse environments.
• Built and optimised data models using star schema architecture, improving query performance and scalability across BI platforms by 40%.
• Wrote complex SQL queries including CTEs, window functions, joins, and aggregations to extract, transform, and analyse data for business intelligence reporting.
• Automated reporting pipelines, reducing manual reporting effort by 60% and improving data delivery efficiency.
• Implemented Row-Level Security (RLS) and data governance controls to enforce secure access and ensure compliance with data protection standards.
• Collaborated with cross-functional teams including data engineers, business analysts, and stakeholders to gather requirements and deliver analytical solutions.
• Supported data warehouse processes and ensured seamless integration of upstream and downstream data systems.
• Conducted data quality checks, validation, and reconciliation to maintain consistent, reliable, and production-ready datasets.
• Performed statistical and trend analysis to support business strategies, identify patterns, and drive operational improvements.
• Contributed to improving data strategy, technical documentation, and best practices within the analytics team.

SYSTEM ANALYST - Kew Green Hotels - United Kingdom

(2022-11 - 2023-08)

• Produced regular reports in Excel analysing operational KPIs, revenue metrics, and performance indicators for senior management.
• Cleaned and validated datasets using Excel automation, Power Query, and conditional formatting to ensure data accuracy and reliability.
• Conducted trend analysis and exploratory data analysis to identify patterns and support operational decision-making.
• Collaborated with internal and external stakeholders to resolve system issues, gather requirements, and align data solutions with business objectives.
• Managed data workflows and ensured alignment with organisational goals and reporting timelines.
• Maintained strict adherence to data protection, GDPR compliance, and governance standards.

DATA ANALYTICS BOOTCAMP - Data Analytics - We Are Group (UK Government) (2024-01 - 2024-04)

MASTER OF SCIENCE - Nagarjuna University