Sukhdip Singh

Leveraged 6+ years of deep SQL Server and MSBI engineering, Cloud engineering experience to spearhead the end-to-end design and implementation of a scalable dimensional model for Power BI telemetry, applying a refined star-schema strategy to support enterprise-grade analytics and auditability. Partnered closely with business analysts to elicit, interpret, and translate audit requirements into a high-fidelity dimensional model aligned with organizational governance and reporting standards. Directed and orchestrated cross-team coordination to ensure timely delivery of critical database components-including tables, stored procedures, views, and metadata-while maintaining development continuity across parallel workstreams. Led advanced data-modeling initiatives, producing comprehensive ER diagrams and conceptual/logical/physical data models that informed solution architecture and BI development approaches. Engineered robust databases, tables, stored procedures, indexes, and relational constraints (PK/FK), ensuring integrity, performance, and scalability across transactional and analytical workloads. Applied expert-level SQL Server performance tuning techniques-execution-plan analysis, index optimization, query refactoring-to elevate system throughput and minimize latency across business-critical operations. Architected and delivered high-performance SSIS packages to automate ingestion, cleansing, and synchronization of data sourced from MS Excel, SQL Server, APIs, and flat-file repositories. Implemented complex SSIS transformations—including conditional splits, derived-column logic, advanced lookups, and fuzzy matching-to satisfy intricate business rules and integration requirements. Designed enterprise-grade ETL frameworks and pipeline architectures governing extraction, transformation, and loading operations with a strong emphasis on auditability, resilience, and scalability. Executed normalization and de-normalization strategies across existing data structures to improve performance, align with reporting patterns, and simplify downstream query execution. Championed SQL coding standards, conducted technical reviews, and introduced quality gates to strengthen code maintainability, consistency, and operational reliability. Collaborated with QA and cross-functional teams to validate data accuracy, diagnose issues, and support defect resolution through structured testing and root-cause analysis. Authored detailed technical documentation—including data dictionaries, schema specifications, and process workflows-to ensure transparency and support knowledge transfer. Enhanced platform stability by investigating production incidents, performing root-cause assessments, and delivering permanent corrective measures to prevent recurrence. Drove continuous improvement by identifying optimization opportunities, recommending automation enhancements, and promoting best practices across SQL Server and MSBI ecosystems.