Hyperion Essbase, Planning, HFM, FDM, Financial Reporting, E-business

SIMON SETO

**** **** ****** ~ Brooklyn, New York 11214

917-***-**** ~ *******@*******.***

SUMMARY OF QUALIFICATIONS:

Professional experience in implementation, support, and maintenance in Hyperion Essbase, Planning, HFM, FDM, Oracle E-Business Suite, Hyperion Enterprise, JD Edwards and Microsoft Dynamics GP systems. Managed financial systems team, oversee project development, and take lead throughout systems development life cycle implementations. Successfully managed data within various financial applications as well as developed custom programs and code scripts to support company requirements. Support month end close, budget/forecast process, and other financial modules. Expertise in developing Microsoft Access databases, writing VBA scripts, and programming in Microsoft Excel.

TECHNICAL SKILLS

Financial Applications: Hyperion Financial Management, Hyperion Financial Data Quality Management, Hyperion Essbase and Planning, Hyperion Enterprise, Oracle E-Business Suite, JD Edwards 8.12, Microsoft Dynamics Great Plains 10.0, Fiserv Tracker, SharePoint, JD Edwards Enterprise Report Writer, Hyperion Financial Reporting Studio, Deltek Costpoint

Software: Oracle – Data Integration Management, Create!form, Citrix, MS Office

Languages: Visual Basic, C++, OpenGL, Java, DOS

Operating Systems: Windows 2000/XP/7/NT (Server and Workstation)

Database Management: Access, Showcase Strategy, Noetix

ACCOMPLISHMENTS:

Saved the company (Scholastic) $25K per month on consulting fee by managing software division reporting in-house that involves code development/maintenance.

Implemented the form designs, script designs, print-queue setup in association with JD Edwards Purchase Order and Canada check printing process (Scholastic).

Created Essbase macro with use of code for extracting structural outline from Essbase for data warehouse purposes (Scholastic).

Worked with external programmer to successfully develop forecast/budgeting tool (macros and coding) that involves Essbase Excel add-in to better support a division’s business point of view (Scholastic).

Developed conversion database for loading Hyperion Enterprise data into Essbase (during its implementation stage while parallel running both systems of data accuracy). Have also developed database for converting budget/forecast data from Enterprise to JD Edwards in addition to writing external queries (Scholastic).

Developed check recovery program for Accounts Payable to better support any check printing failures – VBA code involved (Scholastic).

Coordinated the implementation of both production and backup check printers that include redesigning company checks, and working sections with various business involvements - treasury, bank, etc (Scholastic).

Implemented and administered the Fiserv Tracker – escheatable check system for both server and workstations (Scholastic).

Developed an internal Travel and Expense program for supporting the Accounts Payable department – extensive coding involved (Perseus Books Group).

Successfully implemented and consolidated the Cash Flow financial reporting within Essbase – both modifying metadata structures and scripting involved (Griffon Corporation).

Converted both the Online and Meetings accounting structure into one unified chart of accounts during the Hyperion Enterprise consolidated application build (Weight Watchers Inc).

Implemented UK’s Hyperion Enterprise application along with support going forward - includes metadata build, calculations, scripting, consolidations, and reporting (Weight Watchers Inc).

Worked with external consultants to implement both the HFM/Essbase financial applications (Weight Watchers Inc).

Redesigned and automated Oracle’s Project Accounting features and processes. Hence eliminated external consultant fees by taking ownership of subsystem. Extensive VBA coding involved (Weight Watchers Inc).

Designed and fully implemented the Essbase Temp Fees application for reporting company external consultant fees based on Oracle query extracts, for upper management review (Weight Watchers Inc).

Worked with external consultants to successfully implement new Essbase applications in replacement of current application with results of consolidation times from 3 hours to 10 minutes max. Heavy metadata modifications, calculation scripts, and data reconciliation involved. Lead entire systems development life cycle implementation (The Chanel Company Limited).

Developed new metadata build and extract process in replacement of current. Build process eliminated manual outline changes. Extract benefits include more detailed information provided to management reporting, more stable and user friendly tool (The Chanel Company Limited).

EXPERIENCE:

The Chanel Company Limited, New York, NY

Corporate Financial Systems Administrator December 2014 – February 2016

Manage all Essbase applications within TCCL’s corporate department. Responsibilities include all aspects ranging from application development and fine tuning, script and code development, consolidations, security, reporting, integrations, etc.

Work with management reporting team to translate new business requirements, define system impacts, and ultimately develop and incorporate changes within Essbase, HFM, FDM or other systems.

Work closely with management reporting team during financial reporting cycles ranging from consolidations, validations, and resolving any data integration issues.

Lead all Essbase systems development life cycle implementations ranging from plan, design, build, test, and deployment. Manage consultant team during various phases of project.

Coordinate all corporate financial systematic changes with divisional Essbase administrators. Oversee all activities that directly feed financial information from divisional Essbase systems to corporate systems.

Consistently automate manual processes in ways of improving and simplifying user or system tasks with benefits of data accuracy, user error elimination, and time savings. Script and code development involved.

Manage corporate financial systems team and oversee system support for both domestic and international groups.

Train users and team members of various applications, processes, and new developments.

Weight Watchers Inc, New York, NY

Senior Financial Systems Analyst January 2011 – November 2014

Manage various Essbase production applications within EAS such as creating applications and databases, dimension modifications, member formulas, calc script development, maxls and batch coding, business rules, partitions between BSO and ASO cubes, etc. Also coordinate and apply development testing prior to deployment, manage Financial Reporting Studio, and security via Shared Services within the Global Systems department.

