Category Archives: Microsoft Flow

Bitscape Customer Story – Cement Manufacturing Company | SPO | Applications | Applications | Modern

Bitscape is Microsoft Gold Competency Partner for Cloud Productivity, Cloud Platform, Data Analytics and Content and Collaboration. Bitscape’s customer centric approach ensures organizations to do more with their technology investments by improving user experience and productivity. We help customers achieve more in the digital transformation of their organizations of all sizes.

Industry: Manufacturing | Pharmaceuticals |Oil and Gas |Media Entertainment |Retail |Government

 Products/Solutions: SharePoint Online |Power BI |Microsoft Flow |PowerApps |Dynamics AX Integration |ADFS / SSO

 Solution Summary:

Customer is one of the largest cement manufacturer in the country with more than 6.75 million tons of annual production capacity and close to 1500 shop floor and first line worker collaboration. Customer aims to become number 1 player in the cement manufacturing brand in the country by using technology help them digitally transform the operations efficiency and which can result in to narrowing gap of hardly 2% in market share from number 1 player. Contract Labor Management System and Ticket Management System solution envisioned on top of SharePoint online where already existing corporate collaboration was happening.

 Challenge:

Collecting data from multiple systems including legacy contract management solution, other shift data and production data from Dynamics AX ERP and ensuring all labor law, compliances and benefits are effectively monitored and rendered. Creating the fully functional regulatory driven, safety, statutory rates, medical records, contract management, shift management, workmen configuration, overtime, department mapping, workorder, bulk update attendance and fully integrated ticket management system for operational efficiency means highly efficient, no or less custom code-based

 Solution Strategy:

Working with functional group heads to map the processes and identifying data modeling needed from various data sources to run process workflow on SharePoint Online and create a seamless experience to achieve single source of truth available on preferred platform of SharePoint online.

The solution delivered responsive with completable to mobile devices such as Android, iPhone and iPad or tablets and other regular form factor and delivered integrated ticketing system for contract labor management which included Manage Contractor, Work order Management, Labor Management, Card Management, Attendance Management, Shift management, Wages Management, Compliance Management, Master data manipulation, Administration, Field Customization, Contractor collaboration, Leave Management

 Results:

The solution delivered ensured a 360-degree view and compliance driven automation of manual processes and directly linked with production data ensured not only better productivity but also better employee satisfacation for transparent process for work and rewards.

Bitscape Customer Story: Adani Australia digitally transforms internal operations, business processes and workplace to be more agile

Industry:

Manufacturing  |  Pharmaceuticals | Oil and Gas | Media Entertainment | Retail |Government

 Products/Solutions:

SharePoint Online |MS Flow | Graph API |Power APP |AZURE API

Azure Web Service: SAP to SharePoint document transport |Azure DataLake |Azure Web Job

Solution Summary

Adani Australia digitally transforms internal operations, business processes and workplace to be more agile to meet challenging business asks thanks to Microsoft PowerPlatform and Office 365.

Adani Australia is a multi-dimensional energy and infrastructure company, dedicated to delivering energy solutions for an advancing world. It owns and operates Abbot Point Terminal which has been exporting Queensland coal responsibly for more than 30 years. Adani Renewables Australia’s first solar farm Rugby Run near Moranbah will supply 65MW of renewable power in phase 1, with the capacity to expand up to 170MW. The Carmichael Project is a 27.5mtpa coal mine and 200km rail line.

Bitscape and Adani Australia, developed, designed and implemented Office 365 and PowerPlatfrom empowered commercial system and insights system to overcome this problem and help them meet business accountability and transparency at every level for internal operations.

Challenge:


With business and processes getting stiff requirements of transparency and processes including their business dealing with different vendors, service providers, other companies, being tracked at every level in semi-automated excel and email-based processes creates clear issues of accountability, agility and fast decision making their business need today.  The processes in use had multiple challenges that included no tracking for approvals, C level approval complexity, no view of commercial processes such as invoices, payments, contracts tracking.

Solution Strategy

