Senior Data Analyst - SQL, Python, Tableau, Power BI expert

Summary

Shivam Mishra

******************@*****.*** • +1-765-***-**** • Linkedin

Data Analyst with 5+ years’ experience in delivering data-driven solutions. Proficient in SQL, Python, Tableau, Power BI, and cloud tools such as Azure Data Factory and AWS Glue. Skilled in ETL development, data modeling, dashboarding, and statistical analysis, including A/B testing, regression, and forecasting. Strong background in automating workflows, supporting business decisions, and ensuring compliance. Experience

UNC Health, NC Aug 2025 - Current

Sr Data Analyst

Automated GHX dashboard to track supply chain exceptions across 500+ vendors and 20+ facilities, delivering actionable insights that reduced total exceptions by 12% and improved the Perfect Order Rate by 5%.

Performed variance analysis to track budget vs. actual spend, managing a $70M+ budget variance and reducing it by 10% across 16 hospitals and 3,000+ departments.

Developed dashboards to track $2.3M+ in rush orders, analyze unit price shifts (FY25 vs. FY26), and compare spend against vendor contracts, uncovering $0.2M in savings opportunities and improving validation turnaround by 30%.

Integrated Epic and Vizient data to benchmark mortality, readmissions, complications, and costs; developed cardiology dashboards highlighting implants, case volumes, and cost variances, identifying overuse and $0.2M in savings.

Migrated 20+ data tables from Denodo to Microsoft Fabric, streamlining reporting workflows and improving data accessibility for analytics teams.

Holiday Channel, NC Oct 2024 – July 2025

Data Analyst

Optimized website for seasonal keywords and metadata, executing targeted SEO strategy and boosting traffic by 20%.

Built interactive Tableau dashboards to monitor customer engagement, campaign performance, conversion trends, and revenue forecasts, reducing reporting time by 25% and providing real-time insights to marketing stakeholders.

Created KPI dashboard using Power BI to monitor Website traffic, bounce rates, click-through rates, and conversions.

Partnered with product and engineering teams to build KPI dashboards for content performance and campaign metrics. Accenture, IN Nov 2023 - Jul 2024

Sr Data Analyst

Conducted customer behavior analysis by integrating transactional, web, and CRM data, uncovering trends and opportunities to optimize marketing campaigns and increase engagement.

Applied predictive modeling and trend analysis to identify high-value customer segments, improve targeting, and support personalized marketing initiatives.

Migrated the credit risk pipeline from SQL to Python, reducing 3-hour daily tasks to 30 minutes and saving $50,000.

Automated a Power BI dashboard for real-time credit risk insights, reducing past-due payments by 1%.

Automated insights and recommendations using SAP (ERP) and SQL through an ETL pipeline and KPI benchmarking.

Developed a scoring model (LLM) using the OpenAI API to analyze SAP data, delivering the top 10 business process optimizations with 90% accuracy and boosting profitability by 5%. MFine, Bangalore, India Oct 2022 - Jun 2023

Sr Data Analyst

Developed a Vendor Risk Management System to monitor vendor performance for lab tests and clinics, ensuring customer retention and service quality, which resulted in a 10% increase in fulfillment rates.

Conducted a phlebotomist performance analysis project with MySQL and Python, evaluating sample pickup times and error rates, and raised CSAT scores from 4.2 to 4.7 through actionable recommendations presented in WBRs.

Managed an ETL pipeline implementation project with Informatica and Talend to process insurance claim data, ensuring data quality and monthly billing reports across multiple healthcare providers.

Designed and maintained data dashboards using Tableau to track patient adherence, claim denials, and chronic disease management KPIs, enhancing healthcare outcome visibility.

Utilized SQL to extract, join, and cleanse datasets from EMR systems, IoT devices, and insurance platforms for advanced statistical and clinical analysis.

Conducted EDA and applied statistical models (hypothesis testing, regression, ANOVA) to evaluate care program effectiveness and identify actionable health trends. ClearTax, Bangalore, India Jan 2020 - Sep 2022

Data Analyst

Developed churn prediction and product recommendation models using Scikit-learn, reducing churn by 6% and driving a 5% lift in personalized marketing engagement.

Conducted A/B testing and statistical analyses of promotional campaigns, uncovering strategies that improved customer conversion rates by 8%.

Analysed lead data to identify opportunities and created a Salesforce CRM pipeline, enabling sales representatives to effectively target high-potential leads, resulting in a 5% increase in ARR upsell and a 6% rise in win-back rates.

Designed 30+ dashboards viewed by 500+ users across sales, marketing, and finance, enabling faster decisions and increasing cross-team alignment.

Led Agile coordination for migrating Bitrix CRM to Salesforce across 8 business units, streamlining sales workflows, creating BRDs, conducting UAT testing, and delivering end-user training to achieve a 35% reduction in man-hours.

Automated data QA processes and ensured data integrity for 4,000+ enterprises by implementing 10+ validation rules in Salesforce, enhancing data accuracy by 30%.

Partnered with marketing, finance, and analytics teams to deliver customer segmentation, churn analysis, campaign ROI, and forecasting models using Python, SQL, and Excel, supporting data-driven strategy decisions. Education

Master of Science in Business Analytics and Information Management Aug 2024 Purdue University, Daniels School of Business West Lafayette, IN Bachelor of Technology in Civil Engineering May 2020 Vellore Institute of Technology, Chennai, India

Honors & Awards

Won$1,000 and secured 1st place in "Love Data Visualization" competition with an insightful LEGO data dashboard.

Finalist among 42 teams in the 2024 “KOLs” ProcDNA Healthcare Consulting Case Competition at Purdue University. Certifications

AWS Cloud Practitioner

Microsoft Azure Fundamentals (AZ-900)

Operations Research with SAS Optimization

Advanced SQL HackerRank

Skills

Methodologies: Agile (Scrum, Kanban), Waterfall, SDLC, Lean Six Sigma

Documentation: BRD, FRD, SRS, Process Flows, RTM, User Stories, Use Case Narratives

Data & Visualization Tools: Qlik Sense, QlikView, Power BI, Tableau, DAX, SSIS, MS Excel (Pivot Tables, VLOOKUP, Macros)

Programming & Scripting: Python (pandas, NumPy, scikit-learn), R, VBA, SQL (T-SQL, PL/SQL)

Analysis: GAP Analysis, Root Cause Analysis (RCA), Cost-Benefit Analysis, SWOT Analysis

Project Management Tools: Jira, Confluence, MS Project, Trello, SharePoint

Soft Skills: Stakeholder Management, Negotiation, Conflict Resolution, Decision-Making

Operating Systems: Windows, Linux, macOS

Additional Tools: MS Visio, Axure, MS Word, PowerPoint

Contact this candidate