SURYA V

Data Analyst, Firstsource Solutions PVT LTD

Hyderabad,INDIA | January 2024 - August 2025

Junior Data Analyst, LIKEDIN SERVICES PVT LTD
Bengaluru, INDIA | August 2020 - October 2023

1.Developed dynamic dashboards and interactive reports in Power BI and Tableau, integrating data
insights with SQL queries and custom visuals for retail KPIs, sales performance, and client
portfolios.

2.Built and optimized data models using calculated columns, measures, and relationships, improving report performance and analytical capabilities.

3.Developed complex DAX measures, calculated columns, and tables while leveraging Power Query for data transformation, including splitting columns, merging data, and removing duplicates.

4.Created feature-rich Power BI and Tableau reports with Drill Through, Drill Down, Bookmarks,
Parameters, and Slicers for an user experience.
Designed and optimized SQL queries to improve dashboard responsiveness and reduce data
processing times for large datasets.

5.Automated ETL processes using SQL and integrated with Power BI and Tableau 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.
6.Implemented data governance frameworks, security measures, and validation processes to maintain data integrity, compliance, and user access control. Published and managed Power BI dashboards via Power BI Service, enabling collaboration and maintaining automated data refresh schedules.

7.Integrated data from multiple sources, including SQL Server, Excel, and Flat Files, for unified analysis in Power BI.

8.Developed real-time reporting solutions using Power BI Gateway for scheduled and on-demand
data refreshes.Led end-to-end reporting projects, from SQL data extraction to Power BI dashboard deployment,ensuring alignment with business objectives.Worked within Agile methodologies, interpreted progress metrics, and applied Agile techniques for efficient project execution in BI projects.

• DOMAIN: Healthcare
• CLIENT: MedCare Hospitals
• TECHNOLOGY: Power BI and SQL Server,AWS(Athena)

DESCRIPTION:

• MedCare Hospitals is a network of healthcare facilities specializing in
• comprehensive patient care across multiple specialties. The project involved
• analyzing patient demographics, treatment outcomes, and operational efficiency
• metrics to improve healthcare delivery.

RESPONSIBILITY:

• Extracted and integrated data from Electronic Health Records (EHR)
• systems and operational databases using SQL Server for healthcare analytics
• in Power BI and Tableau .
• Developed interactive dashboards in Power BI and Tableau to visualize key
• performance indicators (KPIs) such as patient wait times, bed utilization rates,
• and readmission rates.
• Implemented predictive analytics models using SQL and Power BI to
• forecast patient admission rates and optimize resource allocation.
• Collaborated with healthcare professionals to translate data insights from
• Power BI, Tableau, and SQL into actionable strategies for enhancing patient
• care and operational workflows.
• Integrated Athena with Power BI to deliver interactive dashboards for hospital management, visualizing KPIs such as patient readmission rates, treatment outcomes, and claim approvals.

• DOMAIN: Finance
• CLIENT: Global Investment Bank
• TECHNOLOGY: Power BI and SQL Server, Snowflake

DESCRIPTION:

• The project involved creating a comprehensive financial reporting and analytics
• solution for a global investment bank to monitor portfolio performance, risk
• exposure, and regulatory compliance.

RESPONSIBILITY:

• Developed financial dashboards in Power BI by connecting to Snowflake , providing real-time insights into revenue trends, expense forecasts, and profit margins for senior leadership.
• Designed and developed interactive dashboards in Power BI and Tableau,
• integrating data from SQL Server and financial trading platforms to track
• market trends, and risk exposure.
• Utilized advanced DAX calculations in Power BI and calculated fields in
• Tableau to measure risk- adjusted returns, conduct scenario analysis, and
• financial decision-making.
• Automated ETL processes using SQL and integrated them with Power BI and
• Tableau for real-time financial analytics, ensuring accurate data extraction
• and transformation.
• Implemented data governance frameworks and security measures in SQL,
• Power BI, and Tableau to protect sensitive financial information and ensure
• regulatory compliance.
• Optimized data storage and scaling in SQL, Power BI, and Tableau, ensuring
• efficient financial data management while maintaining security protocols.

• DOMAIN: Retail
• CLIENT: Emirates Business Group.
• TECHNOLOGY: Power BI and SQL Server

DESCRIPTION:

• This Project Involves around the development and implementation of a
• comprehensive analytics dashboard specifically for the retail industry. The
• primary goal is to harness the power of data to provide actionable insights that
• enhance decision making processes, optimize operations and drive business
• growth within the retail sector.

RESPONSIBILITY:

• Collected, transformed, and centralized data from multiple sources,
• including sales, inventory, and customer records, using SQL and Power
• Query for seamless reporting.
• Created visually engaging dashboards in Power BI, showcasing retail KPIs,
• 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, ensuring a smooth user experience and real-time data
• accessibility.
• Automated report generation and scheduling via Power BI Gateways,
• delivering actionable insights and fostering collaboration with stakeholders.
• Designed and implemented data models in SQL Server to store and
• manage retail data from trading platforms and market feeds for efficient
• analysis.
• Utilized advanced DAX calculations in Power BI to measure risk-
• adjusted returns and conduct scenario analysis, aiding strategic retail
• planning.
• Automated report generation and distribution using Power BI Service, ensuring stakeholders have access to real-time retail insights.