Senior Data Warehouse Developer & AI Data Architect at ARU Solutions (Berylline Group) (2025-05 – Present)
- Architected BIG DataPulse — a custom Python/Flask orchestration platform managing P&C insurance ETL pipelines (PowerInsure, Claims, Surefyre, RISE) with role-based access, multi-environment (UAT/PROD), real-time monitoring, and Slack/email alerting.
- Designed a multi-layer data warehouse architecture aligned to a P&C insurance ontology (Policies, Claims, Parties, Coverages, Exposures, Assessments) targeting Snowflake as the production ODS with Bronze/Silver/Gold medallion layers.
- Built an AI Underwriting Intelligence module — rule-based risk scoring, bind probability prediction, anomaly detection across six underwriting dimensions — exposed in a DataPulse AI Insights tab with Excel audit trail export.
- Designed real-time data streaming architecture using Apache Kafka for event-driven pipeline triggers and high-frequency data ingestion from source systems into the warehouse.
- Implemented schema drift detection, data reconciliation controls, and a SQL Transformation Framework for staging-to-ODS and ODS-to-mart transformations with versioning and lineage.
- Integrated Snowflake, AWS S3, MySQL RDS, and REST APIs (Surefyre) into a unified ingestion architecture with per-pipeline Python virtual environment isolation.
- Implemented email OTP MFA via SendGrid and multi-admin role-based security for the platform.
Senior Technical Consultant at ITNovate CS Pvt Ltd (2020-12 – 2025-02)
- Led DW/BI, Data Science, and RPA solution delivery across insurance, banking, and retail clients.
- Built retail demand forecasting models using clustering and regression in Power BI. Deployed interactive big data visualisations using Python (Plotly, Vaex.io) on AWS (EC2, Lambda, Beanstalk).
- Designed ETL pipelines and dashboards using Power BI (DAX) and Zoho BI (Zoho Data Prep).
- Designed attended and unattended RPA bots using Automation Anywhere and AARI for invoice processing and scheduled reporting automation.
Technical Consultant — Data Warehouse & BI at Datacurate Technologies (2020-02 – 2020-10)
- Built a centralised SAS Data Warehouse consolidating policyholder, claims, and premium data using SAS Data Integration Studio (SAS DI).
- Designed SAS Visual Analytics (SAS VA) and SAS Viya dashboards for insurance performance monitoring.
Technical Consultant — Data & Risk Analytics at IDFC Bank (2017-07 – 2020-02)
- Implemented SAS Anti-Money Laundering (AML) for transaction monitoring, anomaly detection, and automated regulatory alert generation.
- Developed SAS Credit Risk ETL pipelines and BI dashboards for credit exposure and loan monitoring.
- Automated audit data extraction, validation, and reporting workflows using SAS DI.
Consultant — Insurance BI at C3 Solutions (2013-12 – 2017-05)
- SAS-based reporting for Honda Insurance and Fortis Insurance — policy trends, claim performance, premium analytics, and risk metrics.
- Automated recurring SAS reports reducing manual effort across insurance lines of business.
