Sentiment Analysis on Tweets by KOLs
We successfully implemented an efficient data-retrieval mechanism using the Twitter
Historical PowerTrack API, retrieving millions of tweets from influencers through keyword
and hashtag utilization. By running Python scripts on AWS Lambda, we filtered tweets to
derive sentiments of Key Opinion Leaders (KOLs) on clinical research work.
Enhanced Conference Experience with OpenAI
QnA Conversational Interface powered by OpenAI text embedding model allows users to
input search queries for conference details, paper information, or speaker bios, providing
accurate and relevant responses. This QnA Conversational Interface saves time for
conference attendees and enhances their overall conference experience.
PostgreSQL Performance Optimization on AWS RDS
We optimised PostgreSQL database hosted on AWS RDS to reduce query response time
for displaying KOL feed data through proper indexing, avoiding correlated sub-queries and
wise use of temp tables.
Highly Scalable and Secure Cloud based solution
Implemented horizontal scaling using AWS EC2 instances and Docker for containerization.
Utilized AWS Load Balancer and Auto Scaling to dynamically allocate resources based on
demand
Tech Stack







