Founded in 1983 the client is a privately owned mid-sized company located in Fort Worth, Texas. The company offers clinical software, business intelligence, specialty pharmacy, and more to individual and chain pharmacies across the United States.
For over 30 years more than 10,000 pharmacies all across the US use one or more of the client’s suite of on-premises and SaaS software and services.
To grow its service offerings, the client needed data and intelligence across its presence in pharmacies. It’s legacy, on-premise data warehouse could not analyze data from multiple pharmacies or an entire pharmacy chain. It could not scale to accommodate additional customers and had no ad-hoc query capability.
Processing large volumes of data would have required additional, expensive hardware. For example, it’s existing environment took a week to process 3 billion records — a task that should have completed within a fraction of that time.
The client wanted to better serve their customers, analyze the data, and provide real-time recommendations back to the pharmacies and decided to look for a solution.
The client set up a challenging timeline of six-weeks to come up with a proof-of-concept, a comprehensive comparison between various data warehouses, and a suitable data analytics platform.
Synerzip’s team working with the client evaluated Snowflake and Looker. The comparison included its legacy data warehouse provider, and Hortonworks’ Hadoop deployed on the Microsoft Azure cloud service.
The analysis conclusively determined Snowflake to be the way ahead in processing speeds and capacity for large files and records. The Hadoop ecosystem had a two-week head start. However, Snowflake caught up within a few days and was importing and analyzing data within a week. Working in parallel, Hadoop, and the client’s legacy teams spent at least three weeks getting those environments ready for data import and further analysis.
Snowflake was a clear winner across all three ecosystems used to collaborate, ingest, and process data in the shortest time frame.
For presenting the analysis, the team compared Looker to other popular data-visualization tools. Thanks to Snowflakes’ native integration with Looker, its efficient use of SQL, and avoidance of unnecessary joins, Looker achieved the desired query performance with a warehouse, half the footprint of that of others.
Additionally, Looker has an in-database application layer on which the client can grow Snowflake and Looker simultaneously. With Snowflake and Looker, a single interface allows for logging into accounts, defining new schemas and warehouses, and also permits to manage permissions. As a SaaS offering, the combination easily accommodates growth, and the client has minimal administrative chores. Data is always encrypted, at rest and in-transit.
The client now offers a BI platform capable of running enterprise-level reports for its customers.
Within three years, this BI platform now hosts data for six pharmacy chains, ingests up to 20 billion records daily in less than an hour, and offers the option of running near real-time data loads.
Pharmacies are able to make better decisions with the following key reports that can now be generated with ease.
- Fiscal year based Sales reporting including Trailing Twelve Months, This Year – Last Year analysis, etc. across all the pharmacies in a chain
- Third-party related reporting
- Medication Adherence Scores’ computation
- Manufacturer reporting
- Inventory management and theft detection
- Increase in pharmacies efficiency by monitoring prescription fill time, time spent at various stages of a prescription, etc.
- Drug cost monitoring and predictions
- Inadequately reimbursed insurance claims
Synerzip’s team successfully implemented the solution that now allows the client to offer its customers,
- Access to pharmacy data that makes sense in their business context. For e.g. reports such as below-cost dispensing, visibility into prescription referrals, controlled substance dispensing summary, etc.
- Ability to quickly access and analyze their prescription data
- Actionable growth ideas through retrospective, near real-time, and predictive analytics
- Ability to provide a source of accurate data and creation of reports and tools for both internal use and external Rx service vendors
- Faster and regular visibility to the various factors that impact their pharmacy business
- Unparalleled speed, scalability, and reliability to gain insight into data that leads to immediate action
- Utilizing the tool’s data-gathering capabilities for their contracted manufacturer’s reporting via the client’s advanced tool for gathering, organizing, and sending data to their data aggregators
“Synerzip team is very responsive & quick to adopt new technologies. Team naturally follows best practices, does peer reviews and delivers quality output, thus exceeding client expectations.”
“Synerzip’s agile processes & daily scrums were very valuable, made communication & time zone issues work out successfully.”
“Synerzip’s flexible and responsible team grew to be an extension to the StepOne team. Typical concerns of time zone issues did not exist with Synerzip team.”
“Synerzip worked in perfect textbook Agile fashion – releasing working demos every two weeks. Though aggressive schedules, Synerzip was able to deliver a working product in 90 days, which helped Zimbra stand by their commitment to their customers.”
“Outstanding product delivery and exceptional project management, comes from DNA of Synerzip.”
“Studer product has practically taken a 180% turn from what it was, before Synerzip came in. Synerzip cost is very reasonable as compared to the work they do.”
“Synerzip makes the timezone differences work FOR the customer, enabling a positive experience for us. ‘Seeing is believing’, so we decided to give it a shot and the project was very successful.”
“The Synerzip team seamlessly integrates with our team. We started seeing results within the first sprint. And due to the team’s responsiveness, we were able to get our product to the sales cycle within 7 months.”
“Product management team from Synerzip is exceptional and has a clear understanding of Studer’s needs. Synerzip team gives consistent performance and never misses a deadline.”
“Synerzip is different because of the quality of their leadership, efficient team and clearly set methodologies. Studer gets high level of confidence from Synerzip along with significant cost advantage of almost 50%”
“Synerzip’s hiring approach and practices are worth applauding. Working with Synerzip is like
“What you see is what you get”.”
“Synerzip has dedicated experts for every area. Synerzip helped Tangoe save a lot of cost, still giving a very high quality product.”
“Synerzip gives tremendous cost advantage in terms of hiring and growing the team to be productive verses a readymade team. Synerzip is one company that delivers “co –development” to the core!”
“Synerzip is a great company to work with. Good leadership and a warm, welcoming attitude of the team are additional plus points.”
“Our relationship with Synerzip is very collaborative, and they are our true partners as our values match with theirs.”
“Synerzip has proven to be a great software product co-development partner. It is a leader because of its great culture, its history, and its employee retention policies. ExamSoft’s clients are happy with the product, and that’s how ExamSoft measures that all is going well.”
“They possess a great technical acumen with a burning desire to solve problems. The team always takes the initiative and ownership in all the processes they follow. Synerzip has played a vital role in our scaling up and was a perfect partner in cost, efficiency, and schedules.”
“As we are a startup, things change on a weekly basis, but Synerzip team has been flexible in adapting the same”
“Synerzip team has been very proactive in building the best quality software, bringing in best practices, and cutting edge innovation for our company.”
“We’ve been working for more than six years with Synerzip and its one of the better, if not the best, experience I’ve had working with an outsourcing company.”
“My experience with Synerzip is that they have the talent. You throw a problem at them, and someone from that team helps to solve the issue.”
“The breadth and depth of technical abilities that Synerzip brings on the table and the UX work done by them for this project exceeded my expectations!”
“Synerzip UX designers very closely represent their counterparts in the US in terms of their practice, how they tackle problems, and how they evangelize the value of UX.”
“Synerzip team understood the requirements well and documented them to make sure they understood them rightly.”
“Synerzip is definitely not a typical offshore company. Synerzip team is incredibly communicative, agile, and delivers on its commitments.”
“Working with Synerzip helped us accelerate our roadmap in ways we never thought possible!”
“While working with Synerzip, I get a feeling of working with a huge community of resources, who can jump in with the skills as needed.”