Customer Success Stories

  A leading global conglomerate, known for its extensive operations in energy, infrastructure, and mining, has digitally transformed its internal operations, business processes, and workplace to enhance agility and meet modern business challenges. Leveraging Microsoft Power Platform and Office 365 solutions, the organization has implemented streamlined workflows, robust insights, and an empowered commercial system. Products/Solutions: Microsoft Solutions: SharePoint Online Microsoft Flow (Power Automate) Graph API Power Apps Azure API   Azure Services: Azure Web Services for SAP-to-SharePoint Document Transport Azure Data Lake Azure Web Jobs AI and Automation Tools: Power Apps AI Builder Copilot Studio Python Solution Summary The organization partnered with atQor to design, develop, and implement a modernized operational ecosystem. This transformation aimed to address challenges in managing internal workflows, ensuring process transparency, and improving decision-making agility. Additionally, the company’s diversified operations, including energy production, renewable projects, and infrastructure development, required a unified digital strategy to ensure accountability and scalability across business verticals. Business Use Case As a global leader in energy and infrastructure, the organization operates multiple high-impact projects: Export Operations: Efficiently managing operations at long-standing export terminals to meet environmental and logistical standards. Port Operations : Leveraging automation to streamline operations at export terminals, including the automation of sailing advice processes. This initiative reduced manual intervention, improved accuracy, and enabled real-time tracking of critical shipping operations, enhancing the port’s efficiency and operational transparency. Renewable Energy Projects: Delivering scalable renewable energy solutions with significant expansion potential. Mining Operations: Streamlining supply chain processes for resource extraction and transportation across expansive networks. Implementing advanced planning and optimization tools for coal plant operations. A constraint-based optimization model was introduced to handle dynamic mine plan updates, reduce inefficiencies in stockpile allocations, and minimize demurrage costs. This ensured better alignment of mining activities with shipping schedules and production targets, driving increased dispatch efficiency and reduced operational overheads. The diverse nature of these projects necessitated an integrated approach to managing operations, enhancing collaboration, and ensuring compliance with global standards. The digital transformation initiative was critical for supporting these goals. Challenge The company faced significant challenges in managing its semi-automated, Excel- and email-based processes for handling vendor interactions, service requests, and other commercial activities. Key pain points included: Lack of real-time tracking for approvals. Complexity in obtaining C-level approvals. Inefficient visibility into commercial processes such as invoice and payment tracking. Limited transparency and accountability across operational levels. Manual processes for managing sailing advice Frequent mine plan changes required dynamic updates to coal plant schedules Solution Strategy The transformation focused on automating workflows and introducing role-based dashboards to streamline operations and improve visibility. Key functionalities included: Role-Based Dashboards: Customized views for Admins, Approvers, and Requestors. Automated Notifications: Email alerts at each approval stage for stakeholders. Document Management: Centralized repository for supporting documents. Mobile Accessibility: Approval capabilities for CEO and CIO-level users. Workflow Automation: Streamlined processes for approvals, contracts, invoices, and payments. Advanced Reporting: Insightful Power BI dashboards tailored for C-level executives. Created draft sailing advice automatically. Automated adjustments to stockpile allocations, plant schedules, and shipping plans. Provided scenario modeling for decision-making and trend analysis. Results The digital transformation resulted in significant operational efficiencies and transparency improvements. Key outcomes included: Live Tracking: Real-time monitoring of commercial requests from initiation to completion, including approver comments and status updates. Enhanced Dashboards: Role-specific dashboards for Admins, Approvers, and Requestors, improving visibility and control. Actionable Insights: Power BI-generated reports for management, providing actionable insights for decision-making. Automated Documentation: PDF generation and management of approved requests (PR/NFA/Invoice/SES) for seamless knowledge management. Improved Transparency: C-level reporting dashboards enabling strategic oversight. Port operations : Faster processing times, improved accuracy, and seamless document management. This collaboration underscores the organization's commitment to leveraging cutting-edge technology for operational excellence and business agility while supporting diverse business verticals through unified and transparent digital processes.

A major export terminal, renowned for its critical role in global logistics and resource distribution, transformed its operations by automating the sailing advice process. This initiative enhanced efficiency, scalability, and transparency, aligning with the organization’s commitment to delivering seamless supply chain solutions. Products/Solutions: Power Automate AI Builder Python SharePoint Online Power Apps Business Challenge The sailing advice process was heavily manual, causing delays and inefficiencies that impacted operational flow. Challenges included: Operational Delays: Manual processing hindered timely updates and approvals. Limited Visibility: Stakeholders did not have access to real-time updates on sailing schedules. Scalability Issues: Increasing transaction volumes strained existing processes. Business Impact Delays in sailing advice management led to inefficiencies in export operations, potentially affecting client satisfaction and revenue. SolutionThe export terminal deployed an automated solution leveraging AI Builder and Power Automate. Features included: Automated data extraction and validation from PDF sailing advice documents. Centralized storage integrated with SharePoint Online for seamless document management. Real-time dashboards offering comprehensive insights for stakeholders. Workflow automation with notifications tailored to specific roles. Business Results Enhanced Efficiency: Reduced processing times by over 50%, enabling faster decision-making. Improved Transparency: Real-time updates increased stakeholder confidence. Scalability: Prepared the terminal for higher transaction volumes and future growth. Customer Satisfaction: Improved accuracy and responsiveness strengthened client trust. This transformation highlights the organization's capability to enhance logistics and sustain its competitive advantage.

