Chirag Patel
Randolph,USA
Summary
Dynamic Senior Manager at Community Pharmacy Cooperative, leveraging data modeling and operational efficiency to drive analytics strategy and enhance clinical outcomes. Proven track record in optimizing 340B programs and developing impactful dashboards. Passionate about advancing health equity and fostering collaboration across teams to achieve strategic goals.
Overview
12
12
years of professional experience
1
1
Certification
Work History
Senior Manager, Pharmacy Data & Analytics
Community Pharmacy Cooperative (CPC)
Boston, MA
06.2025 - Current
- Driving enterprise-wide analytics strategy and business intelligence operations across CPC’s network of Federally Qualified Health Centers (FQHCs), with a focus on pharmacy innovation, equity, and performance.
- Strategic Leadership: Architecting scalable data infrastructure and analytics frameworks that align with CPC’s strategic goals, optimize 340B program performance, and enhance clinical outcomes reporting.
- Dashboard Automation: Spearheading development of dynamic pharmacy performance dashboards (Power BI, SQL) to support operational efficiency, clinical pharmacy services, and financial KPIs across multiple FQHCs.
- 340B Program Optimization: Managing and expanding CPC’s 340B data ecosystem to ensure compliance, maximize savings, and improve health outcomes for covered entities.
- Cross-Functional Analytics: Delivering integrated analytics for ACO and Pharmacy Benefit Management programs, aligning insights with quality metrics, patient impact, and regulatory standards.
- Executive Collaboration: Partnering with clinical and executive leadership to define success metrics and deliver actionable insights that inform strategic planning and clinical decision-making.
- BI Modernization: Leading CPC’s business intelligence transformation by evaluating and implementing tools that ensure secure, accessible, and user-friendly data delivery.
- Operational Excellence: Overseeing a team of analysts, establishing SOPs, and enforcing HIPAA-compliant data practices across pharmacy data systems.
- Equity-Focused Impact: Advancing health equity through data-driven insights, supporting underserved populations in community-based healthcare settings.
Research Data Engineer
Harvard Business School
Boston, MA
05.2023 - 06.2025
- Autonomously provided advanced analytical and operational support for reporting and analytic systems, ensuring accuracy and efficiency in data-driven decision-making processes.
- Generated both standard and ad-hoc reports for diverse departments, managers, and faculty, delivering comprehensive insights and support for informed decision-making.
- Managed the coordination of sampling and analysis tasks, ensuring meticulous verification of finished products' quality.
- Expertly navigated and managed 40 terabytes of claims data stored in a relational database, employing extensive SQL skills and various data extraction and manipulation tools to ensure data accuracy and accessibility.
- Assumed the role of subject matter expert on the entire data source, providing consultative support and guidance to researchers to optimize their work with the data.
- Conducted detailed examinations of metadata and indexes, recommending and implementing indexing improvements to facilitate efficient data utilization. Collaborated with faculty and researchers to understand their workflow and specific data needs to support their research.
- Developed complex SQL queries, functions, procedures, views, and materialized files, supporting faculty researchers who work with R, Stata, and Python, thereby enhancing their research capabilities.
- Monitored and optimized data queries and extraction techniques to ensure optimal performance, leveraging insights to improve data access and analysis.
- Contributed to the definition, configuration, and workflow improvements, facilitating remote execution of queries and procedures. Collaborated on the design and maintenance of potentially massive databases, ensuring seamless connectivity and access.
- Adhered to and upheld Harvard University IT technical standards, policies, and Code of Conduct, ensuring the integrity and security of all data and processes.
- Designed and produced reports tailored to diverse business needs, resolving data discrepancies and ensuring alignment between the data warehouse and systems.
- Collaborated on developmental work related to applications, reports, and databases, contributing insights on table structures and entry screens while collaborating closely with application developers to enhance functionality.
- Implemented robust best practices for data security and access control, ensuring compliance and managing user roles and privileges effectively.
Data Development Lead
Beth Israel Deaconess Medical Center
Boston, MA
01.2018 - 06.2024
- Oversaw the comprehensive in-house 340B program, ensuring strict adherence to compliance requirements for qualified patients, drugs, providers, vendors, payers, and locations. Spearheaded audits and checks to ensure the program's integrity and compliance with established standards.
- Led cross-functional development teams in creating robust system infrastructures, establishing data interfaces, and fostering functional relationships within applications, ensuring seamless integration and optimal performance.
- Assumed responsibility for generating and maintaining pharmacy reports and dashboards, crucial for both operational and regulatory needs. These tools tracked multidimensional performance against divisional or departmental objectives, providing actionable insights.
- Collaborated closely with the Director of Pharmacy Data Analytics, supporting the team's requirements, from ad-hoc projects to publications, while guaranteeing data integrity, validation, and the necessary safeguards.
- Applied expertise in standardization and best practices as the internal data warehouse evolved, ensuring that evolving data storage and retrieval methods aligned with industry standards and organizational needs.
- Designed and executed analyses from the data warehouse, utilizing SQL, Python, and other technologies to extract insights from patient-level or similar datasets, contributing to informed decision-making.
- Aided in contract compliance and identified opportunities for cost savings, effectively communicating findings to the Pharmacy Manager and inventory Buyer, facilitating the implementation of feasible changes.
- Maintained meticulous documentation concerning routine operational analytics and data sources, fostering cross-coverage and creating visual aids for enhanced comprehension among peers.
- Participated actively in improvement initiatives, leveraging data extracts to identify areas for enhancement, leading to improved patient satisfaction, organizational growth, and increased net revenue.
- Conducted a comprehensive analysis of company training methods, implementing adjustments to rectify issues, increase efficiency, and surpass training goals, thereby improving overall workforce performance and efficiency.
Certified Pharmacy Technician
CVS Pharmacy
10.2013 - 05.2019
- Managed a high volume of incoming calls, skillfully addressing inquiries from both customers and healthcare providers, ensuring prompt and accurate responses. Displayed a commitment to exceptional service quality and efficiency in all interactions.
- Executed diverse operational tasks within the pharmacy, consistently upholding a commitment to precision, efficiency, and service excellence, ensuring seamless workflow and adherence to established protocols.
- Maintained meticulous records by accurately recording and filing physician's orders and prescriptions, contributing to streamlined documentation and compliance with regulatory standards.
- Engaged in effective collaboration with insurance company representatives to facilitate smooth claims processing, actively resolving concerns and reconciling payments. Ensured comprehensive communication and resolution of any issues.
- Played a pivotal role in patient care by liaising directly with individuals to gather essential information regarding prescriptions and medical conditions, facilitating consultations with pharmacists when necessary.
- Exemplified adherence to stringent drug storage procedures and records for controlled substances, ensuring compliance with regulatory standards and maintaining accurate registries for seamless drug management.
- Delivered comprehensive customer support both in person and over the phone, skillfully navigating systems, assisting in order placements, and providing guidance to customers, thereby resolving their concerns effectively and ensuring a positive customer experience.
Specialty Pharmacy Liaison
Boston Medical Center
Boston, MA
05.2016 - 01.2019
- Innovated and executed pilot programs, notably including medication refill centers and adherence programs, designed specifically to enhance the overall health outcomes of internal medicine patients. These initiatives were meticulously developed to streamline medication processes and improve patient compliance.
- Conducted comprehensive medication histories through collaborative efforts involving patients, their families, pharmacies, and various healthcare providers. This approach ensured accurate, up-to-date medication records.
- Established and maintained a current and accurate list of active medications, cross-referencing them with clinician notes for precision. Upon determining the appropriateness of medication refill, facilitated seamless communication with Pharmacists or Medical Providers for necessary approval.
- Proficiently utilized a suite of advanced platforms including EPIC, Salesforce Health Cloud, NRX-QS1, and Lexicon. Leveraging these tools, meticulously referenced, tracked, and documented pertinent information in patient profiles for precise and comprehensive record-keeping.
- Designed and implemented in-house systems tailored specifically for managing specialty medications. These systems documented and streamlined the refill procedures, ensuring meticulous adherence to protocols.
- Established effective liaison with other pharmacies, proactively mitigating issues related to product expiration to maintain a seamless medication supply chain for patient welfare.
- Effectively resolved diverse challenges, including third-party billing, computer system discrepancies, and customer service issues, ensuring uninterrupted operational efficiency in medication management systems.
Education
Master of Science - Health Informatics
Boston University
Boston, MA01.2020
Bachelor of Science - Biochemistry and Molecular Biology
University of Massachusetts Amherst
Amherst, MA01.2013
Skills
- Active Learning
- Agile Framework
- Understanding Business Intelligence
- Data Modeling
- Data Profiling
- Database Management
- Operational Efficiency
- Process Development
- Technical Reporting
- Quality Control
Certification
- Massachusetts Pharmacy Technician License
- National Certified Pharmacy Technician
- Business Essentials Accelerator
- Learning @ Morning Brew
References
References available upon request.
Publications
- Evaluation of the Safety and Potential Time-Savings of Subcutaneous Rituximab Administration in a Single Cancer Center, JHOP, 02/01/22, 12, 1
- Adherence to oral oncolytics filled through an internal health-system specialty pharmacy compared with external specialty pharmacies, J Manag Care Spec Pharm, 10/01/21, 27, 10
Timeline
Senior Manager, Pharmacy Data & Analytics
Community Pharmacy Cooperative (CPC)
06.2025 - Current
Research Data Engineer
Harvard Business School
05.2023 - 06.2025
Data Development Lead
Beth Israel Deaconess Medical Center
01.2018 - 06.2024
Specialty Pharmacy Liaison
Boston Medical Center
05.2016 - 01.2019
Certified Pharmacy Technician
CVS Pharmacy
10.2013 - 05.2019
Master of Science - Health Informatics
Boston University
Bachelor of Science - Biochemistry and Molecular Biology
University of Massachusetts Amherst