Paul LoSacco, Pagoda Consulting Group

Transforming LTC Pharmacy Operations Through Technology

With 45 years of IT experience—including 33 years dedicated to long-term care (LTC) pharmacy software—I bring deep technical expertise and business leadership insight to your IT needs. Having served in company leadership roles, I understand the full spectrum of pharmacy operations, from planning and strategy to finance and project management.My strength lies in partnering with pharmacy operations leaders to uncover business challenges and shape technology solutions that drive efficiency and growth. I then bridge the gap between vision and execution by developing software solutions or by guiding your software development teams with the technical direction and expertise they need to deliver results.Whether your goal is modernizing systems, improving workflows, or launching new technology initiatives, I can help you align your business needs with the right solutions.

Technical & Domain Expertise

Expertise with FrameworkLTC® from SoftWriters and other pharmacy dispensing systemsSQL database coding, including developing stored procedures and providing reports in Excel and SSRSPharmacy system interfaces to adjunct products such as dispensing machines, delivery applications and data servicesElectronic prescribing and related standards (HL7 and NCPDP SCRIPT)Data warehouse design, including ETL process designSharePoint site design and administrationITIL certifications in IT Service Management and Intermediate Service DesignSoftware architecture and design, including web-based applications and mobile appsUser experience definition and designApplication integration design and strategy

Leadership & Strategic Skills

Requirements gathering, documentation and business sponsor buy-inDirecting in-house or third-party development effortsProject managementChange management, including Change Advisory Board (CAB) and Change Control Board (CCB) practices and standardsProduct management of customer-facing web portals and mobile appsQuality assurance testing oversightEvaluating new technologiesImplementing IT best practices and standards

A Sampling of Recent Work

We've done these things for others. What can we do for you?

  • Inventory report in Excel to show current and prior AWP and WAC prices for any inventory items matching the input criteria

  • Prior day order alert for critical customers that sends an email summary twice daily with orders received the prior day and current workflow status

  • Custom interface between an external partner and Framework to add patients and orders using FwHL7 and FwDirect from a proprietary data format

  • Possible early fill in open batch alert; sends email to pharmacy team if a potential early fill is detected that exceeds a facility cost threshold

  • Active partial tab orders report

  • Facility invoice detail report in Excel with feature to export results to a file to sent to the customer

  • Enhanced a custom-built customer portal with reports that source data from a non-Framework pharmacy system

  • Assistance with data center consolidation tasks, including Framework data pulls

  • Find all dispenses in the date range and do a margin analysis by payor type, brand/generic or top/bottom 250 GPIs

  • Export claim data to provide to SPS Health

  • Facility bill summary reports in both Excel and SSRS

  • Facility census checker in Excel that imports EMR data, queries Framework and compares facility census information

  • Open AR aging report pulled from Sage data

  • Mobile app requirements gathering and design/build options analysis with costing

  • Find all inventory items that have an AWP override

  • "Unlocking Business Intelligence for Strategic Success" presentation for senior management

  • Duplicate GPI in open batch alert; sends email to pharmacy team if a potential duplicate order is detected

  • Find all open batch orders that were electronically rejected and the MOP2 represents a cost-share plan

Introducing Pharmacy Data Explorer for quick access to your FrameworkLTC® data

In today’s fast-paced long-term care pharmacy environment, quick access to accurate information is essential. That’s why we’re excited to introduce Pharmacy Data Explorer, a powerful web-based tool that makes it easy for your team to access and explore FrameworkLTC® data in real time.Designed to simplify daily operations, Pharmacy Data Explorer empowers pharmacy staff with faster insights, greater efficiency, and the information they need—right when they need it.

Paul LoSacco, Pagoda Consulting Group

Let's Talk

Reach out and let's discuss how Pagoda Consulting Group can help your pharmacy achieve their goals.