Jan 2022 – Jan 2026 · 4 yrs

• Dairy & FMCG Analytics Platform (Mar 2025 – Feb 2026)
• Clients: Sri Venkateshwara Dairy, Sreenivasa Dairy Milk, MOOMARK Pvt Ltd, KVP Dairy, Padmavathi Dairy
• · Architected and delivered an end-to-end analytics, forecasting, and accountability platform for milk procurement, loss control, profitability, and farmer welfare.
• · Designed a SQL-based Lakehouse architecture (Bronze–Silver–Gold) enabling governed ingestion, transformation, and analytics consumption.
• · Built enterprise data models spanning procurement, quality, logistics, processing, sales, forecasting, insurance, and accountability.
• · Implemented high-performance Power BI semantic models with star schema, minimal DAX, and role-level security.
• · Developed explainable forecasting logic with forecast-vs-actual accuracy tracking.
• · Defined KPI & SLA frameworks with ownership, variance analysis, and financial impact attribution.
• · Delivered CXO, operations, planning, and insurance dashboards.
• · Established UAT-driven governance, audit-safe documentation, and Phase-2 optimization roadmap.
• Retail Manufacturing Analytics (2022 – 2025)
• Client: Nutan Jewellers – Nottingham, UK
• · Architected a Power BI + Microsoft Fabric analytics ecosystem with Direct Lake semantic models and OneLake governance.
• · Built predictive models for seasonal demand, margin forecasting, and customer segmentation using PySpark & Delta.
• · Automated multi-store ETL and reporting pipelines, reducing manual BI effort by 75% (480+ hours/month).
• · Enabled pricing, procurement, and inventory optimization through KPI frameworks and anomaly detection.
• Hospitality Analytics Platform (2022 – 2025)
• Client: Global Accommodation Group
• · Designed Fabric Lakehouse → Delta → Semantic → Power BI architecture for bookings, occupancy, revenue pacing, and pricing optimization.
• · Engineered PySpark & DLT pipelines processing 15M+ annual booking records across PMS and OTA systems.
• · Built semantic models with 180+ KPIs (RevPAR, ADR, occupancy, pickup,

Mar 2012 – Aug 2019 · 7 yrs 5 mos · Bengaluru, Karnataka, India · Remote

• Domain: Energy & Power Analytics |
• Tech: Microsoft Fabric Lakehouse, Dataflow Gen2, Databricks Delta, SQL Server, Power BI, DAX, Python, PySpark, GenAI (Copilot, Claude, Ajentic)**
• Enterprise Architecture & Data Engineering
• Architected the Power Valuation Platform analysing 8,500+ power plants across North America (thermal, renewable, storage).
• Designed multi-layer Fabric architecture: ingestion → Delta Lakehouse → Dataflow Gen2 → semantic models → certified datasets → enterprise dashboards.
• Engineered Databricks & SQL pipelines for unit metadata, outage schedules, heat rates, emissions, bid/offer curves, LMP forecasts, and plant performance KPIs.
• Implemented incremental refresh + partition pruning reducing refresh time from 6 hrs → 1.3 hrs.
• Optimized data models with star schema, composite models, relationship tuning, and calculation groups to support 150+ dashboards.
• Advanced DAX Engineering & Performance Tuning
• Optimized high-complexity DAX measures using:
• Variables & scoped evaluations
• Virtual tables & iterators
• CROSSFILTER & TREATAS patterns
• GROUPBY and window functions
• Achieved 3–5× faster query performance across valuation, dispatch, and financial modeling dashboards.
• Built reusable DAX templates for valuation, generation mix, ramp rates, seasonal indexes, forced outage rates, reliability metrics.
• AI Automation & Developer Productivity
• Automated SQL, DAX, PySpark and documentation using GenAI (Claude, Copilot, Ajentic) → 40–60% reduction in development time.
• Created AI-driven BI wireframes, KPI cards, measure templates, and storytelling flows for senior executives and market analysts.
• Built Python-based utilities for data validation, anomaly detection, metadata extraction and lineage mapping.
• Governance & Enterprise BI Standards
• Implemented workspace governance, dataset certifications, lineage, RLS (ISO-based access), and metric cataloging.
• Deployed CI/CD pipelines for automated dataset deployments, schema validation and report versioning

Jan 2012 – Jan 2018 · 6 yrs

• · Migrated Excel-based forecasting systems into scalable BI platforms.
• · Built SCUC & ED dashboards for PJM, MISO, NYISO, ERCOT, and other ISOs.
• · Developed robust SQL and Power Query pipelines for operational analytics.

Mar 2007 – Dec 2009 · 2 yrs 9 mos · Hyderabad, Telangana, India

• Tech: Java/J2EE, JSF, MySQL, Jasper Reports, REST Services, Workflow Engines, Reporting Systems
• Enterprise Application & Reporting Architecture
• Designed and developed modular analytics and reporting systems within Java/J2EE architecture, supporting enterprise-scale operational workflows.
• Built RESTful data services to feed interactive dashboards, improving real-time access to KPIs across operations, finance and process teams.
• Engineered multi-layer reporting engines using JSF + MySQL + Jasper, enabling configurable reports, drill-through views, and scheduled email distribution.
• Database & Performance Optimization
• Optimized SQL queries, indexing strategies and stored procedures, improving report generation performance by 2.5× for high-volume datasets.
• Implemented database normalization, caching strategies and pagination logic reducing API response times by 40–60%.
• Designed aggregated summary tables for high-frequency operational metrics, reducing live query load by 30%.
• Workflow Automation & UI Engineering
• Built workflow monitoring modules tracking process SLAs, pending actions, escalation triggers, approval cycles and operational delays.
• Implemented custom UI components using JSF with role-based access, delivering a secure and responsive reporting experience.
• Created reusable visualization components (tables, charts, filters) accelerating front-end development by ~35%.
• System Integration & Deployment
• Integrated reporting modules with existing ERP and operational systems using SOAP/REST APIs and batch synchronisation jobs.
• Automated deployment pipelines using Ant and shell scripts, improving release reliability and reducing manual deployment effort by 50%.
• Designed error-handling and logging frameworks capturing system failures, improving debugging efficiency across engineering teams.
• Business & Operational Impact
• Delivered dashboards that improved visibility into process SLAs, task turnaround times and operational bottlenecks.

Apr 2005 – Jun 2007 · 2 yrs 2 mos

• · Developed analytics and MIS systems using Java, J2EE, MySQL, and JSF.
• · Built workflow monitoring dashboards and manufacturing reporting solutions.
• · Implemented secure applications using SHA-128/256 encryption.

Apr 2003 – Jan 2005 · 1 yr 9 mos · Hyderabad, Telangana, India

• Domain: Manufacturing Analytics & Workflow Systems
• Tech: Java/J2EE, Struts/Servlets, SQL Server/MySQL, ETL Jobs, Reporting Engines, Scheduling Frameworks
• Manufacturing Data Architecture & Workflow Engineering
• Designed and developed Project Planning & Monitoring System (PPMS) to track production orders, machine utilization, workforce allocation, SLA adherence, and work-center efficiency.
• Engineered a unified data model capturing BOM structures, routing steps, production cycles, capacity rules and shift calendars.
• Built ETL jobs for ingesting shop-floor data (machine logs, operator entries, QC results), ensuring accurate real-time visibility.
• KPIs, Dashboards & Operational Reporting
• Delivered production dashboards including:
• OEE (Overall Equipment Effectiveness)
• Machine downtime analysis
• Cycle-time variance
• Planned vs. actual production
• Rejection/defect ratios
• Implemented drill-through reporting for batch-level traceability, enabling root-cause analysis for quality failures.
• Developed SLA monitoring dashboards highlighting bottlenecks, reducing missed deadlines by 18–22%.
• Performance Optimization & Database Engineering
• Optimized SQL queries, indexing, and stored procedures to support large-volume production logs (100k–500k rows/day).
• Built materialized summary tables for daily WIP, reducing report load times by 3×.
• Designed scheduling modules for automated report generation, email delivery, and exception alerts.
• Workflow Automation & Business Logic
• Implemented approval workflows for production changes, QC exceptions, procurement requests and engineering modifications.
• Added escalation rules for overdue tasks, reducing process delays by ~25%.
• Developed reusable components for form handling, validations, user access, and audit trails.
• System Integration & Deployment
• Integrated PPMS with manufacturing ERP modules (inventory, procurement, QC) through REST/SOAP interfaces.
• Automated deployments using Ant + shell scripting.