Naveen Kumar

Data Warehousing

Bilight Solutions • Fulltime

Jun 2024 - Present • 2 yrs

1. Owned end-to-end data engineering for financial systems, handling extraction, transformation, warehousing, and reporting independently. 2. Processed 60+ JSON sources (including 160GB dataset), transforming 35K+ fields into analytics-ready format. 3. Designed and maintained global data marts across multiple schemas (26 tables, 3 schemas), merging multiple system versions for consistent reporting. 4. Developed complex SQL (38,800+ lines) to extract 223 business-critical fields with high accuracy. 5. Validated and standardized datasets by reverse-engineering schemas and directly coordinating with clients to fix incorrect or missing field mappings. 6. Delivered 40+ analytical reports, including highly complex reports with 200+ fields per record. 7. Built Tableau ETL pipelines for two projects with ~30 data preparation and transformation steps, enabling actionable analytics. 8. Worked extensively for data modeling, schema management, and validation across LOS and LMS systems.