Default profile banner
Shorya RastogiSR

Shorya Rastogi

@shoryarastogi

Data Analyst

Noida, Uttar Pradesh

Arietis Health Tech Pvt. Ltd.Texas McCombs School of Business

Shorya Rastogi is a Data Analyst with experience in insurance claims processing and data-driven decision-making. He possesses skills in advanced data analysis, machine learning, and predictive modeling, gained through his PGP-DSBA program. His technical expertise includes Python, SQL, R, and visualization tools like Tableau and Power BI.

Experience

Sr. Analyst

Arietis Health Tech Pvt. Ltd.

Nov 2022 - PresentNoida, Uttar Pradesh

Spearheaded insurance claims processing ensuring accuracy and timely billing resulting in optimized revenue flow. Collaborated with insurance representatives to resolve claims processing discrepancies, maximizing claim payments. Contributed to process improvements by updating SOPs and mentoring junior team members. Independently managed Air and Ground Ambulatory processes, ensuring client satisfaction and retention. Conducted root cause analysis, reducing denied claims by 20–25%. Utilized SQL for data analysis, leading to a 90–95% reduction in duplicate claims. Developed dynamic dashboards in Excel and visualizations in Tableau for data-driven decision-making.

Sr. Analyst

NTT Data

Jul 2022 - Nov 2022Noida, Uttar Pradesh

Researched and resolved claims discrepancies, ensuring accurate billing and prompt claim processing. Maintained daily reports in MS-Excel and communicated with insurance companies for payment verification.

Sr. Business Associate

Tata Consultancy Services Pvt. Ltd.

Jul 2021 - Jul 2022Gurugram, Haryana

Review, for correctness, claims made by the hospital's backend system and settle them. Make systematic checks to ensure prompt claim processing and effective billing. Optimized data retrieval processes and created interactive dashboards, reports, and visualizations using MS-Excel as per client requirements. Analyzed data, identified trends, and proposed solutions that resulted in a 20-25% reduction in denials. Conducted thorough analysis of insurance claims data using SQL, resulting in a 90-95% reduction in duplicate claims. Created interactive dashboards, reports, and visualizations using Power BI to effectively communicate findings and support data-driven decision-making.

Analyst

R1 RCM Global Private Limited

Jan 2020 - Jan 2021Gurugram (Tikri), Haryana

Examine claims for accurate invoicing to reduce mistakes. Make follow-up calls and verify insurance payments. Conduct methodical examinations to ensure prompt claims processing and effective billing. Work together with insurance companies to address claim denials and partially or not paid claims. Acting as an AR Caller to maximiser income, I used applied data analysis to track and follow up on unpaid claims within the parameters of the regular revenue cycle.

Education

Texas McCombs School of Business

Post Graduate Program in Data Science and Business Analytics (PGP-DSBA)

Data Science and Business Analytics

Nov 2022 - Dec 2023

Mahatma Jyotibha Phule Rohilkhand University

M.Com

Business/Commerce

Jan 2017 - Jan 2019

Mahatma Jyotibha Phule Rohilkhand University

Bachelor of Commerce

Business/Commerce

Jan 2014 - Jan 2017

Skills

Python
SQL
R
Pandas
NumPy
Matplotlib
Scipy
Sklearn
Scikit-Learn
Seaborn
Tableau
Power BI
Excel
EDA
PCA
Data Mining
ML Algorithms
Hypothesis Testing
ANOVA
Clustering
Predictive Modeling
Time Series Forecasting