Senior Manager — BI & Automation Lead at Labcorp Drug Development (Covance / Chiltern) (2016-12 – Present)
Tech SPOC for the Metrics Management account for 5+ years — the go-to person for all platform, tool, and design decisions across the team.
- Led the full migration of executive dashboards from Spotfire and Excel to Power BI — scoping, DAX and Power Query development, testing, and team handover.
- Built a 50-metric executive dashboard for CEO and L1/L2 leadership — handled requirements, RAG logic, data design, access control, and delivery end to end.
- Built Power BI solutions using advanced DAX (CALCULATE, FILTER, ALL, Field Parameters) and Power Query to replicate complex Spotfire analytics.
- Designed page-level security using five role-based filtering measures and multi-page navigation across dashboard pages.
- Designed Power Automate workflows — Forms-to-Excel pipelines, Desktop flows that trigger VBA scripts, and SharePoint list management flows built with Copilot.
- Rebuilt headcount and exits VBA processing logic using AI-assisted development — cut code runtime from 1 hour to 30 minutes across a 15-module codebase handling 147,000+ rows.
- Set up SharePoint site structures, document libraries, permissions, and user groups for the account — used as the data access backbone.
- Managed HR data workflows with strict access controls and built shared mailbox infrastructure for automated dashboard distribution.
- Set up PowerShell-based SharePoint file downloads and Power Automate flows for SharePoint-to-list exports.
- Led onboarding and knowledge transfer for all new team members joining the account.
- Part of the organising committee for Leadership visits to India.
- Worked with global teams across clinical, HR, and business functions to define requirements and validate reporting outputs.
- Awarded 3 times for excellence and delivery at Labcorp/Covance.
Assistant Manager at Genpact (2013-12 – 2016-12)
Spotfire lead for 3-5 member team across multiple healthcare accounts.
- Built dashboards using IronPython scripting, JavaScript, CSS, scheduled reports, and SQL write-backs.
- Ran scoping calls, managed timelines, and presented demos to clients and leadership.
- Set up the Spotfire environment from scratch and trained the full team.
- Six Sigma Green Belt certified.
Systems Engineer at Tata Consultancy Services (2010-08 – 2013-12)
- Built Spotfire dashboards with IronPython for navigation, on-demand data load, and Oracle DB write-backs.
- Worked on SAP Business Objects — schema design, Universe development, report creation, scheduling, and user access.
- Mentored new joiners on BO and Spotfire. Recognised twice for customer focus.
