Farhan Omer

Architected secure, scalable data integration solutions across enterprise domains, applying encryption, access controls, and audit logging for sensitive datasets. Built and optimized SQL transformations for governed lakehouse/analytics layers, reducing critical dashboard query latency. Implemented orchestration with resilient retry logic, raised SLA attainment, and added automated data quality and anomaly monitoring to prevent recurring downstream defects. Partnered with data architects and stakeholders to define KPI metrics, documentation, and incident-ready runbooks.

Delivered healthcare data pipelines with privacy-focused controls and auditable access patterns. Developed SQL workflows for claims and eligibility datasets, improving processing performance through query and indexing optimizations. Built and maintained Power BI KPI dashboards with standardized metric definitions, and worked with stakeholders to translate data requirements into measurable outcomes. Added data validation and completeness checks, and supported incremental loading and backfill procedures with runbooks for incident response.

Built scalable data processing services for analytics and reporting, focusing on reliability and repeatable integration patterns. Implemented advanced SQL analytics with performance-oriented partitioning and indexing strategies. Conducted root-cause analysis for data anomalies using logs and data comparisons, then introduced automated data quality and reconciliation routines to reduce manual validation. Strengthened analytics dataset security with least-privilege access patterns and added monitoring for freshness and pipeline health.