Raj Shah
Somerset,NJ
Summary
Results-driven Analytics Manager with 8 years of experience in data strategy, omnichannel integration, and business intelligence. Proven track record of driving multimillion-dollar revenue growth, enhancing operational efficiency, and optimizing workforce allocation through data insights and innovative solutions. Expertise in leading cross-functional teams to implement scalable data infrastructure and performance metrics aligned with business objectives. Skilled in leveraging advanced analytics tools such as Tableau, Alteryx, and Power BI to deliver actionable insights. Strong communicator with talent for building productive relationships and influencing stakeholders across all levels.
Overview
8
8
years of professional experience
1
1
Certification
Work History
Data Strategy & Analytics Manager
CVS Health
11.2022 - Current
- Location: Remote
- Designed labor optimization models resulting in 1.2M fewer calls routed to pharmacy teams annually, improving operational efficiency
- Transitioned patient communication channels across 9,000+ locations, reducing pharmacy call volume by 1.1M annually to enhanced customer engagement
- Forecasted pharmacy labor needs, optimizing workforce allocation and addressing a $7B annual labor spend across over 20,000 locations
- Spearheaded digital pharmacy transformation initiatives projected to deliver $400M in margin growth by 2025
- Led A/B testing pilots by creating test groups through hash algorithms, targeting key KPIs to validate pilot success
- Created Tableau dashboards and partnered with data engineering teams to simplify performance views, reducing SQL query complexity
- Spearheaded strategic data and analytics initiatives, transforming CVS Pharmacy's digital assets to enhance customer engagement
- Collaborated with teams, including IT, Digital Lean, and Pharmacy Operations to align data strategy and enhance digital pharmacy services
- Executed dashboards to monitor chatbot and live agent performance, customer interactions, and adherence metrics
Sr. Business Analyst - Enterprise Workforce Management Insights (Contract)
CVS Health
02.2022 - 11.2022
- Location: Remote
- Constructed a pharmacy health dashboard in Tableau to visualize pharmacy business health, labor models, and areas requiring exploration
- Delivered critical data insights, influenced broader Enterprise Workforce Management strategies within the Retail division
- Collaborated with the Enterprise Workforce Management Team to forecast pharmacy labor needs, optimizing labor spend and improving resource allocation
Senior Analyst, Medical Cost Management (Medicare Advantage)
Oscar Health
New York, NY
06.2021 - 02.2022
- Location: New York, NY
- Directed discussions with leadership during monthly meetings, presenting reports on market performance and cost management
- Streamlined and transformed multiple Excel reports by converting Periscope & Looker Dashboard views, reducing manual efforts by 6 hours
- Served as liaison data engineering team and business users, ensuring data loads into BigQuery tables
- Coordinated meetings for Oscar Health and vendors to identify and address gaps, minimizing errors in ETL processes
- Constructed reports on Cost Management and Value-Based Care initiatives for Medicare Advantage, and enhanced healthcare outcomes
Business Analytics Lead Analyst
Evernorth
Franklin Lakes, NJ
05.2020 - 06.2021
- Location: Franklin Lakes, NJ
- Served as SME for two products, delivering critical insights for reports and prospective models
- Collaborated with third-party vendors and internal departments within the healthcare data group model reporting service
- Automated data extraction and aggregation by developing Alteryx workflows, reducing query execution time by 35 minutes per query
- Managed client-specific prospective models and algorithms, identifying key trends and patterns to maximize savings guarantees
- Designed complex SQL queries to analyze billion-row datasets, ensuring data accuracy for strategic planning
- Applied hands-on expertise in creating data visualizations and analytics, leveraging Tableau Desktop & Server for actionable insights
- Delivered 10 dashboards, enabling internal teams to produce custom client-specific reports and executive PowerPoint presentations
- Led project teams, identifying training needs and conducting sessions to enhance team productivity
IT Administrator
Reddy Raw
Wood-Ridge, NJ
03.2017 - 07.2019
- Location: Wood-Ridge, NJ
- Developed custom SQL queries on MySQL server to generate detailed Microsoft Power BI dashboards and standardized ad-hoc sales and purchasing reports across multiple departments
- Led hardware and software internal systems, collaborating with various vendors, and providing technical support to local and remote users
- Improved document management and recovery processes by 90% by overseeing the creation of a centralized electronic repository system
- Saved the company over $31K annually by designing in-house automated ad-hoc reporting services and dashboards for the sales departments
- Identified technical issues through root cause analysis, delivering targeted system solutions
Education
Bachelor of Science - Computer Science
Fairleigh Dickinson University
01.2012
Skills
- Python
- SQL
- VBA
- HTML
- CSS
- JavaScript
- MySQL
- PostgreSQL
- MongoDB
- Teradata
- Google Cloud
- Snowflake
- MS Office
- Visio
- SharePoint
- MS Project
- Jupyter Notebook
- RStudio
- Tableau
- Alteryx
- MS Power BI
- Looker
- BigQuery
Careeraccomplishments
- Results-driven Analytics Manager with 8 years of experience in data strategy, omnichannel integration, and business intelligence.
- Proven track record of driving multimillion-dollar revenue growth, enhancing operational efficiency, and optimizing workforce allocation through data insights and innovative solutions.
- Expertise in leading cross-functional teams to implement scalable data infrastructure and performance metrics aligned with business objectives.
- Skilled in leveraging advanced analytics tools such as Tableau, Alteryx, and Power BI to deliver actionable insights.
- Strong communicator with talent for building productive relationships and influencing stakeholders across all levels.
Certification
- Python for Data Science and AI, Coursera
- Data Science Boot Camp Certificate, Rutgers State University, Jersey City, NJ, 2019
- Certified Data Visualization Developer, Evernorth, Franklin Lakes, NJ, 2019
- Python for Data Science and AI, IBM, 2019
- Data Science Methodology, IBM, 2019
- Open-Source Tools for Data Science, IBM, 2018
- What is Data Science?, IBM, 2018
Websites
linkedin.com/in/rkshah7255/
Timeline
Data Strategy & Analytics Manager
CVS Health
11.2022 - Current
Sr. Business Analyst - Enterprise Workforce Management Insights (Contract)
CVS Health
02.2022 - 11.2022
Senior Analyst, Medical Cost Management (Medicare Advantage)
Oscar Health
06.2021 - 02.2022
Business Analytics Lead Analyst
Evernorth
05.2020 - 06.2021
IT Administrator
Reddy Raw
03.2017 - 07.2019
Bachelor of Science - Computer Science
Fairleigh Dickinson University