| Working Item | Yuhuang Li | Jian Guo |
Phase 1 | Performed the initial research and analysis of the general data importing secenarios of Cognos controller data transfer process | X | |
| Setup the basic data transfer file format requirement | X | X |
| 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 2 | Test and setup the standard procedure, requirement and template of Account Mapping between Great Plains and Cognos Controller | | X |
| Tested and designed the data model of Account mapping, ETL process to load and refresh the Account Mapping | X | X |
| 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 controller | X | |
Phase 3 | Investigated 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 4 | Performed tests on the ETL logic and tried to find data quality issues. | | X |
| Made analysis on the data issues. | X | X |
| 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 5 | Discovered 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 feature | X | |
Phase 6 | Tested the user access quality, proposed the further access requirements. | | X |
| Design, implemented the front end supporting system and test. | X | |
Phase 7 | System Integration test. | | X |
| Performance evaluation, test and tunning. | X | |