Data Business Analyst

Shivam Mishra Sr Data Analyst

+1-765-***-**** ******.************@*****.*** LinkedIn

Looking Only for Corp 2 Corp Jobs

SUMMARY

Senior Data Analyst with 6+ years of experience delivering data driven insights across healthcare, fintech, and digital domains. Proven expertise in SQL, Python, Power BI, Tableau, and modern cloud data platforms, with a strong background in data modeling, ETL/ELT pipelines, statistical analysis, and analytics engineering. Adept at translating complex datasets into actionable insights through executive dashboards, predictive modeling, KPI frameworks, and experimentation, while partnering closely with cross functional stakeholders to support strategic decision making. Known for building scalable, high performance analytics solutions that drive measurable business impact.

Advanced SQL based analysis, KPI design, hypothesis testing, and A/B experimentation

Predictive modeling, statistical analysis, and business impact measurement

Executive reporting and data storytelling for senior leadership

Conceptual, logical, and physical data modeling Relational (3NF) and dimensional (star/snowflake) schema design

Fact and dimension modeling for OLTP and OLAP systems Strong understanding of normalization, denormalization, and referential integrity

Oracle, SQL Server, Teradata, DB2, MySQL, Redshift T SQL and PL/SQL (stored procedures, functions, triggers, views)

Query performance tuning, indexing strategies, and execution plan analysis Troubleshooting complex production SQL and ETL jobs

SSIS, Informatica PowerCenter, dbt, Apache Airflow Metadata driven ETL frameworks and automated data refresh pipelines Integration of structured and semi structured data for analytics

AWS: S3, Redshift, EMR, EC2, Glue, Lambda Azure: Azure Data Lake, Databricks, Azure SQL, Microsoft Fabric Snowflake data warehousing and analytics pipelines Experience with Google Cloud Platform

Power BI (data modeling, DAX, performance optimization, scheduled refreshes) Tableau for interactive dashboards and executive analytics SharePoint and enterprise gateway integrations

Python (Pandas, NumPy, Matplotlib, Seaborn, SciPy, Scikit Learn) Automation of data extraction, transformation, and reporting workflows REST API integration for external data ingestion

ERwin, ER/Studio, PowerDesigner, Toad Data Modeler UML modeling (Use Case, Activity, Sequence Diagrams) Full SDLC experience in Agile and Waterfall environments

Cross functional stakeholder engagement (business, product, engineering) Technical consulting and end to end solution delivery High quality documentation, dashboards, and presentations

SKILLS

Programming & Querying: SQL (Advanced), Python (Pandas, NumPy, Scikit-learn), PL/SQL, T SQL (Stored Procedures, Functions, Triggers), Query Performance Tuning & Execution Plan Analysis

Data Visualization & BI: Tableau, Power BI DAX, Data Modeling & Performance Optimization, Excel (Advanced Pivot Tables, Power Query, Dashboards)

Analytics & Statistics: A/B Testing, Regression, Forecasting, Hypothesis Testing, Exploratory Data Analysis (EDA), Predictive Modeling & KPI Framework Design.

Data Engineering & ETL: ETL Pipelines, Data Transformation, Azure Data Factory, AWS Glue, Informatica, Talend, dbt.

Databases & Data Modeling: SQL Server, MySQL, PostgreSQL, Data Warehousing, Star/Snowflake Schema, Normalization (1NF BCNF) & Referential Integrity, Data Modeling.

Cloud Platforms: AWS (S3, Glue), Microsoft Azure (ADF, Data Lake), Microsoft fabric, AWS Redshift, EMR, EC2, Lambda, Azure Databricks, Azure SQL, Snowflake, Google Cloud Platform.

Business Analysis: KPI Development, Dashboarding, Requirements Gathering, Gap Analysis, Stakeholder Management

Tools & Collaboration: Salesforce CRM, Jira, Confluence, MSVisio, ERwin, ER/Studio, PowerDesigner, Toad Data Modeler

AI and Automation: ChatGPT, Copilot, Gemini, Claude, BERT, T5, LLaMA, Generative AI, LLMs, NLP, Prompt Engineering, Text Analytics, Machine Learning, Deep Learning, Automation, Python Automation

EXPERIENCE

UNC Health, NC, US Aug 2025 Present

Sr Business Data Analyst

Built enterprise analytics solutions by integrating Epic, Infor, and financial data through Denodo, enabling Power BI dashboards to track cost per case, physician utilization, and supply chain performance across 16 hospitals.

Defined and governed KPI logic by partnering with cross-functional stakeholders, leveraging Collibra for data lineage, traceability, and metric consistency, and developing reusable semantic models to support scalable, trusted reporting.

Developed a vendor optimization model using physician-level usage, RFP pricing, and contract data (via APIs), scoring vendors on cost savings, item coverage, market share, and strategic priority to drive sourcing decisions.

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.

