01 Professional Summary
Data and Analytics professional with 14+ years of robust experience leading B2B data operations,
high-volume reporting delivery, and business intelligence pipelines. Expert at managing cross-functional execution
teams of 15+ members to consistently meet strict data quality benchmarks and client SLAs. Combines
long-term operational leadership and large-scale data governance with hands-on relational data modeling (SQL Server),
cloud data warehousing (Snowflake Medallion architecture), and enterprise Power BI DAX semantic reporting.
02 Core Expertise
- • Operational Leadership: Project delivery execution, resource planning, and end-to-end team
SLA management.
- • Data Quality Assurance & Reconciliation: Designing automated data cleansing, composite key
deduplication, and high-volume audit frameworks.
- • Business Intelligence & Data Modeling: Star Schema design, Power BI DAX semantic models,
VertiPaq performance tuning, and executive dashboards.
- • Database & Pipeline Systems: SQL Server relational querying, Snowflake Streams & Tasks (CDC),
and automated ETL validation pipelines.
03 Professional Experience
Data Consultant (Independent Project Engagements)
- Pipeline Architecture: Build and optimize data pipelines using SQL, Snowflake Streams, and
Tasks for automated, incremental data processing.
- Business Intelligence: Develop comprehensive Power BI dashboards for strategic KPI tracking
and business performance visibility.
- Workflow Optimization: Integrate multiple data sources and implement strong validation
checks across transformation layers to maximize reporting accuracy.
Manager – Data & Delivery
- Team Leadership: Led, trained, and allocated daily tasks for a core data operation and
reporting delivery team of 15+ members handling large enterprise client accounts.
- SQL & Data Operations: Queried relational databases and staging tables using SQL for batch
extractions; processed, validated, and normalized large datasets (200K–300K+ records monthly).
- BI & Process Automation: Architected Power Query and Power BI semantic models alongside
advanced Excel automation macros, reducing client reporting cycle times from 5 days down to 1 day.
- Quality Audits & Reconciliation: Introduced strict multi-gate data quality checks, composite
key deduplication, and reconciliation audits to eliminate final delivery discrepancies.
04 Key Data Architecture & Modeling Projects
Production-Ready Data Models, Auditing Engines & Semantic Systems
1. Commercial 3-Way Quote-to-Invoice Reconciliation System
- Architected a multi-table relational star schema (Jobs, Quotes, Purchase Orders, Subcontractor Invoices)
designed to audit operational cost leakage.
- Engineered automated variance detection logic flagging job-costing discrepancies exceeding a 0.01% threshold
to alert operations before executive financial reports refresh.
2. Automated 3-Gate Data Cleansing & Reconciliation Pipeline
- Developed a production data hygiene framework enforcing structural regex validation (non-printable characters,
format standardization), composite key deduplication, and taxonomy keyword mapping.
- Implemented automated batch exception logging and SLA threshold triage for high-volume 200K+ record delivery batches.
3. Enterprise Executive BI Semantic Engine
- Engineered a high-performance Power BI semantic model utilizing Star Schema architecture, VertiPaq columnar
optimization, and complex DAX time-intelligence metrics.
- Established automated data refresh governance and row-level reconciliation controls between staging datasets
and production reporting views.
05 Verified Technical Certifications
- • HackerRank Verified Skill: Querying Data with Transact-SQL (Issued Feb 2025)
- • Snowflake Academies: Hands-On Essentials: Data Applications | Data Warehousing Workshop | Collaboration & Cost Estimation
- • Coursera Verified Credentials: Preparing Data for Analysis with Microsoft Excel
- • Technical Specializations: Power BI DAX Semantic Modeling, Star Schema Design & Medallion Pipeline Architecture