Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Background: Minnesota Consulting Group

The Minnesota Computer Consulting Group (MCC) is a 50-person consulting services practice focusing on telecommunications and systems administration that includes Minnesota offices in Minneapolis, St. Paul, and Rochester. MCG has had some business opportunities in Wisconsin and Iowa and is considering branching out further within those states by adding offices in Madison, WI and Cedar Rapids, IA. Much of its project and ongoing account work, particularly in today's economy, has been in the medical hospital and health insurance industries.

As a telecommunications practice, MCC has assisted organizations in business and market planning, technological evaluations, and education for IT organizations that are looking to expand their own telecommunications infrastructure services and support. MCC began with technical specialists and, over time, an increasing amount of MCC business consists of auditing, governance, and business advisory activities.

MCCs published areas of expertise include the following:

Network Assessment
System Architecture Assessment
Risk Assessment & Business Impact Analysis
Information Technology Governance
System Administration Staffing
Minnesota Consulting Group: Key Personnel

Principal Consultant?Amy Smith
Business Process Consultant?Becky Fredrickson
Business Process Consultant?George Conrad
Sr. System Administrator?Dave Baker
Sr. Technology Consultant ?Mary Williams
Background: Central Medical Group

One of MCCs larger clients is the 560-bed Central Medical Group (CMG)?a not-for-profit managed health care organization that provides an entire spectrum of health care services, including health insurance, primary care, and specialty care. Along with a primary care facility and teaching hospital, physicians and affiliated staff travel to more than 60 satellite primary care clinics to provide medical coverage across a 15-county region in the state of Minnesota. CMG is affiliated with specialty clinics and medical networks for pharmacy, dental, and employee assistance counseling services. CMG is presently considering expansion into additional counties in Minnesota and may be interested in branching into Western Wisconsin and Northern Iowa to provide a broader range of coverage for its members. Their mission as a not-for-profit is to provide the community and regions that they serve with high quality, cost-effective, accessible health care.

CMG's IT department consists of about 70 people. The department is broken up into a Technical Services group and an Application Development group. Project managers, business analysts, and application developers are within the application development group. Software applications (primarily .NET and Informatica Data Warehousing) that are developed in-house are also supported by the same developers who built the applications.

Technical Services contains a database and applications team, infrastructure team, and quality control team each with a department manager. Quality Control consists of testing and defect management, test data management, and internal auditing/compliance. Infrastructure includes disaster recovery planning, desktop support, security, and data center management. Database and Applications consists of EDI coordination, database administration, data and code migrations, and application support for third-party purchased applications and tools. EDI coordination is an important role with claims processing and enrollment integration with 80 trading partners, 3,000 providers, secured transactions, and approximately 5 million electronic claims per year.

From CMGs perspective, Minnesota Consulting Group handles telecommunications installation, after hours support to handle telecommunications issues, and staff augmentation to support the infrastructure team by adding resources for special, unstaffed data center or disaster recovery projects. Staff augmentation can also provide support coverage for 2-3 months when staff turnover occurs. Minnesota Consulting Group has provided these services for 3 years through an annual support contract along with statements of work for project and staff augmentation. As CMG IT staff gains expertise and additional personnel, an annual evaluation is held to determine whether or not to renew MCC services for the following year. MCC won this work through a competitive bid process, and Central Medical Group is not looking to replace MCC with another vendor but may bring those services completely in-house as CMG continues to grow and mature.

CMG's IT Department: Key Personnel for this Scenario (out of 70 people)

VP of Technology?Fred Moore
Director of Technical Services?Brian Walters
Manager of Database/Applications?Jim Hanson
Lead Database Administrator?Diane Lau
Manager of Infrastructure?Julie Nelson
Lead System Administrator?Toby Johnson
External Forces Driving Projects

Regarding governance, risk, and compliance, both MCC and CMG have been recently focused on Information Technology Infrastructure Library (ITIL) policies and HIPAA 4010 compliance. However, CMG is taking steps to prepare for the National Association of Insurance Commissioners (NAIC) Model Audit Rule (MAR) compliance in 2010. Model Audit Rule is similar to the Sarbanes Oxley Act with an expanded focus on key business process controls, general computer controls, and the financial reporting process.

Both organizations are adding additional resources in the areas of governance, auditing, and process redesign for compliance. HIPAA 5010 updates are planned for 2009 and ICD-10 updates planned for 2010. State government programs and mandates also create business opportunities along with operational challenges to responding to those mandates. CMG is systematically improving its internal processes and is looking to be more proactive than reactive in handling work assignments around infrastructure improvements.

