Raja Jeganathan

Designed and deployed a GenAI-powered NL2SQL solution using Python, LangGraph, LangChain, and Streamlit, now live across 4+ LOBs and used by 50+ DB developers and support engineers.
Architected Snowflake multi-cluster warehouse strategy to isolate workloads across dev, analytics, and reporting teams, improving concurrency and cost efficiency by 40%.
Implemented zero-copy cloning and time travel features to enable rapid environment provisioning and rollback, accelerating QA cycles and reducing rework.
Centralized SQL management, audit logging, and reporting, improving traceability, governance, and team collaboration across data workflows.
Engineered multi-source data integration pipelines using Informatica, SSIS, and Python, processing over 1 TB of structured and semi-structured data weekly.
Designed scalable ELT pipelines using SSIS, Airflow, and Python, ensuring auditability and performance.
Designed secure data sharing workflows using Snowflake’s native sharing and masking policies, enabling cross-LOB collaboration while maintaining compliance with internal data governance standards.
Automated CI/CD workflows with Jenkins, Git, and parameterized deployment scripts for reproducible releases.
Led data lineage and impact analysis initiatives to support governance and control management.
Integrated RBAC and tokenization strategies to enforce data privacy and access control.
Collaborated with QA and business teams to define test coverage, acceptance criteria, and rollback strategies.
Delivered executive dashboards using Power BI with drill-throughs, KPI cards, and dynamic filters.
Mentored junior developers on modular architecture, test-driven development, and documentation standards.
Conducted performance tuning and query optimization across Snowflake, SQL Server, and Python-based ETL, reducing query latency by up to 70%.

Architected and optimized Snowflake-based data warehouse solutions handling over 2 TB of financial data monthly, improving query performance by 50%.
Led migration of legacy ETL workflows to Snowflake-native ELT using SQL and Python, reducing pipeline complexity and improving maintainability across environments.
Orchestrated Snowflake data ingestion using external stages and auto-ingest with Snowpipe, enabling near real-time analytics for operational dashboards.
Developed Power BI dashboards with row-level security, bookmarks, and dynamic slicers for business units.
Built 40+ SSRS reports with parameterized queries and drill-down capabilities, supporting daily operational decisions and SLA tracking.
Implemented data quality checks, exception handling, and alerting mechanisms in ETL workflows.
Led UAT coordination, defect triage, and production deployment planning across multiple releases.
Created metadata repositories and data dictionaries to support business glossary and lineage tracking.
Conducted root cause analysis for data discrepancies and implemented automated reconciliation scripts.
Delivered training sessions for business analysts on Power BI usage, DAX formulas, and data interpretation.

Architected and optimized Snowflake-based data warehouse solutions handling over 2 TB of financial data monthly, improving query performance by 50%. Led migration of legacy ETL workflows to Snowflake-native ELT using SQL and Python, reducing pipeline complexity and improving maintainability across environments. Orchestrated Snowflake data ingestion using external stages and auto-ingest with Snowpipe, enabling near real-time analytics for operational dashboards. Developed Power BI dashboards with row-level security, bookmarks, and dynamic slicers for business units. Built 40+ SSRS reports with parameterized queries and drill-down capabilities, supporting daily operational decisions and SLA tracking. Implemented data quality checks, exception handling, and alerting mechanisms in ETL workflows. Led UAT coordination, defect triage, and production deployment planning across multiple releases. Created metadata repositories and data dictionaries to support business glossary and lineage tracking. Conducted root cause analysis for data discrepancies and implemented automated reconciliation scripts. Delivered training sessions for business analysts on Power BI usage, DAX formulas, and data interpretation.

Delivered cross-border BI implementations integrating Oracle, XML, and HBase into Hive and Impala, supporting analytics for over 10 million monthly transit records.
Automated batch and real-time data ingestion using Autosys and Redwood, improving SLA adherence by 40% and reducing manual intervention by 60%.
Developed Hive queries and UDFs for large-scale data aggregation and transformation.
Authored deployment playbooks, rollback plans, and support guides adopted by 3 offshore teams, reducing onboarding time by 50%.
Designed dashboards for ridership trends, ticketing anomalies, and service performance metrics.
Led data migration efforts from legacy systems to Hadoop-based platforms with zero data loss.
Collaborated with data scientists to provision curated datasets for predictive modeling.
Conducted stakeholder workshops to align KPIs with transport policy and operational goals.
Resolved data discrepancies through root cause analysis and implemented automated reconciliation scripts, reducing ticket volume by 70%.
Delivered training sessions for business analysts on Power BI usage, DAX formulas, and data interpretation.

Delivered cross-border BI implementations integrating Oracle, XML, and HBase into Hive and Impala, supporting analytics for over 10 million monthly transit records. Automated batch and real-time data ingestion using Autosys and Redwood, improving SLA adherence by 40% and reducing manual intervention by 60%. Developed Hive queries and UDFs for large-scale data aggregation and transformation. Authored deployment playbooks, rollback plans, and support guides adopted by 3 offshore teams, reducing onboarding time by 50%. Designed dashboards for ridership trends, ticketing anomalies, and service performance metrics. Led data migration efforts from legacy systems to Hadoop-based platforms with zero data loss. Collaborated with data scientists to provision curated datasets for predictive modeling. Conducted stakeholder workshops to align KPIs with transport policy and operational goals. Resolved data discrepancies through root cause analysis and implemented automated reconciliation scripts. Delivered training sessions for business analysts on Power BI usage, DAX formulas, and data interpretation.

