Case Studies
Cycle Time and Yield Improvement Dashboard
Our team built an analytical model to analyze yield and cycle-time for a major biotech company for their products, resulting in more than 20 Million USD ROI for the client in a year.
Business Problem Addressed: This company makes 100s of Pharma products across 19 manufacturing sites, using 7 SAP systems, 4 MES systems and many home grown Quality systems. They needed a DataWarehouse as single source of truth to manage cycle time and yield metrics
Technology Stack: Google Cloud Storage, Data Flow, Cloud Composer (Apache Airflow) , DataPrep and DataFusion, Big Query, and Tableau
Sales Dashboard and Analytics
Sales forecasting of their high-cost equipment by-product by sales area so that they could position products well.
Business Problem Addressed: The company had problems forecasting sales, managing product promotions and having a single place to manage KPIs.
Technology Stack: Google Cloud Storage, Data Flow, Apache Airflow, Big Query, and Tableau, BiQueryML for machine learning forecasts.
CloudKarya team built the delivery of the solution, they Architected the solution, hand-coded the prototype to get customer buy-in.
PoAE: Prevention of Adversarial Events
CloudKarya consultants built a forecasting model for oil well production cessation. This model we built is used in predicting likely failures, and suggest preventive maintenance to avoid downtime.
Business Problem Addressed: The company needed a forecasting method to plan predictive maintenance on the Oil Wells using past data.
Technology Stack: Google Cloud Storage, DataFlow, Big Query, TensorFlow and scikit learn for machine learning forecasts. in.