Lavanya SV

Project: Charac Pharmacy Application
Duration: Feb 2022 – Present

Worked on building custom reports for pharmacies using the Charac platform. This included daily, monthly, and quarterly reporting for operations and billing.

Key responsibilities:

• Created tailored dashboards using Power BI and Amazon QuickSight
• Wrote complex SQL queries to extract and transform pharmacy data
• Built and maintained ETL pipelines using AWS Glue
• Used Databricks for data cleaning and transformation in some reporting workflows
• Generated billing reports and service usage summaries
• Analyzed trends and provided insights to pharmacy teams
• Worked closely with stakeholders to gather requirements and ensure accurate reporting

Data Analyst Project: Medical Portfolio Management – Lucida Life

Duration: Sep 2021 – Jan 2022

Worked on the backend of a platform that provides detailed drug and provider information for medical professionals.

Key responsibilities:

• Built data scraping modules to collect drug data
• Created and managed MongoDB collections
• Developed backend features using Django
• Supported website updates, bug fixes, and general maintenance

Science Project: Keyword Detection – PathosAI

Duration: Mar 2021 – Jan 2022

Built a tool to help clients extract useful keywords from user reviews and comments across sectors like government, finance, retail, and healthcare.

Key responsibilities:

• Cleaned and analyzed text data
• Created a master keyword list to search user reviews
• Wrote Python scripts for keyword detection
• Collaborated with the team in daily scrum meetings
• Helped identify key details like gender, location, age, and organization from text