Andreas Andreas

Andreas Andreas

Summary

IT Professional with 9 years of experience, expertise in Hyperion technical, Oracle database administration, and Microsoft SQL Server database administration. Significant experience in troubleshooting technical problems in database, Windows O/S and UNIX O/S. Excellent interpersonal, organizational, presentation and writing skills.

Work History

Work History
Feb 2008 - Present

Hyperion Consultant

PT Emerio Indonesia

PT Cipta TPI, Jakarta (http://www.tpi.tv), November 18-19, 2008Installation & configuration of Hyperion System 9 9.3.1

oInstalled and configured Oracle WebLogic 9 and Oracle Database 10gR2 to be used for Hyperion 9.3.1 implementation.

oInstalled and configured Hyperion 9.3.1 Shared Services, Planning and BIPlus.

oConfigured SSL on WebLogic 9.2 for Planning and Workspace.

oCreated backup procedure.

PT Bank Danamon Indonesia, Jakarta (http://www.danamon.co.id), April 2008 – present Hyperion Application Support

oSupported day to day operation of Hyperion application for 9 cubes (5 cubes for Planning and 4 cubes for Essbase).

oConfigured SSL on WebLogic 8.1 for Shared Services and Planning.

oCopied applications from Development environment to UAT, Production and DRC (4 Planning applications and 2 Essbase ASO applications).

oDeveloped Disaster Recovery plan to shorten RTO (Recovery Time Objective) for DR switch over/switch back by 90.3 % (from 6 hours to 35 minutes)

oOrganized the implementation of Hyperion Planning Forecast 2008 and Budget 2009 in Production and DRC machine.

oOrganized the backup procedure.

PT Coca Cola Bottling Indonesia (http://www.coca-colabottling.co.id/), Jakarta, April 28 - May 9 andJuly 3 – 12 & 22, 2008 Hyperion 6.5 to 9.3.1 Migration Project

oInstalled and configured all Hyperion components, 2 development servers and 3 production servers, including Windows 64-bit machines for Essbase in PT Coca Cola Bottling Indonesia.

oInstalled IBM WebSphere 6.1 as J2EE server for Shared Services, Workspace and WebAnalysis components in PT Coca Cola Bottling Indonesia

oPerformed migration, checked and validated 50+ cubes migrated from Essbase 6.5 to Essbase 9.3.1.2 64-bit in PT Coca Cola Bottling Indonesia.

oPerformed migration, checked and validated 500+ Analyzer 6.5 reports migrated to Hyperion WebAnalysis 9.3.1 in PT Coca Cola Bottling Indonesia

Nomura International Hong Kong Ltd. (http://www.nomura.com), Aug 4-5, Aug 21-27, 2008

oResearched on SSH solution needed for doing the backup process.

oCreated and tested Backup scripts to backup all Hyperion components.

Aug 1999 - Feb 2008

IS Technical Analyst

PT HM Sampoerna, Tbk

oAdministered 30 different instances of Oracle, ranging from Oracle 8-10g.

oAdministered Hyperion Financial Management, Hyperion Planning and Hyperion BIPlus system.

oInstalled, configured and administered all Hyperion products in Sampoerna (Hyperion Financial Management, Hyperion Planning, Hyperion Essbase and Hyperion BIPlus) using BEA WebLogic Server 8.1 SP4.

oAdministered Microsoft SQL Server 2000 & 2005 database.

oAdministered and troubleshoot problems on Worldox document management system for Legal department, Marketing division and Public Relations department.

oInstalled Oracle 9.2.0.1 and upgraded to 9.2.0.4 on HP-UX 11.11.

oAdministered Microsoft SQL Server 2000 & 2005 database.

oAdministered and troubleshoot problems on Worldox document management system for Legal department, Marketing division, Public Relations department and Product Development division.

oOversaw the need to use the partitioning option on Oracle 9.2 on Panamas (Sampoerna’s sales division) In-house applications.

oInvestigated and communicated with Hyperion to identify the bug on Hyperion products related with active directory users tree moving.

oInvolved on the following projects

    • Remedy ARS 6.0 implementation
    • CMMS Upgrade
    • Transport Order Management
    • Panamas Sales Division In-house applications
    • Manufaturing Division In-house applications
    • Consolidation project using Hyperion Financial Management
    • Budgeting project using Hyperion Planning
    • Remedy ARS 5.5 implementation
    • Clove Receiving Information System
    • Tobacco Traceability Information System
    • Remedy – Altiris connectivity
    • Panamas Consolidation Server
    • Computerized Maintenance Management System (CMMS) implementation using Datastream MP2.
    • Laboratory Information Management System (LIMS) using Agilent LIMS
    • Manufaturing Division In-house applications

oIdentified and reported to BMC to resolve ARS 5.5 bug connecting to MSAD.

oInstallation of Agilent LIMS on HP-UX 10.20.

oInstallation of Oracle 7.3.2 on HP-UX 10.20.

Education

Education
1994 - 2000

Bachelor Degree

Sekolah Tinggi Teknik Surabaya

Skills

Skills

ITIL Foundation

Training attended:   ITIL ITSM Essentials Course, Kata Systems, Singapore, June 6 – 8, 2005

Windows System Administration

UNIX/Linux System Administration

Training attended:   HP-UX System and Network Administration I, HP Education Indonesia, Jakarta, January 22 – 26, 2001 HP-UX System and Network Administration II, HP Education Indonesia, Jakarta, May 28 - June 01, 2001

MS SQL Server Database Administration

Oracle Database Administration

Training attended: Oracle Database Administration, Inixindo, Surabaya, 2000 Oracle8i SQL Statement Tuning , Oracle Education, Jakarta, November 7-9, 2001 Oracle9i Database: Fundamentals I, Oracle Education, Jakarta, July 18 – 22, 2005

Hyperion Installation & Configuration

Training attended: BEA WebLogic Server 8.1: System Administration, BEA Education, Singapore, October 16-20, 2006 Hyperion Financial Management: Create & Manage Applications, Hyperion Education, Singapore, 2006 Hyperion Planning & Budgeting: Create & Manage Applications, Hyperion Education, Singapore, 2006

Certifications

Certifications
Jun 2005 - Present

ITIL Foundation

Exin