Summary:

Significant hands-on Information Technology - Data Warehousing and Business Intelligence experience in the Financial, Consumer Goods, Insurance, Manufacturing, Healthcare, and Transportation industries. Involvement in all phases of the Application Development Life Cycle. Highly developed user interface abilities complement strong analytical, systems design, and hands-on technical skills. Proven ability to effectively plan and adapt to rapidly shifting priorities and deadlines.

SOFTWARE: Hyperion System 11.x, and 9.x: Hyperion Essbase, Hyperion Planning, Hyperion Financial Management (HFM), FDM, EPM, EPMA, Foundation/Shared Services, Hyperion Reporting, Smartview, OBIEE, ODI, Informatica;
Hyperion Enterprise v6.x, Hyperion Essbase v3.5-7.x, Hyperion Planning 3.5-4.x, HFM v 2-3.5, Hyperion Application Link (HAL), Hyperion Analyzer, Brio;
IBM WebSphere, WebMethods, Crystal Reports, PeopleSoft Financials, Informatica, IBM DataStage;
Microsoft: Windows Server 2008, 2003, IIS, MDX, DTS, Reporting Services, Outlook, Excel, Word, Visio, Powerpoint, Project; CMMI, ITIL.
DATABASES: Hyperion Essbase, Oracle, Microsoft SQL Server, Analysis Services, Access, DB2, VSAM
LANGUAGES: MaxL, ESSCMD, MDX, PL/SQL, SQL, PERL, Java, Korn Shell, Visual Basic, VBA, ASP, VBScript, ASPScript, JavaScript, Excel Macros, COBOLII

Education:

Accounting, Computer Science

PROFESSIONAL EXPERIENCE:

Consultant for Confidential, Chicago, IL (07/08 to 07/12)

• Participated, hands-on, in the implementation of Hyperion System 9.3 and 11.1.2 Essbase, Planning, HFM, FDM, DRM, Reporting, Foundation/Shared Services, and EPM. Worked closely with Oracle Product Assurance in bug resolution and product stabilization.
• Participated in gathering detailed user requirements, application design, and development of Hyperion Essbase and Planning applications utilizing the integrated Hyperion DRM (Data Relationship Manager) tool. Worked with End Users and ERP team to define and implement an enterprise view of Chart of Accounts, Hierarchy, Data Governance design and development, and Analytical Dimensions between Oracle/Hyperion applications and ERP and Payroll.
• Worked with Corporate End Users to design, build, and implement HFM application for Corporate Consolidations utilizing integrated Data Warehouse Metadata and FDM for interfaces. Optimized performance of existing data structures where possible
• Worked with Financial End Users and the ERP Development team to design, build, and implement automated nightly processes for Essbase, Planning, and HFM Data Loads and the EPM nightly Metadata updates. . Optimized performance of existing data structures where possible.
• Participated, hands-on, in the development of scripts for the detection of Essbase/Planning database/application failures enabling response to the issue before notification from an end user; for backing up Planning Business Rules; reporting within detailed Drill-Thru; automated Application Re-deployment; reconciling Metadata differences across applications; and retaining database/application statistics. Scripts written using MaxL, Perl, SQL, Excel API, and/or Java API.
• Provided application and technical guidance and mentoring to team members less familiar with Hyperion software.

Environment: Hyperion Essbase, Hyperion Planning, Hyperion Financial Management (HFM), FDM, DRM, Hyperion Reports, Smartview, Foundation/Shared Services, EPM, EPMA, OBIEE, ODI, Informatica, MaxL, Perl, Java, Excel VBA, SQL, Korn Shell, Oracle 10G/Oracle 11G, Server: Windows 2008/2003, Solaris Unix; Websphere, WebMethods.

Consultant for Confidential, Austin, TX (05/08 to 06/08)

• Participated in detailed user requirements and development of an integrated data warehouse metadata environment using Hyperion MDM (Master Data Management) to support Hyperion Planning, HFM, and existing system interfaces. Optimized performance of existing data structures where possible.
• Automated the refresh of user security access thru Hyperion System 9 Shared Services and Hyperion Planning.

Environment: Hyperion Planning, Hyperion Essbase, Hyperion Financial Management (HFM), HAL, MDM, FDM, Hyperion Reporting, Excel VBA, and Oracle/SQL;

Consultant for Confidential, Warrenville, IL (04/07 to 03/08)

