Swapnil Darmwal

Driven business intelligence professional managing areas such as data mining, database management and report development. Meticulous and hardworking with a disciplined and methodical approach. Exceptional skills in project management, problem-solving and verbal and written communication.

Home Protect (Insurance/Warranty)

Home Protect (UK: Offsite)

Jul 2025 to Present (Full Time)

For Home Protect, the objective was to consolidate policy lifecycle data and claims management into a unified reporting suite. • Monthly Performance Dashboard: I developed a high-level strategic view to monitor Year-over-Year (YoY) growth and claims loss ratios. Using advanced DAX, I created time-intelligence measures to compare current performance against historical benchmarks. • Operational & Delivery Dashboards: I designed a tactical "Underwriting Pipeline" using Funnel Visualizations to identify customer drop-off points. To ensure service excellence, I built a delivery tracker using Conditional Formatting to highlight SLA breaches in real-time, reducing manual reporting time by 40%.

Yodel (Logistics/Last-Mile)

Yodel (UK: Offsite)

May 2024 to Jul 2024 (Full Time)

At Yodel, the challenge involved managing massive datasets from a nationwide courier network (145M+ annual parcels). • Monthly Performance Dashboard: I engineered an optimized Star Schema model to analyze nationwide volumes. I authored DAX measures for Profitability per Parcel, allowing the finance team to assess contract margins accurately. • Operational Control Tower: I built a real-time tactical dashboard to monitor First-Attempt Delivery Rates (FADR) and vehicle capacity. By integrating data from handheld driver devices, I provided depot managers with instant visibility into sortation and dispatch efficiency. • Delivery & Customer Experience: I utilized Geospatial Mapping to track "Xpect" service window compliance. This enabled regional managers to pinpoint specific postcodes causing delays. This data-backed intervention supported Yodel in achieving a record-high customer satisfaction score of 89.7%.

Asda (Retail/Marketing)

Asda (Offsite)

Jan 2024 to Present (Full Time)

developed a suite of Power BI dashboards to track the end-to-end performance of large-scale Asda retail campaigns. By integrating Point-of-Sale (POS) data with digital marketing metrics, I provided a 360-degree view of promotional ROI and operational execution. Key Implementations: • Strategic Performance: Engineered a Monthly Performance Dashboard to measure Incremental Sales Lift. I used advanced DAX to isolate promotional impact from organic baseline sales, providing a clear view of Return on Ad Spend (ROAS) across thousands of SKUs. • Operational Compliance: Built a tactical dashboard to monitor On-Shelf Availability (OSA). Using Conditional Formatting and real-time inventory data, I flagged stores at risk of stock-outs, improving promotional availability by 15%. • Customer Engagement: Designed a Delivery & Engagement Dashboard using Market Basket Analysis to identify cross-sell patterns.

Hyundai - J.D Power

Kantar IMRB (Offsite)

Aug 2019 to Sep 2019 (Full Time)

- Conducted a survey about the dealers' employee satisfaction of Hyundai for J.D Power, an American-based global marketing information services company.

TripAdvisor - Survey

Kantar IMRB (Offsite)

Jul 2019 to Aug 2019 (Full Time)

- Conducted a survey about the preference of customers regarding the objective of trips, source of transport, and type of hotel through questionnaires by meeting respondents randomly in Delhi NCR.