•
**Project 1 - Mobile Messaging (MicroStrategy)**
•
Architected and governed the comprehensive **semantic layer** within MicroStrategy, integrating complex multi-level **hierarchies**, dynamic **metrics**, and advanced **attribute forms** to ensure enterprise-wide data consistency and accuracy across 100+ reports
•
Led a **query optimization** initiative by refactoring intricate MicroStrategy reports and fine-tuning **VLDB properties**, achieving a 40% reduction in report execution time and a 25% improvement in overall report delivery performance, significantly enhancing user experience
•
Engineered and deployed a suite of interactive, real-time **dashboards** leveraging MicroStrategy’s **Visual Insight** and **Dossier** capabilities for C-level executives, enabling data-driven decision-making through intuitive **KPI visualizations** and drill-down analytics
•
Implemented advanced **security protocols** including **row-level security (RLS)**, **object-level permissions**, and dynamic **data masking**, ensuring robust data governance and compliance with organizational policies
•
**Project 2 - Gaming Analytics Solution (Power BI)**
•
Pioneered the design and development of an end-to-end gaming analytics platform using **Power BI**, incorporating **composite models**, **incremental refresh**, and **AI-powered Q&A visuals** to deliver real-time insights into player behavior, revenue streams, and game health metrics
•
Crafted a highly optimized **star schema data model** and leveraged advanced **DAX functions** including variables, **time intelligence**, and dynamic segmentation to compute complex KPIs such as **DAU/MAU ratios**, retention rates, and churn analytics
•
Streamlined **ETL processes** with **Power Query** by implementing **query folding**, incremental data refreshes, parameterized functions, and custom connectors, enabling efficient processing of large-scale datasets exceeding 10 million rows
•
Enforced **row-level security (RLS)** within Power BI Service with dynamic role assignments, ensuring secure, compliant data distribution tailored to diverse user roles and business units
•
**Project 3 - Business Analyst (Data Migration - Mini Project)**
•
Led a cross-functional team of 5 members as the primary **Business Analyst**, driving requirement gathering and stakeholder engagement for a critical **data migration** initiative involving multiple legacy systems
•
Translated high-level business objectives into detailed technical requirements and measurable KPIs, incorporating **data lineage** and **impact analysis** to ensure migration accuracy
•
Collaborated closely with data engineers and business users to perform comprehensive **data discovery**, **profiling**, and **validation** across heterogeneous source systems
•
Engineered a proof-of-concept interactive **Power BI report** featuring dynamic filtering, drill-through capabilities, and automated alerts, which validated project feasibility and secured executive sponsorship
•
Presented findings and the final dashboard to business stakeholders, achieving 100% buy-in and confirming alignment with all initial requirements