Summary
Overview
Work History
Education
Skills
Timeline
Generic

Vikrant Poul

Summary

Data Analyst with four years of experience across healthcare and telecom, specializing in SQL-based data analysis, data quality, and KPI reporting. Experienced in Power BI, advanced Excel, ETL workflows, and AI-assisted analytics using Claude, working with large datasets across SQL Server, Oracle, PostgreSQL, and SAP HANA. Strong background in MCP integration, L2 production support, Root Cause Analysis (RCA), and SLA monitoring, delivering data-driven insights to improve system reliability and business operations.

Overview

5
5
years of professional experience

Work History

Data Analyst

Veradigm
Pune
05.2023 - Current
  • Delivered SQL-driven backend support for US-based EHR, PayerPath, and Practice Management systems, ensuring data accuracy, secure handling of PHI, and strict HIPAA compliance.
  • Worked directly on SQL databases to investigate and resolve production issues through backend queries, controlled data corrections, and validations across patient, billing, and claims data.
  • Diagnosed and resolved production issues using SQL Server, ServiceNow, and log analysis, minimizing downtime and ensuring high application availability.
  • Applied Medallion Architecture (Raw–Refined–Curated) principles to maintain clean, traceable data flows and improve troubleshooting efficiency.
  • Collaborated with L3/Development teams via Jira to perform detailed Root Cause Analysis (RCA), leveraging Kimball dimensional modeling concepts to analyze data relationships and reporting impacts.
  • Validated data migrations, executed SQL data fixes, and performed data quality checks to support product implementations while consistently meeting strict SLA targets.
  • Developed Power BI dashboards on incident trends, SLA adherence, and data issues, enabling leadership to monitor platform health and prioritize remediation efforts.
  • Built drill-down reports for ticket volumes, P1/P2 distribution, root-cause categories, and module-wise impact, helping teams identify recurring failure patterns and high-risk areas.
  • Implemented DAX measures for key KPIs such as average resolution time, backlog aging, first-time fix rate, and data defect density, providing real-time visibility into support performance.
  • Leveraged MCP integration with ClaudeAI to support ETL transaction processing, assist in dimensional data modeling, optimize DAX queries, and accelerate dashboard development through structured logic generation and validation.
  • Monitored incident trends and KPIs, created structured tracking reports, and streamlined workflows aligning SQL debugging, documentation, and analytics-ready processes.
  • Mapped end-to-end healthcare data workflows across EHR, billing, and practice management modules, enabling faster issue isolation, improved data reliability, and stronger upstream–downstream dependency validation.

Data Analyst

TCS
Pune
07.2021 - 01.2023
  • Led operational analytics for BT Trading & Command, conducting system health checks, analyzing Syslog/Debug logs, and coordinating Root Cause Analysis (RCA) with L3/Dev teams to ensure SLA-driven platform stability.
  • Used SQL and Excel to analyze incident history, perform metrics, and capacity trends across trading platforms, identifying recurring problem areas and opportunities for optimization.
  • Investigated application and network performance issues using Wireshark, SNMP data, and vSphere metrics, transforming raw telemetry data into actionable insights that reduced incident turnaround time.
  • Built SQL- and KNIME-based analytical workflows to validate production fixes, structured testing for new implementations, and environment changes.
  • Designed and documented process workflows, upgrade strategies, and KPI frameworks, enabling continuous monitoring of support efficiency, system reliability, and incident trends.
  • Consolidated incident, performance, and capacity data into structured datasets, and created visual reports (Excel/Power BI) to highlight long-term trends for BT trading and Command stakeholders.
  • Supported the creation of operational dashboards tracking system uptime, critical incident counts, and resolution SLA metrics for support leads and client managers.
  • Managed ticket lifecycles via Jira and ServiceNow, mentored junior engineers, and enhanced troubleshooting accuracy through data-driven documentation and knowledge-sharing practices.
  • Mapped end-to-end data, system, and network dependencies, enabling faster pattern detection, proactive issue prevention, and data-backed decision-making across cross-system environments.

Education

Master of Science - Computer Applications Development

Savitribai Phule Pune University
Pune
05-2022

Bachelor of Science - Computer Science

Savitribai Phule Pune University
Pune
05-2020

Skills

Query Languages: SQL

Databases: SQL Server, MySQL, Oracle, PostgreSQL, SAP HANA

Data & BI Tools: Power BI, Tableau, Excel (PivotTables, VLOOKUP, Power Query), SSIS, KNIME, Claude AI

Data Architecture & Concepts: Dimensional modeling (Kimball methodology), Medallion architecture, Data migration & profiling, KPI reporting, MCP integration, Incident & SLA management

Project & ITSM Tools: Jira, ServiceNow, Confluence

Development & Administration Tools: VS Code, SSMS, vSphere

Timeline

Data Analyst

Veradigm
05.2023 - Current

Data Analyst

TCS
07.2021 - 01.2023

Master of Science - Computer Applications Development

Savitribai Phule Pune University

Bachelor of Science - Computer Science

Savitribai Phule Pune University
Vikrant Poul