Please enable JavaScript.
Coggle requires JavaScript to display documents.
Wockhardt - Coggle Diagram
Wockhardt
Scope of Work
Deploy analytics platform on Azure data Fabric
Analytical reporting covering
Cockpits (CEO & Operational)
RCA
Forecasting
Scrubbing external relevant data
Moderating the cockpit KPI's
Data processing & Integration
Data transformation using Data factory & DS capabilities
Efficient storage and retrieval of processed data
Using PowerBI for creating insightful dashboards and reports
Advanced Capabilities
Cohesive data engineering approach
Conversational bot capabilities using GenAI for Cognitive intelligence
Analytics and insights
Enable external data scrubbing and injecting
Stream anlaytics
Predictive analytics
prescriptions based on predictions
Governance & KPI's
Data governance over the data lake.
Define & Monitor 25 KPI's including 7 KPI's at the top management level
Functional Areas
Commercial
Finance
SCM inc. procurement
Manufacturing
Various Pharma Flavours
Total quality management
QA process
Products coverage including Customer feedback for a 360 degree view
Sales & Marketing
360 view of sales and marketing data
Regulator & Compliance
compliant with industry regulations & Policies
Technical Coverage
BIW for End of life coverage
Integration of SAP Modules, SQL, Oracle, Trackwise, LMS, DMS, LIMS, eLogbook, eBMR
data privacy measures
Security layer for frabic
Authentication & Authorization
a. MFA
b. AAD for user identities & Permissions
c. RBAC
Data Encryption
a. Transit using TLS/SSL protocols
b. rest encryption using Azure Storage Service encryption (SSE)
c. Client side encryption for enhanced data protection
Network security
a. Azure VM & NSG to control inbound & outbound traffic
b. Azure firewall
c. Enable Azure DDoS protection
Data Masking & Redaction
a. dynamic data masking for sensitive information
b. redaction policies to dynamically restrict the display of sensitive data in reports & dashboards.
Azure Key Vault Integration
a. store Connection strings, passwords & encryption keys
b. Integrate AKV with ADF & other components to secure and centralize key management.
Audit Logging and monitoring
a. Enable Azure Montior
b. Azure security center to monitor security & detect potential issues
c. configure alters for suspicious activities and integrate with Azure sentinel for advanced threat detection and response
Data classification & Information rights management (IRM)
a. use Azure information protection for data classification based on sensitivity
b. Implement IRM policies to control access permission & actions on sensitive data.
Compliance and Governance
a. ensure compliance with industry standards and regulatory requirements.
b. conduct security assessments and audits
c. Implement Azure policy to enforce organizational standards and compliance rules
Backup & Disaster Recovery
a. Establish regular backup procedures to protect against data loss.
b. Implement DR plans and Azure Site Recovery for critical components.
Functional Requirements
a. Technical blueprinting/design
b. Implementation of integrated Azure analytics cloud platform with existing systems
c. Data transformation, Data Modelling, performance tuning & Publishing in power BI
Product warranty (bug Fixing) - 12 months
Develop Landing page in ReactJS to showcase for dashboards in Power BI
HLD & Deliverables
a. Infrastructure setup
b. Data extraction from SAP
c. Data ingestion pipelines
d. Data Catalogue & Metadata Management
e. Data security & access control measures
f. Data transformation & integration workflows
g. Data processing & analytics in Azure Synapse
h. data visualization & reporting tools.
i. project documentation.
LLD
Implementation
Integration
Deployment & Customization
Security & Controls
NFR
Response time & user experience should be uniform across dashboards
user interest in the dashboard should not diminish
Testing & Acceptance criteria
Post Go-Live Operations & Support
Governance
Deliverables
a. Facility to store ingested data in data lake & process data into data warehouse
pre processed/prepared datasets
Statistical & ML Models
Dashboards in scope (20 numbers - 10 KPI's Each)
Project Training
Documentation - Technical Specification, Test scripts, user guides in video format
Wockhardt specific Architecture diagram to be vetted & approved by Microsoft
SLA & KPI
per dashboard development duration
10 days (7 days acceptance criteria)
Data validity & integrity must be maintained
100% user acceptance
Defects & Bugs fixing
During development
within the dashboard timelines & acceptance criteria is no defects & bugs
Post Handover
< 1 day & no defects & bugs is the acceptance criteria
warranty
12 months
Resource availability
No delay in delivery
< 2 days as per timeline
Dashboard response time
3 seconds
Key Data source
SAP S/4 on HANA
Excel & CSV files
Web API
Historian - GE Proficy
On Premises RDBMS system, DBMS & No SQL
FTP
Teams & Onedrive
Objective
To Establish a comprehensive data lake infrastructure
Integrate diverse data sources
Driving interoperability
Unified product experience
Scope Constraints
a. Requirement Workshops - Capped to 10 workshops - 2 workshops for each functional areas (Commercial, Manufacturing, Total Quality Management, Sales & Marketing, Regulatory & Compliance)
b. Data Ingestion
SAP S/4 on Hana
Finance
Upto 12 Tables
Procurement
Upto 6 Tables
Manufacturing
Upto 25 Tables
Excel & CSV Files
Upto 10 Files
Web API
Upto 20 API's
Historian - GE proficy
Upto 10 datasets
On premises RDMBS, DBMS, No SQL
Upto 50 Tables
FTP
Upto 10 files