Peningo Systems, Inc.
Resume of Candidate: PEN-115
Rate: email us at info@peningo.com for rate information
Hyperion Software Consultant
Technical Summary
Hyperion Products: Hyperion Financial Management 9.3.1, FDM/FDQM 9.3.1., Essbase/Planning 9.3.0.1/7, Shared Services 9.3.1, Financial Reporting Studio
9.3.1, Hyperion Enterprise 5, SmartView for HFM 9.3.1, Hyperion Application Link, Workspace, Workbench, Web Analysis/Analyzer 9.3.0, Excel Add-In.
Databases: SQL 2000/2005, Access, DataWarehouse
Operating Systems/Servers: Windows XP, Windows 2003, MS-DOS, Weblogic
General Ledger: Lawson 9/8.0.3, JDEdwards, Oracle 11i, SAP
Other Applications: Clarity5.5, Vision Explorer, MS Project, Salesforce.com, Databasics, Mistral, Bloomberg, TrackIt, OpenEdge.
Certification
Hyperion Financial Management 9.3.1; Hyperion Essbase 9.3.1; Hyperion Enterprise 5
Experience
11/09 – 9/10 SeaCube Container Leasing, Systems Analyst, NJ
• Provide administration and user support for Essbase, Planning, HFM/FDM, SQL, Lawson GL, Salesforce.com, Databasics, Reports, and MS office
suites.
• Maintain .bat, MaxL automation scripts and 100+ SQL DTSs for scheduled data refreshes.
• Maintain security in Hyperion Shared Services and Lawson LID with LDAP authentication.
• Install and configure software, add-ins, and patches for users and as necessary.
• Customize ad hoc queries for data pull via SQL, Access, and ODBC connections.
• Manage systems projects and testing, including hardware specs.
• Some maintenance of departmental intranet site.
9/08 – 4/09 WHX Corp – Handy Harman, HFM Technical Project Manager, NY
• Responsible for managing technical functions pertaining to HFM, FDM, Financial Reporting Studio, WebAnaysis, Shared Services, and Smartview for
data conversion project.
• Diagnosed technical configuration issues in HFM 9.3.1 and FDM subsequent to install.
• Developed reports in Financial Reporting Studio, Web Analysis, wrote manual guide for FRS.
• Reviewed and administered HFM security, performed local backups of metadata, rules, memberlist, data, security files. Recommended process
improvements and best practices.
• Maintained structural changes in metadata, rules as necessary, including overrides.
• Identified Bairnco data conversion Project parameters and review progress with management.
• Built new applications and test environments in HFM. Maintain interface between HFM/FDM.
• Set up Smartview for users, developed templates for analysis and reporting.
• Utilized Hyperion utilities for extracting of metadata information for analysis purposes.
4/07 – 9/08 Continental Grain Co, Financial/Hyperion Systems Analyst, NY
• Oversight of scripts, consolidation infrastructure and data sync on Hyperion and GL systems.
• Maintained Lawson GL and Hyperion consolidation suites via updating cubes/structures, variables, filters, scripts for month-end, quarter-end, year-
end rollovers.
• Maintained templates for accounting/reporting in Retrieve or Clarity formats.
• Client upgrades of office suite, Essbase 7, Hyperion Enterprise Reporting 6.4.1 including reports conversions from lower version to 6.4.1. Tracked
project status with MS Project.
• Lawson GL upgrades, including company set-up, load transactions, vendors, jobs/reports, client portals, answer user inquiries, back-end SQL
support.
• Prepared training materials and held training class for accounting staff on Report Writer.
• Maintained user securities on all financial systems, prepare summary of changes monthly.
• Received and resolved user support issues on daily basis, tracked in log file.
• Diagnose and rectify configurations, systems error messages, systems optimization.
• Performed system backups on different systems at varied schedules .
• Updated procedures/checklists, documentation of new procedures.
5/06 – 12/06 Futures & Commodities Trading Consultant, IL
UBS Securities LLC, ETD Trade Support Help Desk Consultant (Management)
• Reported system status, enabled traders on systems/exchanges.
• Ensured company compliance through market data reporting to exchanges.
• Completed daily trade allocations and clearings.
• Customized sales analysis reports, power-point presentations.
• Assisted with new client connectivity including mapping and testing as pertinent.
• Attended project development/status conference calls, liaised with other departments as required, reported to Executive Director.
• Developed Access database with VBA for tracking firm-wide security login data in NA. Trained former users on integration.
7/04 – 4/06 Manufacturing Industry Consultant, NY
Scholastic Inc., Senior Financial Analyst/Hyperion Consultant
• Redesigned budget templates in Hyperion for collection of yearly budget information.
• Rebuilt forecast upload templates in Hyperion Retrieve for re-forecasted data.
• Developed overhead expense reports and sub-ledger reports for 9 business groups and 80+ cost centers for monthly distribution.
• Developed variance reports and prepared bridge reports.
• Made allocation entries for copy, telecom and facilities, calculated depreciation and capital expenditure ROI, monthly accruals and expense entries.
Ad hoc.
Dover Corporation, Senior Financial Analyst/Khalix Consultant’
• Participated in Khalix implementation, customized script for Khalix maintenance
• Verified roll-forward balances and transactional balance problems.
• Checked BS, PL & inter-company validations on current and historical data.
• Converted Bluebook, flash income templates to Khalix for Excel and hybrid forms.
• Developed designed operating income template, ROI, calculated working capital/sales metric.
• Acted as Liaison to consolidation team, IT, Taxes, & Corporate Reporting.
•
PepsiCo International, Consolidation Accounting Consultant
• Consolidated regional data files, schedules, into PI application/s in Hyperion.
• Prepared special ledgers in royalties and trademarks.
• Updated retained earnings in Hyperion schedules.
• Developed Retrieve test scripts parallel testing, converted existing Retrieve shells to new app.
• Developed and Designed customized management Retrieve reports, account analysis scripts.
• Developed automatic uploads to some period reports, identified report enhancements to IT.
10/99 – 6/04 Banking/Financial Services Industry Consultant, NY/NJ/CT/IL.
GE Commercial Finance, Business IT and Taxes
• Prepared commercial loan dataset for ACBS conversion per mapping specifications.
• Validated datasets in CU, CA, CL, researched in DUN & Bradstreet for data. Dataset included syndication, direct, sub-prime, securities
facilities/loans, customer profiles.
• Expected value testing, some reverse gap analysis of legacy and ACBS.
• Created supporting schedules for varied types of commercial real estate entities.
•
Citi-Capital, General Ledger Reconciliation Accounting Consultant
• Reconciled general ledger accounts in Oracle GL 11i with sub-ledger parallel systems.
• Prepared trend analysis reports for custody and suspense accounts.
• Verified account balance and entries for accuracy and documented items for corrections. Ran identifier for re-class entries.
• Analyzed accounts for up to 1000 Excel pages. Queried entries in Access.
JPMorganChase, Financial Reporting Hyperion Systems Consultant
• Established general ledger sub-account tables in Hyperion under test.
• Edited logic formulas for GL accounts established on system.
• Ran VB Macros for consolidation of impacted data.
• Test application successfully implemented in production. GL sized at 20 billion.
Deutsche Bank, Securities Excel Consultant
• Maintained aging report on cash and share breaks for securities group.
• Collected exceptions from administrators daily for aging report.
• Customized reports and implemented new templates per management specification.
Bank of Nova Scotia, Loan Accounting Consultant
• Reconciled exceptions on syndication loan receivables and contra account post ACBS conversion.
• Balanced accounts daily with controller’s figures. Cleared 6 month 25MM backlogs.
Verified entries with accounting staff, loan/LC administrators. Assisted with implementation of new trial balance procedures for funds receivables.
Education
Tufts University, Medford, MA., M.A. in Economics, 1998.
University of California at Berkeley, Berkeley, CA., B.A. in Economics, 1995.
 | |  | |  | |  | |  | |  | |  |