Anshul Singh — Business Analyst

I am a Data Analyst & Business Intelligence professional with experience designing analytics solutions, scalable ETL pipelines, and enterprise reporting systems across healthcare, government, pharma, and financial domains. I specialize in transforming large, complex datasets into impactful insights using SQL, Python, Tableau, Power BI, DBT, and cloud platforms (AWS, Snowflake, Databricks). My work focuses on improving decision-making, increasing operational efficiency, and enabling automated, insight-driven reporting for large organizations. At the Illinois Dept. of Health & Family Services, I delivered automated BI solutions used for Medicaid oversight, optimized SQL pipelines processing millions of records, and built dashboards that improved spend visibility and reporting efficiency by 25%. Prior to that at Axtria and TCS, I developed ML forecasting systems, migrated analytics workflows from SAS to SQL, automated reporting pipelines, and built dashboards that accelerated decision-making in pharma and banking operations. I am passionate about data modeling, analytics engineering, KPI standardization, pipeline optimization, and building scalable BI ecosystems. With an MS in MIS (3.9 GPA) from the University at Buffalo, I aim to drive measurable business impact through clear, reliable, and actionable analytics. Core Skills SQL • Python • Tableau • Power BI • ETL • DBT • Airflow • Data Modeling • Machine Learning • AWS • Snowflake • Databricks • Healthcare & Pharma Analytics • KPI Automation • Dashboards • Predictive Analytics Actively Seeking 📌 Data Analyst 📌 Business Intelligence Engineer / BI Developer 📌 Analytics Engineer 📌 Data Engineer (Entry-Level Hybrid)

Stackforce AI infers this person is a Data Analyst specializing in Healthcare and Pharma analytics with strong BI and ETL capabilities.

Location: Buffalo, New York, United States

Experience: 2 yrs 4 mos

Skills

Business Intelligence (bi)
Sql
Healthcare Analytics
Machine Learning
Data Engineering
Data Analysis

Career Highlights

Delivered automated BI solutions improving reporting efficiency by 25%.
Developed risk models for 18K+ patient records in healthcare.
Engineered scalable data pipelines for pharma analytics.

Work Experience

Illinois Department of Healthcare and Family Services

Data Analyst (1 yr 10 mos)

University at Buffalo

Business Intelligence Engineer (Intern) (4 mos)

Axtria - Ingenious Insights

Associate - Decision Science (2 mos)

Data Analyst - Decision Science (11 mos)

Tata Consultancy Services

Data Analyst - Assistant System Engineer (1 yr 6 mos)

Education

Master's degree at University at Buffalo

Bachelor of Engineering - BE at Medicaps University

Anshul Singh

Business Analyst

Buffalo, New York, United States2 yrs 4 mos experience

AI EnabledAI ML Practitioner

Key Highlights

Delivered automated BI solutions improving reporting efficiency by 25%.
Developed risk models for 18K+ patient records in healthcare.
Engineered scalable data pipelines for pharma analytics.

Stackforce AI infers this person is a Data Analyst specializing in Healthcare and Pharma analytics with strong BI and ETL capabilities.

Contact

anshulkumar1234@gmail.com LinkedIn

Skills

Core Skills

Business Intelligence (bi)SqlHealthcare AnalyticsMachine LearningData EngineeringData Analysis

Other Skills

Agile DevelopmentAgile MethodologiesAgile Project ManagementAgile TestingAnalytical SkillsArtificial Intelligence (AI)AthenaCMSClassificationCluster AnalysisCommunicationDashboard AutomationData AnalyticsData CleaningData Science

About

Experience

2 yrs 4 mos

Total Experience

1 yr 2 mos

Average Tenure

Current Experience

Illinois department of healthcare and family services

Data Analyst

Aug 2024 – Present · 1 yr 10 mos · Springfield, Illinois, United States · Remote

I deliver automated BI solutions for Medicaid programs by optimizing SQL workloads, engineering ETL pipelines, and building dashboards that improve financial and operational reporting.
● Built 12 Power BI dashboards and 5 automated workflows, improving Medicaid spend visibility and reporting efficiency by 25%
● Refactored 14 Oracle SQL scripts, reducing query runtime by 40% across high-volume financial reporting pipelines
● Automated recurring reporting using SQL- and Python-based ETL workflows, reducing manual processing time by 35%
● Optimized analytics performance for datasets exceeding 8M+ records, accelerating insight delivery for leadership
● Identified major budget discrepancies using advanced Excel modeling (VLOOKUP, INDEX-MATCH)

SQLPythonPower BIETLBusiness Intelligence (BI)

University at buffalo

Business Intelligence Engineer (Intern)

Aug 2023 – Dec 2023 · 4 mos · Buffalo, New York, United States · On-site

I supported healthcare analytics initiatives by developing risk models, analyzing large-scale claims data, and building BI dashboards that improved visibility for clinical and operational teams.
● Built a Medicaid risk stratification model for 18K+ patient records, identifying high-cost cohorts to guide care strategy
● Developed 5 Tableau dashboards with automated refresh on 6M+ claims, improving executive reporting and resource planning
● Applied Python (Pandas, NumPy) and SQL to perform claims analysis and uncover utilization and cost trends
● Designed interactive BI visualizations to support decision-making for healthcare operations and policy teams

PythonSQLTableauBusiness Intelligence (BI)Healthcare Analytics

Axtria - ingenious insights

2 roles

Associate - Decision Science

Promoted

Apr 2023 – Jun 2023 · 2 mos · Noida, Uttar Pradesh, India

I contributed to commercial pharma analytics by developing forecasting models, automating reporting workflows, and engineering scalable data pipelines across large datasets.
● Led an ML-driven sales forecasting pipeline using Python + SQL across 10M+ pharma records, improving forecast accuracy by 25%
● Automated reporting workflows using Python + VBA, reducing manual effort by 85% and accelerating insight delivery
● Migrated oncology analytics workflows from SAS → SQL, improving model performance and diagnostic accuracy
● Collaborated with data engineering teams to streamline ETL workflows and enhance pipeline efficiency for downstream analytics

PythonSQLETLMachine LearningData Engineering

Data Analyst - Decision Science

May 2022 – Apr 2023 · 11 mos · Noida, Uttar Pradesh, India

I supported pharma commercial analytics by developing statistical models, optimizing analytics workflows, and building BI reporting solutions to support business decision-making.
● Applied statistical modeling to analyze 500K+ datasets, identifying growth drivers tied to a 40% profit increase
● Developed automated Power BI and Excel reporting solutions to standardize weekly commercial insights for pharma business stakeholders
● Performed exploratory data analysis (EDA) to uncover business trends and support cross-functional pharma teams

Statistical ModelingPower BIExcelBusiness Intelligence (BI)Data Analysis

Tata consultancy services

Data Analyst - Assistant System Engineer

Nov 2020 – May 2022 · 1 yr 6 mos · Indore, Madhya Pradesh, India · Remote

I supported financial analytics teams by building BI dashboards, optimizing SQL pipelines, and developing data warehouse components for enterprise reporting.
● Engineered banking analytics pipelines using Python + SQL, reducing data processing time by 20%
● Designed KPI-driven Tableau dashboards that improved loan approval decision-making by 20%
● Built ETL workflows and data warehouse structures in Oracle to support scalable reporting environments
● Delivered training and documentation for 10+ BI dashboards, increasing stakeholder adoption by 30%

PythonSQLTableauBusiness Intelligence (BI)Data Engineering