EDUCATION

MBA, Concentration in Finance
BA, History

EXPERIENCE

Confidential, Pittsburgh, PA
Senior Business Systems Analyst
July 2008 - May 2009

• Engaged user community to capture and access changing user needs
• Ensured Hyperion processes mirrored evolving business strategies
• Worked across organizational boundaries to document and develop functional and technical specifications and support for the design, development, testing and maintenance of new Essbase and Planning processes
• Overhauled current reporting environment to leverage Web Analysis, be more "user-friendly", comprehensive, and to require less maintenance
• Developed and delivered training to application users on an ongoing basis
• Evaluated new technologies and processes for suitability of use and implementation
• Administered Essbase, Planning, HAL, Shared Services and Workspace

Confidential, White Plains, NY
Consultant, Project Manager
October 2006 - July 2008

• Designed, developed and managed Hyperion system 9.3, 7.x applications - Essbase, Shared Services (security matrix)
• Designed, developed and managed Hyperion system 9.3, 7.x reporting front end packages - Web Analysis, Workspace, Financial Reporting
• Provided capacity planning analysis for Essbase, Oracle and SQL Server resource requirements
• Developed SQL extracts, batch scripts and MAXL to automate data, dimension and security implementation processes
• Implemented and migrated new and data technologies and releases
• Developed Proof of Concept application, reporting and automation script models for RFPs
• Client List - Dycom Industries, Office Depot, National Basketball Association, Yale University, ITT, Noven Pharmaceuticals, Long and Foster Real Estate, US Foodservice

Confidential, Greensburg, PA
Database Administrator
July 2005 - October 2006

• Design, develop and manage Essbase 7.1.2 applications utilizing both BSO and ASO methods
• Minimize data element redundancy and maximize compatibility across all Essbase applications
• Provide capacity planning analysis for Essbase, Oracle and SQL Server resource requirements
• Develop SQL extracts and batch scripts to automate data file creation for Essbase dimension builds and data loads
• Transitioned Cognos Impromptu queries to align with Essbase BSO outline formats
• Streamlined Cognos PowerPlay to receive reporting data from an Essbase data source to allow for invoice-level drill-through reporting
• Evaluate recommended new and future data technologies and releases
• Provide 24 x 7 on-call technical support
• Participate in data audits, IT security reviews and Disaster Recovery Tests
• Responsible for SQL Server and Oracle security administration for users, roles, tables and links

Confidential, Pittsburgh, PA
Senior Consultant, Project Manager
December 2004 - July 2005

• Created internal project site with SharePoint Portal and Windows SharePoint Services
• Performed feasibility studies of Oracle Discoverer 10.1.2, Hyperion Intelligence, Hyperion SQR, Hyperion Business Metrics
• Developed several new Essbase 7.1.2 applications - all calc scripts, outlines, load rules
• Designed financial reporting packages with Hyperion Reports and Hyperion Analyzer
• Redesigned and updated current Essbase 6.5 application
• Wrote SQL queries to automate data load and dimension build process

Confidential, Pittsburgh, PA

November 2001 - November 2004

• Develop and maintain applications, utilities and data manipulation/transfer for IT group and world headquarters financial applications
• Provide technical assistance/enhancements to/for all financial applications including: Hyperion Enterprise, Ledgerlink profiles, Autopilots, Enterprise Reports, Essbase, Hyperion Financial Manager (HFM), Hyperion Strategic Finance (HSF), Hyperion Reports and Hyperion Analyzer
• Build and test new software applications and releases/updates
• Trouble-shoot all Hyperion applications, Citrix and security issues
• Assist in the development and execution of new applications/utilities:
• Detailed analysis
• Specific application designs
• Time estimates related to specific tasks
• Application test/implementation plans/schedules
• Provided 24 x 7 on-call technical support
• Developed new/alternative standard charts of accounts, organization structures, logic alternatives, and security restrictions
• Contributed to Sarbanes-Oxley compliance with detailed security analysis and improvements
• Developed Hyperion Enterprise and Essbase applications for Del Monte Foods

Confidential, Pittsburgh, PA
Senior Accountant, Systems Analyst, Hyperion Database Administrator, January 2001- November 2001

• Extracted and loaded all financial data from Oracle GL into Hyperion Enterprise on a monthly basis using Oracle Discoverer 2000
• Maintained Standard Chart of Accounts for both Oracle and Hyperion Enterprise
• Analyzed monthly balance sheet, income statement, cash flow accounts and account reconciliation for each business unit
• Produced ad hoc analysis reports for business units regarding sales, sales volumes, cost of goods sold, direct and indirect expenses
• Researched financial accounting issues regarding GAAP and FASB standards
• Assisted with the performance of internal audit and process reviews
• Automated Oracle/Hyperion account conversion in Access using Visual Basic and SQL programming
• Created templates for all forecasting, planning, and non-Oracle accounts for business units to ensure streamlined reporting in a format that allowed a direct database upload which eliminated manual entry

Confidential, Pittsburgh, PA
Senior Financial Analyst, August 1999-December 2000

• Participate in planning, timing, setting and implementation of monthly forecasts and yearly budget including revenue and line item expenses
• Prepare monthly financial statements and packages with variances for actual versus forecast and budget
• Establish and report on cost drivers per business line and per software development project
• Draw trends in management reports and report on trends and variances in cost behavior
• Monitor and control budgets, costs, and expenditures
• Allocate Overhead expenses to profit-making cost centers
• Audit current corporate accounting/reporting policy for Annual Report and current client allocation process
• Audit client contracts and finance regulations regarding specific fiduciary transactions and movement to reduce associate error

Confidential, Roscoe, PA
Programmer, Developer, Analyst, October 1998 - July 1999

• Responsible for the application design and program development of an Interactive Voice Response system on an NT platform that allowed clients to obtain critical hiring/rejection information via telephone inquiry - VoiceGuide 4.2 (Katalina Technologies)

COMPUTER
Hyperion System 9.3, Hyperion Enterprise, Hyperion Essbase, Hyperion Financial Manager, Hyperion Strategic Finance, Hyperion Reports, Enterprise Reports, Financial Reporting, Web Analysis, Workspace, HAL, Shared Services, AutoPilot, LedgerLink, SQL Server, Oracle 10
Operating systems experience- MS-DOS and Windows 95, 98, 2000 Professional, XP and Windows NT workstation
Proficient with MS Project, MS Office Suite.
Extensive working experience with Visual Basic, VB Script, and manipulation and analysis of Oracle database with OLAP capabilities, Oracle general ledger, Oracle Discoverer 2000 3.0, Oracle Browser.
Proficient with Voice Guide 4.2 Interactive Voice Response software: programming (SQL), installation, and implementation.