Nitesh Yadav

About Nitesh Yadav

Results-driven Business Intelligence Engineer and Data Engineer with 3.6 years of…

Experience

1. Business Intelligence Engineer

   Zeta

   Dec 2024 — Present

   Sparrow Reg Z Dashboard – Designed and implemented SQL logic with CTEs, nested subqueries, and window functions to handle complex dispute scenarios, deriving proposed statement dates and auto-flagging cases exceeding 2 statements (60+ days). UCIC Daily Logic Implementation – Engineered an end-to-end automation framework using optimized SQL queries, joins, and Python pandas, replacing manual curls and file merges. Cut report generation time from ~30 mins to seconds while removing dependency on SRE/QA teams. Chargeback Rights Indicator Dashboard – Developed scalable SQL pipelines with joins, window functions, and CTEs to automate chargeback eligibility checks (ECI, POS, etc.). Transformed a manual, JSON-based 5-minute per-case process into an automated 10-second query-driven solution with added date filters. NTSL Automation – Built automation pipelines for Rupay (CC), UPI (PPI), and CLOU using Python pandas to process raw data, generate statements, and classify transactions. Reduced 2 hours of manual effort to ~20 seconds with improved accuracy. Daily Moving Average (DMA) Dashboard – Designed and deployed a monitoring dashboard using window functions and CTEs to track onboarding volumes against 10-day DMA, enabling early detection of >20% deviations and proactive stakeholder alerts.