Infrastructure, Network and Application Architecture

Medical claims processing and insurance operations is the most dynamic part of the operation, and we will focus our time on those areas. The primary database platform is primarily Oracle running under AIX with some SQL Server running under NT based on third-party application purchases that only run under NT. Application and Web servers are NT servers with VMware (roughly 50 processors) running under Microsoft Windows. VMware has demonstrated some clear advantages for this organization, but one of the challenges with VMware is that SQL Server software vendors want to run their application on their own hardware instead of a virtual machine. A storage area network (SAN) environment is used to provide direct access storage at about 3,000 Gb, and it is operating at near (85%) capacity.

The current environment consists of Development (sized at about 30% of production), Disaster Recover /Operational Recovery servers, and Production servers. The business area consists of about 300 Wintel desktop and laptop computers. The VP of Technology is interested in replacing AIX with Linux and is considering some proof of concept projects to evaluate that option.

Project Overview

You are a principal consultant for Minnesota Consulting Group, and this is your first assignment where you will be responsible for the entire client engagement. The environment is consultant friendly but dynamic with frequent organizational and business changes. CMG is a growing organization and staff reductions are not being discussed so morale is high. However, 25% of the technical services department has been with CMG for less than 1 year due to that growth. The training budget is respectable and everyone has typically 5-10 days annually planned for training. Process improvements and document management could be expanded to help the teams handle the increased business volume, an increasing need for governance, and the expansion of individual and team responsibilities.

The organization has some plans to become even more diverse with a tentative acquisition of a pharmacy benefit plan system. Discussions are at the preliminary stages, but this could provide integration opportunities along with the potential to sell ownership shares of a pharmacy benefit plan to other regional nonprofit entities that did not provide pharmacy benefits to their members.

CMG is also considering expansion into other markets, and its current environment and infrastructure may not be sized appropriately to handle an increase in both staff and membership that a new market would bring. Direct growth through acquiring another smaller medical claims and insurance entity is not currently being considered, but the management team is open to the possibility if the right opportunity became available. Again, this organization is not-for-profit, but it is run in a business-like manner regarding cost containment and providing quality service for CMG members. Geographical growth is a part of the organization's long-term goals and objectives to extend services to those members.

Assignment:

In this assignment you will be in the role of Dave Baker, Senior System Administrator, Minnesota Consulting Group

Outside research is strongly recommended, and diagrams would be helpful to improve understanding and to help explain your recommendation.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91621132
  • Price:- $30

Priced at Now at $30, Verified Solution

Have any Question?


Related Questions in DBMS

Question team project submission - submit to the unit 4

Question: Team Project Submission - Submit to the Unit 4 Group Project Area This version of the capstone project assignment is FOR GRADING this week. Submit to the group area the document containing completed Sections On ...

Question talk about the importance of pulling data from

Question : Talk about the importance of pulling data from worksheets into a single sheet also the ways excel could be a solution to a complex challenge. The response must be typed, single spaced, must be in times new rom ...

Question a suppose you are a marathon runner that can run a

Question : a) Suppose you are a marathon runner that can run a maximum of n miles on a single bottle of water. You are given a map of your marathon route with all the water stations marked. Design an efficient algorithm ...

Database design amp development assignment -assignment

Database Design & Development Assignment - Assignment title - Design and Implement a Relational Database for a local Print and Ink Refill Business. Learning Outcome - Use an appropriate design tool to design a relational ...

Case study problem 1 the case study company has experienced

Case Study: Problem 1 The case study company has experienced rapid growth in both the size of its client base and also in the services provided to clients. Unfortunately, the growth in data management policies, procedure ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

Sql transactions exercisesconsider table itemnameprice

SQL Transactions Exercises Consider table Item(name,price) where name is a key, and the following two concurrent transactions. T1: Begin Transaction; Update Item Set price = 2*price Where name = 'pencil'; Insert Into Ite ...

Solve the following questions using oracle you are not

Solve the following questions using Oracle. You are not allowed to use the syntax of any DBMS other than Oracle. Make sure to upload an electronic copy of your solution to your CSC335 TRACE folder. Name the file hw4.sql. ...

Question create an erd for the following scenarioa small

Question: Create an ERD for the following scenario. A small company ABC wants a database to keep track of internal company information. Â Given the following information create an ERD. The ABC Company has several departm ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As