SUMMARY:

• Confidential has experience of over 20 years in the IT industry, focusing on Business Intelligence Applications using the latest Datawarehouse/Data Mart Technology specializing in Hyperion System 9 Essbase OLAP Database, Hyperion System 9 Planning, Hyperion System 9 Analytics Integration Service, Hyperion Application Link and Informatica. Confidential also has extensive experience with Insurance, Manufacturing and Telecom Applications.

TECHNICAL SKILLS:

Languages: HTML, Oracle PL/SQL, Visual C++, Visual Basic, Visual J++ (Java), C - Language

Operating Systems: Solaris 2.6/2.7/7.0/8 , HP-UX 12.1, Windows NT 3.1/3.5/3.51/4.0/ 2000 AS/ XPPro, Windows 95/98, RedHat LINUX 7.2, OS MVS/XA, OS/MVS, DOS/VSE, SUNOS4.1, OS/2 3.0, DOS, VM/CMS, TSO/ISPF, GEMCOS, UNIX/SVR4

Ancillary Skills: Informatica V 6.2.1/7.1, Incentive System 3.2, Cognos Finance 5.0, Cognos Impromptu 6, Cognos Powerplay 6, Cognos DecisionStream 6.5, Hyperion Essbase 5.0.1/5.2.0/6.1/6.2/7.1 (OLAP), Hyperion BI+/EAS/AIS System 9, Hyperion Allocation Manager, Oracle 7/8i, Informatica PowerMart 4.7/5.1, Oracle G/L, Oracle SQLPlus, Oracle SQL/Loader Oracle Designer 2000, SQL Navigator, Cognos PowerPlay, Microsoft Visual Studio, Microsoft SQL Server 7.0, GASP 5.0, Huron Objectstar; Applications: Sales Commissions System, Sales Forecasting System, Corporate P and L System, WDS/Compass Contract, Y2K Conversion, Data warehouse and Decision Support Systems, Purchasing System Accounts Payables Systems, Personnel Systems, Payroll Systems, Inventory Control Systems, Accounts Receivables Systems, Product Management Systems (EBOM-MBOM), Medical Malpractice Insurance System

PROFESSIONAL EXPERIENCE:

Confidential

Senior IT Hyperion System 9 Planning Manager

Responsibilities:

• Implemented Hyperion System 9 Suite of tools for the Finance FP&A department. The suite includes Hyperion System 9 Planning, Hyperion System 9 Essbase, Hyperion Analytics Integration Server (EIS), Hyperion Application Server (AAS), Hyperion Applications Link (HAL). Implemented Essbase Cubes using BSO and ASO, Calc Scripts, Data Load Rules and Business Rules. Analyzed and performed tuning of the Essbase Database on a regular basis to meet response time SLA. Designed and implemented the Production Support structure used to provide a 24x5 worldwide support of the system.
• Implemented the system on version 9.0.1.
• Performed upgrade from 9.0.1 to 9.2.0.3.
• Performed upgrade from 9.2.0.3 to 9.3.1.

Confidential

Senior Principal Consultant

Responsibilities:

• Assigned on site at Capcom Corporate Headquarters in Sunnyvale, Ca as Business Intelligence/Essbase consultant.
• Roles and responsibilities as consultant in designing and implementing the Financial Reporting System using Hyperion System 9 Modules and MSSQL running under Windows XP server and Dell Servers:
• Performed Design, Testing and Implementation of ETL processes used to load the Corporate Data warehouse and Staging star schema database using MSSQL DTS with sources from SQL Server, and Excel spreadsheets.
• Performed Design, Testing and Implementation of Essbase cubes using Essbase 6.5/Hyperion System 9.
• Performed Design, Testing and Implementation of automated Essbase cube build using MaXL.
• Performed Design, Testing and Implementation of Essbase Calc Scripts to implement Business Rules on the cubes.
• Performed Design and Review of Migration Plan for current Essbase 6.5 cubes to Hyperion System 9.
• Performed Design and Testing of Sellthru Hyperion Interactive Reports.
• Performed Design and Testing of Sellthru Hyperion Analyzer Reports.

Confidential

Senior Principal Consultant

Responsibilities:

• Assigned on site at Confidential - Confidential corporate headquarters in Palo Alto, Ca as Business Intelligence/Essbase consultant.
• Roles and responsibilities as consultant in designing and implementing the Revenue and Forecasting Tool for Foreign Exchange System using Essbase 7.1.1 and MSSQL running under Windows XP server and HP Servers:
• Performed Design, Testing and Implementation of ETL processes used to load the Staging star schema database using MSSQL DTS with sources from Oracle Databases, SQL Server, and Excel spreadsheets.
• Performed Design, Testing and Implementation of Essbase cubes using Essbase 7.1.1.
• Performed Design, Testing and Implementation of automated Essbase cube build using MaXL.
• Performed Design, Testing and Implementation of Essbase Calc Scripts to implement Business Rules on the cubes.

Confidential, Orlando, Fl

CRM Migration Analyst/Informatica Consultant

Responsibilities:

