AMIT PATEL

About

Work

Medha AI(Narayana Health)
|

Analyst - Advanced Analytics & AI

Highlights

Automated variable payout process for doctors across 3 hospitals by collaborating with HR teams to understand payout methodologies and translating them into complex SQL queries.

Designed and implemented 10+ analytical dashboards on Narayana Health's in-house portal, leveraging large financial datasets, SQL, Python, and YAML to reduce reliance on external BI tools.

Addressed 15+ dashboard issues by coordinating with App, DE, and QA teams to fix data display errors, SQL failures, and logic conflicts during ongoing development of the analytics portal.

Executed large-scale data validation on evolving datasets using advanced Excel, verifying schema changes and table joins.

My Analytics School
|

Data Analyst Intern

Highlights

Conducted market survey on over 10 platforms in the EdTech industry to launch individual course marketplace.

Performed SWOT analysis and SAM calculation to devise a cost-effective strategic market entry plan.

Collaborated with 4 cross-functional teams to successfully launch the course platform within tight deadlines, showcasing effective communication and project implementation skills.

Education

IIT Kharagpur

B.Tech

Agricultural & Food Engineering

Skills

Technologies

Advanced SQL, Python, Machine Learning, Prompt Engineering, ETL, DBMS, Data Modeling.

Tools and Libraries

MS Excel, Power BI, MySQL, Sklearn, Pandas, NumPy, Jira, Databricks, Visual Studio.

Interests

Business Analysis, Data Analytics, Leadership, Teamwork, Project Management.

Courses

Business Statistics and Analysis Specialization, Probability and Statistics.

Projects

Pizza Sales Analysis
Loan Application Predictor
Time Series Forecasting of Stock Price
Kyphosis Disease Predictor