Zhen Chen

Assignment in Ford Motor Company FCSD Support in change and test management, e.g. Help in creating technical specifications from NSC requirements, functional testing. Deliver all dealers standard reports or internal reports with specified timings. Create Ad-hoc reports with independent ORACLE SQL queries. Optimize process automation and improvement. Cooperate with the local sale department and IT. Data analysis and validation with GUDB database. Participate in the training courses for WF8.1.

WebFocus Developer MIS reporting system, Ford Credit UK Review and confirm the technical design with the Solution Team and document in One Note. Develop, Test and Deliver BI portal components. Set up Report Caster schedulers to distribute the reports to the customers via email. Co-ordinate with the offshore team to convert the design into the finalized version of components. Trouble shooting for the migration issues from WF 7 to WF 8. Support for Acceptance Testing.Track Post Shipment Defects to Closure.

IT analyst (Agile) in Ford Motor Company Köln, Germany. Outline Database Architecture and design issues. Design ETL data mapping jobs in Data stage, assess the design quality. Early identify weaknesses in the design model. Build Reporting Data Mart and Summary table and manage the database change in Teradata and MSSQL. Collaborate with business customers and support the QA/QC team. Reporting PROD issues shooting. Coach power users for Adhoc reporting tool. Support WebFocus Migration work.

Working as BI consultants in the following clients: Informa Europe, Eindhoven KHGCC Golf & Country Club, Den Haag Rabo Bank, Utrecht Woonbron, Rotterdam The main tasks were DWH & KPI dashboard desgining.

Contact with Chinese customers over the phone and follow-up Collect the customer’s questions and forward to the corresponding department Seek the potential customers

Prepare and examine the documents for exports and imports. Manage the inventory and supervise the shipments to the customers. Arrange air and sea freight and truck deliveries. Work with the factories for product improvement, packaging changes, and testing requirements. Communicate with prospective clients at China Import and Export Fair. Maintain listing of account payable/receivable, customer service, and conduct market research, monthly sales forecasts/goal setting etc.