Systems Analysis
Essays

In evaluating the current field of database administration, the areas of Database Management Systems (DBMS), Database Administrator (DBA) roles and responsibilities, the concepts of database designs, performance of…

In today's world of technology, it is imperative that you stay current with what is new in the IT world. What makes this particularly challenging is the pace of change in IT systems, and the continual need to make sure they align to a department, division and in the case of the City of Elizabethtown, an entire city. Never before has it been more critical for government municipalities to get the most value possible out of their IT investments. With continual budget costs and an orientation to judge investments purely on short-term cost reduction, investments in IT must be seen as atypical and worthy of much greater focus and effort to integrate the into municipalities. This is to first increase the value delivered, second to ensure the hard-earned taxpayer funds used to buy and upgrade equipment, operating systems, networks and applications are put to the best possible use, and third, to make absolutely sure they deliver the greatest value necessary in order for the City of Elizabethtown to get the greatest value. Those are the foundational elements of this proposal and the values it is based on. As the migration of 250 workstations across 10 departments and 5 locations has a budget of $100,000 and the performance gains possible from transitioning their operating systems form Windows XP to Windows 7 is expected to be significant, the cornerstone of this proposal centers on delivering excellent public service ultimately to the citizens City of Elizabethtown. As Microsoft has also recently indicated they will be permanently discontinue Windows XP support on April 8, 2014 according to the Microsoft website, the urgency to get this upgrade completed accurately, completely, and with precision is clear. It seems like every six months something new is coming out. While it is true you do not need every new gadget out there to stay current in the IT world, you do need the most recent operating system to ensure the compatibility, security, scalability and long-term Return on Investment (ROI) of IT spending. I work for the City of Elizabethtown as the Network Administrator. While a Network Administrator's job is mostly configuring and maintaining servers, I also manage all the workstations and make sure they are getting the most recent updates that are on the WSUS (Windows Server Update Services) server. I am also in charge of preparing budgets for these workstations and purchasing them. I have been with the City now for 5 years and we have running Windows XP SP3 on all workstations. With all the new threats out there and with Microsoft ending their commitment to support Windows XP in 2014 I have decided to upgrade to Windows 7. The reason I have decided to go with Windows 7 instead on the upcoming release of Windows 8 is simply because Windows 7 was released 2 years ago and most of the bugs and kinks are gone and there is stability in the program. Microsoft has also been able to get much greater levels of software support for their 64-bit versions of the Windows 7 Application programmer Interface (API). The current Windows 32-bit based applications on the XP systems throughout the city will eventually become obsolete, some as early as twelve months from now in 2013. The message is clear from Microsoft however; they have made Win64 API-based development a strategic priority, investing heavily in Independent Software Vendor (ISV) relations efforts with their strategic partners. Microsoft has also modified and improved the device drivers for Win64-based systems so that the network security, speed and precision are also significantly enhanced. While Windows NT, XP and Windows 7 are all based on the Windows NT Kernel shown in Appendix 4, Microsoft has greatly expanded the Windows 7 kernel to support a more multiplatform-based strategy than ever before. The Windows 7 kernel can be seen in Appendix 3. Microsoft will make a major announcement later this year with Windows 8 support for the Windows Phone, and will also seek to bring the Win64 API to the Apple iPad via Apple iOS 6. This Apple operating system will most likely bring Microsoft Office to the Apple iPad. Current discussions with Microsoft indicate that any servers running Windows 7 components will be able to support non-Microsoft devices. As the City of Elizabethtown begins to adopt smartphones and tablet PCs including the Apple iPad with increasing regularity, the IT department will need to also consider the platform requirements for supporting these devices. This tend in IT is called Bring Your Own Device (BYOD). Departments in City Hall, the Elizabethtown Police Department, Fire Stations, Gas Department and Public Works all could significantly increase the effectiveness of their workflows by integrating smartphones and tablet PCs into their workflows in the future. While these are not core requirements of this transition from Windows XP to Windows 7, 64-bit edition, it is another consideration that needs to be kept in mind. The transition from XP to Windows 7 will enable our IT department to better serve the entire city in the future and set the foundation for eventual adoption of mobile devices. It is not a matter of whether this will happen, only a matter of when. Another aspect of the transition of the 250 workstations is the versioning of their applications and the significant potential speed increase they can attain when they are migrated form Win32 to Win64-based versions. This speed increase has, according to Microsoft and its ISVs (development partners) been as high as 60% on calculation-intensive applications including Microsoft Excel, SQL Server and other database applications. This speed increase is due to the result of applications using memory more efficiently and also having greater support for multithreading, which is literally the ability to have an application complete several concurrent, even potentially conflicting tasks, at once. The transition from Windows XP to Windows 7 will certainly require a hardware upgrade for workstations, and if the architecture of the workstation cannot support the minimum requirements of the operating system, another will need to be purchased. This is also the case with software licenses for all applications that are today running in Win16-based API Mode, by far the most prevalent and popular API that Microsoft has developers supporting. To see where the Win16 API fits into the architecture of these operating systems please see Appendix 4, Windows NT Kernel Architecture. An application written to support the Win16 API will also run in Windows XP, Windows 7 and 8. As the kernel architecture shows in Appendix 2, Win32 APIs dominate the XP framework. Fortunately Windows has designed in Win16 to Win32 API migration and compatibility, and is working to ensure applications written on both of these standards will work with Windows 7 and beyond. What all this means for the upgrade of systems is that the planning steps need to pay very close attention to standardizing on Win64-based applications to gain the full performance boost form upgrading the systems with hardware to make them capable of running Windows 7. The hardware upgrades and fine-tuning will only be as valuable as the operating system-level and most importantly, application-based upgrades completed. In conclusion the primary goal of upgrading the systems to avert obsolescence needs to be balanced with potential to significantly increase and improve speed over time.

