Automate with safety improvement application(SIO)
This safety improvement application collects the observations from the organizational Staff and non-staff, and the respective department head will take care of the closure observation, and some observation categories will be verified by the top management. This system uses the competency of Microsoft SharePoint Online, Power Automate, Power Apps, Power BI, and MS Form to develop durable and scalable systems. Other members developed MS Forms to make entries, and with the help of Power Automate, it will reflect form responses in the SharePoint List. The respective department heads have permission to take closure images with the camera and add current observations to make it close, re-open, or may be rejected. Category-wise option over there to validate or reject the current observation by the head.
About Client
Client-Name
L'Oréal
Country
India
Platform
Microsoft
L'Oréal is a prominent player in the Indian beauty market, offering diverse products under brands like L'Oréal Paris, Maybelline, and Garnier. L'Oréal has adapted its products and marketing strategies to meet the specific beauty preferences and standards of the Indian market. Sapphire Software Solutions have establish a segregated Power BI dashboard and table to track action items and their respective statuses, and implement a Power BI visual to monitor overdue near miss actions and SIO ageing.
Challenges
The biggest challenge for this project was making entries by non-staff. For the same, we prepared the MS form, and with the help of Power Automate, we copied that response into the SharePoint list. The challenge was to make power automate to collect the observation from the MS-Form and assign that observation to the respective department head. It was challenging to manage the categories-wise options like validate and reject for some categories during close observation for others. The client wanted to manage the Power BI Reports to cover the entire project MSI detain in a single dashboard.
Solutions
We created a PowerApps application for explicitly information gathering & storing to SharePoint user management.
Makes the whole process automated which saves user’s time.
SharePoint/PowerApps User Interface Provides Data Entry Validation Benefits.
Enables the copy/paste of data from excel to support bulk operations.
Notifies working hour entry and verification upon date(s).
Manage audience for operate the certain operation rights wise.
Define some common configuration.
App Screen
Principal Features
Push notifications
Push notification over there to notify when new observations are added in Apps. Prepared MSI report in Power BI to monitor and drill the observation entries and their closure ratio.
Document Storage
You can store documents in one location so auditors, employees & compliance officers can easily find the documents.
Advanced Search & Reports
Find any documents by keywords or metadata. Get instant reports on current stages, policy features & owners.
Role-Based User Access
Allow the users who need to view a document only to have access, whether they require a permit to view a document or edit it.
Real-Time Dashboards
Get an instant overview of date wise and department wise observation details with category wise drill down.
Observation ration
Also display some blocks for count of repetitive observation, closure and pending observation and Level wise (High-medium) observation ratio.
Technology Stack
We employ cutting-edge technologies and tools to make sure your applications are built on the latest technology. Have a look at our tech stack
Frameworks
- PHP - Laravel
Front End
- Android
- Bootstrap
- JQuery
- iOS - Swift
- Kotlin
Database
- MS-SQL
Deployment
- AWS
- Play Store
- Apple Store
Testing
- Selenium
- Test Rail
- Apache JMeter
- BrowserStack
- Postman
- OWASP ZAP
Architecture
- MVC
- MVVM
What Our Clients Say
****FIVE STARS****
He is very talented and the work is completed on time and he explained it very well. He used latest technologies to complete the task. I am ready to offer him more tasks in future.
Arjun Aileeni
Ohio, USA
Thank you so much to the team for helping my company set sail with such amazing web development services. I would be more than happy to refer you to my circle. These guys created an awesome website at a minimum cost. Thanks to the team for going that extra mile.
Pamir
Florida, USA
I have had very good experience with the team. They definitely have the right skill in house, I would definitely recommend them for future .NET projects. Hope to get back to them with more work Cheers!
Carmen Dumascu
Toronto ,Canada
This is my second project with this team and they are awesome in what they do.. I came back them with suggestions /changes to the output and they were able to knock the work well in time.. I would love to work with them again.
Saichand Mekala
Albama ,USA
I appreciate the work quality and deadline adherence of Sapphire Team to finish agreed project work on time and with quality.
Praveen Gami
Riyadh, Saudi Arabia
****FIVE STARS****
He is very talented and the work is completed on time and he explained it very well. He used latest technologies to complete the task. I am ready to offer him more tasks in future.
Arjun Aileeni
Ohio, USA
Thank you so much to the team for helping my company set sail with such amazing web development services. I would be more than happy to refer you to my circle. These guys created an awesome website at a minimum cost. Thanks to the team for going that extra mile.
Pamir
Florida, USA
I have had very good experience with the team. They definitely have the right skill in house, I would definitely recommend them for future .NET projects. Hope to get back to them with more work Cheers!
Carmen Dumascu
Toronto ,Canada
This is my second project with this team and they are awesome in what they do.. I came back them with suggestions /changes to the output and they were able to knock the work well in time.. I would love to work with them again.
Saichand Mekala
Albama ,USA
I appreciate the work quality and deadline adherence of Sapphire Team to finish agreed project work on time and with quality.
Praveen Gami
Riyadh, Saudi Arabia
****FIVE STARS****
He is very talented and the work is completed on time and he explained it very well. He used latest technologies to complete the task. I am ready to offer him more tasks in future.
Arjun Aileeni
Ohio, USA
Thank you so much to the team for helping my company set sail with such amazing web development services. I would be more than happy to refer you to my circle. These guys created an awesome website at a minimum cost. Thanks to the team for going that extra mile.
Pamir
Florida, USA
I have had very good experience with the team. They definitely have the right skill in house, I would definitely recommend them for future .NET projects. Hope to get back to them with more work Cheers!
Carmen Dumascu
Toronto ,Canada
This is my second project with this team and they are awesome in what they do.. I came back them with suggestions /changes to the output and they were able to knock the work well in time.. I would love to work with them again.
Saichand Mekala
Albama ,USA
I appreciate the work quality and deadline adherence of Sapphire Team to finish agreed project work on time and with quality.
Praveen Gami
Riyadh, Saudi Arabia
