Re-architecting
1.1B+ Row Tables
The Scale: At Mastercard, a 1.1B+ row SQL Server transaction table totaling 2.16 TB needed drastic optimization.
The ROI: I re-architected it using monthly date-based partitioning and columnstore compression across 290 partitions. Storage was reduced to 38.5 GB—a massive 98% reduction footprint—while significantly accelerating query performance for fast reporting and time-series analytics.
Accelerating
Ingestion Pipelines
The Scale: Hadoop-to-SQL Server bulk load times were acting as a massive bottleneck, taking 5.6 hours daily.
The ROI: By building a PySpark and XML-driven ingestion framework using partition-log-based incremental processing, load times were slashed to just 1.2 hours. This SSIS orchestration made daily loads faster, infinitely more reliable, and easier to operate.
Building Multidimensional
Analytics Cubes
The Scale: Business teams needed instant aggregation across 44 GB/day of raw incoming data.
The ROI: Daily Auth and Debit cubes were operationalized combining Hadoop, SQL Server, SSAS, and PySpark facts. I achieved a record 38-minute load time for 34 GB of Auth data, unlocking highly scalable, lightning-fast payments analytics.
Delivering Executive BI
on a 2 TB Live Cube
The Scale: Business leaders require absolute confidence when monitoring payments performance at massive enterprise scale.
The ROI: Executive Power BI dashboards were developed running live on a 2 TB enterprise SSAS cube. By tracking core time-series KPIs (MoM, YoY, and growth trends) for top issues, stakeholders gained immediate deep visibility into performance at scale.
Designing Access
Governance at Scale
The Scale: Operating globally means enforcing and verifying access across complex Partner-Acquirer-Merchant hierarchies over 65M rows.
The ROI: I modeled and built a User Access Management dashboard enabling scalable region- and gateway-based access governance. This simplified enterprise access control and improved reporting visibility exponentially across the business.
Tracking Migration &
Operational Readiness
The Scale: Managing client movements between legacy and modern login gateways requires pinpoint tracking over entire regions.
The ROI: I designed a specialized Power BI migration dashboard mapping regions, emails, and pending statuses. This directly provided business teams with real-time operational readiness limits, eradicating bottlenecks and smoothing the entire deployment lifecycle.
Owning Comprehensive
Power BI Operations
The Scale: BI infrastructure requires end-to-end administration to prevent reporting fragmentation and data leaks.
The ROI: I fully managed Power BI access governance—including Active Directory configuration, Stage/Prod environmental roles, refresh automation, and strict report onboarding policies—ensuring the company’s BI ecosystem runs safely and efficiently.