Senior Data engineer

ITOM Dashboard & Web Portal 08/2025 – Present ◦ Designed and developed a Power BI Dashboard for Microsoft Intune providing insights into device inventory, compliance, security, user access, and applications. ◦ Integrated internal REST APIs and external portal token-based APIs to extract Intune and Asset Infinity data into Power BI. ◦ Built KPIs and drill-down reports including Managed vs. Unmanaged devices, OS breakdown, Patch status, Compliance %, BitLocker/FileVault coverage, and last check-in trends. ◦ Designed dashboard layout with KPI cards, slicers (OS, region, ownership type), and trend graphs to support IT and security teams in decision-making. ◦ Built a Next.js portal to view ITOM, Vulnerability, and License Utilization reports for users by accessing the Power BI REST API via a Service Principal (SPN). ◦ Implemented CI/CD version control using Power BI Projects (.pbip/.pbir format) with GitHub, enabling granular change tracking of DAX measures, pages, and visuals through feature branching, pull requests, and code reviews via Antigravity IDE. Power BI Tenant Administration & License Optimization Platform ◦ Built end-to-end Power BI tenant monitoring system using Python ETL, Oracle 19c, and Next.js dashboard, ingesting data from 9 Power BI Admin REST API endpoints across 1,164 workspaces, 1,515 datasets, and 1,381 reports for a 4,889-user M365 tenant. ◦ Designed Oracle PL/SQL view (PBI_VW_LICENSE_UTILIZATION) using multi-signal analysis combining user activity logs, schedule ownership, and content consumption patterns to identify 75 unused PPU licenses, projecting USD 18,000 in annual cost savings. ◦ Developed 10 modular Python scripts with incremental loading, retry logic, rate-limit handling, and centralized job execution logging to PBI_ADMIN_JOB_EXECUTION_LOG, automating daily ingestion of 189,000+ activity events with 100% refresh success rate. ◦ Implemented dataset health monitoring with drill-through pages tracking refresh status, schedule configuration, and dependency mapping across 68 active schedules and 1,484 refreshable datasets, enabling proactive identification of stale or failing pipelines. ◦ Deployed responsive Next.js 14 dashboard with static export to Vercel, featuring real-time KPI cards, multi-dimensional filtering (status, engagement level, inactivity period), and interactive Recharts visualizations for license utilization, refresh trends, and user engagement analytics. Marketing BI – Multi-Source Data Pipeline & Analytics Platform ◦ Architected and developed end-to-end ETL data pipeline integrating 6 marketing data sources (Facebook, Instagram, Google Analytics 4, LinkedIn, X/Twitter, Simpplr Hub) using Python REST API automation and SFTP ingestion, loading into Oracle staging tables for centralized marketing analytics. ◦ Built 15+ production Python scripts with incremental and full load strategies using oracledb, MERGE/UPSERT operations, error handling, connection recovery, and never-expiring access tokens, eliminating manual data refresh and reducing data latency from weekly to daily. ◦ Implemented an automated job-monitoring framework (Oracle log table + SMTP email alerts) providing daily success/failure status across all marketing pipelines. ◦ Designed Oracle stored procedures and final reporting tables with optimized schema, composite primary keys, and date-dimension modeling to handle Meta API lifetime-only metric limitations and GA4 unique-count aggregation challenges. ◦ Developed interactive Power BI dashboards with multi-page navigation, dynamic date filtering, DAX measures, and cross-platform KPI cards, published to Power BI Service for leadership and marketing stakeholders. ◦ Established CI/CD pipeline for Power BI reports using .pbip project format with GitHub version control, enabling traceable DAX and visual changes through feature branching, pull request reviews, and merge workflows via Antigravity IDE.

⌂Profit Cube⌂ • Drove a 15% reduction in raw material expenses by creating a real-time PBI dashboard to track and forecast material pricing trends, mitigating supply chain vulnerabilities. o Automated workflows using Alteryx, reducing manual effort by 70% and saving $60,000 annually while improving data accuracy by 30%Engineered ETL pipelines to streamline data ingestion and transformation for improved data accuracy • Orchestrated data-driven financial modelling using Power BI to visualize key performance indicators and metrics, resulting in a 20% improvement in resource allocation efficiency. •Reduced license requirements and saved $60,000 annually by migrating 200+ Alteryx workflows to MS-SQL stored procedures while maintaining data pipeline integrity. •Improved report performance and user experience by 75% by optimizing stored procedures used for labour and material calculations, reducing execution time from over 20 minutes to under 5 minutes. ⌂ FP&A Executive Dashboard⌂ • Designed and developed an Executive Dashboard using Power BI, integrating real-time financial KPIs and forecasts o Generated Conducted comparative analysis using historical, current-year, and forecasted metrics to support financial planning. •Automated ETL processes, reducing manual reporting efforts by 40% and increasing data accuracy. •Constructed data models for financial forecasting, enhancing revenue and cost projections by 30% • Implemented data visualization techniques to present key financial trends, variance analysis, and performance metrics in an interactive, user-friendly format. • Implemented Analytical Centre of Excellence (ACE) guidelines in Power BI reports, incorporating custom visuals to maintain enterprise standards and enhance user experience. o Optimized Power BI with 40+ backend and 10 front end pages using bookmarks and buttons, reducing load time by 30s through DAX and data model optimization.

Advance Life Services ⌂ • Orchestrated ELT/ETL pipelines in Azure Data Factory, leveraging best practices in data transformation, modeling, and visualization across 8+ data sources •Created compelling visualizations in Power BI , improving stakeholder insights and increasing emergency service utilization by 15% •Developed a Star Schema and utilized DAX for a 25% reduction in report loading times and a 50% increase in efficiency. •Managed end-to-end project development and implemented a seamless data collection process using Power Automate for real-time analytic