09/2024 – Present
Chennai, Tamil Nadu
Data Analyst (Research Analyst – Executive)
Straive · Client: Green Street — international commercial real estate research & analytics
- Wrote and optimised SQL queries — joins, aggregations, subqueries, CTEs and window functions — to extract, reconcile and stage transaction data from multiple source systems, cutting database update turnaround from 2 days to 1 day, a 50% efficiency gain.
- Built and maintained interactive Tableau dashboards and Power BI reports using DAX measures, calculated columns and star-schema data models, communicating transaction activity, productivity and quality KPIs so business partners could interpret results quickly and act on data-driven recommendations.
- Performed exploratory data analysis in Python (Pandas, NumPy) on complex, multi-source business datasets — profiling distributions, correlations and outliers — to uncover trends, patterns and anomalies that informed operational and strategic decisions.
- Automated recurring reporting with advanced MS Excel — complex formulas, pivot tables and Power Query routines — removing hours of manual preparation each cycle while improving data accuracy for stakeholders.
- Standardised calculation logic and metric definitions across teams, periods and reports, applying descriptive statistics so figures stayed comparable and decision-makers worked from a single source of truth.
- Implemented rigorous data quality checks across Excel and Python to validate sources and reconcile discrepancies, sustaining an approximately 1% error rate on client-facing deliverables.
- Translated ambiguous business questions from non-technical stakeholders into clear analytical outputs; documented methods, assumptions and business rules and mentored a 4-member analyst team, supporting reproducibility, governance compliance and faster onboarding.