Project Management

LLEEOO MMEENNGG

469-***-**** *****@*******.*** LinkedIn: https://www.linkedin.com/pub/meng-fanlong/a7/509/49a Page 1 of 4

SSUUMMMMAARRYY

• 15 years of experiences in Hyperion, Business Consulting and Software Product development in Java/J2EE.

• In Oracle & Accenture, operated projects, performed income/cost analysis for annual revenue of $4.3M.

• Managed large and multiple Hyperion projects and produced deliveries in critical time limits.

• Expertise in business process, IT project management and documentation. CCOORREE CCOOMMPPEETTEENNCCIIEESS

• 10+ years Hyperion Essbase and Hyperion Planning • 10+ years Project Management

• Implementation of Hyperion Planning and Essbase

version from 9.2.1 to 11.1.2 3 or later

• Maintenance of the application, Database, Outline, Business, Formula

• Knowledge of Budgeting, Forecasting, Management

Reporting and Analytic applications domains

• Experience on Hyperion security, Hyperion Shared services, LCM utility, migration process

• ETL experience with ODI, Esscmd and MaxL • Good working knowledge of SQL

• Ability to perform top down and bottom up planning • Understands General Accounting and Finance Concepts

• Extensive experience in ASO/BSO • 8+ years Core Java Programming Language

• Report and dashboard by WA, Financial report,

Interactive report, OBIEE

• 8+ years Business Intelligence

• SOA, ESB, BPEL

• Designed and deployed software in Java/J2EE world

• Web based development, JSP, Servlet, JavaScript

• Agile, Spring/Struts, Hibernate

• Applet, AWT/Swing

EEDDUUCCAATTIIOONN

UNIVERSITY OF DALLAS Irving, Texas USA (Expected Spring 2016) Master of Business Administration, GPA 4.0

UNIVERSITY OF THE CHINESE ACADEMY OF SCIENCES Beijing, China (2005) Master of Computer Software

HARBIN INSTITUTE OF TECHNOLOGY Harbin, China (1999) Bachelor of Management Information System

PPRROOFFEESSSSIIOONNAALL EEXXPPEERRIIEENNCCEE

ORACLE Principal Consultant, China Region EPM Manager Mar 2010 – Aug 2014

• Cooperated with market personnel to identify and pursue $10M strategic business development opportunities

• Operated projects, performed income/cost analysis for annual revenue of $4.3M

• Performed Project Life Cycle Management

• Designed and developed Hyperion business and technical architecture for projects.

• Maintained the application, Database, Outline, Business, Formula

• PROJECT EXPERIENCE

o Bank of China Hyperion Project (Banking Industry) $4M, 14 members, 24 months

Normalized budget processes: Loans & Deposits, Interest Incomes, Non-interest Incomes, FTP, Operating expense, Capital Budget

Designed the calculation engine to forecast interest income base the Term Structure of Interest Rates and interest rate curves from Bloom Berg, Shibor, Libor.

Data analysis and what if analysis, adjusted FTP rates and their effect on Interest Income for each product

Designed & developed Hyperion Essbase BSO solution, designed Hyperion planning model, Essbase formula, business rule, process flow, and multi-currency exchange

Created and maintained reports and dashboards by BIEE, WA and Financial report for ASO and database.

Responsible for developing project plan and oversight, tracking the project process

Administration for automating backups, service start/stop scripts

Administrated and created Users and Groups in Hyperion Essbase and assigned privileges to them.

Administrated variables monthly or weekly.

Administrated outline, formula, Rule files, optimized Data Loads and Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).

LLEEOO MMEENNGG

469-***-**** *****@*******.*** LinkedIn: https://www.linkedin.com/pub/meng-fanlong/a7/509/49a Page 2 of 4

o HuaWei Hyperion Project (Manufacturing Industry) $4.5M, 23 members, 26 months

Standardized Planning process from order, deliver to P&L in terminal product and other lines

• Designed & Developed Essbase Application architecture, balanced application, database and partition to support concurrent 700 of 3000 users in world

• Excellent understanding of different storage in Essbase and their usage. Created really large cubes using ASO option. Also, created BSO application to support Financial Budgeting and Forecasting Application.

• Design transparent partition to support Forecast and budget process and reporting.

Designed Hyperion Planning solution including dimensions, versions, flows, and granularity for Budget/Forecast

