SR-ED: Description of the work of employees

	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