Jerish David

01

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.

02

03/2024 – 09/2024

Chennai, Tamil Nadu

Data Analyst (Research Analyst – Junior Executive)

Straive  |  Client: Green Street — international commercial real estate research & analytics

• Extracted, validated and structured transaction data from multiple sources, applying data quality controls that improved collection workflows, consistency and operational efficiency.
• Partnered with cross-functional internal teams and client stakeholders to gather requirements and translate business questions into clear analytical outputs delivered on schedule.
• Tracked acquisition, disposition, leasing and development activity across property sectors while adhering to internal data governance, security and documentation standards.

SQL & Data Workflows

Excel & Automation

BI & Data Visualization

Python & Analysis

Analytical Methods

Quality, Governance & Collaboration