Jay Awasthi
Indore
Summary
Experienced Associate Consultant with over 2 years of expertise in data analytics, utilizing tools like Dataiku and SQL. Demonstrated proficiency in data visualization using Excel and Power BI, with extensive hands-on experience. Skilled at analyzing complex datasets and providing valuable insights to drive informed decision-making. Committed to delivering high-quality results and continuously improving skills in the dynamic field of data analytics.
Overview
2
2
years of professional experience
Work History
Associate Consultant
Aspect Ratio
02.2025 - Current
- Led a team of two analysts, overseeing the execution of detailed exploratory data analysis (EDA) and quality checks for new bridging datasets being onboarded, ensuring high data integrity and accuracy
- Managed ad-hoc data requests and worked closely with cross-functional teams to deliver actionable insights, optimizing decision-making processes across various business units
Data Analyst
Aspect Ratio
01.2023 - 01.2025
- Received the 'Two Star' award at the Business Townhall for contributions to time-sensitive client delivery, conducted extensive Exploratory and Comparative Data Analysis and large-scale analysis on the Patient Level Claims Dataset (IQVIA eLAAD)
- Developed and implemented a system within the team to minimize analysis errors, contributing to the achievement of the team's goal of delivering error-free results
- Supported clients in purchasing decisions by performing content validation, quality checks and comparative analysis on data from vendors like Clarivate DRG, MMIT, Navlin and Global Data
- Developed expertise in EDA, handling large and complex datasets, providing impactful insights, and data analytics
Education
Bachelor of Technology (B.Tech) - Mechanical Engineering
Institute of Engineering & Technology, DAVV (IET-DAVV)
Indore 05.2023
Skills
- Database Management
- SQL
- Data Visualization
- Reporting
- Excel
- PowerBI
- Dataiku
- Statistical Skills
- Analytical Skills
- Python
- Pandas
- NumPy
- AWS
- Data Extraction
- Analysis
- Issue Diagnosis
- Problem Dissection
- Business Analysis
- Client Relationship Management
- Team Mentoring
Projects
Formulary Library Recreation: Recreating a formulary events dashboard to track changes in drug status within healthcare plans, analyzing the impact of these changes on market share, claims rejection rates, drug abandonment rates, and other key metrics using IQVIA eLAAD Data.
Medical Benefit Analysis: Conducted extensive analysis on a large healthcare claims datasets like IQVIA eLAAD, KOMODO Plaid etc to evaluate medical benefit coverage in comparison to other datasets. Investigated the effects of data blocking on coverage outcomes.
Formulary Data Sets Comparison: Performed comparative analysis on two major formulary data assets (DRG Fingertip Formulary and MMIT Formulary), providing stakeholders with insights to support informed decision-making.
340B Claims Probability: Developed a methodology to assess the workload distribution of healthcare providers between 340B and non-340B entities, calculating the likelihood of claims being covered under the 340B Drug discount program.
Timeline
Associate Consultant
Aspect Ratio
02.2025 - Current
Data Analyst
Aspect Ratio
01.2023 - 01.2025
Bachelor of Technology (B.Tech) - Mechanical Engineering
Institute of Engineering & Technology, DAVV (IET-DAVV)
Similar Profiles
Yash JaiswalYash Jaiswal
Quantitative Analyst at Aspect Ratio Pvt. Ltd.Quantitative Analyst at Aspect Ratio Pvt. Ltd.
Aman DixitAman Dixit
Intern at RatioIntern at Ratio
Krishna AminKrishna Amin
Intern at Golden Ratio Funds Private LimitedIntern at Golden Ratio Funds Private Limited