Support and maintain the HFM consolidated database and FDM data collection and transformation tool, as well as ERPi (Enterprise Resource Planning Integrator) connections between Oracle and HFM/Essbase.

Support both Oracle and Hyperion user community in relations to month end close, forecast, and budget cycles. Maintain data flow efficiency between source and target systems for example chart of accounts modifications and various dimension mapping tables that drive consolidated financial data. Maintain Oracle security at the general ledger cost center/account level and in addition to providing Noetix query support.

Take lead in all Essbase systems development life cycle implementations from discussion workshops to complete production deployment. Advise in all process automations where appropriate for business users.

Provide training for new or existing users of various HFM/Essbase related reporting tools: Workspace (Financial Reporting Studio reports), FDM mappings and journal uploads, Smartview, Adhoc, etc.

Managed all modules within Hyperion Enterprise prior to HFM/Essbase go-live, such as chart logic/formula modifications, maintaining both Entity and Account modules, creating reports/books, journals, Ledger Link, Autopilot, Retrieve, and update financial data from Oracle.

Worked on projects independently and provide support where needed. Develop or modify scripts to enhance data automation processes, as well as documentation.

Managed Oracle’s Project Accounting subsystem.

Supervised and cross trained colleagues across multiple ERP systems.

Griffon Corporation, Jericho, NY

Hyperion Developer Administrator January 2010 – October 2010

Manage the company’s full Essbase data consolidation process and financial reporting package within the corporate department.

Coordinate Essbase structure changes between segments to fulfill corporate accounting requirements.

Conduct and advise segment administrators for ongoing system related tasks.

Coordinate and manage consultants to automate data processes in addition to the implementation of new Essbase systems of newly acquired companies.

Oversee and/or modify Essbase related dimensional changes as well as develop scripts (Essbase Administration Services) and business rules for Planning. Manage security within Shared Services and Planning. Manage the Oracle – Data Integration Management tool for translating data from individual Essabe databases (segments) to the company consolidated database. Create reports via Hyperion Financial Reporting Studio in addition to managing Workspace. Develop and apply code as needed.

Support the month end close process in relations to Hyperion Essbase data validations and integrity.

Support related accounting systems by developing and providing automated Essbase data feeds.

Document Essbase procedures and processes for Sarbanes Oxley compliance.

Perseus Books Group, New York, NY

Consultant September 2009 – January 2010

Provided advice for the restructure of Dynamics GP chart of accounts and reporting system.

Performed maintenance of Dynamics GP general ledger system in addition to provided daily support of incoming issues within the Strategic Planning department.

Managed and develop financial reports within GP – FRx reporting while also assisted in the implementation of various financial application modules.

Developed and modified programs that utilize Visual Basic coding and macros.

Created financial queries in addition to analyzing data for upper management.

Scholastic, June 2003 – August 2009

Senior Financial /Computer Systems Analyst February 2007 – August 2009

Supported the daily operations within Hyperion Enterprise and Essbase while also maintained the flow of financial data from other applications/systems or vice versa.

Continued support and maintenance of JD Edwards Xe system such as general ledger, purchase orders, printers, security, generic interface, etc.

Wrote or troubleshoot financial reports within the systems specified above.

Trained individuals for the various applications that the department supports which included onsite or remote.

Designed and maintained the internal Accounts Payable check printing system (Create!form) which includes coordinating with IT operations in the set up of print-queues and the physical printers itself. Designed, developed, and printed Purchase Orders & 1099's as well. And upgraded software packages where needed.

Developed programs to accommodate user/departmental needs that involved multiple system interaction and coding. Document processes for both internal use and external auditors – Sarbanes Oxley.

Created and maintained user/group security as well as filtering Essbase dimensional access. Developed calculation and report scripts in addition to modifying Essbase outline.

Analyzed data with MS Access/Excel - efficient with functions, macros, and VBA coding.

Coordinated projects where multiple businesses were involved. Participated in the planning, design, and implementation of various ERP software packages, as well as administer future installations. Scheduled the workflow of various system processes in addition to metadata backup.

Data mining between various systems – testing, development, and production purposes.

Financial Systems Analyst December 2003 – January 2007

Supported and maintained the Hyperion Enterprise application as well as load data and monitor nightly scheduled processes. Managed mapping tables (Ledger Link) and fixed load errors. Automated daily data loads and nightly consolidations with the utilization of Hyperion Autopilot. Develop scripts and code as needed.

Performed maintenance of both JD Edwards World and One World Xe systems.

Assisted with the budget/forecast processes as well as created upload templates for users.

Created or troubleshoot queries that include SQL coding.

Analyzed data with MS Access/Excel (Retrieve) for managerial review.

Financial Systems (Internship) June 2003 – November 2003

Updated financial databases.

Created financial reports for business divisions.

Worked as a liaison with business divisions in resolving query and reporting issues.

K & M Computer Inc, Brooklyn, NY

Computer Technician November 1998-December 2000

Provided technical assistance for IBM-Compatible systems – phone support and onsite.

Performed Windows NT and Windows 98/2000 system configurations as well as assembling pc.

Performed computer/software sales and upgrades while working with customer requirements.

Troubleshoot networks that include hubs, wireless peripheral, etc.

EDUCATION:

Bachelor of Science in Computer Science, College of Staten Island, Staten Island, NY May 2003

Contact this candidate