yingnan qian

Functional Area : Credit Risk Management, Marketing - Managing BI service team (17 persons including a remote team in Bordeaux) - Candidates Interviews to recruit the appropriate resources for each project - Project Steering Committees on a monthly basis - Following up the Project KPI - Preparing financial follow-up report on a monthly basis - Participating in the preparation of several proposals - Analyzing the actual BI system and prototyping with the new business requirement in order to integrate the new online credit product into daily performance and operational reports - Designing solutions - Ensuring solutions delivered are fully compliant with Architecture and supportability standards and requirements - Playing a crossover role between Clients/Business team and Technical team - Planning, budgeting and forecasting - Following up the Requirement Traceability Matrix to ensure project scope is/will be well covered - Organizing/Preparing Integration Test / User Acceptance Test - Developing Work Breakdown Structure (WBS) - Identifying project risk and manage risk with Risk Breakdown Structure (RBS) - Managing stakeholders' communication - Providing coaching to team members and on-the-job training - Setting up an creative Moving Motivators system while ensuring team members are motivated - Team HR management (Conflict, Problem of productivity…) - Setting up a configuration management system

Functional Area : Accounting, Profitability Analysis ETL Team Leader on an new BI Core Model build against the ERP SAP (CO, SD, COPA) - Coordinated SAP / BI team to define Core Model business requirements and business rules - Analyzed solution needs jointly with LVMH Project Managers and SAP Solution Manager and defined the scope for BI Core Model project (configuration, data modeling, usability review, process set-up, etc.) - Crossover functional/ technical design - End to end management of project design - Planning, budgeting and forecasting - Managed technical development team of 5 persons: provided technical direction and owned development lifecycle of the project from initiation to production using iterative RUP methodology - Managed a remote team in Bordeaux on agile development - Designed ETL jobs and Data Model for Core Model - Estimated the resources to achieve project delivery targets - Created and Managed development plans and reviewed work of development team - Developed project and communications plans and documents - Effectively communicated project expectations to team members and stakeholders in a timely and clear fashion - Authored business and technical requirement specifications - Authored integration test plans, and other project requirement artifacts - End User Training on BI Core Model (5 days in English) - Prepared User Acceptances Tests (SAP, Cognos, DataStage, Oracle DB) - Prepared Cut-Over with Exploitation Service for Go Live - Go Live

- Prepared project steering Committee and Followed-up different stakeholders - Created KPI Reports and Quality Dashboard - Identified, investigated, and analyzed incoherence (Fraud Control) - Managed Business Analyst Team (2 persons) - Identified and evaluated inefficiencies and recommended optimal business practices, and system functionality - Authored functional specifications - Responsible for performing technical and user acceptance tests for Global Electronic Counter Reference Database - Developed the test strategy (tests, scenarios and test plan)

Functional Area : Receivables, Payables, General Ledger Technical Environnement : Oracle E-Business Suite 11.5.10.2 (AP, AR, GL, PO, IP5 et IC) PLSQL developer 7.1.5/Oracle SQL developer 1.5.4 Oracle Reports 6i/Oracle Forms 6i Unix Shell Support N3 - Timely follow-up, investigation, troubleshooting and resolution on Oracle E-Business Suite - Supported day-to-day execution of production support for Oracle Financial Applications (General Ledger, Accounts Payable, Accounts Receivable, ADI/Web ADI, General Reporting & Controls) - Managed priorities of a cross functional geographically disbursed teams including offshore consultants - Managed Oracle configuration changes in respective application areas - Participated in system testing and resolution of system issues - Completed all required internal Change Management documentation and signoffs related to SRs/RFCs Migration and Implementation Printemps : BPACK – Supplier Overhead Management CASHFORCAST – Asset Management OSCAR- Interface between Oracle e-Business Suite Financial and SAP Supply Chain Management UEM : ENGAGEMENT BUDGETAIRE – Budgetary Accounting Lyonnaise des eaux : SIMPAC :Migration project from e-Business Suite 11.0.3 to 11.5.10.2, applied the upgrade the customer needs, supported to test the new environment and reviewed the existing setup version

Tech. Envir. : SAP R/3 Module MM, Microsoft Excel, Microsoft Access, VBA, ADO, SQL Established a new Excel-Access budget calculator application and helped to predefine the budget for 2010/2011 Demonstrated this new tools and Trained users and managers on system capabilities and usage

Collaborated and communicated with all team manager (Production, RH, Quality Audit...) to centralize all KPI in a core model. Documented all update procedure and described the calculation method with a high level of efficiency and accuracy. Automated and improved KPI daily update

AGISIAD Pro 2009: Creation Website, Analyze bunisness need to propose opensource ERP tools : 2450 euros turnover for this year