NITESH RANGA

• Built and deployed a cloud hosted data engineering portfolio website with automated CI/CD using Git based workflows, enabling version controlled updates and continuous deployment. • Designed, built production style real time data pipelines using AWS, Snowflake, dbt, Airflow and Kafka. • Implemented end to end ELT architectures with layered schemas. • Built streaming pipelines ingesting external APIs with orchestration. • Completed AWS Cloud Practitioner and dbt Fundamentals certifications.

• Led large scale data integration initiatives following Citibank acquisition working with multi source datasets covering 1M plus customers. • Designed and maintained standardized KPI datasets and reporting tables used across 35 branches, improving data consistency, validation and downstream consumption. • Migrated legacy SAS SQL and statistical model workflows to Python and PySpark based processing, improving pipeline performance and achieving ~10% runtime efficiency.

• Delivered acquisition readiness datasets by integrating and validating customer consent data across multiple source systems covering 1M plus customers and €4.2M in deposits. • Built and maintained KPI level datasets tracking acquisition stages and customer consent status, enabling consistent reporting and operational monitoring. • Supported high priority operational recovery by validating data integrity and restoring accurate customer account states for 16K impacted salary accounts.

• Worked with large scale financial and customer datasets across multiple regions to support enterprise forecasting, planning, and performance analytics exceeding $14B in spend. • Built and maintained complex SQL based data extraction and transformation pipelines, enabling consistent and repeatable reporting across regions. • Automated data ingestion and processing workflows, eliminating ~32 hours of monthly manual effort and improving team productivity by ~70%.

• Performed month end rewards expense accounting, payments reconciliation and recoveries, recovered credit note $200K in over payment to a major Client. • Conducted yearly contract reviews, audit controls and amortizing intangible assets.

Managed defined benefit 401K plans and approving medical claims.