Designed & developed Essbase BSO calculation architecture including formula, business rule, process flow, and rewrite multi-currency exchange to improve response time

Designed & developed Essbase maintenance architecture to update more than 400 variables by one click to avoid mistake and to improve efficiency.

Designed & developed authorization architecture to avoid role & group nested while to keep flexibility.

Developed and maintained reports and dashboards by BIEE, WA and Financial report for ASO and database.

Responsible for developing project plan and oversight, tracking the project process.

Maintained and created Users and Groups in Hyperion Essbase and assigned privileges to them.

Optimized the Essbase BSO and ASO cube by changing the outline.

Maintained the data in system by creating clean data script to clean specified area.

Maintained the variables in monthly or weekly.

Maintained and Created alternate hierarchies, automated process to extract and load data and metadata via ODI to/from Essbase and created calc scripts to move data to Planning. o New World department Hyperion Project (Retail Industry) $0.8M, 4 members, 12 months o RSHI Hyperion Project (Manufacturing Industry) $1M, 4 members, 16 months ACCENTURE Senior Consultant, Manager Mar 2006 – Mar 2010

• Operated projects, performed income/cost analysis for annual revenue of $2.5M

• Reported directly to the Senior Manager

• Coordinated and created project team for new projects

• Developed project plan and oversaw project process

• Designed and programmed models

• PROJECT EXPERIENCE

o HDPI Hyperion Project (Energy and Utilities Industry) $2.5M, 22 members, 12 months

Collected best practices and analyzed the gap between HDPI and best practices

Designed & Developed KPI framework from manufacture to finance, including installed capacity, total fuel, Residues disposal, Desulphurization, fixed costs and so on.

Install and configured EPM 11.1.1.1 in prod and dev environments.

Developed the KPIs in ESSBASE BSO application.

Loaded Security manually using a text editor and Loaded using Shared Services

Design disaster recovery process for Hyperion environment

Developed and maintained Reports and Dashboards by BIEE, WA and Financial report for ASO and database.

Performed tuning to calculation from 4 hours to 20 min by adjusting outline, formula and business rule

Responsible for developing project plan and oversight, tracking the project process

Maintained the data in system by creating clean data script to clean specified area.

Maintained the outline, formula, Rule files, optimized Data Loads and Calc Scripts (BSO), Maxl Scripts, MDX member formulas (ASO).

Maintained the variables in monthly or weekly.

Administration for automating backups, service start/stop scripts o CMCC Telecom SOA Project (Telecom Industry) $1.6M, 10 members, 8 months

Defined SOA service framework including SOA management processes, SOA description templates, business process templates and SOA government process. LLEEOO MMEENNGG

469-***-**** *****@*******.*** LinkedIn: https://www.linkedin.com/pub/meng-fanlong/a7/509/49a Page 3 of 4

Developed gap analysis of requirements and technical architecture design o CNAF Hyperion Project (Energy & Transportation Industry) $2M, 12 members, 8 months o Guohua IT Planning Project (Energy Industry) $0.3M, 3 members, 4 months o SGCC IT Planning Project (Utility Industry) $0.3M, 4 members, 4 months YONYOU SOFTWARE COMPANY Java engineer, Technical Lead Aug 2002 – Feb 2006

• Organized a department of 18 members within Product R&D

• Responsible for all aspects of Business Intelligence systems and products including OEM Hyperion

• Performed SWOT Analysis of the products

• Designed and developed core model and engine with Java, Struts 1.3, Servlets, JSP

• Provided Tech Support for entire team

• SOFTWARE PRODUCT DEVELOPMENT EXPERIENCE

o OLAP server Product Base on Hyperion API The Product is OLAP server, providing OLAP analyses, and ad-hoc query. Responsibilities include:

Designed & Developed main architecture and programmed OLAP server by Java according to CWM which include several cache strategies and supported auto-sum up data. Original design and program.

Business model validation.

Developed the JMS point to point messaging and Message Driven EJBs to order multiple reports simultaneously.

Used JSP and HTML pages to develop the web interface; used JSP tag libraries for creating complex web pages.

Used the MVC design pattern based on Struts + Spring + hibernate, which hibernate package this platform, as well as all the data in the database operation; Struts in this project serve as a View the realization of the function layer; and the commercial logic of Spring by the full responsibility, a lot of work to be completed by the JavaBean.

