Data Analyst with expertise in Reporting Analytics. Proficient in Python, Excel Macros, Web scraping and SQL

I have worked as Data Analyst for the past 3 years in a healthcare solutions company.
Benchmark Projects:
Customer segmentation: We analyzed the patient data for a drug and its market obtained from CRM and implemented unsupervised learning techniques to segment the customers into various buckets based on common characteristics for devising an effective strategy for promotion. An excel Dashboard was developed to show the increase in drug sales after effective E-Mail strategies developed based on the segmented data.
Sentiment Analysis: We performed sentiment analysis for a drug that has been recently launched into the market and analyzed the overall Sentiment. The process involved collecting data from various social media sites like Twitter, YouTube, Instagram, etc. and perform Text cleaning and sentiment analysis using python. A word cloud was developed based on the data and it helped understand the patient and physician views on the drug as compared to its competitors.
Global Sales Portfolio Management Dashboard: It involved creating an Excel tool using VBA to automate the Quarterly report updation of various drugs and its competitors in multiple regions. The process involved automating the collection of required data from raw files and creating trends and visualization based on various pre-defined metrics. The tool offers a user-friendly interactive way to update and analyze data. Generation of reports to PDF and power points have also been incorporated in the tool.
Multi-Channel Marketing Analytics: It involved finding the effectiveness of marketing campaign across various channels like email, calls and sample. Clustering was done on the HCP’s (Health care Professionals) at both product and market level and the key HCPs to be contacted were identified and marketing strategy was devised.

Work Terms

Flexible work hours. Please mail/message for details