Surya VijayKumar

• Developed dynamic dashboards and interactive reports in Power BI, integrating data insights with SQL queries and custom visuals for retail KPIs, sales performance, and client portfolios.
• Built and optimized complex data models using calculated columns, measures, and relationships, improving report performance and analytical capabilities.
• Developed complex DAX measures, calculated columns and tables, and leveraged Power Query for data transformation, including splitting columns, merging data, and removing duplicates.
• Implemented Row-Level Security (RLS) in Power BI to ensure appropriate user data access as per requirements.

• Automated ETL processes using SQL and integrated with Power BI for real-time analytics, ensuring data accuracy and effectiveness in the data warehouse.
• Acquired and integrated data from diverse sources, including SQL Server, Excel, Flat Files, and APIs, for comprehensive analysis and reporting.
• Published and managed Power BI dashboards via Power BI Service, enabling collaboration and maintaining automated data refresh schedules using Power BI Gateway.
• Worked within Agile methodologies, interpreting progress metrics and applying Agile techniques for efficient project execution in BI projects.

CLIENT PROJECTS

DOMAIN: Healthcare JAN 2024 TO AUG 2025

CLIENT: Med-Care Hospitals
TECHNOLOGY: Power BI, SQL Server, AWS (Athena, S3 Services)

* Extracted and integrated data from Electronic Health Records (EHR) systems and operational databases using SQL Server for healthcare analytics in Power BI.
* Managed and queried large-scale healthcare data stored in AWS S3 utilizing AWS Athena for data preparation and transformation.
* Developed interactive dashboards in Power BI to visualize key performance indicators (KPIs) such as patient wait times, bed utilization rates, and readmission rates.
* Collaborated with healthcare professionals to translate data insights from Power BI and SQL into actionable strategies for enhancing patient care and operational workflows.

DOMAIN: Finance MAR 2022 TO OCT 2023

CLIENT: Global Investment Bank
TECHNOLOGY: Power BI, SQL Server, Snowflake

* Architected and developed the financial reporting system in Snowflake, leveraging its features for scalable warehousing and high-performance querying.
* Utilized advanced Snowflake-specific SQL features (e.g., Materialized Views) to achieve query optimization and faster report generation on large financial datasets.
* Developed financial dashboards in Power BI by connecting to Snowflake, providing real-time insights into revenue trends and expense forecasts.
* Implemented robust data governance frameworks and role-based security measures in SQL and Power BI to protect sensitive financial information.

DOMAIN: Retail AUG 2020 TO FEB 2022

CLIENT: Emirates Business Group
TECHNOLOGY: Power BI and SQL Server

* Collected, transformed, and centralized data from multiple sources (sales, inventory, customer records) using SQL and Power Query.
* Created visually engaging dashboards in Power BI, showcasing retail KPIs, sales performance, and inventory trends to support data-driven decision making.
* Leveraged advanced DAX functions to build calculated measures, custom visualizations, and interactive reports with Drill Down and Drill Through features.
* Streamlined data workflows and optimized Power BI reports for faster loading times and real-time data accessibility.