• Assigned on site at Confidential Inc, a leader in the Timeshare industry, as Data Migration Analyst and Informatica Developer of Epiphany Campaign Management System.
• Roles and responsibilities as consultant designing and implementing the Data Migration Strategy for Epiphany Campaign Management System using Oracle 9i running under Windows XP server and Dell Poweredge Servers:
• Performed Design, Testing and Implementation of ETL processes used to load the Epiphany Campaign Management database using Informatica Powercenter 6.2.1 with sources from Oracle Databases, SQL Server, DB2/UDB and Mainframe Files.

Confidential, Redmond, WA

Business Intelligence Consultant/Informatica Consultant

Responsibilities:

• Assigned on site at Confidential Inc. as Business Intelligence Consultant working with Sales and Marketing System. The system provides the Sales Force with accurate sales information using the Worldwide Web.
• Roles and responsibilities as consultant in designing and implementing Sales and Marketing System using Brio Systems running under Windows NT 4.0/2000 and Dell Poweredge Servers:
• Performed Design, Testing and Implementation of Data warehouse Star Schemas using CA Erwin Data Modeler and CA Modelmart.
• Performed Design, Testing and Implementation of ETL process used to load the Sales and Marketing Data warehouse using Informatica Powercenter 6.0 with sources from Oracle Database, SQL Server and Mainframe Files.

Confidential, Orlando, Fl

Business Intelligence Consultant/Informatica Consultant

Responsibilities:

• Assigned on site at Confidential Inc, a leader in the Timeshare industry, as Business Intelligence Consultant working with Sales and Marketing System. The system provides the Sales Force with accurate sales information using the Worldwide Web.
• Roles and responsibilities as consultant in designing and implementing Sales and Marketing System using Brio Systems running under Windows NT 4.0/2000 and Dell Poweredge Servers:
• Performed Design, Testing and Implementation of Data warehouse Star Schemas using CA Erwin Data Modeler and CA Modelmart.
• Performed Design, Testing and Implementation of ETL process used to load the Sales and Marketing Data warehouse using Informatica Powercenter 6.0 with sources from Oracle Database, SQL Server, DB2/UDB and Mainframe Files.

Confidential, Orlando, Fl

BI Consultant/Informatica Consultant

Responsibilities:

• Assigned on site at Confidential Inc as Business Intelligence Consultant working with Sales Compensation System. The system provided the Sales Force with accurate compensation information using the Worldwide Web.
• Roles and responsibilities as consultant in designing and implementing Sales Compensation System using Incentive System running under Win NT 4.0/2000 & Dell Poweredge Servers:
• Performed Design, Testing and Implementation of ETL process used to load the Incentive Database using Informatica 5.1 with sources from Text file, Excel Files, Access Database, SQL Server and Mainframe Files.

Confidential

BI Consultant/Hyperion Essbase Consultant

Responsibilities:

• Assigned on site at Confidential Inc as Business Intelligence Consultant working with Sales Forecasting System. The system reduced the Sales Forecasting Cycle from 14 days to 7 days and provided more accurate and timely Sales Forecast information compared with their previous non-integrated system.
• Roles and responsibilities as team member implementing the Sales Forecasting System using Essbase 6.1/6.2 running under Windows NT 2000 and Dell PowerEdge Servers:
• Performed Design, Testing and Implementation of Sales Forecasting Data Mart using Essbase Application Manager, Essbase Load Rules, Essbase Calc Scripts, Outline maintenance using Esscmd/Maxl batch process and manual online update, Database Partitioning, Database Tuning, Database Backup and Recovery using export and import utility, Report Generation using MS Excel VBA API.
• Performed Design, Testing and Implementation of Sales Forecasting Data Mart lights out automation process.
• Performed Design, Testing and Implementation of Sales Forecasting Data Mart ERP ETL process to populate the staging data warehouse.

Confidential, Scotts Valley, CA

BI Consultant/Hyperion Essbase Consultant

Responsibilities:

• Assigned on site at Seagate Technology as Business Intelligence Consultant working with various FISS projects. The system provided the users with more accurate and timely GL and Financial information at the click of a button.
• Roles and responsibilities supporting the Financial Integration Systems and Support using Essbase 5.0.2/6.1 running under Windows NT 4.0/2000 and Compaq Proliant Servers:
• Performed Design, Testing and Implementation of Revenue and COGS Reporting Cube using Essbase Application Manager, Essbase Load Rules, Essbase Calc Scripts, Outline maintenance using Esscmd/Maxl batch process and manual online update, Database Partitioning, Database Tuning, Database Backup and Recovery using export and import utility, Report Generation using MS Excel VBA API.
• Performed Design, Testing and Implementation of World Wide General Ledger Reporting Cube using Essbase Application Manager, Essbase Load Rules, Essbase Calc Scripts, Outline maintenance using Esscmd/Maxl batch process and manual online update, Database Partitioning, Database Tuning, Database Backup and Recovery using export and import utility, Report Generation using MS Excel VBA API.
• Performed Design, Testing and Implementation of Partitioned WWGL Reporting Cube using Essbase Application Manager, Essbase Load Rules, Essbase Calc Scripts, Outline maintenance using Esscmd/Maxl batch process and manual online update, Database Partitioning, Database Tuning, Database Backup and Recovery using export and import utility, Report Generation using MS Excel VBA API.