Data/ Supply Chain / Healthcare Analyst

Gangadhara Rao Arepalli

Saint Petersburg, FL, USA, +1-551-***-****

***********@*****.***

https://www.linkedin.com/in/gandhar01ar/

Data / Supply Chain / Healthcare Business Analyst

PROFESSIONAL SUMMARY:

• Data Analyst with a Master’s in Data Science and over 4 years of targeted experience in data reporting, operational analytics, and process validation within Healthcare and Manufacturing sectors.

• Technical specialist in extracting, cleaning, and structuring large datasets to track critical KPIs, inventory trends, and supply chain efficiency, with a focus on Data Integrity and Traceability.

• Proficient in the "Analyst Stack," including SQL, Python, Power BI, and Advanced Excel (Pivot Tables, Power Query), with hands- on experience maintaining reports within ERP and Hospital Information Systems (HIS).

• Detail-oriented in performing trend analysis and variance reporting to identify operational bottlenecks, billing inconsistencies, and areas for process automation.

• Reliable support for regulatory compliance and internal quality audits, specializing in preparing validated datasets and structured documentation for cross-functional reviews.

• Collaborative communicator experienced in working with Supply Chain, Quality Control (QC), and Finance teams to translate complex business needs into actionable data visualizations and reports.

• Proven ability to streamline workflows by automating manual data entry tasks and Release Status tracking, improving the speed and reliability of management snapshots.

EDUCATION:

Master of Science in Data Science Pace University, New York, USA Master of Computer Applications (MCA) Lakireddy Bali Reddy College of Engineering, India TECHNICAL SKILLS:

• Data Analysis & Reporting: Advanced Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Query), SQL (Basic Queries, Joins), Python

(Pandas for Data Cleaning).

• Business Intelligence: Power BI, Dashboard Maintenance, Automated Reporting, Trend & Variance Analysis.

• Database Management: SQL Server, MySQL, Data Extraction (ETL), Data Validation & Cleaning.

• Operational Systems: ERP Systems (Manufacturing/Supply Chain), Hospital Information Systems (HIS), Revenue Cycle Management (RCM).

• Tools & Collaboration: JIRA (Task Tracking), Git (Version Control), VS Code, Documentation & Testing.

• Data Formats: CSV, JSON, XML, Large Dataset Handling. PROFESSIONAL EXPERIENCE

Client: Verde Nutra, FL Mar 2025 – Present

Role: Regulatory Data Analyst (Supply Chain & Operations) Responsibilities:

• Manages Power BI dashboards to track raw material approval timelines and document status, ensuring zero delays in production scheduling.

• Utilizes SQL and Excel to audit and clean manufacturing data within the ERP system, reconciling lot numbers and expiration dates to ensure 100% traceability.

• Automates cross-referencing of ingredient lists against internal databases, reducing manual verification time by 25% through improved data workflows.

• Coordinates data lifecycles using JIRA, managing documentation flow between R&D and Quality Control (QC) teams to meet operational deadlines.

• Identifies discrepancies in vendor documentation through variance reporting, preventing the use of non-compliant materials in the production line.

• Extracts and structures validated datasets for internal quality audits, ensuring all production data adheres to standardized manufacturing practices (cGMP).

• Develops Excel macros to consolidate testing results from multiple file formats (CSV, JSON), providing real-time snapshots of product release status.

• Maintains technical documentation and data scripts using Git, ensuring all data-handling procedures remain consistent and easily auditable.

Client: Yashoda Hospitals, Hyderabad, India Apr 2021 – Apr 2023 Role: Revenue Data Analyst

Responsibilities:

• Analyzed billing and insurance datasets to track daily revenue trends and identify patterns in claim denials.

• Updated and maintained Excel dashboards for AR Aging and Denial Ratios to help the team monitor financial performance.

• Performed data validation checks between the Hospital Information System (HIS) and insurance remittances to ensure reporting accuracy.

• Conducted deep-dive reviews on claim rejections, identifying recurring billing errors to help reduce "revenue leakage."

• Monitored operational metrics, including claim turnaround time (TAT) and collection rates, for regular departmental reviews.

• Acted as a point of contact between clinical, IT, and insurance teams to resolve billing data inconsistencies. Client: Sparsh Hospital, Bengaluru, India Jan 2018 – Dec 2020 Role: Process & Billing Analyst

Responsibilities:

• Monitored high-volume billing data across inpatient and outpatient services to track revenue cycles and identify operational delays.

• Maintained Excel-based MIS reports and simple dashboards to track billing volumes and insurance approval status.

• Performed data reconciliation between the HIS and finance records to ensure 100% consistency across datasets.

• Tracked trends in claim denials, identifying the most common reasons for rejection to help improve the approval cycle.

• Recorded and reported on KPIs, such as Billing Turnaround Time (TAT) and insurance settlement lifecycles.

• Prepared validated datasets for insurance audits and regulatory compliance reviews. Client: Narayana Health, Bengaluru, India Nov 2015 – Dec 2017 Role: Billing & Data Associate

Responsibilities:

• Processed 150–250 patient records daily for inpatient and outpatient services, ensuring all charges were accurately captured for clinical departments.

• Maintained high data accuracy within the Hospital Information System (HIS) to ensure records were ready for financial and medical audits.

• Prepared daily and weekly billing summaries to help the finance team track departmental performance and daily cash flow.

• Checked claims for errors or missing information before submission, helping to reduce the number of rejected claims by 15%.

• Coordinated with nursing and front-office teams to ensure a smooth transition from patient admission to final billing.

Contact this candidate