{"id":173,"date":"2023-12-21T22:05:48","date_gmt":"2023-12-21T13:05:48","guid":{"rendered":"https:\/\/www.fideltech.com\/case-studies\/?p=173"},"modified":"2025-04-14T18:57:50","modified_gmt":"2025-04-14T09:57:50","slug":"resource-utilization-data-collection-workflow-servicenow-casestudy","status":"publish","type":"post","link":"https:\/\/www.fideltech.com\/case-studies\/resource-utilization-data-collection-workflow-servicenow-casestudy\/","title":{"rendered":"Resource Utilization Data Collection Workflow"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_image src=&#8221;https:\/\/www.fideltech.com\/case-studies\/wp-content\/uploads\/2023\/12\/Resource-Utilization-Data-Collection-Workflow.jpg&#8221; alt=&#8221;Resource Utilization Data Collection Workflow&#8221; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_image][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; fullwidth=&#8221;on&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_margin=&#8221;2px||0px||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_fullwidth_post_title meta=&#8221;off&#8221; featured_image=&#8221;off&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; title_text_align=&#8221;left&#8221; custom_margin=&#8221;0px||||false|false&#8221; custom_padding=&#8221;30px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][\/et_pb_fullwidth_post_title][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;25px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_row module_class=&#8221;inner-page&#8221; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; custom_padding=&#8221;0px||||false|false&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.18.0&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h3>Requirement<\/h3>\n<ul>\n<li>Create custom modules and workflows to collect data to calculate resource utilization.<\/li>\n<li>Employees work timesheet is present in private database. <\/li>\n<li>The database is pulled in SNOW by connecting to APIs and stored into custom tables. <\/li>\n<li>Data needs to be pulled in following sequence, processed and stored.\n<ul>\n<li>Get users<\/li>\n<li>Get task names<\/li>\n<li>Get project names<\/li>\n<li>Get time sheets<\/li>\n<\/ul>\n<\/li>\n<li>Populate monthly team utilization table.<\/li>\n<li>Generate various reports as\n<ul>\n<li>Overall Utilization<\/li>\n<li>Utilization by Team<\/li>\n<li>Project Data<\/li>\n<li>Non-project Data<\/li>\n<li>Project Vs Non-project Distribution<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2>About the client <\/h2>\n<ul>\n<li>An American company having 100s of restaurants located globally. <\/li>\n<li>The idea was to create workflow to collect data of their teams distributed in different geographies and it was needed to integrate it through a common workflow to generate the reports for resource utilization.\n<\/li>\n<\/ul>\n<h3>Solution<\/h3>\n<ul>\n<li>Create multiple custom tables.<\/li>\n<li>Create multiple custom work flows.<\/li>\n<li>Integrate the workflow and generate data.<\/li>\n<li>Create various reports.<\/li>\n<\/ul>\n<h3>Execution<\/h3>\n<ul>\n<li>Agile Scrum (Managed through JIRA provided by client)\n<ul>\n<li>Product Backlog<\/li>\n<li>Sprint Planning \u2013 Sprint Backlog<\/li>\n<li>Daily Stand Up<\/li>\n<li>Sprint Review Meeting<\/li>\n<li>Sprint Retrospective Meeting<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Estimation\n<ul>\n<li>5 sprint (10 weeks)<\/li>\n<li>12 stories (5 simple [3 days], 4 moderate [5 days], 1 complex [8 \u2013 10 days])<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul>\n<li>Deliverables\n<ul>\n<li>Update Sets<\/li>\n<li>Status Reports<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>Sample Stories<\/h3>\n<ul><li>Create a workflow to collect data of users and store it in the custom tables.\n<ul><li>Complexity: Moderate\n<ul>\n<li>Connect to external server<\/li>\n<li>Get data in JSON format via API <\/li>\n<li>Process the data as required and store it in custom table<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<ul><li>Create a main workflow which will connect other workflows in sequence and get the data.\n<ul><li>Complexity: Complex\n<ul>\n<li>Integrate multiple workflows<\/li>\n<li>Data from one workflow should be access by other workflow<\/li>\n<li>Process data as required and store it in custom table<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section][et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;Section&#8221; module_class=&#8221;footer-cnt&#8221; _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#103e66&#8243; custom_margin=&#8221;||-27px||false|false&#8221; custom_padding=&#8221;||30px||false|false&#8221; hover_enabled=&#8221;0&#8243; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;][et_pb_row column_structure=&#8221;1_2,1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.19.5&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<h2 style=\"color: #ffffff;\">Is this Case Study interests you?<\/h2>\n<p style=\"color: #ffffff;\">If you found this case study similar to your requirement OR interested to get our services, please connect with us using form. We will be happy to respond.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.27.4&#8243; _module_preset=&#8221;default&#8221; hover_enabled=&#8221;0&#8243; global_colors_info=&#8221;{}&#8221; sticky_enabled=&#8221;0&#8243;]<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-phone\"><\/i>Call us<\/h3>\n<p><a href=\"tel:03-6261-3309\" onclick=\"gtag('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Phone Japan','value': '03-6261-3309'});\">03-6261-3309<\/a><\/p>\n<p><span><\/span><\/p>\n<h3 style=\"color: #ffffff;\"><i id=\"et-info-email\"><\/i> Email us<\/h3>\n<p><a href=\"mailto:infofidel@fideltech.com\" onclick=\"gtag(('event', 'generate_lead', {'event_category': 'engagement','event_label': 'Footer Email Japan','value': 'infofidel@fideltech.com'});\">infofidel@fideltech.com<\/a><\/p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;1_2&#8243; _builder_version=&#8221;4.17.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;][et_pb_text _builder_version=&#8221;4.23.1&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221;]<div class=\"cf7sg-container\"><div id=\"cf7sg-form-footer-contact-form\" class=\"cf7-smart-grid has-grid key_footer-contact-form\">\n<div class=\"wpcf7 no-js\" id=\"wpcf7-f22-o1\" lang=\"en-US\" dir=\"ltr\" data-wpcf7-id=\"22\">\n<div class=\"screen-reader-response\"><p role=\"status\" aria-live=\"polite\" aria-atomic=\"true\"><\/p> <ul><\/ul><\/div>\n<form action=\"\/case-studies\/wp-json\/wp\/v2\/posts\/173#wpcf7-f22-o1\" method=\"post\" class=\"wpcf7-form init\" aria-label=\"Contact form\" novalidate=\"novalidate\" data-status=\"init\">\n<fieldset class=\"hidden-fields-container\"><input type=\"hidden\" name=\"_wpcf7\" value=\"22\" \/><input type=\"hidden\" name=\"_wpcf7_version\" value=\"6.1.6\" \/><input type=\"hidden\" name=\"_wpcf7_locale\" value=\"en_US\" \/><input type=\"hidden\" name=\"_wpcf7_unit_tag\" value=\"wpcf7-f22-o1\" \/><input type=\"hidden\" name=\"_wpcf7_container_post\" value=\"0\" \/><input type=\"hidden\" name=\"_wpcf7_posted_data_hash\" value=\"\" \/><input type=\"hidden\" name=\"_wpcf7_key\" value=\"footer-contact-form\" \/><input type=\"hidden\" name=\"_cf7sg_toggles\" value=\"\" \/><input type=\"hidden\" name=\"_cf7sg_version\" value=\"4.16.0\" \/><input type=\"hidden\" name=\"_wpnonce\" value=\"ec6482d46a\" \/>\n<\/fieldset>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns full\">\n      <div class=\"container cnt-mt\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"your-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Your Name*\" value=\"\" type=\"text\" name=\"your-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field email required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"email-669\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-email wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-email\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Corporate Email*\" value=\"\" type=\"email\" name=\"email-669\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n      <div class=\"container\">\n        <div class=\"row\" style=\"padding-bottom: 20px\">\n          <div class=\"columns one-half\">\n            <div class=\"field text required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"company-name\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-text wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Company Name*\" value=\"\" type=\"text\" name=\"company-name\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n          <div class=\"columns one-half\">\n            <div class=\"field tel required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"tel-536\"><input size=\"40\" maxlength=\"400\" class=\"wpcf7-form-control wpcf7-tel wpcf7-validates-as-required wpcf7-text wpcf7-validates-as-tel\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Phone*\" value=\"\" type=\"tel\" name=\"tel-536\" \/><\/span>\n              <p class=\"info-tip\"><\/p>\n            <\/div>\n          <\/div>\n        <\/div>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field textarea required\"><span class=\"wpcf7-form-control-wrap\" data-name=\"Message\"><textarea cols=\"40\" rows=\"2\" maxlength=\"2000\" class=\"wpcf7-form-control wpcf7-textarea wpcf7-validates-as-required\" aria-required=\"true\" aria-invalid=\"false\" placeholder=\"Message*\" name=\"Message\"><\/textarea><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><div id=\"cf7sr-6a1d658adfc48\" class=\"cf7sr-g-recaptcha\" data-theme=\"light\" data-type=\"image\" data-size=\"normal\" data-sitekey=\"6LcW5JAUAAAAAHRCNkfrX7zI14Oxgh2dP0KQg8Av\"><\/div><span class=\"wpcf7-form-control-wrap cf7sr-recaptcha\" data-name=\"cf7sr-recaptcha\"><input type=\"hidden\" name=\"cf7sr-recaptcha\" value=\"\" class=\"wpcf7-form-control\"><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\" style=\"padding-bottom: 20px\">\n    <div class=\"columns full\">\n      <div class=\"field\"><label><\/label><span id=\"wpcf7-6a1d658ad8a2d-wrapper\" class=\"wpcf7-form-control-wrap email-wrap\" style=\"display: block;\n\t\t    width: 0px;\n\t\t    height: 0px;\n\t\t    padding: 0px;\n\t\t    border: 1px solid transparent;\n\t\t    display: block;\n\t\t    overflow: hidden;\n\t\t    \"><input type=\"hidden\" name=\"email-random-hash\" value=\"27244723\"><label\n\t\t    for=\"wpcf7-6a1d658ad8a2d-field\"\n\t\t    class=\"hp-message\"\n        >Please leave this field empty.<\/label><input\n\t    id=\"wpcf7-6a1d658ad8a2d-field\"\n\t    \n\t    class=\"wpcf7-form-control wpcf7-text\"\n\t    type=\"text\"\n\t    name=\"dm55ihzhxbvz\"\n\t    value=\"\"\n\t    size=\"40\"\n\t    autocomplete=\"new-password\"\n\t    tabindex=\"1000\"\n    \/><\/span>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div>\n<div class=\"container\">\n  <div class=\"row\">\n    <div class=\"columns one-fourth\">\n      <div class=\"field\"><label><\/label><input class=\"wpcf7-form-control wpcf7-submit has-spinner\" type=\"submit\" value=\"Send\" \/>\n        <p class=\"info-tip\"><\/p>\n      <\/div>\n    <\/div>\n  <\/div>\n<\/div><div class=\"wpcf7-response-output\" aria-hidden=\"true\"><\/div>\n<\/form>\n<\/div>\n<\/div><\/div>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>Requirement Create custom modules and workflows to collect data to calculate resource utilization. Employees work timesheet is present in private database. The database is pulled in SNOW by connecting to APIs and stored into custom tables. Data needs to be pulled in following sequence, processed and stored. Get users Get task names Get project names [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":261,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[14],"tags":[],"class_list":["post-173","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-development"],"_links":{"self":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/173","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/comments?post=173"}],"version-history":[{"count":10,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/173\/revisions"}],"predecessor-version":[{"id":317,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/posts\/173\/revisions\/317"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media\/261"}],"wp:attachment":[{"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/media?parent=173"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/categories?post=173"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fideltech.com\/case-studies\/wp-json\/wp\/v2\/tags?post=173"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}