Developed both Tableau and Power BI dashboards and ad-hoc reports from multiple data sources for different departments to their environment.

Managed, created and altered Databases, Tables, Views, Indexes, and Constraints using PL/SQL and python.

Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis

Designed and implemented database schemas, tables, indexes, and stored procedures to optimize query performance and enhance data integrity.

Created and maintained scheduled jobs and alerts in SQL Server Agent for automated database maintenance tasks and monitoring.

Assisted Supply chain analysts with automating reporting functionality using Power BI tools Power BI reporting, Dashboards & Scorecards (KPI) and MySQL & Data warehouse data sources and Optimized data models for large datasets and complex relationships.

Designed and implemented of a Power BI solutions, leveraging Azure SQL Database as the backend data store for analytics.

Designed and developed custom connectors in Power BI to connect to RESTful web services and retrieve on-time or streaming data.

Implemented row-level security in Power BI to restrict access to sensitive data based on user roles and permissions.

Optimized DAX calculations and measures to perform complex aggregations and calculations within Power BI reports, improving accuracy.

Created custom Power BI reports for executive stakeholders, enabling them to visualize revenue forecasts, budget allocations, and expenditure trends to make strategic business decisions.

Leveraged Power Automate to automate workflows, streamline processes, and facilitate data integration between disparate systems in Power BI.

Developed custom connectors and workflows in Power Automate to automate data refreshes, report distribution, and notifications.

Developed complex DAX calculations and measures within Power BI for actionable insights from ServiceNow, SharePoint, and AMDB data.

Applied Machine learning Algorithms and Statistical Modeling to generate customized datasets by extracting, and transforming largely unstructured data using Python and SQL.

Actively contributed to the development and implementation of data-driven solutions, improving operational efficiency by 30% through innovative approaches and close collaboration with business stakeholders and Managers.

Holiday Channel, IN, US Oct 2024 Jul 2025

Data Analyst

Proficient in Python for data analysis, scripting, and automation, enabling efficient data processing and manipulation.

Extensive expertise in Microsoft Office Suite, particularly Excel, showcasing skills in macro creation, Pivot-table utilization, VLOOKUP implementation, chart development, and crafting complex formulas to enhance data analysis and reporting.

Extensive experience in configuring and implementing Guide wire modules to meet business requirements.

Proficient knowledge and hands-on experience with Microsoft Power BI and other data analytics tools, illustrating the ability to leverage these platforms for effective data analysis and presentation.

Possess strong analytical and quantitative skills, emphasizing a data-driven and results-oriented approach to problem-solving and decision-making.

Utilized Databricks for complex data transformations and mapping from source to target systems.

Strong SQL skills, with the ability to write complex queries to extract, transform, and analyze data, ensuring data accuracy and reliability.

Spearheaded ETL processes, streamlining data flow from source systems to the data warehouse.

Optimized ETL workflows to enhance data integration, transformation, and loading efficiency.

Crafted end-to-end Business Intelligence (BI) architectures to support analytics and reporting requirements.

Expertise in data reporting metrics and dash-boarding, utilizing tools like Amazon Quick-sight to create interactive and visually appealing reports for data-driven decision-making.

Expertise in implementing and managing data governance frameworks within organizations, ensuring the development and enforcement of policies, standards, and procedures for effective data management.

Ensured compliance with data privacy regulations by leveraging Purview's classification capabilities.

Collaborated with cross-functional teams to define key performance indicators (KPIs) and establish data reporting strategies, ensuring alignment with business objectives.

Developed and maintained data pipelines to automate data extraction, transformation, and loading (ETL) processes, reducing manual work and enhancing data quality.

Created and optimized data visualizations and dashboards to convey complex information in a clear and actionable manner, supporting stakeholder understanding and engagement.

Played a pivotal role in the successful transition from Oracle to AWS, ensuring data integrity and accessibility while achieving cost savings and scalability.

Leveraged Python libraries, including Pandas and NumPy, for data manipulation and analysis.

Designed and executed PySpark and Airflow jobs to handle complex data transformations and job orchestration, improving data accuracy and workflow efficiency.

Involved in Translating business concepts into XML vocabularies by designing XML Schemas with UML.

Worked on following applications Business Objects, Enterprise Architect, Toad, Plainview (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project).

Boosted website traffic by 20% through data-driven SEO optimization and user behavior analysis

Delivered interactive Tableau dashboards for campaign and engagement tracking, reducing reporting effort by 25%

Established KPI reporting frameworks in Power BI to monitor conversions, engagement, and revenue trends in real time

Uncovered growth opportunities through deep analysis of marketing and customer data, improving campaign effectiveness

Collaborated cross-functionally with product and marketing teams to translate data insights into actionable business strategies

Accenture, IN, US Nov 2023 Jul 2024

