Andrew Phillips-Guzman

• Lead PM of over 30 different pharmaceutical data-driven contracts at Aetna Specialty Pharmacy that
contributed to rebate revenue in the amount of $7 million annually.
• Responsible for the procurement, planning, executing, and closing of complex projects that safely
delivered millions of HIPAA compliant EHR patient data records through secure encrypted and
tokenized channels to external HUBs, data aggregators, and pharmaceutical partners.
• Oversaw REMs, adverse events, and patient safety compliant projects to align with FDA regulations.
• Worked on the migration of our Oracle BI API responsible for patient, claims, and clinical operational
data to a vendor’s web based clinical assessment application.
• Lead PM of the conversion of contractual reporting obligations from one system to another when
ASRx migrated Oracle BI clinical assessment functionality to a vendors clinical assessment application.
• Developed and participated in presentation and consultation to existing and prospective customers,
business partners and internal business areas on information services, capabilities, and performance
results.
• Oversaw high-value projects with large numbers of stakeholders; Worked with advisers from key
functional areas to understand potential project impact on the organization, align project work, and
execute activities accordingly.
• Program Manager to multiple projects coordinating all program documents with project
interdependencies, ensuring that they align; managing both resources and communications across all
projects with their stakeholders.
• Proactively evaluated project activities, built contingency plans, executed corrective action, and
monitored issue resolution to mitigate risks such as scope and/or budget variances; Negotiated
resources in peer organizations to meet high priority department objectives.
• Influenced change or enhancements to business processes, policies and system infrastructure to
improve information quality, availability and access.

• Performed analyses to assist with the translation of business needs into Business Requirements and
Functional Specifications documentation.

• Gathered requirements, created user stories, and performed test scripts.
• Applied specific functional and/or business expertise to perform assigned tasks and develop specific
project deliverables, and business workflow diagrams.
• Documented, tracked, and resolved issues related to data quality.
• Tracked initial requests and maintains status reports.
• Generated daily/weekly/quarterly/monthly reports, and created SQL queries.

• Worked under a senior executive of a 720 provider multi-specialty, 180 location, hospital-owned group
practice operating in 4 counties in Central FL.
• Complied and created analyses of financial, operation, and benefit records for project utilization.
• Technical writing, presentation, and analysis of hospitalist staffing, volume, charges, and payer mix.
• Database creation, management, and market analysis of provider metrics for multiple regions.