A prominent mining organization implemented cutting-edge planning solutions to address inefficiencies in managing stockpiles, production schedules, and shipping timelines. This initiative marked a crucial breakthrough in driving operational efficiency and addressing market needs. Products/Solutions: Mixed-Integer Linear Programming (MILP) Python Power Apps Azure Data Lake Business Challenge Frequent changes to mine plans introduced challenges in aligning operations with market demands. Challenges included: Manual Processes: Dependence on spreadsheets was inefficient and error-prone. Inefficiency: Misalignment between stockpile, production, and shipping schedules affected dispatch performance. Cost Implications: Delays led to increased demurrage costs and lost opportunities. Business Impact Inefficiencies in planning directly impacted revenue potential and operational costs, emphasizing the need for an advanced solution. SolutionThe organization deployed a constraint-based optimization model powered by MILP and Python. Key capabilities included: Automated realignment of production and shipping schedules based on real-time updates. Intuitive interfaces for scenario modeling and strategy evaluation. Advanced analytics for trend insights and decision-making. Business Results Increased Revenue: Enabled additional dispatch opportunities, unlocking untapped potential. Cost Savings: Reduced demurrage costs through optimized scheduling. Operational Agility: Rapid adaptation to changing mine plans. Scalable Solution: Established a foundation for future operational enhancements. This initiative highlights the organization’s commitment to innovation, ensuring resilience and leadership in the mining industry.

Client: Under NDA Industry: Banking & Finance Deployment Country: USA Solution: Complex Used Product/Service: Microsoft Azure Migration Type: Rehost Windows Server and SQL Server from On-Premise Company Size: 1000-5000 employees Project Timeline: November 2020 Client’s Business Overview 4th Largest Bank in the Midwest of the US drives Digitization by migrating mortgage-related services and infrastructure to Microsoft Azure. The 4th largest bank in the Midwest US, with 46 full-service bank branches across the USA and $2.9 billion in total assets, offers a comprehensive variety of financial services and products. The Bank continually upgrade its technology infrastructure by investing in the latest tools and run their business process for correspondent lending using Cloud-based proprietary LOB System The challenge The challenge at hand was to ensure the application’s availability and reliability while meeting all financial services-related compliances and security standards as well as meet technical requirements to deliver the best performance for customers across the US east coast and west coast. atQor’s RegTech practice and its expertise around atQor Vault built on top of Microsoft Trusted Cloud helped the customer pose its trust in our abilities and decide to host their mission-critical app on Microsoft Azure. The outcome was the improved availability of the app with close to 99.999% uptime achieved and the presence of different regions for a production environment as well as test environment: thus enabling enhanced business continuity. “Our mortgage application is now not only internally consumed but leased to 40 other banks in West Coast, thanks to your solution and amazing 24/7 premium support.” - Vice President IT –– The Bank From requirement analysis to proposing a comprehensive dependable solution We evaluated the existing ecosystem in the Bank and its requirement to identify the best way to protect their information rights and IPR and ensure a faster, better, secured, regulatory compliance in-built solution to run this core application. Migrating the app infrastructure to Azure With atQor’s RegTech expertise, the atQor team moved this mission-critical application for the bank to Azure with High Availability and Different Regions for Production Environment as well as non-production/test environment separately. The application was built on Microsoft .net technology with SQL as a backend database, which takes care of the Lending process, from registration to final docs in it. Some of the modules include; Manage the pipeline of loans, loading the loans with categorization, review loan package, Compliance EZ, and DataVerify. The highlight of the solution Azure for Production of Fusion Web Application Additional Domain Controller on Azure with High Availability in a different region Database Server on Azure with High Availability in a different region Back-End Server on Azure with High Availability in a different region Front-End Server with High Availability in a different region Proxy Server with High Availability in a different region Azure for Non-Production/Testing of Fusion Web Application Additional Domain Controller on Azure Database Server on Azure Back-End Server on Azure Front-End Server Deployment of Proxy Server Post Migration: 24/7 Proactive Azure Monitoring and managed services. Happy client and a promising future   The result was a dependable app running from scalable, load-balanced, elastic architecture as well as improved performance, that allowed them to further lease or offer on subscription to other banks in West Coast and resulted not only achieving the primary goal but opened additional revenue stream for the bank. The audit for SOC and other compliances were met using atQor RegTech services and Microsoft Trusted cloud reports that we supply to them along with Azure Premium support by the atQor team.

