Fluent Essays

An overall IT      architecture diagram that includes Internet and web technologies, the      computers, the databases, and the applications (where do they reside and      how they are interconnected). This      diagram should put all the pieces together and show how they are      interconnected and accessed.   You need to prepare only one slide from the attached PPT. The slide number is 27. Project 2 ISEM 500  - O – 2021/ Late Summer Harrisburg University of Science and Technology  Paulo Martins Nery de Araujo, Naga Srinivas, Priyanka Kogta, Raquel Noblejas Sampedro 1 Connies Clothing Store – Team Contribution Full Name Contribution Percentage Paulo Martins Nery de Araujo Databases (Part B) The Network (Part B) 25\% Naga Srinivas  Architecture Diagram Cloud Computing 25\% Priyanka Kogta Mobile App and IoT Strategy (Part A) Web Technologies Being Used (Part B) 25\% Raquel Noblejas Sampedro Long Range Plan (Part A) Rough cost estimate (Part B) 25\% Here is the team contribution that shows what each member has done, and the percentage of contribution by each team member. 2 Part A: Application Plan 3 Application Matrix Year 3 Business Intelligence Software (IBM) CRM Software (SugarCRM) SCM Software (E2Open) Marketing Automation Software (SAP) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Production Raw Material Purchasing X Engineering/Management X X Raw Material Inventory X CAD/CAM X Research and Innovation Research and Development X X Innovation and Applied Research X X Logistics Product Lifecycle Management X QA X Supply Chain Management Procurement X Scheduling X Monitoring and control X X Warehousing and Distribution Fulfillment X Shipping X Finished Goods Inventory X Finance and Accounting Finance  X Accounting X On Year 3, since our strategy is to expand gradually all over the country and invest in 3D printing technology for production and logistics automation, we will consider Research and Development as an independent Business process (outside Production business unit) and use an additional software package dedicated for 3D printing management. However, since 3D printing will play a fundamental role in our companys development, we will manage this business process with an in-house develop software application. Additionally, our company size will grow significantly, forcing the company to optimize the HR management and accounting processes, combining the used software packages into one unified ERP system, Workday. We will try and incorporate Business Intelligence results to our Product Development and Innovation processes, enriching our product differentiation with the market knowledge and predicted trends. 4 Business Intelligence Software (IBM Cognos) CRM Software (SugarCRM) SCM Software (E2Open) Marketing Automation Software (SAP) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Store Operations Customer Assistance X Store Management/Operations X Product Inventory X Corporate Corporate Planning X X X Business Intelligence X Knowledge Management X Enterprise Purchasing X X Business Monitoring and Control X Human Resources Payroll X Hiring X X Legal Contract Approvals/Renewals X X Counseling X Information Technology Online Orders and Processing X X X Customer Service and Assistance X X Product Information X X Marketing Research X X Promotions X E-store fronts X X X Regarding the applications selected: IBM Cognos (Executive Support, Rented): it is a web-based business Intelligence suite that provides the company a toolset for analytics, reporting, score carding, and monitoring. It will help the company to identify actionable information from the raw data, facilitating data-driven decision making and supporting the business to make informed decisions. It also reduces the IT dependencies and helps to recognize performance gaps, market trends and revenue opportunities fasters since it is automated and analytics driven. SugarCRM (Decision Support, Extended): is web-based system that includes functionalities for customer relationship management, salesforce automation, marketing campaigns, customer support, collaboration, and reporting. It will help the company by automatically capturing relevant customer information and propagating it to the rest of the relevant systems to provide a seamless experience for the end-user. E2Open (Operational, Bought): is a cloud-based, on-demand software for supply chain processes support, including production, inventory, logistics, and channel activity. It will help the company to automate production, distribution and logistics, reducing operational costs and increasing the supply chain agility and resiliency. Furthermore, having an efficient supply chain and inventory management will increase the revenue because of accurate stock and estimations. SAP (Decision Support, Rented): is an ERP system that provides solutions for marketing, Finance, CRM and customer experience, Supply Chain Management, Human Resources and Business Technology. It will be mainly used for Marketing support in the company, providing omnichannel engagement with the customer and marketing planning and management strategies. Workday ERP (Transaction Processing, Rented): Workday ERP is a unified SaaS software system for finance, human capital management (HCM), planning, professional services automation, project management, analytics, and business intelligence. It will help the company by automating financial and accounting processes, streamlining the overall sales process and reducing fixed costs. DocuSign (Transaction Processing, Rented): is a platform that allows automating the entire agreement process, from document generation and negotiation to contract lifecycle management and electronic signature. It will help the company to reduce drastically the time of legal and financial transactions, managing automatically all the agreement lifecycle. Moreover, is already pre-integrated with AP and Workday. 3D Printing Application: it is an enterprise application developed by the company that will manage all processes regarding research and innovation in 3D printing technologies. Since this area is our differentiator, we will invest to create it in-house so we can adapt its functionalities to the companys particular business requirements. It will integrate with E2Open to improve manufacturing efficiency and cost reduction. 5 Business Intelligence Software (IBM) CRM Software (SugarCRM) SCM Software (E2Open) Marketing Automation Software (SAP) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Customer Awareness X X X Customer Service Customer Support X X CRM X Sales Customer Payments X X X Selling Chain Management X X X X Purchasing X X X X X Customer Order Processing X X X X 6 Application Matrix Year 5 Business Intelligence Software (IBM) CRM Software (SugarCRM) SCM Software (E2Open) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Production Raw Material Purchasing X Engineering/Management X X Raw Material Inventory X CAD/CAM X Research and Innovation Research and Development X X Innovation and Applied Research X X Logistics Product Lifecycle Management X QA X Supply Chain Management Procurement X Scheduling X Monitoring and control X X Warehousing and Distribution Fulfillment X Shipping X Finished Goods Inventory X Finance and Accounting Finance  X Accounting X In Year 5, the company will continue to grow by opening three more stores in the United States. Additionally, it will invest in reallocating resources in R&D and Innovation and unify the CRM systems. The strategical focus will reside on automating customer service and support processes, reducing time to resolution, and promoting cross-functionality across the EAPs. The company will take advantage of the SugarCRM Marketing product suite, eliminating the dependency on SAP and reducing fixed costs without loosing functional capabilities. SugarCRM will manage sales automation and marketing processes from Year 5, integrating with IBM Cognos to leverage its analytics toolset. The rest of the EAPs will remain the same, and the company will continue investing in the in-house development of 3D Printing technologies system. 7 Business Intelligence Software (IBM Cognos) CRM Software (SugarCRM) SCM Software (E2Open) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Store Operations Customer Assistance X Store Management/Operations X Product Inventory X Corporate Corporate Planning X X X Business Intelligence X Knowledge Management X Enterprise Purchasing X X Business Monitoring and Control X Human Resources Payroll X Hiring X X Legal Contract Approvals/Renewals X X Counseling X Information Technology Online Orders and Processing X X X Customer Service and Assistance X X Product Information X X Marketing Research X X Promotions X E-store fronts X X X 8 Business Intelligence Software (IBM) CRM Software (SugarCRM) SCM Software (E2Open) 3D Printing In-house System Finance and HR Management (Workday ERP) Contract Management Software (DocuSign) Customer Awareness X X X Customer Service Customer Support X X CRM X Sales Customer Payments X X X Selling Chain Management X X X Purchasing X X X X X Customer Order Processing X X X X 9 You attended a conference on Mobile Apps that claimed “ Mobile Apps Can Do Everything”.  To prove this claim right or wrong, redraw your Long Range Planning Matrix  but use Mobile Apps from Android, IPhone or other suppliers to determine if you can support your entire business with Mobile Apps. Give your conclusions in two sentences (max). Also, IoTs and Cyber-physical systems (e.g., robots and drones) are becoming very popular. Can you find places for these technologies in your Application Matrix.  Mobile App and IoT Strategy 10 Application Matrix Year 3 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) Marketing Software (Facebook Pages Manager) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Production Raw Material Purchasing X Engineering/Management X X Raw Material Inventory X CAD/CAM X Research and Innovation Research and Development X X Innovation and Applied Research X X Logistics Product Lifecycle Management X QA X Supply Chain Management Procurement X Scheduling X Monitoring and control X X Warehousing and Distribution Fulfillment X Shipping X Finished Goods Inventory X Finance and Accounting Finance  X Accounting X In Year 3, since our strategy is to gradually expand across the nation, it may be somewhat difficult to support the entire business through mobile applications, but not impossible. We need to ensure that our 3D printing technology is up-to-date with the AutoCAD software, and if we can send our final designs straight to our warehouse so they can be printed. With our ERPs such as Finance and HR Management, Contract Management Software, Marketing, and Business Intelligence, a lot of mobile applications already exist which we can utilize to run our business online through our apps.  11 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) Marketing Software (Facebook Pages Manager) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Store Operations Customer Assistance X X Store Management/Operations X X Product Inventory X X Corporate Corporate Planning X X X Business Intelligence X Knowledge Management X Enterprise Purchasing X X X Business Monitoring and Control X Human Resources Payroll X Hiring X X Legal Contract Approvals/Renewals X Counseling X Information Technology Online Orders and Processing X X X X Customer Service and Assistance X X X Product Information X X X Marketing Research X X Promotions X E-store fronts X X X Regarding the applications selected: Power BI App: it is a business analytics service that provides users to be able to create reporting and dashbaords, which can help us monitor data. The company can identify their targets from the raw data, and make decisions to support the business accordingly. ZoHo App: is a cloud software suite, providing a complete CRM platform, and providing marketing services and human resource solutions as well. When engaging with customers, this is a platform that can help support our company. Facebook Pages Manager: is our form of marketing that we can use for our customers, so if they have any queries or need customer service help, questions can go through there and we can help. ADP App: can help us with our payroll, HR and Tax Services. We can use the HCM services provided by them to be able to monitor our income. DocuSign: is a platform that allows automating the entire agreement process, from document generation and negotiation to contract lifecycle management and electronic signature. It will help the company to reduce drastically the time of legal and financial transactions, managing automatically all the agreement lifecycle. Moreover, it is already pre-integrated with Workday. AutoCAD APP: this application will help our company to manager the 3D printing technology aspect, where we can also design our products and adapt its functionalites accordingly. 12 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) Marketing Software (Facebook Pages Manager) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Customer Awareness X X Customer Service Customer Support X X CRM X Sales Customer Payments X X X X Selling Chain Management X X X X Purchasing X X X X X Customer Order Processing X X X 13 Application Matrix Year 5 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Production Raw Material Purchasing X Engineering/Management X X Raw Material Inventory X CAD/CAM X Research and Innovation Research and Development X X Innovation and Applied Research X X Logistics Product Lifecycle Management X QA X Supply Chain Management Procurement X Scheduling X Monitoring and control X X Warehousing and Distribution Fulfillment X Shipping X Finished Goods Inventory X Finance and Accounting Finance  X X Accounting X X In Year 5, the company will continue to grow and by this point, running the business using mobile apps seems like a good idea, as more applications are available and we have actually consolidated some of our EAPs (for example, previously, we were using Facebook for our marketing efforts, but we have learned that ZoHo provides a marketing feature, as well as Human Resources solutions).  The rest of the EAPs will remain the same, and the company will continue to use Power BI through an app, along with AutoCAD for the 3D printing feature. 14 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Store Operations Customer Assistance X X Store Management/Operations X Product Inventory X Corporate Corporate Planning X X Business Intelligence X Knowledge Management X Enterprise Purchasing X X Business Monitoring and Control X Human Resources Payroll X Hiring X X Legal Contract Approvals/Renewals X Counseling X Information Technology Online Orders and Processing X X X Customer Service and Assistance X X X Product Information X X Marketing Research X X Promotions X E-store fronts X 15 Business Intelligence Software (Power BI App) CRM Software (Zoho App) SCM Software (ZoHo App) 3D Printing (AutoCAD App) Finance and HR Management (ADP App) Contract Management Software (DocuSign App) Customer Awareness X X Customer Service Customer Support X X CRM X Sales Customer Payments X X X Selling Chain Management X X X Purchasing X X X X Customer Order Processing X X 16 Part B: Technology Plan 17 Computing Platforms client devices – example: phones, pcs Internet Computing platforms: The computing platform is something which enables to run the computer system w​ith the help of process, operating systems with relevant run time librabries and end users. Computing platforms has got various capabilities, price ranges right from various devices to advanced computers so that different user needs and data processing workloads can be addressed. 18 Cloud Computing Strategies: The company could opt to utilize public cloud as a cost saving mechanism, and ease of access through multiple devices in different locations. Cost reduction can be achieved through renting of cloud space and services instead of owning a server. Also, technical staff working online can cut the cost of having staff placed in various locations. Business processes computed over the cloud could rely on SaaS providers. Example of services that can be undertaken include Marketing, Human resource management, purchasing, warehouse management, research and development, operations monitoring etc. Advantages of Cloud Computing: ●Reduced capital and operating costs as organization only pays for the required capacity. There’s an option of temporary purchase of additional disk space when need arises ●There’s flexibility in accessing new technology without high cost risks. It is also easy to revert back to previous technology if the new way isn’t working properly. ●Using cloud computing favors both large and small business. The versatility is good for scaling, whereby the company utilizes the pay-per-use model ●Using established cloud service providers with better security experience increases data safety as opposed to relying on in-house security in cases of small companies.  Computing Platforms There are list of benfits utilizing cloud computing 1. Cost effectiveness 2. Secu​rity towards the data management. 3. Continous availability 4.Spontinous 5.Scalability 6. Enhancement in the productivity 7. Better Performances. 19 Computing Platforms Emerging computing technologies - Quantum Computing: ●Quantum computing is fairly still a new technology, and there are a lot of uncertainties regarding its execution in business. Nevertheless, it can be used in advanced cryptography for security of virtual assets for the company e.g designs and other information (Klint, 2021).  ●Advanced data analysis is possible through quantum computing. For instance enormous amount of data can be analyzed using computation models that aren’t possible to sustain with digital processing. Pattern matching can allow the company to predict forthcoming trends (Klint, 2021).  The functionality of Quantum computing is to do calculations on the objects state before it is measured. The quantam computing is something related to artificial intelligence where the systems can be utilized for creating virtual environment which can enhance the process rapidly with less expensiveness. The method will also enable the research with latest enhancements. 20 A conceptual model of databases diagram.  Databases CRM customer_id first_name last_name age gender city state phone_number email Orders order_id custumer_id product_id unit_price total_sale status_code order_date payment_date Suppliers supplier_code supplier_name product_cost Warehouse  product_id quantity date_from product_type_code product_price supplier_code units_sold category_id Distribution order_id date_reported route_id delivery_status shiper_name Customer This database model is focused on what data is needed and how is organized instead of what operation will be performed on data.  Moreover, the main objectives of using this database are: 1-  Guarantee that all data objects required for our business model are represented. 2-  Be able visualize the database at the conceptual level. 3- This database structure helps to determine  the relational tables, primary and foreign keys and stored procedures. 4-  to help to have a clear picture of the database, thus, be used by database developers to create a physical database. 5-  it will help to identify possible missing or redundant data. Regardless the time spent during the creation of  this database , the results will make the IT infrastructure cheaper and faster. (Taylor, David 2021) 21 List 10 database queries (first in English and then in SQL) that the company will use most commonly with these databases.   1- Calculate the revenue SELECT SUM(amount) from(total_sale) 2-  All sales that occurred on the beginning fo winter in the USA SELECT * from orders WHERE DATE (order_date) = 2021-12-21 3- The whose sale that occurred during winter SELECT * from orders WHERE DATE (order_date) BETWEEN 2020-12-21 AND 2021-03-20 4 – When we want to restrict only the 10 best days result, after the 50 result SELECT * FROM total_sale ORDER BY order_date DESC LIMIT 10 OFF SET 50; 5- Select each date and the total amount of all payments made on that date from the order table SELECT DATE (payment_date), sum(total_sale) from orders GROUP BY (payment_date); 6 –  Select each date and total amount of payments made on that date from the orders table , and then order them in decending order SELECT  DATE (payment_date), as PaymentDate, SUM(total_sale) as Total from orders GROUP BY desc Databases This slide illustrates the most common SQL queries that will be used by Connies Clothing Store. The queries used in this presentation will support managers to identify possible opportunities or problems in their operations. For instance, query number 3 will help managers to analyze the whole sales numbers during the winter, which is the most important season for the company. Those, outputs provided by queries will help analyses if the company reached its goals or achieved profitability. 22 List 10 database queries (first in English and then in SQL) that the company will use most commonly with these databases.   7 -  Analise the cities that selling the most SELECT COUNT(city), AVG(total_sales) as Avg_sales FROM order GROUP BY total_sales; 8-  Analise the that are selling the most SELECT COUNT (state), AVG(total_sales) as Avg_sales FROM order GROUP BY total_sales;  9- top 10 product sold by unit sold SELECT * FROM unit_sold, product_id ORDER BY unit_sold DESC LIMIT 10; 10- top 10 categoty by unit sold  SELECT * FROM unit_sold, category_id ORDER BY unit_sold DESC LIMIT 10; Databases 23  Business intelligence, Big Data and Data Warehouse  Architecture Databases ERP CRM Databases External Sources Data Integration and ELT tools Structured Data Semi-structured Data Unstructured Data Big Data Reporting Tools Interactive Dashboard Ad Hoc Report Data Warehouse Structured Data The main aspect of Business Intelligence is to supply businesses with actionable insights that will help decision-making. Furthermore, the critical part of BI implementation includes the following technologies, such as data source, ETL, Data Warehouse, Online Analytical processing cubes, Data Marts and Reporting BI tools. The data warehouse is the core element of this BI architecture. The data warehouse maintains the information predefined format, structured,  classified, and purged of errors. Because the data is not preprocessed, will be necessarily ETL tools or data integration tools that will process the raw data from the initial sources and send it to a warehouse in three consecutive steps called data extraction, data transformation, and data loading. The Big data in this architecture is the data in the enormous form on which technologies can be applied. On the other hand, the data warehouse is the collection of historical data from different operations in an enterprise. Moreover, Big data is technology to store and manage a large amount of data. Differently, the warehouse is an architecture to used to organize the data. Furthermore, big data can handle all kinds of data from unstructured and structured. However, the data warehouse can only take structured data as an input. Besides, Hadoop will be used to better handle the enormous amount of data at Big data. Nevertheless, the data warehouses can not handle an enormous amount of data. Finally, the company will have Apache Hive on the top Hadoop, providing data summarization, query and analysis.  24 The network (LAN, WAN, wireless) that will interconnect the computers.   Networks and the Web Technologies Home Office Central Branch Internet Cloud LAN WAN This slide illustrates the path that a message takes from source to destination can be as simple as a single cable connecting one computer to another or as complex as a network that literally spans the globe. This network infrastructure is the platform that supports the network. It provides the stable and reliable channel over which our communications can occur. The network infrastructure contains three categories of network components: End devices Intermediary devices Network media Also this slide exemplifies the most common network infrastructure that will be use by Connies Clothing Store Local-area network (LAN): A network infrastructure that provides access to users and end devices in a small geographical area. Wide-area network (WAN): A network infrastructure that provides access to other networks over a wide geographical area. 25 Some technologies that are company would consider using are:  HTML5 and CSS React Python and Django SQL Databases Jenkins and Docker for containerization Power BI and Splunk As far as security goes, we want to make sure that our website is secure to avoid hackers attacking us. Some strategies for that include using: Input validation Encrypting our data, especially when we are using web services and APIs to pull queries Authentication and access control Ensuring our hosting website is secured through SSL, and being able to implement HTTPS Constant quality assurance and testing, and being able to detect warnings as well so we can resolve them before it turns into an error Networks and the Web Technologies Some technologies that are company would consider using are:  HTML5 and CSS, React, Python and Django, SQL Databases, Jenkins and Docker for containerization, and Power BI and Splunk As far as security goes, we want to make sure that our website is secure to avoid hackers attacking us. Some strategies for that include using: Input validation Encrypting our data, especially when we are using web services and APIs to pull queries Authentication and access control Ensuring our hosting website is secured through SSL, and being able to implement HTTPS Constant quality assurance and testing, and being able to detect warnings as well so we can resolve them before it turns into an error 26 The high-level budget is $500k, with the following division: Information Technology – $200K SaaS infrastructure - $40K Databases and Data Warehousing-$60K Network Infrastructure - $30K Hardware - $70K Enterprise Applications - $300K IBM Cognos - $3.6K SugarCRM - $51K E2Open - $50K SAP -$50K Workday ERP- 20K Docusign - $24.9K Networks and the Web Technologies All the estimations have been done for one year, but IT costs and EAPs will vary depending on if they are purchased as a SaaS or as an on-premise/perpetual license solution.  In the estimate for IT infrastructure, we are considering spending most of the budget in required hardware and cover the computing costs with cloud-friendly systems: Enablers to support SaaS infrastructure with cloud providers such as AWS or Google Cloud, that support the web technologies mentioned previously and have pricing calculators available. The cloud infrastructure recommended for SMB for AWS …