Led a team of 6 BI developers in delivering analytics for ticketing, fare collection, and passenger behavior.
Designed and implemented CI/CD pipelines using Git, Jenkins, and parameterized SSIS packages.
Defined modular ETL architecture with reusable components and centralized error handling.
Conducted code reviews, performance audits, and documentation walkthroughs for quality assurance.
Integrated audit logging and data masking for sensitive passenger and transaction data.
Delivered Power BI dashboards with real-time refresh, drill-throughs, and mobile responsiveness.
Coordinated with business stakeholders to define SLAs, KPIs, and reporting cadence.
Managed sprint planning, backlog grooming, and release coordination under Agile methodology.

Led a team of 6 BI developers in delivering analytics for ticketing, fare collection, and passenger behavior. Designed and implemented CI/CD pipelines using Git, Jenkins, and parameterized SSIS packages. Defined modular ETL architecture with reusable components and centralized error handling. Conducted code reviews, performance audits, and documentation walkthroughs for quality assurance. Integrated audit logging and data masking for sensitive passenger and transaction data. Delivered Power BI dashboards with real-time refresh, drill-throughs, and mobile responsiveness. Coordinated with business stakeholders to define SLAs, KPIs, and reporting cadence. Managed sprint planning, backlog grooming, and release coordination under Agile methodology.

Analyzed transit data to support strategic planning, route optimization, and service reliability.
Built ETL workflows for ridership, ticketing, and service metrics using SSIS and SQL procedures.
Delivered dashboards for executive decision-making, including peak hour trends and fare analysis.
Conducted data profiling and cleansing to improve accuracy and completeness of operational datasets.
Created ad hoc reports for policy makers and transport planners using SSRS and QlikView.
Supported data-driven initiatives for infrastructure investment and service expansion.
Collaborated with GIS teams to integrate spatial data into reporting layers.

Analyzed transit data to support strategic planning, route optimization, and service reliability. Built ETL workflows for ridership, ticketing, and service metrics using SSIS and SQL procedures. Delivered dashboards for executive decision-making, including peak hour trends and fare analysis. Conducted data profiling and cleansing to improve accuracy and completeness of operational datasets. Created ad hoc reports for policy makers and transport planners using SSRS and QlikView. Supported data-driven initiatives for infrastructure investment and service expansion. Collaborated with GIS teams to integrate spatial data into reporting layers.

Developed foundational ETL pipelines using SSIS and SQL Server for enterprise reporting.
Created parameterized SSRS reports for finance, HR, and operations teams.
Gained hands-on experience with Oracle, SQL Server, and Power BI for data visualization.
Supported production deployments, UAT coordination, and defect resolution.
Documented ETL workflows, data mappings, and business rules for audit readiness.
Participated in performance tuning and query optimization exercises.
Assisted in migration of legacy reports to modern BI platforms.

Developed foundational ETL pipelines using SSIS and SQL Server for enterprise reporting. Created parameterized SSRS reports for finance, HR, and operations teams. Supported production deployments, UAT coordination, and defect resolution. Documented ETL workflows, data mappings, and business rules for audit readiness. Participated in performance tuning and query optimization exercises. Assisted in migration of legacy reports to modern BI platforms.

Designed and deployed a GenAI-powered NL2SQL solution using Python, LangGraph, LangChain, and Streamlit, now live across 4+ LOBs and used by 50+ DB developers and support engineers. Architected Snowflake multi-cluster warehouse strategy to isolate workloads across dev, analytics, and reporting teams, improving concurrency and cost efficiency by 40%. Implemented zero-copy cloning and time travel features to enable rapid environment provisioning and rollback, accelerating QA cycles and reducing rework. Centralized SQL management, audit logging, and reporting, improving traceability, governance, and team collaboration across data workflows. Engineered multi-source data integration pipelines using Informatica, SSIS, and Python, processing over 1 TB of structured and semi-structured data weekly. Designed scalable ELT pipelines using SSIS, Airflow, and Python, ensuring auditability and performance. Designed secure data sharing workflows using Snowflake’s native sharing and masking policies, enabling cross-LOB collaboration while maintaining compliance with internal data governance standards. Automated CI/CD workflows with Jenkins, Git, and parameterized deployment scripts for reproducible releases. Led data lineage and impact analysis initiatives to support governance and control management. Integrated RBAC and tokenization strategies to enforce data privacy and access control. Collaborated with QA and business teams to define test coverage, acceptance criteria, and rollback strategies. Delivered executive dashboards using Power BI with drill-throughs, KPI cards, and dynamic filters. Mentored junior developers on modular architecture, test-driven development, and documentation standards. Conducted performance tuning and query optimization across Snowflake, SQL Server, and Python-based ETL, reducing query latency by up to 70%.