Client: Under NDA Industry: Finance Deployment Country: USA Solution: Complex Used Product/Service: Microsoft Azure Migration Type: Rehost Windows and SQL server from on-premise Company Size: 11-50 employees Project Timeline: October 2020 Client’s Business Overview A market leader in surety bond processing since 1999 in the United States migrates to Microsoft Azure to improve security and reliability. The US-based market leader for surety bond processing organization with its web-based surety bond solution enables clients, brokers/agents, obligees, and carriers to manage bond requirements efficiently. The application digitally connects the world of surety by enabling seamless communication among and between obligees, principals, and sureties. Move to the cloud at scale. The application was built on a legacy platform of Windows 2008 and SQL 2008 and running on client-server on-premise architecture, which needed a scalable, and seamless move to newer technologies. Due to increasing demand improving productivity while delivering the best to customers, the organization decided to adopt modern technology and decided to move applications, servers, and databases to Microsoft Azure. This was a migration from On-Premises to Microsoft Azure Cloud Implementation with required architectural changes and newer technology-based scalable delivery to all their customers. The customer began a process to evaluate the cost-benefit of various platforms and the most effective way of unifying its existing tools. atQor’s expertise and required pre-assessment helped them determine that migrating to Azure is the right fit for their needs. With the help of atQor advisory and expertise around azure data, platform offering customer found real value and reason to move existing running SQL Server, to Azure SQL Managed Instance which offered the fullest database compatibility. With SQL Managed Instance, the customer remains assured that the managed SQL instance is always up to date, with minimal IT team attention including they do not have to worry about updates and upgrades. Not only did Azure meet Customer requirements for its SQL Server workload to save costs but the lift-and-shift to Azure went seamlessly, and the company experienced minimal downtime using Azure Database Migration Service to support the fast, easy migration of SQL Server and MySQL workloads. Fast migration, easy maintenance The company completed the migration quickly with proven Migration methodology from atQor and with very minimal downtime and nearly zero downtime to customer-facing services. The company runs a lean development team that supported and managed all aspects of its data, and in the past, the team found it challenging to use disparate tools and perform support tasks while constantly training staff to stay up to date with technology. The move helped the company to plan future applications rebuilding scalability-based architecture without worrying about transition period service delivery experience for their end customers.

Industry: Manufacturing Deployment Country: India Solution: Power Apps Used Product/Service: Power Platform, Azure Project Timeline: Nov 2022 Executive Summary  A textile manufacturing giant from India with gargantuan global operations was facing challenges with their fabric sampling process. The sampling process in the textile business is critical as it is the starting point for any potential sales, and customers usually ask for samples before placing a bulk order. The request, also known as "Sample Request" or "Sample Order", requires a lot of details such as the type of fabric, composition, stitching, embellishing, color specifications, and associated codes. The process involves multiple departments and hands, including design, technical, production, and quality, and staff members must also take customer needs and expectations into consideration to decide on the samples to be sent.  Customer challenges  However, the company's legacy way of handling the process using spreadsheets, emails, and physical documents was time-consuming, personnel-intensive, lacked real-time visibility, and was highly prone to information loss and errors. The process also lacked a central repository of all past samples, causing the marketing and sales team to go through a new sample process even if there is a nearest match of the specification and sample available in the system from past requests. This resulted in missed information and direct/indirect financial impacts.  Partner solutions  A Model Driven App – using Power Apps  Automation of mundane tasks – using Power Automate  Integration with SAP (ERP) – using Azure WebApp and API management. Integration with CRM – using Microsoft Dataverse and Power Automate To solve the fabric sampling challenge, the company partnered with atQor, which proposed to create a Power App using Microsoft Power Platform and Dataverse as the database to store sample request transactions. The app would use Power Automate to automate workflows, approvals, and integrate with CRM, and the sample requests created on Power Platform would go to SAP to process further as a sample order in the ERP. The solution also implemented QR codes across the processes to reduce manual inputs and fetch required details or status from ERP and CRM.  Customer benefits  With the new solution, every department involved in the sampling process now uses the Model Driven app to run the entries, see status in real-time, and update relevant information on the go. Sample requests are now synced with SAP for further processing, and the app automates approvals and sends automated emails to ensure no errors and appropriate records. The solution also includes a sample library that searches for the nearest specifications available in the sample library and makes suggestions, saving the company and clients time and costs and ensuring something that has already been tried and tested for quality and performance gets a chance to re-enter the market. Notifications of exceptions and call-outs are sent out in no time to the respective teams via inbuilt notification features available in Power Platform, ensuring thorough awareness and preparedness.