{"id":131000,"date":"2023-01-03T14:32:54","date_gmt":"2023-01-03T14:32:54","guid":{"rendered":"https:\/\/news.microsoft.com\/?p=447979"},"modified":"2023-01-03T14:32:54","modified_gmt":"2023-01-03T14:32:54","slug":"employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps","status":"publish","type":"post","link":"https:\/\/sickgaming.net\/blog\/2023\/01\/03\/employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps\/","title":{"rendered":"Employees at India\u2019s largest bank embrace citizen developer revolution with Microsoft Power Apps"},"content":{"rendered":"<p>When B. Ramkumar was tasked with preparing daily reports on marketing leads from hundreds of Microsoft Excel sheets for his managers, he figured there had to be a more efficient way to get the task done.<\/p>\n<p>Ramkumar\u2019s team collates all the reports that each of the nearly 1,500 offices under their jurisdiction send them. These reports, created by multiple teams within each office, contain potential leads for the sales teams to follow and are an important tool for the management to identify new business opportunities for the bank. Except the reports wouldn\u2019t always get uploaded correctly and multiple users working on live data would cause significant data loss.<\/p>\n<p>\u201cWhile we could collect all this information from various sources, there was no centralized location to store and follow up on them. I wanted us to do more at a local level, so we could track these better,\u201d says R. Radhakrishna, chief general manager of State Bank of India\u2019s Chennai local head office.<\/p>\n<p>SBI is the country\u2019s largest bank with over 450 million customers and more than 250,000 employees. Today, all SBI\u2019s employees have Office 365 and use services, such as OneDrive, Teams, SharePoint Online and Power Apps, as part of a digital transformation that the 220-year-old bank underwent in 2017.<\/p>\n<p>At a time where there\u2019s an app for almost everything, Ramkumar, a manager in the digital and transaction banking unit at SBI\u2019s Chennai office, toyed with the idea of creating an app that could automate the data collation process and present the data visually.<\/p>\n<p>\u201cI thought, why not convert the Excel sheet we send out into an app that would be user <span class=\"emdash-wrap\">friendly\u2014not<\/span> just for the people in the branches, but also for the back offices that were monitoring the data? Which is how we came up with the idea of the Digi Toolkit app,\u201d he says.<\/p>\n<p>But Ramkumar, who is blind, had no educational background or professional experience in programming. He hadn\u2019t learned basic computer skills in school, unlike his peers, because accessibility in computer technology was still a few decades away.<\/p>\n<figure id=\"attachment_84480\" aria-describedby=\"caption-attachment-84480\" class=\"wp-caption alignright\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-84480\" src=\"https:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2023\/01\/employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps.jpg\" alt=\"a photo of the Digi Toolkit app's login screen on a smartphone display\" width=\"600\" height=\"338\"><figcaption id=\"caption-attachment-84480\" class=\"wp-caption-text\">Built using Microsoft Power Apps, Digi Toolkit enables employees to fill customer details easily on their smartphones or PC. The information is stored in a central database, which provides more accurate information and better insights. Photo by Sri Loganathan Velmurugan for Microsoft.<\/figcaption><\/figure>\n<p>Enter Microsoft Power Apps, the low-code app development platform that empowers people with little or no coding experience to build apps to improve business processes.<\/p>\n<p>With Digi Toolkit, employees can input the data into the app where the collation process is automated. In the backend, Digi Toolkit is also able to deliver far more accurate data. Since users only have access to the data they input (versus an entire shared sheet) this avoids intentional or unintentional tampering, and every piece of data can be traced back to who entered it.<\/p>\n<p>This data is relayed back to the branch managers, who now have a singular view of all the products their customers are interested in. Before, each team would pursue that customer lead independently.<\/p>\n<p>With Digi Toolkit, the branch manager now knows all the products that an individual customer has expressed an interest in and is able to brief them over a single call instead of multiple calls from different teams.<\/p>\n<p>For Radhakrishna, the app provides a consolidated view of the performance of every branch in an easy to consume fashion rather than having to pore over Excel sheets.<\/p>\n<p>\u201cWe are now able to capture leads more effectively and also track and follow up on them,\u201d he says.<\/p>\n<figure id=\"attachment_84481\" aria-describedby=\"caption-attachment-84481\" class=\"wp-caption alignleft\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-84481 size-full\" src=\"https:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2023\/01\/employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps-1.jpg\" alt=\"a group of people sitting around a coffee table in an office\" width=\"2560\" height=\"1440\"><figcaption id=\"caption-attachment-84481\" class=\"wp-caption-text\">From left to right: B. Ramkumar, who came up with the Digi Toolkit app; R. Radhakrishna, chief general manager of SBI\u2019s Chennai local head office; Praveen Kumar T., who worked on Power Automate features for the app; and Bharathram S., who tested the user interface for the app. Photo by Sri Loganathan Velmurugan for Microsoft.<\/figcaption><\/figure>\n<p>Digi Toolkit was Kumar\u2019s second outing with Power Apps. But to fully execute his ideas, he realized he needed help, as this project was much larger in scope than anything he\u2019d built earlier.<\/p>\n<p>\u201cWe happened to meet when I was presenting a complaint escalation tool I\u2019d built using Power Apps for the digital and transaction banking unit,\u201d said Praveen Kumar, an assistant manager overseeing home loans for SBI in Chennai circle. \u201cEven though I don\u2019t have any coding experience, I realized he was struggling with Power Automate as it wasn\u2019t completely accessible, so I teamed up with him.\u201d<\/p>\n<p>Another colleague jumped in to test the user interface elements when Ramkumar was done creating the app.<\/p>\n<p>\u201cIn 2020, when I first started using it, Power Apps wasn\u2019t as accessible as it is now. So, I was only able to generate ideas but was not able to contribute anything to designing the interface or coding. But, over time, Power Apps has become a lot more accessible,\u201d he said. \u201cI\u2019m eagerly waiting for the next opportunity where I can chip in to create yet another app. And to think I don\u2019t even know how to code!\u201d<\/p>\n<figure id=\"attachment_84483\" aria-describedby=\"caption-attachment-84483\" class=\"wp-caption alignleft\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-84483\" src=\"https:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2023\/01\/employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps-2.jpg\" alt=\"a woman wearing a purple sari with a blue blouse looking at the camera\" width=\"600\" height=\"400\"><figcaption id=\"caption-attachment-84483\" class=\"wp-caption-text\">Vidya Krishnan, SBI\u2019s deputy managing director for IT, finds Power Apps to be a \u201cpowerful and flexible\u201d platform. Photo by Soumik Kar for Microsoft.<\/figcaption><\/figure>\n<p>Vidya Krishnan, SBI\u2019s deputy managing director for IT, finds Power Apps to be a \u201cpowerful and flexible\u201d platform that\u2019s enabling the bank\u2019s staff to build custom business solutions that are tailored to their specific needs.<\/p>\n<p>\u201cThe adoption of new technologies can lead to culture changes within an organization. For example, the introduction of new collaboration tools could change the way that teams communicate and work together, and the adoption of new productivity tools could change the way that work is organized and managed,\u201d she says.<\/p>\n<p>Fathima Syed is another employee who\u2019s using Power Apps. But unlike Ramkumar, who had no IT background, Syed is an engineer. She works at SBI\u2019s Hyderabad office, where her team handles and maintains servers.<\/p>\n<p>She struggled to provide solutions for software development requests that came her way.<\/p>\n<p>\u201cWe don\u2019t have a lot of product development happening,\u201d she said. \u201cThis is obviously not feasible every time because not all requests warrant hardcore programming. For these, we use Power Apps,\u201d she says.<\/p>\n<p>Syed discovered Power Apps quite by chance. While responding to a request from one of her colleagues at the branch level, she suggested using Microsoft Forms to lodge a complaint. Her colleague recommended that Syed use Power Apps instead, so it could be a two-way communication where complainants could also track the status of their request.<\/p>\n<figure id=\"attachment_84482\" aria-describedby=\"caption-attachment-84482\" class=\"wp-caption alignright\"><img decoding=\"async\" loading=\"lazy\" class=\"wp-image-84482\" src=\"https:\/\/www.sickgaming.net\/blog\/wp-content\/uploads\/2023\/01\/employees-at-indias-largest-bank-embrace-citizen-developer-revolution-with-microsoft-power-apps-3.jpg\" alt=\"a woman wearing a maroon dress with a green shawl looking at the camera\" width=\"600\" height=\"450\"><figcaption id=\"caption-attachment-84482\" class=\"wp-caption-text\">Fathima Syed, an engineer and pro-developer working at SBI\u2019s Hyderabad office, uses Power Apps to create solutions for colleagues that don\u2019t require hardcore programming. Photo by Arut Karan for Microsoft.<\/figcaption><\/figure>\n<p>Over time, she has developed half-a-dozen apps. Some solve a one-time problem like collating data of all hardware connected to a bank branch\u2019s network for inventory purposes, while others address ongoing issues like logging office maintenance complaints or collecting photos of server racks from various branches to ensure they\u2019re well maintained.<\/p>\n<p>One app that\u2019s currently live uses the Power Automate feature in Power Apps to add a flow to emails that have tasks for branches in them. The emails could be as simple as announcing the start and end day for sales and marketing campaigns.<\/p>\n<p>The Power Automate flow automatically adds the task to the recipient\u2019s Outlook calendar as a reminder. The app is currently live for more than 100 branches that fall under the Hyderabad local head office and will be rolled out to nearly 1,300 branches.<\/p>\n<p>\u201cThis saves a lot of time as no one has to call every branch and remind them of upcoming deadlines to meet,\u201d Syed says.<\/p>\n<p>Syed likes that she\u2019s able to provide solutions for her colleagues without having to devote a lot of time or requests for precious IT resources.<\/p>\n<p>Power Apps is being leveraged to develop several solutions across SBI offices around the country. From capturing attendance to conducting quizzes at staff training centers to ensuring ATMs are accessible for people with disabilities, there are Power Apps in place.<\/p>\n<p>The adoption of Power Apps has taken off with more than 300 apps in regular use and more than 1,400 apps developed.<\/p>\n<p>For Radhakrishna, the chief general manager of SBI\u2019s local head office in Chennai, Power Apps has become a canvas for new innovations. Recently, his team launched QR codes that SBI\u2019s customers can scan to enter their requirements.<\/p>\n<p>\u201cNow we can have customers fill their details themselves and the leads get collated into the Digi Toolkit system automatically. This wouldn\u2019t have been possible without Power Apps,\u201d he says.<\/p>\n<p>The banking behemoth is in the process of setting up a Centre of Excellence for Power Apps that won\u2019t just drive adoption, but also will find ways to scale up some of the apps at an organizational level while also adding a governance layer to the entire exercise.<\/p>\n<p>\u201cSBI and Microsoft could collaborate and explore for setting up of a joint Centre of Excellence, to offer hands-on training and brainstorming to innovate, digitize and automate the routine business processes,\u201d says Krishnan.<\/p>\n<p><em>Top photo: B. Ramkumar, a manager in the digital and transaction banking unit at SBI\u2019s Chennai office, developer the Digi Toolkit app using Microsoft Power Apps. Photo by Sri Loganathan Velmurugan for Microsoft.<\/em><\/p>\n<p><em class>Abhishek Mande Bhot is an independent writer and editor covering news, lifestyle, and luxury for publications in India and the US.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>When B. Ramkumar was tasked with preparing daily reports on marketing leads from hundreds of Microsoft Excel sheets for his managers, he figured there had to be a more efficient way to get the task done. Ramkumar\u2019s team collates all the reports that each of the nearly 1,500 offices under their jurisdiction send them. These [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":131001,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49],"tags":[415,1083,50],"class_list":["post-131000","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-news","tag-feature-stories","tag-power-apps","tag-recent-news"],"_links":{"self":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/131000","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/comments?post=131000"}],"version-history":[{"count":0,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/posts\/131000\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media\/131001"}],"wp:attachment":[{"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/media?parent=131000"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/categories?post=131000"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sickgaming.net\/blog\/wp-json\/wp\/v2\/tags?post=131000"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}