Helen Li

***** ***** **** ****** **********, MD 20876 ad472p@r.postjobfree.com 301-***-****

PROFILE

Proactive and results-driven professional with extensive experience in corporate finance and business consulting. Proficient in data analysis and data management. Wide-ranging knowledge of business and financial information system design, implementation, and modification. Well-developed verbal and written communication skills.

AREAS OF EXPERTISE

Budgets and Forecasts

Oracle Financial System Administration

Financial Process Improvement

SAP Web Intelligence & Business Objects

Financial Reporting and Analysis

Project Analysis and Management

Database Design & Management

Programming & Testing

PROFESSIONAL EXPERIENCE

Viavi Solutions Inc. Germantown Maryland

Senior Analyst / Financial Analysis and Planning, (2015 – 2023)

Developed and provided financial and business data analysis reporting package for senior management.

o Develop Profit and Loss (P&L) Excel spreadsheet that models the effect of forecast targets on net margin and cash flow.

o Prepare monthly and quarterly forecast versus actual variance reports for senior managements.

o Perform monthly and quarterly financial closing for IT, Legal, Human Resources, Manufacturing, and Customer Service.

o Provide insights into the performance of the finance and business and translates findings into potential action plans for area supported.

o Provide key support to the annual budgeting and periodic forecasting of the assigned business area including variance analysis and sensitivity testing.

o Set up the annual Capital expenditure and Operating expenditure budget template files. Performed data collection, data analysis, data validation, and data consolidation.

o Produce ad-hoc queries and reports in Hyperion Smart View.

o Update and maintain company chart of accounts table.

oIdentify, develop, and implement procedures to improve existing business processes.

Assisted in software migration from Brio to Oracle Business Intelligence

o Provide R&D (Research and Development) and Sales Return Reserve data information and reports structure documents to the project team.

o Aid the IT consultants to help them understand company finance and business concepts.

o Perform user acceptance testing for the new software development. Participated in the reporting conversion and modification. Provide training to co-workers.

American Red Cross, National Headquarters, Washington, D.C.

Senior Analyst / Lead Analyst, Corporate Finance and Business Planning, (2008 – 2015)

Analyze financial results to support key business decisions and marketing activities.

oEvaluate business data at the calculation and quantitative method level for quality control.

oSet up business data analysis template file and the database to process revenue and expense data.

oFormulate and provide financial and business operational reports for senior management.

oDesign, implement and maintain budget management user interface tools.

Develop and implement financial and operational reporting models to manage business performance.

oWork with Red Cross project managers on project data analysis and identify the information required.

oTrack and report monthly expense savings and revenue enhancements.

oProvide cost savings analyses and reporting for senior management.

oDesign and develop the savings tracker database and report automation templates.

Enhance Enterprise Data Warehouse Capabilities in Business Objects Upgrade Plans.

oLed a Data Warehouse migration from Business Objects full client to SAP Web Intelligence.

oProvide ongoing support to monitor system effectiveness and troubleshoot customer concerns.

oProvide requirements and designs for the data warehouse area of staffing (ADP Payroll) to the technical team.

oProvide standard reports for monthly FTE (Full Time Equivalent), headcount, and turnover reporting for a workforce of 21,000 employees.

oDevelop and manage Data Warehouse SharePoint site for Red Cross SAP Web Intelligence users.

Administer Red Cross corporate Oracle Hyperion ERP system.

oRepresent corporate finance in system development and user acceptance testing (UAT).

oGather leadership requirements and provide customer insights for vendor project team efforts.

oSupport organization’s budgeting data process in Hyperion Planning Application.

oManage security level authorizations and oversight of the Hyperion planning application.

oDesign and implement forms for users to enter and review budget numbers

Senior Financial Analyst, Biomedical Finance department (1998 – 2008)

Led the system development efforts to improve management of our expense budget and 18-month rolling forecasts totaling $2 billion.

oSupervised contract programmers in the development of the forecasting software application.

oResponsible for software design, testing and nationwide implementation.

oManaged monthly and quarterly forecasting data processes.

oDeveloped standardized reporting.

oProvided reporting processes and procedures documents to the customer.

Aligned staff contributions across the organization to prepare annual budgets.

oDetermined budget targets-based unit potential for operational and financial improvement.

oAssisted with review of budgets for any new cost proposals.

oDesigned and developed the budget data entry template file for the regional offices. Managed annual budget data consolidation and validation.

oDeveloped and managed the budget database.

oManaged monthly budget data modifications.

Managed system infrastructure.

oLed discussion of project prioritization and support of financial resources.

oSupported system administration for 46 regional offices nationwide.

oDeveloped and implemented company-wide training on financial and budgeting tools.

Developed cost analysis tool and reports to support financial decision making.

oDesigned and managed production of a data mart combining monthly summaries of production, distribution, and staffing measures.

oConstructed the cost model used as an analysis tool for senior financial management and auditors.

TECHNICAL SKILLS

Certified Oracle Hyperion Planning System Administration.

Visual Basic, VB application in Excel/Access, VB application in client and server environment (OLE, DAO, ODBC), JavaScript, HTML, Access Database.

SharePoint Site Development

Project Management

TRAINING & EDUCATION

Master of Science, Virginia Commonwealth University. Richmond, VA

Bachelor of Science, the branch of Beijing University. Beijing, China

Finance controller workshop

Citizenship: U.S.A.

Contact this candidate