Functionality involved

  • Role based Dashboards i.e. Admin/ Approver/Requestor.
  • Email notification at each level i.e. Approver, Requestor, HOD
  • Attachment of supporting documents.
  • Mobile base Approval System for CEO/CIO level user
  • Role based Dashboards i.e. Admin/ Approver/Requestor.
  • Automated workflow in each module.
  • Insight Reporting for C level users with Power BI Dashboards.

Results

The transformation helped Adani Australia to manage key and insights for operational efficiency. Some of the results as under

  • Live tracking of Commercial request (PR to SES realised) status as well as their approvers status and comments.
  • Role based Dashboards i.e. Admin/ Approver/Requestor.
  • Power BI reports for Management/ CEO/ CIO.
  • PDF conversion of Approved request (PR /NFA /Invoice /SES)
  • Document Management of Approved Request (Knowledge Management)
  • C level reporting generated on dashboards using Power BI

Bitscape Customer Story: Essentra PLC digitally transforms multiple operations and gains critical insights

Industry: Manufacturing | Pharmaceuticals | Oil and Gas  |Media Entertainment | Retail Government

Products/Solutions: SharePoint Online | Microsoft Power BI | MS Flow |  Graph API | SQL SSRS | Power Platform

Solution Summary:

Essentra PLC digitally transforms multiple operations and gains critical insights thanks to Power BI, Flow, graph API and Microsoft software as service cloud.

Essentra is a leading global provider of essential components and solutions with four global divisions: Components, Packaging, Filters and Specialist Components. Every day Essentra produce and distribute millions of small but essential components and their international network extends to 33 countries and includes 45 principal manufacturing facilities, 30 sales and distribution operations and 4 research & development centers.

With more than 5000+ Office 365 users on Microsoft Cloud platform it partnered with Bitscape to work and leverage the platform to help them implement strategic transformation for various operations and insights needed by their strategic business units.

With the help of power platform and Microsoft O365 platform, Bitscape created multiple transformational solutions for them which included Capex Approval system, commercial system, Power BI Dashboard for Mattec System (3rd Party Manufacturing Execution system), compliance, risk mitigation and specific to business processes systems.

Challenge

  • Data maintained and used in MS excel and it was not manageable.
  • No tracking of approvals.
  • Do not get the live status of the Request i.e. Capex, Invoice Status, Payment Status, production reports.
  • Lack of tracking for the approvers comments as well as status.
  • No insights to Management for overall status of production of materials
  • Lack of tracking for the Action owners and their comments as well as status.

Solution Strategy:

  • Live tracking of Capex status as well as their approvers status and comments.
  • Dashboards for Admin/Approver/Requestor.
  • Power BI reports for admin.
  • PDF conversion of Approved capex
  • Live tracking of Commercial request (CAPEX to Invoice realised) status as well as their approvers status and comments.
  • Role based Dashboards i.e. Admin/ Approver/Requestor.
  • PDF conversion of Approved request (Capex / PO / Invoice)

Results:

The transformation helped Essentra to manage key actions from meetings, projects, incidents, audits and monitor quality control. It provided real time visibility and status for every action within the organization or the strategic business unit along with critical insights reports for production.

 

