Back to Developers
Tushar Arora

Tushar Arora

Data Analyst / BI Analyst

Gurgaon, HR, India 5+ yrs exp 90 ยท Outstanding

About

Data Analyst / BI Analyst with 5+ years of experience in advanced analytics, business intelligence, SQL optimization, data quality, and cloud-based analytics across healthcare and enterprise domains. Strong expertise in SQL, Python, ETL, data warehousing, and interactive visualization. Hands-on experience building AI-powered analytics applications using open-source LLMs, Retrieval-Augmented Generation (RAG), vector search, and agentic workflows.

Skills & Expertise (27)

SQL Advanced
8.4/10
7
Years Exp
Python Advanced
8.2/10
7
Years Exp
ETL workflows Advanced
7.5/10
5
Years Exp
Statistical Modeling Advanced
7.5/10
5
Years Exp
Stakeholder Collaboration Advanced
7.0/10
5
Years Exp
Tableau Intermediate
6.5/10
4
Years Exp
Excel Dashboards Intermediate
6.0/10
5
Years Exp
Agile Intermediate
6.0/10
4
Years Exp
Regression SAS Jira Confluence Rally Scrum Data Extraction Trend Analysis Forecasting Random Forest Quality Checks MS Access RDBMS SQL Server QlikView Antigravity Cursor RAG Prompt Engineering

Work Experience

BI Analyst

CVS Health

Jan 2025 - Jan 2025

Analyzed healthcare claims, pharmacy, payer, and member datasets using SQL Server, T-SQL, Python, and Pandas to generate actionable insights and support operational and business decision-making. Developed a Logistic Regression model using Python (Scikit-learn) to identify high-risk patients from healthcare claims data, enabling early intervention strategies and supporting population health management. Built interactive Power BI dashboards to monitor KPIs including claims trends, medication adherence (Proportion of Days Covered PDC), healthcare utilization, and operational performance for business stakeholders. Performed ETL validation, source-to-target testing, data profiling, reconciliation, and data quality analysis to ensure the accuracy and consistency of enterprise healthcare reporting. Optimized complex SQL/T-SQL queries and automated reporting workflows using Python, improving reporting efficiency, reducing manual effort, and delivering reliable executive BI reports.

Data Quality Manager

Hope Shelters

Jan 2024 - Jan 2025

Validated and transformed HMIS (Homeless Management Information System) datasets and error-checking workflows, improving reporting accuracy for quarterly and annual submissions. Designed automated donor/meal host data pipelines from SquareSpace to Salesforce, reducing manual updates and improving data reliability. Performed root-cause analysis on data integrity issues and implemented corrective workflows to improve data quality across programs. Trained new HMIS users and standardized data-entry processes to strengthen system compliance and reporting consistency. Partnered with leadership to produce actionable insights for funding, compliance, and operational planning.

Data Analyst

Ascension Providence Hospital

Jan 2024 - Jan 2024

Designed and executed a reconciliation framework across Microsoft SQL Server, performing null checks, duplicate detection, data validation, and business rule testing to ensure high data quality and reporting accuracy. Performed SQL performance tuning by analyzing execution plans, optimizing joins, CTEs, window functions, indexing strategies, and query logic, significantly improving report execution time, ETL performance, and resource utilization across large production datasets. Developed and maintained complex SQL queries, stored procedures, views, and data transformation pipelines to support enterprise reporting, dashboarding, KPI tracking, and analytical workflows using SQL, Python, and BI tools. Worked with cross-functional teams to troubleshoot data discrepancies, ETL failures, and production performance issues, conducting root cause analysis, implementing corrective actions, and ensuring reliable delivery of business-critical data solutions. Supported cloud and on-prem data warehouse environments, including performance monitoring, workload optimization, production releases, incident management through ServiceNow, and continuous process improvement for scalable analytics platforms.

Data Analyst - Intern

Binghamton University

Jan 2023 - Jan 2023

Assisted faculty in reviewing and grading student academic projects, offering guidance on data analysis, research approaches, SQL, Python, and visualization techniques.

Business and Data Analyst

Creative Infocom Pvt Ltd

Jan 2018 - Jan 2022

Automated daily Purchase Order and invoice processing using MS Excel and SQL-driven logic, reducing manual work by 90%. Built automated inventory aging and reorder analytics, helping reduce excess stock by 10% through data-driven replenishment. Designed validation scripts that corrected vendor/material data quality issues, improving Procure-to-Pay transaction accuracy. Collaborated with IT and operations teams to streamline data workflows and improve reporting efficiency.

Education

M.S. in Data Analytics - Binghamton University, SUNY

- ยท Afghanistan

B.Tech in Mechanical Engineering - Manav Rachna College of Engineering

- ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 15/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 90/100

Profile Overview

Member sinceAug 2026

Availability Details

Visa Status

Citizen

Relocation

Open to Relocation