Shubham مودليار

• Lead end-to-end delivery across 12+ projects in finance, real estate, and construction with consistent on-time delivery for US
and European Clients
• Eliminated manual reporting bottlenecks by designing Power BI semantic models (star schema, DAX, RLS) and SSRS paginated
reports — cutting reporting cycle time by 40% and freeing clients from Excel-dependent workflows
• Reduced data processing time by 60% by architecting scalable ELT pipelines in Microsoft Fabric (Lakehouse, Notebooks,
Pipelines) and Databricks (PySpark) — enabling real-time operational visibility across large-scale client data warehouses
• Owned the analytics engineering layer end-to-end — building data models with business logic, data quality tests, and full
lineage documentation, transforming raw ingested data into trusted, business-ready datasets consumed by BI and ML
workloads
• Connected business systems (CRM, D365, SAP, Workday, marketing platforms) through Python REST API integrations via
Databricks and DLT pipelines for production clean data — enabling a single source of truth across client data
environments

• Modernized a legacy on-premises data infrastructure at a regulated financial exchange — migrating SQL Server to Azure SQL and
Synapse Analytics, cutting infrastructure costs by 30% and achieving enterprise-grade scalability
• Automated Finance MIS reporting end-to-end using ADF pipelines, SSAS, and Power BI dashboards — increasing reporting
efficiency by 80%
• Bridged the gap between finance, compliance, and engineering teams — translating complex regulatory reporting requirements
into scalable technical solutions presented to senior management

• Gave field clients real-time visibility into operational performance by building Power BI dashboards from raw system data —
replacing ad-hoc reporting and enabling faster, evidence-based client decisions.
• Enhanced client communication by translating technical insights for non-technical stakeholders in manufacturing