Thomas F. Smith

Rochelle Park, NJ 201-***-****

adu647@r.postjobfree.com

www.linkedin.com/in/thomas-smith-4b82342

FINANCE IT MANAGER

Decisive, results-driven IT professional with a proven track record implementing Oracle EPM suite of applications. Successfully worked with functional groups and senior management to streamlined and re-engineered processes from inception to deployment. Improvements in planning and reporting processes resulted in more timely analysis and recommendations to management by functional groups. Adept at building strong relationships with management, personnel, and clients.

AREAS OF EXPERTISE

Business and IT Management, Leadership, Customer Relationship Management, Analytical

System Implementations, Business Operations, Strategic Planning

Forecasting / Budgeting, Financial Modeling

TECHNICAL SKILLS

Hyperion System 11 Planning, Essbase and Financial Reports developer and administrator,

Hyperion Essbase Certified, MDX, MaxL, Esscmd, scripting and automation, Microsoft Office (Excel, Word, Access, Visio, Project), Oracle Data Integrator (ODI), Visual Basic for Applications (VBA),

Agile Methodology

PROFESSIONAL EXPERIENCE

Verizon 06/2016 - Present

Solutions Architect

Oversaw the design and implementation of the underlying processes and systems architecture on Oracle Enterprise Performance Management (EPM) and Business Intelligence (BI) platform.

Senior functional expert accountable for aligning internal reporting solutions with MDM strategy.

Functional end to end design, management, and decision authority of the Hyperion internal reporting solutions architecture.

Provided ongoing optimization and development of the systems and applications.

Work closely with the Planning Solutions and External Master Data architecture and governance managers.

Collaborate with internal and external resources to develop solutions to customer issues

Support of Essbase Application and ETL Process

Control Performer for Quarterly SOX reviews and audits.

Experienced in use of Agile and Waterfall methodologies

Pearson Education 03/2008-06/2016

Financial Systems Manager

Lead team consisting of internal and external resources in development and support of multiple Hyperion Planning and Essbase applications. Worked with business executives, functional groups and IT on requirements and hosting of three environments for Hyperion EPM suite.

Financial Systems Manager, continued

Developed Planning and Reporting application for Pearson North America businesses.

Worked with functional groups on migration from Hyperion Enterprise to Hyperion Planning / Essbase.

Designed, implemented, maintained, and managed Hyperion System 11 EPM applications.

Hands on Developer for ODI, Essbase, Planning, Excel VBA Templates and Financial Reports.

Developed ODI processes to replace HAL and automate regular updates of applications.

Utilized Excel VBA for automation of supporting templates.

Worked successfully with team of internal and external resources.

Assisted in migration of Hyperion environment to Fusion 11.

Created processes and policies governing usage of shared environment.

Israel Discount Bank of NY 02/2006 - 03/2008

Assistant Vice President Information Technology

Developed Hyperion Planning and reporting system from start to finish. Implemented automated processes to maintain hierarchies and load data.

Worked with functional groups on design and implementation of Hyperion Planning / Essbase system.

Implemented Hyperion System 9 Planning Application. Completed three successful planning cycles.

Automated Load of Essbase, Planning and HFM applications using HAL.

Created Hyperion Financial Reports using Essbase, Planning and HFM as sources.

Administrator for Essbase and Planning, Backup for HFM.

BMW of North America 09/2003 - 02/2006

Lead Hyperion Developer

Maintained, updated, and enhanced existing Essbase auto dealership reporting system.

Hyperion Analyzer, Hyperion Reports, and Microsoft Excel used as front-end reporting systems.

Audited existing processes for accuracy, implemented best case practices, and made modifications and upgrades as needed.

Coordinated upgrade of Hyperion Essbase (6.5.6 to 7.1.5), Reports (2.6 to 7.2), Analyzer (5.02 to 7.0.1), and HAL (1.3 to 7.0).

Maintained system of 10 Essbase cubes, 30+ Analyzer views, 30+ Hyperion Reports, 15+ HAL processes, and 10 Excel (VBA) based processes.

Developed new automated maintenance process, archiving process, and coordinated the migration to new servers.

ADDITIONAL RELEVANT EXPERIENCE

Edgewater Ranzal (Formerly Ranzal and Associates, Inc.), Hyperion Consultant

Held various consulting and analyst positions at AnswerThink Consulting, Ernst & Young, LLP, Somerset Medical Center, Elizabeth General Medical Center, and IBM Corporation

EDUCATION

Bachelor of Science Finance

Bachelor of Science Accounting

RAMAPO STATE COLLEGE Mahwah, NJ

Contact this candidate