Vasanth J

Data Analyst with 2.5+ years of experience in data analytics and business intelligence, with 4+ years of overall professional experience. Currently supporting healthcare analytics for Apollo Hospitals, leveraging SQL, Python, Power BI, Advanced Excel, Power Query for data analysis, dashboard development, ETL, financial analysis and reporting, automation, and KPI-driven insights. Experienced in data modeling, data quality, ad-hoc analytics, stakeholder reporting, and process improvement, with current project experience in Machine Learning and predictive modeling and working knowledge of PySpark and Databricks.

Data Analyst at Tandem Consulting Group — Client: Apollo Hospitals (2024-02 – Present)

• Processed and analyzed 20M+ records across healthcare and financial/accounting datasets for 56 hospitals, supporting analytics for approximately ₹6,000 crore in annual credit revenue.
• Developed and maintained 10+ Power BI dashboards to monitor revenue, collections, outstanding balances, and key AR KPIs, improving financial performance visibility and supporting data-driven decisions.
• Implemented Star Schema models, semantic models, DAX measures, Row-Level Security (RLS), and MoM/QoQ/YoY analysis; managed data refreshes and report enhancements.
• Developed optimized SQL queries and performed data extraction, transformation, filtering, merging, and validation using SQL and Power Query to prepare reliable, reporting-ready datasets.
• Performed variance, trend, cohort, and root-cause analysis across unapplied payments, fully unpaid and partially paid bills, disallowances, and bad debts. Evaluated ageing, outstanding value and volume, due dates, and payment anomalies across units, hospitals, categories, and parties to flag stagnant balances, potential revenue leakage, and high-risk financial exposure.
• Automated recurring, high-volume data cleaning, transformation, consolidation, validation, and reporting workflows across multiple sources using Python and Power Query, reducing processing time from approximately 50 minutes to 5 minutes per run and saving around 4 hours across recurring workflows.
• Conducted UAT and quality checks for Power BI reports, ad-hoc analysis, Python automation scripts, and Power Automate workflows, validating business logic, data completeness, KPI calculations and output accuracy; automated Excel report distribution, prepared MIS reports and board-level presentations, and collaborated with stakeholders on requirements and process improvements.
• Currently contributing to NLP and predictive modeling initiatives for automated bank-statement processing, customer identification, payer turnaround prediction, and collection forecasting.

MIS & Accounts Executive at Shreekar Polyester Private Limited (2023-03 – 2024-02)

• Managed purchase and sales billing, prepared MIS and financial reports using Advanced Excel, PivotTables, and data visualization; analyzed financial and operational data and prepared management reports and PowerPoint presentations for head-office decision-making.

Process Associate at Mahendra Next Wealth IT India Private Limited (2022-08 – 2023-02)

• Processed raw LiDAR data with high accuracy in object identification and annotation, collaborating with team members to maintain consistency and quality throughout the workflow.

Master of Science in Data Science and Analytics – Indira Gandhi National Open University (IGNOU) (2026-07)

Bachelor of Commerce – Government Arts College (2019-06 – 2022-04)