Location Northbrook, IL
Processing large volume of claims, prescribers and drug-based information for performing retail opportunity/expansion analysis for CVS pharmacies all over United States using tools like SQL.
Creating ETL end-end data pipelines from extraction to transformation to data validation and finally performing ad-hoc data analysis as per stakeholder's request.
Using R/Python programming language for performing statistical analysis specifically price sensitivity analysis and predictive modelling/machine learning to determine how different input costs and other parameters will help us classify the data into different pricing models and make recommendation to business for making more insightful decisions.
Working on Identifying KPI'S and business cases for Retail Specialty to track the performance of the project and suggest steps that can be taken to forecast better growth for the project.
Creating and presenting the results for the stakeholders by creating large scale data visualization and dashboards using Tableau for communicating results to technical as well as non-technical audience.
Training and working with new analysts in the team and making sure that they understand the process and help them in conducting day to day data analysis requests.
Tools Used: SQL, Teradata, Tableau, R, Python, SAS