Summary
Overview
Work History
Education
Skills
Disclaimer
Timeline
Generic

Giridaran Chandrasekar

Chennai

Summary

Data Analytics Specialist with 4 years at State Street and 9 years of overall experience. Created impactful dashboards using Power BI and SQL Server, enhancing decision-making processes. Skilled in data modeling and visualization, transforming complex datasets into actionable insights. Collaborated effectively with cross-functional teams to achieve organizational objectives.

Overview

9
9
years of professional experience

Work History

Specialist

State Street
Chennai
11.2021 - Current
  • Client Name: UBS Investment Bank
  • Tools : Power BI Desktop,Orale
  • Project Name: M&A Deal Performance Analytics
  • The M&A Deal Performance Analytics Power BI dashboard is designed to provide real-time insights into mergers and acquisitions (M&A) transactions handled by UBS Investment Bank.
  • The dashboard tracks key deal metrics, evaluates post-merger financial performance, and helps investment bankers assess the success of M&A deals.
  • It integrates financial, legal, and operational data to ensure a comprehensive analysis of deal performance and risk assessment.
  • Client Name: Citizens Financial Group
  • Tools : Power BI Desktop,Power Automate,SQL Server
  • Project Name: Citizens Financial Performance Dashboard
  • The Citizens Financial Performance Dashboard is a Power BI solution designed to provide executives and financial analysts with real-time insights into the bank's financial health.
  • It enables tracking of key financial metrics, revenue streams, expense management, loan portfolio performance, and profitability trends.
  • The dashboard integrates data from multiple sources, ensuring compliance with banking regulations and providing predictive insights to optimize financial strategies.

Senior Process Associate

IQ Backoffice
Chennai
07.2019 - 08.2021
  • Client Name: BNY MELLON BANK
  • Tools : Power BI, Power BI Service & SQL Server
  • Project Name: BNY MELLON Performance Dashboard
  • Connected Power BI to SQL Server databases to extract financial, transactional, and compliance-related data.
  • Performed data cleansing, transformation, and shaping using Power Query Editor to prepare the data for modeling.
  • Designed a star schema data model with fact and dimension tables including Fact_Transactions, Fact_Investments, Dim_Client, Dim_Department, and Dim_Date for performance and scalability.
  • Developed interactive dashboards and reports with slicers, drill-throughs, bookmarks, and tooltip pages for deeper insights. Implemented Row-Level Security (RLS) to restrict data access based on user roles (e.g., Department Heads, Risk Managers, and Executives).
  • Published reports to the Power BI Service and scheduled data refreshes to ensure up-to-date information for stakeholders.
  • Collaborated with finance, risk, and compliance teams to gather requirements and validate report metrics.

Process Associate

Entrust
Chennai
02.2018 - 07.2019
  • CLIENT | PURAVANKARA GROUP
  • DOMAIN: REAL ESTATE
  • ENVIRONMENT: EXCEL, POWER BI, POWER BI SERVICE
  • Extensively worked in Microsoft Excel for data preparation activities including data validation, consolidation, pivot-based analysis, and initial KPI computations for unit sales, customer leads, and project performance tracking.
  • Utilized Power BI to transform pre-processed Excel datasets into interactive dashboards and analytical views for strategic and operational decision-making.
  • Applied data transformation techniques using Power Query in both Excel and Power BI to standardize, clean, and structure data for reporting.
  • The project for Puravankara was centered on building a Real Estate Sales and Project Monitoring Dashboard to empower business heads, sales managers, and finance teams with real-time insights.
  • The dashboard highlighted critical metrics such as booking velocity, unsold inventory trends, project-wise revenue performance, and customer acquisition patterns, enabling better visibility and operational control.
  • Designed a structured data model using business-friendly tables like SalesData, LeadTracker, CustomerProfiles, ProjectInfo, PropertyTypeList, and CalendarView to enable robust data analysis.
  • Built Power BI reports enriched with slicers, bookmarks, drill-throughs, and tooltips, covering key performance indicators including: Sales Funnel Efficiency, Booking Rate per Project, Inventory Movement, Revenue per Square Foot, Lead Source Effectiveness.
  • Configured Row-Level Security (RLS) based on user roles like Sales Executives, Regional Managers, and Department Heads, restricting data views appropriately.
  • Published and maintained reports on Power BI Service, enabling automated refresh schedules and seamless access to updated metrics for leadership reviews.
  • Engaged in regular collaboration with Sales, CRM, and Finance stakeholders, leveraging Excel-based outputs to validate metrics and align reporting logic with business needs.

Process Associate

Capgemini Services
Trichy
06.2016 - 02.2018
  • CLIENT | FEDEX CORPORATION
  • DOMAIN: LOGISTICS & SUPPLY CHAIN
  • ENVIRONMENT: SQL SERVER, EXCEL, POWER BI (VALIDATION SUPPORT)
  • Wrote complex SQL queries to validate transactional, shipment, and billing data from multiple source systems.
  • Performed data integrity checks between operational databases and staging tables to ensure consistency prior to report development.
  • Validated ETL pipeline outputs by comparing source vs. destination row counts, value mismatches, and null anomalies.
  • Conducted column-level checks for business rules (e.g., Shipment weight ≥ 0, delivery status = Delivered/Pending/Failed).
  • Coordinated with ETL developers and Power BI report developers to confirm upstream data readiness and correctness.
  • Documented test cases, validation results, and issue logs for audit trails and handoffs.
  • The SQL Data Validation project for FedEx aimed to ensure high-quality and accurate data flow into analytical dashboards built for shipment tracking, billing reconciliation, and performance metrics.
  • The initiative played a critical role in building trust in reporting by validating the integrity of data being consumed from operational systems into reporting layers.
  • The role required close collaboration with data engineering, BI developers, and QA teams to ensure timely delivery of validated datasets.

Education

B.com -

The American College
Madurai

Kamaraj University
Madurai

Skills

  • Microsoft Excel and Word
  • Oracle
  • Tableau and Power BI
  • SQL Server and queries
  • Data modeling and visualization
  • DAX query optimization

Disclaimer

I am interested in working for your organization. I enclose my resume as a first step in exploring the possibilities of employment with your organization. I would appreciate your keeping this inquiry confidential. Thank you for your consideration.

Timeline

Specialist

State Street
11.2021 - Current

Senior Process Associate

IQ Backoffice
07.2019 - 08.2021

Process Associate

Entrust
02.2018 - 07.2019

Process Associate

Capgemini Services
06.2016 - 02.2018

B.com -

The American College

Kamaraj University
Giridaran Chandrasekar