Healthcare Data Analyst & RCM Reporting

MOHAMMED ABDUL AZEEZ ANSARI

Data Analyst Healthcare Analytics, RCM & Operations Reporting

***************@*****.*** 971-***-**** LinkedIn New York / New Jersey / Connecticut

PROFESSIONAL SUMMARY

Results-driven Data Analyst with 3+ years of experience designing ETL pipelines, building interactive dashboards, and delivering actionable insights across healthcare, finance, and operations domains. Proficient in SQL (SSMS), Power BI, Tableau, and Python, with direct experience in healthcare data environments including HIPAA compliance and RCM reporting. Skilled at automating workflows using Power Automate, Jira, and REST APIs, and adept at cross-functional collaboration to support data-driven decision-making. Quick learner with the ability to rapidly understand internal data structures and deliver high-quality reports with minimal ramp-up time.

TECHNICAL SKILLS

Data & Reporting

SQL (SQL Server Management Studio), Power BI, Tableau, Azure Analysis Services, Excel (Pivot Tables, VLOOKUP)

Database & Querying

Complex SQL queries, ETL design, data extraction, validation, transformation, stored procedures, SSIS

Automation & Workflow

Python (Pandas, NumPy), Power Automate, Jira, REST APIs, Apache Airflow, Bash scripting, Jenkins

Healthcare Domain

HIPAA compliance, RCM analytics, claims data, patient trends, operations & finance reporting

Cloud Platforms

AWS (S3, RDS, Redshift, Glue), Azure (Data Lake, Synapse Analytics, Data Factory, AKS), Snowflake, Databricks

Big Data & Streaming

Apache Spark, Kafka, Spark Structured Streaming, HDFS

Version Control & CI/CD

GitHub, Docker, Kubernetes, Jenkins, AWS CodePipeline/CodeBuild

Compliance & Security

HIPAA, Role-Based Access Control (RBAC), Data Governance, NIST standards

PROFESSIONAL EXPERIENCE

Data Analyst / Data Engineer CVS Health Aug 2024 – Present

Texas (Client: Supply Chain & Operations Analytics)

•Designed and maintained advanced SQL queries in SQL Server Management Studio (SSMS) to extract, validate, and analyze large-scale operational and supply chain datasets, improving query performance by 35%.

•Built and optimized Power BI and Tableau dashboards to deliver real-time insights into supply chain KPIs, finance trends, and operational metrics for business stakeholders.

•Developed automated ETL workflows using Apache Airflow on AWS and Python scripts for data transformation, validation, and monitoring, reducing manual operations by 30%.

•Partnered with operations, finance, and compliance teams to translate complex data findings into clear, actionable reports, supporting strategic decision-making at leadership level.

•Integrated REST APIs and CI/CD pipelines (GitHub, Jenkins) for seamless data rollouts, ensuring consistency and accuracy across reporting environments.

•Leveraged AWS (S3, RDS, Redshift) and Snowflake for scalable data storage and consumption views, supporting role-based access controls and data governance compliance.

•Supported AI-driven analytics tools to identify trends, surface anomalies, and continuously improve reporting processes and workflow automation.

Data Analyst Tech Mahindra Nov 2022 – Jul 2023

Hyderabad, India

•Conducted comprehensive analysis of operational, finance, and academic performance datasets to identify trends and drive data-informed improvements in resource allocation.

•Wrote and optimized complex SQL queries to extract and validate data from multiple sources; designed ETL processes using SSIS and Kafka for high-quality, consistent data integration.

•Built interactive dashboards in Power BI and Tableau, presenting key performance metrics clearly to business stakeholders and improving accessibility of actionable insights.

•Automated recurring data workflows using Python (including NLP-based processing), reducing manual effort by 25% and accelerating reporting cycles.

•Supported data integration and reporting on Azure Analysis Services, reducing latency and enabling faster decision-making across finance and operations teams.

•Utilized Excel (Pivot Tables, VLOOKUP, financial modeling) to streamline reporting processes and support operational and financial analytics.

Data Engineer CGI Apr 2022 – Oct 2022

Hyderabad, India (Client: United Health Group – Healthcare Analytics)

•Designed and deployed real-time data processing pipelines for healthcare claims and patient trend data using Azure Stream Analytics, Apache Kafka, and Spark Structured Streaming, enabling actionable operational insights.

•Developed and optimized ETL processes using Azure Data Factory and UC4/Automic to integrate data from diverse healthcare sources into the enterprise data warehouse, ensuring data accuracy and integrity.

•Migrated legacy data infrastructure to cloud-native Azure environment (Data Lake Storage, Databricks, Synapse Analytics), improving scalability, performance, and cost efficiency.

•Implemented HIPAA-compliant data pipelines with role-based access controls, safeguarding sensitive patient and claims data in alignment with healthcare regulatory standards.

•Optimized Spark jobs on Azure Databricks by tuning configurations, reducing processing times by 30% and improving operational reporting speed.

•Troubleshot data pipeline issues proactively, ensuring timely resolution and continuous availability of critical healthcare analytics reports.

KEY PROJECTS

Healthcare Claims & Operations Analytics Dashboard

•Built Power BI and Tableau dashboards integrating real-time healthcare claims, patient trends, and finance data, enabling stakeholders to monitor RCM and operational KPIs with reduced latency.

•Implemented SQL-based data validation and HIPAA-compliant access controls, ensuring accuracy and regulatory integrity across all reporting systems.

Automated Data Pipeline & Workflow Automation

•Designed and deployed Python and Airflow-driven ETL pipelines with REST API integrations and CI/CD automation, cutting data provisioning time by 40% and improving reporting consistency.

•Automated data validation, backup, and audit workflows, reducing manual effort significantly and ensuring compliance with NIST and HIPAA standards.

Cloud Data Migration & Hybrid Reporting

•Led migration of legacy data infrastructure to Azure (Data Lake, Synapse, Databricks) and AWS (Redshift, Glue, S3), enabling consolidated analytics across operations and finance.

•Deployed Snowflake and Splunk for centralized data warehousing and audit compliance, improving cross-team data accessibility for RCM and operational reporting.

EDUCATION

Master of Science – Business Analytics May 2025

California State University, East Bay GPA: 3.702

Bachelor of Engineering – Computer Science Jun 2023

Osmania University GPA: 8.0

CERTIFICATIONS

Microsoft Azure Fundamentals (AZ-900) AWS Certified Cloud Practitioner

Contact this candidate