Jian Chen Email and Phone Number

- Long term stewardship of Enterprise Data Warehouse (EDW) for Alstom.- Provided consultations and information on EDW to management and business users around world.- Planned and managed all projects that added new components to EDW, including data marts forQuality Control, Project/Resource Planning, and Sales Opportunity Analysis.- Led DW/SAP developers teamed with business users to deliver some key projects with data comingfrom both EDW and SAP/PMx/BW, like Time Entry Analysis and Project Demand/Supply Analysis.- Leader in SAP/PMx and Global Reporting Project: directed junior developers, trained business users,created SAP/Bex Business Objects reports, and provided global technical support.- Demonstrated capabilities to manage multiple projects simultaneously, to lead people with differentskill sets, and to deliver projects on time and within budget.- Developed and updated all production Business Objects universe connecting data from EDW,SAP/BW, and other data sources.- Worked as Business Objects Administrator to support Business Objects users around the world.- Managed day-to-day operations of EDW and helped Alstom build a robust staging schema withinEDW to support SAP/BW and other application servers.

- Member of architecture group for Data Warehousing team (over 120 people), responsibilities included BI architecture, information system design and development, and project planning and development.- Played important role in two Executive Information projects on data ETL, information delivery anddata quality (data cleansing, data reconciliation, data cross-referencing and metadata).- Developed an Alstom Power master customer table combining data from different systems.- Responsible for all aspects of Business Objects (WebI, full-client and 3-tier) implementation, includingplanning, designing of universes and reports, operation, system upgrade and user training.- Headed an overhaul project on a corporate finance data mart on MSSQL server to improve financialreports’ performance significantly, and saved Alstom $150,000 on hardware purchase.- Database expert in Global CRM Initiative Program and helped the team on CRM data integrity.- Planned, deployed and configured Essbase, Hyperion Analyzer and Reports, and Tableau reportingsystems in Alstom.- Planned and managed two Business Objects upgrade cycles, and migrated all objects to the newsystems.

Project 1: Major contributor in designing a data warehouse for Ford Auto Co. and solely managedplanning and integrating a web-based reporting system with full client/thin client (ZABO) BO, BCA, SDKand WEBI.Project 2: Project LeaderDeveloped data model (logical and physical) for OLTP database and data warehouse (Star-schema).

Developed two corporate data marts and financial Bro reports. Project leader for three data models(physical and logical), and operational databases

Leading role in Prudential DentalCare Management Decision Support System (DSS) Project with Essbase

Performed back-end development for an OLAPsystem (Essbase) for management having a data warehouse with integrating millions of records (>500GB)

Primary contributor to developing a home grown ERP system from MRP (ASK MANMAN) for thecompany