Designing Formal Reports and Analyzing the Recruitment and Hiring Process

Designing Formal Reports

From the above database, design formal reports, with appropriate headings, according to the requirements above. Each report will be on a new page and will contain some data from the above
database in appropriate format.i) (10) Design the output (including layout and information details) for one (1) operational report*and one (1) managerial report*.
* In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions.
ii) Describe (point form) each of the two types of reports in terms of how the information is used to support the decisions by each level of management.
b) (5) Assume these reports (from (a) above) are used as input to an executive information system. Provide examples of the types of decisions made by this level of management. What additional insights
could be derived from this information at this strategic level of reporting? Consider both hard data andsoft data. Explain clearly , using examples, what the specific hard data and soft data would be and how
the data would be used.Refer to Lecture Outline 3, slides 26 – 56 for examples of reports
2)  Now consider you are the business analyst for the HR Department of PowerSalesCo. You have been asked by the company CEO to review the Recruitment and Hiring process as part of the company's Human Resources Information System (HRIS). The following detail process map and modeling diagram using Business Process Modeling Notation (BPMN) has been developed and documented by a third-party consultant. The processes include:
a) Advertise for the Position
b) Source and Screen Applicants
c) Hire the New Resource
i) Review all three processes of the Recruitment and Hiring (above) including the Detail Process Map for Recruiting and Hiring (See Page 5). Utilize the BPMN* template to map the processes as part of your
analysis. Identify the specific tables in the HRIS DBMS that are impacted by the process step. Write a brief narrative using Business Process Narrative approach and annotate (by underlining) the key  procedures as part of the current As Is process.
ii) Consider designing a new online Recruitment and Hiring program module as part of PowerSalesCo`s HRIS to reduce the number of process steps (hand-offs) required to: Advertise; Screen and Interview
Applicants; and Hire New Resources. The proposed automated changes should address improvements across all three process areas as part of an overall solution. Refer to the following White Paper titled Talent Management Best Practices for an overview of future trends in Recruitment and Hiring systems.Write an executive report, 1 - 1.5 pages, 12 pt font, normal margins, using Business Process Narrative approach, describe your recommended changes to the documented steps/ processes that could be improved through automation to meet the proposed solution and what would be the opportunities/ advantages to the business. Annotate (by underlining) the key automated procedures that you have introduced as part of your recommendations in your report. Be sure to cross-reference your  improvements to the existing process steps as a way of showing and comparing the value-add.Hint #1: Consider the number of steps and connection points with the different database tables that are  used to update the information within each of the three main process areas. Is there any way that the processes could be reduced by having the system do more functional processing at certain key points in the cycle - and thereby reduce the number of handoff/procedural steps within each process area?
Hint #2: Consider the relationship between the three main process areas. are there ways that the process steps/handoffs between the three main areas could be simplified?
* A Business Process Map Notation (BPMN) Organizer template has been provided for your analysis and documentation of the key processe