正文

SR-ED: Description of the work of employees

(2007-06-06 05:32:38) 下一個
Working ItemYuhuang LiJian Guo
Phase 1Performed the initial research and analysis of the general data importing secenarios of Cognos controller data transfer processX
Setup the basic data transfer file format requirementXX
Perform the test of the data transfer file format X
Performed lots of research on Great Plains fundation database to figure out the core data access logic to extract the necessary financial data from the fundation database of Great Plains.X
Tested core data access logic to extract the necessary financial data from the fundation database of Great Plains.X
Phase 2Test and setup the standard procedure, requirement and template of Account Mapping between Great Plains and Cognos ControllerX
Tested and designed the data model of Account mapping, ETL process to load and refresh the Account MappingXX
Designed and implemented the core data transfer process V1.0 using Informatica to load the financial data of a single company code into the flat file which meets the format requirments of Cognos controllerX
Phase 3Investigated the solution for LOOP logic to control the workflow in Informatica.X
Developed and setup  the standard configuration file and overall controlling script.X
Did some code adjustments on the ETL code to support the controlling process.
Version 2.0 of ETL was completed and the data transfer of multiple Company Code was supported.
X
Test on the new controlling process and ETL logic.X
Phase 4Performed tests on  the ETL logic and tried to find data quality issues.X
Made analysis on the data issues.XX
Implemented two error handling components in the ETL process to capture the data loading exception or trace the information about the errors in the mapping.X
Phase 5Discovered and proposed the support for Account Range feature.X
Setup a new standard and robust Account Mapping template and procedure which support Account Range functionality.X
Made adjustments on the ETL process to support the new Account Range featureX
Phase 6Tested the user access quality, proposed the further access requirements.X
Design, implemented the front end supporting system and test.X
Phase 7System Integration test.X
Performance evaluation, test and tunning.X

[ 打印 ]
閱讀 ()評論 (0)
評論
目前還沒有任何評論
登錄後才可評論.