Looks like you have JavaScript disabled. For the full Twine experience, you will need to re-enable it.

Senior data professional with 8+ years of experience designing, building, and migrating client-server data systems and analytics platforms using SQL Server and modern Microsoft/Azure ecosystems. I’ve worked across ETL/ELT, governance, DBA responsibilities, and advanced modeling (SCD Type 2, OLAP/OLTP, star/snowflake) with a strong focus on performance and reliability. In recent roles, I built an Azure Synapse warehouse from scratch and led its migration to Microsoft Fabric with a small team, staying hands-on from engineering through architecture and governance. I also deliver real-time analytics with Fabric Eventhouse (KQL), implement privacy/compliance controls (HIPAA/SOC), and support self-service BI using advanced DAX/RLS and well-governed datasets.…Senior data professional with 8+ years of experience designing, building, and migrating client-server data systems and analytics platforms using SQL Server and modern Microsoft/Azure ecosystems. I’ve worked across ETL/ELT, governance, DBA responsibilities, and advanced modeling (SCD Type 2, OLAP/OLTP, star/snowflake) with a strong focus on performance and reliability. In recent roles, I built an Azure Synapse warehouse from scratch and led its migration to Microsoft Fabric with a small team, staying hands-on from engineering through architecture and governance. I also deliver real-time analytics with Fabric Eventhouse (KQL), implement privacy/compliance controls (HIPAA/SOC), and support self-service BI using advanced DAX/RLS and well-governed datasets.

GAURAV SHARMA

Data Engineer, Data Scientist, Data Analyst, +1





Senior data professional with 8+ years of experience designing, building, and migrating client-server data systems and analytics platforms using SQL Server and modern Microsoft/Azure ecosystems. I’ve worked across ETL/ELT, governance, DBA responsibilities, and advanced modeling (SCD Type 2, OLAP/OLTP, star/snowflake) with a strong focus on performance and reliability. In recent roles, I built an Azure Synapse warehouse from scratch and led its migration to Microsoft Fabric with a small team, staying hands-on from engineering through architecture and governance. I also deliver real-time analytics with Fabric Eventhouse (KQL), implement privacy/compliance controls (HIPAA/SOC), and support self-service BI using advanced DAX/RLS and well-governed datasets.…Senior data professional with 8+ years of experience designing, building, and migrating client-server data systems and analytics platforms using SQL Server and modern Microsoft/Azure ecosystems. I’ve worked across ETL/ELT, governance, DBA responsibilities, and advanced modeling (SCD Type 2, OLAP/OLTP, star/snowflake) with a strong focus on performance and reliability. In recent roles, I built an Azure Synapse warehouse from scratch and led its migration to Microsoft Fabric with a small team, staying hands-on from engineering through architecture and governance. I also deliver real-time analytics with Fabric Eventhouse (KQL), implement privacy/compliance controls (HIPAA/SOC), and support self-service BI using advanced DAX/RLS and well-governed datasets.

Available to hire

Senior data professional with 8+ years of experience designing, building, and migrating client-server data systems and analytics platforms using SQL Server and modern Microsoft/Azure ecosystems. I’ve worked across ETL/ELT, governance, DBA responsibilities, and advanced modeling (SCD Type 2, OLAP/OLTP, star/snowflake) with a strong focus on performance and reliability.

In recent roles, I built an Azure Synapse warehouse from scratch and led its migration to Microsoft Fabric with a small team, staying hands-on from engineering through architecture and governance. I also deliver real-time analytics with Fabric Eventhouse (KQL), implement privacy/compliance controls (HIPAA/SOC), and support self-service BI using advanced DAX/RLS and well-governed datasets.

Skills

Experience Level

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Expert

Intermediate

Intermediate

Beginner

Beginner

Work Experience

Senior Data Specialist, Business Intelligence at Amica Senior Lifestyles

November 1, 2022 - Present

Built an Azure Synapse data warehouse from scratch and led migration to Microsoft Fabric using a medallion lakehouse design, re-platforming pipelines by hand. Resolved Fabric migration issues (datetime/datatype mismatches, surrogate key behavior) and redesigned load patterns. Implemented a metadata-driven ETL/ELT framework with config control tables for onboarding sources without new code. Owned Azure environment as DBA: resource groups, capacity sizing, and cost governance. Hands-on with data modeling, query rewrites, materialized views, and complex DAX/CTEs behind reports. Established governance using Azure Purview (cataloging, lineage, classification, endorsed datasets). Led HIPAA/SOC compliance for medical/PI data with ETL masking, database-level masking, and row-level security. Implemented real-time streaming in Fabric Eventhouse using KQL for high-volume telemetry/event analytics. Built an ML model (XGBoost/CatBoost/feature engineering) for rental rate prediction using Salesforce

Senior Data Analyst, AML at RightSource

June 1, 2019 - April 1, 2022

Supported design and implementation of an enterprise insider threat program for user behavioral analytics and data modeling to support investigations and risk mitigation. Managed Azure capacity and built paginated reports to stakeholder specifications. Engineered and debugged ADF pipelines with integrated DevOps versioning (breakpoints/checkpoints). Wrote advanced T-SQL and stored procedures to build SSIS packages with SCD Type 2 historical tracking, later surfaced in SSRS. Acted as technical lead defining DAX and Power Query best practices. Managed ADLS Gen2 and Blob Storage environments for large-scale analytics. Collaborated across Snowflake and Azure to consolidate AML data from multiple institutions into governed datasets; configured thresholds and monitoring. Used Kafka for streaming events and Cosmos DB for low-latency monitoring/fraud workflows. Built predictive modeling to detect new threat techniques and financial crime trends; conducted a Splunk pilot. Extracted recurring th

Data Solution Analyst at Xerox Business Services

August 1, 2015 - July 1, 2018

Processed and staged large datasets using Hadoop/HDFS workflows feeding SQL Server reporting for analytics. Developed SSRS tabular/sub/matrix and drill-down reports and Power BI dashboards from business requirements. Migrated departmental Sisense dashboards into Power BI. Integrated external APIs and imported data into SQL Server for reporting via Azure Data Link (ADL). Managed SQL Server databases across dev-to-production lifecycles and led roadmap migration to SQL Server 2014. Captured database/server/application metrics for long-term capacity planning; maintained tables, views, indexes, stored procedures, and functions.

Business Operations Analyst at Aon Hewitt Consulting

October 1, 2013 - July 1, 2015

Managed ETL frameworks and scheduled ingestion using SQL Server Agent Jobs and SSIS. Migrated complex MS Access code into optimized T-SQL and built SSAS multidimensional cubes for performance analysis. Automated quarterly refreshes with VBA macros and wrote PowerShell scripts for automated table/view refreshes (reducing manual effort). Performed preventive maintenance including causal analysis, program code restructuring, and data issue resolution. Designed ad-hoc Excel PowerPivot reports and migrated slow-running reports into interactive Power BI dashboards.