Online communities have emerged in recent years as a result of the rapid growth of the Internet, arousing intrigue in citizens, policy-makers and government officials. An online community is a group of people who…

¶ … systems analyst is unique in that its role is a hybrid one.

Alcan's growth as a global conglomerate in the aluminum and metal fabrication industry follows a similar trajectory of many companies whose business models forced rapid, highly distributed business models at the expense Information Technologies (IT) management systems consistency and performance. Alcan's IT management systems and underlying infrastructure have become balkanized as the company has grown into four separately functioning and highly autonomous business units. In evaluating the key success factors of successful Enterprise Resource Planning (ERP) implementations in multisite locations, the most critical factor overall is creating a unified, well synchronized system of record across all ERP instances (Hanafizadeh, Gholami, Dadbin, Standage, 2010). A second key success factor for multisite ERP implementations is the ability to negotiate a very low level of maintenance pricing with ERP vendors in the form of multisite or use-based pricing instead of the traditional per-seat model (Law, Chen, Wu, 2010). A third key success factor in the implementing multisite ERP systems is the ability to create a shared set of analytics, financial reporting metrics and measured of shared collaboration performance across all sites (Nour, Mouakket, 2011). Alcan has none of these best practices in effect during the time periods of the case study. They are conversely creating very high costs of maintenance for themselves, paying $500M in software costs and fees to SAP, tolerating up to 400 systems dedicated to just pricing alone, and attempting to manage well over 1,000 systems throughout the four divisions. As the company continues to grow and attempts to move into new markets where unifying all four divisions is necessary, they will find their IT systems are more of a liability than an asset in their current configuration. Coupled with the escalating costs of keeping each of the four divisions under maintenance with SAP, the ongoing high costs of integration, there is the threat of compliance violations to industry safety and quality requirements in addition to Sarbanes-Oxley Act (SOX) financial reporting requirements. All of these factors taken together point to the need for more effective IT management strategy that takes into account the critical success factors for ERP system integration in a highly decentralized organizational structure. The intent of this analysis is to evaluate the pros and cons of the current Alcan IT management system, in addition to evaluating the pros and cons of the new Alcan IT enterprise architecture as proposed by Robert Ouelette. The final section of the paper discusses if moving from the current Alcan IT management system to a new structure is advisable or not.

¶ … Strategy Theory and Actual Strategies Being Used in Small Insurance Companies

Of the many types of trade barriers there are that countries use for managing their balance of trade and protecting key industries, three specifically used by many countries are import duties, quotas, and tariffs.

The intent of this project plan is to comprehensively define the development process, testing, training, and introduction of an enterprise-class portal and series of enterprise content management (ECM) applications that…

¶ … intelligence unit that is secure and maintained at all times is an absolute necessity for operational reasons. Explain in detail why this is so important.

Learning Teams; Website Assigned Facilitator