ABOUT CUSTOMER
A leading supplier of Anti-Vibration Components and Encapsulated Glass Systems to Automotive Industry.​​
CHALLENGES
- Home-Grown Access-Based Productivity Tool built to streamline planning was stored in Network Shared Drive to give access to users across North America, Europe and China. ​
- Purpose-build silo application - not a scalable architecture to build new features & applications. ​
- Manual Sync across Access DB for each region.​
- Labor-intensive report generation – 2 days to generate report from 3 different databases.​
- No integration with Active Directory for Identity Management.​
- Integrity Issues due to lack of direct validation against source/master data.​
- Lack of Auditing & Change Management features. ​
- Manual processes for back-up & restore. ​​
SOLUTION
Phase - 1:
- Cloud solution built using modern Microsoft Azure cloud technologies and React based responsive web application that is truly global with multi-lingual capability.​
- Multi-form-factor Responsive Design for consistent user experience across devices.​
- Import and map input IHS data and validate data against source of truth.​
- Multi-Lingual (3 languages).​
- Active Directory Integration, Logging and Auditing, Downloadable Reports & Data.​
- CI/CD and Auto Deployment​​
Phase - 2:
- Readiness for Integration with Flex ERP system to get finished parts volume from BOM – assist in accurate parts forecasting.​
- Analyze Purchase Price Variance & forecast using advanced analytics. ​
- Ability to track and link commodity price to PPV/HIS data.​
BENEFITS
- A web application with existing features on a scalable, extensible architecture.​
- Built-in ingestion/processing and analytics layer for expanding analytics capabilities in the future.​
- Secured through Microsoft Azure Active Directory.​
- Role-Based Authorization for Users.​
- End to End Traceability.​
- Maintain Integrity of data.​
- Track opportunities and quotations (SharePoint). ​
- System that integrates Program Management, Product Lifecycle Management (PLM) and ERP.​
- Change Control and Audit Capabilities.Â