Industry: Manufacturing | Pharmaceuticals | Oil and Gas |Media Entertainment | Retail Government Products/Solutions: SharePoint Online | Microsoft Power BI | MS Flow | Graph API | SQL SSRS | PowerPlatfrom Solution Summary Essentra PLC digitally transforms multiple operations and gains critical insights thanks to Power BI, Flow, graph API and Microsoft software as service cloud. Essentra is a leading global provider of essential components and solutions with four global divisions: Components, Packaging, Filters and Specialist Components. Every day Essentra produce and distribute millions of small but essential components and their international network extends to 33 countries and includes 45 principal manufacturing facilities, 30 sales and distribution operations and 4 research & development centers. With more than 5000+ Office 365 users on Microsoft Cloud platform it partnered with Bitscape to work and leverage the platform to help them implement strategic transformation for various operations and insights needed by their strategic business units. With the help of power platform and Microsoft O365 platform, Bitscape created multiple transformational solutions for them which included Capex Approval system, commercial system, Power BI Dashboard for Mattec System (3rd Party Manufacturing Execution system), compliance, risk mitigation and specific to business processes systems. Challenge • Data maintained and used in MS excel and it was not manageable. • No tracking of approvals. • Do not get the live status of the Request i.e. Capex, Invoice Status, Payment Status, production reports. • Lack of tracking for the approvers comments as well as status. • No insights to Management for overall status of production of materials • Lack of tracking for the Action owners and their comments as well as status. Solution Strategy • Live tracking of Capex status as well as their approvers status and comments. • Dashboards for Admin/Approver/Requestor. • Power BI reports for admin. • PDF conversion of Approved capex • Live tracking of Commercial request (CAPEX to Invoice realised) status as well as their approvers status and comments. • Role based Dashboards i.e. Admin/ Approver/Requestor. • PDF conversion of Approved request (Capex / PO / Invoice) Results The transformation helped Essentra to manage key actions from meetings, projects, incidents, audits and monitor quality control. It provided real time visibility and status for every action within the organization or the strategic business unit along with critical insights reports for production. “We started reaping benefit of the Microsoft platform to transform our operations and strategic business units. The Power BI and Flow really helped us explore further. The folks at Bitscape are very knowledgeable and continue to add value to our journey of exploiting full features of Microsoft cloud and business platform.” - Harsha Venkatrao – Global Head of Custom and Enterprise Solutions – Essentra

Customer story: Multinational media and entertainment company modernize the workplace with migration of SharePoint 2010 to SPO

Bitscape is Microsoft Gold Competency Partner for Cloud Productivity, Cloud Platform, Data Analytics and Content and Collaboration. Bitscape’s customer centric approach ensures organizations to do more with their technology investments by improving user experience and productivity. We help customers achieve more in the digital transformation of their organizations of all sizes.

SHAREPOINT 2010 TO SPO

Industry: Manufacturing |  Pharmaceuticals |Oil and Gas | Media Entertainment | Retail

Products/Solutions: SharePoint Online | Power BI | Microsoft Flow

Solution Summary: Customer is one of the largest media entertainment company in the world with stringent internal corporate complainces and regional data classification compliances. Migration of SharePoint 2010 two farms in two different continent datacenters supporting collaboration on SharePoint based business workflow and application across multiple subsidiaries and 23000+ users migrated to SharePoint online for seamless collaboration and active integration with newly acquired large corporation easily. Solution usage Bitscape’s proprietary farm analysis PowerShell scripts and content portability guide on SPO, OneDrive Online and Teams channel.

ChallengeThe complexity of understanding use across various organization and what is important and not, with data classification and business unit approvals for 4000+ Subsites, 300+ site collection and 500+ personal sites having 1500+ active web features, 130+ SPD List workflow, 315+ InfoPath forms, 105+ Nintex workflow, 105 Kwizcom forms and custom code was cumbersome task. Meeting business objective of removing most of the third-party components and custom code without affecting business current need and processes were challenging in few infopath forms and Nintex workflow cases where Flow was used to meet similar if not exact business process automation.

Solution Strategy: The solution strategy was to identify and help business take decision on lift and shift and most active sites and processes on SPO first and then prioritize various complexity based on Bitscape’s migration suggestion and reporting provided by various proprietary Power Shell scripts. The current state assessment with recommendation and data visibility summary provided by Bitscape team, worked as decision making on priority of data to reside where for business user groups i..e personal sites to OneDrive online, most of the processes on the SharePoint and key collaboration in to teams.

Results: The migration helped customer move 23000+ active users to SPO for collaboration across subsidiaries and even further helped them integrate with new large media businesses they acquired during the process. The modern new workplace further empowered employee efficiency and active collaboration across organization using Azure B2B in some cases which were not possible in previous on-premise datacenter-based SharePoint 2010. The entire project before Bitscape engagement internally estimated to be 3 years timeline, completed in 8 months.

“When we estimated the migration, we were not sure on timeline and complexity due to multiple geography-based team involved, as we worked along Bitscape’s SharePoint Migration Framework, we not only achieved this in record time but also able to integrate faster to newly acquired companies in two different continents” – Director, Enterprise Business Systems