Skills
2012/6-current
IBM China GDC(shenzhen)
Application Specialist(Cognos)
Work in IBM Global Area BI project,Cognos reports developing,database script developing.Modeling With Framework manager,Performance Tuning On Reports and Scripts.
2012/2-2012/7
Shenzhen Development Bank
Technical Manager
Lead a team(3 people) to create a data mart for Banking KPI Salary System
2010/4--2012/2
Kingdee software China
BI engineer(ETL)
Completion of the background design and development of the financial BI product involved in the field of BI project implementation.
2008/7--2010/4
Foxconn group
software engineer
Completion of the development and maintenance of multiple BI systems to participate in the entire software development life cycle: requirements analysis, documentation writing, cognos development, Web development, database design and development of the SSIS development, development of the SSAS, SSRS development.
IBM China GDC(shenzhen)
Application Specialist(Cognos)
Work in IBM Global Area BI project,Cognos reports developing,database script developing.Modeling With Framework manager,Performance Tuning On Reports and Scripts.
2012/2-2012/7
Shenzhen Development Bank
Technical Manager
Lead a team(3 people) to create a data mart for Banking KPI Salary System
2010/4--2012/2
Kingdee software China
BI engineer(ETL)
Completion of the background design and development of the financial BI product involved in the field of BI project implementation.
2008/7--2010/4
Foxconn group
software engineer
Completion of the development and maintenance of multiple BI systems to participate in the entire software development life cycle: requirements analysis, documentation writing, cognos development, Web development, database design and development of the SSIS development, development of the SSAS, SSRS development.
Project history
ime Period 2011/9--2011/12
Project Name Zhejiang Transfar BI Development Tools Oracle 10G, Cognos 10, Informatica8.6, vss, Powerdesigner
Hardware Environment Software Environment Windows 2003
Project Description the project is based on the financial BI products and customized secondary development of the completed project. The development of customized content based on customer needs fine-tuning of the model, new customers demand model in the product, customer special industry KPI, such as: chemical manufacturing KPIs.
Responsibility (1) model modifications and ETL process to modify
(2)Report new and original statements to modify
(3)Environment configuration and build
(4)Statements and related technical training
Time Period 2011/9--2011/12
Project Name Kingdee contract management Development Tools Oracle 10G, Cognos 10, Kettle 4.0 vss, Erwin
Hardware Environment Software Environment Windows 2003, Win7
Project Description Kingdee Group ERP sales contract. This project is to analyze the contracts and the implementation of the agencies Kingdee Group's ERP products, the completion of the project contract time. Profit and loss for each contract. Synchronization contract MOP, financial ERP, such as receivables, system data, integration of financial, sales organization differences in the analysis of the entire group project to provide data support for the CEO decision-making.
Responsibility (1) to analyze business requirements and model implementation
(2)Analysis of the logical structure of the business systems and data extraction
(3)Guarantee the quality of the data and write the data quality report
(4) database and component data backup
(5) data processing performance tuning
Time Period 2011/3--2011/8
Project Name Daye Special Steel BI project Development Tools Oracle 10G, Cognos 10, the data Manager, vss, Erwin
Hardware Environment IBM p5 570 Software Environment Windows 2003, Win7
Project Description business sales, distribution system, the BI. Sales distribution of various aspects of data analysis and decision support, based on the sales department at Headquarters and branch order, branch to submit an order, the headquarters of a unified inventory order management, collection and delivery. Aging monitoring, regional, seasonal variations in customer orders, and compared with BI implementations of each process. Performance and budget of the regional companies to reach.
Responsibility (1) project risk control and project node control
(2) and the communication needs of the model structures
(3)Analysis of customer ERP systems, document data processing logic
(4) data processing performance tuning
(5)Guarantee the quality of the data and write the data quality report
(6) etl output logic detailed design document
Time Period 2010/10--2010/11
Project Name Haipu system cover project Development Tools Oracle 10g, 'pentaho the Kettle 3.2, vss
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description Finance BI products, the association of human resource, part of the production module BI development.
Responsibility Financial BI product implementation of the deployment, field data processing, report to show the test to solve environment, data, reports and other issues that may arise. The four integrated customer data center to achieve organizational unity Group data analysis.
Time Period 2010/9--2010/9
Project Name Chu Kong Shipping Project Development Tools SQL Server 2005, Microstrategy, 9, Kettle 4.2
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description Finance BI implementation. Consolidated project financial analysis, financial KPIs, KPIs increase the shipping industry.
Responsibility Financial BI product implementation of the deployment, field data processing, report to show the test to solve environment, data, reports and other issues that may arise.
Time Period 2010/5--2011/3
Project Name Kingdee Financial BI Development Tools Oracle 10G, Cognos 10, the Kettle 4.0, vss, Powerdesigner
Hardware Environment Software Environment Windows 2003
Project Description EAS Kingdee own ERP product, based on the BI of the EAS development financial analysis of standard products. Kingdee ERP general ledger consolidated module for data integration and through the vertical analysis, analysis of the Corporation's financial health degree from the combined data to the general ledger and a breakdown is also added to the classic model of financial analysis such as: EVA, five force, and DuPont.
Responsibility (1) analysis of the general ledger business processes and logic
(2) to identify and verify ledger incremental data extraction
(3) model and database structure of the data warehouse structures
(4)Financial kpi indicators system to calculate the
(5) configuration with the safety of business communication and data isolation
Time Period 2008/7--2010/4
Project Name Foxconn bi developed Development Tools Cognos 8.4, the VS2005, the SQL Server2005, SQL Server Analysis Service 2005, SQL Server Integration Service
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description 2009/03 - 2010/04: the JIT-KPIs management system
Project Description: Foxconn new JIT warehousing within the park, on the organization, the supplier's order analysis, significantly reduce the aging of the JIT warehouse through BI analysis, the tremendous increase in storage utilization.
2009/05 - 2010/04: proposals to improve the analysis
Project Description: Group IE project proposals to improve project implementation and assessment of the benefits analysis. Effective assessment through the use of the BI analysis, the benefits of the IE project life cycle, greatly increasing the effectiveness of the IE project and project control.
2009/07 - 2010/04: fixed assets
Project Description: The analysis of the Group's fixed assets, the depreciation rate of sector assets.
2009/05 - 2010/04: VMI-HUB the BI system
Project Description: purchase to accept orders for shipping process limitation
2009/05 - 2010/04: the JIT-feeding on Aging
Project Description: supplier inventory aging analysis
Responsibility The person in charge, needs analysis, project development, project support, the increasing demand of maintenance.
Time Period 2008/7--2010/4
Project Name Foxconn bi for Supported Development Tools Cognos 8.4, VS2005, SQL Server 2005, the SQL Server Analysis Service 2000, dts
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description 2009/3 - 2010/04: Central Personal Data BI systems
Project Description: Group Mainland China Human Resources
2008/10 - 2010/04: CNSBG-CEM/NWE BI systems
Project Description: CNSBG two Division inventory, revenue, accounts receivable, budget and other information analysis)
2009/03 - 2010/04: Central administered by management profit and loss system
Project Description: The system is responsible for project support, the increasing demand of maintenance.
2009/07 - 2010/04: Data analysis of the FIH administered
Project Description: Foxconn Group member companies FIH part of the financial analysis
2009/06 - 2010 04: Card System
Project Description: Analysis of Park 30W staff dining density, dining hours distribution and reasonable arrangements for the dinner.
Responsibility the system is responsible for project support, the increasing demand of maintenance.
Project Name Zhejiang Transfar BI Development Tools Oracle 10G, Cognos 10, Informatica8.6, vss, Powerdesigner
Hardware Environment Software Environment Windows 2003
Project Description the project is based on the financial BI products and customized secondary development of the completed project. The development of customized content based on customer needs fine-tuning of the model, new customers demand model in the product, customer special industry KPI, such as: chemical manufacturing KPIs.
Responsibility (1) model modifications and ETL process to modify
(2)Report new and original statements to modify
(3)Environment configuration and build
(4)Statements and related technical training
Time Period 2011/9--2011/12
Project Name Kingdee contract management Development Tools Oracle 10G, Cognos 10, Kettle 4.0 vss, Erwin
Hardware Environment Software Environment Windows 2003, Win7
Project Description Kingdee Group ERP sales contract. This project is to analyze the contracts and the implementation of the agencies Kingdee Group's ERP products, the completion of the project contract time. Profit and loss for each contract. Synchronization contract MOP, financial ERP, such as receivables, system data, integration of financial, sales organization differences in the analysis of the entire group project to provide data support for the CEO decision-making.
Responsibility (1) to analyze business requirements and model implementation
(2)Analysis of the logical structure of the business systems and data extraction
(3)Guarantee the quality of the data and write the data quality report
(4) database and component data backup
(5) data processing performance tuning
Time Period 2011/3--2011/8
Project Name Daye Special Steel BI project Development Tools Oracle 10G, Cognos 10, the data Manager, vss, Erwin
Hardware Environment IBM p5 570 Software Environment Windows 2003, Win7
Project Description business sales, distribution system, the BI. Sales distribution of various aspects of data analysis and decision support, based on the sales department at Headquarters and branch order, branch to submit an order, the headquarters of a unified inventory order management, collection and delivery. Aging monitoring, regional, seasonal variations in customer orders, and compared with BI implementations of each process. Performance and budget of the regional companies to reach.
Responsibility (1) project risk control and project node control
(2) and the communication needs of the model structures
(3)Analysis of customer ERP systems, document data processing logic
(4) data processing performance tuning
(5)Guarantee the quality of the data and write the data quality report
(6) etl output logic detailed design document
Time Period 2010/10--2010/11
Project Name Haipu system cover project Development Tools Oracle 10g, 'pentaho the Kettle 3.2, vss
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description Finance BI products, the association of human resource, part of the production module BI development.
Responsibility Financial BI product implementation of the deployment, field data processing, report to show the test to solve environment, data, reports and other issues that may arise. The four integrated customer data center to achieve organizational unity Group data analysis.
Time Period 2010/9--2010/9
Project Name Chu Kong Shipping Project Development Tools SQL Server 2005, Microstrategy, 9, Kettle 4.2
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description Finance BI implementation. Consolidated project financial analysis, financial KPIs, KPIs increase the shipping industry.
Responsibility Financial BI product implementation of the deployment, field data processing, report to show the test to solve environment, data, reports and other issues that may arise.
Time Period 2010/5--2011/3
Project Name Kingdee Financial BI Development Tools Oracle 10G, Cognos 10, the Kettle 4.0, vss, Powerdesigner
Hardware Environment Software Environment Windows 2003
Project Description EAS Kingdee own ERP product, based on the BI of the EAS development financial analysis of standard products. Kingdee ERP general ledger consolidated module for data integration and through the vertical analysis, analysis of the Corporation's financial health degree from the combined data to the general ledger and a breakdown is also added to the classic model of financial analysis such as: EVA, five force, and DuPont.
Responsibility (1) analysis of the general ledger business processes and logic
(2) to identify and verify ledger incremental data extraction
(3) model and database structure of the data warehouse structures
(4)Financial kpi indicators system to calculate the
(5) configuration with the safety of business communication and data isolation
Time Period 2008/7--2010/4
Project Name Foxconn bi developed Development Tools Cognos 8.4, the VS2005, the SQL Server2005, SQL Server Analysis Service 2005, SQL Server Integration Service
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description 2009/03 - 2010/04: the JIT-KPIs management system
Project Description: Foxconn new JIT warehousing within the park, on the organization, the supplier's order analysis, significantly reduce the aging of the JIT warehouse through BI analysis, the tremendous increase in storage utilization.
2009/05 - 2010/04: proposals to improve the analysis
Project Description: Group IE project proposals to improve project implementation and assessment of the benefits analysis. Effective assessment through the use of the BI analysis, the benefits of the IE project life cycle, greatly increasing the effectiveness of the IE project and project control.
2009/07 - 2010/04: fixed assets
Project Description: The analysis of the Group's fixed assets, the depreciation rate of sector assets.
2009/05 - 2010/04: VMI-HUB the BI system
Project Description: purchase to accept orders for shipping process limitation
2009/05 - 2010/04: the JIT-feeding on Aging
Project Description: supplier inventory aging analysis
Responsibility The person in charge, needs analysis, project development, project support, the increasing demand of maintenance.
Time Period 2008/7--2010/4
Project Name Foxconn bi for Supported Development Tools Cognos 8.4, VS2005, SQL Server 2005, the SQL Server Analysis Service 2000, dts
Hardware Environment Software Environment Windows 2003, Windows XP
Project Description 2009/3 - 2010/04: Central Personal Data BI systems
Project Description: Group Mainland China Human Resources
2008/10 - 2010/04: CNSBG-CEM/NWE BI systems
Project Description: CNSBG two Division inventory, revenue, accounts receivable, budget and other information analysis)
2009/03 - 2010/04: Central administered by management profit and loss system
Project Description: The system is responsible for project support, the increasing demand of maintenance.
2009/07 - 2010/04: Data analysis of the FIH administered
Project Description: Foxconn Group member companies FIH part of the financial analysis
2009/06 - 2010 04: Card System
Project Description: Analysis of Park 30W staff dining density, dining hours distribution and reasonable arrangements for the dinner.
Responsibility the system is responsible for project support, the increasing demand of maintenance.
Local Availability
Only available in these countries:
China
1
