Yaofen Ho Email & Phone Number

New York, Ny, Us

Seattle, Washington, United States

New York City Metropolitan Area

Responsibilities and key activities: Provided project planning, developed test plans, engaged with key business stakeholders to draft detailed requirement documents and craft actionable communications and project status reports offering analysis and insights for SAP GL projects and Business Intelligence reporting initiatives.Business Analysis:-Drafted business requirement documents to capture key functional business requirements and work with IT to implement new functionality and process solutions in SAP ECC for Treasury dept-Analyzed trading partner issues using SAP ECC and BOBJ and implemented new functionality for GL journal entries slashing the number of unnecessary manual Journal Entries created and accelerating monthly processing timesBusiness Intelligence Reporting:-Rolled out BI management reporting dashboard for senior FP&A executives-Streamlined and standardized monthly expense reporting for 100+ countries, designing a new standard monthly expense report in SAP BOBJ and Webi for internal finance warehouse. Raised reporting efficiency for management teams-Created custom reports and templates for the CFO using BPC, strengthening senior executives’ decision making when evaluating global business opportunitiesTechnical Activities:-Hands-on report development for SAP BPC, BOBJ and Webi reports -Troubleshoot user issues with SAP BI reporting issues -Performed UAT testing of new reports and draft training materials -Provide quarterly training for Finance users on running SAP BI reportsProject Management:-Project planning and stakeholder management to ensure timely communications to key stakeholders and status reporting

Downtown, Nyc

BPC / EPM•Worked on two full project life cycles implementing SAP BusinessObjects Planning and Consolidation (BPC) Microsoft version and SAP EPM 10 for Netweaver ramp-up•Created and tested new reporting functionality in EPM 10•Created drill-through field mappings and tested drill-through functionality in BPC 7 and EPM 10•Tested new functionality in EPM 10: package links, data loads, journals, consolidation monitor, controls monitor, ownership manager, business rules, work status and business process flows•Designed and implemented BPC security models, created user teams, member access and data access profiles and secured dimensions to control openings/closings of fiscal time periods and categories•Worked on and tested different types of data loads from BW to BPC 7 : GL, exchange rates, revenue, master data and also exports from BPC to BW such as hierarchy exports•Worked on data conversion to bring historical data from TM1 into BPC 7, used SQL extensively to analyze and identify datasets to be converted•Documented technical / functional specifications per business and system requirements.•Developed and ensured proper change controls are followed to promote changes from development / QA / production environments•Managed and tracked system tickets to ensure they are being resolved properly and timely•Regularly communicated and liaised with Finance and IT departments to collaborate on implementing new system strategies and processes•Created system maintenance schedules and procedures to ensure optimal system performance•Analyzed, benchmarked data load times and worked on enhancing system performance in BPC•Setup activity audit in BPC and EPM to track system changesTM1•Lead training sessions on TM1 usage and report development techniques•Supported users with TM1 reporting and system issues•Maintained and created company hierarchies and subsets

Nyc

Systems: Great Plains, Concur•Participated in full project life cycle implementing Great Plains (ERP) and provided user support•Created system documentation for end-users and administrators•Provided end-user training on Great Plains system•Implemented SafePay to prevent check fraud•Worked on implementing Concur T&E system

East Brunswick, Nj

•Junior Java developer, configured and programmed middleware to connect disparate legacy systems•Developed training materials on InstallShield and trained consultants on usage•Consulted on system integration projects at telecom companies: Time Warner Cable, XO Communications, Covad•Created technical and functional specifications using knowledge gained from working with the business and IT developers