Extensively involved in database designing work with Oracle, Coding, testing and deploying the web application using WebSphere Studio and WebSphere App Server. o Business Intelligence Product based on Hyperion API The Product uses Hyperion ESSBASE and Hyperion API to develop BI tools and Balance Scorecard to analyze financial and budget data. Responsibilities include:

Responsible for product definition.

Responsible for the feasibility and technical validation of the solution.

Responsible for developing project plan and oversight, tracking the product process.

Developed various EJB components to fulfill the business functionality.

Session Beans have been used to process the requests from the user.

Involved in developing the service locator pattern for locating the EJB.

Actively involved in requirements gathering, Conceptual Design, Analysis, Detail design, Development, System Testing and User Acceptance Testing.

Used JSP and HTML pages to develop the web interface; used JSP tag libraries for creating complex web pages.

Used the Struts validation, Struts Custom tags and Tiles Framework in the presentation layer.

Implemented a messaging module using Java Messaging Service(JMS).

Extensively involved in database designing work with Oracle, Coding, testing and deploying the web application using WebSphere Studio and WebSphere App Server.

Monitored the error logs using Log4J and fixed the problems.

Developed and maintained applications through Essbase Studio.

Load data, create drill through reports, maintain hierarchy through Essbase Studio. NEUSOFT SOFTWARE COMPANY Java Engineer, Technical Lead Aug 1999 – Aug 2002

• Developed several software products within Product R&D

• Designed, developed, coded, and tested applications using JAVA, Servlets and Oracle technologies, WebSphere, COBOL, BL/1, J2EE and EJB, Servlets, and JSP

• Managed requirement gathering, system analysis, and finalization of technical specifications LLEEOO MMEENNGG

469-***-**** *****@*******.*** LinkedIn: https://www.linkedin.com/pub/meng-fanlong/a7/509/49a Page 4 of 4

• Developed model on mainframe 390

• Provided post-implementation application maintenance

• SOFTWARE PRODUCT DEVELOPMENT EXPERIENCE

o BITO Software Product

Designed, Implemented, Tested and Deployed Enterprise Java Beans(both Session and Entity) using Eclipse as development tool and WebSphere as Application Server.

Developed the Human Resource Management and Defect Resource Management Sub modules using Java, EJB, Servlets, JSP, Struts, JDBC, HTML and JavaScript as per business Requirement.

Designed and Developed JSP, Servlets to represent Presentation Layer Mapped the Error codes with the Exceptional Handling framework.

Developed Stored Procedures, Queries to extract the Customers data from the database.

Extensively used VSS for Version Control management.

Performed unit testing for each module, prepared code documentation(Internal & External) for future reference and upgrades.

o WAP application for phone

Designed WAP application under J2EE architecture using Servlets and developed the business components using EJB.

Deigned and developed the User Interface using JSP, Servlets, XML and Java.

Developed Java Server Pages for both Business Logic and GUI development.

Developed Java Bean components to communicate with JSP.

Designed and developed front end using JSP and Struts framework and other custom tag libraries.

Deployed all JSPs and EJB's in to Web Sphere application server.

involved to develop forms using HTML and Java Script.

Involved converting SQL Server data to Oracle database. o Source Code Control software

Designed Implemented Tested and Deployed Enterprise Java Beans using Jbuilder as development tool and Tomcat as Application Server

Developed the Version Control like Microsoft VSS using Java, EJB, Applet, Swing, Servlets, JSP, Struts, JDBC, HTML and JavaScript as per business Requirement.

Designed and Developed JSP, Servlets to represent Presentation Layer Mapped the Error codes with the Exceptional Handling framework.

Developed Stored Procedures, Queries to extract the Customers data from the database.

Extensively used VSS for Version Control management.

Performed unit testing for each module, prepared code documentation(Internal & External) for future reference and upgrades.

o Project: Design and Developed ‘Defect System’ with Object Oriented technology by Java o Project: Application of CMM in Project.

o Project: Development Standard of Object Oriented development in NEU-BITCO Ltd by Java o Project: Inner Flow of files of Lian Yun Gang TianWan nuclear power plant by java. o Project: IBM Mainframe (OS/390) Japan Mitsubishi by COBOL, BL/1.

Contact this candidate