• Participated in the development and maintenance of Hyperion Essbase Financial Analysis and Planning applications using Transparent and Replicated Partitioning, Visual Basic APIs, Run-time APIs, and SQL Drill-through to Data Warehouse Oracle transactional databases and SQL Server Datamart for Web Analytics. Development used ESSCMD, MaxL, Microsoft IIS, HTML, AlphaBlox, and Crystal Reports
• Participated in gathering functional/detail user requirements, application design, and development for automating the 2005/2006 historical data conversion and verification/reconciliation process for financial restatements to meet Financial and Management Reporting requirements. Application design and implementation included the development of HFM, FDM, Hyperion Enterprise Applications and Reporting. Environment included a high volume of Oracle transactional data and the use of Oracle / SQL, Excel VBA APIs. Project included establishment of controls to meet Sarbanes Oxley Control Objectives.

Environment: Hyperion Essbase, Hyperion Planning, Hyperion Financial Management, Hyperion Enterprise, FDM, Hyperion Reporting, Excel VBA, and Oracle / SQL;

Consultant for Confidential, Columbus, OH (09/06 to 02/07)

• Participated in gathering functional and detail user requirements for domestic and international businesses and investment holdings; Application design and implementation addressed high transaction volume of the retail industry for Financial and Management Reporting requirements from Hyperion System 9 Financial Management (HFM) and Planning; Custom designed APIs, Rules, and BI, Web Analysis and Reporting. Design included SAP R3, Peoplesoft, JD Edwards, and Hyperion System 9 Security interfaces utilizing HAL and FDM.

Environment: Hyperion System 9 Financial Management, Hyperion Planning, Essbase, HAL, FDM, IBM Websphere, SAP R3, PeopleSoft, JD Edwards, Oracle, MS Windows XP Pro, UNIX, Structured Project Management Methodology.

Consultant for Confidential, Chicago, IL (01/05 to 08/06)

• Participated in project from gathering functional and detail user requirements, application design and development of Hyperion Financial Management (HFM), Planning, and Hyperion Essbase upgrade to version 7.x one of the Subsidiary Divisions. Applications included use of Rules, ASO, MDX, and MAXL.
• Participated in the requirements definition thru implementation/conversion of Hyperion Essbase World Headquarters Corporate Consolidations applications to PeopleSoft Financials.
• Determined functional and detail user requirements, Application/Cube Design and development, configuration, and performance tuning of World Headquarters Corporate Consolidations and Planning applications. Applications used Oracle, SQL Server, and Hyperion Essbase Multi-Dimensional OLAP databases, including the use of Replicated Partitioning, ASO, BSO, Hyperion Application Link, Hyperion Reports, Brio, and Java.
• Provided Financial and Treasury application support of Oracle, SQL Server, .Net applications and server administration. Participated in development of an Excel.VBA based Financial Analysis Data Model.
• Participated in the development of Sarbanes Oxley Control Objectives for financial applications; Presented and passed Sarbanes Oxley Audit of Financial applications performed by internal and external auditors.
• Provided support of Hyperion Essbase, Hyperion Enterprise 5.x/6.x including AutoPilot, Brio, Hyperion Reporting, IBM Websphere, Oracle, and SQL Server applications and server administration to meet Sarbanes Oxley and CMMI requirements.

Environment: Hyperion Essbase OLAP, Hyperion Financial Management, Hyperion Planning, Hyperion Enterprise, HAL, PeopleSoft Global Consolidations, BRIO, SQL Server, Oracle, JAVA, .Net, Datastage ETL, IBM Websphere, MS Windows 2003, 2000, XP Pro, UNIX, CMMI.

Consultant for Confidential, Northfield, IL (09/04 to 11/04)

• Configuration and performance tuning of Hyperion Essbase OLAP application databases. Application databases included the use of Transparent and Replicated Partitioning. Used Tivoli and a VB program to establish synchronized 15 month Archive Backups of Essbase applications to meet Sarbanes Oxley requirements.

Environment: HyperionEssbase OLAP, MS Windows 2000, XP Pro.

Consultant for Confidential, Northbrook, IL (01/01 to 07/04)

