• Worked on the Real World Large Datasets (Patient Level) such as EMR, MR, Demand Study, Syndicated data, Japan MDV, Charts and Claims.• Utilized various data analysis techniques to investigate diverse patient cohorts, including HR+, HER2+ and TNBC patients providing valuable insights to clients regarding market dynamics, drug utilization patterns, and competitive landscape within the breast cancer tumor area• Initiated and led the analysis of metastatic breast cancer treatment sequences using Sankey charts in Power BI, successfully delivering a comprehensive visualization of therapy flows. This empowered stakeholders to understand treatment patterns more effectively and informed their investment decisions, resulting in commendations for its clear presentation and valuable insights.• I lead weekly meetings with clients to address their ad hoc requests and manage client communications via email, taking full responsibility for deliverables. I also mentor and oversee a junior team member, ensuring high-quality work and knowledge transfer.• Went above and beyond to develop a comprehensive data warehouse using Power BI, Power Apps and Co-pilot, consolidating metrics such as regimen shares, biomarker status, specialty-wise data, and duration of therapy across patient cohorts, including Castration Sensitive and Castration Resistant patients. This self-serving dashboard empowered stakeholders to easily access and analyze critical data insights, ultimately enhancing decision-making and driving improved patient outcomes.Tools used: SQL | Athena | AWS | Redshift | Advance Excel | Power BI | PPT | Glue | Crawler | S3 | IAM | SQS | SNS | Lambda | VPC | EC2 | ETL | DAX | MYSQL | Query Writing

• Created a robust database with well versed, unique, constrained and different type of prompts for making a competitive and intelligent AI model focused on ChatBot. • Created an insightful dashboard for the client with the help of Excel, SQL and PowerBI.Tools used: SQL | Athena | AWS | Redshift | Advance Excel | Power BI | PPT | Glue | Crawler | S3 | IAM | SQS | SNS | Lambda | VPC | EC2 | ETL | DAX | MYSQL | Query Writing

Here, I designed automated machines, autoloaders and unloaders which helps to deliver objects for further machining on SOLIDWORKS software, as various clients has different machines their requirements are different and based on their specific requirements accordingly machine was modelled.Besides this, working animation was also done for quick understanding and marketing purposes.