Case Studies
Data Harmonization with Marketing Cloud Intelligence for Global Medical Device Company
Global Healthcare company present across 60 countries with over 14,000 employees across 260 companies. The leading manufacturer of life-changing breakthroughs over the last 13 decades, committed to delivering excellence through our reach and expertise. The organization strives for accessible healthcare with affordability to foster healthier communities.
With the mission to put a healthy mind, body, and environment within reach for everyone, the company blends heart, science, and ingenuity to profoundly change the trajectory of health for humanity.
Problem Statement
The company faced problems building reliable sales and sharing pipeline reports due to the following:
- Lack of Data Analysis resulting in misaligned quarterly regional and total OUS reports.
- Ineffective control of data sources resulting in VM.
- Lack of Global Data Governance.
- Creation of Multiple Sales Data Silos.
Solution
- AI-Enabled Marketing Cloud Intelligence.
- Data Harmonization.
- Centralized Repository for Real-time Analytics.
- Enriched User Experience.
- Multi-Currency Management and Automation.
- Interactive Dashboard for Regional and Country Reporting.
Benefits
- Single Source of truth eliminates reporting data discrepancies.
- Streamlined Data Management with greater control over data sources.
- Improved Data Accuracy with a Centralized Repository.
- Enhanced Data Visibility and Transparency across the enterprise for Global calls.
Daikin Achieves High-Level Modern Data Analytics Platform With Microsoft Azure
Daikin Industries Ltd. ($22.5 B in revenue) is a Japanese multinational air conditioning manufacturing company headquartered in Osaka with operations in Japan, China, Australia, the United States, India, Southeast Asia, Europe, the Middle East, Latin America, and Africa.
Daikin goes live with Microsoft Azure-Based Modern Data Analytics Platform to assist the Sales Forecasting and Planning system. Daikin facilitated a unique cloud D&A platform modernization powered by Microsoft Azure Tech stack with Oracle EBS.
Problem Statement
Daikin required Data & Analytics Modernization to create a cutting-edge sales and operations planning platform within nine months.
Key Project Highlights:
- Integrating data from multiple internal and external sources with 100 data integration points to create a data pipeline.
- Data Extraction from disparate external sources such as Oracle EBS, SQL Server, CSV/Excel, cloud databases, and Dodge Analytics.
- Deploying Azure Data platform with Power BI to create data visualization replacing the legacy excel based planning and forecasting system.
- Implementing a data lake with disparate data sources. Achieving key data insights, publishing reports, and dashboard presentations to empower Sales ops.
- Identifying and Deploying tools for data ingestion from disparate sources to establish a data lake.
- Building analytics model for extensive data to forecast and assist decision-making in sales and operations.
- Dashboard tools, Report Publishing, and Data Visualizations for Operational Stakeholders.
Key Business Benefits:
- Creating Data Warehouse for Accurate Reporting and Analysis.
- Integrated Sales & Operational Planning with Inventory for Automated Reports to Reduce IT costs.
- Configuration of Super Users (Roles and access) through Azure Rights Management to Visualize Data and Enhance Data Visibility throughout the Enterprise.
- Scalable and automated solutions deployment to enhance workflow efficiencies.
- Sales and Operational framework optimization to assist SiOP managers in saving up to 25% time and up to 10% reduction of time on data supply from stakeholders to key SIOP personnel.
- Team meeting cadence reduction from 15 to 7 days, with automated report delivery to avoid human intervention.
Birlasoft at Stryker
Modernizing field inventory management systems across various divisions
Birlasoft embarked on this multi-year EIM journey with Stryker in 2021 to modernize Field Inventory Management systems across various divisions by replacing legacy applications like Mobile Workforce and FIMS with completely inhouse custom built EIM product having both web and mobile capabilities.
The rollouts had to be in sync with the overall Accelerate roadmap.
Core Team
Birlasoft: Raj Gaurav, John Danese, Gurvinder Bains, John Fahy, Jawahar L
Stryker Team: Jason Tirri, Jeff Stull, Amanda Heller, Sharath Shanker
Where are we today ?
Live with SportsMed in April 2022 with 200+ active users
Currently in R5 Build Phase and about to start Discovery/Design phase for next release (R6)
Capabilities
- Global Product Mindset
- Digital Application Development
- Domain Expertise – Capabilities & Ongoing Process Maturity
- Supporting multi-release rollout plan utilizing global platform and common architecture
- Building the application using extendable web and mobile architecture with common code base to the vision of unified architecture across releases and reduces overhead
- Digital Application Development
- Leverage Core plus Flex model
Shoutouts
.jpg)
Risk mitigation plan to safeguard Stryker's legacy ERP systems
Capstone is a risk mitigation plan to safeguard Stryker legacy ERP systems during the multi-year rollout of SAP Accelerate. Different versions of QAD were used for operations in LATAM; existing QAD instances were due for upgrade in September 2020.
Brazil - QAD 2007 | Colombia - QAD 2010 | Argentina, Chile, Mexico, Export/PuertoRico/HQ - QAD eB2
Stryker decided to migrate the QAD instance to JDE 9.2 instead of upgrading it with a Vision is to build JDE 9.2 as a global instance. JD Edwards solution for LATAM would be hosted on a cloud platform.
Wave 1 or Pilot deployment – Brazil | Wave 2 – México, Argentina, Colombia, Puerto Rico and Chile
The Fiscal solutions must be compatible with both JDE and SAP to be flexible to migrate to SAP in the long run. Below we have the Roadmap for Stryker LATAM
Roadmap for Stryker LATAM
Wave 1 – Standing up a cloud based JDE solution (as vanilla as possible) and migrating LATAM QAD starting with Brazil, Go Live on July 2021.
Wave 2 – Migration of the rest of LATAM QAD to the new JDE cloud platform starting in Nov 2021. We completed this in three waves
- Wave 2A – Mexico went live on Nov 2021
- Wave 2B – Argentina, Columbia & Puerto Rico went live on Dec. 2021
- Wave 2C – Chile went live on April 2022
Key Benefits
Standardized Processes
- Alignment with Stryker Standard global processes – Design Phase encompassing all Countries
- Leveraging standard features/ functionalities of JDE, minimal customization
Enable
- Smooth transition to Future state
- Effective Training Approach
Statutory & Regulatory Compliance
- LATAM local, statutory, and regulatory requirements
- Operational and compliance requirements for LATAM countries
Right Team for Delivery
- Delivery Team with knowledge of Stryker Business Processes
- Right team with experience in LATAM countries localizations
Managing Future Growth
- Scalability and flexibility
- Integrate new modules / business processes
- Improved & enhanced analytical reporting
- Supporting M&As
Seamless Integrated Solution
- Seamless integrated solution of JDE, and Fiscal Solutions
- Integration with Dedicated Global Solutions already in place
Shoutouts
Team Behind
Amit
Samanta
Samanta
Program Director
Bernardo
Cantor
Cantor
Finance Consultant
Carina
Carranza
Carranza
OTC Consultant
Florence
Guevshenian
Guevshenian
Solution Architect
Francisco
Maggio
Maggio
Consultant
Liz
Acevedo
Acevedo
Solution Architect
Lizbeth
Roa
Roa
OTC Consultant
Luciano
Botta
Botta
Solution Architect
Luis
Hernandez
Hernandez
INV Consultant
Pamela
Scinica
Scinica
Solution Architect
Pilar
Niz
Niz
Solution Architect
Sandra
Malenky
Malenky
Data Conversion Lead
Tatiana
Echaide
Echaide
OTC Consultant
Wagner
Bonizzi
Bonizzi
JDE Consultant
Stryker successfully deploys a modern data analytics platform powered by Microsoft Azure in North America
An American multinational medical technologies company. A world leader in manufacturing innovative products and services for orthopedics, medical, surgical, and neurotechnology to improve patient care and hospital outcomes.
Problem Statement
Stryker required data analytics platform modernization for insightful data visualization and advanced analytics capabilities at an optimized cost.
Key Project Highlights:
- Deploying End-to-End Analytics Solutions powered by Azure Synapse and Power BI.
- Business logic rediscovery to match existing BI documentation.
- Diagnosing bug issues in the legacy BI system and Resolving them through the New BI system.
- Creating a reliable, scalable, and data-intensive sales analytics solution for global use.
- Data Integration and Transformation for Enhanced Report Interface.
- Optimizing service management with customized security implementation for enhanced business performance.
Key Business Benefits:
- High scalability and Sales & Pricing data availability through the BI system, reducing data load dependency on other components.
- ETL management is optimized by shifting business dependency from the legacy BI systems and reducing human interventions by lowering legacy ETL jobs.
- Modernized data analytics platform and improved BI service facilitate Quicker time to market for new regions.
- Data security heightened through Robust data framework across the Enterprise.
- Improved efficiency and cost reduction achieved through automation.
- Improved data visibility and control across business entities enhance data governance.
- Effective error and exception handling mitigate data discrepancies.
- Data standardization across the Enterprise with functional testing enables best user practices for reports and dashboards.
Modernizing a future ready, scalable architecture with standardized reports & KPI’s
Core Team
Amit Khanchandani, Nitesh Chavan, Nikhil Agarwal, Sumit Ahuja
Purpose
The legacy system replacement with Artemis and building Athena Ortho Reporting Systems to better serve our customers – the sales and marketing teams in the United States.
- Artemis Phase1 serves the purpose to deliver sales and orders BI solutions.
- Artemis Phase2 serves the purpose to deliver finance and inventory BI Solutions.
- Athena Ortho Reporting: Athena is a sales and marketing analytics benchmark for Stryker. The Athena Ortho has been built on top of Artemis.
Key Highlights
- Artemis phase 1 & 2 went LIVE in October’ 2022.
- Artemis go-live & one source decommissioning communications has been shared with all stakeholders.
Challenges
- On-premises Oracle platform with multiple reporting platforms comprising of Individual data models/ tables/ schemas with siloed reporting.
- Code and platform maintenance challenges due to multiple teams/ technologies involved.
- Performance issues with limited scalability & high cost of ownership
- Lack of support for advanced analytics.
The core team is continuing to work on Athena International Design and build to rollout to regions/countries including EMEAA, Russia, Canada, and Japan towards the vision of international approach for upcoming releases.
New Team Members
Our Mexico Delivery Centre is in Full Operation
Clients Being Serviced from the Center
Insights
Latest News
