Need Data Analyst Guy(repost)

Design a User Work flow for a Sales Department. Map the data elements from the example User Interface to the Database Model Detail and Provide Gap Analysis of data elements. The other system that we use is [url removed, login to view] so something similar would be good. You can log in on that web site and register for a trial account to see how it works. The attached file "Sales_Commission_User_Work_Flow" has a format for designing the work flow." You should have the ability to complete this request based on the examples provided and the files attached and knowledge of what typical sales commission databases and content management systems do. Specific technical specifications are not available. One way to approach this would be to take the database model detail file and map the data elements to the UI. So you would just take the UI Model Template and UI to Database Map from page 2 and copy those below one of the UI's, Home Page for example. Then map the elements on the UI to the template by enterring the UI text box name in the column name and the parent table name in the database model. And add a column to note UI elements that don't have a corresponding element in the database. And then do the same for the database back to the UI. And that would suffice for a GAP analysis for the data elements. Documents should confor to the Micfosoft Manual of Style for Technical Publications and Chicago Manual of Style

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

* * *This broadcast message was sent to all bidders on Tuesday Apr 29, 2008 3:16:57 AM:

Create Sales Commission Reports illustrated in the Reports Section of the attached Functional Specification Draft. There are some other parts of the specification that are still in process so those are just there for reference The examples of calculations and reports are included in the files attached and start in the Reports section of the Functional Specification. The calculations are modeled in excel in the attached file, RAC_Sales_Tracking_Calculation_Illustration.xls. 1. Document the objects on the reports like data elements, report headings, and selection criteria and show the calculations for summaries and commission reporting 2. Map the report objects to the data elements in the detail data model file. 3. Provide a Gap Analysis of data elements that need to be added to the data model. 4. Create the Reports in the attached application generated by ironspeed and update the database elements. RAC_Ironspeed_Generated_Application_TCSC_setup It is an installer file and will install the data base and asp.net pages. 5. Create a Reports Section on the Menu of the Application and attach the Reports to the Submenu. 6. Add an Admin section to the menu and add any report settings that need to be stored and updated by a sales manager or application administrator. 7. Update the installer package with the revisions.

## Platform

It is the simple data analyst work for persons who can perform the GAP analysis.

ASP JavaScript PHP

Project ID: #3896677

About the project