Sr. Data Analyst

Worked with the fundraising teams to gather data migration and ETL requirements and prepare requirement documents.

Worked on creating Ad-hoc reports, subscription reports by using Report Builder in SSRS.

Reviewed the data model and reporting requirements for Reports with the Data warehouse/ETL and Reporting team.

Performed Data Cleaning, Data Profiling, and Data Analysis and Data Mapping operations to bring more insights onto the raw finance data.

Worked on exporting data using Teradata and involved in the development of Reporting Data Warehousing System.

Collaborated with business units to understand data governance requirements and incorporated them into Microsoft Purview.

Generated Reports and queries using Crystal Reports for product information report and products due for analyzing.

Implemented and optimized SQL queries within DataBricks for large-scale data sets, ensuring high performance.

Implementation of data governance tools and technologies to automate and streamline data management processes, enhancing efficiency and reducing the risk of errors.

Collaborated with data engineers to optimize data warehouse performance, resulting in faster data retrieval for Power BI reports.

Implemented row-level security in Power BI to ensure sensitive data access control, meeting strict compliance requirements.

Involved in understanding the customer needs with regards to data, documenting requirements, developing complex SQL statements to extract the data and packaging/encrypting data for delivery to customers.

Proficient in Python, using it for data manipulation, analysis, and automation to streamline data processes.

Experienced in PySpark, harnessing its capabilities for distributed data processing and advanced analytics.

Utilized Airflow for job orchestration and task automation, enhancing workflow efficiency.

Demonstrated expertise in writing Python scripts to preprocess, clean, and transform data for analysis and reporting.

Employed PySpark for data transformation, ETL processes, and querying, ensuring data readiness for analysis.

Developed and maintained PySpark data pipelines, enabling seamless data integration and processing.

Conducted data analysis using Python, PySpark, and Airflow, identifying trends, patterns, and anomalies.

Collaborated with cross-functional teams to provide data-driven recommendations and support business objectives.

Proficient in utilizing Tableau for data visualization and analysis, demonstrating the ability to create interactive and insightful dashboards to support informed decision-making.

Experience in leveraging Tableau's advanced features for complex data modeling, including handling large datasets, creating calculated fields, and implementing effective data blending techniques.

Strong understanding of Tableau's integration capabilities with various data sources, ensuring seamless connectivity and extraction of valuable insights from diverse datasets.

Leveraged Python libraries, including Pandas and NumPy, for data manipulation and analysis.

Designed and executed PySpark and Airflow jobs to handle complex data transformations and job orchestration, improving data accuracy and workflow efficiency.

Involved in developing ETL solutions using Clover ETL, R, and Python to process client data.

Guided clients by generating a data forecast report for minimum investment in their upcoming projects using JMP.

Participated in Writing SQL queries to validate source data versus data in the data warehouse including identification of duplicate records.

Involved in Tested whether the reports developed in Business Objects and Crystal Report are as per company standards.

Involved in Testing Ad-hoc reports, drill down and drill through reports using SSRS and different detail, summary reports and on demand reports.

Involved in pre- and post-session migration planning for optimizing data load performance.

Engineered predictive models to identify high-value segments, enhancing personalization and campaign ROI

Re-architected credit risk pipeline (SQL to Python), reducing processing time by 80% and saving $50K+ annually

Implemented real-time Power BI dashboards, contributing to a 1% reduction in past-due payments

Streamlined ETL workflows, improving data processing efficiency and reporting reliability

Deployed LLM-based scoring solution using OpenAI API, achieving 90% accuracy and driving a 5% increase in profitability

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, India Jan 2020 Sep 2022

Data Analyst

Delivered machine learning models for churn prediction and recommendations, reducing churn by 6% and increasing engagement by 5%

Executed A/B testing strategies, improving campaign conversion rates by 8% through data-driven experimentation

Produced 30+ Tableau and Power BI dashboards for 500+ stakeholders, accelerating decision-making and reducing reporting time by 25%

Identified revenue growth opportunities through lead and customer analysis, increasing ARR upsell by 5% and win- back rates by 6%

Enhanced Salesforce CRM pipelines to improve lead targeting and sales performance

Led CRM migration initiative, reducing manual effort by 35% and optimizing workflows

Automated data validation processes, improving enterprise data accuracy by 30%

Collaborated cross-functionally with marketing, sales, and finance teams to deliver insights on segmentation, ROI, and forecasting

EDUCATION

Master of Science in Business Analytics and Information Management

Purdue University, West Lafayette, IN Aug 2024

Bachelor of Technology in Civil Engineering

Vellore Institute of Technology, Chennai, India May 2020

CERTIFICATIONS

AWS Cloud Practitioner

Microsoft Azure Fundamentals (AZ-900)

Operations Research with SAS Optimization

Advanced SQL HackerRank

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.

Contact this candidate