Work Experience

My work experiences across different companies and roles.

All Experiences(3 experiences)

Ingrity

Ingrity

Working

Data Analyst Consultant

September 2024 - Present

Sydney, Australia

• 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.

National Tsing Hua University

National Tsing Hua University

Research Assistant Intern

June 2023 - September 2023

Hsinchu, Taiwan

• 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.

Boston Global Forum

Boston Global Forum

AI Research Fellow (Volunteer)

April 2024 - October 2024

Remote

Technologies

• 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.