Resoures Needed
ETL Specialist:PL/SQL procedure, DWH & ETL knowledges (ETL tools skills are not required at present)
Cognos Specialist:Cognos skills, PL/SQL skills
(Other BI tools skills are also could be qualified, such as BO, Hyperion, Brio and Oracle BI EE(Siebel Analytics))
Project Brief
Phase 1
CRM Reports
Analysis, Design, Sys Set-up, Dev, SIT, UAT, Training
Planned Due Date
Release Package 1
KR, RA, RM and CRM Portal Reports
ETL, BI UI for 48 Business rpts (around 100 sub rpts)
5/30/2008
Release Package 2
CRM Cockpit Reports
ETL, BI UI for 3 Business rpts (around 10 sub rpts)
7/7/2008
Release Package 3
Conquest Straegy and Other CRM Reports
ETL, BI UI for 34 Business rpts (around 80 sub rpts)
7/22/2008
Phase 2
Sales Reports
Phase 3
After Sales Reports
Phase 4
Reports of other Business Department (TBD)
High Level Tasks for each Release Package in each Phase
Items
Stages
Documents in process
Remark
Business Analysis
Business Requirement Analysis
Function Specifications
For Call Center, Marketing, Sales
IT Architecture
Data Model Design
Technical Design
UI Design
Technical Specifications
Systems Set-up
Systems Set-up and Configuration
System Implement RequirementSet-up and Configuration Doc. with Q/A
DWH Creation (Dimention and Fact Tables)
ETL Development
Oracle 10g, Toad
Dev.
Report Development
Report TempleteUT (Test) Specifications
IBM Cognos 8.3
SIT
DWH and BI Reports SIT
SIT (Test) Specifications
UAT
DWH and BI Reports UAT
UAT (Test) Specifications
User Traning
Key-user and End-user Training
User Training Docs
KT
KT to support team
KT docs
Current RISKS and ISSUES in Phase 1 - Release Package 1
1. Timeline is so tied, cannot meet the dead line with current resources (only 23 weekdays for 100 rpts in Phase 1 - RP 1)
2. Lack of resources,for design, dev. & Testing, the workload is so heavy within planned timeline that we cannot finish it at all.
· workload for IT Architecture: 40 mandays (some parts have been done)
· workload for ETL Specialist: 60 mandays, at least needs 3 ETL Specialists
· workload for Cognos Specialist: 80 mandays, at least needs 4 Cognos Specialists
(And for the coming phases, the resources are also most critical factor for the project)
3. Business requirement is not clear, Business team has not provided business reqirement docs. Need to have meetings with business team to get the requirement, this at least needs 10 weekdays (2 weeks) before technical design.
4. Data Quality, there are 4 main data sources for DWH, some source systems are still in development process. And some data is even not from DB at all, which is stored in XLS sheets.It is difficult to make sure the data is correct.
5. Some Reports should not be included in DWH, such as some OLTP letters, should be sent in CRM OLTP system, it is not easy to meet the function requirement in Cognos
有意向者可直接发中英文简历给我或加我MSN
[email protected]
有兴趣的请msn加我详谈.
或者直接将简历以 姓名+期望工作城市 的标题发往邮箱
我将主动联系您
E-mail:[email protected]
|
