I am a data engineering and BI technical lead with over 18 years of experience delivering enterprise-scale analytics solutions. I design and build reliable, scalable data platforms and automate data pipelines to empower data-driven decision making across banking, regulatory, and healthcare domains. I’ve led cross-functional teams, implemented regulatory and compliance data frameworks (CRS, FATCA, BASEL III, HL7, FHIR, AML, ALM, BACS), and driven data acquisition and integration across complex environments. I’m known for re-engineering legacy ETL workflows, dramatically reducing runtimes, and applying agile practices to deliver high-impact, data-driven solutions.

Ruben Rao

I am a data engineering and BI technical lead with over 18 years of experience delivering enterprise-scale analytics solutions. I design and build reliable, scalable data platforms and automate data pipelines to empower data-driven decision making across banking, regulatory, and healthcare domains. I’ve led cross-functional teams, implemented regulatory and compliance data frameworks (CRS, FATCA, BASEL III, HL7, FHIR, AML, ALM, BACS), and driven data acquisition and integration across complex environments. I’m known for re-engineering legacy ETL workflows, dramatically reducing runtimes, and applying agile practices to deliver high-impact, data-driven solutions.

Available to hire

I am a data engineering and BI technical lead with over 18 years of experience delivering enterprise-scale analytics solutions. I design and build reliable, scalable data platforms and automate data pipelines to empower data-driven decision making across banking, regulatory, and healthcare domains.

I’ve led cross-functional teams, implemented regulatory and compliance data frameworks (CRS, FATCA, BASEL III, HL7, FHIR, AML, ALM, BACS), and driven data acquisition and integration across complex environments. I’m known for re-engineering legacy ETL workflows, dramatically reducing runtimes, and applying agile practices to deliver high-impact, data-driven solutions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more

Language

English
Fluent

Work Experience

Architect at Covasant Technologies Pvt Ltd
April 1, 2025 - November 2, 2025
Provided technical leadership and people management for data engineering teams, overseeing skill development, project planning, and delivery of large-scale cloud data initiatives. Architected a Data Migration Accelerator to automate the migration of on-prem ETL systems to Cloud ETL, increasing development throughput by over 70% via migration automation. Designed and piloted Generative AI workflows with Human-in-the-Loop refinement and implemented HITL AI systems.
Business Analyst L3 Level at Technopals Consultancy Pte Ltd
April 1, 2025 - April 1, 2025
Led a 10-member cross-regional team delivering FRTB data pipelines and regulatory reports. Designed Operational Data Source (ODS) for real-time and batch ingestion. Managed data strategy decisions, integrated external market data feeds (Bloomberg, Reuters), and delivered Power BI reports connected to Databricks. Produced detailed technical and functional documentation for FRTB pipelines to ensure traceability and smooth handover.
Senior Software Engineer at Innopro Consultancy Pte Ltd
April 1, 2023 - April 1, 2023
Redesigned MAS regulatory reporting systems (MAS610, MAS537). Optimized Informatica ETL pipelines by reusing marts and restructuring architecture. Coordinated cross-team delivery and maintained status dashboards to track deliverables and align with business timelines.
Senior Application Consultant at Tangspac Consultancy Pte Ltd
June 1, 2022 - June 1, 2022
Developed ETL pipelines for Value at Risk (VaR) and various stress scenario calibrations. Interfaced with Murex systems and implemented normalized data models as part of a Murex version upgrade. Managed WBS tracking, deployment oversight, and used reverse engineering as part of the upgrade process.
ETL Lead at Encora Technologies Pte Ltd
November 1, 2021 - November 1, 2021
Modernized legacy ETL systems to AWS using Spark and Kafka streaming. Implemented real-time Operational Data Store (ODS) to provide a golden source of data. Established monitoring, SLA alerting, and modular data ingestion pipelines. Coordinated cross-functional DevOps and QA teams to streamline CI/CD and cloud deployments; ledSingapore-Zurich cloud transformation efforts and developed CRS/FATCA regulatory reports.
Principal Consultant at Just Analytics Pte Ltd
April 1, 2019 - April 1, 2019
Led BI and ETL systems supporting $2B+ in global liquidity risk metrics. Designed a modular data processing framework for 50+ countries, ensuring timely dashboards within SLA. Owned database and ETL design, reporting framework, and implementation strategy. Managed full project lifecycle from requirements through UAT and handover, including code review and testing. Developed regulatory reports such as ALM Fermat and Basel-3 and delivered Power BI dashboards.
Associate at JP Morgan Chase
May 1, 2016 - May 1, 2016
Delivered enterprise-grade Operational Data Store (ODS) and ETL systems for the Securitized Products Group. Built robust data pipelines for mortgage banking, securitization, and analytics. Performed performance tuning including query optimization, indexing, and partitioning; reused ETL mappings to address recurring patterns.
Senior Software Engineer at SABA Software India Pvt Ltd
October 1, 2012 - October 1, 2012
Delivered BI reports in Business Objects and Crystal Reports; reverse-engineered legacy BI reports to redesign underlying databases to enable migration and modernization.
Associate System Analyst at NSE India Limited
August 31, 2011 - August 31, 2011
Performed reverse engineering of the legacy data warehouse and upgraded the star schema. Developed dimensions of data marts, implemented data quality checks, metadata management, and performance tuning for high-volume ETL workloads.

Education

Bachelor's in Computer Engineering/Computer Science at K.C. College of Engineering, India
August 1, 2003 - May 31, 2006
Diploma in Computer Engineering at M.M.J.S Polytechnic, India
August 1, 2000 - June 1, 2003

Qualifications

Microsoft Certified: Azure Data Engineer Associate (DP-203)
January 1, 2025 - November 2, 2025
Microsoft Certified: Azure AI Engineer Associate (AI-102)
January 1, 2025 - November 2, 2025
Google Certified Professional Data Engineer
January 1, 2025 - November 2, 2025
AWS Certified Solutions Architect – Associate (SAA-C03)
January 1, 2025 - November 2, 2025
Certified ScrumMaster (CSM)
January 1, 2025 - November 2, 2025
Project Management Professional (PMP)
January 1, 2020 - November 2, 2025
Certified SAFe 5 Practitioner
January 1, 2020 - November 2, 2025

Industry Experience

Financial Services, Healthcare, Professional Services, Software & Internet

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
See more