Welcome



Pacific Technology Solutions, Inc has over 30 years of data technology expertise in delivering Business Intelligence solutions. We are data professionals that use technology to make sense out of your data.  Our process to tie your data together will help you make prudent decisions from powerful insights whether you use cloud analytics or on premise.
 
We are data whisperers.

Mission / Vision

Our mission is to provide you with high quality and cost-effective data solutions.

We listen. We understand. We work with you every step of the way.

Pacific Technology Solutions, Inc delivers what we promise and continually strive to pursue better solutions, better processes and better technologies as these become available. We have clients in Healthcare, Higher Education, Banking and Financial, Insurance, Entertainment, Hotel and Casino & Gaming, Retail, Transportation, Telecommunication, Network Manufacturing and Configuration, Professional Services, and a lot more.   





Please call (310)990-8252 or email info@ptsi-ca.com for further information.

Overwhelmed?

Learn how you can build a custom Data Warehouse and Business Intelligence Solution that meets your needs. We help you understand your data so you can make trusted decisions, assess your day-to-day operations via Dashboards and Scorecards, develop strategies such as market penetration, negotiate better contracts, develop performance matrix, evaluate demographics, and many more. Understanding your data is power. Let us be your technology partner and we will work with you to transform your data and deliver easy to understand reports so you can make confident decisions.


Visualize your data

Data are your assets and navigating through layers of data can be complex and very frustrating.  We have tools and expertise to help you visualize your data.  Power BI, Tableau, QLIK, Excel and other tools are available for you to use whether your data reside on premise or hosted in the cloud.  Let us show you how! 

Cloud Analytics

Thinking of migrating to the cloud?  Your investments for on premise data warehouse can be leveraged with hosting analytics in the cloud.  We have successfully migrated analytics to the cloud either all in or hybrid.  AWS, Azure, and other less known players are available to meet your expectations and budget considerations. We have implemented Data Lakehouse on Databricks and Data Lake / Data Warehouse on Snowflake.

We have worked with large healthcare organizations to modernize data analytics.  The opportunities in migrating legacy databases to Snowflake and Databricks have been endless.  We share the journey of providing better patient care by delivering world class analytics on cloud.

Traditional data warehouse approaches are starting to drag business decisions.  We can work with your IT Department to find a balance of faster to market yet meeting security and compliance protocols.  Business questions need to be answered immediately and not a year from now.  Competition in monetizing data to increase your top line or improve operating costs is prevalent in every industry.  Companies who make prudent decisions with insights from accurate data will survive and grow in the unforeseeable future.  We're here to help make those decisions faster and if needed we can architect almost real time analytics when possible.

Even hosted applications on the cloud such as Salesforce, Workday, Service Now, and ADP to name a few have presence in most successful organizations.  Microsoft Office?  If you have Office 365 your company provides installed Microsoft Office applications on your desktop or laptop computers and most companies allow use of Microsoft Office on the cloud using a browser and save enterprise data on the cloud.  Google was a pioneer of cloud office applications with Google Suite for the enterprise or small business.  Google Docs, Sheets, and Slides all work in google cloud securely.

We are agnostic in choosing technology.  We work with your current licenses or we can help you decide which toolsets and cloud vendors work best for your organization. POC, vendor selection, and contract negotiations could be inundating and we've been helping our customers and partners succeed with decisions for success. Some of the most commonly used analytics tools available such as Power BI, QLIK, Tableau and many others have very confusing features as they all compete for your business.  We'll help identify which products best suit your organization from working with your users, stakeholders, decision makers, and compliance guidance.

Let's start a discussion and we can initiate your journey to cloud analytics!


Healthcare

Our clients expect accurate healthcare data. We have processes in place to make sure your reporting data are the same from your EMR, EHR, and other sources of patient data. You may also have different systems of records for your patients like Epic, Allscripts, IDX, Cerner and others by virtue of changing vendors or having more than one system to have the best hybrid system to meet your needs. Data can be complex and we can help you tie your systems together. We provide services and tools to help you analyze trends, mine data, and provide meaningful insights with all of your data sets.
 
We have been data mining claims, encounters, ADT, physician notes and any data available to analyze population health for kidney care, chronic heart disease, cancer, diabetes and provide analytics for better outcomes.  Some of our health plan clients have significantly reduced expenses by working with the members' medical team and providing insights about members' conditions through integration of data from different providers, organizations, and carriers.

Forecasting your data is very time consuming. We can assist you with census, labor, operating expenses and come up with models to predict monthly, quarterly, yearly EBITDA as an example. Medicare rates may change and we can accommodate “what if” scenarios in our models to help you plan for any upcoming changes from reimbursement. Labor $ are not static and we can provide some tools to assist managing labor on holidays, weekends, OT, and other events that impact your cost.

Data exist everywhere - on site, cloud, Excel, and other databases or documents. We provide services to integrate all of your data securely and work with your processes to consume your data. We are agnostic in reporting tools and we have expertise in Tableau, Power BI, QLIK, Microstrategy, Cognos, Excel, and many more.

Education

PTSI helped educational institutions manage all their data and information, allowing easy access to the most current developments within their sphere. We provided front and back-end support to organize and streamline operations and finances. 

University of Southern CA
We designed, developed and implemented an Enterprise Data Warehouse with operational and ad hoc reporting for GL, PCard, Contracts and Grants, AP, Purchasing, Asset Management, HR, Payroll, and academic analysis.  With 10,000 users on Cognos, the entire University had access to data needed to manage every school.

Orange County Dept of Education
We designed and developed an Enterprise Data Warehouse for the district to manage expenses including labor contract negotiations.  We helped expedite financial decisions by having data and analytics processed everyday which included historical and current data from GL, Budget, and Payroll.

 

Global Data and Analytics Solution



We were part of a team that built 2 of the world’s largest data warehouse. Privacy and security were paramount from day 1 and this was a time before GDPR and privacy laws took effect. Every country or territory had different guidelines on handling consumer data. We designed and built secure architecture in infrastructure, software, and business processes to make sure users in different parts of the world only view data they have privileges to. Even database and system administrators are not able to see all data.

Privacy and security are not challenges to getting data and providing better insights to management. Our processes protect consumer data and yet allow organizations to get insights, improve top and bottom lines, and make prudent business decisions without compromising privacy. 

Our global analytic solutions include on premise or cloud. We can pull and integrate data from various databases, different file formats, cloud or hosted service providers and visualize stories in Tableau, Power BI, QLIK, Excel and many more.




 

9/2024. We're starting a Data Warehouse project with New England Life Care, a non profit home infusion provider. 

6/2024. We have recently designed a Medallion Data Architecture on Databricks with Healthmap Solutions. Our architecture was a foundation for mining chronic kidney care from claims data.  It was a complex and extensive process to rank patients on the different stages of kidney care by looking at all the diagnoses, procedures, labs, pharmacy, and admission data.

4/2024. We have completed our project with Rezolut to design and build an enterprise data warehouse on Azure.  The company is growing through acquisitions and our design accommodated future growth and new data assets that can be integrated into the data warehouse.  

1/2024. We have been working with CareConnect MD to provide better data insights to high risk Medicare members.  Our architecture on Snowflake included EMR/EHR, Salesforce, and CMS data all tied together.  Patient Outcomes improved through integrated data analytics. 

6/2023. It's been almost a year of working with CareOregon to migrate on prem EDW and build a modern data architecture on Snowflake.  We're proud to accomplish a new architecture that will help the organization service Medicaid patients.