ETL( Extract Transform Load)

Question

Hello Friends,
                 Today i have a bit of difficult problem. I have to code an ETL tool. Which will basically Extract data from a database file. Then after extraction i have to perform certain Transformation on that data to bring it into standardized format. The main task is to transform data. Can please you people suggest me the logic that i should perform to accomplish the task. The described statement file is attached below.
        Regards
                        Zeb