Piyush Kakde

- Developed a Neo4j-based knowledge graph to efficiently organize and retrieve vast amounts of medical data for advanced analysis and insight generation. - Implemented a Retrieve and Generate (RAG) system using Langchain and OpenAI technologies, streamlining the process of medical content summarization and generation. - Launched a Dynamic Content Generator that automates the creation of compliant, persona-based medical content, enabling rapid production of targeted visual aids and campaign materials.

- Designed and executed algorithms for automated data extraction from real estate platforms like Zillow, enabling advanced analytics and predictive model development across multiple zip - Extracted and analyzed medicine pricing data using GoodRx, applying advanced data mining techniques for comprehensive pricing analysis and market trend evaluations. - Programmed using Python and its libraries, Selenium and Beautiful Soup, to perform robust web scraping and data extraction, ensuring high data reliability and integrity. - Cleansed and prepared datasets using Pandas, upholding data integrity standards to ensure quality for sophisticated analytical tasks and model training.

- Led team of 5 members to develop LSTM forecasting model, improving on-shelf product availability, integrated into Power BI dashboard, enhancing product availability, reducing stockouts, and improving customer satisfaction. - Transformed the data visualization approach using Power BI, boosting stakeholders’ engagement by and decreasing report generation time, developing intuitive dashboards that enhanced data accessibility and decision-making.

- Led development and execution of comprehensive go-to-market (GTM) strategies for Fortune 500 pharmaceutical company’s launch of Lung cancer drug using primary market research data, resulting in increase in market share post-FDA approval. - Conducted extensive analysis of PMR data using Python and SQL for segmentation analysis to identify key HCPs segments and developed detailed target personas, improving targeting accuracy and enhancing marketing campaign effectiveness. - Collaborated with cross-functional teams to develop PowerPoint VBA add-in that automatically updates data in visualization from the Data warehouse, reduced manual processing time by 4X, and improved data accuracy. - Mentored and supervised 50+ new joiners in utilizing proprietary in-house survey data analysis tools and data visualization updating tools & techniques, enhancing team productivity, and ensuring high-quality data insights.

- Built interactive Tableau dashboards, PowerPoint reports and Excel workbooks for pharma clients, highlighting KPI and KBQs for sales reps' performance, and HCPs' prescribing behaviours, enabling data-driven decisions and refined promotional strategies, boosting sales. - Orchestrated end-to-end healthcare market research projects, including survey design, data modelling, and visualization, leveraging Excel, SQL, and Python to uncover critical market trends, leading to improvement in campaign targeting accuracy. - Reduced report creation turnaround time by developing visual communication practices and reference repository of visualizations, boosting data presentation quality and increasing user satisfaction.

- Streamlined AML surveillance by enhancing politically exposed people data collection processes, reducing project completion times by 15%. - Designed Tableau dashboard to track progress for team lead & stakeholders, enabling them to monitor data collection, prioritize tasks, and allocate resources efficiently, leading to improvement in team efficiency and preventing project delays.

- Led the construction and development of a mixed-use project, combining a commercial shopping mall with residential apartments, ensuring seamless integration of both functionalities. - Oversaw all phases of construction, from initial ground-breaking to final inspections, adhering to strict timelines and quality standards