Methods and system are disclosed that generate an execution schedule to optimize a transformation of business. In one aspect, from multiple tables residing in multiple databases and storing business data associate with multiple business management systems, dependencies between the tables may be determined based on attributes associated with the tables. When execution time for transforming business data exists, a decrease time algorithm or a critical path algorithm may be executed to generate execution schedule and to calculate processor idle times during the transformation of business data. Based on the calculated processor idle times, whether or not to execute a local optimization algorithm may be determined. Based on the determination, execution schedule that optimize the transformation of business data may be generated. The transformation of business data may be executed based to the generated execution schedule that optimizes a time consumed for transforming the business data in the tables.