Beijing, Beijing, China
Eight more years of working experience in top 500 companies, Yiyuan hold MBA degree at Illinois Institute of Technology's Stuart Graduate School of Business and majoring in Corporate Finance, having excellent consulting and problem solving skills. Organizes ambiguous projects to define high impact deliverable and meet tight deadlines. Extremely detail oriented with a strong ability to identify and leverage improvement opportunities in complex situations. Specialties: • Experienced with Supply Mgmt, Master Data Governance, Business Process Improvement, Inventory Control, Logistics Mgmt • Develop and support Apex projects (Oracle Application Express) (甲骨文自制云） • Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling and Data Warehousing • Proficient in Database Programming and Development using SQL Server Management Studio and good experience in creating T-SQL (DDL,DML), Triggers, Views, Stored Procedures, User Defined Functions • Built Data Integration and Workflow solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Services (SSIS) • Defined queries, generated drill-down report, complex formulae, sub-reports, on-demand reports in SSRS • Spreadsheet Modeling and Financial Modeling using macros, @Risk, VBA code • Experienced with Investment performance analysis, Risk return models, Stock valuation • Perform business, financial, accounting, and customer due diligence • Civil Law and International Economic Law • Strong experience in preparing documentation, preparing test environments, executing and analyzing the results • Expert in interacting with clients, business analysts, and developers • Accustomed to working in multi-disciplinary teams, with a knack for seeing the details.
- Data standard for GS1 China and GS1 Global - ESG projects
• 基于英诺森产品（InData，InStock，InMarts，InLocate等）及咨询服务的售前工作支持，撰写MRO物资供应链相关解决方案，标书撰写及述标展示； • 零到壹搭建产品部门服务创新组标准化工作，贯穿项目管理全流程，数据治理服务体系方向项目交付包（启动、调研问卷及需求调研、蓝图设计、周月报、进度计划、会议纪要、验收等）； • 高效高质完成项目交付工作，合理利用内外部资源，持续学习沉淀工作经验高效输出，推动目标达成； • 双碳政策下能源行业研究分析及绿色供应链试点解决方案。
作为全球物流支持部门中的一员负责甲骨文与客户之间的供应链管理，其中主要包括北亚的库存管控，亚洲的紧急备件调用、反向物流操作，日常相关部门的系统疑难问题收集并与美国系统解决组就此问题的及时解决，以此提高工作效率及客户满意度。 • 精通Oracle ERP及DHL WMS/OMS模块，负责北亚入库的的采购订单及出库的销售订单报告的日常检测，并对异常数据进行分析及根本原因查找和问题处理； • 负责日常销售订单系统问题分析，提供解决方案以确保满足客户需求的销售订单货物的及时递送； • 辅助全球商务合规部门，处理香港台湾进出口特殊单证申请及海关、商检查验。 奖励： FY20Q3 Spot Award 优秀员工
• 协助客户经理及产品经理，有效沟通并产出客户体验报告，提供包括呼叫中心电话邮件数据，信用卡拒付数据及原因，旅行信息，开关卡信息，消费及额度数据等； • 负责每月客户体验报告的所有数据库维护，更新，为商业分析小组提供数据支持； • 协助银行部门内部按需求完成动态报表，实时追踪信用卡使用情况，观察是否存在欺诈行为； • 负责供应商匹配报表，为新客户提供参考意见。 奖励：合同制转为正式员工