Jerish David in a navy suit, looking to his left inside a church hall
Research Analyst at StraiveChennai, Tamil Nadu

Jerish David, data analyst

I build dashboards, reporting automation and data quality checks for commercial real estate teams.

About

I work as a data analyst at Straive, with 2+ years turning complex, multi-source datasets into decisions for an international commercial real estate research client. I care most about figures that non-technical partners can read, check and act on.

I also work as an AI-augmented engineer: I direct AI tooling to build the automations and small software that take manual steps out of reporting, then review everything it produces.

Outside the day job I ship small software end to end, from an empty repository to a working product.

Services

What I can do for you

Dashboard development

Interactive Power BI and Tableau dashboards that put the KPIs a non-technical partner needs into one readable view.

Data cleaning & validation

Extraction, staging and reconciliation across source systems, with quality checks that catch discrepancies before figures reach the client.

SQL & reporting automation

Optimised SQL and recurring reports that run themselves, from requirements through documentation.

Quality checks & error tracking

Excel dashboards that read your SharePoint error tracker and show where errors come from, by person, type, source and field, so the right checks run first.

CRE & market research

Commercial real estate transaction and market research for international clients.

Static websites

Hand-written HTML, CSS and JavaScript with a real design system behind it: accessible, fast to load and free of framework overhead.

Mobile apps

Cross-platform apps with secure sign-in, realtime sync between devices and push notifications, delivered from empty repository to working product.

Experience

Reporting owned end to end, for a client who reads every number.

Research Analyst – Executive (Data Analyst)

Straive

09/2024 – Present

Chennai, Tamil Nadu

Wrote and optimised SQL queries (joins, CTEs and window functions) to reconcile and stage transaction data, cutting database update turnaround from 2 days to 1 day, a 50% efficiency gain.

Built interactive Tableau and Power BI dashboards on star-schema models with DAX measures, turning transaction and quality KPIs into decisions business partners could act on quickly.

Built an Excel error-tracking dashboard that pulls the team's SharePoint tracker through Power Query, refreshes the current month automatically, keeps earlier months in a historical tab, and ranks errors by associate, error type, source and field with suggested checks.

Ran exploratory data analysis in Python (Pandas, NumPy) across multi-source datasets to surface the trends, correlations and anomalies behind operational decisions.

Directed AI tooling to build three automations end to end: weekly client reports that regenerate the moment new data lands (saving about 3 hours a week), a task automation cutting a 15-minute process to 5 minutes (67% faster), and a deal-reconciliation tool cutting a week-long file job to 2 days (71% faster).

Validated sources and reconciled discrepancies across Excel and Python, sustaining an error rate of 2-4% on client-facing deliverables.

Translated ambiguous business questions into clear analytical outputs and mentored a 4-member analyst team, supporting reproducibility and faster onboarding.

Research Analyst – Junior Executive (Data Analyst)

Straive

03/2024 – 09/2024

Chennai, Tamil Nadu

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.

Tools

The tools I work in, and what I use each one for.

Analysis and reporting

  • SQL

    Joins, CTEs and window functions for reconciling and staging transaction data.

  • Python

    Pandas and NumPy for exploratory analysis across multi-source datasets.

  • Power BI

    Star-schema models and DAX measures behind transaction and quality KPIs.

  • Tableau

    Interactive dashboards for business partners.

  • Excel

    Pivot tables, complex formulas and the model sheets that sit behind a dashboard.

Automation

  • Power Query and SharePoint

    Live data from shared trackers, refreshed into Excel without copying and pasting.

  • AI tooling

    Directed to build reporting and reconciliation automations, with every output reviewed.

Software

  • React Native and Expo

    Cross-platform mobile apps.

  • Firebase

    Realtime sync and push notifications for mobile apps.

  • Python and BeautifulSoup

    Web scraping and data extraction.

  • JavaScript, HTML and CSS

    Static sites and single-file tools.

Work

Things I've built

  • Quality Checks Dashboard

    Excel tool · In use

    An error tracker and dashboard that finds every error an associate made on sales comps. The team logs errors in a SharePoint tracker and the workbook pulls it in through Power Query, refreshing the current month automatically while earlier months are kept in a historical tab. A model sheet separates true errors from non-errors, and the dashboard ranks errors by associate, error type, source and field, then suggests which checks to run first.

    Built with Excel, Power Query, SharePoint, Excel formulas.

  • Home Board

    Mobile app · In testing

    A shared household shopping list that lives on a kitchen corkboard: whatever one person pins shows up on everyone else's phone immediately, with a push notification when something is added or bought.

    Built with React Native, Expo, Firebase.

  • THAARA

    Website · Live

    Site for a creative studio working on invitation experiences, brand identity, digital design and motion. A hand-written static build: CSS custom properties carry the whole design system, one IntersectionObserver drives the scroll reveals, reduced motion is honoured and every text pair is readable at accessibility standards.

    Built with HTML, CSS, JavaScript, Netlify.

  • Parent Entity Finder

    Data tool · Delivered

    Type a company name and get its direct and ultimate parent, cross-referenced across three public registries (GLEIF, Wikidata and Companies House), with a confidence rating and an Excel-safe CSV at the end. A scoring pass demotes the pension schemes and employee trusts that share a group's exact name, and a human gate stops to ask when two candidates tie.

    Built with JavaScript, REST APIs, Python, Excel.

  • Business Web Scraper

    Python tool · Delivered

    Paste one website link and get a single spreadsheet back: every location the site lists, scored against 40-plus business attributes, with the sentence from the page that proves each answer. No headless browser is needed: discovery falls back from page links to sitemaps to the store locator's own JSON feed, and two QC passes flag anomalies for review instead of overwriting them.

    Built with Python, BeautifulSoup, pandas, Excel.

Screens, walkthroughs and source for any of them are available on request.

Ask me for a look

Let's talk data

Always happy to connect, whether for opportunities, collaborations or a chat about data.

I usually reply within a day.

Email me