Skip to content
View Nimisharani's full-sized avatar

Block or report Nimisharani

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Content in all repositories owned by your account will be closed.
Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Nimisharani/README.md
Sai Nimisha Kakarla: career timeline

The story so far

I started out cleaning operational data at Kone, then spent two years at Relevance Lab on supply-chain analytics, where shipment analysis cut delivery time by 25% and automated pipelines saved about 9 hours of manual work per week. At Baylor Scott & White I delivered healthcare claims analytics tracking turnaround time, denials and payment discrepancies.

Since April 2023 at Neiman Marcus Group, I have unified 7 sources (OMS, POS, product master, marketplace reconciliation, marketing, customer and inventory) into one PostgreSQL warehouse.

I design fact and dimension models with slowly changing dimensions and define KPIs with finance, merchandising and marketing. I automate data-quality checks in Python, diagnose slow SQL with EXPLAIN ANALYZE, and deliver Tableau dashboards with parameters and drill-downs. I lead validation and UAT for every KPI and maintain code in Git with documented schemas and lineage.

Experience

Role Company Dates Highlights
Data Analyst Neiman Marcus Group · Dallas, TX Apr 2023 – Present 7-source PostgreSQL warehouse, star schema with SCDs, 20+ KPIs, ~50% faster dashboard refresh
Data Analyst Baylor Scott & White · Irving, TX Oct 2022 – Mar 2023 Claims KPIs (volume, turnaround, denials, payment discrepancies), Python data-quality scripts, weekly Tableau reporting
Jr Data Analyst Relevance Lab · Bengaluru, India Jun 2020 – May 2022 25% shorter delivery time, ~9 hrs/week automated, API ingestion into Delta Lake on AWS S3
Data Analyst Intern Kone · Chennai, India Aug 2019 – May 2020 Cleaned and standardized operational data in Excel and SQL; monthly trend reporting

Milestone work

Initiative Scope Outcome
Retail data warehouse Unified 7 sources (OMS, POS, product master, marketplace, marketing, customer, inventory) into PostgreSQL star schema with sales/returns facts and slowly changing dimensions Defined 20+ KPIs
Dashboard performance tuning Diagnosed slow queries with EXPLAIN ANALYZE; restructured joins, filters, and indexes Cut dashboard refresh times by approximately 50%
Automated data quality Python/pandas profiling of daily OMS, POS, and marketplace feeds Removed recurring manual checks; made every run reproducible
OMS-to-marketplace reconciliation Traced mismatches to timing gaps, missing files, and conflicting business rules Documented fixes that became the standard reconciliation process
Supply-chain delay analysis Analyzed shipment data in Python Reduced delivery time by 25%
Delta Lake ingestion Built API-based ingestion from inventory processing application into Delta Lake on AWS S3 Automated extraction saved approximately 9 hours per week
Behind the retail data warehouse

I designed a star schema with sales and returns facts, product and customer dimensions, and slowly changing dimensions. I built SQL transformations using CTEs and window functions for running revenue, category-level return rates, and repeat-customer metrics.

I partnered with stakeholders to define 20+ KPIs and delivered Tableau dashboards with parameters and drill-downs. I led validation and UAT for every KPI and maintained all code in Git with documented schemas and lineage.

Toolkit

  • SQL & databases: PostgreSQL, CTEs, window functions, query tuning, EXPLAIN ANALYZE, indexing
  • Python: pandas, NumPy, boto3, data profiling, workflow automation
  • Modeling & cloud: ETL/ELT, star schema, fact/dimension design, slowly changing dimensions, Delta Lake, AWS S3, EC2
  • BI: Tableau (calculated fields, parameters, interactive dashboards), Excel, KPI reporting
  • Analytics: KPI design, hypothesis testing, segmentation, trend and root-cause analysis
  • Data quality: completeness, duplicate and integrity checks, source reconciliation, UAT test design
  • Domains: retail and e-commerce, marketplace, inventory, returns, healthcare claims, supply chain

Credentials

  • MTech Integrated, Software Engineering – VIT University, Chennai, June 2015 – June 2020

Projects

  • retail-analytics-customer-segmentation — Customer purchasing behavior, seasonal sales trends and category performance from retail transactions, turned into revenue, targeting and inventory recommendations.
  • marginbridge — A price-volume-mix margin bridge plus elasticity estimated against discount confounding, scored against a synthetic ground truth so the pricing advice is not…
  • upliftpolicy — Retention targeting by uplift rather than churn propensity, with Qini curves and doubly-robust policy evaluation that surfaces customers contact drives away.
  • consentgraph — Identity resolution where per-purpose consent gates the graph join itself, with match quality measured as precision against planted ground truth and a…
  • pacingloop — Real-time campaign pacing with hour-of-week median/MAD baselines and a damped, rate-limited controller that avoids false alarms on normal seasonal peaks.
  • dagcache — A content-addressed, parallel pipeline runner for reproducible ML workflows that hashes code, params and data, explains staleness and traces artifact lineage.
  • erasure — GDPR erasure driven by column-level lineage across multiple data stores, verified by an adversary that tries to re-identify the person who was just deleted.
  • permitflow — A municipal permitting workflow where a declared statechart compiles to PostgreSQL constraints and a trigger, so illegal status transitions are rejected by the…
  • ratevault — A motor insurance quote engine with bitemporal rate tables, so any past quote reprices exactly using the rates and rules in force at the time, with a live…
  • pickpath — An offline-first warehouse picking PWA where reconnect conflicts become supervisor exception tasks instead of silently overwritten picks.
  • lastknowngood — A backup recovery drill harness that measures real RTO and RPO by running restores and tests backup immutability by attempting deletion in a sealed lab.

Let's connect

Looking for an analyst who turns multi-source data into KPIs teams trust? Reach out by email or connect on LinkedIn.

Portfolio · Resume · LinkedIn · Email · GitHub

Popular repositories Loading

  1. dashboard dashboard Public

  2. ant-design ant-design Public

    Forked from ant-design/ant-design

    🌈 A UI Design Language and React UI library

    TypeScript

  3. Login-using-hooks-and-redux Login-using-hooks-and-redux Public

  4. LoginApp LoginApp Public

    JavaScript

  5. WeatherApp WeatherApp Public

  6. ToDo ToDo Public