Hi, I'm Ashu Saini

Ashu Saini | Freelance Data Analyst & Automation Expert in Healthcare RCM

Freelance Data Analyst & Automation Expert & RCM Expert

Ashu Saini
Work skills

Who I Am

I'm a results-driven Reporting Analyst and Automation Specialist with over 3 years of experience in the healthcare RCM domain. I focus on optimizing reporting workflows and automating repetitive tasks using tools like Excel, VBA, SQL, and Playwright. With hands-on experience across various Practice Management Systems such as Tebra and AdvancedMD, I efficiently manage ETL processes and deliver accurate, real-time insights through Power BI dashboards. My work empowers stakeholders to make faster, data-informed decisions.

My approach combines clean, maintainable code with user-centric report design and scalable automation architecture. I'm deeply committed to continuous learning and staying ahead in the fast-evolving world of healthcare tech and data automation, always aiming to deliver innovative, high-impact solutions.

Personal Info

  • Name: Ashu Saini
  • Age: 26 Years
  • Location: Mohali, India
  • Email: ashusaini635@gmail.com

My Interests

  • Web Development
  • Data analytics
  • Automation
  • Excel
  • VBA
  • Dashboards
  • Power BI
  • RCM(US Healthcare)

Skills & Expertise

I've spent years honing my skills across various technologies and disciplines. Here's what I bring to the table.

Data analytics

HTML5 / CSS3

PostgreSQL

Responsive Design

Team Leadership

Git / Version Control

Advance Excel

VBA

Python

Automation

Problem Solving

Wordpress

Ui Path

RCM

My Projects

Here are some of my recent projects. Each one presented unique challenges and opportunities for growth.

DaisyBill Automation

Built an automation solution using Python and VBA to extract, transform, and upload reports from the DaisyBill PMS. Scheduled to run at fixed times, this streamlined reporting, decreased errors, and significantly reduced team workload.

Python VBA Automation

Data Transformation

Created Python automation scripts to handle data transformation for different clients and upload datasets into a PostgreSQL database. Scheduling fixed-time runs saved significant processing time and reduced manual errors.

Python PostgreSQL ETL

Modmed Automation

Designed a full automation workflow using Python to extract, transform, and upload reports from the Modmed PMS into PostgreSQL. Scheduled runs improved accuracy and saved several hours of manual processing weekly.

Python PostgreSQL Automation

Niko Automation

Developed an automation system with Python and Playwright to extract, transform, and upload reports from Niko PMS. This scheduled process minimized human interface, enhanced accuracy, and improved operational efficiency.

Python Playwright Automation

Power BI Dashboard

Created a comprehensive RCM appointments dashboard in Power BI, tracking key performance indicators (KPIs) to provide actionable insights and improve operational efficiency in healthcare revenue cycle management.

Power BI Data Visualization RCM KPI Dashboard

Personal Portfolio Website

Designed and deployed a responsive personal portfolio site using HTML, Tailwind CSS, and JavaScript. Deployed on Netlify, it includes a contact form and serves as a professional platform to showcase skills and projects.

HTML Tailwind CSS JavaScript Netlify

Work Experience

My professional journey has allowed me to work with amazing teams and on exciting projects.

Reporting Analyst

2024 - Present

SGH Management

Automation of Manual Tasks

  • Developed Excel macros and scripts to streamline repetitive tasks, significantly reducing processing time.
  • Created dynamic dashboards with automatic updates, delivering real-time data insights.
  • Utilized UI Path to automate data extraction and reporting, boosting efficiency and accuracy.
  • Designed system-integrated workflows to reduce manual interventions in daily operations.
  • Built Python scripts to automate routine file handling, data formatting, and report generation tasks.

Collaboration with Development Team

  • Worked alongside front-end developers to build and refine the production tracker interface.
  • Contributed to user experience (UX) design, ensuring an intuitive and user-friendly interface.
  • Supported HTML and CSS integration to create responsive and visually appealing UI components.
  • Ensured smooth alignment between front-end components and backend data for seamless functionality.

Database Management

  • Handled PostgreSQL database tasks, including uploading and managing large datasets using Python.
  • Ensured data integrity and optimized database performance for accurate reporting and analysis.
PostgreSQL Ui path Python HTML5 CSS JS

Analyst

2022 - 2024

Coronis Ajuba

  • Managed a team of 20 users responsible for client support and resolving inquiries efficiently.
  • Acted as the primary point of contact for client communications, ensuring concerns were addressed promptly and effectively.
  • Optimized workflows and improved customer experience using tools like ECW, Unity, Tebra, and AdvancedMD.
  • Participated in client meetings to gather requirements, troubleshoot issues, and deliver customized solutions.
  • Developed and implemented Management Information Systems (MIS) to generate weekly production reports, monthly analytics, and ad-hoc reporting based on business needs.
  • Improved data analytics proficiency through ongoing learning and practical implementation, with expertise in Excel, VBA, and SQL.
  • Generated insightful reports using operational data to support strategic decision-making processes.
  • Led the investigation and resolution of laboratory claim denials, reducing the rejection rate by 25% through thorough analysis and process improvements.
  • Managed full billing cycles for HRSA projects, ensuring regulatory compliance and optimal fund utilization.
  • Oversaw the paper claim process for diverse medical treatments, achieving 98% accuracy and a 20% reduction in turnaround time.
  • Supervised billing for Monarch Diagnostics Inc.’s COVID-19 panel (U0001–U0005) and Tox Billing (80307–G0480), ensuring precise and timely submissions.
Excel VBA SQL Data Visualization

Junior Analyst

2021 - 2022

Coronis Health

  • Led the investigation and resolution of laboratory claim denials, lowering the rejection rate by 25% through thorough assessment and process optimization.
  • Managed complete billing for HRSA projects, ensuring full compliance with federal rules and maximizing money utilization.
  • Managed the entire paper claim process for a variety of medical treatments, maintaining a 98% accuracy rate while cutting turnaround time by 20%.
  • Oversaw billing for Monarch Diagnostics Inc.'s coronavirus diagnostics panel U0001-U0005, as well as Tox Billing 80307-G0480, to ensure accurate and timely billing methods.
RCM US healthcare Problem Solving MS office

Get In Touch

Have a project in mind or want to discuss potential opportunities? I'd love to hear from you!

Contact Information

Location

Mohali, India

Website

Ashusaini.app

Follow Me