My work experiences across different companies and roles.
• Delivered analytics, BI, data-platform and automation work across 4 enterprise clients and up to 3 concurrent environments, supporting 20+ recurring dashboards/reports, building 10+ reports/dashboards and investigating 20+ incidents/issues.
• Redesigned analysis-ready Snowflake structures across labour, sales and delivery using 20+ source tables, 15+ analytical tables/views, 20M+ labour rows and 30M+ combined records across multi-year data.
• Built Python/SSIS Snowflake-to-Azure SQL load patterns across 15+ tables and 20M+ historical rows, including raw-staging to final append logic, multi-file ingestion and identity/authentication troubleshooting.
• Developed Power BI workforce/operational reports with DAX, Power Query, heatmaps, KPI logic and variance analysis, including a 5-store labour solution with 30+ DAX measures over 10+ source tables.
• Defined 7 workforce KPIs across 100+ stores and built DLM-style 15-minute staffing diagnostics using sales, role and operational-load features with per-store statistical thresholds.
• Applied Python/SciPy to representative sampling, hypothesis testing, regression/correlation and extended-hours analysis; selected ~100 stores from an ~800-store network and analysed late-night labour/sales patterns.
• Built geospatial external-data pipelines using Google Places/Geocoding across 100+ stores, 1,000+ queries, 50+ brands and 4,000+ API requests, enabling competitor/amenity and demographic feature engineering.
• Built an AI tool-calling labour-reporting agent with 15+ tools/functions and quality gates, and automated delivery through Power Automate, OneDrive/SharePoint and Outlook; also built Azure OpenAI/Azure AI Search RAG document-Q&A workflows.
• Supported production data platforms for legal/professional-services, insurance and financial-services clients through ADF monitoring, SQL validation, Power BI reconciliation, incident investigation and post-recovery checks.
• Produced technical documentation/runbooks covering 10+ systems/pipelines and 10+ stored procedures, supporting 5+ team users and onboarding of 5+ new joiners.
• Implemented a smart-city Digital Twin research prototype linking telemetry through Azure IoT Hub, Event Grid, Azure Functions, Digital Twins, Event Hub and Azure Data Explorer for synchronised state and historical analysis.
• Built/tested Python telemetry senders, a DTDL wind-turbine model and C# Azure Function event processing; contributed to the peer-reviewed ACM MIDD4DT 2024 publication on sustainable urban Digital Twin architecture.
• Worked on AI/ethical-AI educational initiatives for leaders/researchers/citizens
• Extracted, processed, cleaned and verified text from legal/political sources
• Developed training datasets and applied ML/deep-learning/generative-AI techniques
• Worked on model evaluation, fine-tuning and prompt engineering for factual/legal qual
Design & Developed by Ramkrishna Swarnkar
© 2026. All rights reserved.