• Participated in the development of new Hyperion Essbase version 6.5.1 financial analysis and planning applications using Transparent and Replicated Partitioning, Visual Basic APIs, Run-time APIs, and SQL Drill-through to Oracle transactional databases and SQL Server datamart. Development used ESSCMD, Erwin, Microsoft IIS, HTML, ASP, VBScript, ASPScript, JavaScript, and Crystal Reports.
• Provided primary database and system administration, data modeling, and configuration for Hyperion Essbase application databases, including installation configuration, performance tuning, backup and recovery scripts/processing, server sizing, and on-going DASD requirements. Data analysis, data modeling, logical and physical database design, including the use of Erwin.
• Participated in development of Marketing Survey OLAP applications using SQL Server Analysis Services, MDX, ADOMD and DSO for comparison to an existing Hyperion Essbase application. All the information gathered by the MDX queries were utilized to compare Allstate's performance to their leading industry competitors. Various MDX queries were designed into the OLAP cube creation within Analysis Services, DTS, and other MDX queries were executed on the fly to access the OLAP cubes. Created complex calculation strings within MDX for various statistical calculations for survey results. These calculation strings were both pre-calculated and calculated on the fly queries to determine the statistical significance and gaps of the marketing survey results.
• Upgraded Hyperion Essbase Marketing and Financial applications and databases from versions 5.0.2 to 6.1 to 6.5.1. Provided support to Hyperion Essbase version 5.0.2 Marketing datawarehousing applications which drilled thru a DB2 datamart.
• Performed detailed Business Intelligence Tool and OLAP Server Evaluations and Proof of Concept project, including the review of Hyperion Essbase/Brio, Oracle 9i/Express, Microsoft SQL Server Analysis Services, Reporting Services, Business Objects/Crystal Reports, WebFocus, and Cognos. Participated in presentation to the Technical Architecture Group.
• Performed Brio version 6.6 and 8.x system administration and Brio SQR and ad-hoc query development and troubleshooting.
• Participated in the conversion of a financial application from Access to SQL Server. Created and maintained the system's Transact-SQL, stored procedures, DTS, and security access rights. Developed reporting queries using BRIO SQR and ad-hoc queries.

Environment: Oracle, Hyperion Essbase, SQL Server with Analysis Service, UNIX, PL/SQL, Informatica ETL, MS Windows 2003, 2000, NT, DTS, MDX, T-SQL, Reporting Service, Access, Erwin, DB2Connect, MS Windows 2000, NT, Visual Basic, Comshare Decisionweb, HTML, ASP, VBScript, ASPScript, JAVAScript, Crystal Reports, BRIO, CMMI, ITIL.

Consultant for Confidential, Skokie, IL (09/99 to 12/00)

• Participated in gathering user requirements and functional and detail design definition of a Hyperion Essbase OLAP system for Worldwide Sales and Manufacturing SKU-level Product Profitability applications including Oracle PL/SQL data warehousing and web-based data collection interfaces.
• Provided primary database and system administration, data modeling, and configuration for Oracle, Hyperion Essbase 6.x and Enterprise 5.x application databases, including performance tuning and automated scheduling using AutoPilot. Established backup and recovery. Data modeling and data analysis included the use of Erwin. Databases supported included transactional database and drill-thru datamart configurations
• Implemented Hyperion Essbase and Enterprise server and client software installation and upgrades.
• Developed and modified new and existing financial Hyperion Essbase amd Enterprise applications including security administration.
• Participated in the development of a SAP/ABAP General Ledger data extract from Oracle databases for a Hyperion data load utilizing Hyperion Application Link (HAL) and PL/SQL.
• Provided Y2K verification of Hyperion Essbase and Enterprise systems.

Environment: Oracle PL/SQL; Hyperion Essbase, Enterprise, Hyperion Applications Link (HAL), SAP; MS Windows NT, 98, 97, 95; UNIX, Visual Basic, VBA, Excel, Crystal Reports.

Consultant for Confidential, Racine, WI (03/95 to 09/99)

• Participated in analysis thru implementation of Hyperion Essbase for International Corporate Consolidations, Foreign Currency Conversion, & Budgeting applications.
• Determined user requirements, analyzed, designed, coded, and implemented Back Office & Client HP Open Mail.MS Mail/Outlook electronic mail expense reporting/EDI/EFT (GENTRAN) payment system (SQL Server, stored procedures, triggers).
• Participated in the design thru implementation of a server-based automated invoice entry, EDI/EFT payment, & document tracking system around Minolta's Document Imaging System (SQL Server).
• Determined user requirements, analyzed, designed, coded, and implemented system modification for merger of GEAC (DBS:M) Accounts Payable, General Ledger, Accounts Receivable, Purchasing Corporate and North American Consumer business units in a Multi-Mill, multi-Foreign Currency environment, including Materials Management, Stockroom, Deals, Advertising, Promotions, and Billing system interfaces.
• Participated with users in development of EDI standards.
• Established daily WinNT EDI/EFT (GENTRAN) for inbound/outbound processing of vendor payments, billing, & customer/vendor forecast data.
• Extracted data from PeopleSoft HR/Payroll System (Oracle PL/SQL, UNIX).
• Analysis through implementation of Y2K readiness for the systems.
• Analysis through implementation of conversion from SAP R/3 to GEAC (DBS:M) Accounts Payable & Purchasing systems of a newly acquired business unit to parent company.
• Automated the Control Balancing between Accounts Payable and the various General Ledger Bank Cash accounts for foreign drafts, wire transfers, and normal checks.
• Completed Oracle DBA training program taught by Oracle.

Environment: MS Windows NT, UNIX, SQL Server, Outlook, Visual Basic, VBA, SQL, MFC, Sterling Gentran, Hyperion Essbase, Oracle PL/SQL, Crystal Reports, COBOL II, CICS, VSAM.